Jim Kaplan's
audnet.gif (4937 bytes)

AuditNet Resource List
Audit Programs
AuditNet Virtual Library

AuditNet Newsletter
Ask the Auditor
AuditNet Mailing Lists
Audit Jobs
Travel

Career Links
Partner Discounts

Search
Sign Guestbook

AuditNet Sponsors

Advertising Opportunities
About AuditNet
About Jim Kaplan
AuditNet Seminars
AuditNet Home Page

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

August 1, 2002

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


Get the book!

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

The Auditor's Guide to Internet Resources, 2nd Edition is the only book on the Internet written expressly for internal auditors. Expanded and updated to include the latest Internet trends and resources, the book provides all the Internet competency skills auditors need to become digitally literate. Order your copy now!  Call 877-867-4947 (Toll free in U.S. and Canada) or FAX 770-442-9742 or email iiapubs@pbd.com  Use Order Number KPR320 and receive the IIA member price. It pays to use AuditNet! 

Available on CD-ROM!


AuditNet New Advertiser!

AuditNet welcomes a new advertiser, SGP International, the software developer of DataCheck, a data integrity assurance tool. Please visit their site and see how DataCheck can be used to quickly and efficient review and compare records. 

 

Without the support of these sponsors and advertisers AuditNet would have to look at alternative funding including access fees.  Please show your support by visiting the sponsor sites, evaluating and using their services.

al_logo.gif (1206 bytes)

AAsmall banner.gif (2891 bytes)

 

Software Compliance Audit Corner 

AAsmall banner.gif (2891 bytes)

Audit Compliance With Software License Agreements

AuditNet welcomes an article or audit tool each month from Andersen's KnowledgeSpace. KnowledgeSpace is a subscription-based web site that provides, tools, resources and best practices to help internal auditors save time, manage risk, and add value. For more information go to www.knowledgespace.com 

The latest contribution is an article on auditing compliance with software license agreements. Compliance with software licensing agreements may not be one of those topics that companies are overly concerned about. But in the current economic environment, perhaps they should be. Software vendors, squeezed for new revenues, have stepped up their audits to ensure that companies are not using unlicensed software.

Click on the or symbol for the complete article generously shared by Andersen's KnowledgeSpace® Internal Audit and Risk Management Community. 


AuditNet Develops Sector-Oriented Web Pages

We are always looking to expand the database of available resources for internal auditors. We added sections for auditors in public schools, banking, construction, higher education, hospitality and healthcare. Please visit them and if you have suggestions, additions or comments please share them with us by sending an email to editor@auditnet.org. We are always looking for coordinators for specific areas so if you are interested in participating in Auditors Sharing Knowledge for Progress, let us know.

Check out the details and links available from the AuditNet Library page at www.auditnet.org/auditnet_virtual_library.htm or check out the following pages:

Public School Auditing * Banking and Financial Institutions Auditing * Church/Religious Organizations * Construction Auditing * HealthCare Auditing  * Higher Education Auditing  * Hospitality Industry Auditing

AuditNet also added a new section devoted to auditors operating in an SAP environment. Thanks to Philip Moulton for suggesting this resource and offering his expertise as an SAP auditor. The section includes links to ERP and SAP information, audit programs, guides, best practices, security and more. AuditNet also established an e-mail discussion forum for this area! 


Using Microsoft Access for Digital Analysis and Interrogation

by Mark J. Nigrini, Ph.D.

Every auditor has Microsoft Access on their desktop but how many have considered using this bundled software for digital analysis and interrogation? Watch for a review of Mark Nigrini's, the author of Digital Analysis Using Benford's Law, latest book. 

idealogo.jpg (59139 bytes)

CAATTs Corner

SOFTWARE REVIEW

DataCheck: the New Kid on the Block:

The use of computer assisted audit tools and techniques or CAATTs is now commonplace in many internal audit offices. Where several years ago the use of CAATTs was optional, the increase in digital data storage within organizations has caused audit shops, large and small, to look to these methodologies for data extraction, audit examination and reconciliation. For the full review of DataCheck click here.


