Supporting Documentation: Losses of public money or property as per the Public Accounts of Canada
Update to cases reported in previous years' Public Accounts of Canada
The data file contains both original losses, as reported in the public accounts (as found in Volume III, Tables 4, 4a, 4b and 4c of the Public Accounts of Canada), as well as updates to these existing losses (Volume III, Table 4d).
Original losses are indicated by having the column Yr-loss-rptd_Ex-fin-perte-rppt as blank, while updates to previously reported losses will display the original year the loss was reported in this column.
Note: Amounts not expected to be recovered (Loss-recvry-not-expctd_Perte-recvrmt-non-prevu) and amounts expected to be recovered in subsequent years (Loss-recvry-expctd_Perte-recvrmt-prevu) for losses of type "Cases before the Courts (Canada Revenue Agency's estimate of the amount of tax evaded or fraudulently obtained)", which can be found under column Incdnt-type_Type-incdnt_eng, cannot be estimated prior to a court conviction. Therefore these values are not presented.
New loss identifier column
As of the 2026 release, a new Loss-ID_ID-perte column was added to clearly link updates to previous years' losses to their original loss record. This ID begins with the last four digits of the fiscal year in which each loss was originally reported, followed by a dash, then an incrementing four-digit number.
To see all records newly reported in a given fiscal year, filter the Fscl-yr_Ex-fin column for that year, and filter the Yr-loss-rptd_Ex-fin-perte-rppt to show only blank values.
To see all updates to past year losses, as reported in a given ficsal year, filter the Fscl-yr_Ex-fin column for that year, and filter the Yr-loss-rptd_Ex-fin-perte-rppt to remove all blank values.
To see all original loss records of a given fiscal year, and all subsequent updates to those losses, filter the Loss-ID_ID-perte column to show all values that start with the final four digits of the given fiscal year followed by a dash. (Ex: to see all original loss records from 2013/2014 and any subsequent updates to those records that may have been published since, filter for "2014-" in the Loss-ID_ID-perte column.)
To see a specific original loss record and all subsequent updates to that loss, filter the Loss-ID_ID-perte column for the related ID value (which will be shared by all related records).
General Notes
As of the 2025 release, the following columns were renamed to improve readability and bilingualism:
- FSCL_YR was renamed to Fscl-yr_Ex-fin
- YR_LOSS_RPTD was renamed to Yr-loss-rptd_Ex-fin-perte-rppt
- LOSS_TYPE_EN was renamed to Loss-type_Type-perte_eng
- TYPE_DE_PERTE_FR was renamed to Loss-type_Type-perte_fra
- INCDNT_TYPE_EN was renamed to Incdt-type_Type-incdt_eng
- INCDNT_TYPE_FR was renamed to Incdt-type_Type-incdt_fra
- MINC was renamed to Min-code
- MINE was renamed to Min-portfolio_Portefeuille-min_eng
- MINF was renamed to Min-portfolio_Portefeuille-min_fra
- DepartmentNumber-Numéro-de-Ministère was renamed to Dept-nbr_No-min
- DEPT_EN_DESC was renamed to Dept-name_Nom-min_eng
- DEPT_FR_DESC was renamed to Dept-name_Nom-min_fra
- INCDNT_EN_DESC was renamed to Incdnt-desc_Desc-incdnt_eng
- INCDNT_FR_DESC was renamed to Incdnt-desc_Desc-incdnt_fra
- TOT_INCDNT_NO was renamed to Loss-nbr_No-pertes
- CHRGD_CY_VT_NO was renamed to Vote-nbr_No-credit
- TOT_LOSS_AMT was renamed to Loss-amt_Mnt-pertes
- TOT_CY_RCVRD_AMT was renamed to Loss-amt-recvrd_Mnt-pertes-recouvre
- NOT_XPTD_RCVRD_AMT was renamed to Loss-recvry-not-expctd_Perte-recvrmt-non-prevu
- C_XPTD_SY_RCVR_AMT was renamed to Loss-recvry-expctd_Perte-recvrmt-prevu
Related Links
- Previous years: Public Accounts of Canada
- Current year: Public Accounts of Canada
- Open Government Portal
- Date modified: