Best practices
Supplier Statement Reconciliation Best Practices: 12 Habits for AP Teams
Reconcile each important supplier’s statement before the payment run, not after it, and give every difference a cause and an owner before anything is paid. After that, judge the result by lines rather than by the total, and chase missing credit notes first, because the supplier has no reason to raise them. The remaining nine habits are how you make that happen every time.
Take a supplier like Dellacott Packaging. Its statement for 31 October says Wattleridge Hospitality owes $10,959.60, while the ledger says $8,550.70. That is a gap of $2,408.90 with the payment run due Monday 2 November. Five items explain the gap and four of them are mistakes. The gap hides them, because some push it up and some pull it down.
We make Statement Zen, which reads statements, but this page works with or without it. None of it comes from a survey. It is published guidance plus the usual ways statements go wrong, and any figure that isn’t ours has a name and a date next to it. The Dellacott amounts are made up. If you want the line-by-line method for one statement, start with the guide to supplier statement reconciliation. This page is about the team around that method.
By Michael Usov, FounderPublished Updated 22 min read
Key takeaways
- A matching total proves little. Sign off on lines: every one matched, or explained.
- Give every difference a cause, an owner and a next step. Chase missing credit notes first, because a credit is money.
- Hold the disputed line, not the whole supplier, and ring a number already on file before you pay to changed bank details.
- Log the cause by supplier. When the same supplier causes the same difference three months running, change something upstream.
On this page
The twelve habits at a glance
Short answer
What are the best practices for supplier statement reconciliation?
Check the statements of your largest and most error-prone suppliers before every payment run, the middle group monthly and the long tail quarterly. Sign off on lines rather than on a matching total, give each difference a named owner, chase missing credit notes first, and ring a number already on file before paying to changed bank details.
Get it
- 1. Reconcile before the payment runPull statements on the run’s cut-off date.
- 2. Cover every supplier, in tiersCadence follows spend and error history.
- 3. Ask for the right statement, sent to the right inboxOpen-item, dated to your cut-off, to AP.
Check it
- 4. Write the matching rules down onceReferences, timing, rounding, credit signs.
- 5. Post the supplier’s own invoice numberOne reference format, no PO numbers in it.
- 6. Judge the result by lines, not the totalA zero gap can hide two errors.
- 7. Treat a timing difference as a promise with a dateStill open on the next statement means it is real.
Fix it
- 8. Name every difference and give it an ownerYou, the supplier, or neither.
- 9. Chase missing credit notes firstA credit is cash you have not collected.
- 10. Hold duplicates and changed bank details before you payHold the line, not the supplier.
Keep it
- 11. Separate preparer from approver, and keep the fileNo plug journals.
- 12. Log causes by supplier and fix them upstreamAutomate the reading, not the judgement.
What does a supplier statement show that your ledger can’t?
Supplier statement reconciliation is the line-by-line comparison of a supplier’s statement of account with the open items in your own ledger, so that every difference has a cause and an owner.
A supplier statement is the supplier’s record of your account, and it can list things your ledger has never seen. The classic one is an invoice emailed to whoever ordered the goods, who never passed it on to AP. Another is a credit note the supplier raised and forgot to send.
Three-way matching checks an invoice against the purchase order and delivery note, so it only works on documents you already have. A statement is the one thing that can tell you about a document you don’t.
Which statement do you ask for, and when?
Nothing below works if the statement is out of date or lands in the wrong inbox.
1. Reconcile before the payment run
Most people are taught to do this at month-end, but by then the payments you care about have already gone out. If you spot a duplicate before the run, you ring the supplier and fix it. If you spot it afterwards you have to ask for the money back, and how fast that happens is up to them.
So pull the statements on the cut-off date for the run, and check them before the batch gets approved. In the Dellacott example, invoice DP-61170 for $2,118.40 was paid on 29 October but still showed as open on the statement dated 31 October. If someone builds Monday’s batch from that statement, the line looks overdue and gets paid a second time. Sending the supplier the remittance advice first lets them apply the payment before that happens.
If you pay once a month, the run and the month-end fall on the same day and the habit is the same.
2. Cover every supplier, in tiers
We found no published standard for how often to reconcile. Two vendor guides we read on 30 Oct 2026 give a rule of thumb. Solvexia says monthly is standard and weekly for high-volume suppliers, and Fiscaltec says monthly or quarterly. Those are vendor opinions, not standards.
I’d split suppliers three ways. The biggest ones, and the ones that get things wrong most often, are checked before every payment run. So is any supplier in its first three months, and anyone whose bank details have just changed. The middle group gets a monthly check. The long tail gets a quarterly one, plus a look whenever a balance jumps for no obvious reason. Treat those cut-offs as a starting point, because the right ones depend on how many suppliers you have and how often they slip. The cadence table in the checklist guide has a fuller version.
I wouldn’t drop the long tail altogether, unless it’s a supplier you only buy from once a year. Low and mid spend suppliers don’t get looked at much, so forgotten credits tend to build up there.
3. Ask for the right statement, sent to the right inbox
If the supplier gives you a choice, take the open-item statement, the one that lists only what is unpaid. A balance-forward statement rolls everything into a running total and the old items get lost in it, which is usually where the disputes start. If balance-forward is all they do, ask for an aged list of open items as well. And ask for it as at your cut-off date, because most systems default to whatever day someone pressed print.
Then fix where it arrives. Statements sent to the buyer who placed the order tend to sit in that person’s inbox. Give each supplier a shared AP address and ask them to send it there.
Some suppliers send nothing, usually the small ones. Print their account from your ledger as at your cut-off, send it, and ask them to confirm or correct it. It is slower, and it still finds the same differences.
Decision flow. On cut-off day, ask whether the supplier sent a statement. Without a statement, print the account from your ledger and ask the supplier to confirm it. With one, check whether the supplier is in the top tier, is new, or has changed bank details. Those suppliers are reconciled before this run, and the rest on the monthly or quarterly schedule.
- 1Payment run cut-off date
- 2DecisionDid the supplier send a statement?Yes: go to step 3No: go to step 4
- 3DecisionTop tier, new, or bank details just changed?Yes: go to step 5No: go to step 6
- 4Print the account from your ledger, send it, ask for confirmation
- 5Reconcile before this run
- 6Reconcile on the monthly or quarterly schedule
- 7Every difference has a cause and an owner
Write the rules before you match
Two people on the same team will match the same statement differently until the rules are written down, and you usually find that out when one of them is on leave.
4. Write the matching rules down once
Keep it to one page with one owner, and review it once a year. Its first line is the opening balance: the statement’s opening balance should equal the closing balance you agreed on last month’s statement, and if it doesn’t, stop there and find out why before matching anything. On a balance-forward statement that is one figure to tie to last month’s close. An open-item statement has no running opening balance, so the same test is that every item it carries over is one you already agreed last month. After that it says which reference counts and how prefixes, spaces and leading zeros are handled, so DP-61204 and 061204 read as the same invoice. It says a payment in transit is one released on or before the statement date, which rounding gap you ignore (usually a few cents), and that credit notes are negatives on both sides.
Without it, every reviewer re-argues the same points on every supplier, and the reference rules cause most of the arguments.
5. Post the supplier’s own invoice number as the reference
This one is for whoever keys bills. The reference field should hold the number printed on the supplier’s invoice, exactly as printed, and nothing else. Put your purchase order number somewhere else.
In the example, DP-61204 for $2,713.00 was posted on 6 October and then posted again on 7 October as 061204, perhaps from a second copy of the same email. A duplicate check that compares references won’t see that DP-61204 and 061204 are the same invoice. The statement listed it once, which is how the second posting showed up.
6. Judge the result by lines, not the total
Make “every line matched or explained” the sign-off test, not “the balances agree”. A missing invoice and a missing credit of the same amount cancel out inside one total, and the total looks fine.
The Dellacott gap is $2,408.90, and it’s tempting to read that as one problem when there are five. Three of them push the gap up by $5,666.40 between them and two push it down by $3,257.50. Add the five amounts without their signs and you get $8,923.90. So the size of the gap doesn’t tell you much about how much is wrong. There is a list of causes and fixes by symptom in the guide to common statement problems.
7. Treat a timing difference as a promise with a date
A payment in transit is a real reason for a gap, and a dangerous place to stop thinking. Log it with the date you released the payment and the date you expect the supplier to apply it. Send the remittance PDF so they can.
If it’s still open on the next statement, it isn’t timing any more. It’s a real difference, and you’ve lost a month finding that out.
What do you do with the differences you find?
Once the differences are on the list, someone has to own each one.
8. Name every difference and give it an owner
Each difference needs a cause, a person and a next step. “Unreconciled” is not a cause. ACCA’s technical article lists the usual six, and they are a good starting vocabulary for the log.
Swipe sideways to see every column.
| Reason | What you see | Who acts | Habit |
|---|---|---|---|
| Payment in transit | Paid on your side, still open on the statement | Neither, until the supplier applies it | 1 and 7 |
| Invoice posted to the wrong supplier | On their statement, missing from this supplier’s ledger account | You | 8 |
| Credit note not processed | Credit on the statement, nothing in your ledger | You | 9 |
| Debit note not processed | Charge or return on one side only | You or the supplier, depending on who raised it | 8 |
| Discount wrongly accounted | Same invoice, different amount, gap equals the discount | You | 4 and 6 |
| Transposed digits | Statement shows 1,968.00, ledger shows 1,698.00 | You | 6 |
| Duplicate posting (ours) | Same invoice twice in the ledger, once on the statement | You | 5 and 10 |
| Invoice never reached AP (ours) | On the statement, nowhere in the ledger | You | 3 |
The last two rows are in the Dellacott example below, which is why they are in the log alongside ACCA’s six.
9. Chase missing credit notes first
A missing invoice turns up eventually, because the supplier chases you for it. Nobody chases you for a missing credit, so the money only comes back if you ask.
Credit note DP-C0307 for $544.50, dated 21 October, appeared on the Dellacott statement but wasn’t in the ledger at all. Ask the supplier for a copy, quoting the number and date, and say when you need an answer. The guide to missing credit notes and duplicate payments has an email you can copy, and also covers what to do if the supplier says there is no such credit.
A short query needs only five details, and the supplier can answer each one without a phone call. For the Dellacott credit they would be:
- Statement date: 31 October 2026.
- Credit note number: DP-C0307, dated 21 October 2026.
- Related invoice: the invoice it reverses, if the supplier’s copy names one.
- Amount: $544.50 credit.
- Reply by: a date before the payment run, such as Monday 2 November.
10. Hold duplicates and changed bank details before you pay
Hold the disputed line, not the whole supplier. Pay what you agree on and park the rest. Stop a supplier over a $270.00 keying error and their warehouse will stop shipping to you before you’ve fixed it.
A duplicate that has already been paid can be recovered by you, or by a recovery audit firm that chases the same duplicates for a share of what comes back.
Changed bank details are different, and nothing gets paid until they are confirmed. In April 2024 the Australian Competition and Consumer Commission urged people to check payment details directly with a business before paying an emailed invoice, by calling a number they found themselves. Apply the same thinking to statements. If a statement or invoice arrives with new account details, or from an address you haven’t seen before, ring the number already on your supplier file.
Combined data from Scamwatch, ReportCyber and three other reporting bodies. The 2024 figure in the same report is $152.6 million. Last checked 30 Oct 2026. Source: National Anti-Scam Centre: Targeting scams report 2025 (published 30 Mar 2026), .
Swipe sideways to see every column.
| Sign | What to do |
|---|---|
| Bank details differ from your supplier file | Ring a number already on file. Do not use the number in the email. |
| New contact name or email domain | Compare the sender domain with the one on your last paid invoice. |
| Pressure to pay before the usual run | Treat the pressure as a reason to wait for the callback. |
| Statement arrives from a different address than before | Ask the usual contact whether they sent it. |
Review, file and log
The last two habits are about what you leave behind.
11. Separate preparer from approver, and keep the file
The person who prepares the reconciliation should not be the person who approves the payment run it feeds. That is ordinary segregation of duties. The audit view is in the guide to reconciliation as an internal control.
Don’t post one net “difference” journal to make the numbers agree. It buries the causes you just spent an hour finding.
The file for each supplier and period holds six things.
- The statement exactly as received.
- The ledger report, with the date and time you ran it.
- The line-by-line match.
- The cause and owner of each difference.
- The supplier correspondence, including remittances sent.
- The approver’s name and the date.
If you work alone, the next best thing is to review your own work the following day, and to let the owner see the log once a month.
12. Log causes by supplier and fix them upstream
Keep the log simple: supplier, statement date, cause, amount, owner and days to clear. Every quarter, sort it by supplier and see who keeps turning up. If one supplier causes the same kind of difference three months in a row, the fix probably isn’t on the statement. Maybe their invoices keep going to the buyer instead of the AP inbox, or the same person keeps keying their bills wrong.
If you automate anything, automate the reading and the matching, because those are mechanical. Leave the decisions to a person: whether to pay, hold, chase or write off.
If you would rather start in a spreadsheet, there is a reconciliation template, and the workbook below has a log sheet ready to use.
Free download: supplier statement reconciliation workbook
Free, no sign-up, works offline. Excel workbook for matching one statement against your ledger.
Excel workbook (.xlsx)
Five differences, seven habits
Here is the Dellacott statement from the start of the page, with made-up amounts. It prints the month’s activity, so it opens at nil, the balance both sides agreed in September. One October invoice and the payment that cleared it match on both sides. In the check that follows, each note names the habit that would have caught the line before Monday’s run, and seven of the twelve habits come up.
A supplier statement with a nil opening balance, six invoices, one payment and one credit note. The closing balance is 10,959.60. Four lines carry numbered markers for the differences found against the ledger.
Swipe sideways to see every column.
Dellacott Packaging Pty Ltd
Account WH-2241, customer Wattleridge Hospitality
Statement of account
31 Oct 2026
| Date | Reference | Description | Debit | Credit | Balance |
|---|---|---|---|---|---|
| 01 Oct | BF | Balance brought forward | 0.00 | ||
| 02 Oct | DP-61102 | Invoice | 4,215.00 | 4,215.00 | |
| 03 Oct | DP-61170 | InvoiceNote 1 | 2,118.40 | 6,333.40 | |
| 05 Oct | DP-61204 | Invoice | 2,713.00 | 9,046.40 | |
| 14 Oct | DP-61219 | InvoiceNote 2 | 1,968.00 | 11,014.40 | |
| 16 Oct | PMT | Payment received, DP-61102 | 4,215.00 | 6,799.40 | |
| 20 Oct | DP-61233 | InvoiceNote 3 | 3,278.00 | 10,077.40 | |
| 21 Oct | DP-C0307 | Credit noteNote 4 | 544.50 | 9,532.90 | |
| 28 Oct | DP-61251 | Invoice | 1,426.70 | 10,959.60 | |
| Balance due | 10,959.60 | ||||
- Note 1Still open here, though Wattleridge paid it on 29 October.
- Note 2The ledger holds 1,698.00, with two digits swapped.
- Note 3Not in the ledger. The invoice never reached AP.
- Note 4Not in the ledger. The credit note was never posted.
Swipe sideways to see every column.
| Reference | Status | Statement | Ledger | Note |
|---|---|---|---|---|
| Opening balance, 1 Oct | Matched | 0.00 | 0.00 | Ties to the September close (habit 4) |
| DP-61102 | Matched | 4,215.00 | 4,215.00 | |
| Payment of DP-61102 | Matched | −4,215.00 | −4,215.00 | |
| DP-61170 | Missing | 2,118.40 | not listed | Paid 29 Oct, supplier has not applied it (habits 1, 7) |
| DP-61204 | Matched | 2,713.00 | 2,713.00 | |
| 061204 | Query | not listed | 2,713.00 | Same invoice posted a second time (habits 4, 5) |
| DP-61219 | Differs | 1,968.00 | 1,698.00 | Keyed with digits swapped (habit 6) |
| DP-61233 | Missing | 3,278.00 | not listed | Invoice never reached AP (habit 3) |
| DP-C0307 | Missing | −544.50 | not listed | Credit note not posted (habit 9) |
| DP-61251 | Matched | 1,426.70 | 1,426.70 | |
| Total | 10,959.60 | 8,550.70 |
That leaves getting both sides to the same figure. On the statement, the only change is DP-61170, which the supplier has not yet applied. Everything else is ours to fix in the ledger.
Swipe sideways to see every column.
| Step | Statement | Ledger |
|---|---|---|
| Closing balance | 10,959.60 | 8,550.70 |
| DP-61170, paid 29 Oct, not yet applied | −2,118.40 | No change |
| Void second posting of DP-61204 | No change | −2,713.00 |
| Correct DP-61219 (1,698.00 to 1,968.00) | No change | +270.00 |
| Post DP-61233 | No change | +3,278.00 |
| Post credit note DP-C0307 | No change | −544.50 |
| Adjusted balance | 8,841.20 | 8,841.20 |
| Difference | 0.00 | 0.00 |
What happens to each of the five:
Swipe sideways to see every column.
| Difference | Next step | Owner | By when |
|---|---|---|---|
| DP-61170 | Send the remittance advice, then check the next statement shows it applied | AP clerk | Before the run on 2 Nov |
| Second DP-61204 | Void it in the ledger, check whether it was paid, and ask for the money back if it was | AP clerk | Before the run on 2 Nov |
| DP-61219 | Correct the keying error, with no need to contact the supplier | AP clerk | Before the run on 2 Nov |
| DP-61233 | Get the invoice approved, post it and schedule it | Buyer who ordered, then AP clerk | Approved by 2 Nov |
| DP-C0307 | Ask the supplier for a copy using the five-line query under habit 9, then post it | AP clerk | Query sent by 2 Nov |
When this advice does not fit
- Five suppliers, one payment run a month. Tiers add nothing. Reconcile all five on run day.
- A supplier that never sends statements and will not confirm an account you print. Move it to the highest tier for invoice checks instead, because you have nothing to compare against.
- A one-person finance team. Separation of duties is not possible, so replace it with a next-day self-review and a monthly look from the owner.
- Utilities and card feeds that bill automatically. A statement check is rarely where the errors are. The bank feed and the contract are.
Where do the figures come from, and what was not checked?
This page was written by the founder of Statement Zen from the sources listed at the end, and no external reviewer has read it. Check the rules against your own policy and your auditor’s requirements. Every figure on the page is gathered below with its publisher, date and type.
Swipe sideways to see every column.
| Figure | Publisher | Date | Type |
|---|---|---|---|
| Up to 10 minutes to reconcile one statement by hand, down to 1 minute | Xelix, UK retailer case study | Undated, read 30 Oct 2026 | Vendor claim |
| A large statement took up to a day and now takes about 2 hours; 15 to 20 minutes became 5 | Xelix, Mole Valley Farmers case study | Undated, read 30 Oct 2026 | Vendor claim |
| 10 to 15 minutes for one reconciliation | AWS Startups interview with Xelix | 3 Jun 2025 | Vendor interview |
| $166.8 million lost to payment redirection scams in 2025, $152.6 million in 2024 | National Anti-Scam Centre | 30 Mar 2026 | Official report |
Swipe sideways to see every column.
| Point | Publisher | Date | Type |
|---|---|---|---|
| A supplier must give an adjustment note within 28 days of being asked for one, or of becoming aware of the adjustment | GST Act 1999, section 29-75, on AustLII | Consolidated Act, read 31 Oct 2026 | Legislation |
| A decreasing adjustment needs a valid adjustment note, unless the GST involved is $75 or less | Australian Taxation Office | Last updated 14 Sep 2026 | Official guidance |
| An adjustment note must give the reason, the issue date and the supplier’s ABN | Australian Taxation Office, LI 2022/31 | Instrument of 2022, read 31 Oct 2026 | Legislative instrument |
| Reconcile regularly, for example monthly, including payables to the general ledger | CPA Australia, small business controls | Undated, read 31 Oct 2026 | Professional body |
| Supplier statements should be compared regularly with open invoices, by someone independent of invoice processing | CPA Australia, not-for-profit controls | Undated, read 31 Oct 2026 | Professional body |
| Xero’s help page on supplier credits points to the Supplier Bill Activity report for outstanding bills | Xero Central | Undated, read 31 Oct 2026 | Vendor help page |
Some things were not verified. We looked at Xero’s help and Product Ideas forum on 30 Oct 2026, but we did not check any other accounting system for a statement reconciliation feature. We read the ATO pages and the GST Act only for the adjustment note rows in the table above. Nothing here covers how to account for GST or VAT on an adjustment, and we did not read HMRC guidance. We also did not test any vendor’s time claim on a real statement.
The Dellacott example rests on these assumptions:
- All amounts are invented, in AUD, and shown as totals without a GST split.
- Statement and ledger are both cut off at 31 October 2026, and the payment run is Monday 2 November.
- The September close was agreed at nil, so the October opening balance is 0.00.
- The five differences were chosen to show the habits and are not taken from a real file.
Where Statement Zen fits
Statement Zen does the reading step. Forward a supplier statement as a PDF and the differences, such as the five behind Dellacott’s $2,408.90 gap, show in your dashboard next to the ledger lines they belong to. You still decide what to pay, hold or chase. You can try it on one statement with the free reconciliation.
Questions people ask
How often should you reconcile supplier statements?
Does three-way matching replace statement reconciliation?
What if the balances agree but the lines do not?
Does Xero do supplier statement reconciliation for me?
How long does it take to reconcile one supplier statement?
Is supplier statement reconciliation the same as bank reconciliation?
Can I reconcile supplier statements in Excel?
What do I do with old outstanding items?
About the author
Michael Usov, Founder, Statement Zen
Michael Usov founded Statement Zen, which reconciles supplier statements against your accounts payable ledger. He also runs MRU Consulting, which builds accounts payable and ERP integrations, including for construction businesses on Viewpoint Vista. For the last fifteen years he has worked with finance controllers and AP managers in construction companies, doing and automating supplier statement reconciliation and other accounting tasks.
Sources
- National Anti-Scam Centre: Targeting scams report 2025 (official, published 30 Mar 2026), read
- ACCA: Supplier statement reconciliations (professional body), read
- ACCC: Beware of fake invoices from scammers impersonating businesses (official, published 4 Apr 2024), read
- Xero Product Ideas: Supplier Statement Detailed Ledger (vendor forum, admin reply 20 Nov 2025), read
- Solvexia: Vendor reconciliation (vendor), read
- Fiscaltec: Supplier statement reconciliation best practices (vendor, updated Dec 2025), read
- Xelix: How a retailer increased statement reconciliation coverage from 15% to 95% (vendor case study), read
- Xelix: How Mole Valley Farmers achieved a 40% productivity increase (vendor case study), read
- AWS Startups: How Xelix is breaking boundaries in fintech (vendor interview, 3 Jun 2025), read
- ATO: Adjustment notes (official, last updated 14 Sep 2026), read
- A New Tax System (Goods and Services Tax) Act 1999, section 29.75: Adjustment notes (legislation, via AustLII), read
- ATO: Adjustment Note Information Requirements Determination 2022, LI 2022/31 (legislative instrument), read
- CPA Australia: Internal controls for small business (professional body, undated), read
- CPA Australia: Internal controls for not-for-profit organisations (professional body, undated), read
- Xero Central: Apply a supplier’s credit to a bill (vendor help page, undated), read
What changed
- : First published. Sources checked on this date.
- : Added habit numbers to the causes table and an opening balance with a matched payment to the Dellacott example. Added owners and deadlines, a five-line credit note query, and a table of published figures with what was not checked. Added six sources and a table of the rules and guidance behind the advice.
- : Added the Dellacott statement as a figure and inline links to six sources. Removed a 2011 forum anecdote and corrected a sentence that said we had not read ATO guidance.
Read next
- Supplier Statement Reconciliation Checklist for Month-End and Before the Payment RunDated steps for month-end and each payment run.
- 10 Common Supplier Statement Reconciliation Problems (and How to Fix Each One)Symptoms and fixes behind habits four to seven.
- Supplier Statement Reconciliation as an Audit Control: How It Gets TestedWhy an auditor treats this as a control.