See the week cash gets tight, before payroll does.
A 12-month and 13-week cash flow forecast spreadsheet for small businesses, built by a Toronto bookkeeper with 20+ years of small-business books. No subscription, no bank login.
Instant download · Works in Excel and Google Sheets · QuickBooks Online & Xero paste-in (Pro)
Month-end stayed positive. Two weeks didn't.
Sample 13-week view, fictional business
Profitable on paper, tight in the bank?
Usually it is not a profit problem. It is a timing problem: bills arrive before the customer pays.
Bills land early, payments trickle in
Rent, payroll and suppliers hit at the start of the month. Customer payments arrive over weeks. Month-end can look fine while the middle is in the red.
Lumpy costs catch you off guard
Sales tax remittances, payroll source deductions, tax instalments, insurance and loan payments don't arrive evenly. The forecast puts each one in the month it is due.
The bank wants a projection
Applying for a loan or line of credit? Pro prints a one-page Bank Summary with 12 months of cash flow and your notes.
Pick your edition
Same files in both stores. Gumroad checks out right on this page in US dollars. Etsy is in Canadian dollars if you prefer buying there.
Starter
For owners who want a 12-month plan they fill in themselves.
- 12-month cash forecast with month-end bank balances
- Lowest-month, minimum-buffer and runway alerts
- Best and worst case switch
- Plans for customers who pay late
- Sales tax, payroll remittances, tax instalments, loans and planned purchases
Pro
For businesses where a monthly view hides a bad week.
- Everything in Starter
- 13-week, week-by-week cash forecast
- Paste in from QuickBooks Online, Xero or your bank, with built-in row checks
- One-page Bank Summary for your bank, lender or investor
Advisor
For bookkeepers, accountants and fractional CFOs.
- The full Pro forecaster
- Licensed for up to 25 client businesses plus your own firm
- Your firm name, contact line and footer on the Bank Summary, with room for your logo
- Turn an AR aging export into a 13-week view in minutes
Browse everything: Gumroad store · Etsy shop ↗
How it works
About an hour for a first forecast if you have your last few bank statements handy.
Enter today's cash
Add your bank balance, regular money in and money out, and the lumpy items: tax remittances, instalments, loans, planned purchases.
Paste in your data (Pro)
Export open invoices or bank history from QuickBooks Online, Xero or your bank and paste it in. It works out when money should arrive.
Read the alerts
See your lowest month, your runway, and the weeks below your minimum buffer. Flip to worst case to stress-test it.
What you get
- Blank template (.xlsx)
- Filled-in sample for a fictional renovation company
- Quick-start guide (PDF)
- Licence (one business; Advisor: up to 25 clients)
Instant download, one zip file. Nothing is shipped.
Works with
- Microsoft Excel
- Google Sheets
- No subscription, no bank login, no app connection
- Your numbers stay in your file
Industry editions on Etsy
Starter editions with sample figures for your type of business:
Built by a working bookkeeper
Sajid Shaikh runs NumericX, a Toronto bookkeeping practice, and has spent 20+ years keeping small-business books in Ontario. The forecaster is the same cash view he builds for clients before a slow season or a loan application.
Prefer a hand? Bought the forecaster and want to build your first forecast together on a call? Email info@numericx.net.
Questions
Does it need a subscription or a bank login?
No. It is a one-time download that runs in Microsoft Excel or Google Sheets. No subscription, no bank login, no app connection. Your numbers stay in your file.
Which edition should I buy?
Starter if you want a 12-month plan you fill in yourself. Pro if bills and customer payments land unevenly through the month, or you want to paste in data from QuickBooks Online, Xero or your bank and print a Bank Summary for a lender. Advisor if you are a bookkeeper or accountant using it with clients.
Why are there two stores?
Same files in both. Gumroad charges in US dollars and checks out on this page. Etsy charges in Canadian dollars and suits buyers who already have an Etsy account.
Do I need QuickBooks or Xero?
No. Every edition works with numbers you type in. The paste-in from QuickBooks Online, Xero or a bank export is an optional shortcut in Pro and Advisor.
Can I get a refund?
Digital downloads are delivered instantly. If something is wrong with your file, email info@numericx.net and it will be sorted out.