Monographs Under Development
* * * * * * * * * * * * * * * * * * * * * * *

I am planning an AuditNet Monograph Series of audit and Internet related topics. The purpose of the monographs will be to provide the global audit community with productivity related guides on audit topics. The first two installments of the series focus on flowcharting for auditors and documentation techniques for spreadsheets. A monograph is in the works for Internet search techniques.

If you are interested in contracting to write a monograph on an audit related topic please send an email to editor@auditnet.org


Book Reviews

2002 Miller Audit Procedures

The documentation for some types of audits are standard, therefore it makes sense that there should be facilitation tools for these types of projects. If you perform financial audits, Audit Procedures from the 2002 Miller series published by Aspen Law & Business is just that tool. 

The book provides financial auditors with a cost effective approach for auditing nonpublic commercial entities. The practice aids on CD-ROM make it easy to integrate the audit work programs, checklist, questionnaires and other documentation into an engagement. Internal auditors that perform financial audits will welcome the standardized documentation in Rich Text and Excel formats that can be modified as needed. From my perspective as an internal auditor this is a desktop reference that all audit shops should have in their library of professional publications. There are additional options available that will benefit auditors including a self-study CPE course and the opportunity to create a paperless audit workflow through integration with ePaceENGAGEMENT.

Why spend time reinventing the wheel when you can purchase a low cost comprehensive solution for financial audit projects?

For more information on this and other products available from Aspen Law and Business go to www.aspenpublishers.com


The Audit Process Step-by-Step

AuditNet includes a section for new (and seasoned) auditors detailing the audit process using a step-by-step approach. The section is under construction and includes templates, sample documents, flowcharts and links to other resources. I remember (vaguely) what it was like when I started out in the audit profession. I would have readily embraced an online resource that guided me into new and unfamiliar territories. Unfortunately the Internet was not an option then so I had to turn to peers, books, and a lot of internal and external training.  The success of these pages will rely on the philosophy of Auditors Sharing Knowledge (ASK) for Progress and grow as more seasoned auditors contribute and find value in educating others in their own best and continuing practices!

Go the Virtual Library page for the beginnings of this  new resource. 


Fraud Corner

Newsletter focusing on White Collar Crime

Pick up a paper today and chances are there is an article on corporate fraud. White-Collar Crime Fighter is a newsletter focusing on issues of fraud in the corporate environment.  

White-Collar Crime Fighter www.wccfighter.com the only source of exclusive, authoritative "how-to" information for financial crime fighters. Highlights from the August 2002 issue include (insert titles) and more.
 
AuditNet users get a discounted subscription rate.
This is a great publication and well worth the annual subscription rate. I find at least one practical article from each issue that helps me focus on fraud issues within my organization! 

New Opportunities for  Vendor and Consultant Listings in AuditNet

Vendors of audit related goods and services now have an opportunity for inclusion in the list of audit resource links. This new fee-based service provides an opportunity for consultants and vendors to purchase a listing for the most widely distributed list of audit resources on the Internet. Paid listings will include a $ designation to distinguish them from sites that include free resources for auditors. For more information send an email to editor@auditnet.org


Looking for a few good men (or women) Audit Candidates?

Consider using the AuditNet Audit Jobs area. The page provides exposure to over 17,000 audit professionals every month from all over the world. The Jobs page receives between 3000-4000 hits per month. The cost is low. Tell your HR department about using this option when you are looking for audit candidates. Go to the AuditNet home page at www.auditnet.org and click on Audit Jobs. Click on Post Jobs for posting information.


Heard on the Street 

The Sarbanes-Oxley Act of 2002 establishes new rules for the accounting profession and corporate executives in the U.S. including an accounting oversight board, auditor independence and senior management accountability. Read CCH's overview of the new law.  

