Bank Supervision

Downloadable Forms

Excel Reporting System (ERS)

Published Friday November 5th, 2010
Amended Tuesday December 4th, 2012

The Central Bank of the Bahamas (the Bank) has updated its official release of its Excel Reporting System (ERS) from Version 2.0 to Version 2.5 for the Authorised Dealers and Authorised Agents and Version 2.4 replaces Version 2.0 for the International Licensees. The latest revisions to the ERS is in the context of the Bank’s market risk framework, which now includes a suite of nine additional reporting forms in the ERS.

All public licensees with the exception of branches and pure trust companies are expected to report on their ‘Trading Book’. Those that meet the deminimus threshold will be required to complete as appropriate the suite of Market Risk forms.

The Guidance Notes for the Completion of the ERS, which serve as a companion tool to assist licensees in completing the ERS, has now been supplemented with a subsidiary Guidance Notes for the Completion of the Market Risk Reporting Forms.

“Authorised Dealers” and “Authorised Agents” should note that the revised ERS comprises the following suite of monthly and quarterly reporting forms (see table below). However, for International Licensees, all reports in the table below are to be reported quarterly, only. To further improve the synergies provided by this initiative, we encourage institutions, to the extent possible, to create links between the report forms and individual accounting systems.

Monthly Forms Quarterly Forms
Form 1-Statement of Liabilities Form 3A-Dormant Account Report
Form 2-Statement of Assets Form 3B-Analysis of Resident B$ Deposits
Form 2A-Statement of Other Assets and Liabilities Form 5B-Credit Card Report
Form 3-Analysis of Deposits by Depositors Form 7-Profit and Loss
Form 4-Analysis of Loans and Overdrafts Form 8-Analysis of Payments System
Form 5-Analysis of Consumer Credit Fiduciary Assets
Form 10-Interfinancial Transactions Memo Items
Statement of Capital Adequacy Maturity-Wise Analysis
Statement of Assets by Zone Interest Rate Sensitivity
Statement of Investments Investments by Currency Type
Statement of Market Loans/Depositors Trading Securities
Statement of Large Exposures Trigger Form
Summary of Non-Performing Assets and Provisions Interest Rate Risk - General
Sectoral Exposures Interest Rate Risk - Specific
Large Loan Arrears Foreign Exchange Risk
Large Exposures 2 Equity Risk
Commodities Risk
Interest Rate Options
Equity Forex Commodities Options
Market Risk Capital Charge

All Licensees should refer to the guidance notes for the submission protocols and other reporting instructions. Regarding submission, the completed ERS forms are to be emailed to [email protected] for "Authorised Dealers" and "Authorised Agents". The completed forms for submission of the ERS for "International Licensees" should be emailed to [email protected] All Licensees are required to submit the ERS forms by the prescribed deadline i.e., 15 business days after the end of the reporting period.

Bank Supervision