Reconciliation control desk
Turn two CSV exports into a reviewed reconciliation.
SettlePair pairs bank deposits with open invoices, scores each suggestion against visible evidence, and hands the decision to you. Part payments, batched deposits and short payments included.
Your files are read in this browser tab. Nothing is uploaded, stored, or shared — and no account is required.
Matching rail — sample session
3 pairs · 1 exception
INV-1042
Harborline Studio
1,240.00
96ACH CREDIT HARBORLINE INV1042
2026-03-18
1,240.00
ConfirmedInvoice number in description · amount agrees to the cent
INV-1042
1,240.00
Harborline Studio
score 96ACH CREDIT HARBORLINE INV1042
1,240.00
2026-03-18
ConfirmedInvoice number in description · amount agrees to the cent
INV-1047
Northbank Coffee
812.50
88DEPOSIT NORTHBANK CO
2026-03-19
812.50
ConfirmedCustomer name overlap · amount agrees to the cent
INV-1047
812.50
Northbank Coffee
score 88DEPOSIT NORTHBANK CO
812.50
2026-03-19
ConfirmedCustomer name overlap · amount agrees to the cent
INV-1051
Verrall & Sons
2,970.00
58TRANSFER V AND SONS LTD
2026-03-20
2,940.00
Needs reviewShort by 30.00 · no invoice reference in description
INV-1051
2,970.00
Verrall & Sons
score 58TRANSFER V AND SONS LTD
2,940.00
2026-03-20
Needs reviewShort by 30.00 · no invoice reference in description
Every score shows the evidence behind it. You approve, adjust, or reject.
2 confirmed
The flow, end to end
- 01
Import
Two CSV exports: invoices and bank transactions.
- 02
Review suggestions
Scored pairs with the evidence behind each score.
- 03
Handle exceptions
Part payments, batched deposits, short payments.
- 04
Export
A reviewed reconciliation as CSV, ready to post.
Why finance teams lose time at month end
Reconciliation is rarely one deposit against one invoice. These are the situations that turn an afternoon into two days — and how SettlePair handles each one.
- Bank descriptions don't name the invoice
- SettlePair scores customer-name overlap, amount agreement and settlement timing, then shows you which signals fired.
- One deposit settles five invoices
- Allocate a single deposit across several invoices in integer cents, with the unapplied balance always visible.
- An invoice arrives in two instalments
- Record each part payment against the same invoice and watch the remaining balance fall to zero.
- A payment is short by a processing fee
- Near-amount matches are flagged amber for review rather than silently approved or silently dropped.
- Payments land days after the invoice
- Settlement timing is scored, not assumed, so a late but plausible deposit still surfaces as a candidate instead of disappearing.
- Line-by-line checking in a spreadsheet
- Approve every high-confidence suggestion in one action, then spend your attention on the exceptions only.
Built around evidence and human review
SettlePair proposes; you decide. Nothing is posted to your accounting system, and every number it shows can be traced back to a rule you can read.
Every score shows its reasons
Expand any suggestion to see the signals that produced the number — reference match, amount agreement, name overlap, date plausibility, and any ambiguity penalty.
Allocations, not just pairs
One-to-many, many-to-one, part payments and unapplied remainders are first-class, with balances recomputed on every change.
Integer-cent arithmetic
Amounts are parsed to whole cents and stay there. No floating-point drift between the import and the export.
Browser-local processing
CSV parsing and matching run in this tab. No upload, no account, no storage — refreshing clears the session.
You make every decision
Nothing is posted anywhere. Approve, reject or adjust each suggestion, then export the reviewed result.
CSV export with the full picture
Record type, allocated amounts and remaining balances, so the file reconciles against your books line by line.
From two raw exports to a reviewed worklist
Same rows, same amounts — reorganised into decisions you can act on.
invoices.csv
| Invoice | Customer | Amount |
|---|---|---|
| INV-1042 | Harborline Studio | 1,240.00 |
| INV-1047 | Northbank Coffee | 812.50 |
| INV-1051 | Verrall & Sons | 2,970.00 |
bank.csv
| Date | Description | Amount |
|---|---|---|
| 2026-03-18 | ACH CREDIT HARBORLINE INV1042 | 1,240.00 |
| 2026-03-19 | DEPOSIT NORTHBANK CO | 812.50 |
| 2026-03-20 | TRANSFER V AND SONS LTD | 2,940.00 |
Reviewed worklist
INV-1042
1,240.00 applied
96
confirmed
INV-1047
812.50 applied
88
confirmed
INV-1051
2,940.00 applied · 30.00 open
58
review
Accounts receivable reconciliation, exceptions included
Automatic matching pairs one deposit with one invoice. Everything a statement throws at you beyond that — a deposit covering five invoices, an invoice settled in two instalments, a payment short by a processing fee — is handled on the allocation sheet, in integer cents, with the remaining balance always visible. Nothing is posted to your books for you: you export the reviewed reconciliation and record it yourself.
Read how the matching tool works, the guide to matching bank deposits to invoices, or what happens to your CSVs.
Reconcile a real month in a few minutes.
Start with the loaded sample session, or bring your own two exports. Free, no account, nothing leaves your browser. Tell us what's missing at support@settlepair.com.