ContextCleaner: see every entry in the Windows 11 right-click menu, and which app added it — on the Microsoft Store.

Last updated:

Guided workflow variation

Coming soon for Windows. Feature preview.

Reconcile two spreadsheets,row by row, on the key you pick.

Lookup formulas and colored cells hold up until a column moves. LedgerPair pairs the rows of two CSV or Excel exports on your chosen identifier and sorts every one into matched, changed, missing, or duplicate.

When two exports should agree and you need a record of where they differ, a keyed comparison and an evidence workbook replace an afternoon of formulas.

Coming soon No telemetry Local-first

coming soon for Windows

If this sounds like your week

Most reconciliations still run on lookup formulas.

The usual method is a helper column: a VLOOKUP or XLOOKUP that pulls the matching figure from the other sheet, a second formula that flags disagreement, then conditional formatting so the eye can find it. That works the first time. Next month someone inserts a column, the lookup range shifts, the #N/A results multiply, and half the afternoon goes to repairing formulas instead of reviewing balances.

Where tooling usually breaks

Formulas stop at the first hit.

A lookup returns the first match it meets, so an invoice entered twice looks fine. Trailing spaces, numbers stored as text, and dates typed day first in one system and month first in another all raise false alarms. When the review is finished, what remains is a tangle of nested functions that only its author can follow, not something a manager or an auditor can open and read.

Where LedgerPair lands

A keyed comparison with a record you can hand over.

LedgerPair opens both exports, suggests a shared identifier, and lets you tick more key columns or differently named ones. Press Compare and it lists matched, changed, only-in-A, only-in-B, and duplicate keys, after spacing, amounts, and dates are normalized. Export evidence workbook then saves Summary, Additions, Deletions, Changes, and Duplicates sheets to a new .xlsx file.

Join the LedgerPair waitlist Explore the product preview

coming soon for Windows

What you get

Feature highlights

Rows paired on the keys you pick

tick one key column or several in each file, with different names allowed, and rows pair wherever they sit, so two exports sorted in different orders still line up.

Changed cells, side by side

every matched row whose values differ is listed with the columns that changed, and the detail pane shows both files’ values with the differing cell highlighted.

Formatting is not a difference

spaces are trimmed, amounts compare as exact decimals, and dates as calendar dates, so 1,250.00 equals 1250 and 2026-03-01 equals 03/01/2026, with a day-first option.

Duplicate and empty keys surfaced

a key that appears more than once in a file is listed with every row number, and rows with an empty key are listed on their own, never matched.

Near-miss keys suggested

an unmatched key spelled almost like one in the other file is shown as a fuzzy candidate in its own column, with a similarity score in the export, and never counted as a match.

An evidence workbook you can keep

a new .xlsx with Summary, Additions, Deletions, Changes, and Duplicates sheets, while the originals are opened read-only and nothing uploads.

Especially when

  • Compare two CSV or Excel exports by a key column instead of building VLOOKUP or XLOOKUP formulas for every column
  • Find the rows that are in one export and missing from the other, plus the keys that appear twice, with row numbers
  • Stop formatting differences such as 1,250.00 against 1250 or two date notations from showing up as false mismatches
  • Keep a reconciliation record as a new Excel workbook, with the original files untouched and nothing uploaded

Who benefits

Real-world scenarios

A bookkeeper before the monthly close

Two exports should agree before the books close: invoices raised in the billing system and receivables posted to the ledger. Last month the check took most of an afternoon of lookup formulas and hand-colored cells.

She opens both CSV files in LedgerPair, keeps the preselected Invoice key, and presses Compare. The changed amounts, the missing invoices, and one duplicate are listed with row numbers, and the evidence workbook goes into the close folder.

Handing the result to a reviewer

A controller wants to see what was compared, not only a list of exceptions, and does not want a workbook full of formulas that break when it is opened on another PC.

The Summary sheet records both file names, the key columns on each side, the compared columns, every count, and how dates and numbers were read. Values on the other sheets are written as text, exactly as each export had them.

Two exports with different headings

The ledger export calls its identifier Doc No, while the billing export calls the same number Reference. Both files also carry Amount and Date columns that need checking.

Tick Doc No under In file A and Reference under In file B, then press Compare. LedgerPair pairs the rows on those two columns and compares the columns both files share, such as Amount and Date, cell by cell.

Deep dive

What to look for in a tool to reconcile two spreadsheets

A key you choose. Reconciling starts with deciding what makes two rows the same record: an invoice number, an account code, a reference. LedgerPair suggests a column the two files share, preferring identifier-like columns with unique values over amounts and dates. You can tick a different column, several columns for a composite key, or differently named columns in each file, as long as each side has the same number.

Formatting handled before comparing. Two systems rarely write the same value the same way. LedgerPair ignores leading, trailing, and repeated spaces, reads 1,250.00 and 1250 as the same amount, understands parentheses and a trailing minus for negatives, and compares dates as calendar dates whether they are written 2026-03-01, 03/01/2026, or Mar 1, 2026. When a date such as 03/01/2026 could be read either way, it tells you how many it found and which order it used, and Dates are day first switches the order and compares again.

