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. Q037 Hard The sampling interval
  2. Q038 Hard The big invoice's odds

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