e-Tools for Auditors

 

March 2013

Cloud Computing

The AuditNet Newsletter is sponsored by:

ACL CCH TeamMate Thomson Reuters

 

Join The Professional Audit Information Networking Group

 

Find out how TeamMates's award-winning audit management system can increase the efficiency and productivity of your entire audit process.

 

http://teammate.arclogics.com/Rescue


ACL Connections

Our global customer conference is back and headed for Atlanta, Georgia in April. We're building an impressive speaker line-up that is sure to inspire and invigorate. We'll feature leaders in their field sharing insights and addressing key issues relevant to audit, finance, risk and compliance professionals across 22 hours of sessions and multiple networking opportunities.

Subscribe for Updates: www.acl.com/connections/subscribe.html
Register: www.acl.com/connections/register.html


THOMSON REUTERS SPECIAL REPORT

Read the special report, Culture, Corporate Governance and the Internal Auditor to better understand internal audit’s perspective on the challenges the profession is facing and examine recent and pending regulations from around the globe and their impact on the internal audit profession.

http://accelus.thomsonreuters.com/campaign/culture-corporate-governance-and-internal-auditor?lsd=AuditNet+Enews

 


 Follow AuditNet on Facebook

 


Audit Management Software - TrackWise by Sparta Systems

 

 

 

Post a Job for Under $200

Follow AuditNet on

Twitter.com

 

what
job title, keywords
where
city, state, zip

 

       



 

 


 

 

 

 

 

 

 

 

Guide to the Sarbanes-Oxley Act: IT Risks and Controls (Second Edition)

Protiviti has published the second edition of its popular book, Guide to the Sarbanes-Oxley Act: IT Risks and Controls. This publication is the definitive resource guide on IT risks and control issues related to compliance with SOX Section 404.

Guide to the Sarbanes-Oxley Act: IT Risks and Controls (Second Edition) provides guidance to Section 404 compliance project teams on the consideration of IT risks and controls at both the entity and activity levels within an organization. Questions and answers in the book focus on the interaction between the IT organization and the entity’s application and data-process owners, and explain the implications of general IT controls and how they are considered at the process level. This guide also explores how application-control assessments are integrated with the assessment of business-process controls, and addresses documentation, testing and remediation matters.

Click here for the Guide!

This article was contributed by Protiviti KnowledgeLeader, an online service providing tools, templates, and other resources for internal audit and risk management. Free trials available at www.knowledgeleader.com.


Wk Logo

HONG KONG - Feb. 14, 2013 – Wolters Kluwer Audit, Risk & Compliance announced today that it has named Matt Sullivan general manager for its TeamMate audit management system in the Asia-Pacific region.

In this role, Sullivan will be responsible for overseeing TeamMate’s expansion efforts in the region, creating new business relationships and bringing new products and services to the marketplace.

Sullivan joined Wolters Kluwer Audit, Risk & Compliance’s parent company, Wolters Kluwer, more than 15 years ago and has extensive experience in the Asia-Pacific region, supporting the company’s growth in China, Southeast Asia, India and Australia. Most recently, he was managing director of CCH Australia & New Zealand for Wolters Kluwer, where he oversaw a substantial portfolio of information and software assets, helping drive growth organically and through acquisition. Earlier in his career, Sullivan was the managing director of CCH Asia, based first in Singapore and then Beijing. In that role, he spearheaded CCH’s entry into China and India. Prior to this, he lived and worked in Japan, establishing industry partnerships for Wolters Kluwer in the country.

“As TeamMate expands its presence in the Asia-Pacific region, Matt’s experience and deep understanding of the marketplace make him the ideal person to lead operations so we can continue to help growing businesses meet increasing compliance challenges,” said Mike Gowell, vice president and global general manager of TeamMate.

“With various countries in the Asia-Pacific region facing new or changing regulations, many companies are dealing with more complex requirements,” said Sullivan. “That coupled with rapid growth and development in Asian economies definitely creates a need for organizations across multiple industries to manage risk more transparently, and the internal audit process plays a critical role in that.”

TeamMate is the world’s most widely-used audit management system. More than 90,000 auditors and over 2,000 organizations across the world rely on TeamMate to improve the audit process, including risk assessment, scheduling, planning, execution, review, report generation, trend analysis, committee reporting and storage.

About Wolters Kluwer Audit, Risk & Compliance
Wolters Kluwer Audit, Risk & Compliance is part of Wolters Kluwer, a leading global information services and solutions provider with annual revenues of (2011) €3.4 billion ($4.7 billion) and approximately 19,000 employees worldwide. Please visit our website for more information.

 


 

Technology and Auditing

AuditNet®  - 2012 AuditNet Data Analysis Audit Software Survey


Data analysis technology tools provide auditors with tremendous opportunities in today's digital world.


However according to the IIA's Global Technology Audit Guide 16 Data Analysis Technologies released in 2011- although internal auditors have been doing data analysis for more than 25 years, it has only recently started to become standard practice.

