Invoice Cancellation Generator
Cancel an invoice properly, with the notice and the credit note it needs.
Invoice Reconciliation Tool
Reconcile your ledger against a supplier statement or a bank export.
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
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
Paste your ledger
Invoice number, date and amount, from your own records.
-
2
Paste the statement
The supplier’s, the customer’s remittance, or a bank export.
-
3
Read the four lists
Matched, only on theirs, only on yours, and different amounts.
-
4
Check the difference is explained
The unmatched items should account for it exactly.
-
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.
It was never received, it was received and not posted, or it was posted to the wrong account or period. It can also be an invoice you disputed and they never credited.
Usually a credit note applied on one side and not the other, a settlement discount taken but not agreed, or a currency conversion at a different rate. The tool lists them so each can be checked individually.
Yes. Paste the bank lines as the second list and it matches on amount and date. Bank references rarely match invoice numbers exactly, so expect more amount-based matches and use the payment tracker for allocation.
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
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 reviewMore invoice tools
Invoice in EUR
Bill in euro with VAT, a VAT number, SEPA details and the reverse charge.
Invoice Debit Note Generator
A debit note for an under-billing, with the reason and the tax on the addition.
Invoice Company Number Validator
Check company registration numbers on invoices — UK prefixes, and the shape elsewhere.
Invoice Image to Text
Turn a photo of an invoice or receipt into copyable text, privately, in seconds.
PDF Invoice Template
A reusable PDF invoice with your branding and the variable fields left empty.
Invoice Branding Generator
Pick invoice colours and type that match your brand and still print legibly.
Invoice JPG to PDF
Turn photos of invoices into one tidy PDF, sized to the page and in the right order.