DD-ARC-002
Two Companies, Lump Payments and Cash Nobody Can Place — Accounts Receivable & Collections
Mizan Manufacturing and Mizan Logistics (105 customers, the Logistics year running April to March) keep their receivables in one subledger. You get it as the ERP exports it: 64,282 ledger lines to June 2026 as CSV and the last three months as a separate Parquet file, the bank's remittance feed (JSON), the disputes log, collection targets including next year's plan, the month-end balance of the receivables account in the general ledger, the customer master and a calendar. Find the cash nobody could place, the disputes behind the late payers - and why the ledger and the subledger disagree.
- Accounts Receivable & Collections
- L2 · CSV
- ~64,282 rows
- 8 tables
- 40 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-ARC-002_Question_Book.pdf
- Dataset Documentation / Data Dictionary XLSX DD-ARC-002_Data_Dictionary.xlsx
- Business Introduction PDF DD-ARC-002_Business_Introduction.pdf
- Relationship Diagram PDF DD-ARC-002_Relationship_Model.pdf
- Raw fact data DD-ARC-002_FactARLedger.csv
- Dimension / supporting data DD-ARC-002_Dimensions.zip
Questions
Open one to discuss it- Q017 Medium Ledger and subledger disagree
- Q018 Medium Overdue today
- Q019 Medium Ageing at mid-year
- Q020 Medium Best possible DSO
- Q021 Medium Days delinquent
- Q022 Medium Collection effectiveness
- Q023 Medium Invoices per transfer
- Q024 Medium How long cash waits in suspense
- Q025 Medium Disputes slow the cash
- Q026 Medium The price-rise pushback
- Q027 Medium Whose desk the overdue sits on
- Q028 Medium Manufacturing against target
- Q029 Medium Logistics' fiscal year
- Q030 Medium Logistics against target
- Q031 Medium The month the book grew most
- Q032 Medium Last quarter against last year
- Q033 Medium Customers over their limit
- Q034 Medium Export customers in the overdue
- Q035 Medium Falling due next month
- Q036 Medium Disputes still open
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