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