Skip to main content
Data Dare consolidation L4 sticker: the findi360 mascot analysing Diversified Group Close: Acquisition, Goodwill & Multi-ERP Consolidation.

DD-CON-004

Diversified Group Close: Acquisition, Goodwill & Multi-ERP Consolidation

The Level 4 consolidation case behind the Group Consolidation Accountant role. Seven companies, ~6.9M journal lines, three charts of accounts, no mapping table and no date table. Sixty questions.

  • Consolidation
  • L4 · PARQUET
  • ~6,884,744 rows
  • 18 tables
  • 60 questions
Get the data 60 questions
Free account: download the data, check your answers and earn a certificate. Create it → More Consolidation: L2 · L3 Next in the story: Data Transformation →

Profile Challenge · L4

Solve this and get a verified profile report

Build the model in Power BI (Python welcome), answer the questions, submit your file. findi360 reviews the work and publishes a report with a QR code — employers scan it and see what you can do, not only what you have done. The real potential lies at L4 and above — that is where employers look first.

Start my Profile Challenge See a sample report

Get the data

v1.0 · 8 files

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

Create a free account Sign in
  • Question Book PDF DD-CON-004_Question_Book.pdf 1.2 MB · v1.0
  • Dataset Documentation / Data Dictionary XLSX DD-CON-004_Data_Dictionary.xlsx 15.9 KB · v1.0
  • Business Introduction PDF DD-CON-004_Business_Introduction.pdf 616.2 KB · v1.0
  • Group Accounting Manual PDF DD-CON-004_Group_Accounting_Manual.pdf 627.1 KB · v1.0
  • Management Accounts Summary PDF DD-CON-004_Management_Accounts_Summary.pdf 616.8 KB · v1.0
  • Relationship Diagram PDF DD-CON-004_Relationship_Model.pdf 616.7 KB · v1.0
  • Raw fact data DD-CON-004_FactGLLines.parquet 81.5 MB · v1.0
  • Dimension / supporting data DD-CON-004_Supporting_Tables.zip 10 MB · v1.0

Questions

Open one to discuss it
  1. Q001 Easy Posted journal lines in Mizan Retail's ledger, December 2025
  2. Q002 Easy Parked SAP documents, 2025
  3. Q003 Easy Real Estate UAE rental income from outside tenants, 2025
  4. Q004 Easy Mizan Services Pakistan delivery staff costs, FY2025
  5. Q005 Easy Intercompany loans outstanding at 31 December 2025
  6. Q006 Easy Trading KSA revenue in SAR, 2025
  7. Q007 Medium Group revenue after eliminations, 2025
  8. Q008 Medium Mizan Retail revenue, 2025
  9. Q009 Medium Goodwill at the acquisition date
  10. Q010 Medium Book net assets acquired
  11. Q011 Medium Pakistan revenue in August 2024 before the acquisition
  12. Q012 Medium Pakistan profit consolidated in 2024
  13. Q013 Medium Amortisation of the fair-value uplift, 2025
  14. Q014 Medium Unrealised profit in group stock at 31 December 2025
  15. Q015 Medium Group EBITDA, 2025
  16. Q016 Medium Management fees charged by Holding, 2025
  17. Q017 Medium Intercompany differences in group profit, 2025
  18. Q018 Medium Group revenue growth, 2025 vs 2024
  19. Q019 Medium Peak month for group revenue, 2025
  20. Q020 Medium Mizan Retail's busiest trading day, 2025
  21. Q021 Medium Pakistan revenue for calendar 2025
  22. Q022 Hard Profit attributable to owners, 2025
  23. Q023 Hard Non-controlling interests' share of profit, 2025
  24. Q024 Hard Goodwill at 31 December 2025
  25. Q025 Hard Translation reserve at 31 December 2025
  26. Q026 Hard Non-controlling interests at 31 December 2025
  27. Q027 Hard Group net debt at 31 December 2025
  28. Q028 Hard Intercompany suspense at 31 December 2025
  29. Q029 Hard The invoice the counterparty never recorded
  30. Q030 Hard Goods booked against the wrong partner
  31. Q031 Hard Reportable segment with the best EBITDA margin, 2025
  32. Q032 Hard Worst month for group EBITDA against budget, 2025
  33. Q033 Hard Constant-currency revenue growth excluding Pakistan, 2025
  34. Q034 Hard Rolling 12-month group EBITDA to June 2025
  35. Q035 Hard Pakistan profit before the acquisition in FY2025
  36. Q036 Hard Journal lines to exclude, 2025
  37. Q037 Hard Reversal journals in Mizan Retail's ledger, 2025
  38. Q038 Hard Group effective tax rate, 2025
  39. Q039 Hard Best quarter for group gross margin, 2025
  40. Q040 Very Hard Group retained earnings at 31 December 2025
  41. Q041 Very Hard Total group equity at 31 December 2025
  42. Q042 Very Hard Consolidated total assets at 31 December 2025
  43. Q043 Very Hard Technology services segment external revenue, 2025
  44. Q044 Very Hard Non-controlling interest in Mizan Services Pakistan at 31 December 2025
  45. Q045 Very Hard Identifiable net assets acquired
  46. Q046 Very Hard Owners' share of Pakistan's 2025 profit
  47. Q047 Very Hard Months the group beat its revenue budget, 2025
  48. Q048 Very Hard Best three months for group EBITDA margin, 2025
  49. Q049 Very Hard Movement in the translation reserve, 2025
  50. Q050 Very Hard Exchange difference on goodwill, 2025
  51. Q051 Very Hard Real Estate UAE net assets in USD at 31 December 2025
  52. Q052 Very Hard Group revenue growth per year, 2023-2025
  53. Q053 Very Hard Group retained earnings at 30 June 2025
  54. Q054 Very Hard Largest month-end intercompany suspense, 2025
  55. Q055 Very Hard Suspense not explained by goods in transit or the dispute
  56. Q056 Very Hard Dividends eliminated on consolidation, 2025
  57. Q057 Very Hard Pakistan profit for calendar 2025
  58. Q058 Very Hard Ramadan uplift in Mizan Retail, March 2025
  59. Q059 Very Hard Exchange-rate effect on subsidiaries' EBITDA, 2025
  60. Q060 Very Hard Change in owners' profit, 2025 vs 2024

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

Create a free account Sign in