Case Study: How to Analyse Credit Limits and Data-Mine Purchase Orders

Testing credit limits against sales and overdues, then data mining purchase orders: invoice rates above the agreed PO rate and open orders not yet delivered.

9 min video · Module: Module 5: Planning and Executing an Internal Audit · ₹49 / $0.49 · 2 views within 7 days

Included with this video

• Assignment: Audit Queries from Raw Data (PDF)
• Raw File for Audit (Analysis) (XLSX)
• Solution for Self Evaluation (XLSX)
• A 3-question quiz, unlocked after you watch the video

Put it into practice

• Depot and Distribution Warehouse Operations: Risk and Control Matrix (Excel) (Risk Control Matrix, XLSX)
• Marketing and Sales: Risk and Control Matrix (Excel) (Risk Control Matrix, XLSX)
• Outbound Logistics (Orders to Dispatch): Risk and Control Matrix (Excel) (Risk Control Matrix, XLSX)
• Sales (Inquiry to Cash): Risk and Control Matrix (Excel) (Risk Control Matrix, XLSX)

Previous: Case Study: How to Analyse a Yarn Distributor with Ratios and Trends
Next: Ten Golden Rules of Fieldwork (1): Controls, Objectivity and Evidence

All videos

---

Checklists, templates and sample documents · Free articles and guides · YouTube

Learn Internal Audit is run by SKYBOT Technology LLP. The founders, Amit Salla and Zehra Maccawala, are partners at ZMAS and Associates, a Chartered Accountancy firm specialising in internal audit.