Skip to main content
Data Dare audit & assurance L2 sticker: the findi360 mascot analysing Sampling, Cut-off and the Missing Invoices - Audit & Assurance.

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
Free account: download the data, check your answers and earn a certificate. Create it → More Audit & Assurance: 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-AUD-002_Question_Book.pdf 1.2 MB · v1.0
  • Dataset Documentation / Data Dictionary XLSX DD-AUD-002_Data_Dictionary.xlsx 12.5 KB · v1.0
  • Business Introduction PDF DD-AUD-002_Business_Introduction.pdf 614.5 KB · v1.0
  • Relationship Diagram PDF DD-AUD-002_Relationship_Model.pdf 614.4 KB · v1.0
  • Raw fact data DD-AUD-002_FactInvoiceRegister.csv 3.2 MB · v1.0
  • Dimension / supporting data DD-AUD-002_Dimensions.zip 285.7 KB · v1.0

Questions

Open one to discuss it
  1. Q001 Easy Invoices on the register
  2. Q002 Easy Billed in 2025
  3. Q003 Easy The biggest branch of 2025
  4. Q004 Easy Invoices raised by the trade counter in 2025
  5. Q005 Easy The largest invoice
  6. Q006 Easy Missing numbers at the trade counter, 2025
  7. Q007 Easy Shipped one year, billed the next
  8. Q008 Easy The value that slipped the year
  9. Q009 Easy Months where the GL disagrees
  10. Q010 Easy Purchase orders on file
  11. Q011 Easy Clean matches
  12. Q012 Easy The exception rate
  13. Q013 Easy Paid twice
  14. Q014 Easy Access rights on file
  15. Q015 Easy The strongest billing month of 2025
  16. Q016 Easy December surge
  17. Q017 Medium Completeness by branch, 2025
  18. Q018 Medium Where the numbers go missing
  19. Q019 Medium The leak rate
  20. Q020 Medium Cut-off at the 2025 year end
  21. Q021 Medium Average days from gate to invoice
  22. Q022 Medium The topside accrual
  23. Q023 Medium Where the GL first disagrees
  24. Q024 Medium Do the differences cancel?
  25. Q025 Medium What the price variances cost
  26. Q026 Medium The double payment
  27. Q027 Medium Invoices with no goods receipt
  28. Q028 Medium Raised and approved by the same person
  29. Q029 Medium Who holds both sides
  30. Q030 Medium The value he self-approved
  31. Q031 Medium Short deliveries billed in full
  32. Q032 Medium The worst month for exceptions
  33. Q033 Medium Billing growth, year on year
  34. Q034 Medium The top stratum
  35. Q035 Medium Coverage of the top stratum
  36. Q036 Medium Rolling twelve months
  37. Q037 Hard The sampling interval
  38. Q038 Hard The big invoice's odds
  39. Q039 Very Hard Revenue on a shipped basis, 2025
  40. 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