Open Government and OSFI Financial Data
On this page
- Rationale for the transition to Open Government
- Temporary measures to ease transition to Open Government
- Legacy FINDAT
- Financial data for banks
- Financial data for foreign bank branches
- Financial data for trust companies
- Financial data for loan companies
- Financial data for retail associations
- Financial data for life insurance companies
- Financial data for fraternal benefit societies
- Financial data for property and casualty companies
- Sample MS Excel spreadsheets for OSFI's most frequently used datasets
- Legacy FINDAT
- Information available on Open Government
- Working with the data
Rationale for the transition to Open Government
While this represents a change from how some users previously accessed the data, the Open Government approach provides powerful benefits, including better access to full datasets, improved data quality, and greater flexibility for analysis. The legacy FINDAT platform relied on outdated technology, which limited OSFI's ability to make timely corrections and made customized analysis difficult. Open Government resolves these challenges.
Access. Transparency. Flexibility.
We are committed to transparency and accessibility through Canada's Open Government initiative. Open Government allows Canadians, researchers, analysts, and regulated entities to access government‑approved data in open, machine‑readable formats, instead of viewing information one report at a time. You can now download complete datasets and analyze them using tools such as Excel or Power BI.
We've made this shift to help you work with the data more efficiently and confidently. Key benefits include:
- Greater transparency through standardized, publicly approved datasets
- Flexibility, allowing users to filter, combine, and consolidate data based on their needs
- Collaboration made simple: share a live, filtered view so everyone sees the same data instantly.
Temporary measures to ease transition to Open Government
Legacy FINDAT platform will be taken down August 3rd, 2026 (subject to change)
Financial data for banks
Financial data for foreign bank branches
Financial data for trust companies
Financial data for loan companies
Financial data for retail associations
Financial data for life insurance companies
Financial data for fraternal benefit societies
Financial data for property and casualty companies
Sample MS Excel spreadsheets for OSFI's most frequently used datasets
OSFI's data can be accessed in several ways via Open Government. To help users work with this data more easily, these spreadsheets show how Open Government data can be extracted on demand using Application Programming Interfaces (APIs) and presented in a simple, structured format.
Disclaimer: These Excel spreadsheets are provided as samples only and, therefore, have certain limitations. They are designed to use the latest Open Government Data Point Addresses (DPAs), which may result in gaps in the presentation of historical data captured under previous DPAs. These samples will be updated periodically as needed to reflect new OSFI regulatory requirementsPlease check back often for the latest version.
- Consolidated Balance Sheet (XLSM, 669.95 KB, last updated Thursday, June 4, 2026)
- See M4 - Consolidated Balance Sheet (Active) for validation
- BCAR Derivative Components (XLSM, 409.13 KB, last updated Thursday, June 4, 2026)
- See BA – BASEL III Capital Adequacy Reporting - BCAR (Active) for validation
- Capital Adequacy - Components of Capital (XLSM, 414.56 KB, last updated Thursday, June 4, 2026)
- See BA – BASEL III Capital Adequacy Reporting - BCAR (Active) for validation
- Consolidated Statement of Comprehensive Income (XLSM, 395.33 KB, last updated Thursday, June 4, 2026)
- See P3 - Consolidated Statement Of Income, Retained Earnings & AOCI (Active) for validation
Information available on Open Government
We publish two main types of information:
Who We Regulate (WWR)
WWR is a public listing of federally regulated financial institutions. It serves as a reference and contact directory, not a financial reporting tool. We update this information on the first of each month.
Financial Data (FINDAT)
FINDAT on Open Government contains regulatory returns filed by institutions, representing financial data approved by Parliament for public disclosure. We publish monthly data on the 15th of each month, and quarterly data in late May, August, November, and March.
Working with the data
Whether you are a first‑time user or an experienced analyst, these tools and resources are designed to help you get the information you need—quickly and confidently.
Each dataset includes:
- A data dictionary explaining each column and row
- A user manual explaining the structure and key data elements
- A guide explaining how to access via Application Programming Interface (API)
If you are new to data analytics, free tutorials for Excel or Power BI are widely available online
Step 1: User manual
Download a user manual to help guide you (requires MS Word):
- Banks - User manual
- Foreign bank branches - User manual
- Trust companies - User manual
- Loan companies - User manual
- Retail associations - User manual
- Life insurance companies - User manual
- Fraternal benefit societies - User manual
- Property and casualty companies - User manual
Step 2: Open the dataset you need
Jump to one of our most popular sets:
- Banks - M4 - Consolidated Balance Sheet (Active)
- Banks - P3 - Consolidated Statement Of Income, Retained Earnings & AOCI (Active)
- Banks - BA – BASEL III Capital Adequacy Reporting - BCAR (Active)
- Life insurance companies - LCA - LICAT (Active)
- Life insurance companies - LF1 - Life Core Financial Statement Return (Active)
- Property and casualty companies - PC1 - P&C Core Financial Statement Return (Active)
- Foreign bank branches - P3 - Consolidated Statement Of Income, Retained Earnings & AOCI (Active)
Step 3: Viewing the data you need
Click Add Filter button to focus on a specific institution (total), overall totals (measure value), or reporting period.
Also, hide the columns you don't need
Step 4: Save and share your results for future reference
Download filtered results to see only the portion of the dataset that you need
Share the current view with others
If you still have questions, please contact us.