Two files. One truth!

However messy your exports are, Reconcile matches them, flags every discrepancy, and hands you a clean, audit-ready report. No reformatting, setup, or onboarding call needed.

Your first run is free

See a sample report

Your bank says one thing. Your books say another.

Every month, the same question — where is the difference and who is right?

equity_bank_may2026.csv

	A	B	C	D	E	F	G
1	txn_ref	value_date	debit	credit	narration	currency	running_balance
2	EQT-8801	05-May-26	12,400.00		supplier transfer / kivu steel	RWF	84,920.00
3	EQT-8802	07-May-26		3,250.00	deposit / client refund	RWF	88,170.00
4	EQT-8803	07-May-26	870.50		monthly bank charge	RWF	87,299.50
5	EQT-8804	12-May-26		18,000.00	RTGS / project drawdown	RWF	105,299.50
6	EQT-8805	31-May-26	4,100.00		cash withdrawal / site ops	RWF	101,199.50

txn_refMemo Ref

Key	Bank file	Ledger file	Result
EQT-8801	12,400.00 Dr	12,400.00 Cr	clears
EQT-8802	3,250.00 Cr	3,250.00 Dr	clears
EQT-8803	870.50 Dr	870.50 Cr	clears
EQT-8804	18,000.00 Cr	18,000.00 Dr	date gap
EQT-8805	4,100.00 Dr	—	not in ledger

3 cleared, 1 date difference, 1 missing from ledger.

cashbook_may.xlsx

	A	B	C	D	E	F	G
1	Memo Ref	Posting Date	Amount	Dr/Cr	Account Code	Description	Batch No
2	EQT-8801	5 May 2026	12,400.00	Cr	2100	Kivu Steel payment	MAY-04
3	EQT-8802	7 May 2026	3,250.00	Dr	4105	Client refund reversal	MAY-05
4	EQT-8803	7 May 2026	870.50	Cr	6102	Bank charges	MAY-05
5	EQT-8804	15 May 2026	18,000.00	Dr	1200	Project drawdown receipt	MAY-07

Stripe settled it. But did you get the full amount?

Fee gaps, missing payouts, partial settlements. They hide in the numbers until someone catches them.

shopify_orders_june.xlsx

	A	B	C	D	E	F	G
1	orderID	orderDate	grossAmount	customerName	paymentStatus	salesChannel	deliveryZone
2	#10441	2026-06-03	2,340.00	Amara K.	paid	online-store	Kigali
3	#10442	2026-06-03	890.00	Thierno B.	paid	online-store	Rubavu
4	#10443	2026-06-04	14,200.00	Mireille N.	paid	draft-order	Kigali
5	#10444	2026-06-04	450.00	Jean P.	paid	POS	Musanze
6	#10445	2026-06-07	3,100.00	Fatouma D.	paid	online-store	Huye

orderIDorder_ref

Order	Orders file	Payout file	Result
#10441	2,340.00	2,272.68	fee deducted
#10442	890.00	864.31	fee deducted
#10443	14,200.00	13,789.40	fee deducted
#10444	450.00	—	not settled
#10445	3,100.00	3,007.90	fee deducted

4 settled with fee deductions, 1 order not yet settled.

stripe_payout_06jun.csv

	A	B	C	D	E	F	G	H
1	order_ref	net_payout	gross	processing_fee	refund	payout_id	status	available_on
2	#10441	2,272.68	2,340.00	(67.32)		po_88471	paid	2026-06-05
3	#10442	864.31	890.00	(25.69)		po_88471	paid	2026-06-05
4	#10443	13,789.40	14,200.00	(410.60)		po_88472	paid	2026-06-06
5	#10445	3,007.90	3,100.00	(92.10)		po_88473	paid	2026-06-09

The invoice was sent. Was it actually paid?

Payment references don't always match invoice numbers. That gap is where money gets lost.

mpesa_collections_june26.csv

	A	B	C	D	E	F	G
1	PAYMENT_REF	AMOUNT	TXN_TYPE	DATE	COLLECTOR_ID	MSISDN	CHANNEL
2	INV-3301	45,000.00 Cr	collection	02-Jun-26	AGT-04	+254712...	M-PESA
3	INV-3302	12,800.00 Cr	collection	05-Jun-26	AGT-04	+254712...	M-PESA
4	INV-3302	12,800.00 Cr	collection	05-Jun-26	AGT-04	+254712...	M-PESA
5	INV-3304	8,500.00 Cr	collection	10-Jun-26	AGT-11	+254733...	M-PESA
6	INV-3305	(3,200.00)	reversal	14-Jun-26	AGT-11	+254733...	M-PESA

PAYMENT_REFInvoice No

Invoice	Payments file	Invoices file	Result
INV-3301	45,000.00	45,000.00 Dr	cleared
INV-3302	12,800.00	12,800.00 Dr	duplicate payment
INV-3303	—	28,000.00 Dr	unpaid
INV-3304	8,500.00	8,500.00 Dr	cleared
INV-3305	(3,200.00)	—	reversal, no invoice

2 cleared, 1 duplicate payment, 1 unpaid invoice, 1 reversal with no matching invoice.

AR June 2026.xlsx

	A	B	C	D	E	F	G
