Jim Kaplan's
audnet.gif (4937 bytes)
 

newslogo.gif (7197 bytes)
ASK (Auditors Sharing Knowledge) for Progress

 

April 2004

Prior AuditNet-L Newsletters

The AuditNet-l Newsletter is sponsored by: PricewaterhouseCoopers TeamMate

"PricewaterhouseCoopers TeamMate is a database-driven audit management system that streamlines the audit process by providing integrated tools for documentation, report generation and file sharing."

 

 

Audit Programs
AuditNet Resource Links
AuditNet Virtual Library
AuditNet Newsletter
Ask the Auditor
Audit Jobs
Partner Discounts

Search the Site
Our Sponsors
Advertise
Sign the Guestbook
AuditNet Home Page

 al_logo.gif (1206 bytes)




logo.jpg (1604 bytes)

 Accounting Procedures for Internal Control
Accounting Procedures for Internal Control
CLICK HERE TO ORDER

 

 
Corporate Governance Certification
New Program Offering from Bisk Education

Earn your Tulane University Law School Certificate 100% Online. Complete the program in a week: Audit Committee and reporting, legal and board issues and more. Learn from leading experts about all relevant regulations and laws including Sarbanes Oxley. Use the Program as a resource for a FULL YEAR.

To get more information click here.


AuditNet® Community

Sponsor News!

The AuditNet® community has grown by leaps and bounds over the past ten years thanks to your continued support. Yes it is hard to imagine but it has been a decade since this community was created!  Support AuditNet® by supporting our sponsors. Without sponsor and affiliate advertising and contributions from the AuditNet® community everyone would have to pay for use of this site.

logo.jpg (1604 bytes)

This month check out Pentana, a vendor that produces software for audit professionals, including integrated risk and audit management, staff scheduling and information security questionnaires. Remember: visiting sponsors helps support AuditNet®.


E-commerce Security Best Practice Guidelines

 

These guidelines describe a number of best practices related to E-commerce security. In each case, the risk of not implementing the practice is identified.

The guidelines were 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. For a limited time KnowledgeLeader memberships are available for the reduced rate of $500 per year. Tell them you heard about it from AuditNet.org.

Click here for the best practice guidelines.


Controls Effectiveness Survey

A new survey about controls effectiveness has been launched online to find out more about what information auditors consider relevant to assessing controls effectiveness. When the results are available, probably next month via AuditNet, they could help open the way to more efficient compliance with relevant regulations - especially if a large number of auditors have participated and so given the survey extra credibility.

The questionnaire presents 20 items of information and asks you if you think each is relevant to evaluating effectiveness of internal controls over financial reporting.

Please help by taking the survey by clicking here!


Application Audits: A Primer for Internal Auditing Professionals

By Michael Cooke, Practice Leader at ACL Services

A maelstrom of market, competitive and regulatory forces, shapes today’s auditing landscape. The auditing style of yesterday, with its focus on risk matrices and samples, is quickly becoming outdated as technology rapidly changes the complexion of the auditing environment. Most notably, the pervasiveness of technology has brought with it speed and directness to the auditing world.  The fact that audits can now be done on a more continuous and real-time basis has important consequences -- technology has become both an enabler of audits and a key operational business factor that must itself be audited.

For the rest of the story click here!


AuditNet Job Listings (& more)

Looking for an audit job? Go to the AuditNet® Audit Jobs section for the latest job opportunities. 24 hours a day, 7 days a week you have the ability to not only look at available jobs, but you can also post your resume, apply for open jobs, research companies and obtain career advice. If you are in the market for a new job, make AuditNet® your first stop to check out what's available.

This is just another benefit of using AuditNet® as your one stop shop for all your audit and career resources.

Click here for more jobs!


Looking for Auditors?

If your company has any audit job vacancies that you are looking to fill, have your HR people contact AuditNet® to post the job and search for candidates. Using the jobs section helps support AuditNet® as well! For more information click here.


AuditNet® Fraud Auditing Corner
Interviewing: Achieving Rapport, Part One 

By Don Rabon

