Skip to content

Multiple jurisdictions · CRS and FATCA

Preparing database exports for CRS and FATCA reporting

How to turn existing system data into a consistent reporting workbook while preserving identifiers and account relationships.

← All reporting updates

Reporting period: Practical preparation guide — not year-specific

Published:

Last checked:

Reviewed by: Voodoo Ltd

Start with the reporting requirements

Financial institutions often hold the information needed for reporting across several systems. A useful export specification starts with the target jurisdiction, reporting period and agreed workbook, then maps each required value to its source. Identify gaps before building the extract rather than filling them with assumptions.

Preserve identifiers and relationships

Treat TINs and account numbers as text so leading zeros survive the export. Agree date formats and amount conventions, and keep currency codes separate from amounts. Avoid formulas or display formatting that conceal the actual stored value.

An account can involve multiple people or entities. Document how account holders, controlling persons and substantial owners relate to each account, and how the chosen template represents them. Do not flatten a repeating relationship in a way that loses a person or duplicates an account balance unintentionally.

Test the conversion with representative records

Begin with a small sample that includes individuals, entities, several related persons, leading zeros and missing information. Compare the export with the source records, then reconcile account counts and the financial totals relevant to your data model. Log exceptions for review before processing the full population.

Software development and reporting support

Voodoo can help develop exports from existing databases and map the output into the reporting process. We can review spreadsheet data, identify validation issues and prepare XML, with the submission responsibility agreed with you.

This is practical preparation advice, not an official file specification. The local authority’s current requirements and your agreed template remain the starting point for each filing.

Sources and further reading

General information, checked on the date shown. Confirm the guidance that applies to your institution and reporting period before filing.

Discuss your reporting requirements