Where your cash on delivery sits.
Put what your carriers collected beside what reached your account. You see the gap, the cash they hold while they settle, and what the days beyond your target cost you each year.
What the diagnostic shows before you change a number
These panels use the starting figures in the calculator above. Replace them with yours and the answer moves.
Collected is not the same as settled
Anything collected and not settled is in transit, deducted for a reason you have not seen, or lost. Trace it carrier by carrier, starting with the largest.
27,000
Collected and not settled to you
That is 3 in every 100 collected.
Cash your carriers hold as settlement slows
- 120,0004 days
- 210,0007 days
- 330,00011 days
- 420,00014 days
- 540,00018 days
Of every hundred collected
Settled to you 97
Yearly cost of the days beyond your target
- 27,000Collected, not settled
- 330,000Held by carriers on an ordinary day
- 210,000Held beyond your 4-day target
- 16,800Yearly cost of those days
Two lines for the gap, three for the time
The first two lines measure the gap. Anything collected and not settled is either owed to you and in transit, deducted by the carrier for a reason you have not seen, or lost. That figure is the amount to trace carrier by carrier, starting with the largest.
The last three lines measure time. Cash held shows how much of your money sits with carriers on an ordinary day, given the average collection per day and the days they take to settle. The excess line counts only the days beyond your target, and the final line prices that excess at the rate you enter, as a cost for a full year.
The calculator spreads the collection evenly across 30 days and prices the days beyond your target at the capital rate you enter. Replace the starting figures with your own.
Trace the gap to its carrier and its cause
COD reconciliation and exception management matches every collection to a settlement and sets the exception routine your finance team runs. The Control Diagnostic shows how far you depend on carriers to hold your cash at all.
Related
- COD reconciliationEvery cash-on-delivery order matched to its money, and what your carriers still hold.
- Logistics cash conversionThe cash conversion cycle in days, the working capital it ties up and the cash growth would need.
- Delivery invoice and COD controlWeekly matching of carrier invoices and cash-on-delivery remittances to orders, with exceptions chased to closure.
Bring last month. Leave with a score.
Sit down with Qasim Abbas. One table, your numbers, and a clear read on where you stand against par.