But is it really standard practice for most internal auditors? A recent survey conducted by AuditNet on Audit use of Audit Technology revealed that auditors are using data analysis software tools mainly on an ad hoc basis. So what is the current state of auditors implementing data analysis software technology for planning and conducting audits. AuditNet has long held the opinion that data analytics are not as widely used as the profession would lead us to believe. The Surveys by leading audit associations and consulting organizations as well as AuditNet® have highlighted the fact that while auditors are using some of the technology, most still have a long way to go to reach a level of maturity beyond the ad hoc usage.

The 2012 Data Analysis Audit Software Survey builds on the 2010 survey we conducted to determine where auditors are with regards to data analytics technology and what changes have taken place in the last 2 years. The 2010 survey represents the benchmark against which we will measure the progress that has taken place to see if the audit use of data analysis software technology is in fact standard practice.
 

Summary of response click here!

AuditNet Past Surveys

   

AuditNet® conducts periodic user surveys based on relevant or hot topics as well as areas suggested by our users. Click here for a list of the surveys that we have completed.

 

If you have an idea for a survey or would like us to conduct a survey for a particular subject send us an email. We are particularly interested in surveys that explore the use of technology for auditors.

 


Training Institute

a Wholly Owned Division of AuditNet®

Training without Travel™ Internal Audit Skills Series

 

AuditNet® has joined forces with Woodington Training Solutions and William Woodington to bring you a structured learning curriculum for internal audit. The courses are designed to build on skills developed from prior knowledge or training. Auditors can choose between the complete series or pick and choose specific courses depending on both needs as well as budgetary financial constraints.

Following is the schedule of Webinars beginning in January 2013 (sign up for one or more now)

  1. Writing to Achieve Results 1.5 CPE 

  2. Risk-Based Auditing 1.5 CPE

  3. Internal Auditing Basics 1.5 CPE

  4. Fieldwork 1.5 CPE

  5. Assertiveness Skills for Auditors 1.5 CPE

  6. Interim Performance Appraisals for Auditors 1.0 CPE

  7. Leading Effective Exit Meetings 1.0 CPE

  8. Leadership 101 1.5 CPE


Training without Travel

No CPE Option

AuditSoftwareVideos.com

Data Analytics Using Audit Software - The Latest Tools and Technology for Auditors!

Click here to view the video for free!

 


 

Click on the links below for the listed Webinars (may be part of a package however they are also available for individual sign up)

 

 

Click on the following to sign up for individual Webinars or packages (all Webinars are recorded for viewing at your convenience. We can only provide CPE certificates for attendance at the live Webinar)

 

Training Without Travel 2013

Any Course $300 with CPE for your Entire Department

 

Audit Software

Anti Fraud

Internal Audit Skills

Internal Audit Hot Topics

IT Audit

 

AuditNet is now a NASBA Approved CPE Sponsor

 

 


How to Build a Business Case for Data Analytics

by Sean Elrington

internalauditanalytics.com

 

 

Many companies require managers to prepare a Technology Business Case for any new software purchases. A persuasive business case for purchasing some desktop audit software usually includes these elements...

 

Click here for the article...


 


Growing Need for Internal Auditors to Determine Effectiveness of Technology Efforts, According to CCH

 

 Internal Audit Technology Survey Aims to Help Auditors Increase Technology Value

 

MINNEAPOLIS – Budgetary trends show companies are putting an increased focus on technology in the audit space, but internal auditors have room for improvement when it comes to determining how effectively they are using technology, according to the CCH TeamMate Internal Audit Technology survey.

The survey, conducted in September of this year, was completed by 585 internal auditors across the globe who use the TeamMate audit management system, offered by Wolters Kluwer’s ARC Logics business. The survey was developed to help internal auditors see how their peers are using technology, and consider ways they can use technology more effectively.

 

More than 35 percent of the survey respondents experienced an increase in their technology budgets this year. About 30 percent expect their technology budgets to increase over the next two years and more than half predict technology allocations will stay about the same. Less than 15 percent expect budgets to drop.

However, while roughly two-thirds of respondents say most of their staff has proficient technology skills, about 80 percent indicate their audit departments haven’t determined how effectively they are leveraging technology.

“There are a number of factors that can help auditors better determine the effectiveness of their technology initiatives, including ongoing training programs and the implementation of key performance measures,” said Mike Gowell, vice president and general manager, CCH TeamMate. “Technology can help ensure key business risks are being managed appropriately and can greatly enhance auditors’ productivity, but it requires ongoing assessments to reap those benefits.”

CCH TeamMate’s internal audit experts recommend a five-step approach in increasing technology value:

  1. Convey the Right “Tone at the Top” – Strong leadership and support from the chief audit executive (CAE) can be a key factor in improving technology value at an organization.
     
  2. Place a High Priority on Leveraging Technology to Boost Performance – Members of an internal audit department’s staff may be using technology tools, but beyond that, they need to also fully understand all of the applications available to them.
  3. Hire Technology Skills Selectively – Hiring outside talent with experience in data analytics and data mining can jump-start implementation of major technology initiatives.
  4. Train, Train, Train – It’s not only about mastering technical skills, but also retaining them.
  5. Measure What Really Matters – Have performance measures in place to determine how effectively you are leveraging technology.

More information about this approach is included with the full results of the CCH TeamMate Internal Audit Survey online.
About ARC Logics
ARC Logics is a provider of proven audit, risk and compliance software solutions, information and services to more than 2,000 clients in over 100 countries. ARC Logics combines both solution-specific and enterprise integration to help legal, compliance, risk, finance and audit departments within an organization rapidly address their unique risk management needs, while building a holistic, enterprise-wide program. The business’ prominent brands include Axentis and CCH TeamMate.
ARC Logics is part of Wolters Kluwer, a market-leading global information services company focused on professionals with annual revenues (2010) of €3.6 billion ($4.7 billion), approximately 19,000 employees worldwide and operations in over 40 countries across Europe, North America, Asia Pacific, and Latin America. Visit our website, YouTube or follow @Wolters_Kluwer on Twitter for more information about our market positions, customers, brands, and organization.


AuditNet® Community

Sponsor News!

 

Thanks to ACL, TeamMate and  ThomsonReuters for sponsoring the newsletter!


network

 

Audit Software Training without Travel No CPE Option

This new AuditSoftwareVideos training option is only available through AuditNet and AuditSoftware.net

 

Watch a Sample

ACL – How to Complete a Vendor to Employee Matching Test – Many to Many Join

Excel – How to Automatically Calculate a PivotTable Data Range Using the OFFSET() function

For a limited time if you sign up for either the ACL or Audit Software Training without Travel series you will have access to the videos


CAATT Tales

 

 

Welcome to CAATT Tales, a column focusing on computer assisted audit tools and techniques (CAATTs) to increase audit efficiency and effectiveness. Donald E Sparks, CIA, CISA, ARM and Vice President Industry Relations for Audimation Services, Inc. suggested a column titled Moving Forward with Data Analysis Q&A to provide a forum for readers to submit questions about how to best conduct internal auditing related data analysis activities. AuditNet® renamed the column to CAATT Tales and expanded the scope to include all uses of technology to enhance audit efficiency and effectiveness. Audimation Services Inc., a Houston TX based company is the sole U.S. distributor of IDEA, CaseWare™ Monitor and SmartExporter for SAP

Credit Balance Hide and Seek

BY DONALD E. SPARKS

Audimation Services, Inc.

 

A determined internal auditor and a simple data analysis technique uncover an insurance company’s fraud against its customers.

David Arnold, the internal auditor for Amity Insurance Co., began his workweek with a visit to one of the company’s field offices, where commercial cus­tomers interact with employees and pay their premiums. The audit in­cluded a surprise after-hours inspec­tion to make sure doors and cabinets were locked, negotiable instruments were not lying around, and live checks were stored securely.

For the rest of the story click here!

 

For previous CAAT Tales click here!


 

AUDITNET® SURVEYS

 

Study Shows Auditors Slow to Adopt Hi-Tech Fraud Detection Strategies
Plus: Top 10 reasons why

Over 400 Auditors Respond to the AuditNet 2012 Survey on Fraud Detection Techniques Using Technology

The professional standards relating to the auditor’s responsibility for detecting and preventing fraud changed in 2009 when the Institute of Internal Auditors (IIA) updated the International Professional Practices Framework (IPPF). Auditors must now consider fraud risks and red flags as part of planning audits. In conjunction with these changes the IIA released Practice Guides for Internal Auditing and Fraud, Fraud Prevention and Detection in an Automated World (GTAG 13) and Data Analysis Technologies (GTAG 16).  ISACA also issued a White Paper titled Data Analytics – A Practical Approach.

 

According to GTAG 13:

Data analysis technology enables auditors and other fraud examiners to analyze transactional data to obtain insights into the operating effectiveness of internal controls and to identify indicators of fraud risk or actual fraudulent activities.

 

Most audit professionals and fraud examiners are aware of the ACFE Report to the Nation survey covering how frauds are detected, who commits fraud and the types of frauds perpetrated.  The ACFE survey found that over 40% of reported frauds are uncovered by tips. The report does not however ask questions relating to the use of technology in uncovering frauds. AuditNet is conducting a survey to answer the question and determine fraud detection techniques using technology.

 

Here is a link to an article in CPA Trendlines with the preliminary results. The survey closed and we are in the process of finalizing the survey results and support.

 

We are also developing surveys for the following topics. If you have an area that you feel would add value please share it with us.

 

The State of Audit Management Software Technology Usage

Risk Control and Audit of Mobile Devices

Flowchart Best Practices for Internal Audit

Best Practices in Acquiring and Importing Data

Audit Software Capabilities Survey

 