By identifying a subject's dominant mode of expression - visual, auditory, or sensation - (and when he or she deviates from it) you can mirror the subject and begin to achieve rapport.

This article is from The White Paper, the professional magazine of the Association of Certified Fraud Examiners and is a regular feature of AuditNet under a new cooperative
relationships and partnership with professional associations in the
interest of sharing resources for the benefit of the global AuditNet®
community. .

For the rest of the article from the latest ACFE White Paper click here.


AuditNet® Resource List Updates

Click here for the new links!

Please let us know of links that are not working!


Free Tools for Auditors

Sarbanes-Oxley Software

To address the mounting debate about the requirement to document the
internal controls in order to comply with SOX, a new software is now
available free of charge.

Click here for details.

An Auditor's Travel Guide

by Jean-Louis Vergaert

"Following a high level interest of the audit community in the cultural aspect of international auditing, one of our fellow auditors, Jean-Louis Vergaert, has written a comprehensive book: An Auditor's Travel Guide. This book includes many practical, no-nonsense travel tips, and a personal review of 37 countries, with more to come. It is independent, unbiased, and free of any sponsorship and advertising. It is hoped that this book, available free of charge, will give useful tips and advice to the ever growing traveling auditors community, and be of entertaining reading to all of us."


The only periodical of its kind bringing useful and timely advice and insights into the prevention detection, and investigation of all forms of computer and Internet crime. The April 2004 issue includes the following articles: how to build a cyber-security policy with teeth, how to gather e-mail evidence when the evidence is gone and more. For more information visit www.cybercrimefighter.net


Audit Recommendation Self-Assessment Questionnaire

by Kastuv Ray

Negotiation and persuasion skills are important to the effectiveness of an internal auditor. These skills are tested when the auditor holds an exit meeting with the client/auditee to discuss the findings/recommendations.

Click here for the rest of the story!


AuditNet® Conference & Training News

Want to announce your professional association conference to the global audit community? Send us conference name, date and URL details or your

The IIA's Information Technology Conference - For Today's Auditor
April 19–21, 2004 Orlando, Florida

2004 ACFE Fraud Conferences and Training

2004 IIA Conferences and Training


FIRST AUDIT AND ASSURANCE SOFTWARE EXPO MATERIALS AVAILABLE ONLINE FOR FREE

On March 11, 2004, The Institute of Internal Auditors (The IIA) North Jersey Chapter hosted a vendor expo: Making Sense of The Audit and Assurance Market In a Sarb-Ox Environment. They created a Web site with all the material from the expo.

For the press release click here.



AuditNet® Vendor News

Check here for the latest news from our AuditNet® sponsors!


AuditNet® Statistics

For those who like to wade through the details on how popular AuditNet® is, click here for the current stats.

 

The Auditor's Guide to Internet Resources, 2nd Edition!

Order it Now!


Auditor on the Net!

Finding Educational Tools on the Internet for Auditors

Many auditors prepare PowerPoint presentations to train staff or educate members of their organization about various programs or risks. Fortunately those of us who are Internet savvy can easily find these presentations to modify and use for our own organization. It is very easy to download and then modify a PowerPoint presentation. I have found presentations on internal controls, fraud awareness, accounts receivables, auditor's role and more. Start by identifying your search objective such as fraud awareness. Next open up your favorite search engine (mine is Google) and enter your query terms and then, most importantly, add +ppt. By entering +ppt to your query, Google will then search for filenames posted with that file extension. If you find something that you feel would be a good starting point for internal use then make sure you contact the person or organization that developed the presentation and ask their permission to modify and use it for internal education. 

My philosophy is no sense reinventing the audit wheel when it has been done before!

If you have a tip on how you are using the Internet or software applications for auditing send them to editor@auditnet.org Watch for more Internet boot camp tips from the auditing Internet guru!


Audit Work Programs Corner

Auditors Sharing Audit Programs and Working Papers

