Supplier statement reconciliation
Reconcile a supplier statement in seconds.
Drop in the supplier's statement and your ledger export. Statementpair pairs every line and lists what does not match: missing invoices, duplicate bills, wrong amounts and unrecorded credit notes.
No sign-up. Free during early access. Your files never leave your browser.
Harlow Catering Supplies Ltd, October
5 lines need a look
- Missing from ledgerINV-020418 Dairy412.60
- Possible duplicateINV-020377 entered twice318.75
- Amount differsINV-020391: 1,248.00 vs 1,284.0036.00
- Credit note missingCN-000457 Damaged cartons96.00
- Payment not on statementBACS 30 Oct, likely timing2,000.00
- 6 lines paired and agreed
Built for bookkeepers and accounting practices.
Supplier statement checks are easy to skip at month-end, because doing them by hand takes so long. This makes them quick enough to do for every supplier.
Minutes back on every client
The ticking is done for you. You only look at the lines that do not agree.
Overpayments caught before the payment run
Duplicates and unused credit notes are added up, so you can see what was about to be overpaid.
Something concrete to show the client
Copy the result as a short report, or as an email to the supplier asking for what is missing.
Two files in, one answer out.
There is nothing to install, connect or set up. If you can attach a file to an email, you can use it.
Drop in the statement
The PDF, Excel or CSV file exactly as the supplier sent it. No retyping and no template.
Drop in your ledger
Export that supplier's transactions from your accounting system. Date order and column layout are worked out for you.
Read the result
Every line is paired or flagged, with what each difference does to the balance. Copy a ready-written email to the supplier.
What it finds.
The differences that cost money or hold up a month-end, each with a plain note on what to do next.
Invoices missing from your ledger
On the statement but never entered. Ask for a copy before it becomes an overdue reminder.
Bills entered twice
The same invoice posted on two dates. Caught before it is paid twice.
Amounts that differ
The same invoice number with two different totals, such as a keying slip of 1,248 for 1,284.
Credit notes you have not used
Credits the supplier has raised that are not in your books yet. Money you are owed.
Payments in transit
Paid by you, not yet shown by the supplier. Usually timing, and marked as such.
Payments and entries only one side has
A payment the supplier shows that you cannot find, or a ledger line with no partner on the statement.
Client data stays on your machine.
The matching runs inside your browser. The statement and the ledger are read on your own computer and are not uploaded to us or to anyone else. Close the tab and they are gone.
In plain terms
- No account, so there is no password to manage.
- No file upload, so there is no copy of your client's data on our servers.
- The sums are done by fixed rules, not by guesswork, so the same files always give the same answer.
Files it reads
Statements and ledger exports in the common layouts, including the transaction exports produced by Xero, QuickBooks and Sage. UK and US date order are both recognised.
- XLSX
- XLS
- CSV
- Pasted text
What it does not do yet
- Scanned statements that are a photo of a page. The PDF needs real text in it.
- A direct link to your accounting system. For now you export a file.
- Saving a history of past reconciliations.
Questions.
Short answers to what bookkeepers ask first.
What does it cost?
Nothing during early access. Paid plans will come later, and you will see the price before you are asked for anything.
Do I need to sign up?
No. Open the tool, drop in two files and read the result.
Where do I find the ledger export?
In your accounting system, open the supplier and export their transactions for the period as Excel or CSV. The tool has a short guide for the common systems next to the drop area.
Does it change anything in my books?
No. It only reads the two files. You decide what to correct, and you make the change in your own system.
What if it reads my statement wrongly?
You can open the lines it read, correct them and run it again. If a layout does not work, send us the format and we will add it.
Who is behind it?
Statementpair is a product of Gereon Studios ApS, a Danish company. Write to hello@statementpair.com.
Tell us where it falls short.
Statementpair is new. If a statement layout is read wrongly, or you need something it does not do, one email is enough and it goes straight to the people building it.
Running a practice with many clients?
Tell us how many supplier statements you handle in a month and which accounting system you use. It shapes what is built next.
hello@statementpair.comTry it on the statement you are dreading.
The example is loaded when you open the tool, so you can see a result before you use your own files.