AuditNet Past Surveys

   

AuditNet® conducts periodic user surveys based on relevant or hot topics as well as areas suggested by our users. Click here for a list of the surveys that we have completed.

 

If you have an idea for a survey or would like us to conduct a survey for a particular subject send us an email. We are particularly interested in surveys that explore the use of technology for auditors.


Jim Kaplan, founder of AuditNet will be speaking at the following events in 2013

ACL User Conference April 2013

Williamsburg Fraud Conference April 2013

 

Need CPE? Sign Up now for the this month's Webinars by clicking here!

 

Remember! Clicking on sponsored ads and visiting their sites helps support AuditNet®. 


AuditNet® Communication Skills

 

Now Available on Kindle

Latest Edition Job Loss

 

 

Product DetailsProduct Details

 

Words That Comfort

 

Follow AuditNet on

Twitter.com


Update on AuditNet® Networking and Information

 

AuditNet® has established new networking opportunities for auditors through social networking sites such as LinkedIn, Google Groups, Yahoo Groups and more. LinkedIn's Professional Audit Information Network has over 4,800 members. What a great tool which includes group discussions, news and the opportunity to network with other professionals around the world!  

 

AuditNet continues building the library of resources with new audit programs, monographs, fraud analytics into audit work programs and more to provide auditors with a new tools for compliance with the standards. We are working on a  monograph on Building Fraud Detection into the Audit Process.

 

New audit programs are also now available.  Subscribers may access these documents now.

 

AuditNet articles will now include the ability to provide feedback and comments. We are looking at a way to rate audit programs as well. Stay tuned!

 

AuditNet is working on several fronts to enhance the audit programs and incorporate audit content into other software applications. One of these applications will begin offering Software as a Service (SaaS) solutions to requirement management. AuditNet has always supported new solutions and has encouraged start ups and other software vendors to enhance their products for both the mainstream as well as the small internal audit functions. We will continue to seek out opportunities that offer the global audit community new ways of doing business.


Benefits of Registration

AuditNet continues to forge new relationships with software vendors, professional associations, and audit and accounting sites to provide auditors with access to audit work programs.

 

Group Access to AuditNet Audit Programs.

 

Join the other groups such as ACL, CCH TeamMate, Protiviti KnowledgeLeader and the Association of Healthcare Internal Auditors that have access to all of the AuditNet audit programs.

 

If you want your group or professional association (IIA, ISACA, ACFE, ACUA, ACUIA etc) to have transparent access to AuditNet audit programs and other content as a benefit of membership contact your professional association official or group leader and ask them to pursue this with AuditNet.

 

Fraud News Feed

 

Go to the AuditNet Fraud Resource Center and check out the fraud news feed to keep up to date with media reported fraud happenings. 

 

The best way to find all the resources on the site is by going to the AuditNet Library or use the site search.


Coming Attractions!

 

AuditNet Inventory Clearinghouse of Standard Audit Condition Statements (SACS). 

 

AuditNet continues work on building a library of standard audit conditions (comments/observations/findings). Similar to the audit programs inventory this will create a clearinghouse of well written findings to jump start development of audit findings. You will still need to add the other elements such as criteria, cause and effect however we have observed over the years that many conditions repeat themselves.

Why recreate the wheel if someone has already crafted a well written condition statement?

 

AuditNet® is working on an audit program development service. If we don’t have an audit program in our inventory that meets your needs we will develop a program if you can provide the type of program you need, along with the objectives, purpose and scope. This will be a fee based service. Stay tuned for the roll out of this innovative new program.

 

We are drafting surveys for cloud computing, mobile devices and flowchart software and the impact of technology on internal audit then and now. We will be launching these surveys later this year.

 

AuditNet continues working with professional associations to provide access to the audit program inventory. If your professional association is not providing their members with access to AuditNet® then they are missing a great opportunity. Let your association know that access to AuditNet® would be a value added benefit they could provide to members!

 

The AuditNet Monograph Series  provides useful guides for all levels of auditors from juniors right up to audit directors. We are currently working on new guides covering audit basics as well as emerging technologies. These guides will be available to registered subscribers. If you are interested in developing a monograph on a contract basis, contact us.

 

AuditNet® continues adding new specialized resources for auditors. Watch the newsletter and keep checking the Library page for updates and new resources.

 

AuditNet® Data Analysis Corner

 

 

Pleier Corporation has partnered with AuditNet® and FraudAware® to publish “Data Mining for Payroll Fraud” webinar on CD-ROM click for details.  This is the first publication of a “Data Mining for Fraud Series”. 

 

A very popular joint AuditNet(R) and Fraudaware(R) Webinar of 1 hour and 42 minutes of video recorded live and distributed on CD-ROM.

 

Here are some of the benefits of this type data mining and analysis:

- Reduce control weaknesses before fraud escalates
- Determine cost impact of fraud
- Analyze complete data sets for fraud
- Efficient and cost-effective ability to automate for continuous monitoring/auditing
- Uncover specific fraud scenarios and schemes

