Supplier Account Reconciliation Template (Excel + Google Sheets)

At every month-end, the accounting team opens the supplier file and asks the same question: do our numbers match theirs? More often than not, the answer is no. An invoice that was never recorded, a payment posted in a different month, a return whose credit note was forgotten, an early-payment discount applied by one side but not the other. As these gaps pile up, the supplier account becomes an accounting minefield. It threatens the accuracy of your financial statements, shakes your relationship with your biggest suppliers, and opens a gap during an audit by the Zakat, Tax and Customs Authority (ZATCA).

The fix is a structured process known as supplier account reconciliation. It is not just a spreadsheet, but a monthly, quarterly, or annual cycle in which you compare your internal records against the supplier’s official statement, identify the variances, classify them, and resolve them through balanced accounting entries before closing the period. In this practical guide we walk through every stage: the concept, the timing, the elements of the template, the difference between the two statements, the execution steps, the types of variances and their accounting treatment, the link to accounts payable (AP) and VAT, a full Saudi numerical example, then handling foreign-currency suppliers, and how all of this turns inside Qoyod into an automated cycle that wraps up in minutes instead of days.

What is supplier account reconciliation and why is it indispensable?

Supplier account reconciliation is a recurring accounting process whose goal is to confirm that the balance recorded in the company’s books for a specific supplier matches the balance recorded by that supplier for the company. The idea is simple at its core: you see the supplier as a creditor for a certain amount, the supplier sees themselves as a creditor for a different amount, and the role of reconciliation is to close the gap between the two figures in a documented way.

On the surface, reconciliation looks like a formality. In reality, it is a pillar of sound accounting. A company that does not reconcile its supplier accounts is operating on records that do not reflect reality. An invoice lost in the mail, a payment never linked to its invoice, a return never recorded, all accumulate over months until the supplier balance becomes a meaningless number. Then comes the surprise at the annual close: the supplier demands an amount, you see the balance at half that value, and time has run out to dig up the documents. At that point the balance sheet turns into a subject of debate with the external auditor.

Reconciliation serves four goals that cannot be separated:

• Accuracy of the financial statements: the AP balance on the balance sheet must be provable with documents, not just a number in the system.
• Integrity of the tax return: the input VAT you claim back from the authority must rest on real invoices that are recorded on both sides.
• Protecting the supplier relationship: periodic reconciliation spares you the surprise of late-payment demands, legal claims, or loss of supplier trust.
• Cash-flow control: knowing the real obligations due each month lets the finance team plan cash with precision.

If you are just starting to understand the AP cycle, we recommend reading the Accounts Payable guide first, so it becomes clear how reconciliation fits into the full purchasing cycle.

When should supplier account reconciliation be performed?

The timing of reconciliation is not arbitrary. It depends on the volume of activity with the supplier, the nature of the sector, and the requirements of the accounting and tax close. Three cycles are common in Saudi practice:

Monthly reconciliation

Best for major suppliers (inventory, logistics, raw materials) where activity exceeds 5 to 10 invoices a month. Monthly reconciliation closes each month cleanly, prevents the build-up of errors, and smooths the monthly financial close. It is usually performed in the first week of the following month, after the supplier has issued their monthly statement.

Quarterly reconciliation

Best for mid-activity suppliers, or suppliers whose transactions are patterned and repetitive with steady figures. Quarterly reconciliation lines up with the VAT return that ZATCA requires from businesses with annual revenue below 40 million SAR. When preparing the tax return, you need to confirm that every purchase invoice you used to claim input VAT is actually recorded, paid (or at least due), and approved by the supplier.

Annual reconciliation

Mandatory for every supplier without exception. It is performed in the first quarter of the new fiscal year as part of closing the accounting period. It is the reconciliation the external auditor will ask you to produce as part of the AP sample file, and the opening balance of the new year is built on it. Any flaw here opens up costly audit findings.

Ad hoc reconciliation

At the end of a supplier contract, when business stops, during a commercial dispute, when a legal claim is filed, or when an accountant moves and a handover is required. Ad hoc reconciliation is more detailed, calls for original documents, and is sealed by a formal signature from both sides.

