Skip to content
LauréoBetaPublic procurement intelligence
Settings
My account

Planned vs actual

What each department said it would spend, program by program, and what it spent.

Key figures

91organisations with a planof which 89 with public accounts 2022-23
1,197comparable programsof 1,226 published programs · 29 without a positive plan or without actuals
+6.4%median gap, actual / plannedquartiles −7.5% and +27.2%how it's calculated

Median actual / planned gap — where the number comes from

The calculation
For each program: actual spending ÷ planned spending − 1. The median of these gaps: +6.4%.
What goes in
1,197 comparable programs, out of 1,226 programs published for fiscal year 2022-23: those whose planned spending is positive and whose actual spending is published. The others stay out.
Source
Departmental plans and Public Accounts · Open Government Licence – Canada (OGL-Canada-2.0) · data up to fiscal year 2024-25 · link to this detail
844published explanationsby departments, on the gap

By organisation

By organisation
Organisation ENProgramsMedian gapAbove / below
Department of Employment and Social Development66 63 comparable+1.3% −23.1 to +18.232 / 31
Department of National Defence64+4.9% −6.0 to +20.839 / 25
Department of Foreign Affairs, Trade and Development53+8.0% −10.0 to +33.231 / 22
Department of Indigenous Services43+22.7% −0.5 to +58.731 / 12
Department of Fisheries and Oceans42+1.9% −13.2 to +34.323 / 19
Department of Health42+12.5% −3.4 to +57.927 / 14
Department of Transport41+17.5% −7.8 to +48.128 / 13
Department of Natural Resources40+10.5% −9.2 to +28.322 / 18
Department of Agriculture and Agri-Food36 33 comparable+6.2% −20.0 to +25.221 / 12
National Research Council of Canada34 33 comparable+3.7% −4.7 to +17.921 / 12
how it's calculated — By organisation

By organisation — where the number comes from

What goes in
In dollars and in staff: the source publishes by program, and Lauréo compares each program with its own plan. Sorted by number of programs. The median gap is that of the organisation's programs, with its quartiles; no amount is added up. A positive gap is spending above plan. “None”: the department published no explanation for any of its programs that year. What this department bought against what it spent: plans and public accounts identify the organisation by a number, contracts by a code, and the two share no identifier. The question remains open.
Breakdown
By organisation
OrganisationExplanationsFTEs, median gap
Department of Employment and Social Development66+8.8%
Department of National Defencenone+7.4%
Department of Foreign Affairs, Trade and Developmentnone−2.2%
Department of Indigenous Services43+5.0%
Department of Fisheries and Oceans42+10.4%
Department of Health36+5.7%
Department of Transport28+5.9%
Department of Natural Resources40−0.5%
Department of Agriculture and Agri-Food27−3.0%
National Research Council of Canada19−2.8%
Source
Departmental plans and Public Accounts · Open Government Licence – Canada (OGL-Canada-2.0) · data up to fiscal year 2024-25 · link to this detail

Departmental Plans and Public Accounts, Government of Canada Open Data · aggregates of October 11, 2026