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.
Try it on last month’s files. The Microsoft Store runs a 15-day free trial with every feature, so you can reconcile a period you have already closed and compare the result with your own work.