1	Invoice No	Invoice Amount	Balance Due	Client	Due Date	Status	Account Owner
2	INV-3301	45,000.00 Dr	0.00	Kamau Ltd	03-Jun-26	cleared	Alice M.
3	INV-3302	12,800.00 Dr	650.00	Afia Co	06-Jun-26	partial	Alice M.
4	INV-3303	28,000.00 Dr	28,000.00	Bello Inc	11-Jun-26	overdue	Brian K.
5	INV-3304	8,500.00 Dr	0.00	Diallo Bros	12-Jun-26	cleared	Brian K.

The system says 240. The shelf says something else.

Physical counts and ERP snapshots never agree on their own. That gap has a cost.

warehouse_count_branch_kgl.csv

	A	B	C	D	E	F	G
1	item_code	branch	counted_qty	bin	counted_by	count_time	remarks
2	SKU-881	KGL	240	A1	Jean	09:14
3	SKU-882	KGL	121	A2	Jean	09:18	recounted
4	SKU-884	KGL	40	B1	Jean	09:22	new item
5	SKU-885	KGL	12	B2	Jean	09:25

item_code + branchSKU + Site

Key	Count file	ERP file	Result
SKU-881/KGL	240	240	matched
SKU-882/KGL	121	118	+3 variance
SKU-883/KGL	—	64	not counted
SKU-884/KGL	40	—	not in ERP
SKU-885/KGL	12	12	matched

2 matched, 1 quantity variance, 1 item not counted, 1 item not in ERP.

erp_stock_snapshot.xlsx

	A	B	C	D	E	F	G
1	SKU	Site	System Qty	Unit Cost	Stock Value	Last Updated	Stock Owner
2	SKU-881	KGL	240	14.50	3,480.00	10-Jun-26	ERP
3	SKU-882	KGL	118	13.20	1,557.60	10-Jun-26	ERP
4	SKU-883	KGL	64	10.00	640.00	10-Jun-26	ERP
5	SKU-885	KGL	12	8.75	105.00	10-Jun-26	ERP

WHY RECONCILE

Why bookkeepers choose Reconcile.

You've matched rows manually. You know what that costs.

One missed mismatch, one wrong number on a client report. The risk isn't worth the hours.

You've built the formulas. They still let you down.

The files change, the headers shift, and suddenly nothing works. You spend more time fixing the sheet than doing the work.

You needed a report. Not a spreadsheet diff.

A spreadsheet diff is not something you hand to a client or auditor. Reconcile gives you something that actually holds up.

Your files were never clean. That's fine.

Messy headers, inconsistent formats, mixed date styles. Upload them as they are.

PRICING

Simple pricing. No surprises.

No commitment

Pay as you go

For operators who reconcile occasionally

From $12

per run

Buy credits

1 run at $125 runs at $4915 runs at $10 per run40 runs at $6 per run

PDF report + Excel results workbook

Audit dashboard included

Up to 2 files per run

Up to 10M rows per file

CSV, Excel and JSON supported

Runs never expire

Reconciling more than 30 files a month? Teams at $149/month is better value.

Frequently Asked Questions

In this section, we address common queries about our application features, subscription options, and support services to help you navigate your experience effortlessly.

Learn more

Do I need to clean or reformat my files before uploading?

No. That is the point. Reconcile is built for files as they actually come out of your systems — inconsistent column names, mixed date formats, amounts formatted differently across sources, missing rows, extra headers. You upload your files as they are. Reconcile handles the rest before the comparison even starts.

What happens to my uploaded files after reconciliation?

Your files are processed for comparison only and deleted immediately after your run completes. We never store them, read their content for any purpose other than matching rows, or share them with anyone. What is inside your files is your business, not ours.

How is Reconcile different from using spreadsheets?

Three things Excel cannot do. First, it does not break when your column names change — Reconcile recognizes what a transaction reference looks like regardless of what it is called in a given export. Second, it produces a structured report you can hand to a client or auditor as is, not a highlighted spreadsheet you still have to clean up and explain. Third, it tells you exactly what matched, what did not match, and why — with no formula to doubt and no manual review to second-guess.

Does Reconcile guarantee 100% correct reconciliation outcomes?

No tool that is honest will make that guarantee. What Reconcile does guarantee is that the output is transparent — every matched row, every unmatched row, and every discrepancy is clearly labeled and traceable. You can see exactly what the engine did and why. If something looks wrong, you will see it. That is a stronger assurance than a guarantee that hides its work.

How does pricing work in Reconcile?

You have two options. Pay as you go — buy credits and use them when you need them. One run costs $12, with discounts for larger packs down to $6 per run for 40 runs. Credits never expire. Or choose the Teams plan at $149 per month, which includes 60 runs per month, up to 5 users, a shared workspace, and priority support. Your first two runs are always free, no credit card required.

Blog

From the Reconcile desk.

Why Excel VLOOKUP Returns #N/A on Mismatched CSV Formats

Excel VLOOKUP returns #N/A when CSV column formats differ. This explains the exact causes: text vs number, trailing spaces, date formats: and how to fix each one.

7 min read

How to Compare Two Bank Statement CSVs Without Formulas

Comparing two bank statement CSV files in Excel requires VLOOKUP, matching column names, and manual cleanup. This shows a faster way that skips the formula-building entirely.

9 min read

How to Match a Stripe Payout CSV to Your Bank Statement

A Stripe payout CSV and a bank statement use different references, dates, and amounts. This explains the exact matching approach that works when the two files do not align directly.