26 August 2026 · How To
Tie Customer Balances to the Ledger
A receivables audit schedule should bridge the ledger balance to a customer listing, ageing analysis, invoices, credit notes and receipts after year-end. The appointed auditor uses those records to test existence, completeness, cut-off and recoverability. Flag disputed, related-party and long-outstanding balances with an explanation rather than burying them in the closing total.
Exiloz Management & Tax Consultant · Dubai-based FTA-focused advisory · VAT, corporate tax & accounting
Start with the closing customer listing
A receivables audit schedule should bridge the closing ledger balance to a customer-by-customer listing, then to invoices, credit notes, ageing and receipts after year-end. The appointed auditor can test existence and cut-off only when the total and the individual accounts agree. Put disputed, related-party and long-outstanding balances in visible exception lines rather than allowing them to disappear inside a clean-looking total.
If you are deciding whether to send the listing now, compare its total with the receivables control account first. We recommend resolving the difference before debating provisions, because a balance that does not tie can make every later collection conclusion unreliable. The document that makes the claim true is the customer ledger export dated to the reporting date, supported by the invoice and credit-note records behind each material balance.
The cost of getting this wrong is a weak conclusion about both existence and recovery. A customer total can agree while one account is duplicated, a credit note is missing or cash is sitting unapplied. Start at the control account, then test the customer lines that make up the total. A clean grand total is not enough when the route underneath it is unclear.
- Export the customer listing for the reporting date.
- Reconcile its total to the control account.
- Match invoices and credit notes to customer lines.
- Flag disputes instead of netting them away.
The evidence changes with the customer balance
A current trade balance needs the invoice, delivery or service evidence and a later receipt where available. An old balance needs the contract, collection history and management's view of recoverability. A disputed balance needs the correspondence and the reason the customer has withheld payment. A related-party balance needs the relationship, terms and settlement history. The same ageing column cannot answer all four questions.
Use the customer name and invoice reference as the route through the file. If a balance is large because of one contract, give that contract its own note. If a credit note was issued after year-end, show why it belongs in the earlier period or why it does not. The appointed auditor will decide the testing, but management should make the risk visible before the request arrives.
Do not let the ageing report decide the accounting question by itself. Payment terms, delivery evidence, contract milestones and dispute correspondence can change the explanation for a balance. Record the reason for the ageing category and identify the person who approved any provision assessment. That note gives the auditor a management view to test rather than a silent column of overdue amounts.
- Separate current, old, disputed and related-party balances.
- Keep the contract beside material customer balances.
- Explain post-period credit notes by invoice reference.
- Use later receipts as evidence, not as the whole answer.
| Balance type | Evidence first | Decision to record |
|---|---|---|
| Current trade balance | Invoice and delivery or service record | Whether the balance remains due |
| Old balance | Contract, collection history and later cash | Whether recovery needs further assessment |
| Disputed balance | Correspondence and contract terms | Reason for the dispute and next action |
| Related-party balance | Relationship, terms and settlement history | How the balance will be settled |
The invoice trail must explain the closing figure
Build the schedule from the ledger line to the customer listing, then from the listing to invoices and credit notes. Record the invoice date, service or delivery reference, amount, receipt status and any adjustment. For contract work, add the signed agreement, milestone record and billing calculation. The aim is not to attach every email. It is to show why the closing balance exists and which document supports the amount still due.
Keep the ageing method consistent with the invoice dates and payment terms used in the contract. A customer who pays late is not automatically uncollectable, while a recent balance can still be disputed. Write the reason for any provision assessment beside the customer line and identify the evidence management used. This gives the appointed auditor a starting point for recoverability testing rather than a number without context.
Keep unapplied cash visible instead of netting it against the oldest customer balance. Match each receipt to an invoice or account, record partial settlements and explain amounts that cannot be allocated. For a material contract, preserve the signed terms and milestone evidence with the invoice trail. The schedule should show what management knows and where the evidence stops.
- Link each customer line to invoice references.
- Record credit notes with their reason and date.
- Use contract payment terms in the ageing.
- Write the provision basis beside the affected balance.
Use later receipts to test the open list
Illustrative worked example: opening receivables are AED 240,000, credit sales add AED 1,100,000, receipts reduce the balance by AED 980,000 and credit notes reduce it by AED 60,000, so AED 240,000 + AED 1,100,000 - AED 980,000 - AED 60,000 = AED 300,000. The customer listing and control account should both show AED 300,000. The receipt file then shows which balances still require explanation.
Run the later-receipt check by customer, not only by total bank deposits. Match the receipt to the invoice or account, mark partial settlements and keep unapplied cash visible. For amounts still open, ask the account owner for the contract, correspondence and collection action. A receipt supports cash movement after the reporting date, but it does not repair a wrong-period invoice or an omitted credit note.
The exception note should be specific enough for another reviewer to act on it. Name the customer, invoice or contract, state the unresolved question and identify the next document expected. That note protects the schedule from becoming a silent ageing report and helps management decide which balances need attention before the appointed auditor asks. It also gives the auditor a clear explanation for why an old balance remains open.
- Reperform the customer roll-forward from the saved listing.
- Match receipts to invoice or account references.
- Show partial and unapplied cash separately.
- Escalate open balances with contract evidence.
A later receipt does not settle every judgement
The customer listing, invoice, credit note, contract and bank receipt are the objects that make the schedule testable. They show what was recorded, what was promised, what changed and what cash arrived. They do not decide every recoverability judgement. Management still has to explain a dispute, approve a provision and identify the evidence behind that decision. The appointed auditor then applies the engagement tests to the schedule and source files.
There is a real boundary here: a later receipt confirms a cash movement, but it does not by itself prove that the invoice belonged in the reporting period or that every disputed amount was recoverable. Ministerial Decision No. 84 of 2025 addresses the requirement to prepare audited financial statements, not a universal ageing cut-off for every customer. We would not clear a disputed balance just because one later payment arrived, because the contract and correspondence may describe a different obligation.
The mistake we see most is treating a later receipt as a complete answer. It supports collection evidence, but it does not replace the invoice, the contract, the cut-off analysis or the provision note. Keep the appointed auditor's testing separate from management's judgement. If the evidence does not resolve the dispute, say that plainly and leave the balance visible for review.
- Keep the source contract for material customer balances.
- Treat later cash as one part of the evidence.
- Record the reason for every provision assessment.
- Do not present preparation support as the statutory audit.
Frequently Asked Questions
For building a receivables audit schedule.
What should a receivables schedule show?
The appointed auditor will confirm the final request, but the schedule should usually show the ledger balance, customer listing, ageing analysis, invoices, credit notes, receipts after year-end and explanations for disputed or related-party balances. Each total should reconcile, with the supporting files easy to trace.
Why include receipts after year-end?
Later receipts help the appointed auditor assess whether customer balances were collected and support the existence of the closing balance. They do not replace the customer listing or ageing analysis. Keep the receipt reference beside the customer balance and explain amounts that remain unpaid or disputed.
How should disputed balances be shown?
Show the disputed balance separately, identify the customer and state the reason for the dispute, expected resolution and any provision assessment. The appointed auditor needs to see the risk rather than a clean total that hides the exception. Keep contracts, correspondence and later settlement evidence together.
Can Exiloz prepare the receivables schedule?
Exiloz can reconcile the customer listing to the ledger, organise ageing and receipt evidence and prepare the exception notes for your appointed auditor. Management remains responsible for the balances and provisions. Exiloz provides audit preparation support and does not perform the statutory audit.
Need receivables tied out?
Exiloz prepares the customer listing, ageing bridge and receipt evidence for your appointed auditor without taking on the statutory audit.