Blog Main Page
Areas of Applications
Audit
Automate Procedures
Best Practices
CaseWare IDEA
Data Analytics
Fraud
IDEAScript
Importing
IUC 2020
News
Tech Tip
Visualization/Reporting
School Districts
CaseWare IDEA Applications
Schools have many of the standard ledgers, payroll and accounts payable can be key concerns. Typical test areas include:
Asset Management
Identify fully depreciated items and assets higher than replacement cost
Recap asset values, in value order, by net or cost amount
Recalculate expense and reserve amounts using replacement costs
Compare useful lives of assets by category
Extract assets with useful lives or depreciation rates beyond set norms.
Kickback or Conflict-of-Interest Schemes
Look for vendor prices greater than the standard
Identify price increases greater than acceptable percentages
Check for continued purchases in spite of high rates or returns, rejections, or credits
Look for high volume purchases from one vendor
Phantom Vendor Schemes
Match names, addresses, and phone numbers between employee and vendor files
Check vendor addresses against marketing address lists
Policy Compliance
Monitor the retention of various records and documents to ensure compliance with government (Federal State) and/or local regulations
Extract transactions by funding code, fiscal year, and obligation control level and then compare to encumbrances
Analyze rates and license fees on licenses to determine bylaw compliance
Match vendor address files with employee address files to ensure compliance with vendor restrictions
Extract purchase orders below the dollar amount requiring compliance with sealed bids
Extract transactions of assets funded by federal grants to ensure compliance with grant requirements
Sort contracts databases by contract or cost types to test compliance with government contract terms
Questionable Invoices
Identify invoices without a valid purchase order
Look for invoices from vendors not in the approved vendor file
Find invoices for more than one purchase order authorization
Identify multiple invoices with the same item description
Extract vendors with duplicate invoice numbers
Look for multiple invoices for the same amount on the same day
Find invoice payments issued on non-business days (e.g., Saturdays and Sundays)
Identify multiple invoices at or just under approval cut-off levels
Areas of Applications
,
CaseWare IDEA