Electricity Reporting & Record Keeping Requirements (RRR): Section 2.1.7 Trial Balance

Description

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.

URL

Table 1: The first table provides a balance sheet view derived from the trial balance data. 
https://www.oeb.ca/documents/opendata/rrr/2023/2.1.7 Table 1 Balance Sheet Analysis.xml

Table 2: The second table contains an income statement view derived from the trial balance data. 
https://www.oeb.ca/documents/opendata/rrr/2023/2.1.7 Table 2 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/2023/2.1.7 Table 3 All Accounts Analysis (all year).xlsx (7 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)
https://www.oeb.ca/documents/opendata/rrr/2023/2.1.7 Table 3 All Accounts 2023.xml (10 MB)

Archive:

Data published November 1, 2023

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)

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)

File Types
XML
XLSX
Update Frequency
Annually
Last updated: August 27, 2024
Access Level
Open/Public