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. Q001 Easy Trading KSA branches open at the end of 2024
  2. Q002 Easy Trading KSA revenue in SAR, 2025
  3. Q003 Easy SAR closing rate at 31 December 2024
  4. Q004 Easy Mizan Retail revenue, 2023
  5. Q005 Easy Manufacturing sales to group companies, 2025
  6. Q006 Easy Intercompany loan outstanding at 31 December 2025
  7. Q007 Easy Interest on the intercompany loan, 2024
  8. Q008 Easy Retail stock bought from Manufacturing at 31 December 2025
  9. Q009 Easy Trading KSA purchases from Manufacturing in SAR, 2025
  10. Q010 Easy Mizan Logistics revenue, 2024
  11. Q011 Easy Goods invoices issued by Manufacturing, 2025
  12. Q012 Easy Mizan Retail revenue budget, 2025
  13. Q013 Medium Trading KSA revenue in USD, 2025
  14. Q014 Medium Group revenue after eliminations, 2025
  15. Q015 Medium Unrealised profit in group stock at 31 December 2025
  16. Q016 Medium Unrealised profit charged to group cost of sales, 2025
  17. Q017 Medium Group gross profit, 2025
  18. Q018 Medium Group EBITDA, 2024
  19. Q019 Medium Group profit for 2025
  20. Q020 Medium Minority share of profit, 2025
  21. Q021 Medium Trading KSA exchange differences, 2025
  22. Q022 Medium Dividends received from subsidiaries, 2025
  23. Q023 Medium Goods in transit at 31 December 2025
  24. Q024 Medium Group revenue growth, 2025 vs 2024
  25. Q025 Medium Trading KSA best quarter in USD, 2025
  26. Q026 Medium Mizan Retail strongest month, 2024
  27. Q027 Medium Trading KSA revenue in USD, first quarter 2025
  28. Q028 Medium Group revenue against budget, 2025
  29. Q029 Medium Intercompany suspense at 31 December 2024
  30. Q030 Medium Group net debt at 31 December 2025
  31. Q031 Hard Translation reserve at 31 December 2025
  32. Q032 Hard Non-controlling interests at 31 December 2025
  33. Q033 Hard Trading KSA net assets in USD at 31 December 2025
  34. Q034 Hard Exchange-rate effect on Trading KSA revenue, 2025
  35. Q035 Hard Weakest month for group gross margin, 2025
  36. Q036 Hard Largest monthly rise in unrealised profit, 2025
  37. Q037 Hard Months the group beat its revenue budget, 2025
  38. Q038 Hard Group EBITDA growth, 2025 vs 2024
  39. Q039 Hard Rolling 12-month owners' profit to September 2025
  40. Q040 Hard Intercompany differences in group profit, 2025
  41. Q041 Hard Group retained earnings at 31 December 2024
  42. Q042 Hard Dividend to Trading KSA's minority shareholders, 2025
  43. Q043 Very Hard Group retained earnings at 31 December 2025
  44. Q044 Very Hard Total group equity at 31 December 2025
  45. Q045 Very Hard Consolidated inventories at 31 December 2025
  46. Q046 Very Hard Movement in the translation reserve, 2025
  47. Q047 Very Hard Largest month-end intercompany suspense, 2025
  48. Q048 Very Hard Group effective tax rate, 2025
  49. Q049 Very Hard Intercompany suspense not explained by goods in transit
  50. 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