1
Gather your opening cash balance and bank statements
Pull your current bank balance and the last 3 months of bank and credit card statements. This is your baseline β every projection starts from a verified real number.
π‘ Reconcile your bank balance to your accounting software before entering any numbers. An unreconciled gap in the opening balance will compound into every forecast week.
2
List all expected inflows by source and timing
Map every expected cash receipt β customer payments, loan drawdowns, owner injections β to the specific week you realistically expect it to land in your account, not the invoice date.
π‘ Use your historical DSO to estimate receipt dates. If your average DSO is 38 days, shift each invoice receipt 38 days from the invoice date, not 30.
3
Map all fixed and variable outflows to payment dates
List every scheduled outflow β payroll, rent, supplier payments, loan repayments, tax instalments β on the date the cash actually leaves your account, not the invoice or accrual date.
π‘ Pull your direct debit schedule from your bank portal to catch subscriptions and automatic payments that often get missed in manual forecasts.
4
Calculate the weekly closing balance and flag shortfalls
Subtract total outflows from total inflows for each week, add the opening balance, and record the closing balance. Highlight any week where the closing balance falls below your minimum threshold.
π‘ Color-code the closing balance row: green above threshold, amber within 20% of threshold, red below. This makes shortfall weeks visible without reading every number.
5
Classify each shortfall as timing or structural
For every red or amber week, identify the cause. A timing gap (receivables arriving a week late) requires a different response than a structural gap (outflows permanently exceeding inflows at current revenue).
π‘ If more than three consecutive weeks show structural shortfalls, the problem is not a cash flow management issue β it is a pricing or cost structure issue that a line of credit will only defer.
6
Select and document the response for each gap
For each identified shortfall, record the specific action β accelerate invoice collection, defer a discretionary expense, draw the line of credit, or initiate a supplier payment negotiation β with the responsible person and deadline.
π‘ Assign one owner per action item. Shared accountability for cash gap responses means no one acts until it is too late.
7
Update the forecast weekly and review actuals vs. plan
Every week, enter actual inflows and outflows, compare them to what was forecast, and roll the 13-week window forward by one week with updated assumptions.
π‘ Persistent forecast errors in the same category β e.g., customer receipts always arriving 5 days later than projected β signal a bad assumption that needs a permanent fix, not just a weekly adjustment.