Accounts Receivable (AR) Reconciliation Template

Every month, a B2B company in Riyadh or Jeddah finishes closing its books, then the accountant discovers that the Accounts Receivable control account balance in the general ledger does not match the sum of customer balances in the subledger. The gap might be SAR 12,000, and it can reach SAR 480,000 in contracting and government supply firms. The real problem is that this gap is not just a number in a report; it is actual cash that has either been withheld by a customer who did not pay, recorded twice, or hit the bank without being applied.

The causes recur across most Saudi companies: a sales invoice posted twice after a technical adjustment, a payment that landed in the bank account but was never applied to a specific customer, a credit note issued to settle a return but never linked to the original invoice, foreign currency rounding differences on export invoices, a tax invoice cancelled without a formal tax credit note, and a customer who paid with an unrecorded cash discount. Each of these gaps hides the true cash flow picture and confuses management reports and external audits.

Accounts Receivable (AR) reconciliation is not a routine monthly task; it is rigorous financial control that protects liquidity, prevents bad debts from piling up, and prepares the company for the requirements of the Zakat, Tax and Customs Authority (ZATCA) under Phase 2 of e-invoicing. The template we provide in this guide translates this process into a practical sheet that starts with a period cut-off and ends with an approved journal entry, with ready-made tables for aging, a classified differences list, and write-off and provision entries.

What is AR Reconciliation and How It Differs from Bank Reconciliation

Accounts Receivable Reconciliation is a periodic verification process that proves the total of outstanding customer balances in the subledger exactly equals the AR control account balance in the general ledger, that every invoice, note, and payment has a counterpart on both sides, and that the aging buckets reflect the reality of collection rather than just dangling figures.

Many accountants in Saudi companies confuse this reconciliation with bank reconciliation. The difference is fundamental: bank reconciliation compares your internal book to an external statement issued by a single party (the bank), while AR reconciliation compares two internal sources inside your own accounting system, then compares each customer’s result to the statement they maintain on their side.

The Real Goal of Reconciliation

• Protecting cash: every unmatched riyal could be a payment that never arrived, an invoice that will never be collected, or a discount applied without an entry.
• Accuracy of the financial statements: the AR balance appears on the balance sheet as a current asset, and any error inflates assets and distorts liquidity ratios.
• Tax compliance: VAT due on sales arises from invoices, so any duplication or undocumented cancellation distorts the VAT return.
• Credit decisions: you cannot grant a customer a new credit limit before confirming their actual balance.

When Reconciliation Should Be Performed

The minimum in small companies is monthly, before period close. In contracting and government-sector firms it should be weekly for large accounts, and always before filing the quarterly VAT return and before the fiscal year-end close.

The Difference Between the AR Control Account and the Customer Subledger

In any double-entry accounting system, AR exists in two layers: the AR control account in the general ledger, and the subledger which contains a separate card for each customer. The two layers must match at any moment, but a gap arises whenever an entry hits one layer and not the other.

The AR Control Account

This is a single account in the general ledger that holds the cumulative total of all credit sales less collections, returns, and credit notes. It feeds directly into the balance sheet and represents one current asset under one number.

The Subledger

A detailed record that holds a card for each individual customer: their invoices, payments, notes, and aging. The sum of all cards must exactly equal the AR control account balance.

Where the Gap Typically Arises

• Manual entries on the control account: an accountant posts an adjustment directly to AR without updating the customer card.
• A payment in the subledger with no impact on the general ledger: applying an old payment without a corresponding accounting entry.
• An unposted credit note: issued to the customer but never recorded in the system.
• Exchange rate differences: on foreign currency invoices, the gap is computed at two different rates.

The Six Most Common Causes of AR Differences

After reviewing hundreds of cases across diverse Saudi companies, we find that 90 percent of AR reconciliation differences trace back to just six causes. Classifying them early saves hours every monthly cycle.

1. Invoice Recorded Twice

This happens when migrating data from an external POS system into accounting, or when uploading a sales file in Excel format more than once. The invoice appears in the customer card with the same number twice, or with different numbers but the same date and amount.

2. Unapplied Payment

A payment landed in the bank account and was booked in cash, but was not linked to a specific customer invoice, so it sits as a credit balance in the AR control account while the customer cards do not reflect it.

3. Unapplied Credit or Debit Note

A note issued to adjust an invoice value (return, trade discount, error correction), but not linked to the original invoice, so it stays dangling on the customer statement.

4. Undocumented Cash Discount

The customer pays SAR 19,550 on an invoice of SAR 20,000 in exchange for a cash discount. If the discount is not recorded with a separate entry, the customer card keeps showing SAR 450 due with no reason.

5. Foreign Exchange Differences

An invoice in US dollars was issued at SAR 3.7500 and collected at SAR 3.7510. The difference is small on a single invoice, but it accumulates across hundreds of invoices in export companies.

