A community of professionals helping you to  

  

maximize the benefits of audit software  

 

  Home   >    AuditSoftware.Net Store > Spreadsheet and Database Related Tools

 

   

Spreadsheet and Database Related Tools

ActiveData for Excel adds over 100 features for accountants, auditors and fraud detection specialists to Microsoft Excel TM. The time savings and efficiencies you gain means the software can pay for itself in 2 or 3 uses. You never have to learn a new environment or leave the one you’re comfortable in. The powerful analysis features such as group summaries, gap and duplicate detection, stratification, and digital analysis (benford's law) were previously only available in tools such as ACL and Caseware IDEA that cost thousands of dollars more. 
      

HealthSouth admitted to using a simple spreadsheet in committing their fraud, NASA found a $650 million dollar spreadsheet error, and there are countless other examples.  See the article where simple case-study examples and an automated tool (EXChecker) are shown to explain auditing one of the most overlooked financial documents that has one of the highest risk of errors and fraud....the spreadsheet.  Feel free to download the free 30-day demo of the automated Excel audit tool (EXChecker) to see for yourself how easy it is to find spreadsheet errors and fraud. 
  
   Fraud Detection and Cash Recovery Using ActiveData for Excel - The purpose of this 8 hour CPE course is to assist auditors, fraud examiners, and management in implementing data analysis routines using ActiveData for Microsoft Excel. It is hoped that through the dissemination of this new information that more analysis will be done using audit software to prevent and proactively detect organizational inefficiency, ineffectiveness, and fraud. It walks through 16 common fraud detection, cash recovery and audit tests within the accounts payable, accounts receivable, and general ledger audit areas. 
This course will: 1) Introduce you to the powerful combination of ActiveData and Excel, 2) Walk you through basic fraud detection and cash recovery reporting concepts, 3)  Map out each step for the most common of fraud detection, cash recovery and audit tests, 4) Equip you with sample data, providing a glimpse of the resulting report prior to the (crunch time) situation, and 5) Suggest fraud detection and audit procedures to perform on the resulting reports.
   

   Top Tests Using ActiveData for Excel - Want to get up and running FAST with ActiveData for Excel?  Need to get measurable results for your organization and get the most from your ActiveData for Excel investment?  Want to learn how to practically apply ActiveData for Excel to top audit areas with minimal learning curve?  Then take a look at the Top Audit Tests Using ActiveData for Excel user manual that walks you, step-by-step through popular audit tests in the most popular audit areas: 
>Accounts Payable, 
>Accounts Receivable, 
>General Ledger 
   
Not only that but the guide provides sample data to test your skills prior to using "live" company data. 

Using Microsoft Access to Audit Payables for Fraud - Accounts payable have always been a preferred target for fraud by employees. This course will help you gain a clear understanding of the concepts used to audit payables for fraud with Microsoft Access® and why certain tests area more effective than others.  You will learn the following in this 8 hour CPE course: 1) Basic features of Microsoft Access, 2) Types of audit software, 3) Proactive detection of fraud using audit and other planning tools, 4) Four steps needed to request data from a client, 5) How to modify tests for different situations and needs, 6) How identify where vendor payments are going, 7) How to summarize debit memos.  To learn more, watch the sample video (requires Macromedia Flash Player).  Also, see the recent product review on AuditNet

   

 

 

 

 

 

 

 

 

 

 

Copyright and Other Policies