Free Supplier Statement Generator

Supplier Statement Reconciliation: Why Statements Differ from Your Records

A supplier statement lists every invoice the supplier believes you owe, every payment they have received from you, and the resulting balance — from their perspective. Supplier statement reconciliation is the process of comparing that statement against your own AP records to identify and explain any differences. It is one of the most important controls in accounts payable, yet it is routinely skipped by AP teams under time pressure. The cost of skipping it can be significant: duplicate payments, missed invoices, and unrecorded credits all go undetected without a reconciliation.

Differences between a supplier statement and your records almost always fall into one of four categories: invoices the supplier has raised that you have not yet received or processed; payments you have made that the supplier has not yet applied to your account; credit notes issued by the supplier that are not in your system; or genuine errors on one side (duplicate invoices, incorrect amounts, payments applied to the wrong invoice). Most of these are timing differences that resolve themselves in the following period — but they must be documented and reviewed, not ignored.

The ATO expects businesses to maintain accurate creditor records that reconcile to supplier statements. During a GST audit, the ATO will compare your input tax credits claimed against supplier tax invoices. If an invoice appears on a supplier's statement but not in your records, you may have claimed GST without a valid tax invoice — which is a compliance risk. Conversely, if you have paid an invoice that is not on the supplier's statement, you need to confirm the payment has been received and correctly applied.

How to use this supplier statement generator

1. Enter your business name and contact details as the supplier, along with your customer's account details and the statement period.
2. Add each transaction — invoices issued, payments received, and any credit notes — with the date and amount. The running balance and aging summary update automatically.
3. Review the totals against your accounts receivable ledger to confirm the statement is accurate before sending.
4. Download as PDF and send to your customer with your month-end statement run. Retain a copy for your AR records.

Why does the supplier statement balance differ from what is in Xero or MYOB?

The most common reason is a timing difference: the supplier has raised an invoice or applied a payment in their system that has not yet been processed in yours. Check whether the items on the statement that do not appear in your records are in your email inbox awaiting processing, or whether you have paid amounts that the supplier has not yet allocated. Always investigate rather than assuming the supplier is wrong — the statement may reveal invoices you legitimately owe but have not yet received.

How often should supplier statement reconciliation be done?

Monthly reconciliation for all key suppliers is the minimum standard. For high-volume or high-value suppliers, reconcile every statement received — which may be more frequent. Businesses in construction and manufacturing often deal with suppliers who issue weekly or fortnightly statements. Building reconciliation into the regular AP cycle prevents small discrepancies from compounding into large, hard-to-unwind errors.

What should I do if a payment I made is not on the supplier statement?

Contact the supplier with your remittance advice — the document or email you sent when making the payment, showing the amount, date, and the invoice reference it relates to. Payments are sometimes applied to the wrong invoice, banked against a different entity (particularly in group structures), or simply not yet processed. Ask the supplier to confirm receipt and provide a corrected statement showing the payment. Do not make a further payment against the same invoice until the discrepancy is resolved in writing.