MARGINCANVAS
Home → Tools → Seasonal Trade Cash Flow Forecaster
Seasonal Cash Flow Forecaster for Trades

The busy season pays for the quiet one, if you know how long the quiet one runs.

Twelve months of cash for a business with a season, so you know how deep the quiet months go before the busy ones arrive.

$39 USD · one-time
Buy on Etsy · $39Gumroad coming soon
Instant download · Excel & Google Sheets · works on Mac and Windows · on Etsy today, Gumroad soon
Seasonal Trade Cash Flow Forecaster dashboard
Who it's for

Made for the way you actually work.

  • Seasonal contractors whose winter runs on summer's money
  • Landscapers and exterior trades with a hard stop in the calendar
  • Owner-operators deciding when to stop taking jobs
  • Crews planning wages through the months nothing comes in
What's included

Everything in one file.

  • Dashboard: Lowest balance, runway and the cash curve. Read-only.
  • Start Here: Five steps from opening the file to a real number on screen.
  • Cash Flow: Where the forecast is built. The main working sheet.
  • Settings: Forecast horizon and display.
  • Instructions: What each sheet does, and what to do if a number looks off.
  • About: Version, license and support.
  • PDF Quick-Start Guide: two pages, first result in five minutes
How it works

Three steps to a number you trust.

  1. Open Cash Flow. Enter the cash you can actually draw on today, not invoiced, not committed, available.
  2. Set your alert threshold: the balance below which you cannot operate.
  3. Under Money in, enter each source with the amount and the months it runs for. A one-off uses the same number twice.
A look inside

The screens you'll be working in.

List of the seven sheets in the seasonal cash flow forecasterCash Flow sheet with money in, money out and the balance by monthStart Here sheet with five steps to a readable forecastSettings sheet covering twelve months of one businessThree steps: money in, money out, read the low pointCompatibility: works in Google Sheets and Microsoft Excel 365
Questions

Good to know.

Is this different from the 13-Week Cash Flow Forecast?
Same engine, longer horizon. Thirteen weeks cannot see a season; twelve months can.
How do I model a season that spans the year end?
Enter it as two rows, one at the start of the year and one at the end. The engine sums whatever is active in each month.
Does this work in Excel and Google Sheets?
Both. Google Sheets: File > Import, or open and make a copy. Excel 365: open it directly. No macros, no add-ons, nothing to install.
How do I enter something that happens once?
Put the same month number in the From and To columns.
I'm not confident with spreadsheets. Will I manage?
Yes. The white cells are the only ones you touch. The Quick-Start Guide has your first real number on screen in about five minutes, and if you get stuck, message me.

One mispriced job costs more than this.

$39 once, and it's yours to keep. It pays for itself the first time it stops you underpricing a job or leaving margin on the table. No subscription, no login, just a file that does the maths.

Buy on Etsy · $39Gumroad coming soon
Related tools

Owners like you also use.

Farm Cash Flow Forecaster dashboard
Cash Flow ForecastingAny Small Business

Farm Cash Flow Forecaster

Twelve months of farm cash with income concentrated at harvest, so the gap before it is a number rather than an overdraft notice.

$39View →
13-Week Cash Flow Forecast dashboard
Cash Flow ForecastingAny Small Business

13-Week Cash Flow Forecast

Thirteen weeks of cash in and cash out, with the week you run short identified before it happens.

$39View →