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- Q001 Easy Trading KSA branches open at the end of 2024
- Q002 Easy Trading KSA revenue in SAR, 2025
- Q003 Easy SAR closing rate at 31 December 2024
- Q004 Easy Mizan Retail revenue, 2023
- Q005 Easy Manufacturing sales to group companies, 2025
- Q006 Easy Intercompany loan outstanding at 31 December 2025
- Q007 Easy Interest on the intercompany loan, 2024
- Q008 Easy Retail stock bought from Manufacturing at 31 December 2025
- Q009 Easy Trading KSA purchases from Manufacturing in SAR, 2025
- Q010 Easy Mizan Logistics revenue, 2024
- Q011 Easy Goods invoices issued by Manufacturing, 2025
- Q012 Easy Mizan Retail revenue budget, 2025
- 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
- Q031 Hard Translation reserve at 31 December 2025
- Q032 Hard Non-controlling interests at 31 December 2025
- Q033 Hard Trading KSA net assets in USD at 31 December 2025
- Q034 Hard Exchange-rate effect on Trading KSA revenue, 2025
- Q035 Hard Weakest month for group gross margin, 2025
- Q036 Hard Largest monthly rise in unrealised profit, 2025
- Q037 Hard Months the group beat its revenue budget, 2025
- Q038 Hard Group EBITDA growth, 2025 vs 2024
- Q039 Hard Rolling 12-month owners' profit to September 2025
- Q040 Hard Intercompany differences in group profit, 2025
- Q041 Hard Group retained earnings at 31 December 2024
- Q042 Hard Dividend to Trading KSA's minority shareholders, 2025
- 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