6. VAT on a Cancelled Invoice

A tax invoice cancelled internally without issuing a formal credit note recognised by ZATCA. The base value disappears from the customer card, but the output VAT entry in the general ledger remains.

The Six Reconciliation Steps in Order

Following a strict sequence in reconciliation prevents rework and speeds up the close. The six steps below are applied in the same order in every cycle, and each step has a documented output in the attached template.

1. Period Cut-off

Before starting the reconciliation, the posting period in the accounting system must be locked so that no user can add invoices or payments with a date that falls within the period under reconciliation. This step is the difference between a successful reconciliation and a file that changes every hour.

2. Extract the Customer Statement and the Subledger Card

For each customer, an account statement is extracted from the system containing the opening balance, the period’s movements, and the closing balance. A customer statement is requested from the customer on the other side from their own records when the relationship is significant.

3. Invoice Matching

Each invoice on your statement is compared with its counterpart on the customer’s statement: invoice number, date, value before and after VAT. Any invoice present on one side and missing on the other goes onto the differences list.

4. Payment Matching

Each payment you received is compared with the transfer record on the customer side. Any payment shown on the customer side but not on yours is verified with the bank, and any payment on your side not acknowledged by the customer is reviewed against the reference number and deposit date.

5. Classifying Differences

Every item on the differences list is classified according to the six causes in the previous section. The classification determines the correcting entry required and the owning function: accounting, sales, treasury, or the customer.

6. Documenting and Approving the Reconciliation

All correcting entries are recorded with documented references, and a final reconciliation report is prepared containing: the balance before reconciliation, differences by type, the corrected entries, the balance after reconciliation, and the signatures of the accountant and the financial reviewer.

AR Aging Analysis (Aging Buckets)

Aging analysis is the second part of the reconciliation after quantitative matching. It classifies outstanding balances by age from the due date, and reveals the customers who are slipping into late payment before they turn into bad debts. Mature companies in Saudi Arabia use 4 standard buckets:

Age Bucket	Description	Recommended Action	Suggested Provision Rate
0 to 30 days	Within the agreed credit period	Standard follow-up with a pre-due notice	0 percent
31 to 60 days	Mild delay, calls for a reminder	Customer service call and statement of account	1 percent
61 to 90 days	Moderate delay, sign of a potential dispute	Formal meeting, contract review, freeze of credit	5 percent
More than 90 days	Major delay, possible dispute or insolvency	Legal escalation, build a doubtful debt provision	25 percent or higher

A Real-World Contracting Customer Example

A contracting company in Riyadh supplies the government sector with SAR 4.8 million in annual sales. When the analysis was applied, it discovered that 18 percent of its receivables sat in the 90+ days bucket because of delays in work completion certificates. The decision: restructure the credit policy and tie invoicing to the completion certificate sequence before posting.

Reading the Ratios

• 0 to 30 days under 60 percent of the total: warning, collection is slow.
• 90+ days exceeding 10 percent: red flag, bad debt risk is close.
• Heavy concentration on a single customer: concentrated credit risk that calls for portfolio diversification.

How to Handle Unapplied Payments and Dangling Credit Notes

Unapplied payments and dangling credit notes are among the most troublesome differences, because they produce a credit balance on a customer (making it look as if they are overpaying) while the money is actually present but not attributed to a specific invoice.

The Unapplied Payment Scenario

A professional services customer wires SAR 47,500 without an invoice reference. The accountant records it as a collection from the customer but it stays unapplied. After 3 months, they discover it belongs to two old invoices that were sitting in the 60 to 90 day bucket. The result: misleading aging reports and a doubtful debt provision computed incorrectly.

The Handling Procedure

• Isolate unapplied payments in a clearing account: a “Receipts Pending Application” account that segregates them from AR until they are applied.
• Monthly tracking: a report listing every payment older than 7 days without an application.
• Customer outreach: request the intended invoice number or the bank transfer slip.
• Finance sign-off: no amount is applied manually without written authorization from the reviewer.

Dangling Credit Notes

A credit note issued to a customer must be linked to an original invoice at the same moment. If it remains standalone, it lowers the customer balance misleadingly, and complicates the VAT return because it represents an adjustment to prior output VAT.

VAT Impact on Reconciliation

VAT at 15 percent in Saudi Arabia makes AR reconciliation more demanding, because any invoice duplication is also a duplication of the tax amount. ZATCA links e-invoicing under the Integration Phase (Phase 2) to this practice, which means any manual reconciliation must be reflected in an approved electronic invoice.

Rule One: No Invoice Cancellation Without a Credit Note

In the electronic system, the original tax invoice cannot be deleted after issuance. Amendment or cancellation goes through a formal tax credit note tied to the original invoice number, transmitted to ZATCA through the same channel as the invoice.

Rule Two: Output VAT Matches the Sales Report