By attending you will receive expert guidance on:

- Costliest forms of internal and external payroll fraud
- Who commits payroll fraud
- Gathering accurate data for effective payroll fraud data analysis
- Powerful and user-friendly audit automation tests and techniques
- Using data analytics results to improve payroll fraud preventative controls
- Using meta-data and cross-referencing to produce better results
- Tools, Techniques and Tips of Data Mining Success
- Much MORE


Finding the Best Resources for Auditors This Month

If there is one area that we have excelled at it is finding the best audit resources for auditors.

 

AuditNet has a large number of audit programs, checklists, matrices and more on audit related topics. We also are working with other subject matter experts to develop audit programs, articles, guides, training and more on all things relating to audit, fraud, compliance and more.

 

Here are some resources and articles for this month's theme of Forensics and Auditors (the following are provided for information only and should not be considered a recommendation or endorsement of the vendor or services provided):

 

The Benefits of a Forensic Audit

A forensic audit will investigate and identify fraudulent behavior but can also serve as a springboard to establishing control mechanisms that help mitigate the risk of potential fraud. Forensic accounting can also:

  • Identify areas of waste to improve operational efficiencies.

  • Calculate economic losses associated with contract disputes, product liability claims, non-compete agreements, and, patent and trademark infringement.

  • Help ensure regulatory compliance and assist with compliance audits.

  • Investigate and quantify professional negligence claims.

  • Improve executive and managerial transparency by identifying conflict-of-interest issues.

  • Identify employee fraud, identity theft, embezzlement, insider training, and security fraud.

  • Help settle monetary disputes between business partners, shareholders, and marital couples in addition to insurance claims.

The forensic audit begins in the planning stage where the objectives of the audit are identified. A series of tests are performed to gather evidence – or no evidence as the case may be – which is analyzed for potential fraud. Each step of the forensic audit is documented and gathered into a report for executives and shareholders. Its main components are whether fraud occurred and, if so, who committed it and what were the monetary losses.

 

Computer Forensics: A Valuable Audit Tool

Forensic Auditing

 

 

If are interested in the best methods of researching for audit topics or to have AuditNet present at your meeting or conference then just send us an email.

 


 
 

ACL News

ACL Delivers Audit and Compliance Management on the iPad®

First Native iPad App with Full Audit Management Capabilities Now Available

 

ACL, the company that is transforming audit and risk, announced today the expansion of its mobile audit and compliance management product offering with the launch of ACL™ Workpapers for the iPad®. ACL™ Workpapers for iOS, an extension of the ACL Workpapers cloud-based audit and compliance management system, is available for iPhone® and iPad® as a free download on the iTunes App Store™.

 

Click here for the rest of the story...


Training Institute

a Wholly Owned Division of AuditNet®

 

AuditNet® Launches Training without Travel No CPE Option

 

AuditNet®, an industry leader and trend setter for technology solutions for auditors launched the Training without Travel No CPE Program in July 2012. Auditors can join select Webinars at no cost and benefit from the training without receiving the materials, recording or CPE. We are offering this option as many audit department training budgets have suffered based on the weak economy. To receive offers for CPE and no CPE training make sure that you are registered with us.  You will receive our email for the vendor sponsored Webinars with CPE, the AuditNet® Training without Travel Webinars for anti-fraud, data analysis, audit software, IT audit and Audit Skills, and the select No CPE Option webinars.

 

Register here and opt in for the mailing list.


Training Institute

a Wholly Owned Division of AuditNet®

in conjunction with:

 

Anti-Fraud Webinars

March 2013 Travel without Training Anti-Fraud Webinar Opportunities......

  1. Using Data Analysis to Conduct Forensic Fraud Audits (DA-3) Feb. 6 - 2 CPE $99 for one person $300 for your entire department with CPE
  2. Essentials of a Highly Effective Employee Fraud Awareness Program (OF-2) Feb. 13 2 CPE $99 for one person $300 for your entire department with CPE
  3. Is Your Payroll Being Plundered (DA-1) Feb. 27 2 CPE $99 one person or $300 for your entire department with CPE

Sign Up for any 2 for Only $175 for one person or $500 for your entire department or all 3 for $225 for an individual or $750 for your entire department with CPE


If you missed any Webinars or would like to view recordings of our prior events visit our Webinar History Page


 

ACL and Audit Software Video JIT Training

 

 


 

 

Data Analytics for Auditors

 

Open Source Software for data mining with a Mac

by Mike Blakely

 

A number of open source software packages can be run on a Macintosh computer and are well suited for data mining and other audit support functions. This article will provide a brief overview of some of the major packages, describing the functionality of the package which can support commonly performed audit procedures.
 
