Order-to-Cash & Reconciliation

Bank Reconciliation for Finance Teams: Multi-Currency, Post-Dated Cheques and Automation

A bank reconciliation is simple on one account. Across six banks and a drawer of post-dated cheques, the work takes a week. This guide gives the format and the fix.

Sanya Shah

Co-founder at Predflow

Bank reconciliation statement with outstanding cheques and deposits in transit

A bank reconciliation is simple on one account. Across six banks and a drawer of post-dated cheques, the work takes a week. This guide gives the format and the fix.


Bank reconciliation statement with outstanding cheques and deposits in transit

A bank reconciliation compares your bank statement with your cash book and explains every difference, so the balance in your books matches the money in the bank.

On one account in one currency, the work takes an hour. Across six banks, AED, USD and EUR accounts, card settlements, payment gateway payouts and a drawer of post-dated cheques, the work takes a week of month-end. This guide covers the bank reconciliation statement format, a worked example, the complications UAE finance teams face, how to manage post-dated cheques (PDCs), matching rules, and the options for automating the work.

What Does a Bank Reconciliation Statement Look Like?

What is a bank reconciliation? A bank reconciliation compares your bank statement with your cash book at a date and explains every difference. Items in transit wait on the bank side, while bank charges, interest and returned cheques need journal entries. When both adjusted balances agree, the cash figure in your books is correct.

Line

Amount (AED)

Balance as per bank statement at month end

A

Add: deposits in transit (recorded in books, not yet in bank)

+ B

Less: outstanding cheques (issued, not yet presented)

- C

Add or less: bank errors

+/- D

Adjusted bank balance

= A + B - C +/- D

Balance as per cash book at month end

E

Add: interest or receipts credited by bank, not in books

+ F

Less: bank charges, debits not in books

- G

Add or less: book errors

+/- H

Adjusted book balance

= E + F - G +/- H

Difference

Must be zero

Both sides adjust to the same true balance. Items on the bank side wait for the bank to catch up. Items on the book side need journal entries.

Worked Example

Company: Sample Trading LLC. Account: current account in AED. Date: 31 October 2026.

Item

Amount (AED)

Balance as per bank statement

412,800

Add: deposit in transit, customer cheque deposited 31 Oct

38,500

Less: outstanding cheques (CHQ 004512, 004517, 004520)

-61,200

Adjusted bank balance

390,100

Balance as per cash book

391,315

Less: bank charges for October, not yet recorded

-315

Less: customer cheque returned unpaid, not yet recorded

-12,000

Add: transfer received from customer, not yet recorded

11,100

Adjusted book balance

390,100

Difference

0

The book-side items need journal entries. Record the bank charges and the customer transfer, and reverse the returned cheque to reopen the customer receivable. The bank-side items need follow-up only if they stay outstanding next month.

Why Is Bank Reconciliation Harder for UAE Finance Teams?

The format stays the same. Volume and variety make the work hard.

  • Multiple banks. Mid-size UAE companies often hold accounts with four to eight banks, each with its own statement format and export options.

  • Multiple currencies. AED, USD and EUR accounts, with FX conversions at different rates in the bank and in the books.

  • Post-dated cheques. Customers pay rent and instalments with PDCs, which sit in a register until the due date.

  • Card settlements. Card acquirers pay daily batches net of merchant fees. One bank credit covers hundreds of transactions.

  • Payment gateway payouts. Online payment providers settle on their own cycles, net of fees and refunds.

  • Marketplace payouts. Noon and Amazon.ae credits need a separate reconciliation. Read our Noon and Amazon.ae settlement reconciliation guide.

  • Bulk payments. One salary or supplier batch leaves the bank as one debit but sits in the books as dozens of entries.


Bank Reconciliation Statement, Worked Example

The infographic above shows the same figures as the worked example table.

How Do Post-Dated Cheques Affect Bank Reconciliation?

PDCs are common in UAE real estate and contracting. A clean PDC process keeps them out of the reconciliation until they become real.

Keep a PDC Register

Record every PDC received and issued: cheque number, bank, drawer, amount, due date, related invoice or contract, and status. Do not post a PDC to the bank account in the books before the due date. A PDC is a promise, not cash.

Deposit Dates

Deposit received PDCs on the due date, or as close as the bank allows. Track deposit date and expected clearing date in the register. The deposit becomes a deposit in transit until the bank credits the amount.

Bounced Cheques

When a PDC returns unpaid, reverse the receipt to reopen the customer balance, then record the bank's return charges. Since January 2022, amendments to the UAE Commercial Transactions Law have treated most bounced cheques as a civil matter rather than a criminal one, except in cases of bad faith. The bank must pay out any partial balance available, and the holder is entitled to take the cheque to court as an executory instrument for recovery. Get legal advice on specific cases.

Monthly PDC Checks

At month end, reconcile the PDC register itself: cheques due this month should appear as deposits, in transit or bounced. Cheques due next month should remain in the register only.

Matching Rules: Exact, Fuzzy and One-to-Many

Rule

Example

When to use

Exact match

Bank debit AED 21,000 with reference "CHQ 004512" matches cheque 004512 for AED 21,000

Cheques, transfers with clear references

Fuzzy match

Bank credit "SAMPLE DIST LLC INV8812" matches customer Sample Distribution LLC, invoice INV-8812

Transfers with partial or misspelled references

One-to-many

One card settlement of AED 48,600 matches 212 card sales less fees

Card batches, gateway payouts, bulk payments

Many-to-one

Three partial customer transfers match one invoice

Instalments and partial payments

Amount and date window

Bank charge of AED 105 within three days of a transfer

