
What it does
A profitable service business can still run out of cash. One large client pays a month late, payroll and the quarterly tax instalment land in the same week, and the bank balance drops below what you need to operate. This planner lays out the next 13 weeks of cash, week by week. You enter your bank balance, your unpaid invoices with their expected payment dates, payroll and owner draws, recurring bills, loan payments, tax payments and one-off items. It shows each week's opening cash, money in, money out and closing balance, and flags the first week the balance falls below the minimum you choose.
- Configurable start date, opening bank balance and minimum cash level
- Rolling 13-week forecast: opening, inflows, outflows, closing and status for each week
- Invoice register (300 rows): expected date from terms or your override, part payments, overdue and paid status
- Only the open balance of each invoice is forecast, so received cash is never counted twice
- Overdue invoices placed a set number of days after the start; receipts after week 13 shown separately
- Payroll and owner draws (weekly, biweekly, semi-monthly, monthly), recurring bills, loan payments and tax instalments
- One-time items: expenses, other cash in, debt payments and tax payments you enter
- Base, delayed-payment and downside scenarios side by side
- Dashboard: lowest closing balance, first shortfall week, total collections, cash out and overdue invoices, with two charts
- Weekly forecast-versus-actual log with variances and an unexplained-difference check
What's inside
Workbook tabs: Start Here · Dashboard · Invoices · Payroll & Owner Pay · Recurring · One-Time Items · 13-Week Forecast · Scenarios · Weekly Review. Download: one .zip with 2 Excel workbooks (.xlsx), a PDF user guide and a licence.
Who it's for
- Consultants, agencies, studios, clinics, contractors and other service businesses that invoice clients and pay staff, rent and suppliers on a schedule.
Frequently asked questions
Is this the same as a profit and loss forecast?
No. It tracks when cash actually moves. An invoice counts when it's paid, not when it's sent.
What happens to an invoice that's already overdue?
It's placed a set number of days after the start date (14 by default; you can change it), and it's flagged as overdue.
What if a client pays part of an invoice?
Enter the amount in Received to date. Only the remaining balance is forecast.
Does it connect to my bank or accounting software?
No. You enter or paste the figures yourself.
Does it work in Google Sheets?
It hasn't been tested there yet. It's built for Microsoft Excel.
You might also like

Freelancer Owner Pay Planner
Plan a steady monthly owner withdrawal from uneven freelance income while keeping your tax reserve and business cushion intact. 12-month Excel plan with a worked example.

Subscription & Vendor Renewal Audit Kit
One register for every subscription and vendor contract: annualized cost, cost per active user, unused seats, price increases, overlaps and cancellation deadlines, with potential vs realized savings. Excel template with a worked example.

Small Business Funding Projection Kit
Plan an expansion or start-up loan: uses and sources of funds, up to 2 loan schedules, and 24 months of connected profit and loss, cash flow and balance sheet in base, conservative and optimistic scenarios. Includes DSCR, a print-ready Funding Summary and a document checklist.