How do I track RTO without a spreadsheet?

You need a per-order status that distinguishes returned from cancelled, and freight recorded per parcel in both directions. Any system that gives you those two will do it; the spreadsheet stops working at volume, not at principle.

Does courier withholding tax come out of my revenue?

It comes out of the remittance. Your order value is unchanged and your bank credit is smaller, and nothing between the two records the difference unless you reconcile the settlement file.

Should a returned order count as a conversion?

Yes, and it should also be reported as returned. Someone chose to buy, so the channel earned the conversion — but a channel whose orders come back should not look identical to one whose orders stick.

What is the difference between RTO and a cancellation?

A cancellation happens before dispatch and costs you nothing but the admin. An RTO has already travelled, so it costs freight out, freight back and the packaging, while earning nothing.

How do I find a short remittance?

Only per parcel. Compare what the settlement file paid for each order against what should have arrived after the deductions you expect. A total that looks right can still contain offsetting errors.

What withholding rate should I use in my calculations?

The one on your own settlement files. Rates and rules change and depend on your filing status, so a figure quoted in any article — including this one — is the wrong source for a number you will make decisions on.

Tracking RTO and courier withholding tax without a spreadsheet

Markazi Panel3 September 20265 min read

Two deductions decide whether a cash-on-delivery business works, and neither of them touches your website, so no analytics tool has ever seen one. A returned parcel costs freight twice and earns nothing. Withholding is taken out of the money before it reaches you. Record them per order or your profit figure is fiction — and it will be fiction in the flattering direction.

RTO: the order that costs you twice

Return to origin. The parcel goes out, the customer refuses it or cannot be reached, and it comes back. You paid to send it and you pay to receive it. The packaging is spent. The goods return to stock, so their cost comes back — nothing else does.

The trap is that an RTO looks like a non-event in every system you own. Your website recorded a sale. Your analytics still shows it. Only the courier knows it came back, and only if you read their file.

Why deleting the order is the wrong fix

The instinct is to remove it so revenue is not overstated. Do not. The sale genuinely happened — somebody chose to buy, and the channel that brought them earned that. Delete it and you flatter whichever channel returns the most, because its failures vanish while its successes remain.

Keep the order, mark it returned, and report both figures side by side: what was sold, and what was kept. A channel with the same revenue and twice the return rate should look different from one without, and it only can if both numbers survive.

Withholding: money deducted before you see it

The rider collects the full amount in cash. The courier remits you less, having deducted withholding tax on the collected value. Two consequences follow, and both are easy to miss:

It applies to the collected amount, not your margin. A low-margin order is withheld at the same rate as a high-margin one, so it eats proportionally more of what you were going to keep.
It is invisible without the settlement file. Nothing in your order, your website or your analytics records it. The first place it appears is the difference between what you expected and what arrived.

Rates and rules change and depend on your filing status, so the figure to use is the one on your own settlement files, not a number from an article — including this one.

What each system can see

Where each deduction is visible. Both live outside the website entirely.
	Website / analytics	Courier portal	Your bank	Reconciled per order
Order was placed	Yes	No	No	Yes
Parcel came back	No	Yes	Only as absence	Yes
Freight out	No	Yes	No	Yes
Freight back	No	Yes	No	Yes
Withholding deducted	No	In the settlement file	As a smaller credit	Yes
Short payment on one parcel	No	Sometimes	No	Yes

Where each deduction is visible. Both live outside the website entirely.

The right-hand column is the only one that answers the question, and it is not a product — it is a method. You can do it in a spreadsheet.

How to record them without software

Give every order a status that includes returned, distinct from cancelled. A cancellation costs you nothing; an RTO costs you freight twice.
Record freight per parcel, not per month. A monthly courier total cannot tell you which orders were expensive, and zone pricing means they differ a lot.
Match the settlement file to orders, one line at a time. Totals hide short payments — an underpayment on one parcel and an overpayment on another can net to a total that looks correct.
Keep the cost of goods frozen at the time of sale, so a supplier price change next quarter does not rewrite what last quarter earned.

That is the whole method. It works on paper, and it stops working when the volume makes line-by-line matching take longer than the insight is worth — which is the point at which software is worth paying for, and not before.

Questions people ask

How do I track RTO without a spreadsheet?: You need a per-order status that distinguishes returned from cancelled, and freight recorded per parcel in both directions. Any system that gives you those two will do it; the spreadsheet stops working at volume, not at principle.
Does courier withholding tax come out of my revenue?: It comes out of the remittance. Your order value is unchanged and your bank credit is smaller, and nothing between the two records the difference unless you reconcile the settlement file.
Should a returned order count as a conversion?: Yes, and it should also be reported as returned. Someone chose to buy, so the channel earned the conversion — but a channel whose orders come back should not look identical to one whose orders stick.
What is the difference between RTO and a cancellation?: A cancellation happens before dispatch and costs you nothing but the admin. An RTO has already travelled, so it costs freight out, freight back and the packaging, while earning nothing.
How do I find a short remittance?: Only per parcel. Compare what the settlement file paid for each order against what should have arrived after the deductions you expect. A total that looks right can still contain offsetting errors.
What withholding rate should I use in my calculations?: The one on your own settlement files. Rates and rules change and depend on your filing status, so a figure quoted in any article — including this one — is the wrong source for a number you will make decisions on.

These two deductions are steps four and six of the arithmetic on a single order, which puts them in sequence with everything else that comes out along the way.

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.