Skip to content
ToolQivo

Invoice Reconciliation Tool

Reconcile your ledger against a supplier statement or a bank export.

Invoice Tools Reviews Free · no sign-up

Quick Tool Overview

The Invoice Reconciliation Tool compares your ledger against a supplier statement, a customer remittance or a bank export, and answers the four questions a reconciliation always comes down to — with the difference in totals fully explained by the items listed.

What it does
Reconciles two lists of invoices
You give it
Your ledger and their statement
You get back
Matched, missing, extra and different
Best for
Month-end supplier statement reconciliation
Invoice Tools Free, unlimited use No sign-up Runs in your browser

About the Invoice Reconciliation Tool

Reconciling a supplier statement against your own purchase ledger is a job done once a month by somebody with two printouts and a pen, and it always comes down to the same four questions. What is on their statement and not in your ledger. What is in your ledger and not on their statement. What appears on both but for a different amount. And what nets to the difference between the two totals.

This answers all four from two pasted lists. It matches on invoice number first, then on amount and date, and reports every unmatched item on each side with its value. The difference between the two totals is always fully explained by the items listed, which is what makes a reconciliation a reconciliation rather than a comparison.

It works equally well the other way round — your sales ledger against a customer’s remittance, or either against a bank export — because the problem is the same shape whichever direction the money is going.

Key features of the Invoice Reconciliation Tool

Four clear lists

Matched, only theirs, only yours, different amounts.

The difference explained

The unmatched items account for it exactly.

Number then amount matching

Invoice number first, then amount and date.

Works in either direction

Purchase ledger, sales ledger or a bank export.

CSV of the working

To file with the statement.

How to use the Invoice Reconciliation Tool

  1. 1

    Paste your ledger

    Invoice number, date and amount, from your own records.

  2. 2

    Paste the statement

    The supplier’s, the customer’s remittance, or a bank export.

  3. 3

    Read the four lists

    Matched, only on theirs, only on yours, and different amounts.

  4. 4

    Check the difference is explained

    The unmatched items should account for it exactly.

  5. 5

    Export the working

    CSV of the reconciliation, to file with the statement.

Frequently asked questions

Comparing a supplier’s statement of what you owe them against your own purchase ledger, and explaining every difference. It catches missing invoices, duplicate postings and credit notes that never arrived, and it is one of the highest-value monthly controls a small business has.

Reviews of the Invoice Reconciliation Tool

What people who use the Invoice Reconciliation Tool think of it. Reviews come from visitors and are posted as written.

No ratings yet

Yours would be the first.

  • 5 0 reviews rated 5 stars
  • 4 0 reviews rated 4 stars
  • 3 0 reviews rated 3 stars
  • 2 0 reviews rated 2 stars
  • 1 0 reviews rated 1 star

Write a review

Used this tool? Your rating helps the next person decide.

Your rating

Plain text only — links, email addresses and HTML are not accepted. Your name and review are shown publicly; nothing else is collected. See the privacy policy.

0 reviews

Newest first

No reviews yet

Be the first to rate the Invoice Reconciliation Tool. It takes half a minute and no account.

Write the first review

More invoice tools