Excel vs software for payout reconciliation: when spreadsheets stop working

Why everyone starts in Excel

Spreadsheets are free, flexible and familiar. For a small seller with a few dozen orders a month on one platform, a sheet with a few lookups is a perfectly good reconciliation tool. Many sellers and accountants have built clever templates.

Where spreadsheets start to hurt

Report formats change

Marketplaces, gateways and couriers change column names and layouts. A template that worked last month quietly breaks, often without an error, just wrong lookups.

One order, many rows

A single order can appear across several rows and several payouts: the sale, the fee, the shipping, a return, an adjustment weeks later. Matching that by hand is where most errors creep in.

Volume

At a few thousand orders a month across two or three platforms, lookups slow down, files get heavy, and checking takes a full day or more. Most people respond by checking less often, which defeats the purpose.

No evidence trail

A spreadsheet tells you a number is different. It rarely keeps the evidence you need to claim it: which rows, which rule, which dates.

Key-person risk

The template lives in one person's head. When they are busy or leave, reconciliation stops.

Signs it is time to switch

• You reconcile less often than you would like because it takes too long
• You have found errors in your own template
• You sell on more than one platform or use both prepaid and COD
• You cannot easily explain a payout line by line
• Claims are raised late or not at all

What good software should do

• Read each platform's own reports as they are, without reformatting
• Explain every payout, not just flag totals
• Separate timing differences from real ones
• Keep the evidence for each difference
• Protect data: buyer details should not need to leave your device
• Cost less than the money it finds

The honest middle ground

You do not have to give up spreadsheets entirely. Many businesses use software for the matching and a sheet for their own notes and claim tracking. The free claim tracker template is built for exactly that.

Veritally reads marketplace, gateway, courier and restaurant reports, explains every payout and lists the differences worth claiming. Report files are read on your own device, and buyer details are removed before anything is sent. Checking is free, so you can compare it with your spreadsheet on the same month before you decide.