Skip to main content
FHAVI

Free resource

A P&L that survives the failed deliveries

Store dashboards report revenue at checkout. Cash arrives later, in smaller amounts, and only for the parcels that were actually delivered and collected. The difference is not a rounding error in cash-on-delivery markets — it is the number that decides whether the business made money.

The lines

Where the money actually goes

01

Build in this order

  1. Orders placed, and orders delivered — reported separately. The ratio is your first real quality metric.
  2. Revenue collected, not revenue ordered. If you only have ordered revenue, deduct failed and returned parcels before anything else.
  3. Cost of goods — supplier price plus inbound shipping, for delivered units only. Do not carry COGS for parcels that came back.
  4. Delivery and COD charges — the courier takes both on collection, so it never appears in a gateway statement.
  5. Gateway and platform fees, on collected revenue.
  6. Ad spend for the period, including the spend that produced the failed orders.
  7. Fixed costs, app subscriptions, salaries, and the returns processing cost that nobody assigns.
  8. Contribution and net margin, computed from collected revenue. Anything else flatters the month.

Traps

Four lines that make a P&L lie

02

Check each month

  1. Revenue recorded at order creation rather than collection — the single most common overstatement in COD businesses.
  2. Ad spend taken from a platform report while orders come from the store; the two date bases differ and the month gets a phantom profit.
  3. Returns booked in the month they were requested rather than the month they were refunded, which shifts the loss into a different period.
  4. Supplier payments booked as expenses when they leave the account, while the stock sits unsold — that is a balance sheet movement, not a cost.

Closing

The fifteen-minute month end

03

Sequence

  1. Export delivered orders and remittances for the month; reconcile the count before trusting any figure.
  2. Enter the eight lines above; let the sheet compute the derived ones.
  3. Compare against the previous three months, not against a target — the trend is the information.
  4. Write one sentence on what moved the margin most. That sentence is the entire management report.
  5. Carry the closing numbers into the cash flow forecast.

Keep going

The rest of the library

Every checklist here is free and ungated. The research pages carry the reasoning behind them.

All resources · Research library

Not sure the month made money?

Send an orders export and one courier statement. We will build the P&L once and show you which line was being misread.

Prefer email? Write to md@fhavi.com