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

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.

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.

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.


