Educational information only: A forecast is an estimate based on assumptions. It is not financial, tax, lending, or investment advice and it does not guarantee future cash availability.

Why 13 weeks?

Thirteen weeks covers roughly one quarter while keeping the view detailed enough for weekly decisions. It can show several payroll cycles, monthly rent and debt payments, tax dates, customer receipts, and planned purchases without pretending that distant estimates are precise.

Step 1: Start with available cash

Use the cash that is actually available at the start of week one. Separate restricted funds, uncleared deposits, and amounts that cannot be used for ordinary operations. If the bookkeeping bank balance is unreliable, reconcile the account before using it as the forecast opening position.

Step 2: Create weekly columns

Create one column for each of the next 13 weeks. Each column should contain opening cash, expected inflows, expected outflows, net movement, and closing cash. The closing cash for one week becomes the opening cash for the next.

Step 3: Forecast customer receipts realistically

Begin with open invoices and expected payment dates. Use customer payment history instead of assuming every customer pays exactly on the due date. Separate large or uncertain receipts so their effect is visible.

• Confirmed receipts with a known payment date
• Expected receipts based on normal customer behaviour
• New sales that are likely to convert to cash within the period
• Other cash inflows, such as owner funding, refunds, or financing, clearly labelled

Step 4: Schedule committed payments

List payments in the week they are expected to leave the bank, not simply the month in which the expense appears in the accounting records.

• Payroll and payroll-related remittances
• Rent, utilities, subscriptions, and insurance
• Supplier and contractor payments
• Loan principal, interest, and bank fees
• Sales-tax and other government remittances where known
• Equipment purchases and planned owner withdrawals

Step 5: Separate fixed, variable, and discretionary outflows

This classification makes the forecast actionable. Fixed or legally committed payments may have little timing flexibility. Variable payments move with activity. Discretionary purchases may be delayed if the forecast shows pressure.

Step 6: Calculate weekly closing cash

For each week, add expected inflows to opening cash and subtract expected outflows. Highlight a minimum cash threshold that gives the owner time to respond rather than waiting for the bank balance to reach zero.

Step 7: Add scenarios

A useful forecast can show the effect of a late customer payment, an unexpected expense, or a delayed purchase. Keep scenarios focused on decisions the owner can actually make.

• Expected case: the most realistic timing assumptions
• Pressure case: major receipts arrive later or a material payment increases
• Action case: collections improve, spending is rescheduled, or another approved response is taken

Step 8: Update actuals every week

Replace forecast amounts with actual receipts and payments for the completed week. Move the remaining assumptions forward, add a new thirteenth week, and record why material differences occurred. Accuracy improves when assumptions are reviewed, not when the spreadsheet becomes more complicated.

Common forecasting mistakes

• Using accounting profit as a substitute for cash timing
• Counting invoices as cash before customers are likely to pay
• Forgetting payroll remittances, tax payments, debt principal, or annual renewals
• Hiding large uncertain items inside broad categories
• Updating the forecast only when cash is already tight
• Adding so much detail that no one maintains it

The weekly owner review

A useful review can take 15 to 30 minutes. Focus on the lowest projected cash point, receipts that changed, payments requiring a decision, overdue invoices, and the actions assigned for the week.

If your source data is unreliable, begin with bookkeeping cleanup. If the structure is clear but difficult to maintain, explore cash-flow forecasting and dashboard support.