Start with the closing balance and the references
Xero users have asked for supplier statement reconciliation for years, and a 2021 Xero reply quoted in one request said there was no such function. Until one exists the check is by hand, or bought in: does the closing balance equal the sum of the lines, and does each line carry a reference you can find in the ledger? A line you cannot find is the first difference to chase.
- Closing balance against the sum of the lines.
- Each line has a reference, or is marked lower certainty.
- Credit notes on the statement are applied in the ledger.
Put a second person on every payment run
Business email compromise cost US complainants USD 2.77 billion in 2024, and duplicate or erroneous payments run at about 0.8% to 2% of disbursements in APQC data. The control that helps is separation of duties: the person who builds the batch is not the only one who checks it.
- Look for same supplier with a near-same number, amount or date.
- Compare bank details with the supplier record, not with the email asking for a change.
- Treat a first-time payee as a call-back before payment.
Decisions that are yours
What counts as the same item, what tolerance is acceptable and whether to pay are decisions for you and your approver. A list of differences is a prompt to look, not a clearance.
Which paid job fits
For a backlog of statements, the statement check lists differences with page references for one month and up to 15 suppliers, and a monthly version repeats it. For payment runs, the pre-payment check lists probable duplicates and changed bank-detail codes with evidence, and the new-supplier pack covers first payments. To find a supplier whose regular bill has not arrived, there is a separate missing-bills list; none of these jobs touches your bank or gives accounting advice.
Sources and limits
- Xero Product Ideas: AI reconciliation of supplier statements Checked 2026-10-12.
- The request was posted on 29 Nov 2023, has 50 votes and the status "submitted"; comments run to 18 Aug 2026, one from a user with over 50 monthly suppliers.
- Xero Product Ideas: supplier statement against the detailed ledger Checked 2026-10-12.
- The request was posted on 21 Oct 2025, has 31 votes, 11 comments and the status "Gaining Support"; a comment quotes a 2021 Xero Community Manager reply that there was no supplier-statement function, and the current admin reply points to the supplier bill activity report.
- FBI IC3: 2024 Internet Crime Report Checked 2026-10-12.
- Business email compromise losses for 2024 were USD 2,770,151,146 on 21,442 complaints (2023: USD 2,946,830,270 on 21,489).
- CFO.com: detect and prevent duplicate or erroneous payments Checked 2026-10-12.
- APQC data puts duplicate or erroneous payments at about 0.8% (best performers) to 2% (worst) of disbursements.
- NIST SP 800-53 AC-5 (separation of duties) Checked 2026-10-12.
- Control AC-5 divides duties among people to reduce the risk of harmful activity without collusion.