00For the month-end close

Which spreadsheetis the real one?

CloseDiff keeps the official copy of every close file. Emailed versions become a clear list of what changed. Review them, lock the final one, and keep the record.

TB_final.xlsx
TB_final_v2.xlsx
TB_FINAL_real.xlsx
Prepaid rent scheduleclose_final_v3.xlsx
JanFebMar
Opening5,0006,0007,040
Additions2,0002,0002,000
Amortization(1,000)(1,000)(1,000)
FX—40(25)
Closing6,0007,0408,015
who changed this?

01The problem

A close runs on email. Every reply is one more copy of the file.

TB_final.xlsx
TB_final_v2.xlsx
TB_FINAL_real.xlsx
TB_final_v2 (1).xlsx
Copy of TB_final.xlsx
TB_final_MG_edits.xlsx
TB_v3_use_this_one.xlsx
TB_final_final.xlsx

Eight files. One close.
Which did the controller sign?

02What gets lost

Prepaid rent scheduleclose_final_v3.xlsx
JanFebMar
Opening5,0006,0007,040
Additions2,0002,0002,000
Amortization(1,000)(1,000)(1,000)
FX—40(25)
Closing=SUM(B3:B6)6,0006,5007,0408,015

CloseDiff flags it

Formula replaced by a number

Somewhere in this file, one number moved.

It used to be a formula.

Now it is a number somebody typed. Nothing in the file says so.

03How CloseDiff fixes it

The file arrives by email.

Each vault has its own address. Nobody installs anything or changes how they send files.

To: march-tb.k3f9@in.closediff.com

Updated schedule attached

📎 close_v8.xlsx

2 cells changed · 1 row added

Prepaid rent › Amortization(1,000) → (1,500)

Prepaid rent › Closing6,000 → 6,500

⚑ Formula replaced by a number

Maria is reviewing

Approve
🔒 Locked · Final

Signed off by Maria

03A closer look at the diff

Two versions of the same file.

The official copy on the left, the file that just arrived on the right.

Every cell gets compared.

Rows are matched by their labels, so an inserted row doesn’t shift everything below it.

What matches falls away.

Nobody has to read the cells that didn’t change.

What’s left is the review.

Each change shows the old value, the new value, and how much it moved. Quiet edits get flagged.

Officialv7
Opening5,000
Additions2,000
Amortization(1,000)
FX—
Deposit adj.no row
Closing6,000
Incomingv8
Opening5,000
Additions2,000
Amortization(1,500)
FX—
Deposit adj.250
Closing6,500

2 cells changed · 1 row added · 1 flag

  • Prepaid rent › Amortization(1,000) → (1,500)
  • Prepaid rent › Deposit adj.250
  • Prepaid rent › Closing⚑ Formula replaced by a number6,000 → 6,500

04Locked means frozen

A late file can’tchange the final one.

It is stored and never lost, but it waits. The sender gets a reply saying so, and only an admin with a written reason can reopen the vault.

August Sales

Locked by Priya · Final

sales_late_edit.xlsx

05The record

When someone asks what happened, it’s written down.

Who sent it, who approved it, who unlocked it and why. Entries are added, in order, and the old versions stay.

  1. Version created by email, from priya@…
  2. Held the vault was locked
  3. Unlocked by an admin: “late commission correction”
  4. Review opened against the current version
  5. Approved by Maria: “ties to the commission report”
  6. Locked Final v2, signed off

06What else is in the box

Works from email

Send a file to the vault address. There is nothing for submitters to install or log in to.

Handles real workpapers

Roll-forwards and schedules are matched by their row labels, so an inserted row does not shift everything below it.

Catches the quiet edits

A formula replaced by a number, a new #REF! error, or a hidden sheet added: each gets its own flag.

Handles big files

Start with the summary and a per-column rollup, page through changes, and export the full list.

Your file stays your file

An approved file becomes the official copy byte for byte, and every earlier version is kept.

Encrypted at rest

Stored files are encrypted, and each organization only ever sees its own vaults.

Next close,know what changed.