- Home
- 13-Week Cash Flow Forecast
13-Week Cash Flow Forecast
- $24.00
13-Week Cash Flow Forecast
- $24.00
The problem. Income is uneven, a few large bills land close together, and the gap in the bank account is only noticed in the week it arrives.
What this does. You list what you expect to receive and pay: once for anything that repeats, and once for each one-off item. The workbook places every item in the right week and shows your bank balance for each of the next 13 weeks. It flags the lowest point, the week it happens, and every week that falls below a buffer you set.
What you can do with it
- See opening balance, money in, money out and closing balance for each of the next 13 weeks.
- See the lowest balance and the week it happens, in one warning line.
- Set your own buffer and see how many weeks fall below it.
- Enter repeating items once: weekly, fortnightly, every 4 weeks, monthly, quarterly or once, with an optional end date.
- Give tax, payroll and other large bills their own rows, using category names you can change.
- Type what really happened each week and see the difference from your forecast.
- Roll forward to a fresh 13 weeks by changing two cells.
How it works
- Enter your currency symbol, the first day of week 1, your bank balance and your buffer.
- List your recurring items and your one-off items, each with a date.
- Read the dashboard, then update your actual figures each week and roll forward.
Who it is for. Small businesses and sole traders with uneven income or large bills, who want to know about a cash gap while there is still time to act.
Who it is not for. Businesses that want forecasts built automatically from their bank or accounting software, or that need a full-year budget or profit forecast. This workbook shows cash in the bank for 13 weeks. It does not work out tax, wages or interest: you enter those amounts.
What you need. Microsoft Excel 2016 or later. No macros, no add-ins, no subscription and no AI.
Good to know
- Works with any currency: you set the symbol. Week 1 can start on any day.
- No tax rules are built in. Tax, payroll and other obligations are items you add with your own amounts and dates.
- A monthly or quarterly item dated the 29th, 30th or 31st falls on the last day of a shorter month.
- 200 recurring rows and 500 one-off rows are ready, and you can extend either sheet by dragging the last row down.
- Nothing is locked or password protected.
- General information only. It is not accounting, tax, legal or financial advice. A forecast is an estimate.
Enter your email to receive a one-time alert if this product's price decreases.
Customers also buy
You might also like
Recently Viewed
© 2026 TeleWorld Online