The practical rule: every major supplier deserves a monthly reconciliation. Every secondary supplier is fine with a quarterly. Any supplier with no continuous activity is fine with annual. Within the accounting cycle you run every month, supplier reconciliation is a step that cannot be deferred past the period close.

Template elements: what does a strong supplier reconciliation statement contain?

The ready-made template you can download at the top of this page contains six core columns no professional reconciliation can do without. Each missing column opens a gap in accuracy:

1. Incoming invoices

A list of every invoice the supplier issued to the company during the period, including: invoice number, issue date, due date, pre-VAT value, VAT amount, post-VAT total, and the linked purchase order number. The e-invoice that meets ZATCA’s integration-phase requirements must carry a QR code and a UUID reference that can be verified. Make sure every invoice in your statement maps to an invoice in the supplier’s statement with the same number.

2. Outgoing payments

A list of every transfer, cheque, or cash payment sent to the supplier, with the date, amount, bank reference number, cheque number if any, and the invoice number(s) it settled. The most common error here: a payment recorded without linking it to a specific invoice, so it appears as an outstanding debit balance on the supplier’s side while it looks paid in your records.

3. Returns and credit notes

Every item returned to the supplier, every post-sale discount, every adjustment in quantity or price. These are usually recorded through a credit note from the supplier, or a debit note from you. Under e-invoicing requirements, adjustment notes carry the same UUID reference as the original invoice, and any return without a formal note is not accepted for tax purposes.

4. Discounts

Volume discounts, early-payment discounts, framework-agreement discounts. These discounts may be applied directly to the invoice (appearing in its value), or may be applied later as a separate note. Reconciliation surfaces which ones are recorded on both sides and which are missing on one side.

5. Outstanding balance

Opening balance of the period (carried from the end of the prior period) + total invoices, total payments, total returns and discounts = the outstanding balance at period-end. This figure must match what the supplier has, and if it does not, the variance battle begins.

6. Variances

A detailed column that records: item number, variance type, value, responsible party, root cause, corrective action, and the supporting document. This column is the soul of the template, and what turns it into a real tool rather than a reference grid.

Supplier statement versus internal account statement: what is the difference?

The question may sound simple, but it is the heart of the entire reconciliation process. Each party keeps its own ledger from its own angle, in the format that serves its internal system. That alone produces differences before we even discuss real variances.

The supplier statement

This is what the supplier issues as creditor and it reflects their point of view: when they issued their invoices, when they received your payments, when they granted you a discount, when they received your returns. It is usually issued as a PDF or Excel, carries the supplier’s stamp and signature, and orders items according to the supplier’s internal logic (usually issue date, not due date).

The internal account statement

This is what your accounting system pulls from the supplier’s account (under AP), reflecting your point of view: when you received the invoice, when you paid it, when you returned goods. The moment of recording differs from the moment of issue on the supplier’s side by days or weeks, especially if the invoice arrives late, or if you follow a three-way match policy (purchase order + goods receipt + invoice).

Where do variances naturally come from?

• Recording timing: the supplier records on the 30th of the month, you record on the 3rd of the next month, and the same item appears in two different periods.
• Discount classification: the supplier deducts the discount from the invoice value, you record it as separate discount income, producing an apparent difference in the invoice net.
• Recording currency: the supplier issues an invoice in USD, you record in SAR at a specific exchange rate, then settle at a different rate due to currency fluctuation.
• Bank charges: on international transfers, the bank takes a fee. You record the full amount as payment, the supplier receives less and records less.

The goal of reconciliation is not to make the two statements identical in form, but to make the final balance match after accounting for all timing items and explained variances. The double-entry principle your accounting cycle depends on is built on this match. Anyone who has not internalized double-entry bookkeeping will struggle to read and interpret a reconciliation variance correctly.

Common variance types and how to treat them in the books

The most exhausting challenge in reconciliation is classifying the variance correctly before making the accounting decision. Each variance type triggers a different journal entry, and some types need no entry at all:

1. Invoice missing from your records

