26 August 2026 · Evidence
Build a Bank Schedule the Auditor Can Test
A bank audit schedule should reconcile each account from the statement balance to the ledger balance and list every reconciling item with an owner and supporting file. The appointed auditor uses that bridge to test existence and completeness. Include the year-end statement, subsequent clearing evidence and explanations for old items, while keeping the statutory audit with the appointed auditor.
Exiloz Management & Tax Consultant · Dubai-based FTA-focused advisory · VAT, corporate tax & accounting
Each account needs its own route to the ledger
A bank audit schedule begins with the statement closing balance, the ledger balance and the account name used in both records. It then lists each reconciling item, its date, its explanation and the file that supports it. Prepare a separate bridge for every bank and payment account. Combining them too early hides a missing account, a one-sided transfer or a balance that nobody can explain.
If you are deciding what to send first, open the year-end statement and the final general-ledger extract together. We recommend working account by account because that exposes the source of a difference before it becomes a broad question about cash. The appointed auditor uses the bridge to test existence and completeness, while management remains responsible for the records and the explanations attached to them.
The cost of a weak bank schedule is repeated tracing. A transfer may need two statements, a deposit may need a receipt and a cheque may need later clearing evidence. If the account is presented as one unexplained total, the reviewer has to ask for the route again. Show the route once, with the statement date and ledger code beside it.
- Name each bank or payment account separately.
- Show statement and ledger balances on one page.
- Give every reconciling item a date and owner.
- Keep the source statement beside the bridge.
Payment gateways and dormant accounts need different proof
A bank account is supported by a statement, reconciliation and later clearing evidence. A payment gateway may need a settlement report, processor statement, fee report and transfer record because the amount reaching the bank is not the original customer collection. A dormant account still needs a closing statement and an explanation. The object changes the evidence, even when every balance is described as cash in the trial balance.
Look at the account identifier, not only the account label. Match the bank statement to the ledger code, then match gateway settlements to the customer receipts and the bank transfer. If the account was closed, keep the closure letter and final statement. The appointed auditor can then test whether the balance existed and whether money was recorded in the correct period.
A dormant or closed account is not a reason to omit the schedule. It is a reason to explain the status clearly. Keep the last statement, the closure or dormancy evidence and any remaining ledger balance together. If a payment platform settles net of fees, show the gross collection, the fee and the bank transfer as separate steps.
- Separate bank statements from gateway settlement reports.
- Match processor fees to the ledger entry.
- Keep closure letters for accounts no longer used.
- Trace transfers from source account to destination account.
| Account type | Evidence first | Common break |
|---|---|---|
| Bank account | Year-end statement and reconciliation | Uncleared item has no owner |
| Payment gateway | Settlement and fee reports | Net transfer is treated as gross sales |
| Petty cash account | Cash count and ledger extract | The balance has no count record |
| Closed account | Closure letter and final statement | A ledger balance remains after closure |
A clearing file is stronger than a note saying paid
For each deposit in transit, attach the deposit slip, bank credit and the related receipt or invoice. For an unpresented cheque, retain the payment approval, cheque reference and later bank evidence. For a transfer, show both account statements and the matching ledger entries. The next statement is useful because it shows whether the item cleared, but it does not explain an entry that was posted to the wrong account.
The schedule should also record items that are not expected to clear. A bank charge, rejected payment or unidentified receipt needs a proposed treatment and a named decision-maker. Do not remove an old item because it looks inconvenient. The appointed auditor may ask why it remains, and the answer should be a dated investigation note supported by the statement, correspondence or payment record.
The mistake we see most is marking an item as cleared because it appears on a later statement without matching the amount and reference. Later activity helps, but it does not repair a wrong-side posting or an unauthorised payment. Record the bank date, the amount, the ledger entry and the source file. Leave a mismatch in the exception log.
- Attach a deposit slip to each deposit in transit.
- Match transfers on both account statements.
- Keep approval evidence for unpresented cheques.
- Explain items that will not clear normally.
Clear open items against the next statement
Illustrative worked example: the bank statement shows AED 126,000, the ledger shows AED 119,500, deposits in transit are AED 8,000 and unpresented cheques are AED 1,500, so AED 119,500 + AED 8,000 - AED 1,500 = AED 126,000. The bridge should carry the figures, statement page and clearing evidence. If the arithmetic does not reach the statement, stop the handover and identify the missing entry before testing begins.
Run the reconciliation after the final payment batch, then compare each open item with the next statement. Mark cleared items with the bank date and leave uncleared items visible. This process is short, but it only works when the account owner can access the payment approvals, deposit records and correspondence. A total without those objects is a calculation, not an audit trail.
Do the review while the account owner can still identify the transfer, deposit or payment approval without reconstructing the whole year. A bank schedule is not a request for every cash document. It is a controlled explanation of the closing balance, with enough source material for the auditor to select and test the items that matter. Keep the account name, statement date and ledger code together so a reviewer can identify the exact balance without guessing for the reporting date.
- Reperform the arithmetic from the saved statement.
- Mark later clearing with the bank date.
- Leave unresolved items in the exception log.
- Ask the account owner for missing approvals.
A bank tie-out proves the bridge, not every cash risk
The year-end bank statement is the object that makes the closing balance visible. The ledger extract makes the book figure visible. The reconciliation explains the route between them. Those documents support the cash bridge, but they do not by themselves prove that a customer receipt is genuine, that a related-party transfer has the right terms or that a payment was authorised. Keep those questions in their own schedules.
The format of a bank reconciliation is not set out in Ministerial Decision No. 84 of 2025. The decision addresses which taxable persons prepare audited financial statements and says Tax Group special purpose statements follow procedures specified by the Federal Tax Authority. It does not prescribe how an edge-case bank item must be treated. That boundary is real. We would not send a combined cash total while one account remains unreconciled, because the missing account can change the conclusion.
Before handover, have a reviewer who did not prepare the bridge trace one open item from the statement to the ledger and back to the clearing file. If the route cannot be followed without a verbal explanation, the schedule is not ready. Keep the appointed auditor's requests separate from management's reconciliation so preparation work is not mistaken for the statutory audit.
- Use the statement to establish the closing bank figure.
- Use approvals and contracts for transaction questions.
- Keep Tax Group format questions in writing.
- Do not let one open account hide inside a total.
Frequently Asked Questions
For preparing a bank reconciliation schedule.
What belongs in a bank audit schedule?
The appointed auditor will confirm the final request, but a practical bank schedule lists each account, the year-end statement balance, the ledger balance, reconciling items, later clearing evidence and an explanation for each difference. Keep the statements and reconciliation support together so the auditor can move from the balance to the source.
How do you handle old reconciling items?
Assign each old item to a named owner, identify why it remains open and attach the evidence needed to clear or explain it. The appointed auditor may test later bank activity. Management should not remove an item simply because it has been outstanding for a long time.
Do payment accounts need separate schedules?
Yes. Each bank and payment account should have its own reconciliation before totals are combined. The appointed auditor tests completeness as well as the closing figure, so one unexplained combined balance can hide a missing account, duplicated posting or one-sided transfer.
Can Exiloz prepare bank schedules?
Exiloz can prepare the reconciliation, tie the closing balance to the ledger and assemble the supporting files for your appointed auditor. Management remains responsible for the records and explanations. Exiloz provides preparation and support, not the statutory audit or audit opinion.
Is cash still unreconciled?
Exiloz prepares the bank reconciliations, clears the evidence trail and packages the open items for your appointed auditor.