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. Q043 Very Hard Manufacturing profit before tax, 2024
  2. Q044 Very Hard Logistics EBITDA, fiscal 2025 against fiscal 2024
  3. Q045 Very Hard Manufacturing growth without its lost customer
  4. Q046 Very Hard Fuel as a share of Logistics revenue: the peak month
  5. Q047 Very Hard Reforecast against budget: Retail revenue 2026
  6. Q048 Very Hard Payables more than 30 days overdue
  7. Q049 Very Hard Group gross profit bridge 2025: the margin effect
  8. 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