Bank Reconciliation 101: From Statement to Trial Balance

A bank reconciliation matches your accounting records against your bank statement, line by line. It is the most important monthly hygiene check in any business. Done weekly, it takes 15 minutes; left for quarter-end, it takes a day.

What the reconciliation proves

A clean bank rec proves three things: every payment in your books actually left the bank, every receipt in your books actually hit the bank, and there are no unrecorded transactions on either side. Together these are the foundation of trustworthy reports.

If your bank balance per books does not match the statement, something is wrong. The reconciliation document is where you list and explain every reconciling item, usually a handful of timing differences and the occasional error needing correction.

The standard reconciliation format

Start with: bank statement balance at month end. Add: receipts in books not yet on the statement (deposits in transit). Less: payments in books not yet on the statement (uncleared cheques, pending wires). The result should equal the books balance at month end.

Reconciling items beyond timing differences are errors, find each one. Common errors: a payment posted twice, an FX-translated receipt at the wrong rate, a bank fee not yet booked, or a customer payment booked to the wrong invoice.

Common reconciling items in the UAE

Bank fees and FX charges that the bank deducts automatically and you have not yet booked: post them as expense, then mark cleared. Standing orders and direct debits the bank processed but you missed: post them, mark cleared. Returned cheques (NSF returns): reverse the original receipt, then book the return.

Foreign currency receipts: the bank credits at one FX rate; your books may have used another. Adjust either by reposting at the bank rate or by booking a small FX gain/loss to clear the difference. Be consistent, pick one method and stick to it.

Frequency and automation

Reconcile weekly if you process more than 50 transactions per week, monthly if smaller. Daily is excessive for most SMEs but useful for retail with daily POS settlements. The longer between reconciliations, the harder it is to find errors.

Live bank feeds (most UAE banks now offer them) automate 80-90% of the matching. Acowntant pulls feeds from 12 UAE banks and auto-matches against your invoices and bills. The rec workflow becomes review-and-confirm, not manual matching.

This guide is general information, not professional advice. For situations that involve specific facts, talk to your accountant, or hire one of ours from the marketplace.