Budget & Forecast Planner Pro
Build an operating budget for a non-profit housing provider, seniors lodge, or community organization, with one site or many, in one or more provinces or territories. Each site runs on its own province's rules: rent increase guidelines, cost inflation, employer payroll taxes, non-recoverable sales tax after the public service bodies' rebate, and taxes on insurance premiums. See the budget against last year, the year-end forecast from your actuals, monthly cash flow, a multi-year forecast, replacement reserves, and a province-by-province view of where the money is made and lost. Your numbers stay in your browser.
Welcome. Tell us who you are to get started.
The Pro planner is free until November 30, 2026. We ask for a few details the first time you use it on this device, so we know who the tool is helping.
1. Organization & consolidated settings
The example is Cedarline Community Housing Society, a fictitious 1,340-unit non-profit with a sample site in every province and territory. Its figures are illustrative. Replace any number with your own.
Targets the board watches
Fiscal year and actuals to date
Building next year's budget? Leave months of actuals at 0. Reporting partway through the year? Enter the number of months closed, then fill in the Actual to date column for each line in section 3. The planner forecasts the year-end result and compares it with the budget.
2. Provincial assumptions
Choose one or more provinces or territories in the menu at the top, or select Edit beside one, to see and change its assumptions. Rent guidelines are the published caps for the 2027 calendar year where announced (2026 otherwise). Leave the guideline blank where there is no cap, and rent lines grow with provincial CPI. Payroll tax bands and sales tax rebates are simplified and change often: confirm them for your organization and fiscal year. Inflation and growth rates are planning assumptions, not forecasts.
3. Sites
Add each building, portfolio, or regional operation as a site and choose its province. A single-site organization needs only one. Enter last year's actual and this year's budget for each line before sales tax: the planner adds the non-recoverable tax for you. Enter salaries as gross wages: employer statutory costs and provincial payroll tax are added on top. Each line grows by a provincial driver or a custom rate. Timing spreads the budget across the months of the fiscal year for the cash flow.
4. Capital projects
Projects are paid from the site's replacement reserve in the year shown.
5. Consolidated results
There are no sites in this province yet. Add one in section 3 to see results here.
What the numbers are saying
6. Financial health checks
On track meets the target, Watch is close to a limit, and Action needs a plan. Lender and funding agreements set the limits that actually apply, often site by site.
Budget year
Over the forecast
Statement of operations
This year's budget against last year's actual results, with the provincial cost layer and mortgage interest calculated on both.
Where the money comes from
Where the money goes
Year-end forecast vs. budget
Monthly cash flow
Budgeted operating cash through the year, after the provincial cost layer, mortgage payments, and reserve contributions. Changes in receivables, payables, and other working capital are not modelled.
7. Province by province
Cost per unit per month
The provincial cost layer
Costs that exist only because of where a site is: employer statutory costs (CPP or QPP, EI, workers' compensation), provincial payroll tax, sales tax the organization cannot recover, and provincial tax on insurance premiums. These are budget-year figures.
Sites
Consolidated multi-year forecast
Surplus by province over the forecast
Replacement reserves
Sensitivity
Final-year consolidated result if revenue or expenses grow faster or slower than planned, in percentage points a year across every line. Green meets the margin target, amber is a surplus below target, red is a deficit.
If inflation runs one point higher in one province
Change in the final-year consolidated result if CPI-driven lines in a single province grow one point faster than assumed, everything else unchanged.

