Skip to main content
FHAVI

Free resource

Profitable on paper, short of cash on Tuesday

A store paying suppliers up front and receiving cash on delivery runs a permanent funding gap. The gap grows with volume, which means growth is what breaks it. A thirteen-week forecast is the only document that shows the gap before the bank does.

The mechanics

Why the gap exists

You pay the supplier when you place the order. The courier collects from the customer days later, then remits on a cycle — weekly, twice monthly, or worse. Every order therefore consumes cash for the length of that cycle, and the total cash tied up equals daily order volume multiplied by days in the cycle.

Doubling volume doubles the gap. A store that is profitable per order can still fail at exactly the moment it starts working, because the growth is funded from the same account that pays rent.

The sheet

Thirteen rows, one per week

01

Rows to build

  1. Opening cash — bank plus gateway balance plus any courier remittance in transit. Count the remittance; it is real money you cannot spend yet.
  2. Cash collected from couriers — actual expected remittance, by cycle, not by sales date.
  3. Cash collected from prepaid orders and gateway payouts — with the payout delay stated.
  4. Supplier payments — the amount you must pay this week to keep stock flowing.
  5. Ad spend — weekly, and remember it is charged before any revenue arrives.
  6. Fixed costs: salaries, apps, rent, software, tax set-aside.
  7. Debt service and any loan repayments.
  8. Closing cash — computed, never typed.
  9. Gap indicator: closing cash divided by average weekly outflow. Anything under two weeks is a warning, under one is a stop.

Reading it

Decisions the forecast actually changes

02

What to do when the line turns negative

  1. Slow the growth, not the collection: cut ad spend before cutting supplier orders that are already paid.
  2. Shift mix toward prepaid. A prepaid order removes the gap entirely — this is the cheapest fix available and it is a marketing problem, not a finance one.
  3. Negotiate remittance frequency with the courier before negotiating supplier terms; the cycle length is the multiplier.
  4. Hold a buffer sized to the worst week, not the average week.
  5. Re-forecast weekly. A forecast built once and never updated is a decoration.

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

Growing and getting tighter?

Send four weeks of orders, remittances and supplier payments. We will build the forecast and show which week is the risk.

Prefer email? Write to md@fhavi.com