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- Q013 Medium Trading KSA revenue in USD, 2025
- Q014 Medium Group revenue after eliminations, 2025
- Q015 Medium Unrealised profit in group stock at 31 December 2025
- Q016 Medium Unrealised profit charged to group cost of sales, 2025
- Q017 Medium Group gross profit, 2025
- Q018 Medium Group EBITDA, 2024
- Q019 Medium Group profit for 2025
- Q020 Medium Minority share of profit, 2025
- Q021 Medium Trading KSA exchange differences, 2025
- Q022 Medium Dividends received from subsidiaries, 2025
- Q023 Medium Goods in transit at 31 December 2025
- Q024 Medium Group revenue growth, 2025 vs 2024
- Q025 Medium Trading KSA best quarter in USD, 2025
- Q026 Medium Mizan Retail strongest month, 2024
- Q027 Medium Trading KSA revenue in USD, first quarter 2025
- Q028 Medium Group revenue against budget, 2025
- Q029 Medium Intercompany suspense at 31 December 2024
- Q030 Medium Group net debt at 31 December 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