Bookkeeping, inventory, reporting — without VLOOKUP

Reconcile two spreadsheets — find every difference in plain English.

You have two versions of the same spreadsheet — this month and last month, before and after a data update, your records and your vendor's records — and you need to know where they don't agree. Which rows changed? Which are in one file but not the other? What amounts are different? Upload both files and get a clear reconciliation report, no formulas required.

compare · xlsx-for-ai

What the reconciliation report shows you

Upload both files and the report appears right here on the page — nothing to download or open in a spreadsheet to read it. You get a count summary at the top (how many sheets were compared, and how many values changed, were added, and were removed), then every difference listed one by one, sorted into three groups:

  • Changed — a value present in both files but different. Each one shows its location (which sheet and cell) and the before → after, so you know exactly what moved.
  • Removed — a value in the first file that's gone from the second. Common in inventory (items discontinued), customer lists (accounts closed), or order data (orders cancelled).
  • Added — a value not in the first file that newly appears in the second. New orders, new customers, new line items added after the first file was created.

Values that are identical in both files aren't reported — you only see what needs attention. If there are more differences than fit on screen, you get a one-click download of the complete diff, so nothing is ever hidden.

What you need to bring

Two Excel files that use the same structure — same column names, data representing the same kind of records. You tell us which column is the unique identifier (order number, customer ID, SKU, account number) so we can match rows across the two files even if they're in a different order. That's it.

You don't need the files to be sorted the same way. You don't need to add any helper columns. You don't need to know what "VLOOKUP" (Excel's vertical-lookup formula) means.

Why bookkeepers and ops people say "reconcile" instead of "compare"

In general conversation you might say "compare two files." In bookkeeping and accounting, the word is reconcile — because the goal isn't just to spot differences, it's to confirm that two records that should match actually do match, and to document every place they don't. Reconciling your bank statement against your ledger, reconciling an invoice against a purchase order, reconciling this quarter's inventory count against last quarter's — same idea, different data.

Common uses

Monthly close: your records vs the bank export. Inventory audit: what the system says vs what was physically counted. Vendor reconciliation: your purchase orders vs the vendor's invoice list. HR roster: who's in the system vs who should be in the system. Any situation where two files are supposed to agree — and you need to prove they do, or find where they don't.

If you're trying to find rows that appear in both files (rather than rows that differ), or you want to deduplicate a single file rather than compare two, Remove duplicate rows covers that case.

Need to run reconciliations automatically — as part of a monthly report generation script or an AI agent that processes incoming data files? Install xlsx-for-ai and call xlsx_diff to get the same structured reconciliation output programmatically.