The supplier recorded an invoice that never reached you, or arrived but was not recorded. Action: obtain a certified copy of the e-invoice, verify the QR code and UUID, record the invoice in the correct period (issue date, not receipt date), and post:

• Dr. Inventory or Expenses (at full pre-VAT value)
• Dr. VAT (Input)
• Cr. Supplier Account (at the post-VAT total)

2. Payment missing from the supplier’s statement

You sent a bank payment, the supplier did not record it or did not link it to an invoice. Action: no new entry in your books (the payment is already recorded on your side). Send the supplier the transfer advice, reference number, and transfer date, and ask for confirmation and a formal receipt voucher. If the period ends without supplier acknowledgement, pause dealings temporarily until the issue is resolved. Delaying turns the payment into a disputed item at the annual close.

3. Variance in invoice value

The invoice is 11,500 SAR on the supplier’s side and 11,000 SAR on yours. The cause could be an early-payment discount applied unilaterally, a quantity error, or a different price. Action: refer to the purchase order (PO) as the reference, identify the party at fault, request an adjustment note (Credit Note or Debit Note) for the difference, and post the note:

• If the variance is in your favor (supplier overstated): Dr. Supplier Account, Cr. Inventory or Expenses, Cr. Input VAT (partial reversal).
• If the variance is in the supplier’s favor (you understated): an additional entry following the same mechanics as a new invoice, for the value of the difference only.

4. Unrecorded return

Goods were returned to the supplier but neither party issued a credit note. Request a formal credit note carrying a UUID and a reference to the original invoice. Record the note with a reversing entry:

• Dr. Supplier Account (at the total)
• Cr. Inventory (at the full pre-VAT value)
• Cr. Input VAT (at the reversed VAT amount)

Remember: reversing input VAT on a return credit note is mandatory under VAT law, and skipping it triggers a later claim from ZATCA. For a deeper dive into input and output VAT, see VAT in Saudi Arabia.

5. Timing variances

These are the most common and easiest to handle: a payment recorded on the 31st of the month on your side reaches the supplier on the 2nd of the following month. No entry required, just document the item as a “timing item” with the supporting document, and it will self-clear in the next period’s statement. The key point: do not ignore it, document it so it is understood in the next review.

6. Exchange-rate variances

When dealing with suppliers outside the Kingdom in USD or EUR, the FX difference between the moment the invoice is recorded and the moment the payment is settled produces a real difference in SAR. Action: compute the difference and post it to a separate “FX gain/loss” account so it does not contaminate the supplier balance. Details in the foreign-currency section below.

7. Late fees and discounts

The supplier may issue a notice for an annual loyalty rebate, a service fee, or a late-payment penalty. Each item needs to be classified into a separate account: other income for earned rebates, administrative expenses for fees, and late-payment penalties in a sub-account under expenses.

Detailed steps for supplier account reconciliation

The infographic above summarizes the six steps. Practical application needs additional detail at each step:

Step 1: Request the official supplier statement

Send the supplier a formal request (email or letter) with a precise period (for example: 1 Muharram to 30 Safar 1447 AH, or 1 July to 30 September 2025 AD). Request the statement in Excel or CSV format that can be processed, not PDF only. Include your own invoice register from your side in the request as a courtesy to save mutual time. Larger suppliers usually issue the statement automatically on the first day of the month.

Step 2: Pull an internal statement from your accounting system

Open your accounting system, go to the supplier account under AP, and select the same period. Export a detailed report of every transaction. In a modern accounting software like Qoyod, this report is one click away and uses standardized columns aligned with the e-invoice supplier statement, which makes automated matching easier.

Step 3: Line-by-line matching

Put the two statements side by side. Start by matching unique numbers: invoice number, credit note number, receipt or payment voucher number. Each item that matches another is checked off, and each item without a counterpart is moved to the variance list. Do not get caught up in values at this stage, focus on presence first.

Step 4: Variance analysis and classification

For every item on the variance list, set the classification per the infographic table above. Attach the supporting document (invoice PDF, transfer advice screenshot, credit note image). Distinguish between substantive variances (which need a corrective entry) and timing variances (which self-clear in the next period).