Before approving the reconciliation, total output VAT for the period is compared with 15 percent of the value of taxable sales. Any difference indicates a missing invoice or a duplicate.

Rule Three: Zero-rated and Exempt Invoices

Sales to exempt government entities or zero-rated exports show up in AR but do not generate output VAT. Mixing them with taxable sales causes reconciliation differences and tax non-compliance.

Rule Four: Reconcile Before Filing the Return

AR reconciliation must close before the quarterly VAT return is filed, because the return is built on finally posted invoices, not on drafts or pending differences.

When to Build a Doubtful Debt Provision and When to Write Off the Debt

After reconciling AR and analysing aging, the accountant moves to two pivotal accounting decisions: building a doubtful debt provision, or writing off the debt entirely. The two are fundamentally different in their accounting and tax effect.

Allowance for Doubtful Debts

An accounting estimate that part of outstanding receivables may not be collected, without considering the customer insolvent. The provision is recorded by debiting Doubtful Debt Expense and crediting an Allowance for Doubtful Debts account. It does not affect VAT because it is an estimate rather than an actual settlement.

Final Write-off

Executed when it is established that the debt will not be collected: customer insolvency, no contact for more than 6 months after legal notices, or a court ruling of non-liability. The write-off removes the customer balance entirely and is settled against the provision if one exists.

When Each Is Applied

• The provision: at fiscal year-end based on aging and historical collection rates.
• The write-off: when a conclusive legal document exists: a declaration of bankruptcy, a court ruling, or an approved company policy to write off debts older than two years.
• Combining the two: when a provision was built earlier and the debt then turns into a write-off, the provision is reduced by the same write-off amount.

Reconciliation Across Different Sectors

The nature of the business sector dictates the intensity of AR reconciliation and the types of differences that recur. The attached template can be tailored to each sector, but the general logic shifts depending on the invoicing cycle and prevailing credit policy.

B2B Retail and Distribution

A large number of customers with small invoices, and a short collection cycle (15 to 30 days). Common differences: returned invoices, credit notes on returns, undocumented volume discounts. Reconciliation is weekly for major accounts. Linking the template to invoicing in Qoyod accelerates posting.

Contracting

A small number of customers with large invoices, and a long collection cycle (60 to 180 days) tied to work completion certificates. Common differences: completion percentage gaps, retention guarantees, late penalties, contract amendments. Reconciliation should be at least monthly.

Professional Services

(Law, consulting, technology, marketing). Billing is by the hour or by milestone payments. Common differences: hours not approved by the customer, invoices still under review, advance payments not yet settled.

Government Sector Supply

Subject to government procurement platform regulations. Common differences: delays in receipt certificates, a 5 percent retention guarantee, late penalties, invoices tied to a specific purchase order. The template adds a column for the purchase order number and the receipt certificate. To learn more about managing this sector, see the contracting sector page.

The Most Common Mistakes in Saudi AR Reconciliation

The same mistakes recurring across dozens of companies show they are systemic patterns, not individual oversights. Spotting them in advance saves the accounting team from wasted time.

1. Relying on an Excel Sheet Without Access Controls

Everyone in the department edits the template, and no one knows the trusted figure. The fix: an accounting system with posting and approval permissions, with Excel used only for analysis.

2. Deferring Reconciliation to the Quarter

A quarterly reconciliation accumulates hundreds of differences whose causes and history are hard to trace. The fix: strict monthly reconciliation before period close.

3. Applying Payments by Date Automatically

Many accountants apply any payment to the oldest invoice without checking with the customer. This gives a misleading picture of aging. The fix: apply by transfer reference or by the invoice number stated by the customer.

4. Ignoring Exchange Differences

Small differences accumulate over the year into thousands of riyals. The fix: book a separate exchange difference entry on each foreign currency payment.

5. Failing to Document the Cause of a Difference

A reconciliation without classified differences repeats itself next month. The fix: a mandatory column for the cause of the difference and the owner responsible for resolving it.

6. Confusing Cancellation with a Credit Note

Cancelling an electronic tax invoice without a formal credit note violates ZATCA requirements.

The Journal Entries Required to Close the Reconciliation

After classifying differences, journal entries close the reconciliation and restore the match between the control account and the subledger. The table below presents the most common entries with realistic amounts in Saudi riyals.

Case	Debit Account	Credit Account	Amount (SAR)	Notes
Cancel a duplicate invoice	Sales Revenue	Customer AR	17,400	With a corresponding tax credit note (15 percent VAT)
Apply a pending payment	Receipts Pending Application	Customer AR	47,500	After the customer confirms the invoice number
Cash discount entry	Discount Allowed	Customer AR	450	On a SAR 20,000 invoice (2.25 percent discount)
Build a doubtful debt provision	Doubtful Debt Expense	Allowance for Doubtful Debts	112,000	5 percent of the 61 to 90 bucket and 25 percent of 90+
Final debt write-off	Allowance for Doubtful Debts	Customer AR	68,300	Customer declared bankrupt by court ruling
Currency exchange difference	Exchange Losses	Customer AR	1,237	On an invoice valued at USD 100,000

