Bank statement on one side, your cash book on the other. The template walks both to the same number and shows the gap if they do not meet.
A bank reconciliation compares the closing balance on your bank statement with the balance in your books on the same date. Adjust the bank side for deposits in transit and cheques not yet cleared, adjust the book side for bank charges, direct debits and interest you have not recorded, and the two adjusted balances should match. The method is accounting practice; UAE law requires the underlying records to be kept (Commercial Companies Law Article 26, 5 years; corporate tax 7 years).
Every line is marked. "Law" means a UAE law, decree or regulation says it, with the article. "Practice" means it is common and sensible, but no rule requires it.
| Item | Status | Where it comes from |
|---|---|---|
| Statement balance and book balance on the same date | Practice | Standard method |
| Deposits in transit and outstanding cheques listed by item | Practice | So each one can be ticked off next month |
| Charges, direct debits and interest booked in the ledger | Practice | Bank charges carry 5% VAT: keep the bank's tax invoice |
| Difference = zero, signed and dated | Practice | Internal control |
| Accounting records kept at the head office for 5 years | Law | Commercial Companies Law (FDL 32/2021) Art. 26 |
| Records kept 7 years after the tax period | Law | CT Decree-Law Art. 56 |
Switch between the worked example and the blank version you download. Example figures are illustrative.
| Item | Ref | AED |
|---|---|---|
| Balance per bank statement | 84,250.00 | |
| Add: deposit in transit (Sahara Clinics) | RV-0088 | 10,447.50 |
| Less: cheque not presented (landlord) | 000214 | -12,500.00 |
| Less: cheque not presented (supplier) | 000216 | -3,150.00 |
| Adjusted bank balance | 79,047.50 | |
| Item | Ref | AED |
|---|---|---|
| Balance per cash book | 80,180.00 | |
| Less: bank charges not booked (incl. VAT) | Stmt 29 Oct | -105.00 |
| Less: DEWA direct debit not booked | Stmt 30 Oct | -1,027.50 |
| Adjusted book balance | 79,047.50 | |
| Item | Ref | AED |
|---|---|---|
| Balance per bank statement | ||
| Add: deposit in transit (Sahara Clinics) | ||
| Less: cheque not presented (landlord) | ||
| Less: cheque not presented (supplier) | ||
| Adjusted bank balance | ||
| Item | Ref | AED |
|---|---|---|
| Balance per cash book | ||
| Less: bank charges not booked (incl. VAT) | ||
| Less: DEWA direct debit not booked | ||
| Adjusted book balance | ||
Example company and figures are made up. Replace every grey hint with your own details.
Month end. Download the statement as CSV or Excel so you can match lines rather than retype them.
Every bank line against a book entry. What is left unticked is the reconciliation.
Charges, direct debits, interest: book them now. Cheques and deposits not yet through the bank: list them.
Common culprits: a transposed figure (difference divisible by 9), a duplicate entry, a reversed sign.
Small slips that cost VAT, fines or an argument with a customer or employee.
fylng reads your UAE bank exports and receipts, sorts every line under UAE rules and builds the VAT201 and a corporate tax estimate. Free to start. You still file on EmaraTax.
Free file tools from FixDoks, our sister product.
Monthly at minimum, and before every VAT return. Busy accounts benefit from weekly.
Look for a missing or duplicated entry, a transposed number (differences divisible by 9 are a clue), or a reversed sign. Do not post a balancing figure you cannot explain.
The law does not prescribe the reconciliation itself. It requires accounting records that show your true position, kept for 5 years under the Commercial Companies Law and 7 years for corporate tax. Auditors and the FTA will expect reconciliations.
fylng reads UAE bank exports (CSV, Excel, PDF), flags gaps where the running balance does not follow on, and matches receipts to bank lines.
Facts checked 20 Nov 2026. Official sources first; press and Big-4 summaries are marked. English texts of UAE laws are translations; the Arabic text prevails. This template is not legal or tax advice: rules change, so confirm with the FTA, MoHRE or your authority.