Step 5: Communicate and align with the supplier

Send a variance summary to the supplier’s accounts contact. Be precise in wording: “On your statement dated … item … for … appeared and we did not record it. We need a certified invoice with a UUID.” Ask for a written reply, do not settle for phone calls. Larger suppliers run a ticket system to manage this correspondence. Do not post reconciliation entries before a formal confirmation arrives.

Step 6: Post reconciliation entries and approve the balance

In your accounting system, post a single multi-line reconciliation entry that aggregates every adjustment the supplier approved. Each line in the entry carries an explanation that links it to its external document (credit note number …, receipt number …). After approval, pull a fresh internal statement, confirm it matches the supplier’s statement, then archive the final version signed by both parties as the period-close document. For a broader review of reconciliation entry structures, refer to the trial balance and adjusting entries.

Linking reconciliation to accounts payable (AP) and VAT

Supplier reconciliation is not a standalone process, it is a link in a larger chain that starts at the purchase order, runs through goods receipt, ends with the invoice entry in the supplier account under AP, and then with the payment. Reconciliation comes at the end of each cycle to confirm that every link ran accurately.

The full AP cycle

1. Issuing an approved purchase order (PO).
2. Receiving the goods and preparing a goods-receipt note.
3. The invoice arrives from the supplier.
4. Three-way match: PO, goods receipt, invoice.
5. Approving the invoice and posting it to the supplier account.
6. Payment per the settlement terms (for example: net 30 days).
7. Periodic reconciliation against the supplier statement.

Any flaw in one of the seven steps shows up in the reconciliation as a variance. That is why integrating the accounting system with the procurement system is essential. If you use a separate procurement system, make sure it talks to your accounting system over an API, or at least through periodic export and import.

The impact of reconciliation on the VAT return

ZATCA requires the VAT return to include a separate section for input VAT. This tax can be recovered only if it is supported by valid tax invoices, issued by VAT-registered suppliers, carrying the company’s name and address accurately, and tied to taxable activities.

Any unrecorded return = input VAT claimed on goods you no longer hold = audit risk. Any duplicated invoice in your records = input VAT claimed twice = an immediate penalty when discovered. Supplier reconciliation is the filter that ensures your tax return is built on clean data. Do not settle for self-review before submitting the return, make reconciliation of major suppliers a precondition for preparing it.

Worked example: a monthly supplier reconciliation in Saudi numbers

Let’s see the idea in practice. “Al Nukhba Trading” in Riyadh deals with a key raw-materials supplier called “Industrial Supply Factory.” In September 2025, the activity recorded across the two systems was:

Supplier statement (Industrial Supply Factory)

• Opening balance on 1 September: 87,400 SAR (credit).
• Invoice 4521 dated 3 September: 23,000 SAR (pre-VAT) + 3,450 VAT = 26,450 total.
• Invoice 4598 dated 14 September: 18,200 SAR + 2,730 VAT = 20,930 total.
• Credit note CN-118 dated 20 September: 4,500 (return value) + 675 VAT reversed = 5,175 total, deducted.
• Payment receipt dated 7 September: 50,000 SAR.
• Payment receipt dated 28 September: 30,000 SAR.
• Closing balance on 30 September: 49,605 SAR (credit).

Calculation: 87,400 + 26,450 + 20,930, less 5,175, less 50,000, less 30,000 = 49,605 SAR.

Internal account statement (Al Nukhba Trading)

• Opening balance on 1 September: 87,400 SAR (credit).
• Invoice 4521 posted on 4 September: 26,450 total.
• Invoice 4598 posted on 16 September: 20,930 total.
• Payment voucher 5012 dated 7 September: 50,000 SAR.
• Payment voucher 5089 dated 28 September: 30,000 SAR.
• Payment voucher 5104 dated 30 September: 10,000 SAR (evening bank transfer).
• Closing balance on 30 September: 44,780 SAR (credit).

Calculation: 87,400 + 26,450 + 20,930, less 50,000, less 30,000, less 10,000 = 44,780 SAR.

