For a better view on Central Bank of The Bahamas, Update Your Browser.

Excel Reporting System (ERS)

Published: Friday November 5th, 2010

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.