
What it does
Freelance income arrives in bursts: a big month, then two quiet ones. Pay yourself too much after a good month and the tax bill or a slow season catches you short. Pay yourself too little and you're living on less than the business can afford. This planner works through 12 months of expected and actual receipts, business expenses, debt payments and tax payments. It keeps three things apart: your total cash, the money earmarked for tax and other reserves, and the available cash you can actually take. Each month it shows the most you could withdraw while keeping your reserves and your minimum business cushion, and it works out one steady amount that fits all 12 months.
- Twelve months of expected and actual receipts; an actual always replaces the estimate
- Business expenses, debt payments and the tax payments you actually make
- Opening cash split into tax reserve, other reserves and available cash
- Tax reserve rule you choose (a % of receipts minus expenses, or of gross receipts), stated on every sheet
- Tax payments use the reserve first, so they're never deducted twice
- Minimum business cash reserve and target monthly withdrawal
- Affordable withdrawal each month, with "Over affordable" and "Reserves not covered" flags
- Steady withdrawal that fits all 12 months
- Expected, strong-month and weak-month scenarios
- Month-by-month opening-to-closing cash reconciliation with a zero check
What's inside
Workbook tabs: Start Here · Dashboard · Monthly Inputs · Monthly Plan · Reconciliation · Scenarios. Download: one .zip with 2 Excel workbooks (.xlsx), a PDF user guide and a licence.
Who it's for
- Freelancers, contractors and sole proprietors with irregular client payments who want to pay themselves a predictable amount.
Free calculator: Freelance hourly rate calculator
Frequently asked questions
Does it tell me how much tax I owe?
No. It sets money aside using a rate you choose and tracks the tax payments you make.
Why doesn't setting money aside reduce my cash?
Because it's still in your account. The planner moves it from available cash to a reserve; total cash only drops when you actually pay.
What does "steady withdrawal" mean?
The largest amount you could take every month of the plan without available cash falling below your minimum.
Can I use it for next year?
Yes. Save a copy, set the new first month and carry over the closing figures from Reconciliation.
Does it work in Google Sheets?
It hasn't been tested there yet. It's built for Microsoft Excel.
You might also like

Service Business Cash Runway Planner
A rolling 13-week cash forecast for consultants, agencies and service businesses. Invoices, payroll, owner draws and bills, week by week, with late-payment and downside scenarios. Excel template with a worked example.

Self-Employed Bookkeeping Spreadsheet
Your T2125 and GST/HST return, organized as you go.

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.