First, some definitions or scope limitations. To be included in this article, the software package had to be open source, meaning that the source code for the package is freely available for download by anyone interested. Second, there had to be no license cost for obtaining and using the software. Third, the package had to be able to run on a Macintosh computer. And fourth, the package had to provide at least basic audit procedure capabilities. The term “data mining” is often loosely used, but for the purposes of this article, the meaning is that defined in Wikipedia...

 

Click here for the rest of the story...


Attribute Sampling Update
by Mike Blakely

Attribute sampling is widely used by auditors in tests of compliance. Generally, audit samples are used to test the adequacy of internal controls.  An audit sample results in a sample error rate which can then be used to estimate a range of probable errors in the population being tested.  This range is known as a confidence interval because the auditor has some degree of confidence that the overall error rate will be within this interval or range.  Based on whether or not the range is acceptable, the auditor may decide to perform other audit tests.

 

Click here for the rest of the story!

 

Previous Articles from Mike Blakely:

Give Your Stat Sample the Boot Part 1

Give Your Stat Sample the Boot Part 2


AuditNet® Exclusive

Online course - Fraud detection using analytics

This is a case study regarding a fictitious mail order company where an allegation of fraud has been received. A SAS 99 brainstorming session was held, and 11 critical expectations were developed during that brain storming session. This is a hands on course. All data and software needed are provided. The case study can generally be completed in less than four hours.

Objectives

Learn how to use and apply key analytic procedures to detect fraud.

Pre-requisites

Internet browser (Internet Explorer, FireFox, Opera, Chrome). Most tablets and mobile devices with Internet browsers should also work.

Cost None.

CPE Not available.

Length Course takes approximately four hours to complete.

Registration Not required, but must be completed if e-mail support is needed or quizzes are to be taken.

Getting started Click on course link , select the course "Fraud detection using analytics" click "Login as a guest".

Questions or additional info Mike.Blakley@ezrstats.com

Optional registration E-mail contact info to address above. You will receive an id and password within 24 hours. Registered participants can receive e-mail support, post on the forum and take quizzes.

 


AuditNet® Subscriber Benefits

 

Auditors have been visiting and supporting AuditNet® since 1994 when it was first launched. Over the years we have offered unique opportunities for auditors including the following:

 

Access to over 2,300 audit documents including templates, matrices, monographs and more
Monthly newsletter with articles and resources
Special offers on subscription renewals
Updates on industry and profession events and news

A sharing and audit program exchange that provides auditors an option to share programs in lieu of payment

Low or no cost CPE training without travel for detecting fraud, software training (ACL, IDEA, Excel for Auditors), IT and Internal Audit. Coming soon basic skills for auditors and more!

 

AuditNet® recently was approved to be a NASBA CPE Sponsor and in conjunction with that we are now pleased to offer a 10% Discount to Premium subscribers on all AuditNet® sponsored Webinars.



 

AuditNet® Free CAATTs Webinar Was a Success!

 

CAATs are tools specifically created to help Auditors – they are extremely useful and the benefits are well known, yet there are still many audit departments not using them.

 

Watch for future free Webinar events offering value added topics for your audit department and staff!

 

Click here for the link to the recording!


 

Interested in Writing for AuditNet?

Looking for a Few Good Writers

Writing audit reports are very challenging for most auditors. A great way to hone your writing skills is by moving outside the box! Consider writing an article for AuditNet based on your experiences as an auditors. We are always looking for practical how-to articles on all aspects of the audit process. If you are an IIA member this is also a great way to earn CAP points for your local chapter. Send your articles to editor@auditnet.org TODAY!

 

AuditNet Editorial Guidelines

Based on the number of articles being contributed to AuditNet we have developed editorial guidelines for future submissions.  If you are planning to write an article please review the guidelines before submission.  We appreciate receiving material from the global audit community in the interest of sharing knowledge. We are also in the process of guidelines for book reviews and other material submitted for inclusion on AuditNet.

 


Conference News

Internal Auditing and Fraud

AuditNet® Plans More e-Monographs on Fraud Topics

 

AuditNet® is moving forward with e-Monographs on fraud and other related topics that will be added to the subscriber accessible documents over the next 6 months. The planned documents will provide a foundation for a comprehensive fraud risk assessment in conjunction with internal audit requirements for detecting and preventing fraud. 

 

We have been adding at least 10 new resources each month to the subscriber material. Much of this is focused on fraud and forensics. Don't miss out on all the old and new material available to subscribers.

 

Additionally new monographs are in process for other areas of audit operations including Key Performance Indicators for Internal Audit,  Business and Transaction Cycles and Digital Audit Knowledge Resource Guide. If you would like to submit a proposal for a topic please send it to auditnet @ gmail.com

 


AuditNet® Fraud Auditing Corner

 

Fraud News

Need to keep up with fraud news and happenings? There are several options available. One is to subscribe to the free ACFE FraudInfo E-newsletter.

 

Another free resource is the Auditing & Fraud News. Service for research professionals. Constantly updated news and information about Business & Companies. Go to FraudNet and click on the link Click Here for Fraud News.

 

