Bank Reconciliation — How to Do It Right (2026)

Bank reconciliation catches errors before they become problems. It is the single most important monthly bookkeeping task for any UAE business — and the one most often done poorly.

A bank reconciliation compares your accounting records to your bank statement, identifies differences, and resolves them. Done consistently, it prevents fraud, ensures accurate financial reporting, and makes audit season painless. Done badly — or not at all — it creates cascading errors that take months to untangle.

This guide covers the complete reconciliation process, multi-currency considerations specific to the UAE, and the automation tools that modern bookkeepers use. For professional bookkeeping support, browse the FindCPA bookkeeping directory.

What Is Bank Reconciliation and Why Does It Matter?

Bank reconciliation is the process of matching your company's cash book (accounting records) to your bank statement for the same period. It identifies timing differences, errors, and unauthorized transactions. In the UAE, it is essential for VAT compliance, corporate tax accuracy, audit readiness, and fraud prevention — making it a non-negotiable monthly task.

The concept is simple. Your accounting system records cash transactions when you enter them. Your bank records them when they clear. These two records will almost never match on any given date because of timing differences, bank charges, and errors.

Bank reconciliation resolves those differences into two categories:

1. Timing differences — legitimate transactions recorded in one system but not yet in the other (e.g., checks issued but not yet cashed)
2. Errors or omissions — mistakes that need correction in either your books or with the bank

Without monthly reconciliation, your cash balance is unreliable. And in the UAE, an unreliable cash balance means:

• VAT errors — you may report transactions in the wrong tax period
• Corporate tax miscalculations — cash-basis adjustments become impossible to verify
• Audit qualifications — auditors will flag unreconciled bank accounts
• Fraud exposure — unauthorized transactions go undetected

How Do You Perform a Bank Reconciliation Step by Step?

Start with the bank statement balance, add deposits in transit, subtract outstanding checks, and adjust for bank errors to arrive at the adjusted bank balance. Simultaneously, start with the book balance, add bank credits not yet recorded, subtract bank charges, and adjust for book errors. When both adjusted balances match, the reconciliation is complete.

Here is the full process:

Step 1: Gather your documents

• Bank statement for the period (month-end)
• Cash book / general ledger bank account printout for the same period
• Prior month's reconciliation (to carry forward outstanding items)

Step 2: Compare and match transactions Go through each transaction on the bank statement and match it to the corresponding entry in your cash book. Mark matched items in both records. Modern accounting software automates this with bank feed imports.

Step 3: Identify unmatched items

These fall into specific categories:

Step 4: Prepare the reconciliation statement

The standard format:

Bank Statement Balance (per bank)          XXX
Add: Deposits in transit                 + XXX
Less: Outstanding checks                 - XXX
Add/Less: Bank errors                    ± XXX
                                         -----
Adjusted Bank Balance                      XXX

Book Balance (per cash book)               XXX
Add: Bank credits not recorded           + XXX
Less: Bank charges not recorded          - XXX
Add/Less: Book errors                    ± XXX
                                         -----
Adjusted Book Balance                      XXX

Adjusted Bank Balance = Adjusted Book Balance ✓

Step 5: Record adjusting entries Post journal entries for all items that need to be recorded in your books — bank charges, interest, direct debits, and error corrections.

Step 6: Review and sign off A second person should review the reconciliation. Date and sign it. File it for audit purposes.

How Often Should You Reconcile Bank Accounts?

Every UAE business should reconcile bank accounts monthly at minimum. High-volume businesses — those processing more than 500 transactions per month — should reconcile weekly. Companies with online payment gateways or POS systems should reconcile daily. The FTA expects accurate periodic records, and auditors test reconciliation frequency as a key internal control.

The audit angle: Auditors test bank reconciliations as part of their assessment of internal controls. They will select 2–4 months at random and verify that reconciliations were prepared timely, reviewed by a second person, and that outstanding items were resolved in subsequent months.

Companies that only reconcile at year-end face two problems: a massive reconciliation effort in January, and an auditor who will flag weak controls in the management letter.

What Are the Most Common Bank Reconciliation Errors?

The most common errors include stale outstanding checks older than six months, unrecorded bank charges, duplicate transaction entries, transposition errors in amounts, and foreign exchange differences on multi-currency accounts. In the UAE, payment gateway settlement timing and VAT refund credits are frequent sources of discrepancies.

Stale checks: A check issued more than six months ago that has not been cashed. UAE banking convention treats checks as stale after 6 months. These should be reversed in your books and the amount re-accrued as a liability until you issue a replacement or determine the obligation has expired.

Duplicate entries: Common when bank feeds and manual entries coexist. The same payment appears twice — once from the manual entry and once from the automatic bank feed import.

Transposition errors: Recording AED 5,430 as AED 5,340. These are identifiable because the difference is always divisible by 9.

Payment gateway timing: If you use Stripe, Tap, or Network in the UAE, settlement timing creates reconciliation complexity. A customer pays on Monday, but the funds reach your bank on Wednesday. The payment gateway deducts its fee before settlement. You need a clearing account to handle this properly.

VAT refund credits: FTA VAT refunds appear as bank credits that may not match your expected amount due to partial approvals or offset against other tax obligations.

How Do You Reconcile Multi-Currency Bank Accounts?

For multi-currency accounts common in UAE businesses, reconcile each currency separately at the bank statement rate. Book the foreign exchange gain or loss as a separate journal entry. At month-end, revalue all foreign currency balances to the closing rate per IAS 21, and record the unrealized exchange difference in profit or loss.

