Skip to main content
Data Dare accounts receivable & collections L2 sticker: the findi360 mascot analysing Two Companies, Lump Payments and Cash Nobody Can Place — Accounts Receivable & Collections.

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
Free account: download the data, check your answers and earn a certificate. Create it → More Accounts Receivable & Collections: L1

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-ARC-002_Question_Book.pdf 1.2 MB · v1.0
  • Dataset Documentation / Data Dictionary XLSX DD-ARC-002_Data_Dictionary.xlsx 13.3 KB · v1.0
  • Business Introduction PDF DD-ARC-002_Business_Introduction.pdf 614.9 KB · v1.0
  • Relationship Diagram PDF DD-ARC-002_Relationship_Model.pdf 615.2 KB · v1.0
  • Raw fact data DD-ARC-002_FactARLedger.csv 7 MB · v1.0
  • Dimension / supporting data DD-ARC-002_Dimensions.zip 923.4 KB · v1.0

Questions

Open one to discuss it
  1. Q017 Medium Ledger and subledger disagree
  2. Q018 Medium Overdue today
  3. Q019 Medium Ageing at mid-year
  4. Q020 Medium Best possible DSO
  5. Q021 Medium Days delinquent
  6. Q022 Medium Collection effectiveness
  7. Q023 Medium Invoices per transfer
  8. Q024 Medium How long cash waits in suspense
  9. Q025 Medium Disputes slow the cash
  10. Q026 Medium The price-rise pushback
  11. Q027 Medium Whose desk the overdue sits on
  12. Q028 Medium Manufacturing against target
  13. Q029 Medium Logistics' fiscal year
  14. Q030 Medium Logistics against target
  15. Q031 Medium The month the book grew most
  16. Q032 Medium Last quarter against last year
  17. Q033 Medium Customers over their limit
  18. Q034 Medium Export customers in the overdue
  19. Q035 Medium Falling due next month
  20. 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