Skip to main content
Data Dare general ledger & trial balance L3 sticker: the findi360 mascot analysing Three Companies, Four Dates, One Close — GL, Trial Balance, Bank and Budget.

DD-GLT-003

Three Companies, Four Dates, One Close — GL, Trial Balance, Bank and Budget

Mizan Retail (40 stores), Mizan Manufacturing and Mizan Logistics, January 2023 to September 2026, each on its own ERP; Logistics closes its year in March. Twelve tables arrive the way the systems hand them over: the journal lines and master data in Parquet, the trial balance export and supplier master in CSV, the bank's statement feed and the user master in JSON, the budgets and the close calendar in Excel. There is no date table. Every journal carries a document date, a posting date, an entry timestamp and, for invoices, a due date; manual journals carry an approval timestamp. Build the calendar and the fiscal calendar, reconcile GL to TB to bank, test the journals - parked, late, period 13, duplicates, approval limits, self-approval, after-hours entries - and explain why sales and margins moved: store openings, a supplier price rise, a lost customer, a resin spike, a fuel spike, a new contract. The same companies are consolidated in DD-CON-002.

  • General Ledger & Trial Balance
  • L3 · PARQUET
  • ~1,172,802 rows
  • 12 tables
  • 50 questions
Free account: download the data, check your answers and earn a certificate. Create it → More General Ledger & Trial Balance: L1 Next in the story: Budget vs Actual → In Python: Trial balance in Python →

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-GLT-003_Question_Book.pdf 1.2 MB · v1.0
  • Dataset Documentation / Data Dictionary XLSX DD-GLT-003_Data_Dictionary.xlsx 15 KB · v1.0
  • Business Introduction PDF DD-GLT-003_Business_Introduction.pdf 8.2 KB · v1.0
  • Relationship Diagram PDF DD-GLT-003_Relationship_Model.pdf 615.1 KB · v1.0
  • Raw fact data DD-GLT-003_FactJournalLines.parquet 18 MB · v1.0
  • Dimension / supporting data DD-GLT-003_Dimensions.zip 3.1 MB · v1.0

Questions

Open one to discuss it
  1. Q001 Easy Journal lines in the ledger
  2. Q002 Easy Posted journals
  3. Q003 Easy Group revenue for 2025
  4. Q004 Easy Mizan Manufacturing revenue, 2024
  5. Q005 Easy Customers in the party master
  6. Q006 Easy Parked journals
  7. Q007 Easy Stores in the estate
  8. Q008 Easy Mizan Retail revenue budget, 2025
  9. Q009 Easy Bank feed: Manufacturing transactions in 2025
  10. Q010 Easy Users who can approve a million
  11. Q011 Easy Special periods in the close calendar
  12. Q012 Easy Mizan Retail cash at bank, 30 September 2026
  13. Q013 Medium Mizan Retail: best month of 2024
  14. Q014 Medium Group revenue growth, 2025 over 2024
  15. Q015 Medium Group EBITDA, 2025
  16. Q016 Medium Like-for-like store growth, 2025
  17. Q017 Medium Manufacturing: the sharpest monthly fall of 2025
  18. Q018 Medium Logistics: May 2024 against April 2024
  19. Q019 Medium Mizan Retail: January-September growth, 2026
  20. Q020 Medium Mizan Logistics revenue, fiscal year 2026
  21. Q021 Medium Weekend entries
  22. Q022 Medium Journals posted by an inactive user
  23. Q023 Medium Cut-off: December invoices posted in January 2026
  24. Q024 Medium Largest supplier of 2025
  25. Q025 Medium December 2025 invoices by document date
  26. Q026 Medium December 2025 invoices by posting date
  27. Q027 Medium Journals entered after the trial balance was exported
  28. Q028 Medium Period-13 adjustments, 2024
  29. Q029 Medium After-hours entries
  30. Q030 Medium How long approval takes
  31. Q031 Hard December 2025 invoices by entry date
  32. Q032 Hard December 2025 invoices by due date
  33. Q033 Hard GL against the exported trial balance: Retail, period 202509
  34. Q034 Hard Duplicate supplier invoices
  35. Q035 Hard Retail: the accrual that was never reversed
  36. Q036 Hard Bank reconciliation: Retail at 30 September 2026
  37. Q037 Hard Self-approved journals
  38. Q038 Hard Rubber-stamp approvals
  39. Q039 Hard Manufacturing revenue against budget, 2025
  40. Q040 Hard Resin as a share of sales
  41. Q041 Hard Retained earnings brought forward, Retail 2026
  42. Q042 Hard Value of over-limit manual journals
  43. Q043 Very Hard Manufacturing profit before tax, 2024
  44. Q044 Very Hard Logistics EBITDA, fiscal 2025 against fiscal 2024
  45. Q045 Very Hard Manufacturing growth without its lost customer
  46. Q046 Very Hard Fuel as a share of Logistics revenue: the peak month
  47. Q047 Very Hard Reforecast against budget: Retail revenue 2026
  48. Q048 Very Hard Payables more than 30 days overdue
  49. Q049 Very Hard Group gross profit bridge 2025: the margin effect
  50. Q050 Very Hard Bank reconciliation: Manufacturing at 30 June 2026

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