Data preparation test
- In order to submit data on the reporting portal, FI’s must enter data into a file in Excel or Comma Separated Value (CSV) File.
- Templates for these files are available here along with supporting instructions.
| Document Name | Description | Update | |
 |
Bahamas FATCA Financial Institutions File Creation Instructions_07012015 | Instruction document providing general guidance for creating a file to submit on the TIE portal. | 07.01.2015 |
 |
GIIN_XXXXXXXXXXXXXXXXXXX_FATCATemplate_Excel | Excel template to assist in uploading data to the TIE portal. | 07.01.2015 |
 |
GIIN_XXXXXXXXXXXXXXXXXXX_FATCATemplate_CSV1 | Excel template in CSV format | 07.01.2015 |
|
Bahamas FI Reporting EXAMPLES | Displays an example to FI’s of what a typical report may look like | 07.01.2015 |
- The instructions explain the various data fields and required formats.
- Examples are also provided to assist different types of reporting entities.
- FIs should use these templates to start gathering and preparing their data for submissions.
Data Preparation – Important Points
- Use the data template to prepare your data for submission.
- Read and check adherence to validation rules.
- The system will also provide error messages regarding format to help detect validation issues.
- Accuracy of the data is the responsibility of the FI and the system will only check for format and required fields per listed validations.
- Dates must be formatted as “Text”.