Account Statements and Reports
Cash-on-Delivery Orders: Match Courier Collections to Your Payout
A courier payout can differ from the value of dispatched orders for several reasons. Follow a worked example to separate delivery, collection, returns, fees, and the money you actually receive.
Our editorial and review policy · About the product developerYou dispatched orders worth 1,350, then received a courier payout of 900. The difference does not immediately mean the courier has withheld money owed to you: some orders may still be undelivered, some may have been returned, and the batch may carry fees. Accepting the figure without checking it, however, could also conceal a real shortfall.
To reach a clear conclusion, separate the progress of each order from the movement of its money. You need to know what was delivered, what was collected, what the settlement statement deducted, and what actually reached you. An organized ledger helps you follow these stages without turning every status change into another financial transaction.
Four statuses that should not all mean “done”
An order can leave for delivery without reaching the customer. It can be delivered and paid for while the courier still holds the proceeds. It can also be returned in full or in part. Each status has a different effect on the payout you should expect.
Give each order one reference that connects your order list with the courier's statement. Record delivery and collection separately: delivery confirmation alone does not prove how much was collected unless the report also confirms that amount.
A simple reconciliation sheet is enough to start. Include the order number, order value, status, amount collected, courier settlement reference, and a note. You can perform this review without assuming any automatic connection between Zawid Accounts and the courier.
A complete example with five orders
Assume every amount uses the same currency and the order values below exclude any additional delivery charge collected from the customer. All five orders belong to one dispatch batch, with no older amounts included.
| Order and value | Status | Collected |
|---|---|---|
| 101: 300 | Delivered and collected | 300 |
| 102: 450 | Delivered and collected | 450 |
| 103: 250 | Delivered and collected | 250 |
| 104: 200 | Not delivered | 0 |
| 105: 150 | Returned without collection | 0 |
| Total value: 1,350 | Mixed statuses | 1,000 |
The amount collected is 1,000, not 1,350. In this example, the pending and returned orders do not represent customer money that the courier received and then retained.
The settlement statement applies an agreed delivery fee of 15 for each delivered order and a return fee of 10 for the returned order. Total fees are 45 plus 10, or 55. The expected net payout for this settlement is therefore 1,000 minus 55, which equals 945.
If you receive only 900, the difference requiring an explanation is 45. Do not automatically record it as another expense. Look for an itemized deduction, a deferred amount, or an order assigned to a different settlement. Request a breakdown if the statement does not explain the difference.
Reconcile the statement in this order
- Identify the settlement number, period, and currency, and make sure you are not mixing batches.
- Match the order numbers individually, paying particular attention to pending and returned orders.
- Add the confirmed customer collections, then review the documented fees.
- Calculate the net amount due for transfer and compare it with the money actually received.
- Record unresolved differences, the reason for each one, and a follow-up date.
Compare like with like. Today's payout may relate to an older settlement while today's orders are still out for delivery. Comparing one day's sales with another day's transfers can create an apparent discrepancy that has nothing to do with missing collections.
How to use Zawid Accounts without duplicating a payment
If the order amount is already recorded as due on the customer's account and you confirm that the courier collected it on your behalf, record the customer's payment once, with the order reference and collection statement. The later transfer of the net proceeds to you is a reconciliation stage with the courier, not another payment from that customer.
For order 101, the customer has already paid 300. Do not record a second payment of 300 when the courier settlement arrives, or leave part of the customer's debt outstanding because of a delivery fee that you bear in this example. Check who pays the fees under your own agreement before applying these figures.
Keep the courier reconciliation sheet to track money collected but not yet transferred. The customer's account balance alone is not a record of how money moves between you and the courier. This guide does not assume that Zawid Accounts automatically retrieves parcel statuses or transfers: you enter verified information and review it yourself.
When recording business fees as expenses, enter each fee once with the settlement reference and leave it unlinked to the customer's account in this example. The expense entry guide explains how to choose the type, date, and currency. Do not record the net payout as another sale on top of a sale already entered.
Separate returned orders from payout discrepancies
Order 105 was returned without collection. That is an order and stock status, not a cash deduction of 150 from the 1,000 already collected. The return fee of 10 is a separate item under the example's settlement statement.
Review the return's effect on sales and inventory records according to what actually happened. The sales and purchase returns guide helps distinguish stock movements from financial settlement. Do not change a quantity or customer balance merely to make the payout match an incorrect expectation.
To connect the courier statement with your entries during review, use a consistent reference in transaction notes that distinguishes one settlement from another.
Frequently asked questions
Does every delivered order mean its payment has reached my account?
No. Check collection evidence, then the settlement statement, then receipt of the transfer. Each stage needs its own confirmation.
Should I automatically charge the customer the difference in shipping fees?
Do not infer that from the difference alone. Check the agreement, the original order value, and who bears the fees. Avoid creating a new debt without a clear amount actually owed.
What should I do with an unexplained difference?
Keep it as an open item on your reconciliation sheet, with the settlement and order references and a record of your follow-up. Do not invent a transaction to force the difference to zero.
Start with one complete settlement
Choose a small statement and review its orders, fees, and transfer until you can explain every figure. Then use the same reference in your transaction notes. Zawid uses subscriptions with no ads. Review trial eligibility and activation options in your app; reading, export and backup remain available after access expires.
Keep your next record clear
Use Zawid Accounts on Android without ads. Review current subscriptions and activation options in the app.
Apply the idea to your records
Start with accurate entries and original documents, then use account statements and backups to keep a clear record.