Anti-Fraud Library Launching Soon!

 

AuditNet and FraudAware are working on a new anti-fraud resource for professionals. The FRN or Fraud Resource Network will be a subscription based service and will consist of anti-fraud templates, articles, fraud policy samples, CPE Webinars and non CPE recordings,  guides and more. Following are some of the e-monographs we are planning:

 

  • Common Financial Fraud Schemes

  • Construction Industry Fraud

  • Detecting Financial Statement Fraud

  • Guide to Implementing Fraud Hotlines

  • Guide to Preventing and Detecting Fraud Using Data Mining

  • Guide to Anti-Fraud and Fraud Awareness Programs

  • Guide to Developing an Organizational Fraud Policy

  • Guide to Detecting and Preventing Worker's Compensation Fraud

  • Healthcare Fraud

  • P-Card Fraud

  • Payroll Fraud

  • Red Flags of Fraud

Share your anti-fraud resources for this new site and you will be provided with a Premium subscription to the Fraud Resource Network AND AuditNet®.


What's Coming?

The theme of this month's newsletter is Data Mining for Auditors and  you will find articles and links to resources focused on that subject. Next month's theme is Audit Software.  If you have an article or resource on the theme please send it along to the editor.

 

What's New at AuditNet®

 

The Latest Resources and Tools from AuditNet®

 

 

February 1, 2013 (Oakton, Virginia) New site is launching this month. We appreciate your patience as we work through the trials and tribulations of launching a site redesign. I think it is almost easier to start from scratch in building a site as opposed to transitioning an established site to a new design. We have been holding off on adding new programs but are ready to resume. We will have a new user manual for all of your visitors that will help you navigate the new site. Audit programs will no longer be listed in alpha order within the site on a single page but will be in a keyword searchable database. You can sort audit programs based on date added, title or rating. We will begin a project this year to update the audit programs so bear with us as we go through our vast database of content. Training without Travel will continue with or without CPE and we offer new opportunities for audit departments to train and provide CPE at a very low cost.

November 1, 2012 (Oakton, Virginia) Working on the new site launch with testing. We have temporarily suspended adding new template to the site but will make them available to subscribers on request. The task of updating all pages, checking broken links and other site maintenance is an onerous task but we are working hard to facilitate the change. Features of the new site will include easier navigation for visitors and subscribers, ability to provide feedback on templates. enhanced site statistics, search capability and more. Social media links will be included in the site as we launch new opportunities for auditors to connect. The 2013 training schedule is in planning mode and we are also updating the subscription and advertiser rate schedules. Subscribers will have the option to include CPE training classes for audit software and data analysis as well as internal audit basics and ethics.  Our Training without Travel will offer a no CPE option on all classes. The Fraud Audit Skills Training will move to our partner site at FraudResourceNet with subscription options for the popular White Collar Crime Fighter newsletter, article archive, fraud templates and documents in addition to the Webinars.

 

September 1, 2012 (Oakton, Virginia) AuditNet® has completed the site redesign and is currently planning the migration of files and data. We will offer special pricing for subscription, webinars and more as we launch the new design. We have another vendor sponsored webinar with CPE this month and continue to expand our no CPE option for the Training without Travel webinars. Watch for new subscriber benefits including a Data Analytics Script Library with ACL, IDEA, Open Source scripts to jump start integrating technology into your audit process!

 

August 1, 2012 (Oakton, Virginia) AuditNet® announces a subscription rate increase scheduled for January 1, 2013 along with new benefits for subscribers including CPE for Training without Travel. AuditNet® also is expanding the no CPE option for many of our webinars. This new training opportunity will allow auditors to sign up for our events at no cost. Only those who pay for the Webinar will receive the handout material, link to the recording and CPE.

 

July 1, 2012 (Oakton, Virginia) AuditNet® released the summary of the 2012 State of Technology Use by Auditors and found that there auditors still have much room for improvement. AuditNet® Training without Travel adds new Webinars focusing on skills for internal auditors. The new site is nearly complete and we will be releasing the design details and begin transferring the content.

 

Prior What's New at AuditNet!

 

Audit Work Programs Corner

Register Now!

Access to audit programs requires registration.  Free Trials have been suspended pending completion of the new site redesign. If you would like a trial subscription send your request to webmaster@auditnet.org

Subscriptions are open during the site redesign so sign up now! We add new programs each month. Basic level subscription rates increased to $50 a year on January 1, 2013. Auditors Sharing Audit Programs is still available. This innovative approach first offered by AuditNet still provides an in lieu of payment option  for those who cannot afford the price of a subscription. Templates are available on a 1 for 1 exchange for an original audit work program not currently in the inventory. If you unable to share audit programs then consider subscribing to the premium content which provides you with access 24/7/365.  Interested in a subscription in lieu of cash? (Offer only available for new programs submitted).

  1. Accounts Receivable (January 2013)
  2. Communication Matrix (January 2013)
  3. Lean Six Sigma Reference Tools (January 2013)
  4. Sales Incentive Compensation (January 2013)
  5. Travel and Entertainment (January 2013)

 

