X
Icon

The 21st Minute


Blog


Retail

CaseWare IDEA Applications


Retailers have many of the standard ledgers, purchasing and payroll can be key concerns. However, the main business areas are sales and inventories. Retailers often have point-of-sale systems which collect large volumes of useful data which IDEA can analyze. The main tests on inventories are similar to manufacturing companies with perhaps more emphasis on movement, margins, and shrinkage. Typical test areas include:

 

Cash Disbursements

 

  • Monitor cash disbursements for stores
  • Track cash disbursements for contractor and vendor services.
  • Summarize cash disbursements by account, bank, group, and vendor

 

Loss Prevention

 

  • Compare “No Sale” transactions to cash-voided transactions by associate
  • Identify stores with significant allowances
  • Isolate duplicate return transactions
  • Identify incomplete exchange transactions
  • Look for cheque purchases and refunds within 15 days
  • Find credit card purchases and refunds to different credit cards (same day)
  • Identify potential fraudulent or improper transactions through selling price differences between stores

 

Purchase Order Management

 

  • Reconcile order received to purchase order to identify shipments not ordered
  • Extract pricing receipt quantity variations by vendor and purchase order
  • Track scheduled receipt dates versus actual receipt dates
  • Compare vendor performance by summarizing item delivery and quality
  • Compare accrued

 

Additional Tests Included

 

  • Analyze gross profit
  • Identify items past their shelf life
  • Compare holdings and inventory turnover per product line between stores
  • Isolate price adjustment transactions

Areas of Applications , CaseWare IDEA



Posted By

By Team Audimation


Related Posts
CaseWare IDEA in the News: Excel on Steroids
Oct 23 Excel on Steroids Firm: Wipfli Product: CaseWare IDEA® Audit Function: Data Analysis On Record: Matt Storlie, Manager of Forensic & Litigation ...
Using Non-Financial Data to Detect Fraud
Oct 23 Lessons Learned from the Casino Industry Behind the flashing lights, dings, and bells of a casino floor, massive amounts of data are generated each second. E...
Tech Tip: Filling Empty Cells
Oct 23 Importing data that is not formatted correctly can drain hours of your analysis time. An IDEA user was working with general ledger detail that required an accou...
BROWSER NOT SUPPORTED

This website has been designed for modern browsers. Please update. Update my browser now

×