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
Get the data
v1.0 · 6 filesFiles are for members. A free account takes a minute, and you come straight back here.
- Question Book PDF DD-GLT-003_Question_Book.pdf
- Dataset Documentation / Data Dictionary XLSX DD-GLT-003_Data_Dictionary.xlsx
- Business Introduction PDF DD-GLT-003_Business_Introduction.pdf
- Relationship Diagram PDF DD-GLT-003_Relationship_Model.pdf
- Raw fact data DD-GLT-003_FactJournalLines.parquet
- Dimension / supporting data DD-GLT-003_Dimensions.zip
Questions
Open one to discuss it- Q013 Medium Mizan Retail: best month of 2024
- Q014 Medium Group revenue growth, 2025 over 2024
- Q015 Medium Group EBITDA, 2025
- Q016 Medium Like-for-like store growth, 2025
- Q017 Medium Manufacturing: the sharpest monthly fall of 2025
- Q018 Medium Logistics: May 2024 against April 2024
- Q019 Medium Mizan Retail: January-September growth, 2026
- Q020 Medium Mizan Logistics revenue, fiscal year 2026
- Q021 Medium Weekend entries
- Q022 Medium Journals posted by an inactive user
- Q023 Medium Cut-off: December invoices posted in January 2026
- Q024 Medium Largest supplier of 2025
- Q025 Medium December 2025 invoices by document date
- Q026 Medium December 2025 invoices by posting date
- Q027 Medium Journals entered after the trial balance was exported
- Q028 Medium Period-13 adjustments, 2024
- Q029 Medium After-hours entries
- Q030 Medium How long approval takes
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