DD-AUD-002 New
Sampling, Cut-off and the Missing Invoices - Audit & Assurance
Year two at Mizan Industrial Components. Four branches issue sales invoices from yearly number sequences - you get the full register, 32,627 rows as CSV plus the latest three months as Parquet to append, each invoice with its ship date and raiser. Alongside it: the monthly GL revenue control, the purchase three-way match with its exception statuses, the user access grants and a calendar. Numbers are missing from one branch, December goods were billed in January, the GL and the register disagree in exactly four months, one supplier was paid twice - and one buyer approves his own invoices.
- Audit & Assurance
- L2 · CSV
- ~32,627 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-AUD-002_Question_Book.pdf
- Dataset Documentation / Data Dictionary XLSX DD-AUD-002_Data_Dictionary.xlsx
- Business Introduction PDF DD-AUD-002_Business_Introduction.pdf
- Relationship Diagram PDF DD-AUD-002_Relationship_Model.pdf
- Raw fact data DD-AUD-002_FactInvoiceRegister.csv
- Dimension / supporting data DD-AUD-002_Dimensions.zip
Questions
Open one to discuss it- Q001 Easy Invoices on the register
- Q002 Easy Billed in 2025
- Q003 Easy The biggest branch of 2025
- Q004 Easy Invoices raised by the trade counter in 2025
- Q005 Easy The largest invoice
- Q006 Easy Missing numbers at the trade counter, 2025
- Q007 Easy Shipped one year, billed the next
- Q008 Easy The value that slipped the year
- Q009 Easy Months where the GL disagrees
- Q010 Easy Purchase orders on file
- Q011 Easy Clean matches
- Q012 Easy The exception rate
- Q013 Easy Paid twice
- Q014 Easy Access rights on file
- Q015 Easy The strongest billing month of 2025
- Q016 Easy December surge
- Q017 Medium Completeness by branch, 2025
- Q018 Medium Where the numbers go missing
- Q019 Medium The leak rate
- Q020 Medium Cut-off at the 2025 year end
- Q021 Medium Average days from gate to invoice
- Q022 Medium The topside accrual
- Q023 Medium Where the GL first disagrees
- Q024 Medium Do the differences cancel?
- Q025 Medium What the price variances cost
- Q026 Medium The double payment
- Q027 Medium Invoices with no goods receipt
- Q028 Medium Raised and approved by the same person
- Q029 Medium Who holds both sides
- Q030 Medium The value he self-approved
- Q031 Medium Short deliveries billed in full
- Q032 Medium The worst month for exceptions
- Q033 Medium Billing growth, year on year
- Q034 Medium The top stratum
- Q035 Medium Coverage of the top stratum
- Q036 Medium Rolling twelve months
- Q037 Hard The sampling interval
- Q038 Hard The big invoice's odds
- Q039 Very Hard Revenue on a shipped basis, 2025
- Q040 Very Hard The month the counter leaked most
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