The following audit programs, ICQs, checklist or working papers were added this month. They are in  format unless noted otherwise. Some may only be available in exchange for an audit work program contribution. They are also available in  alternate format by email in exchange for a contribution of an audit work program, ICQ or checklist. Beginning in August 2003 all new programs contributed will include the date the program was added to the inventory (mm/yy). This was at the suggestion of an AuditNet® user.

  1. Administration Department Audit Program (April 04)

  2. Audit Report Color Rating System (April 04)

  3. Background Screening ICQ (April 04)

  4. Business Units ICQ (April 04)

  5. Claimant Eligibility ICQ (April 04)

  6. Database Audit Checklist (April 04) (Contribution Required)

  7. Data Warehouse Data Reliability Process Review (April 04) (Contribution Required)

  8. Expenditure Cycle Risks and Controls Matrix (Manufacturing concern/SAP environment/SOX) (April 04) (Contribution Required)

  9. Group Medical Insurance Policy-Claims and Premium (April 04)

  10. Haz Mat Audit Checklist (April 04)

  11. IT Audit Process Description (April 04)

  12. IT General Controls (April 04)

  13. Microsoft SMS Audit Checklist (April 04) (Contribution Required)

  14. Payroll Audit Program (April 04)

  15. Process Walk Through Template (April 04)

  16. Returned Checks Audit Program (April 04)

  17. Small Sample Size Excel Workbook (April 04)

  18. Surface Water Management (SWM) Compliance (April 04)

  19. System Administration and Operations (April 04)

Audit Documents in the Queue!

The following audit documents will be posted next month. Interested in them now? Send an audit work program, ICQ, checklist or other audit template and receive them via e-mail. Your contribution must include your name and email address. 

  1. AS 400 ICQ (May 04)

  2. Bank Security Procedures (By request - requires contribution) (May 04)

  3. Branch ICQ (May 04)

  4. Circuit Fiber Procurement ICQ (May 04)

  5. Human Resources (May 04)

  6. Finance & Administration (May 04)

  7. Insider Trading (May 04) (By request - requires contribution) (May 04)

  8. IT Security Control Objectives Audit Program (May 04)

  9. Kiting Audit Program (May 04)

  10. Know Your Customers Audit Policies and Procedures (May 04)

  11. Location Audit Program (May 04)

  12. Microsoft Server SQL Audit Work Pack (Contribution Required) (May 04)

  13. PeopleSoft Security Work Program (By request - requires contribution) (May 04)

  14. Reinsurance Ceded (Individual) Audit Program (Contribution Required) (May 04)

  15. Reinsurance Assumed (Individual) Audit Program (Contribution Required) (May 04)

  16. UNUM Reinsurance Treaty File Audit Program (Contribution Required) (May 04)

  17. Reinsurance Assumed Audit Program (By request - requires contribution) (May 04)

  18. Revenue Cycle Control Matrix (May 04)

  19. Sales Office Operations Audit (May 04)

  20. SAP Reports Request (May 04)

  21. Store Visit Non Conformity Report (May 04)

  22. User Access Controls Work Program (SOX) (May 04)


AuditNet® What's New This Month?

AuditNet begins providing more fraud related information including new section on Whistleblowing resources for auditors and articles from the ACFE. There is also a section for data warehousing & data mining for auditors. This month I reviewed a new CAATT product called ActiveData for Excel, a must have application for all auditors! Jean-Louis Vergaert shared his new publication called An Auditor's Travel Guide. Bisk Education launches a new S-OX certification program for auditors. There are many new audit programs in the queue for the AuditNet® community. All this and more! The best way to find all the resources on the site is by going to the Virtual Library or use the site search.


AuditNet® CAATT Corner

ActiveData for Excel Officially Launched

Fairfield, New Jersey and Ottawa, Canada - March 11, 2004  InformationActive Inc. announced today the release of its pioneering new data analysis and manipulation tool, ActiveData for Excel, at the Institute of Internal Auditors (IIA) Software Expo taking place in Fairfield, New Jersey.

Click here for the press release.

AuditNet® Product Review

The new CAATT in town: ActiveData for Excel

Are there features that you wish were included in Excel that would help you in your audits? Well analyzing your customer or client information just got a whole lot easier!

Click here to read the product review.

"Searching for Fraud - Five
Tests for SAS 99 Compliance"

by Carolyn Newman ASI