Every category in one result. A reconciliation explains every row, not only the mismatches. LedgerPair reports the number of matched rows, the rows that matched on the key but differ in a value, the rows only in file A, the rows only in file B, and the keys that repeat inside a file. The results table lists each difference with its row number in each file, and a filter shows one kind at a time.

The cell that changed. Select a changed row and the detail pane lists every compared column from both files side by side, with the differing cell highlighted. The row summary names the columns, such as 1 cell differs: Amount.

Near misses kept apart. A key typed with a letter O for a zero will not pair, but it should not vanish either. LedgerPair suggests such keys as fuzzy candidates in their own column, and a candidate is never counted as a match, so the counts stay exact.

A record that stands on its own. Export evidence workbook writes a new .xlsx file, suggested as a-vs-b-evidence.xlsx after the two file names. The Summary sheet carries the date and time, both file names and worksheets, the key and compared columns, every count, and a plain description of how values were compared. Additions, Deletions, Changes, and Duplicates follow, each with a frozen header and filters.

Originals left alone, files kept local. Both exports are opened for reading only, saving over either one is refused, and the app has no network code, account, or telemetry.

Launch updates. LedgerPair is coming soon for Windows. Use the waitlist form on the product page and confirm your email address to hear when it launches. No payment is taken.

Feature preview

Explore the intended workflow

Rows paired on the keys you pick

tick one key column or several in each file, with different names allowed, and rows pair wherever they sit, so two exports sorted in different orders still line up.

Changed cells, side by side

every matched row whose values differ is listed with the columns that changed, and the detail pane shows both files’ values with the differing cell highlighted.

Formatting is not a difference

spaces are trimmed, amounts compare as exact decimals, and dates as calendar dates, so 1,250.00 equals 1250 and 2026-03-01 equals 03/01/2026, with a day-first option.

Head-to-head

How LedgerPair compares

Feature LedgerPair Spreadsheet by hand Online comparison site Software suite
Rows paired on a key you choose Yes, one or several key columns, and the names can differ between files A lookup formula for each column Varies by site Usually, after setup
Formatting differences Spaces, amounts, and dates normalized before comparing Cleaned by hand first Often compared as raw text Depends on configuration
Duplicate keys Listed with every row number An extra COUNTIF column Varies by site Varies by product
Record of the result New .xlsx with Summary, Additions, Deletions, Changes, and Duplicates sheets The working file itself A download, where offered Reports inside the suite
Where the files go Stay on this PC. Nothing uploads. Stay on this PC Uploaded to the site Often stored in the vendor’s cloud
How it is paid for Coming soon to the Microsoft Store Staff hours every month Per use or per plan License terms vary by provider

FAQ

Straight answers—no glossary dump

How do I reconcile two spreadsheets without VLOOKUP?

Pair the rows on a key instead of looking values up one column at a time. In LedgerPair, choose Open file A and Open file B, keep the key column it suggests or tick your own under Key columns, and press Compare. Matched, changed, only-in-A, only-in-B, and duplicate-key rows are listed together, and Export evidence workbook saves them to a new .xlsx file.

What is the difference between comparing and reconciling two spreadsheets?

Comparing finds the cells that differ. Reconciling accounts for every row: which records agree, which agree on the key but differ in a value, which appear in only one file, and which keys repeat. LedgerPair reports all of those categories in one result and counts them on the Summary sheet of the evidence workbook, so the exceptions arrive with the totals that explain them.

Can the key column have a different name in each file?

Yes. Tick the key under In file A and the matching column under In file B, such as Doc No and Reference. Several key columns work too, as long as you pick the same number in each file, and LedgerPair names both files and both counts when they differ. Keys are compared without regard to case, so inv-001 and INV-001 pair up.

Which files can LedgerPair open?

CSV and XLSX files that you pick in the Windows file dialog, in any combination. CSV files can be UTF-8, UTF-16, or Windows-1252, separated by commas, semicolons, tabs, or pipes, with quoted cells that span several lines. Workbooks can hold several worksheets, and a picker under the file lets you choose which one to compare. A file that is open in Excel can still be read.

What happens to my original files?

They are opened for reading only and are never written. LedgerPair compares the data it has read and saves its results to a new .xlsx file that you name in the Save dialog. Saving over either source file is refused with the message that originals are never overwritten, and a name that does not end in .xlsx is refused as well. If an export cannot be built, no file is left behind.

Where do my files go, and how do I get LedgerPair?

LedgerPair is coming soon to the Microsoft Store for Windows and is not available to download or purchase yet. Use the email form on its product page to join the waitlist, then confirm your email address. We will send launch updates when there is news. No payment is taken.

Related pages

Two workbooks, one key, every changed cell side by side. The bank export and the ledger, matched on your PC. What is in one file and missing from the other. Compare two CSV files by the key, not by line number.

LedgerPair is coming soon.

Join the waitlist for launch updates. The app is not available to download or purchase yet. No payment is taken.

Join the LedgerPair waitlist
Open full product page

Excel is a trademark of Microsoft Corporation. LedgerPair is made by Automata Labs and is not affiliated with or endorsed by Microsoft.