Free tool · Accounts payable
Free vendor statement reconciliation tool
Paste the lines from your vendor's statement and the open bills from your books, and this page matches them by invoice number and shows every difference. It runs in your browser only, so nothing you paste is sent or saved, and it works with a list from any accounting software.
Gold tier in Intuit's ProAdvisor program. See my Intuit listing
Keeping your own books? Tallyfinch does invoices, bank import and reports on your computer. See Tallyfinch
How to get the two lists
- The statement. Copy the invoice lines from the vendor's PDF or email. Leave out the headings and the total.
- Your books. Run the open bills (unpaid bills) report for that vendor as of the statement date, and copy the invoice number and amount columns.
- Paste and compare. Use the same date for both, or timing differences will show up as mismatches.
What each result means
- On the statement, not in your books. A bill you didn't receive or didn't enter. Get a copy before you pay it.
- In your books, not on the statement. A bill dated after the statement, a payment the vendor hasn't applied yet, or a bill posted to the wrong vendor.
- Same invoice, different amount. A credit memo, a discount, tax or freight, or a part payment on one side only.
- Left unexplained. Should be zero. If it isn't, a line was skipped: check that every line has a number and an amount.
What it matches on
Invoice numbers are compared without spaces, dashes, a leading "INV" or leading zeros, so INV-01041 and 1041 are the same invoice. When a number has no match but the same amount appears on the other side, the tool points it out, because that is usually one invoice keyed two ways.
After you've found the differences
Follow the steps in our guide to reconciling a vendor statement, keep a record with the free reconciliation template, or run the whole month-end with the month-end close workbook. If reconciling suppliers is eating a day every month, our bookkeeping service does it for you.
This tool compares the lines you paste. It is general bookkeeping help, not accounting, tax or legal advice, and it can only be as right as what you enter. Check anything that matters against the vendor's own records before you pay or adjust.
Questions
Is the vendor statement reconciliation tool free?
Yes. There is no charge and no sign-up.
Is my data uploaded?
No. The comparison happens in your browser. The lines you paste are not sent to us or stored.
Which accounting software does it work with?
Any of them. It reads plain lines, so a list copied from QuickBooks, Xero, MYOB, Zoho Books, Sage, NetSuite, a construction system or a spreadsheet all work.
How does it match invoices?
By invoice number, ignoring spaces, dashes, a leading INV and leading zeros. Lines with the same number but different amounts are listed separately.
What if the vendor's invoice numbers don't match mine?
The tool flags lines where the amount matches but the number doesn't, so you can pair them by eye.
Does it handle credit memos and payments?
Yes. Type a credit as a negative amount or in parentheses and it is included in the totals.
Tallyfinch
Books you keep on your own computer
Tallyfinch does invoices, bills, bank import, reconciliation and the main reports, in a file you own. $99 once, then $5 a month for updates; the app keeps working if you stop the plan. It does not do payroll or sales tax filing. The free download records up to 60 entries.
See Tallyfinch Download it free Compare the three apps