Many UAE companies maintain accounts in AED, USD, EUR, and GBP. The UAE dirham is pegged to the US dollar at 3.6725, which simplifies USD reconciliation. Other currencies fluctuate.

Step-by-step for multi-currency:

1. Obtain the bank statement in the original currency
2. Match transactions in the original currency (not the AED equivalent)
3. Record exchange differences on each settled transaction
4. At month-end, revalue the outstanding foreign currency balance to the closing rate
5. Book the unrealized gain or loss to a foreign exchange account in P&L

Common mistake: Converting foreign currency transactions at a single average rate instead of the actual rate on the transaction date. IAS 21 requires the spot rate (or a reasonable approximation) on the date of each transaction.

What Tools Automate Bank Reconciliation?

Modern accounting software — including Zoho Books, QuickBooks, Xero, and Wafeq — automates bank reconciliation through direct bank feeds, AI-powered transaction matching, and rule-based categorization. UAE-specific platforms like Wafeq and ZohoBooks Middle East offer direct integration with major UAE banks and FTA-compliant VAT coding.

What automation handles well:

• Matching bank transactions to invoices and bills
• Categorizing recurring transactions (rent, utilities, subscriptions)
• Flagging duplicates and unusual amounts
• Generating reconciliation reports

What still requires human judgment:

• Investigating unmatched items
• Determining the correct treatment of complex transactions
• Multi-currency revaluation decisions
• Approving write-offs or adjustments

Bank feed setup in the UAE: Most major UAE banks (Emirates NBD, ADCB, FAB, Mashreq, RAKBANK) support OFX or CSV statement exports. Direct API feeds are available through select accounting platforms. Some banks charge AED 50–200/month for automated feed access.

What Do Auditors Look for in Bank Reconciliations?

Auditors examine bank reconciliations for completeness, timeliness, review evidence, and resolution of outstanding items. They send independent bank confirmations, test a sample of reconciling items, and check that old outstanding items were resolved. A poorly maintained reconciliation is one of the most common audit findings in UAE companies.

The audit procedures for cash and bank:

1. Bank confirmation — the auditor sends a standardized confirmation letter directly to your bank, verifying the balance, facilities, and any charges on the account
2. Reconciliation testing — the auditor selects 2–4 month-end reconciliations and traces every reconciling item to supporting documentation
3. Cut-off testing — verifying that transactions around year-end are recorded in the correct period
4. Outstanding items aging — reviewing items outstanding for more than 30 days and investigating items older than 90 days
5. Subsequent clearance — checking that deposits in transit and outstanding checks cleared in January

Red flags auditors watch for:

• Reconciliations prepared but not reviewed by a second person
• Same items appearing as outstanding month after month
• Large round-number adjustments without documentation
• Reconciliations prepared weeks after month-end
• Cash book balance adjusted to match bank statement (reverse engineering)

How Do You Handle Petty Cash in the Reconciliation?

Petty cash reconciliation is a separate process from bank reconciliation but equally important. Count the physical cash, add up all petty cash vouchers for the period, and confirm that the total (cash on hand plus vouchers) equals the petty cash float. Any shortage or surplus must be investigated and recorded before closing the period.

Petty cash is still widely used in UAE businesses for small expenses — office supplies, courier charges, parking, and minor maintenance.

Reconciliation process:

1. Count all physical cash in the petty cash box
2. Add up all vouchers issued since the last replenishment
3. Cash on hand + vouchers should equal the authorized float
4. Investigate and record any difference
5. Prepare a replenishment request for the total of vouchers
6. The replenishment check or transfer restores the float to its authorized amount

UAE-specific considerations:

• Petty cash expenses must have proper VAT tax invoices for input VAT recovery
• Expenses above AED 500 should generally not go through petty cash
• Keep the float reasonable — AED 2,000–5,000 for most small businesses
• Auditors will count petty cash during fieldwork; discrepancies cause findings

Need bookkeeping help? Find a Bookkeeper in Dubai →

Frequently Asked Questions

Can I skip bank reconciliation if I use accounting software with bank feeds?

No. Automatic bank feeds import transactions, but they do not reconcile them. You still need to match each imported transaction to the correct invoice, bill, or journal entry. Unmatched items require investigation. The software assists the process but does not replace the human review and judgment required for proper reconciliation.

What should I do with checks outstanding for more than six months?

Reverse the check entry by debiting the bank account and crediting accounts payable (or the original expense account). Investigate why the check was not cashed — the payee may need a replacement, or the obligation may have been settled through other means. UAE banks typically will not honor checks older than six months.

How do I reconcile a bank account that has never been reconciled?

Start with the most recent bank statement and work backward. Match every transaction on the current statement to your books. Then move to the prior month. Continue until you reach a point where the balances match or you have identified all historical differences. This can take days for neglected accounts — a professional bookkeeper can accelerate the process significantly.

Do bank reconciliations need to be kept for a specific period?

Yes. UAE commercial law requires businesses to retain financial records for a minimum of 5 years. The VAT law requires retention for 5 years after the end of the relevant tax period (up to 15 years for real estate). Corporate tax records must be kept for 7 years. Keep all bank reconciliations, statements, and supporting documentation for at least 7 years to cover all requirements.

Keep Reading

• General Ledger Setup for UAE Businesses
• Cash Flow Management for SMEs
• Petty Cash Management Guide
• Browse Bookkeepers on FindCPA