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. Q017 Medium Completeness by branch, 2025
  2. Q018 Medium Where the numbers go missing
  3. Q019 Medium The leak rate
  4. Q020 Medium Cut-off at the 2025 year end
  5. Q021 Medium Average days from gate to invoice
  6. Q022 Medium The topside accrual
  7. Q023 Medium Where the GL first disagrees
  8. Q024 Medium Do the differences cancel?
  9. Q025 Medium What the price variances cost
  10. Q026 Medium The double payment
  11. Q027 Medium Invoices with no goods receipt
  12. Q028 Medium Raised and approved by the same person
  13. Q029 Medium Who holds both sides
  14. Q030 Medium The value he self-approved
  15. Q031 Medium Short deliveries billed in full
  16. Q032 Medium The worst month for exceptions
  17. Q033 Medium Billing growth, year on year
  18. Q034 Medium The top stratum
  19. Q035 Medium Coverage of the top stratum
  20. Q036 Medium Rolling twelve months

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