Variance analysis

The gap between the two statements = 49,605, less 44,780 = 4,825 SAR. Matching line by line surfaces two causes:

• Credit note CN-118 (5,175 SAR): recorded on the supplier side, not recorded in our books. Cause: the warehouse team returned the goods but the credit note never reached the accounting team. Action: a full reversing entry.
• Payment of 10,000 SAR on 30 September (voucher 5104): recorded on our side, not yet on the supplier statement. Cause: the transfer left late on 30 September, the supplier received it on 1 October. This is a timing variance with no journal entry required.

The logical reconciliation = 5,175 (return not recorded by us), less 10,000 (payment not yet on the supplier side) = negative 4,825 SAR, which exactly equals the accounting variance. The two statements match logically once the return is recorded.

The reconciliation entry in our books

Note: recording credit note CN-118 dated 20 September reverses the goods value and the input VAT. After this entry, the adjusted balance = 44,780, less 5,175 = 39,605 SAR, and once the 30 September payment appears on the supplier’s October statement, the balance will tie to the next supplier statement.

Reconciling foreign-currency suppliers

Saudi companies that import from abroad deal with suppliers issuing invoices in USD, EUR, CNY, or JPY. This adds an extra dimension to reconciliation: exchange-rate variances.

The accounting rule

Under IFRS 21 and its counterpart in the Saudi accounting framework, a foreign-currency transaction is recorded at the spot rate on the transaction date. At settlement, the spot rate on the settlement date is used. The difference between the two rates is posted as FX gain or loss in a separate income-statement account, not in the supplier account and not in inventory.

Worked example

An invoice from a German supplier for 10,000 EUR on 1 June, when the rate was 1 EUR = 4.10 SAR, equals 41,000 SAR recorded in the supplier account. At settlement on 15 July, the rate is 1 EUR = 4.05 SAR, so 40,500 SAR is actually paid. The difference = 500 SAR in our favor, posted as “FX gain.”

Reconciling with the foreign supplier

The supplier statement is in the original currency, your records are in SAR. Reconciliation starts by matching the figures in the original currency first (10,000 EUR invoice, 10,000 EUR payment, zero FX variance in the original currency). If they match in the original currency, the SAR difference is purely FX-driven and has nothing to do with the supplier. This approach protects you from arguments along the lines of “why did you send less or more than I asked” with a supplier who does not follow SAR conversion mechanics.

For companies that import heavily, we suggest opening sub-supplier accounts by currency, running reconciliation in the original currency, then aggregating FX differences into a single dedicated account at the company level. This simplifies financial statement preparation and keeps the supplier balance clean from differences unrelated to the actual commercial relationship.

The most common mistakes in supplier reconciliation

• Skipping returns: the warehouse returns goods, the note never reaches the accounting team, and your liabilities look inflated. The fix: an internal procedure that forces every credit note through the accounting system before the goods leave the warehouse.
• Not tracking partial payments: a 50,000 SAR payment is applied across two invoices of 30,000 and 25,000, leaving 5,000 unallocated. Reconciliation surfaces this, but prevention is better by linking every payment to its invoices at the moment of issue.
• Relying on the accountant’s memory: one accountant runs 20 suppliers in their head, leaves, and half the knowledge walks out with them. Written documentation of every note on every supplier is the line between a professional company and an ad hoc one.
• Postponing reconciliation until year-end: bundling 12 months of errors into a two-week scramble is a fundamental mistake. Monthly reconciliation costs hours, annual reconciliation of accumulated errors costs days and audit notes.
• Confusing the inventory statement with the supplier statement: inventory measures “what I have,” the supplier measures “what I owe.” Mixing them corrupts both.
• Not documenting verbal agreements: a phone call with the supplier to resolve a 1,200 SAR variance, and six months later the same variance shows up again because nothing was written down. Every understanding is sealed with a written email.
• Posting variances to a “miscellaneous adjustments” account: a vague account that swallows every variance with no detail becomes an accounting trash bin. Every variance deserves precise classification in its correct account.

Reconciliation and tax and zakat compliance

