Copy the rows with their header row from Excel or Google Sheets. Excel files: open them and copy, or save as CSV.
Runs in your browser. The orders and the buyer details in them are not uploaded or saved.
We matched your column names, shipping columns before billing ones. Change any that are wrong.
Needed. Where the parcel went.
Needed. COD or prepaid.
Needed. Delivered, RTO and so on.
Optional. Or type an average in step 4.
Optional. Joins rows of one order.
Optional. For the months covered.
Optional.
Exports word these in many ways. Change any we read wrongly; values marked "not recognised" are left out until you pick one.
Your own numbers from your courier's or shipping app's rate card and your books. No fee or courier price is built in. These are kept in this browser for next time; the orders are not.
What the goods in an order cost you, as a share of what the buyer pays.
What you pay to send one parcel.
What you pay to get one parcel back.
Box, filler, tape and label.
Per delivered COD order.
Fill in both if your rate card says "whichever is higher".
On each prepaid order.
Damaged, opened or spoilt. The rest goes back on the shelf.
Used only when your export has no order value column.
The GST you collect is not your income, so it is taken out first. Check your rate with your CA.
Our suggestion: 10. Smaller PIN codes are judged with neighbours that share their first digits.
Your guess, for the saving estimate. The rest are counted as orders you no longer get.
Leave empty to work it out from the order dates.
Free COD Pincode Risk Analyzer. Runs in your browser, no sign-up. Open the full tool on DigitalSnot →