Guides
Supplier statement guides
Short, practical articles on creating a supplier statement with a running balance, reconciling it against your books, and turning a CSV/XLSX export into a sendable PDF.
How-to
How to create a supplier statement (with running balance)
Columns you need, how the balance works, and a one-minute workflow from export to print.
Reconciliation
Supplier statement reconciliation, step by step
Order of operations and six common differences to check first.
Checklist
Month-end AP checklist
Cut-off, vendor statements, running-balance proof, and AP subledger-to-GL — in close order.
From export
Supplier statement from a Xero CSV export
Export path, running balance, and a local print-ready layout.
Xero
Reconciling a supplier statement against Xero
What a supplier balance is made of, which reports show the lines, and where differences hide.
From export
Vendor statement from a QuickBooks Online export
From Transaction List by Vendor to a sendable running-balance PDF.
Mapping tip
Payable export column names
Typical Contact / Vendor / Reference / No. headers when mapping a payable export.
Concepts
Aged payables vs a supplier statement
Why the two totals never agree, and what each report actually measures.
Troubleshooting
Unmatched lines: the six usual causes
Missing bills, payments in transit, unapplied credits — and what evidence to ask for.
Template
Supplier statement template: columns, example and email wording
The columns every statement needs, a worked example, and two email drafts.
Prefer to generate the statement yourself? Open Statemint — drop any CSV/XLSX accounting export; parsing stays in your browser.