BANKRECONCILIATION 5% Excel
Home / Templates / Bank reconciliation
Free · no sign-upChecked 20 Nov 2026Expenses and cash

Bank reconciliation that ends at zero

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.

CBUAE FX rateson foreign linesBuilt for VAT201box by box
Short answer

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).

01What goes on it

Required by law, or just good practice

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.

ItemStatusWhere it comes from
Statement balance and book balance on the same datePracticeStandard method
Deposits in transit and outstanding cheques listed by itemPracticeSo each one can be ticked off next month
Charges, direct debits and interest booked in the ledgerPracticeBank charges carry 5% VAT: keep the bank's tax invoice
Difference = zero, signed and datedPracticeInternal control
Accounting records kept at the head office for 5 yearsLawCommercial Companies Law (FDL 32/2021) Art. 26
Records kept 7 years after the tax periodLawCT Decree-Law Art. 56
Law stated in legislationPractice common, not required
02Preview and how to fill it

See it filled in, then make it yours

Switch between the worked example and the blank version you download. Example figures are illustrative.

Bank reconciliation31 Oct 2026
CompanyDune Studio LLC (example)
BankEmirates NBD current account
IBANAE07 ... 3456
Bank side
ItemRefAED
Balance per bank statement 84,250.00
Add: deposit in transit (Sahara Clinics)RV-008810,447.50
Less: cheque not presented (landlord)000214-12,500.00
Less: cheque not presented (supplier)000216-3,150.00
Adjusted bank balance79,047.50
Book side
ItemRefAED
Balance per cash book 80,180.00
Less: bank charges not booked (incl. VAT)Stmt 29 Oct-105.00
Less: DEWA direct debit not bookedStmt 30 Oct-1,027.50
Adjusted book balance79,047.50
Difference (must be zero)AED 0.00
Prepared by
Reviewed by

Example company and figures are made up. Replace every grey hint with your own details.

01

Same date both sides

Month end. Download the statement as CSV or Excel so you can match lines rather than retype them.

02

Tick what matches

Every bank line against a book entry. What is left unticked is the reconciliation.

03

Fix the books, list the timing

Charges, direct debits, interest: book them now. Cheques and deposits not yet through the bank: list them.

04

Investigate any difference

Common culprits: a transposed figure (difference divisible by 9), a duplicate entry, a reversed sign.

03Common mistakes

What we see go wrong

Small slips that cost VAT, fines or an argument with a customer or employee.

!Forcing the difference to zero with a "suspense" line and never clearing it.
!Ignoring cheques outstanding for months. After a while they need following up or reversing.
!Booking bank charges gross with no VAT split, when the bank issued a tax invoice.

Or let the numbers fill themselves.

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.

See how it works
FAQBank reconciliation

Questions people ask

How often should I do a bank reconciliation?+

Monthly at minimum, and before every VAT return. Busy accounts benefit from weekly.

What if the difference is not zero?+

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.

Is a bank reconciliation required by UAE law?+

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.

Can fylng do this for me?+

fylng reads UAE bank exports (CSV, Excel, PDF), flags gaps where the running balance does not follow on, and matches receipts to bank lines.

Sources

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.

  1. Federal Decree-Law 32 of 2021 on Commercial Companies (uaelegislation.gov.ae): Art. 26 accounting records, Art. 27 auditors
  2. Federal Decree-Law No. 47 of 2022 on Corporate Tax (MoF English text): Art. 3 rates, 21 Small Business Relief, 32 entertainment, 33 non-deductible, 37 losses, 53 returns, 56 records
  3. FTA: Get to know your tax obligations: returns, 28th-day rule, record keeping

Upload statements,
receive a filed return.

Start free