IBM To Acquire PwC Consulting - Combining Business Insight and Technology to Help Clients Drive Greater Business Returns. For more information click here.

New Subsidiary of Robert Half International Becomes One of Nation's Leading Independent Business Risk Consulting and Internal Audit Firms. For more information go to www.protiviticonsulting.com.  


 

Audit Work Programs Corner

Auditors Sharing Audit Programs and Workpapers

The following audit programs, ICQs, checklist or workpapers were added this month. They are in Microsoft Word Icon format unless otherwise specified. Go to the AuditNet home page or the  Audit Programs page for other formats 

  1. 401K Loan Audit Program

  2. Accounts Payable

  3. Accounts Receivable

  4. Accrual Audit Program

  5. Advertising Contract Audit Program

  6. Audit Finding/Recommendation Worksheet

  7. Bank Branch Audit

  8. Branch Audit Program

  9. Branch Warehouse (Distribution)

  10. Cash Audit Program

  11. Cash Audit Program

  12. Cell Phone Review

  13. Collections Audit Program

  14. Cost of Sales Audit Program

  15. Depreciation Audit Program

  16. EDI Order Fulfillment Audit Program

  17. Financial Commitment Audit Program

  18. Fraternity Audit Program

  19. Homeowners Association Audit Program

  20. Hospital Patient Accounting Audit Program

  21. Interest Expense Audit Program

  22. Inventory Audit Program

  23. IT Risk Matrix

  24. Lotus Notes Risk Matrix

  25. Operating Expense Audit Program

  26. Unix System Services

Audit Programs 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. Auction Audit Program

  2. Cash Receipts Audit Program

  3. CEO Survey

  4. Corporate Spending Analysis Audit Program

  5. Credit Card Administration Audit Program

  6. Customer Satisfaction Questionnaire

  7. Head Start Pre Audit Checklist

  8. Wholesaler Charge Backs Audit Program


Ask the 'Net Auditor Forum Provides an Opportunity for Sharing!

