Supplier Statement Reconciliation: Find Missing Credits Before You Pay
THURSDAY BUSINESS
Check the credits before the payment leaves your account
A practical supplier statement reconciliation can catch missing documents and explain differences before you approve the payment run.
A supplier statement arrives, the balance looks familiar and the next payment run is approaching. Before approving the transfer, check whether your records tell the same story. A credit for returned materials or an agreed correction may appear on the statement but still be missing from your bookkeeping.
Supplier statement reconciliation means comparing the supplier’s record with your own bills, credits and payments, then explaining the differences. It is a practical check before money leaves the business, particularly when several people place orders, receive deliveries and process invoices.
Start with the same date
Use the statement’s closing date when comparing balances. A statement dated 30 September and a supplier balance viewed on 15 October may differ simply because October transactions have been added.
Gather the statement, the supplier’s invoices and credit notes, your supplier transaction report, and payment records. Check that you have the correct supplier account. If the statement lists an opening balance, trace unresolved items back to the previous reconciliation rather than assuming that opening figure is correct.
In Xero, the Supplier Bill Activity report shows bills, credit notes, overpayments and prepayments for a chosen supplier and period. Use the relevant dates and report settings when assembling your comparison. Xero: Contact transactions reports
Compare the individual items
Work through document references and amounts, not just the closing total. Look for:
- An invoice on the statement that has not been entered in your books.
- A bill entered twice under slightly different references.
- A payment in your records that the supplier has not yet allocated.
- A credit note shown by the supplier but missing from your records.
- A credit you hold that is absent from the statement or has not been applied as expected.
A matching total alone is not a complete check: two errors can offset each other. Record each difference with its document number, amount, explanation and next action. Keep genuine timing differences separate from errors that need correction.
A fictional example: the missing $330 credit
A small landscaping business has three unpaid bills from one materials supplier:
- Invoice 4101: $1,100.
- Invoice 4128: $880.
- Invoice 4160: $660.
Its bookkeeping shows $2,640 outstanding at 30 September. The supplier’s statement for the same date shows $2,310.
Checking the individual lines reveals credit note CN205 for $330, issued for returned materials. The business has the return paperwork, but the supplier’s credit note was sent to an employee and never reached the person processing bills.
The bookkeeper obtains the credit note, checks the supplier and original invoice, confirms it has not already been recorded or used, and records it against the correct supplier account. After applying the credit to the relevant bill, the amount outstanding is $2,310: $2,640 less $330.
For this example, all remaining bills are due, the credit is valid and available, and there are no later payments or other adjustments. The approved payment would therefore be $2,310. Paying the original bookkeeping balance would send $330 more than the reconciled amount owed.
These figures are fictional document totals. The example illustrates reconciliation only, without calculating GST or advising on tax treatment.
Record the credit, then check its application
Finding a difference is only part of the job. Keep the supplier-issued document and record the correction properly so the next report is reliable.
Xero explains that applying a supplier credit to a bill reduces the amount due on that bill. Its guidance also distinguishes a credit allocated to a bill from a credit reconciled against a bank statement transaction. Follow the method appropriate to the actual transaction rather than entering an unexplained balancing adjustment. Xero: Apply a supplier’s credit to a bill
In QuickBooks Online, supplier credits can be entered and applied when paying bills. Intuit’s Australian instructions specifically tell users to verify the Credit Applied amount. Check the resulting payment rather than assuming that an available credit has been applied exactly as intended. QuickBooks: Enter supplier credits and refunds
Do not create a credit merely because you expected one. If the supplier has not confirmed the adjustment, ask for clarification and the supporting document. Keep the query visible and agree how disputed amounts will be handled before changing the payment.
Approve today’s payment using today’s information
Once the statement date is reconciled, check for payments, credits or corrections recorded since that date. Then review which bills are actually due under the agreed terms. A reconciled statement balance is not automatically the amount to pay today.
Keep the statement, supporting documents and a short reconciliation note together. This makes it easier for someone else to understand the payment decision and follow up unresolved items. business.gov.au identifies business expense records, creditor records and bank records as important parts of business record keeping. business.gov.au: Record keeping
Make this check part of your payment approval routine for suppliers you buy from regularly. Confirm the documents, resolve the differences, check the credits and approve the amount due. Catching a missing credit before payment is simpler than tracing an unnecessary overpayment afterwards.
Build it into your bookkeeping routine
For regular suppliers, keep a consistent check alongside your month-end bookkeeping checklist. Assign someone to collect missing credit notes, resolve differences and record the approval, so the same issue does not carry into another payment run.
Support with the books behind your payments
365 Bookkeeping and BAS provides bookkeeping support from Penrith, Western Sydney, with remote support Australia-wide. View the current service inclusions and fees to see what suits your business.
General information only. The example uses fictional records and does not provide personalised tax, legal or financial advice. Check your actual documents, supplier terms and software settings before approving a payment.