Supplier reconciliation is a pillar of compliance with ZATCA. When auditing tax returns, the authority asks for:

• A detailed input VAT breakdown for each supplier, with copies of the source e-invoices.
• Proof that the invoices were issued by suppliers actually registered for VAT (the registration number can be verified through the authority’s app).
• Credit notes that reduced input VAT in later periods.
• Reconciliation statements signed by major suppliers.

Regular reconciliation keeps this file submission-ready at any time without extra work. A company that reconciles only on demand finds itself in a frantic race against time at any audit request, and may end up paying off variances by mistake for fear of penalties. To dig into the legislative framework of the tax, review cloud e-invoicing in Saudi Arabia.

How Qoyod reconciles supplier accounts automatically

Everything we discussed above consumes hours per month per supplier when done manually. The Qoyod accounting platform is designed to compress this cycle through four integrated layers:

• Unified supplier record: every supplier has a file containing their data, tax registration number, branches, bank accounts, payment terms, and framework agreements. Every new invoice, payment, and credit note is posted automatically inside one supplier file.
• Reconciliation-ready statement: at any moment, export a supplier statement for any period with a single click, using the same standardized columns the supplier’s e-statement uses, which makes automated matching simple.
• Integration with the e-invoicing system: every purchase invoice recorded in Qoyod is linked to its UUID reference and QR code, so verifying an invoice’s validity is automated.
• Ready-made reconciliation entry templates: when a variance is spotted, you can create a reconciliation entry from a pre-configured template (return, discount, FX), which sets the debit and credit accounts automatically and prevents an unbalanced entry.

The added benefit shows up in preparing the tax return. Qoyod extracts the input VAT from each supplier invoice, nets it against the input VAT reversed on returns, and presents you with the net tax ready for the ZATCA return. This turns a process that used to consume a week into half a day. For anyone running their books from scratch for the first time, review bookkeeping for small businesses to see how recording the invoice at the start ties into reconciliation at the end.

Frequently asked questions about supplier reconciliation

What is the difference between supplier reconciliation and supplier invoice matching?

Matching is a single-invoice operation (three-way matching between a purchase order, a goods receipt, and an invoice). Reconciliation is a period-level operation covering every transaction with the supplier. Single-invoice matching is the condition, periodic reconciliation is the guarantee.

Can the fiscal year be closed without the supplier signing the reconciliation statement?

Legally yes, professionally no. The supplier’s signature on the reconciliation is a mutual acknowledgement of the balance that protects you from any later claim. Large suppliers issue an annual “balance confirmation letter,” and you should make sure it sits in the annual close file.

How do we handle a very small variance (under 50 SAR) in reconciliation?

Immaterial variances can be posted to a “miscellaneous reconciliation differences” account, provided the account does not accumulate beyond an acceptable ceiling (usually 0.5% of the supplier’s annual activity). Above that, the cause of the variance must be investigated.

Is supplier reconciliation required for local suppliers only, or for foreign suppliers too?

It is required from all of them, but reconciling foreign suppliers is more complex because of FX variances and international bank fees. Monthly reconciliation of large foreign suppliers offers extra protection against currency volatility.

What do we do if the supplier refuses to sign the reconciliation statement?

Send the statement formally (registered email or letter), give the supplier 15 days to respond, and if no response arrives treat the statement as approved (implied acceptance) and keep the correspondence as evidence. In a later legal dispute, that correspondence is strong evidence of good faith.

Do I need reconciliation if I use an integrated accounting system?

Yes. The accounting system guarantees the accuracy of your internal records, but it cannot guarantee that the supplier posted the same data into their system. Reconciliation by its nature takes place between two separate systems, and no internal automation, however efficient, can substitute for it.

Start reconciling your company’s suppliers today

Supplier reconciliation is not a secondary accounting task, it is a pillar of the accuracy of your financial statements, the integrity of your tax return, and the health of your relationship with your commercial partners. Download the attached template, apply it to your top 5 suppliers this week, then tie the cycle into Qoyod to run monthly reconciliation in minutes rather than hours.