Is a spreadsheet good enough for tracking COD profit?

Yes, if it has cost per variant frozen at sale, freight per parcel, returns as a distinct status with return freight recorded, and a monthly per-parcel reconciliation. Without those four it is systematically optimistic.

Why is my spreadsheet profit always higher than my bank balance?

Because its four common errors all point the same way — averaged costs, flat freight, returns treated as zero rather than negative, and withholding that never appears. They compound rather than cancelling out.

Should I delete returned orders from my sheet?

No. Deleting removes the revenue and also the freight you paid twice, which understates the cost of returns. Mark it returned and record the return freight against it.

How often should I reconcile courier settlements?

Monthly at minimum, and per parcel rather than by total. A total that matches can still contain a short payment on one order offset by an error on another.

At what order volume does a spreadsheet stop working?

There is no fixed number — the signal is behavioural. When you stop doing the per-parcel reconciliation because it takes too long, the sheet has stopped measuring profit whatever its volume.

What is the single most important column to add?

A returned status with its own return-freight figure. Returns are the largest and most flattering omission in almost every sheet we have been shown.

What tracking COD profit in a spreadsheet actually costs you

Markazi Panel3 September 20265 min read

A spreadsheet is the most common profit tool in Pakistani ecommerce and it is a perfectly respectable one. It is also not free: it costs hours, and it costs accuracy in four specific places. Every one of those four errors makes the number look better than it is, which is why a spreadsheet business is usually pleasantly surprised by its revenue and unpleasantly surprised by its bank balance.

What a spreadsheet is genuinely good at

Worth saying first, because most articles like this one exist to sell you something. A spreadsheet costs nothing, fits your business exactly, needs no integration and cannot be discontinued by a vendor. For a store doing a few dozen orders a month it is not a compromise — it is the correct tool, and buying software instead would be the mistake.

The four places it goes wrong

1. Cost of goods is an average, not a fact

Almost every hand-kept sheet holds one cost per product rather than per variant, and updates it when the supplier price changes. Both are quiet errors. A single average moves margin between your variants, so a large pack subsidises a small one and neither figure is true. Updating in place is worse: it rewrites history, so last quarter’s profit changes when this quarter’s supplier does.

Direction of the error: usually flattering, because the item you sell most is usually the one whose real cost has risen.

2. Freight is a flat number

The sheet has one delivery cost. The courier prices by zone, weight and service. Karachi to Karachi and Karachi to a village in Balochistan are not the same expense, and if your flat figure was set from a city average, every remote delivery is quietly under-costed.

Direction of the error: flattering, and it grows as you sell further from home — which is exactly what happens when a store starts working.

3. Returns are counted once, or not at all

The commonest handling is to delete the row. That removes the revenue, which feels right, and also removes the freight you paid twice and the packaging you spent — which is wrong. The second commonest is to mark it returned and subtract the sale, without adding the return freight as a cost.

Direction of the error: strongly flattering. A refused parcel is not a zero, it is a negative, and a sheet that treats it as a zero hides the single biggest risk in a COD business.

4. Withholding is invisible

The rider collects the full amount, so the sheet records the full amount. The courier remits less. Unless someone reconciles the settlement file line by line, the difference never appears anywhere — and reconciling line by line is exactly the job people stop doing first when the volume rises.

Direction of the error: flattering, on every single delivered order.

Why all four point the same way

This is the part worth sitting with. These are not random inaccuracies that cancel out. Each one omits a cost or overstates a receipt, so they compound in the same direction. A spreadsheet does not give you a slightly fuzzy number — it gives you a systematically optimistic one, and the size of the optimism grows with the things that indicate success: more remote deliveries, more volume, more returns in absolute terms.

How to make one honest

If you are staying with a sheet, these four changes fix most of it.

A cost column per variant, written at the time of sale, not looked up later. Copy the number into the row; never formula it against a live cost table.
Freight per parcel, from the courier’s own charge, not a constant. If that is too much work, keep at least two rates by zone.
A status column with returned as its own value, distinct from cancelled, and a return-freight column that is filled in for every one of them.
A monthly reconciliation against the settlement file, per parcel rather than by total. Totals hide short payments, because an underpayment on one parcel and an overpayment on another net out.

A sheet with those four is genuinely accurate. The remaining cost is the hour it takes every week, for ever, and the fact that it is only as current as the last time somebody did it.

When to stop

Not at a particular order count — at the point where you stop doing the reconciliation. That is the honest signal, and it is observable: look at whether last month’s settlement file was ever matched line by line. If it was not, the sheet has already stopped being a record of your profit and become a record of your revenue with some deductions applied from memory.

Questions people ask

Is a spreadsheet good enough for tracking COD profit?: Yes, if it has cost per variant frozen at sale, freight per parcel, returns as a distinct status with return freight recorded, and a monthly per-parcel reconciliation. Without those four it is systematically optimistic.
Why is my spreadsheet profit always higher than my bank balance?: Because its four common errors all point the same way — averaged costs, flat freight, returns treated as zero rather than negative, and withholding that never appears. They compound rather than cancelling out.
Should I delete returned orders from my sheet?: No. Deleting removes the revenue and also the freight you paid twice, which understates the cost of returns. Mark it returned and record the return freight against it.
How often should I reconcile courier settlements?: Monthly at minimum, and per parcel rather than by total. A total that matches can still contain a short payment on one order offset by an error on another.
At what order volume does a spreadsheet stop working?: There is no fixed number — the signal is behavioural. When you stop doing the per-parcel reconciliation because it takes too long, the sheet has stopped measuring profit whatever its volume.
What is the single most important column to add?: A returned status with its own return-freight figure. Returns are the largest and most flattering omission in almost every sheet we have been shown.

The arithmetic those four columns are trying to reproduce is in how to work out your real profit on one order, done by hand once so you can see what the sheet is approximating.

Written by Markazi Panel, which does the arithmetic in this guide for you — see a dashboard with a month of data in it, or ask anything at hello@markazipanel.com.