What can I reconcile with this tool?

Invoice numbers, payment references, order IDs, employee IDs, account numbers, product SKUs, transaction codes — any list of identifiers where you need to check two sources agree.

Reconcile Two Lists Online — Spot Every Discrepancy Instantly

Q: What does it mean to reconcile two lists?

Reconciling two lists means comparing them to find which records match (are in both), which are only in one list (missing from the other), and which are unexpected extras. It's used in accounting, data audits, inventory checks, and any process where two datasets should agree.

Q: How do I reconcile two lists online?

Paste the first list — invoices sent, payments expected, records from system A — into List A. Paste the second list into List B. The tool instantly shows: 'Only in A' (unmatched/missing from B), 'Only in B' (unexpected in B), and 'Common' (matched records).

Paste your two lists of IDs, records, or identifiers and immediately see which entries match, which are missing, and which are unexpected. Perfect for invoice reconciliation, data audits, and any check-and-balance task.

Reconcile Lists Free → See a Live Example

List A — Invoices Sent6 items

List B — Payments Received6 items

Paste your records and click Reconcile

Live preview · Open the full tool to export the reconciliation report as CSV.

How to Reconcile Two Lists

Reconciliation means checking that two records of the same data agree. The classic example is invoices sent vs. payments received — but the same logic applies to any pair of lists that should match. Here's how to do it in seconds:

Export or copy your "expected" list (List A)This is the authoritative source — invoices sent, orders placed, records expected. Copy the ID or reference column.
Paste into List AOne ID or record per line. The tool handles newlines from Excel, CSV, or any text format.
Export or copy your "received" list (List B)This is what actually arrived — payments, deliveries, confirmations. Paste into List B.
Read the reconciliation resultsOnly in A = sent but not received (outstanding/missing). Only in B = received but not expected (unexpected/error). Common = perfectly matched.
Export the discrepancy listDownload the "Only in A" and "Only in B" results as CSV to investigate and follow up on each discrepancy.

What You Can Reconcile With This Tool

Invoice reconciliationCompare invoices sent against payments received. Find outstanding invoices and unexpected payments instantly.
Order fulfillmentCompare orders placed against orders shipped. Find unfulfilled orders before your customers do.
Attendance vs. registrationCompare event registrations against actual check-ins. Find no-shows and gate crashers.
Database auditCompare records from two systems that should be in sync — find missing records and ghost entries.
Payroll reconciliationCompare the employee list against the payroll run. Find anyone missed or anyone paid who shouldn't be.
Inventory auditCompare system records against physical counts. Find shrinkage and mis-records before year-end.

Frequently Asked Questions

What does it mean to reconcile two lists?

Reconciling two lists means checking that both lists agree — finding records that match (appear in both), records missing from one, and any unexpected extras. It's used in accounting, operations, and any process where two datasets should mirror each other.

How do I reconcile two lists online?

Paste your expected list (invoices sent, orders placed) into List A. Paste your received list (payments, deliveries) into List B. The tool immediately shows unmatched items in both directions plus confirmed matches.

Can I reconcile lists with thousands of records?

The demo above handles small lists. The full tool handles thousands of records and lets you export the results as CSV for further investigation.

What if the IDs have slightly different formatting?

By default comparison is case-insensitive. If IDs have leading zeros, spacing differences, or other minor formatting issues, you may need to normalize them in Excel first. The full tool also has a "normalize whitespace" option.

Is my financial data safe to paste here?

Yes. All processing happens locally in your browser — record IDs are never uploaded or transmitted. Safe for sensitive financial identifiers.