This column is proving to be a great resource for auditors looking for answers to questions. Previous questions asked are organized in archives for audit programs, best practices, audit standards, how do I, and miscellaneous.  Look there and if your question has not been asked before give the ATNA (Ask the 'Net Auditor) forum a try. Send your question along with a contribution of an audit work program, ICQ, checklist, or other audit resource and the audit gurus at AuditNet will try to answer the query to the best of their ability. No guarantees but with the Internet at our side we do a pretty good job!  

We also encourage AuditNet users to review questions posed that are still pending answers. If you have an answer to a question please share it. This will also entitle you to ask a question without having to share a resource!

To submit a question you can go to Ask the Auditor. To review previous questions go to the Forum Index.

Auditors Sharing Knowledge (ASK) for Progress


We'll Get By With a Little Help From Our Friends!

Tell a friend about the AuditNet Web site and how to subscribe to the monthly newsletter update or have them send an e-mail to editor@auditnet.org and I will add them to the list. 


Productivity Tip

Leveraging the Internet for Auditing

The Internet paradigm has affected virtually every aspect of business, as we know it. Auditors are adopting new techniques incorporating Internet technology into their jobs. From audit planning right through to the report auditors are incorporating the Internet into the audit process. I have been using the Internet and developing Internet resources for auditors since 1994. In fact this is the 8th anniversary of the AuditNet Resource List. Every month since 1994 I have added, modified or deleted Internet Internet resources from the list. Why did I do it? Because I felt it was needed and it was the right thing to do. The result of that initial distribution is AuditNet which is now visited by over 28,000 auditors every month of which more than 8,000 are prior users.  Why do those auditors keep coming back? Because we keep adding new resources and tools and they add value to both individual auditors and audit departments. Each month I will present an article on ways to leverage the Internet for audit productivity based on my experience. I will introduce how others are using Internet and welcome AuditNet users to share your experiences.  IF YOU HAVE AN EXPERIENCE TO SHARE ON HOW YOU HAVE INCORPORATED THE INTERNET INTO YOUR AUDIT PROCESS, SHARE IT BY SENDING IT TO editor@auditnet.org.

For more productivity tips order a copy of The Auditor's Guide to Internet Resources 2nd Edition from the IIA

Heard on the Web
The following comments are excerpted from the guest book of the AuditNet Web site: 
 
What a superb website! I have never seen such a gold mine for auditors as far as knowledge goes. I am going to begin another chapter in my audit career and I am thankful that I found this site for help and reference. There is only one word to describe it ... EXCELLENT!!!

More power to all auditors who are generous enough to share their knowledge to other auditors. I can't thank them enough!

Grace from New Zealand

 
************
I have been an Audit Director for a fortune 500 company with a fairly large staff....I am now helping a company start and an internal audit function...in both roles I have found you site to be a most valuable asset!

Keep up the good work!


 


New Audit Program Requests

If you have a program that would address these areas or would just like to contribute to Auditors Sharing Knowledge for Progress, send it along to editor@auditnet.org. To see more audit programs that auditors are looking for, go to Audit Programs and scroll to the bottom of the page.

Advertising Management
Customer Billing/Invoicing
Cell Phones
Contract Management
General Agents
Knowledge Management implementation
Microsoft SQL Audit Program
NDM, FTP or Connect Direct
Subscription Management
Windows 2000 Network Server
Windows 2000 Security


Security Management Guidance Resource List

The Web is an incredible environment for sharing audit related information. Recently Dan Swanson shared his security management guidance resource list that was initially developed for a security seminar and expanded from research for a privacy seminar. Like the AuditNet Resource List others started contributing and adding to the list. Dan updates the list based on research and recommendations from others. In a similar style to AuditNet the list includes the link and a description of the resource. Here are some examples from the latest list:

Feature Security Standard – “ISF Standard of Good Practice”

The Information Security Forum – (formerly known as the European Security Forum).

http://www.securityforum.org/menu.htm

The Forum’s Standard of Good Practice is now available in the public domain. A separate web site has been developed and this “leading edge” security standard can be found at www.isfsecuritystandard.com.

Ø      This document is 136 pages in length and was developed over a 10 year period by ISF!

Feature Web Site  

The Center for Internet Security mission is to help organizations around the world effectively manage the risks related to information security. CIS provides methods and tools to improve, measure, monitor, and compare the security status of your Internet-connected systems and appliances, plus those of your business partners. 

http://www.cisecurity.org/

For the entire list in click here!


CONFERENCES SEMINARS AND TRAINING FOR AUDITORS

Auditors Conference 2002
"Enhancing Audit Performance and Productivity"

The IIA Western South Region Conference will take place on August 8-9, 2002 in San Francisco. The program will cover audit and risk management, audit tools and automating the audit department. For details go to Auditors Conference 2002.

Raising the Bar - In Security Management

 Building on the last several years of highly popular and well attended Security and Privacy events, the Winnipeg Internal Auditors will be delivering a 5 day series of "leading edge" security events - starting on November 4th, 2002. They have organized a comprehensive security conference covering a wide variety of today's hot issues and arranged for a host of very senior and experienced Security Practitioners (to present). Please register early to avoid any disappointment: For conference details


NETWORK WITH OVER 1,000 AUDITORS

Do you have a question about auditing or audit programs? .... Or perhaps you have the answer to someone else's question.... Then consider subscribing to the AuditNet's Audit-L. or Auditprograms-L Imailsrv Discussion List (or both). Go to the Discussion List page for more information about these resources.

For automated workpaper solutions for your audit office check out the following AuditNet sponsors:

al_logo.gif (1206 bytes)    

pentana_banner.jpg (53289 bytes)


CAREER BOOT CAMP FOR AUDITORS

How to Gain Control Of Your Job Search

by Robbie Miller Kaplan

Only 25% of all positions are found through published and defined markets, such as employment ads, placement agencies and recruiting firms. Unfortunately, job seekers favor these markets even though they face less competition for the remaining 75% of jobs found through networking and direct unsolicited contact with employers.

For the story on how I used direct contact to outsmart the pack for an advertised opening and  8 tips for taking charge of your job search click here.

Each month the AuditNet Resource Newsletter includes a career-related tip from Robbie Miller Kaplan, author of How to Say It in Your Job Search. If you like these tips, check out her books! For more career tips go the Job-Resources Web site at www.job-resources.com

.


Archives of Posted Messages

Many times auditors want to see what messages were posted to the list to see if their question can be answered there. Also new subscribers have an opportunity to review the archives as another research resource. AuditNet uses a public archive service for both Audit-l and AuditPrograms-l. The URL's to reach these archives is as follows.

Archives for Audit-L www.mail-archive.com/audit-l@list.auditnet.org

Archives for Auditprograms-l www.mail-archive.com/auditprograms-l@list.auditnet.org/

AUDITNET EXCLUSIVE SOFTWARE COMPLIANCE AUDITING 100% LEGAL BACKUP

Pssssst,
want some "legal" backup software?
........ or has PC Profile lost the plot?

NO, BUT.....................

Read the complete article!

ARTICLES ON FREE AUDIT SOFTWARE? and WEB Based Audits 

If you are using software illegally (or know someone else who is) then there is now no excuse for hiding behind all the weak excuses that many tend to use.

There is now a FREE software tool that will help you (or your friends) cleanup your act BEFORE you get caught out!

Don't say you weren't warned! The FREE Software Audit tool is located at http://www.pcprofile.com

These two new articles walk you through information about FREE Software Audit Tools and the Risks of Web Based Audits

FREE AUDIT SOFTWARE
and Web Based Audits 

For more links to articles and vendors for Software Compliance Auditing go to the AuditNet Library and click on Software Compliance Auditing.


Help Keep AuditNet Current!

AuditNet is a tool used by auditors from around the world. It is therefore very important that the links are current.  If you find a link that is outdated, broken, or going to the wrong site, be a helpful user and let us know. Send an email to editor@auditnet.org and provide the details including the date, URL of the bad address and  the name of the site. We will do our best to  either correct the link or remove it so that all AuditNet users benefit. 

Thanks!  

The Editor


  What's Coming? 

The AuditNet Monograph Series is under development. Useful guides for all levels of auditors from juniors right up to audit directors. 

Web Site Awards

AuditNet will begin identifying Web sites for auditors that stand out from the rest. If you think your company Web site is a cut above the rest send your nominations to editor@auditnet.org

Internet Based Electronic Audit Management

AuditNet is looking for organizations that are integrating the Internet into the audit management process. Some U.S. federal agencies have implemented this and we would like to share their experiences. The combination of using the Internet as well as intranets make this concept a reality. Watch for more on this subject.

Excel is the spreadsheet of choice for many auditors. If you have favorite tips and techniques for auditors using Excel send them along to editor@auditnet.org for inclusion in this new section of AuditNet! 

AuditNet will be reviewing books of interest to internal auditors from popular publishers. If you have a book you would like to see reviewed let the editor know by sending an email to editor@auditnet.org. If you would like to be a book reviewer send an email to editor@auditnet.org


AUDITNET JOB LISTINGS (& MORE)

Looking for an audit job? Go to AuditNet's 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.

 

Flowcharting: Art or Science! AuditNet will review
flowcharting software packages and also provide a 
page with links including a Guide to Preparing Flow-
charts.

Auditing AuditNet: A Historical Perspective and The Stats

Just how big is AuditNet and what statistics do you have to support your claims? When I began building AuditNet, I maintained that if I built it auditors would come.  What started in August 1994 as a one page list of 10 resources has mushroomed into the oldest and most comprehensive free site for the global audit community. While I have been reluctant to provide numbers because, in my opinion, outcomes are what counts, I have decided to play the numbers game and provide the information for the curious. There are a number of statistics that I gather on a monthly basis. The following statistics are as of April 30, 2002:

AuditNet-l subscribers 5,113
AuditPrograms-l discussion list subscribers 668
Audit-l discussion list subscribers 357
Total resources in KARL - 1,261
Number of pages in KARL- 111
Number of audit programs in the inventory (483):

In addition, the following information comes from the July 2002 Web Trends report. Each month I generate a report that provides this information and much more. The statistics provided help manage the site. If you are interested in reviewing the reports, they are available at www.auditnet.org/report

While all these numbers may interest the curious few the bottom line is that AuditNet is dedicated to maintaining and providing this clearinghouse of information for the benefit of the global audit community.  I am constantly asked by auditors how they can help in this effort. My response is to contribute and share in AuditNet's philosophy of Auditors Sharing Knowledge (ASK) for Progress. 

General Statistics
Hits Entire Site (Successful) 1,083,381
Average Per Day 34,947
Home Page 26,202
Page Views Page Views (Impressions) 200,461
Average Per Day 6,466
Document Views 193,718
Visitor Sessions Visitor Sessions 70,439
Average Per Day 2,269
Average Visitor Session Length 00:11:49
International Visitor Sessions 18.38%
Visitor Sessions of Unknown Origin 35.2%
Visitor Sessions from United States 46.41%
Visitors Unique Visitors 28,447
Visitors Who Visited Once 20,335
Visitors Who Visited More Than Once 8,112
 

This section represents only the additions and changes to Kaplan's AuditNet Resource List (KARL) for last month. Regular users of KARL should check this section for updates to previous postings and new additions.


New Sites Added to the AuditNet Resource List:

Benford's Law How to Spot Fraud is part of a Web site covering Amazing Applications of Probability and Statistics.

Best Practice Packages from the Independent Commission Against Corruption provides internal control checklists for over 20 different functions/processes.

Contract Management Better Practice Guide from the Australian National Audit Office

Electronic Auditing and Fraud Detection Techniques article from the Wisconsin CPA newsletter.

Guide to Best Practices for Contract Administration  from the Office of Federal Procurement Policy.

Guide to Best Practices for Performance-Based Service Contracting  from the Office of Federal Procurement Policy.

I've Got Your Number article in the Journal of Accountancy by Mark Nigrini.

Service Contracting: A Guide to Best Practices from the Navy Acquisition Reform Office.

Modifications:

Arthur Andersen (www.arthurandersen.com) web site providing information about the firm and its history as well as sections for global best practices, interactive tools and business links.

Deloitte Touche Tohmatsu (www.deloitte.com) site provides information about the organization and links to their global network.

Ernst & Young (www.ey.com) site provides information about the organization and links to their global network.

KPMG (www.kpmg.com) site provides information about the organization and links to their global network.

PricewaterhouseCoopers (www.pwcglobal.com) site provides information about the organization and links to their global network.

I.D.E.A. - Data Analysis Software (www.caseware-idea.com). Web site provides information about the product, a downloadable demo, and application ideas.

Non Federal Audits Team Home Page (www.ed.gov/offices/OIG/nonfed/)

Resources No Longer Available and Links Removed:  

CAATTsScripts (www.kolumbus.fi/mt.mattila/)

 Please let us know of links that are not working!


For a free subscription to AuditNet-L, which includes the monthly update to Internet Resources for auditors, send an e-mail to imailsrv@list.auditnet.org;

Subject: (leave blank);

Body: Subscribe AuditNet-L (yourname).

logo.jpg (1604 bytes)

For a free subscription to AuditPrograms-L send an e-mail to imailsrv@list.auditnet.org

Subject Leave Blank

Body: Subscribe AuditPrograms-L

To post a message to the list send an e-mail to: AuditPrograms-L@list.auditnet.org


Copyright © AuditNet

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.

Send comments to: editor@auditnet.org



Revised: September 09, 2009

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