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 itGeneral 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