🎉 Black Friday: off every tracker · Or get all 8 for $49.99 → 🎉 Get all 8 spreadsheets for $49.99, save $109.93 vs buying separately →

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.

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

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.

⚠ Important: please readA planning tool for information only. It is not tax, legal, accounting, lending, investment or financial advice, and it doesn't replace a qualified professional. Results depend on the figures you enter; lenders, platforms and tax authorities apply their own rules. Check important decisions with a professional. Images show the real workbook with sample data.

You might also like