How To Build A 13-Week Cash Flow Forecast For Your Store

WISELIVN BUSINESS GUIDES · CASH FLOW

A profitable sale does not pay a bill until the cash is available. A 13-week cash flow forecast helps you put expected receipts and payments on a weekly timeline so you can prepare for potential gaps.

Begin with cash you can actually use

Use the opening balance for the accounts included in your forecast, with a consistent treatment of restricted or reserved money. Do not count an expected customer payment or processor payout as money already available. Keep the scope clear so you do not add the same cash twice.

Place receipts and payments in their expected weeks

Enter receipts when you reasonably expect the money to arrive. Enter supplier payments, inventory purchases, advertising bills, payroll and other commitments when they are due. Separate sales projections from cash collection dates. For uncertain receipts, record the assumption and test a later date. Do not simply divide a monthly figure by four when the actual due date is known.

Follow the weekly calculation

Illustrative example: opening cash of $1,000 plus receipts of $800 minus payments of $1,200 leaves $600. The following week begins at $600. If receipts are $400 and payments are $1,100, projected closing cash is −$100. That negative result signals a gap in the assumptions; it is not an available bank balance or permission to spend.

Test timing before choosing an action

Move a major receipt one week later and check the effect. Test an inventory payment arriving earlier. Consider which discretionary commitments can be reviewed and which need a conversation with the relevant party. Do not enter a payment extension as confirmed until it has actually been agreed. A forecast shows possibilities; it does not arrange funding or guarantee receipts.

Make it a weekly habit

Replace elapsed weeks with actual receipts and payments, explain material differences, and roll the view forward. Review the lowest projected balance as well as the final week. Record one next action with an owner and date. The value comes from keeping the forecast current, not from making the first version look precise.

Put it into practice

Need the reason behind the weekly forecast? Read Why Profitable Businesses Can Run Out Of Cash for an example of the gap between profit and payment timing.

Put your forecast to work in the Cash Flow Planner, a paid monthly subscription. Compare scenarios, track actuals against your forecast, and save plans without maintaining spreadsheet formulas.

Prefer to learn the method first? Explore the free Cash Flow course. Browse the complete business guide series.

Examples are illustrative. Educational content does not replace professional advice. Results vary.