Skip to content

Reconcile two spreadsheets — without checking every row by hand

When two files that should agree don't, the answer is buried in the rows. Tally recomputes every figure from the source data and shows you the exact number that doesn't tie out — and the rows that prove it.

The problem

The manual reconciliation grind

You have two spreadsheets that are supposed to say the same thing — your numbers and a contractor's, this month's file and the master, a summary and the raw data it came from — and they don't agree. So you sort both the same way, line them up, and start hunting for the row where they split apart.

Operators describe it the same way everywhere: "reconciling thousands of transactions between our data and a contractor's, where the formats are completely inconsistent,"and "how do you reconcile different spreadsheet formats?" The numbers usually aren't even wrong on purpose — a row got double-counted, a currency symbol turned a number into text, a footer total got read as data. But finding which one takes an afternoon you didn't have.

How Tally does it

Recompute, then reconcile

Independent recomputation

A separate engine re-adds every figure straight from the rows underneath — it doesn't trust either file's summary, it rebuilds the number itself.

The one that doesn't tie out

Instead of a wall of differences, you get the figure that's actually off — and, in plain language, why it's off.

A receipt for every number

Click any figure and see the exact source rows behind it. Nothing to take on faith — the proof is one click away.

What's live today

Right now you can run this check on a report against its own source data — free, in your browser, catching an error inside your own spreadsheet with the receipt. Reconciling twoseparate files (and tying out against QuickBooks) uses the same engine and is the next release. Try the live check, and join the interest list to hear when two-file reconciliation ships.

Reconciling two spreadsheets — common questions

See it check your numbers

Free, no account, and your file never leaves your browser.

Related: Does my report match QuickBooks?· What Tally is