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
Get the data 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.

Create a free account Sign in
  • 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. Q001 Easy One ledger after the append
  2. Q002 Easy Logistics sales in 2025
  3. Q003 Easy Manufacturing cash in 2025
  4. Q004 Easy What the group is owed today
  5. Q005 Easy The new quarter's billing
  6. Q006 Easy Transfers received in 2025
  7. Q007 Easy Money from nobody
  8. Q008 Easy Disputes raised in 2025
  9. Q009 Easy Why Manufacturing's customers dispute
  10. Q010 Easy Logistics growth
  11. Q011 Easy Logistics customers on 60 days
  12. Q012 Easy Manufacturing's 2027 target
  13. Q013 Easy High-risk customers
  14. Q014 Easy The biggest transfer of 2025
  15. Q015 Easy The ledger's receivables account
  16. Q016 Easy A Logistics invoice
  17. Q017 Medium Ledger and subledger disagree
  18. Q018 Medium Overdue today
  19. Q019 Medium Ageing at mid-year
  20. Q020 Medium Best possible DSO
  21. Q021 Medium Days delinquent
  22. Q022 Medium Collection effectiveness
  23. Q023 Medium Invoices per transfer
  24. Q024 Medium How long cash waits in suspense
  25. Q025 Medium Disputes slow the cash
  26. Q026 Medium The price-rise pushback
  27. Q027 Medium Whose desk the overdue sits on
  28. Q028 Medium Manufacturing against target
  29. Q029 Medium Logistics' fiscal year
  30. Q030 Medium Logistics against target
  31. Q031 Medium The month the book grew most
  32. Q032 Medium Last quarter against last year
  33. Q033 Medium Customers over their limit
  34. Q034 Medium Export customers in the overdue
  35. Q035 Medium Falling due next month
  36. Q036 Medium Disputes still open
  37. Q037 Hard Count-back DSO
  38. Q038 Hard Roll rate
  39. Q039 Very Hard Cash nobody could place
  40. Q040 Very Hard The overdue book, corrected

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

Create a free account Sign in