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