DD-CON-003
Multi-Currency Consolidation: Translation, Loans & Unrealised Profit
Four companies, two currencies, 36 monthly trial balances each (~540,000 rows), invoice-level intercompany transactions, the month-end stock bought from Manufacturing, a loan schedule and an exchange-rate table. No date table. Fifty questions from translation to the retained-earnings roll-forward.
- Consolidation
- L3 · PARQUET
- ~542,872 rows
- 12 tables
- 50 questions
Free account: download the data, check your answers and earn a certificate. Create it →
More Consolidation:
L2 ·
L4
Next in the story: Data Transformation →
Get the data
v1.0 · 6 filesFiles are for members. A free account takes a minute, and you come straight back here.
- Question Book PDF DD-CON-003_Question_Book.pdf
- Dataset Documentation / Data Dictionary XLSX DD-CON-003_Data_Dictionary.xlsx
- Business Introduction PDF DD-CON-003_Business_Introduction.pdf
- Relationship Diagram PDF DD-CON-003_Relationship_Model.pdf
- Raw fact data DD-CON-003_FactTrialBalance.parquet
- Dimension / supporting data DD-CON-003_Dimensions.zip
Questions
Open one to discuss it- Q043 Very Hard Group retained earnings at 31 December 2025
- Q044 Very Hard Total group equity at 31 December 2025
- Q045 Very Hard Consolidated inventories at 31 December 2025
- Q046 Very Hard Movement in the translation reserve, 2025
- Q047 Very Hard Largest month-end intercompany suspense, 2025
- Q048 Very Hard Group effective tax rate, 2025
- Q049 Very Hard Intercompany suspense not explained by goods in transit
- Q050 Very Hard Best three months for group EBITDA margin, 2025
General discussion
Anything about this dataset that is not one question — loading the files, which tool, how you set it up.
A free account takes a minute. Your draft is kept while you sign in. Need help? Message us