DocuLens Revised File Check Preview

Excel add-in for auditors and accountants

Your client sent a revised file. See exactly what changed.

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.

Example result

Result for the sample files
5changed
2only in revised
1missing
1issues
3material
23unchanged

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.

  1. INV-24007ChangedMaterialSelectedAmount: 5,793.51 → 12,043.51 (+6,250.00)
  2. INV-24019ChangedSelectedInvoice date: 2026-08-25 → 2026-10-04
  3. INV-24021Missing from revisedMaterialSelectedWas row 25 in the original · Amount 7,880.53
  4. INV-24026Repeated keySelectedAppears more than once in the revised version, so it was not matched (original row 30; revised rows 27, 28).

What it tells you

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.

Added and missing rows

Rows that appear only in the revised file, and rows from the original that are gone, with their amounts.

Does the total reconcile?

The original and revised totals, and how much of the movement the changed, added and missing rows explain. Anything unexplained is called out.

Items you already tested

Paste or select the IDs you sampled. You'll see which ones changed, disappeared or can no longer be matched.

No guessing on bad keys

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.

Ready for your workpapers

One click writes the summary and every finding to a new sheet in the workbook. A CSV download is there too.

How it works

  1. Open the revised file in Excel (or the original; you can say which one is open).
  2. Open Revised File Check and choose the other version from your computer: .xlsx or .csv.
  3. Confirm how rows match. It suggests the ID column and the amount column. Set a materiality amount and paste the items you selected.
  4. Compare, review the findings (select one to jump to that row), then write the report to a new sheet.

Try it with sample files

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.

  1. Open Revised.xlsx in Excel and start Revised File Check.
  2. Choose Original.xlsx, then Read both versions.
  3. Keep the suggested Invoice # and Amount columns, and set materiality to 5000.
  4. Paste these as the items you already selected:
    INV-24003 INV-24007 INV-24010 INV-24019 INV-24021 INV-24026
  5. Choose Compare. You should see the result shown above.

Install the preview

During the preview, Revised File Check is installed from a small manifest file rather than from Microsoft's add-in store.

Download the manifest

Excel on the web quickest

  1. Open a workbook in Excel at office.com.
  2. Select Home › Add-ins, then More Settings.
  3. In the Office Add-ins dialog, select Upload My Add-in.
  4. Browse to the manifest you downloaded, then select Upload. The task pane opens.

The 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.

Excel for Mac
  1. In Finder, press Cmd+Shift+G and go to ~/Library/Containers/com.microsoft.Excel/Data/Documents/wef. Create the wef folder if it doesn't exist.
  2. Copy the manifest into that folder.
  3. Restart Excel, open a workbook, then choose Revised File Check from Home › Add-ins.
Excel for Windows
  1. Put the manifest in a shared network folder, such as a folder you share from your PC.
  2. In Excel: File › Options › Trust Center › Trust Center Settings › Trusted Add-in Catalogs. Add the folder's network path, tick Show in Menu, then restart Excel.
  3. Choose Home › Add-ins (or Insert › My Add-ins), open Shared Folder, and add Revised File Check.

About the preview

Questions or feedback? Reply to the person who shared this page with you.