Skip to main content
Data Dare consolidation L3 sticker: the findi360 mascot analysing Multi-Currency Consolidation: Translation, Loans & Unrealised Profit.

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 files

Files are for members. A free account takes a minute, and you come straight back here.

  • Question Book PDF DD-CON-003_Question_Book.pdf 1.2 MB · v1.0
  • Dataset Documentation / Data Dictionary XLSX DD-CON-003_Data_Dictionary.xlsx 13.8 KB · v1.0
  • Business Introduction PDF DD-CON-003_Business_Introduction.pdf 617.1 KB · v1.0
  • Relationship Diagram PDF DD-CON-003_Relationship_Model.pdf 615 KB · v1.0
  • Raw fact data DD-CON-003_FactTrialBalance.parquet 12.4 MB · v1.0
  • Dimension / supporting data DD-CON-003_Dimensions.zip 1017.7 KB · v1.0

Questions

Open one to discuss it
  1. Q013 Medium Trading KSA revenue in USD, 2025
  2. Q014 Medium Group revenue after eliminations, 2025
  3. Q015 Medium Unrealised profit in group stock at 31 December 2025
  4. Q016 Medium Unrealised profit charged to group cost of sales, 2025
  5. Q017 Medium Group gross profit, 2025
  6. Q018 Medium Group EBITDA, 2024
  7. Q019 Medium Group profit for 2025
  8. Q020 Medium Minority share of profit, 2025
  9. Q021 Medium Trading KSA exchange differences, 2025
  10. Q022 Medium Dividends received from subsidiaries, 2025
  11. Q023 Medium Goods in transit at 31 December 2025
  12. Q024 Medium Group revenue growth, 2025 vs 2024
  13. Q025 Medium Trading KSA best quarter in USD, 2025
  14. Q026 Medium Mizan Retail strongest month, 2024
  15. Q027 Medium Trading KSA revenue in USD, first quarter 2025
  16. Q028 Medium Group revenue against budget, 2025
  17. Q029 Medium Intercompany suspense at 31 December 2024
  18. 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