Supplier statement reconciliation

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

1. Your two files

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.

What you get back

Matched

On both sides with the same amount. The matching rule is shown, and weak matches are marked.

Amount differs

Same document number, different amount: a mistyped bill, a price change or a partial credit.

Only on the statement

Usually an invoice you have not posted yet, or one posted to another supplier.

Only in your ledger

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.

How it works

  1. Step 1

    Export your side

    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.

  2. Step 2

    Upload both files

    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.

  3. Step 3

    Check the columns

    We guess which column is the date, number and amount from the header row. You confirm or change it before anything is matched.

  4. Step 4

    Work the differences

    Start with what is only on one side and amounts that differ. Download the result for your file or your reviewer.

How lines are matched

1. Same document number

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.

2. Same amount, close dates

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.

3. Same amount only

A last pass pairs equal amounts at any date. These are always marked to check, with how many days apart they are.

Never across directions

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.

Exporting your ledger from Xero or QuickBooks

There is no connection to either; you export a file. Use the same period as the statement.

Xero

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.

QuickBooks Online

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.

Anything else

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.

Limits and your data

  • It does not connect to Xero, QuickBooks or any accounting system. It reads the files you export, and changes nothing in your books.
  • Your ledger file is read in your browser and is not uploaded. The statement PDF is processed on our servers like any conversion: kept 24 hours in your account when signed in, then deleted.
  • Without an account you can reconcile one statement of up to 3 pages a day. A free account reads up to 5 pages a day; Pro 400 at $15 / month (up to 400 pages per month) or Scale 1000 at $30 / month (up to 1000 pages per month). The statement's pages count against the same quota as conversions.
  • Supplier statements are parsed by the same engine as bank statements with instructions for supplier documents. We have not benchmarked it on supplier statements, so check the statement lines before you act on a difference. If the statement's lines do not add up to its own amount due, that gap is shown separately.
  • One currency per reconciliation. Amounts are compared to the cent; there is no tolerance for rounding or exchange differences.
  • Open-item statements, which list only unpaid invoices, reconcile against your open bills: export your unpaid bills for that supplier rather than every transaction.

Questions

What is supplier statement reconciliation?

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.

Does it connect to Xero or QuickBooks?

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.

Which columns does my ledger export need?

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.

Is my ledger uploaded?

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.

How are invoice numbers matched when they are written differently?

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.

What if the difference is not explained by any line?

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.

Is supplier statement reconciliation free?

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.

Related