Methodology

Data Sources & Ingestion

Our data pipeline aggregates information from multiple primary government sources for British Columbia and Alberta. Several distinct datasets are ingested and merged per municipality:

• Financial Statements (BC): BC Ministry of Municipal Affairs Schedule 700-series annual filings (Schedules 700, 702, 704, 706, 707). The current year is the 2024/2025 reporting period. Five supplement municipalities absent from the current release use their most recent available year (2021–2023), with a data notice shown on their pages.
• Financial Statements (AB): Alberta Municipal Affairs annual financial year data (Financial Year files 2021–2024). Current year = 2024.
• Property Assessment (BC): BC Assessment roll data — residential vs. non-residential assessed value split used to compute the residential tax base percentage. Representative house values and mill rates come from Schedule 704.
• Property Assessment (AB): Alberta 2024 assessment data — residential mill rates from the MR(1)-Tax Levy sheet. Total residential assessment and dwelling unit counts are used as the baseline for estimated median dwelling value calculations.
• Tax Levy Data (BC): Schedule 707 — municipal tax levy by property class (residential, commercial, industrial, utilities, farm/natural resources). Used for the Tax Revenue by Property Class chart. Years available: 2021, 2023, 2024, 2025.
• Tax Levy Data (AB): MR(1)-Tax Levy sheet — annual municipal levy by class (residential, commercial & industrial, machinery & equipment, farm). Years available: 2023–2025.
• Homeowner Tax Profiles: Per-municipality estimated annual tax bill calibrated using 2021 Census median dwelling values. See the dedicated Estimated Median Dwelling Value section below for full methodology.
• Building Permit Data: CMHC/StatCan permit data — total permit value and residential units permitted per 1,000 residents (trailing 12 months). Approximately 71 municipalities have suppressed values due to StatCan confidentiality rules.
• Population Estimates: BC Stats and Alberta provincial annual estimates series (2015–2025), used for per-capita normalization and longitudinal population trend calculations.
• 2021 Census (StatCan): Characteristic ID 1488 (median dwelling value by census subdivision) used as the calibration baseline for estimated median dwelling values.

Data Imputation & Gap Filling

When a municipality is absent from the current-year benchmarking release (often due to late or non-submission of data), the pipeline automatically derives fiscal proxies by extracting data directly from raw government files for their most recent available year. This ensures complete coverage across all incorporated municipalities, with clear notices displayed when historical data is used.

Per-Capita Normalization

All financial metrics are divided by the municipality's population to produce per-person values. This allows meaningful comparison between Vancouver (725,000+) and Alert Bay (~500). Without normalization, absolute dollar figures are meaningless for comparison. Population figures are synchronized to the fiscal year using provincial annual estimates; per-capita component fields are scaled proportionally when population updates occur.

Population Bands

Municipalities are grouped into 6 population bands for peer comparison. Comparing a village of 300 to a city of 300,000 is not meaningful, so rankings and averages are computed within bands. The dashboard currently covers BC (161 municipalities, 156 benchmarkable) and Alberta (322 municipalities, 314 benchmarkable):

Rankings and averages are computed within each province separately — a BC municipality's percentile reflects its standing among BC peers in the same band, and an AB municipality among AB peers. Provincial fiscal structures (mill-rate systems, grant programs, capital rules) differ enough that cross-province ranking would be misleading.

Rankings & Percentiles

Each municipality is ranked within its population band and province for every metric. Rankings account for polarity — for metrics where lower is better (e.g., debt load, tax burden), rank 1 goes to the lowest value.

Percentiles are calculated as: 1 – (rank – 1) / (bandSize – 1), yielding a 0–1 scale where 1.0 = top of band.

Traffic Light Indicators

The five report card metrics use a three-color system based on percentile position within the municipality's population band:

Note: These indicators describe relative ranking within a population band, not absolute fiscal health. A municipality at the "bottom of band" for debt may have made a strategic capital investment that is sound long-term. The color signals relative position; context and insight text provide the "why."

The Five Report Card Metrics

See also: Community Context Cards for the four additional Tier 2 indicators shown below the Report Card.

Fiscal Balance (Surplus per Person)

Operating surplus divided by population. Higher = better. Positive means the municipality took in more than it spent.

Tax Burden (Own-Source Taxation per Person)

Property tax and other own-source taxes per person. Lower = better (lower burden on residents).

Debt Load (Liability Capacity Used %)

Percentage of provincial borrowing limit used. Lower = better (more room for future infrastructure investment).

Revenue Resilience (Grant Dependency %)

Provincial and federal transfers as a share of total revenue. Lower = better (more self-sufficient).

Service Efficiency (Total Expenses per Person)

Total operating expenses divided by population. Lower = better (delivering services at lower cost).

Estimated Median Dwelling Value & Homeowner Tax Cost

Municipal tax rolls report an average (or representative) assessed value — not the median. In markets with a wide spread of property values, the average is pulled upward by high-end properties, overstating what a typical homeowner pays. The Annual Homeowner Cost card corrects for this by estimating the tax bill on a median-value dwelling.

All dwelling types, not single-family only

Our baseline is the 2021 Census median dwelling value (StatCan Characteristic ID 1488), which covers all owner-occupied dwelling types — condos, townhouses, row houses, and detached homes. This gives a more representative picture of what a typical homeowner pays than a single-family-only benchmark.

Scaling forward from 2021

The 2021 census baseline is scaled forward to current conditions using the change in assessed residential value, which tracks market price appreciation while controlling for new construction. The result is then bounded: capped at the current single-family benchmark value to prevent over-estimation in small communities where census samples are thin, and floored to prevent extreme under-estimation from data anomalies. Where 2021 Census data is unavailable, the current benchmark value is used directly as a proxy.

Tax bill

The estimated tax bill applies each municipality's effective residential tax rate to the estimated median dwelling value. Fixed charges such as parcel taxes and utility fees are added on top where reported separately.

These are estimates. The 2021 census baseline is held constant until the next census release; values for municipalities with few dwelling units or unusual property mixes should be interpreted with caution.

Community Context Cards

Below the Fiscal Report Card, four additional Community Context cards provide socioeconomic and development context. These use the same traffic light (percentile-based) system as the Report Card metrics, except where noted.

Note: Population Growth uses a directional color hint rather than pure percentile ranking — a municipality with positive 5-year growth trends green regardless of where it falls in the distribution, and negative growth trends red. All other cards use the standard percentile thresholds (≥ 0.6 green, 0.3–0.6 yellow, < 0.3 red).

Limitations

• Fiscal trends (2021–2024) and population trends are available for most municipalities. A small number of municipalities with missing historical filings show partial trend data.
• Per-capita normalization does not capture differences in service scope (e.g., some municipalities provide policing, others don't).
• Population estimates may differ slightly from census counts.
• Infrastructure metrics depend on self-reported asset management data, which varies in completeness.
• These benchmarks are descriptive, not prescriptive. Context matters — a municipality spending more may be investing in needed infrastructure.
• Estimated median dwelling values are calibrated from 2021 Census data and scaled forward using assessed-value growth. In rapidly appreciating markets, the growth factor may overstate appreciation if new construction shifts the mix; the 2021 baseline is held constant until the next census release.
• Building permit data is suppressed by StatCan for approximately 71 municipalities (typically smaller communities). These municipalities show a "not available" notice on the Development Activity card.
• Alberta residential tax base percentage is derived from assessment roll data, which may differ from the levy-based composition shown in the Tax Revenue by Property Class chart.