Accounts payable dataset for practice — invoices, payments and payment runs
DATA DARE on findi360 has accounts payable practice datasets built from a realistic retail and manufacturing group: supplier invoices, payments, payment runs and supplier master data, with graded questions and a Question Book to check your answers. The higher levels add a full AP ledger across three companies, supplier statements, goods received not invoiced and the general-ledger control account. Downloading needs a findi360 account; each set uses a few Data Points, which you earn by taking part (every account starts with an opening balance).
The sets live now
Mizan Retail: Who We Owe and When We Pay — Accounts Payable & Payments
Read a payables book the way a finance team does: what is owed to suppliers and when it falls due, AP ageing, DPO, paying on time, early or late, payment runs,...
Get the data
Three Companies, Supplier Statements and a Bank Account That Changed — Accounts Payable & Payments
Work a group payables ledger: append the new period, build a calendar, age payables on posting and invoice dates, measure DPO, reconcile supplier statements, fo...
Get the data
Mizan Group: The Life of a Supplier Invoice — Accounts Payable & Payments
Mine the accounts payable process of a three-company group: cycle times from receipt to payment, touchless processing, match exceptions, holds and supplier quer...
Get the dataWhat is in the accounts payable sets
- Supplier invoices and payments with invoice, due and payment dates, so you can measure days payable and on-time payment.
- The weekly payment run and a payment plan, so you can see how cash leaves the business.
- Duplicate invoices that were caught before payment, and a supplier whose bank details change before a run of payments.
- Early-payment discounts that were missed, and a year-end cut-off to get right.
- At L2: three companies, supplier statements to reconcile, goods received not invoiced (GRNI) and the AP control account in the ledger.
- At L3: the life of a supplier invoice — cycle time from receipt to payment, touchless processing, match exceptions, holds and supplier queries.
Questions you will answer
- Days payable outstanding (DPO) by month, and which month it peaked.
- How much was paid late, and to which suppliers.
- How many duplicate invoices were caught, and the value held back.
- Discounts lost by paying too late.
- Whether the AP ledger agrees to the control account at the cut-off date.
How to start
- Pick the L1 set above and open its page.
- Sign in and download the package — L1 is one Excel workbook.
- Read the Business Introduction, then answer the first five questions.
- Check your numbers in the Question Book, and post your approach under the question.