Cash-on-delivery reconciliation, parcel by parcel.
Couriers collect your cash at the door and pay it out later, in batches, minus their charges. Chatcart keeps every delivered cash-on-delivery order open until a payout settles it, so “how much does TCS still owe me?” has a one-line answer.
Why COD payouts are hard to check
- A payout covers many parcels at once, often delivered on different days.
- The amount that arrives is the cash collected minus the courier’s deductions (delivery and return charges, and tax on them), so it rarely equals your order totals.
- Returned parcels collect nothing but can still carry a charge.
- With several couriers, each pays on its own schedule and in its own report format.
How it works in Chatcart
- When an order is marked Delivered and it is cash on delivery, it appears on the Cash page, grouped by courier, with a running total of what is owed.
- When a payout arrives, upload the courier’s payment report as a CSV. Chatcart finds the tracking number, COD, charges and net columns, ticks the matching orders and fills in the amount paid.
- Lines that do not match are explained: not marked delivered yet (one click marks them), already settled, returned, prepaid or unknown.
- No report? Tick the orders the payout covers and type the amount. The difference between the payout and the orders’ total is shown, so deductions stand out.
- Each settled order links to its payout, with the date and reference.
A routine that takes minutes
- Mark parcels delivered as couriers confirm them (bulk-select on the Orders page).
- Record each payout the day it reaches your account.
- Check the “Couriers owe you” total once a week; anything delivered more than a payout cycle ago and still open is worth a call to the courier.
Questions
- Which couriers’ payout reports can Chatcart read?
- Any report that lists parcels with a tracking (consignment) number column, saved as CSV. Chatcart recognises the columns by their meaning rather than an exact layout, so reports from PostEx, Leopards, TCS, Trax, M&P and others work. Excel files need to be saved as CSV first.
- Is the report uploaded to your servers?
- No. The file is read in your browser; only the payout you record (courier, amount, date, reference and the orders it covers) is saved.
- Can I settle prepaid or hand-delivered orders?
- Yes. Prepaid orders are paid when entered, and any order can be marked “Cash received directly” from its page.