DD-APY-002
Three Companies, Supplier Statements and a Bank Account That Changed — Accounts Payable & Payments
Mizan Retail, Mizan Manufacturing and Mizan Logistics (155 suppliers) keep one payables ledger. You get it as the ERP exports it: 45,305 ledger lines to June 2026 as CSV and the last three months as a separate Parquet file, the bank payment files (JSON), quarter-end statements from the largest suppliers, goods received not invoiced at every month-end, the payment plan including next year's, the general ledger's month-end payables and the supplier master with discounts and bank accounts. There is no calendar. Find the discounts nobody took, the payments that went to the wrong account - and why the statements do not agree.
- Accounts Payable & Payments
- L2 · CSV
- ~45,305 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-APY-002_Question_Book.pdf
- Dataset Documentation / Data Dictionary XLSX DD-APY-002_Data_Dictionary.xlsx
- Business Introduction PDF DD-APY-002_Business_Introduction.pdf
- Relationship Diagram PDF DD-APY-002_Relationship_Model.pdf
- Raw fact data DD-APY-002_FactAPLedger.csv
- Dimension / supporting data DD-APY-002_Dimensions.zip
Questions
Open one to discuss it- Q001 Easy One payables ledger after the append
- Q002 Easy Manufacturing's supplier invoices in 2025
- Q003 Easy Logistics paid in 2025
- Q004 Easy What the group owes today
- Q005 Easy Payment runs in 2025
- Q006 Easy The biggest payment run of 2025
- Q007 Easy Suppliers who pay you to pay early
- Q008 Easy Goods in, invoice not yet
- Q009 Easy Retail's payables in the ledger
- Q010 Easy Statements at year-end
- Q011 Easy Retail invoices in 2025
- Q012 Easy Logistics buying growth
- Q013 Easy The group's 2027 payment plan
- Q014 Easy Suppliers abroad
- Q015 Easy An average Logistics payment
- Q016 Easy Invoices keyed in late
- Q017 Medium The year-end cut-off
- Q018 Medium Overdue today
- Q019 Medium Manufacturing's DPO
- Q020 Medium Discounts left on the table
- Q021 Medium How long the discount suppliers wait
- Q022 Medium Paid to the wrong account
- Q023 Medium How much went to the wrong account
- Q024 Medium The statement that disagrees most
- Q025 Medium On the statement, not yet in the ledger
- Q026 Medium Payments on the way
- Q027 Medium The month GRNI peaked in 2025
- Q028 Medium Duplicates across the group
- Q029 Medium Duplicates nobody paid
- Q030 Medium The Monday run
- Q031 Medium Logistics pays late
- Q032 Medium Manufacturing against its plan
- Q033 Medium Logistics' fiscal year
- Q034 Medium The new quarter against last year
- Q035 Medium Payments per run
- Q036 Medium Falling due next month
- Q037 Hard Count-back DPO
- Q038 Hard What the statements do not explain
- Q039 Very Hard The worst month-end for overdue payables
- Q040 Very Hard The true year-end liability
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