Charges and fees without references

Apply exact matching first, then fuzzy, then one-to-many. Leave the rest for review.

Which Bank Reconciliation Method Fits Your Team?


Manual in spreadsheets

Rules-based matching in ERP or bank software

AI agent

Setup

None

Rule set per bank and transaction type

Connect statements, ledger and documents

Exact matches

Slow

Fast

Fast

Fuzzy references

Depends on the person

Weak, needs many rules

Strong, reads context

One-to-many batches

Slow

Possible with configuration

Strong, links batches to source data

PDCs and bounced cheques

Manual register

Partial

Tracks register, flags bounces

Exceptions

Person investigates from scratch

Listed without explanation

Listed with a proposed cause and entry

Upkeep

Ongoing hours

Rules break when formats change

Adapts to new formats, with review

Predflow builds agents to reconcile bank accounts across banks and currencies on the accounting system you use. The agent collects statements, applies matching rules, links batches to their source transactions, tracks PDCs, and prepares journal entries for book-side items. Your team reviews exceptions and approves entries. Read more about AI agents for UAE finance teams.

The same matching approach powers our marketplace work. See how one brand reconciles every payout within 48 hours in our settlement reconciliation case. For supplier-side matching, read our supplier statement reconciliation guide.

A Month-End Bank Reconciliation Checklist

Step

Done when

Download statements for every account, every bank, every currency

Statements saved for the full month, closing balances recorded

Confirm opening balances agree with last month's reconciliation

No unexplained opening difference

Match receipts and payments

Exact, fuzzy and batch matches applied

Reconcile the PDC register

Every PDC due this month deposited, in transit or bounced

Match card and gateway settlements

Each settlement linked to its sales and fees

Post book-side items

Bank charges, interest, returned cheques and unposted transfers recorded

Revalue foreign currency accounts

Closing rate applied, FX gain or loss posted

Review outstanding items older than 60 days

Each one investigated and assigned

Sign off

Preparer and reviewer sign each reconciliation

Old outstanding items deserve attention. A cheque issued four months ago and never presented needs a call to the payee. A deposit in transit for three weeks needs a call to the bank. Items left on the reconciliation month after month hide real problems, such as lost cheques, duplicate payments or misapplied receipts.

Keep each month's signed reconciliation with the statements and supporting documents. Auditors ask for them, and the FTA expects records to support every figure in your books.

Bank Reconciliation and Corporate Tax Records

Since UAE corporate tax took effect for financial years starting on or after 1 June 2023, businesses keep financial records supporting their tax return for at least seven years. Bank reconciliations form part of the record. They show the cash figure in your financial statements matches the bank.

Two habits make reconciliations audit-ready. First, keep each signed reconciliation with the bank statement and the support for every reconciling item older than one month. Second, never carry an unexplained difference forward under a suspense heading. Auditors and tax inspectors look for suspense balances first, since they often hide errors.

A tidy reconciliation file also shortens your year-end audit. Auditors sample reconciliations and trace reconciling items to later statements. When every item has support and an explanation, the sampling goes quickly.

How Does Predflow Help With Bank Reconciliation?

Predflow is an AI agent development company. Predflow builds and runs AI agents for businesses in the UAE, India and the US, on the ERP and tools each business already uses, to save time and cost on repetitive work. Predflow builds reconciliation agents which match statements across banks and currencies and prepare journal entries for approval. For a premium beauty brand, a Predflow agent reconciles every marketplace payout within 48 hours of receipt. Read the settlement reconciliation case.

Conclusion

A bank reconciliation brings your cash book and bank statement to the same true balance. The format is simple: adjust the bank side for items in transit and the book side for items the bank already processed.

The difficulty in the UAE comes from volume, with several banks and currencies alongside card batches and post-dated cheques. Keep a clean PDC register and apply matching rules in order. Then automate the matching so your team spends month-end on the exceptions.

Sources

Bring one month of bank statements to a 30-minute reconciliation teardown

We will match your actual statements to your ledger across banks and currencies on the call, PDCs included, and point out which breaks an agent clears. No prep beyond the statements and a GL export.

Frequently Asked Questions

How often should we reconcile bank accounts?

Reconcile every bank account at least monthly, before closing the books. High-volume accounts, such as collection accounts with card and gateway settlements, benefit from daily or weekly reconciliation, since differences are easier to resolve while transactions are recent.

Why doesn't my bank balance match the books?

Common reasons are deposits in transit, outstanding cheques, bank charges and interest not yet recorded, returned cheques, transfers received but not posted, FX conversion differences and posting errors. A bank reconciliation lists each one so both balances agree.

How do PDCs affect bank reconciliation?

Post-dated cheques should not appear in the bank account in the books before their due date. Keep them in a PDC register. On the due date, deposit the cheque and treat the amount as a deposit in transit until the bank credits the amount. If the cheque bounces, reverse the receipt.

What is a bank reconciliation statement?

A bank reconciliation statement is a schedule showing the bank balance and the book balance at a date, with the items explaining the difference, such as deposits in transit, outstanding cheques, bank charges and errors. The adjusted balances on both sides should be equal.

Can bank reconciliation be fully automated?

Agents automate most matching, including exact, fuzzy and one-to-many matches across banks and currencies. A person should still review unexplained differences and approve journal entries. AI agents propose the cause and entry for each exception, which reduces review time.

What is a deposit in transit?

A deposit in transit is money recorded in your books and deposited at the bank, but not yet shown on the bank statement at the reconciliation date. The item usually clears within a few days. Deposits in transit older than a week need a call to the bank.

More on: