Changed rows, field by field
Every changed value with the original and revised side by side, and the exact dollar change. Formatting differences such as $1,000.00 vs 1000 are ignored.
Excel add-in for auditors and accountants
Open the revised spreadsheet in Excel and pick the original. Revised File Check matches every row by invoice or transaction ID, so re-sorted, inserted and deleted rows can't hide a change. It reconciles the total and tells you which items you already selected for testing were affected.
Amount total: 132,747.45 → 148,766.92 (+16,019.47). 1,150.00 of the change is in rows that could not be matched (see Issues).
Selected items: 5 of 6 affected — 3 changed, 1 missing from revised, 1 with a key issue.
Every changed value with the original and revised side by side, and the exact dollar change. Formatting differences such as $1,000.00 vs 1000 are ignored.
Rows that appear only in the revised file, and rows from the original that are gone, with their amounts.
The original and revised totals, and how much of the movement the changed, added and missing rows explain. Anything unexplained is called out.
Paste or select the IDs you sampled. You'll see which ones changed, disappeared or can no longer be matched.
A repeated or blank invoice number is listed as an issue instead of being matched to the wrong row. Total and subtotal lines are left out.
One click writes the summary and every finding to a new sheet in the workbook. A CSV download is there too.
Two versions of a fictional revenue export. The revised copy is re-sorted and has the kinds of changes that slip through when you compare by eye.
INV-24003
INV-24007
INV-24010
INV-24019
INV-24021
INV-24026During the preview, Revised File Check is installed from a small manifest file rather than from Microsoft's add-in store.
Download the manifestThe upload is kept in your browser. After clearing the browser cache or switching browsers, upload it again. If your organization blocks uploading add-ins, try with a personal Microsoft account.
~/Library/Containers/com.microsoft.Excel/Data/Documents/wef. Create the wef folder if it doesn't exist.Questions or feedback? Reply to the person who shared this page with you.