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- Q001 Easy One ledger after the append
- Q002 Easy Logistics sales in 2025
- Q003 Easy Manufacturing cash in 2025
- Q004 Easy What the group is owed today
- Q005 Easy The new quarter's billing
- Q006 Easy Transfers received in 2025
- Q007 Easy Money from nobody
- Q008 Easy Disputes raised in 2025
- Q009 Easy Why Manufacturing's customers dispute
- Q010 Easy Logistics growth
- Q011 Easy Logistics customers on 60 days
- Q012 Easy Manufacturing's 2027 target
- Q013 Easy High-risk customers
- Q014 Easy The biggest transfer of 2025
- Q015 Easy The ledger's receivables account
- Q016 Easy A Logistics invoice
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