Entry Documentation Rules

• Every entry has an attachment: a copy of the note, the transfer slip, or the court ruling.
• Dual approval: an accountant records, and a reviewer approves, with no one doing both.
• Sequential numbering: reconciliation entries have a reference series separate from regular entries.
• Post within the reconciliation period: every entry is dated to the last day of the period, not the next one.

How Qoyod Reconciles AR Automatically for You

Automation is not a luxury; it is a necessity in any company that has crossed 50 active customers. Qoyod is purpose-built for the Saudi business environment, and offers a set of features that cut AR reconciliation from 3 working days down to two hours.

Automatic Matching Between the Control Account and the Subledger

Qoyod runs a real-time check between the AR balance and the sum of customer cards. Any gap surfaces immediately as an alert on the finance dashboard, with its location identified.

Smart-Assisted Payment Application

When a bank payment is received, the system compares the amount and transfer reference to the customer’s open invoices and suggests the application. The accountant reviews and approves instead of searching manually.

AR Aging Reports with Flexible Buckets

4 standard buckets (0 to 30, 31 to 60, 61 to 90, 90+) that can be customized to fit the credit policy, with direct export to Excel and PDF.

Credit and Debit Notes Linked to the Original Invoice

Every note is mandatorily linked to an existing invoice and issued as a ZATCA-approved electronic invoice (Phase 2).

Overdue Invoice Alerts

An automatic notice to the customer and to the collection owner when an invoice passes its due date. A reminder series of 3 messages on approved intervals.

Integration with Saudi Banks

Import the bank statement and link transfers to customer payments automatically, sharply shrinking the unapplied payments gap.

Technical Support Available 24 Hours, 7 Days a Week

A support team specialized in account reconciliations and complex entries, available every hour of the week to answer accountants’ questions. Browse Qoyod plans to pick the one that fits your company size.

Frequently Asked Questions

What is the Difference Between AR Reconciliation and Bank Reconciliation

AR reconciliation compares the AR control account in the general ledger with the sum of customer cards in the subledger, then with the statement issued by the customer from their own records. Bank reconciliation compares the cash book with the bank statement issued directly by the bank. The first is internal with an external complement, while the second is fully external.

How Often Should AR Reconciliation Be Performed

The minimum is monthly before period close. In contracting and government-sector companies, it should be weekly for large accounts. And always before filing the quarterly VAT return and before the fiscal year-end close.

How Do I Handle a Customer Who Refuses to Confirm the Balance

A formal escalation ladder is triggered: send a signed, documented statement of account, hold a review meeting with the customer’s accountant, exchange supporting documents (invoices, delivery receipts, notes), then escalate to the commercial owner, and finally pursue legal action if the dispute persists.

Do I Still Need AR Reconciliation if My System Does It Automatically

Yes. Automation does not replace review. Smart systems detect differences and suggest applications, but approving the correcting entry and classifying the cause remain a human responsibility. A documented monthly reconciliation protects the company legally and from a tax standpoint.

What Is the Relationship Between AR Reconciliation and the VAT Return

The VAT return is built on the actual sales invoices posted in the period. Any duplicated invoice, any cancellation without a credit note, or any missing invoice distorts the output VAT due. Reconciling AR before filing avoids penalties and audit differences from ZATCA.

When Should I Build a Doubtful Debt Provision

At fiscal year-end based on aging analysis. Common rates: 1 percent on the 31 to 60 bucket, 5 percent on 61 to 90, and 25 percent or more on anything past 90 days. Rates are adjusted to the company’s historical collection record and the nature of its customers.

What Is the Difference Between Writing Off a Debt and Building a Provision for It

The provision is an accounting estimate that part of the debt may not be collected, without considering the customer insolvent, and does not remove the customer balance. The write-off is a final removal of the debt after collection has been confirmed impossible, and requires a conclusive legal document such as a court ruling or a declaration of bankruptcy.

Does This Template Work for a Small Company with Only 10 Customers

Yes. The template is fully customizable: a small company uses only the core columns (invoice number, date, value, payments, balance, age bucket), and leaves the notes and exchange columns empty. As the company grows, deeper layers are added.

Conclusion

AR reconciliation is not a ceremonial closing task; it is financial control that protects liquidity, reveals system gaps, and prepares the company for ZATCA requirements. Saudi companies that stick to a strict monthly reconciliation shorten their collection cycle by up to 20 percent and bring bad debts below 1 percent of sales. The attached template is the practical starting point: download it, customize it for your sector, and integrate it with your accounting system to close your books with confidence.