Find out how to use IDEA to search through electronic data files for evidence of fraudulent or unusual transactions during an audit.

For the rest of the story click here.


AuditNet® Software Compliance Audit Corner

The Risks of Old PCs

Article provided by Rob Harmer Consulting Services

“It’s 2004 and Year 2000 is about to hit us again!”
First reactions on reading the headline above will make you think we had “lost the plot, totally”. Your reaction is likely to be “OH, NO”, not another “the sky is falling” message, we had that detail all through the years 1997, 1998, and 1999 which is now 4 to 5 years ago! Before you turn off, please read on as there are issues that CEOs, Managers, Directors need to be made aware of to reduce their personal risk.

For the rest of the story click here.


Your Secret Weapon in the War on Fraud

The April 2004 issue of this fraud newsletter features articles on how to catch fraudsters in the lies they tell, how to recover stolen assets before it's too late and more. AuditNet® users qualify for special rates on this publication. For more information click here


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®.

This Month's Featured Application
 ActiveData for Excel

*****************

Book Review

Fraud Investigation Using I.D.E.A.

By C. Stephen Turnbull
Reviewed by Jim Kaplan

Do you suspect fraud in your organization? Despite what industry or sector of the economy you work in, don’t kid yourself into believing it doesn’t exist or can’t happen. But why do we need another book on investigating fraud?

To find out why click here!


FREE! The Auditor's Guide to Internet Resources 2nd Edition

Interested in a free copy of The Auditor's Guide to Internet Resources, 2nd Edition? Write an article for the next newsletter on how you are integrating the Internet in auditing. If your article is selected, I will send you either the book or CD. Send your article to editor@auditnet.org 


AuditNet® Partner Discounts

Check out all the software vendors that offer discounts to the AuditNet® community.

AuditNet® It pays to be a member!

For information on partner discounts click here.


Preview of Coming Attractions!WorldLingo - Translation, Localization, Globalization

AuditNet® has selected WorldLingo software to offer translations of the Web site into languages of AuditNet® visitors. The Instant Web Site Translator, a turnkey Machine Translation solution will give AuditNet® the ability to provide auditors with speedy multilingual translations in seconds. One simple click will allow a non-English speaking visitor to view the AuditNet® site in their own language. Another example of how we are making AuditNet® the universal tool for the global audit community.

AuditNet will begin by offering translations from English to Spanish. Other languages will be added based on demand.

The AuditNet Monograph Series  provides useful guides for all levels of auditors from juniors right up to audit directors. New guides are under development for International Auditing: Cultural Considerations, and Internet Search Skills for Auditors. We are also working on creating a monograph for Evaluating Internal Controls in Government. If you are interested in developing a monograph on a contract basis, send an email to editor@auditnet.org

Watch for new articles from contributors.   We have some new publications in the queue for review including Auditing the Human Resources Function and Payables Test Set for IDEA, so watch the newsletter. Have an idea for a column? Send it to editor@auditnet.org

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


AuditNet® Feedback

I am an internal auditor with an Australian funded program in Papua New Guinea. I find this site very informative and encouraging. I will contribute where necessary. I sure would like to know other auditors comments

I stumbled across your website while searching for a particular initiative from a placement services perspective. I'm very pleased to have found this link and the information regarding SOX available. Thanks

This is a great web site. I often visit this web site when I start an audit. Recently, a alumni sorority ask me to do an audit of its book. I visited this web site and find a audit program for college fraternity. I can use this program with some minor changes. Thanks

Fascinating site. I haven't had time to explore all the areas yet.  I really need to do my homework. I'll be back. i know this site will be useful when I graduate next year with a degree in accounting.

For more comments click here!


q        

Copyright © Jim Kaplan
AuditNet® is a registered trademark of Jim Kaplan

Copyright and Disclaimer

All rights reserved. No part of this Website may be reproduced in any form, by copying from the Internet, photostat, microfilm, xerography, or any other means, or incorporated into any information retrieval system, electronic or mechanical, without the written permission of the copyright owner.

Comments



Revised: September 09, 2009

Address of this Page is http://www.auditnet.org/