Provides data related to a distributor’s balance sheet and income statement as well as trial balance data for all of the accounts (and sub-accounts as applicable) set out in the Accounting Procedures Handbook. Note that the start year for this data file is 2015.
Table 1: The first table provides a balance sheet view derived from the trial balance data.
https://www.oeb.ca/documents/opendata/rrr/2.1.7 Balance Sheet.xml
Table 2: The second table contains an income statement view derived from the trial balance data.
https://www.oeb.ca/documents/opendata/rrr/2.1.7 Income Statement.xml
Table 3: The third table provides trial balance data for all of the accounts (and sub-accounts as applicable) set out in the Accounting Procedures Handbook.
Note: Some files are large and are best viewed in a data application. Right-click and download the files to your computer. Then open them in the data application of your choice (Excel or other BI tool).
https://www.oeb.ca/documents/opendata/rrr/2.1.7 All Accounts Analysis (all years).xlsx (9 MB)
https://www.oeb.ca/documents/opendata/rrr/2.1.7 All Accounts Analysis 2015.xml (10 MB)
https://www.oeb.ca/documents/opendata/rrr/2.1.7 All Accounts Analysis 2016.xml (10 MB)
https://www.oeb.ca/documents/opendata/rrr/2.1.7 All Accounts Analysis 2017.xml (10 MB)
https://www.oeb.ca/documents/opendata/rrr/2.1.7 All Accounts Analysis 2018.xml (10 MB)
https://www.oeb.ca/documents/opendata/rrr/2.1.7 All Accounts Analysis 2019.xml (10 MB)
https://www.oeb.ca/documents/opendata/rrr/2.1.7 All Accounts Analysis 2020.xml (10 MB)
https://www.oeb.ca/documents/opendata/rrr/2.1.7 All Accounts Analysis 2021.xml (10 MB)
https://www.oeb.ca/documents/opendata/rrr/2.1.7 All Accounts Analysis 2022.xml (10 MB)
Archive:
Data published September 29, 2022
Table 1: The first table provides a balance sheet view derived from the trial balance data.
https://www.oeb.ca/documents/opendata/rrr/2015-2021-2.1.7 Balance Sheet.xml
Table 2: The second table contains an income statement view derived from the trial balance data.
https://www.oeb.ca/documents/opendata/rrr/2015-2021-2.1.7 Income Statement Analysis.xml
Table 3: The third table provides trial balance data for all of the accounts (and sub-accounts as applicable) set out in the Accounting Procedures Handbook.
Note: Some files are large and are best viewed in a data application. Right-click and download the files to your computer. Then open them in the data application of your choice (Excel or other BI tool).
https://www.oeb.ca/documents/opendata/rrr/2015-2021-2.1.7 All Accounts Analysis (all years).xlsx (7 MB)
https://www.oeb.ca/documents/opendata/rrr/2015-2021-2.1.7 All Accounts Analysis 2015.xml (11 MB)
https://www.oeb.ca/documents/opendata/rrr/2015-2021-2.1.7 All Accounts Analysis 2016.xml (11 MB)
https://www.oeb.ca/documents/opendata/rrr/2015-2021-2.1.7 All Accounts Analysis 2017.xml (11 MB)
https://www.oeb.ca/documents/opendata/rrr/2015-2021-2.1.7 All Accounts Analysis 2018.xml (11 MB)
https://www.oeb.ca/documents/opendata/rrr/2015-2021-2.1.7 All Accounts Analysis 2019.xml (8 MB)
https://www.oeb.ca/documents/opendata/rrr/2015-2021-2.1.7 All Accounts Analysis 2020.xml (11 MB)
https://www.oeb.ca/documents/opendata/rrr/2015-2021-2.1.7 All Accounts Analysis 2021.xml (12 MB)