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. Q022 Hard Profit attributable to owners, 2025
  2. Q023 Hard Non-controlling interests' share of profit, 2025
  3. Q024 Hard Goodwill at 31 December 2025
  4. Q025 Hard Translation reserve at 31 December 2025
  5. Q026 Hard Non-controlling interests at 31 December 2025
  6. Q027 Hard Group net debt at 31 December 2025
  7. Q028 Hard Intercompany suspense at 31 December 2025
  8. Q029 Hard The invoice the counterparty never recorded
  9. Q030 Hard Goods booked against the wrong partner
  10. Q031 Hard Reportable segment with the best EBITDA margin, 2025
  11. Q032 Hard Worst month for group EBITDA against budget, 2025
  12. Q033 Hard Constant-currency revenue growth excluding Pakistan, 2025
  13. Q034 Hard Rolling 12-month group EBITDA to June 2025
  14. Q035 Hard Pakistan profit before the acquisition in FY2025
  15. Q036 Hard Journal lines to exclude, 2025
  16. Q037 Hard Reversal journals in Mizan Retail's ledger, 2025
  17. Q038 Hard Group effective tax rate, 2025
  18. Q039 Hard Best quarter for group gross 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

Create a free account Sign in