Reconcile account balances

Reconcile March account balances so the ledger matches the bank by Friday afternoon. Compare the ledger on Sheet Ledger_Mar with the bank statement on Sheet Bank_Mar, list out any uncleared items, tag each difference as timing, error, or unknown, and produce a short reconciled worksheet named Reconciliation_Mar with supporting lines and a sign-off cell for the finance lead.

Before I hand this to the controller, make the reconciliation easy to validate. Put unmatched items at the top with suggested classifications, highlight amounts over 1,000 dollars, attach a one-line suggested action for each unknown item, and add a count of outstanding uncleared cheques so the controller can approve quickly.

I matched payroll and supplier payments but the ledger still differs from the bank by $2,350. Payroll insists all runs were uploaded; the treasurer hints at an unrecorded fee. I can't find a fee line in the feeds and the bank copy has limited notes. What's the most likely diagnosis and the next focused tests to resolve the $2,350 discrepancy before Friday close?

Month after month I lose time chasing small reconciling items that later prove to be bank fees, currency gains, or timing differences. I want one habit that stops the endless detective work and prevents surprises—should I log a short fee-and-adjustment control, insist bank memos be pulled with each statement, or maintain a rolling list of recurring small items tied to GL codes? Recommend the best single change and how to implement it quickly.