Excel Reporting System (ERS)

Published: Friday November 5th, 2010
Amended: Sunday November 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 FormsQuarterly Forms
Form 1-Statement of LiabilitiesForm 3A-Dormant Account Report
Form 2-Statement of AssetsForm 3B-Analysis of Resident B$ Deposits
Form 2A-Statement of Other Assets and LiabilitiesForm 5B-Credit Card Report
Form 3-Analysis of Deposits by DepositorsForm 7-Profit and Loss
Form 4-Analysis of Loans and OverdraftsForm 8-Analysis of Payments System
Form 5-Analysis of Consumer CreditFiduciary Assets
Form 10-Interfinancial TransactionsMemo Items
Statement of Capital AdequacyMaturity-Wise Analysis
Statement of Assets by ZoneInterest Rate Sensitivity
Statement of InvestmentsInvestments by Currency Type
Statement of Market Loans/DepositorsTrading Securities
Statement of Large ExposuresTrigger Form
Summary of Non-Performing Assets and ProvisionsInterest Rate Risk - General
Sectoral ExposuresInterest Rate Risk - Specific
Large Loan ArrearsForeign Exchange Risk
Large Exposures 2Equity 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 RegReports@centralbankbahamas.com for "Authorised Dealers" and "Authorised Agents". The completed forms for submission of the ERS for "International Licensees" should be emailed to bsdqreturn@centralbankbahamas.com. 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.

This site uses cookies: Find out more

Okay, Thanks