Matched
On both sides with the same amount. The matching rule is shown, and weak matches are marked.
Supplier statement reconciliation
Month end, and a supplier's statement says you owe more than your books do. Finding out why means ticking their PDF against your ledger line by line. Upload both: every line is sorted into matched, amount differs, only on their statement or only in your books, and the gap between the two balances is broken down line by line.
Goes in
The supplier's statement PDF (up to 20 MB, digital or scanned) and your ledger for that supplier as CSV or Excel
Comes out
Matched lines, amount differences, lines missing on each side, the balance difference explained, as CSV or Excel
The ledger is read in this browser and never uploaded. The PDF is processed like any conversion; without an account, one PDF of up to 3 pages a day. for longer statements.
On both sides with the same amount. The matching rule is shown, and weak matches are marked.
Same document number, different amount: a mistyped bill, a price change or a partial credit.
Usually an invoice you have not posted yet, or one posted to another supplier.
Usually a payment the supplier had not received by the statement date, or a bill entered twice.
Above the lists: the statement's balance, your ledger's balance, and the difference broken into those buckets plus any opening balance difference, so the parts add up to the gap.
Step 1
From Xero, QuickBooks Online or any system: the supplier's bills, credit notes and payments with a date, number and amount, as CSV or Excel.
Step 2
The statement PDF is read into lines: invoices, credit notes, payments, the balance brought forward and the amount due. Your ledger stays in your browser.
Step 3
We guess which column is the date, number and amount from the header row. You confirm or change it before anything is matched.
Step 4
Start with what is only on one side and amounts that differ. Download the result for your file or your reviewer.
INV-0001043, inv 1043 and 1043 are the same number: case, spaces, leading zeros and prefixes such as INV, BILL, CN and PMT are ignored. Numbers shorter than 3 characters are not trusted. An invoice you posted in two parts matches when the parts add up.
Lines with no shared number, such as a payment, match on the exact amount when the dates are within 7 days. If another line could have taken the place, the pair is marked for you to check.
A last pass pairs equal amounts at any date. These are always marked to check, with how many days apart they are.
An invoice only matches a bill, and a payment or credit note only matches a payment or credit. Your ledger's sign convention is worked out from the matches, or you set it.
There is no connection to either; you export a file. Use the same period as the statement.
Any Xero report that lists the supplier's bills, credit notes and payments with date, reference and amount, exported to Excel or CSV. Reports with Debit and Credit columns and an opening balance row are read as they are.
A vendor report listing the supplier's bills, bill payments and vendor credits with date, number and amount, exported to Excel. A transaction type column tells us which way each amount goes.
Any CSV or Excel file with one row per document: a date or a number, and an amount or debit and credit columns. Up to 5 MB. Titles above the header row are skipped.
Checking the statement a supplier sends you against your own accounts payable ledger for that supplier, so every difference between their balance and yours is explained: an invoice you have not posted, a payment they have not received, a credit note missing on one side, or an amount keyed wrongly.
No. You export the supplier's transactions from Xero, QuickBooks Online or any other system as CSV or Excel and upload that file. Nothing is read from or written to your accounting system.
A date or a document number (ideally both), and either one amount column or debit and credit columns. A description and a transaction type column help. You confirm the columns before matching, so the header names do not have to be exact.
No. The CSV or Excel file is read and matched in your browser. Only the supplier's statement PDF is sent to our servers, because reading a PDF needs the parsing engine.
Both numbers are reduced to their core first: case, spaces, punctuation, leading zeros and prefixes like INV, BILL, CN or PMT are removed, so INV-0001043 matches 1043. Numbers shorter than 3 characters are not used.
The page shows that amount separately. It means the statement's lines do not add up to its printed balance (a line was misread or not printed), or the opening balances differ because your export covers a different period. Check the statement lines and export the same period.
One statement of up to 3 pages a day needs no account. A free account reads up to 5 pages a day; paid plans are Pro 400 at $15 / month (up to 400 pages per month) or Scale 1000 at $30 / month (up to 1000 pages per month). The ledger file does not count against any quota.
Bank and card statement PDFs to rows for QuickBooks, Xero or a spreadsheet.
An .xlsx workbook from a statement PDF.
Clean bank statement rows before you reconcile.
Preparing bank statement data for a Xero import.
Preparing bank statement data for a QuickBooks import.
Statement parsing from your own scripts.