AuditNet® recognizes the above partners that provide their members and clients access to all the AuditNet audit programs. CCH TeamStores format. Access through the TeamStores support site. ACL Premium and Protiviti KnowledgeLeader members access through the respective members login.

 

E-Book for Subscribers to the Annual Audit Programs

 

AuditNet is building Analytic Enabled Audit Programs (AEP) which include steps for using data analysis software such as ACL. If you have a program that uses data analytics and would like to share we will add it to this new category.

  1. Electronic Fund Transfer Act (EFTA) (September 2012)
  2. Equal Credit Opportunity Act (ECOA) and Regulation (September 2012)
  3. Gramm-Leach-Bliley Act (GLBA) (September 2012)
  4. Fair Credit Reporting Act (FCRA) (September 2012)
  5. Homeowners Protection Act (HPA) (September 2012)
  6. Human Resources Scorecard (September 2012)
  7. Network Patch Management Testing Steps (September 2012)
  8. Real Estate Settlement Procedures Act (RESPA) (September 2012)
  9. Unfair, Deceptive, or Abusive Acts or Practices (UDAAP) (September 2012)
  10. Workpaper Documentation (September 2012)

 

Last Month's Additions

  1. Contingency Plan Template (August 2012)
  2. Dashboard Tool (August 2012)
  3. Feasibility Study Template (August 2012)
  4. Goodwill Testing Workbook (August 2012)
  5. Inventory Test Workbook (August 2012)
  6. Network Management Process Maturity Assessment Tool (August 2012)
  7. Project Implementation Plan Template (August 2012)
  8. Project Management Checklists (August 2012)
  9. Software Transition Plan Template (August 2012)
  10. System Access Testing Workbook (August 2012)

Ask the Auditor

Each month I select one question submitted to Ask the Auditor or the LinkedIn Professional Audit Information Network and provide an answer using the same digital tools and techniques that I recommend to all auditors. 

 

SOX Key Control Certifications

Q; Can anyone provide advice regarding internal audits of cloud computing management, particularly governance issues, for non-IT auditors?


A:  There are a number of resources such as Auditing Cloud Computing: A Security and Privacy Guide by Ben Halpert from Wiley. The author explains what cloud computing is and the security and risk issues that auditors need to be aware of. A Cloud Computing Audit Checklist is included as an appendix. Richard Cascarino's Auditor's Guide to IT Auditing (2nd ed) includes several chapters on Cloud Computing. We recently reviewed Richard's book. ISACA has books and other material available to their members as well as some articles:

There are also a number of documents available to AuditNet Premium subscribers on this topic including:

  • Cloud Computing Risks and Benefits
  • Cloud Computing - Security Considerations

I hope that these resources will provide some guidance!

 

If you want to chime in on this then please do.

 


Release the Writer in You!

Looking to Earn Some Extra $$?

AuditNet is interested in hiring experienced auditors to create content for our subscribers.  If you are interested in writing audit programs, ICQs, questionnaires, or control matrices on a work for hire basis please contact me. If you may know of anyone who would be interested in this as well please pass along our contact information.


 

Professional Networking Discussion Forums and More from AuditNet®

 

AuditNet.org is now on Facebook

Twitter too! @auditnet

Join The LinkedIn Professional  Audit Information Networking Group

 

Sign up for the free:

AuditNet Newsletter (monthly)

Audit programs discussion list

General audit discussion list

SOx discussion list


Training Institute

a Wholly Owned Division of AuditNet®

in conjunction with:

 

AuditNet and Richard Cascarino & Associates developed training for IDEA Software and IT Audit. This training for May and June 2012 is as follows (previously recorded courses are available as well):

 

IDEA Software Training

Importing Data from Reports using the IDEA Report Reader June 12, 2012

 

IT Audit Training

Auditing Contingency Planning June 26, 2012


AuditNet® Vendor News

Check here for the latest news from our AuditNet®

 


AuditNet® Featured Books and Reviews

 

FEATURED BOOK REVIEWS

   

MORE BOOKS FOR THIS MONTH'S THEME

 

Visit Our Bookstore Now!

 

The AuditNet® Audit Bookstore Corner

Looking for books on auditing related topics? We suggest using the AuditNet® bookstore. The bookstore focuses on Internal Audit but includes other related subjects as well. AuditNet® uses Amazon to power the bookstore so each purchase you make through this link helps support AuditNet®.


As a reminder, Pleier Corporation offers 10 % discounts to AuditNet readers at www.pleier.com.  To take this discount order online and enter the word AUDITNET in the coupon field at checkout.

Click here for opportunities to share your knowledge and earn royalties

Check out Training on CD

A Practitioner's Guide to Corruption Auditing

Exceeding Expectations for Internal Auditors


 

         

AuditNet LLC is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.learningmarket.org.