---
title: "Vendor Statement Reconciliation Tool: Free, Fast | MCC"
description: "Paste a supplier's statement and your open bills, and see in seconds what's missing, what's extra and where amounts differ. Free, no sign-up, nothing is stored."
url: "https://mcc-solutionsnj.com/bookkeeping/vendor-statement-reconciliation-tool"
---

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.

Paste your lists

**Coming Thursday, November 26: 25% off every bundle and ebook**, through Tuesday, December 1. [See what's included](/black-friday).

[![Intuit ProAdvisor Gold tier badge](/img/credentials/intuit-proadvisor-gold.webp)](https://proadvisor.intuit.com/app/accountant/search?searchId=matthew-coleman77)Gold tier in Intuit's ProAdvisor program. [See my Intuit listing](https://proadvisor.intuit.com/app/accountant/search?searchId=matthew-coleman77)

Keeping your own books? Tallyfinch does invoices, bank import and reports on your computer. [See Tallyfinch](/bookkeeping/mcc-books-downloadable-bookkeeping-software)

**Price**Free to use. Want it done for you every month? See our bookkeeping service.

**Where we cover**Works with QuickBooks, Xero, MYOB, Zoho Books, Sage, NetSuite or a spreadsheet: anything you can copy a list from.

## 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](/bookkeeping/guides/vendor-statement-reconciliation), keep a record with the [free reconciliation template](/bookkeeping/templates/vendor-statement-reconciliation-template), or run the whole month-end with the [month-end close workbook](/toolkits/month-end-close-workbook). If reconciling suppliers is eating a day every month, [our bookkeeping service](/bookkeeping/) 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](/bookkeeping/mcc-books-downloadable-bookkeeping-software) [Download it free](/tools/pro/trial/mccBooks) [Compare the three apps](/software)

## Want us to handle it?

Paste your lists[Call (908) 444-6373](tel:+19084446373)
