Bank Reconciliation: How to Match Your Bank Statement to Your Books
Your banking app shows one number; your books show another. Usually the gap is not an error, but it is still an open question: normal timing, a fee nobody recorded, or money that left the account with no matching document?
Bank reconciliation turns that question into a written answer. Done monthly on clean data it takes half an hour; left for a few months it becomes a week of digging. This guide covers why the numbers differ, the steps, the form itself, and the mistakes that keep the figures from closing.
Why the bank balance differs from your books
The bank records a transaction when it settles; your books record it when the document is issued. Most differences come from that lag; the rest are unrecorded fees and entry errors.
| Cause | Where it starts | Treatment |
|---|---|---|
| Outstanding cheques not yet cashed | Bank has not cleared them | Stay in the books, deducted from the bank balance on the form |
| Deposits in transit | Late deposit or a non-working day | Added to the bank balance on the form |
| Bank charges and transfer fees | Not recorded in the books | Post as an expense on the statement date |
| Card settlements paid net of fees | Gap between sales and payout | Post the processing fee as an expense and clear the difference |
| Customer transfer you were not told about | Not recorded in the books | Apply against the customer balance on the deposit date |
| Automatic instalment or subscription debit | Not recorded in the books | Post as an expense or liability payment |
| Entry error: duplicate amount or transposed digits | Error in the books | Correcting entry referencing the transaction number |
| Bank error | Rare, but it happens | Report it and keep it as an open item until settled |
What you need before you start
- An official statement covering the full period, not a screenshot of the app.
- An opening balance matching your previous reconciliation, since each one builds on the last.
- The bank account ledger from your books or system for the same period.
- A list of outstanding cheques with their dates.
- Documents for large movements: contracts, supplier invoices, transfer advices.
The steps
- Confirm the opening balance agrees on both sides. If not, the problem sits in an earlier period; fix that first.
- Sort both records by date and amount, then tick off every line that matches exactly on both sides.
- Isolate statement lines with no match in your books, such as fees and collections, and record them as they are.
- Isolate book entries with no match on the statement: uncashed cheques and deposits in transit belong on the form, not in a new entry.
- Hunt for errors: duplicated amounts, entries booked in the wrong month, transposed digits. A difference divisible by nine usually means digits were transposed.
- Fill in the reconciliation form and bring both adjusted balances to the same number.
- Document it: file the statement, the form and the correcting entries, and note who reconciled and when.
The reconciliation form
| Line | Effect |
|---|---|
| Closing balance per bank statement | Starting point |
| Add: deposits in transit | + |
| Less: outstanding cheques | − |
| Adjusted bank balance | First figure |
| Closing balance per books | Starting point |
| Less: fees, commissions and direct debits | − |
| Add: unrecorded collections and transfers | + |
| Adjust: entry errors | + or − |
| Adjusted book balance | Second figure |
The reconciliation succeeds when both figures are equal. Any remaining gap, however small, is a transaction you have not found yet, not a rounding item; a few riyals waved through every month produce a balance you cannot trust a year later.
Card and point-of-sale settlements
This is where most retail and restaurant owners get stuck. Card sales do not land the same day, arrive net of processing fees, and several days may be bundled into one payout. Post them straight to the bank account and the reconciliation will never close.
Use a clearing account named cash in transit. Debit it with the day's card sales, then clear it when the payout arrives, posting the fee as an expense. Its remaining balance should equal sales not yet settled, a good check that the cycle is intact.
How often should you reconcile?
Monthly at minimum, inside your period close, and weekly if the account is busy or you deal in cheques. A late reconciliation costs several times a regular one, because tracing a four-month-old movement means chasing a document everyone has forgotten. If you are VAT registered, reconciling before you file also surfaces invoices never recorded, or recorded twice.
Retention periods for books and supporting documents are set by regulation and published by the Zakat, Tax and Customs Authority at zatca.gov.sa, the only official reference. Details can change, so check it before deciding.
Common mistakes
- Relying on the app balance instead of the official statement for the period.
- Forcing agreement with a vague adjusting entry, which hides the problem instead of solving it.
- Posting card sales directly to the bank account with no clearing account.
- Leaving outstanding cheques listed for years when some will never be presented.
- Mixing personal and business accounts, the fastest route to an impossible reconciliation.
- Letting the same person enter transactions, release payments and reconcile, with nobody reviewing the result.
In short: reconciliation is the monthly check proving the cash you hold matches what your books claim. Start from a matching opening balance, separate timing differences from unrecorded items, use a clearing account for card settlements, and never close on a difference, however small.