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)Click Here
ASK (Auditors Sharing Knowledge) for Progress

December 1, 2001

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


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

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 Free!

AuditNet remains free to the global audit
community because it is sponsor-supported.
Support our sponsors and you support AuditNet
and ensure it's continued existence.

If you are trying to market to the audit community, there are many opportunities for corporations and vendors to sponsor the AuditNet site. Contact editor@auditnet.org for advertising, sponsorship or partner information.

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.

logo.jpg (1604 bytes)al_logo.gif (1206 bytes)

AAsmall banner.gif (2891 bytes)

 

Problems with Email Discussion List

My apologies to all the loyal AuditNet users for the multiple messages generated from a mid-November mailing. According to the Web hosting service that provides the list support, the issue has been resolved. They are looking at replacing their listserve software as they have not been happy with it's performance. I am also exploring alternatives for the listserve that include using another third party provider that just handles listserves.

Rest assured that the last thing that I would ever do to list subscribers is intentionally generate unnecessary email (SPAM). A number of subscribers felt that I was intentionally spamming them and either unsubscribed or sent me very strong emails expressing their displeasure. Please remember that AuditNet-l, Auditprograms-l and Audit-l are all opt-in discussion lists. This means that the way that you get the email is by subscribing. You always have the option of unsubscribing and I encourage you to do so if you feel that the respective list is not meeting your needs. The vast majority of subscribers sent supportive emails expressing understanding and a clear picture that what was happening was not intended. Those of you who fit in the latter category you have my never-ending gratitude. For the past seven years I have been providing this resource because I felt it was needed and the right thing to do. I will continue to do so with majority support.

Have a Happy and Healthy Holiday Season whether it be Christmas, Hanukkah, Kwanzaa or Ramadan. On AuditNet we all have a common purpose: Auditors Sharing Knowledge for Progress!


AAsmall banner.gif (2891 bytes)

Avoiding the Pitfalls of 
Control Self Assessment Sessions

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 

Read the entire article  in or generously shared by Andersen's KnowledgeSpace® Internal Audit and Risk Management Community.  


AutoAudit takes the "paper" out of paperwork for HUD Inspector General.

The Office of Inspector General at the Department of Housing and Urban Development implemented AutoAudit software to assist its 300 auditors in transforming the OIG office into a paperless environment. The HUD audit staff conducts 160 audits each year creating an average of 3,600 pages of information per audit. Adding to the challenge is the fact that the HUD audit staff is distributed across the country, working out of more than 15 local and district offices as well as the headquarters in Washington, DC. 

To read how OIG HUD uses AutoAudit click here.

Risk Based Internal Auditing Joins New Pages for Industry Links and Spreadsheets

AuditNet added a page for risk based internal auditing. The page provides link to methodologies, tools and techniques as well as articles on the subject. Go the Virtual Library page for this new resource. Also visit the new pages providing links to industry resources and spreadsheets. 

Auditors work in a variety of industries. AuditNet added an industry link page. The page provides
links to knowledge resources for auditors based on industry codes. Go to the Virtual Library and click on Industry Links.

Spreadsheets have been standard tools for auditors 
since the early days of personal computers. AuditNet
added a page with links to resources including auditor submitted spreadsheets and financial analysis templates.  Go to the Virtual Library and click on Spreadsheets


Data Recovery Services:
The Cost of Not Backing Up

I learned the hard way how it important it is to back up your data regularly. Like most people running a business from their home I did not pay much attention to a specific routine for scheduled back ups of data on our two computers. Once a month stretched in to two then three and so on. Recently the unthinkable happened. Click here for the "rest of the story" and potential problems with hard disks on HP computers!

 
New Programs and Workpapers 
Added to AuditNet

Auditors Sharing Audit Programs and Workpapers

The following audit programs, ICQs, checklist or workpapers were added this month. Go to the AuditNet home page or the  Audit Programs page for other formats 

  1. ACH ICQ (xls)
  2. Deposit Accounts ICQ (xls)
  3. Facility Security Procedures Audit (xls)
  4. Individual Retirement Account Administration
  5. Purchasing Audit Program
  6. Project Management Audit Questionnaire (ISO based) (Word)
  7. Security of Electronic Information
  8. Subsequent Review Audit Program (Word)
  9. Trade Creditors Audit Program (Word)
  10. Wire Room ICQ (Word)

New Audit Program Requests

  1. Collection agencies

  2. SAP Loan Cycle

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.

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. 

Bank Reconciliation Statements
Credit Collections
Cash Payments Cycle
Cash Receipts Cycle
Consumer Loans Procedures and ICQ
Fixed Asset Counts
Internet Banking Audit Program
Novell Groupwise Review
SAP Fixed Assets
Systems Software Audit Program
Time Budget Excel Worksheet
Trade Receivables
Warehousing and Storage Checklist
Wireless Networking

 

Ask the 'Net Auditor Forum Proves Popular!

This new 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!  

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


.

R.T. Edwards, Inc., the publisher of the Journal of Forensic Accounting offers AuditNet user organizations the opportunity to subscribe at the institutional rate.  A sample article Black Tech Forensics: Collection and Control of Electronic Evidence is available for your review. For more information on the publication go to the discounts page.

logo.jpg (1604 bytes)


Partner with AuditNet
 
If you sell goods or services to the auditing community consider AuditNet as your partner for global outreach. Offer AuditNet users a discount on your product or service and we will include a link to your site on the AuditNet Partner Discounts page.

 
 
 
Just received the December 2001 issue and it is packed with great fraud related info and tips. Would you believe that one of terrorists favorite frauds involves grocery coupons?  Another excellent article details new tools and techniques for preventing corporate book-cooking. Another article tells how healthcare providers provide for themselves at taxpayers' expense. Check out this publication if you want to stay on the leading edge of white collar crime and fraud. 
White-Collar Crime Fighter www.wccfighter.com the only source of exclusive, authoritative "how-to" information for financial crime fighters offers AuditNet users a discounted subscription rate of $77-- a savings of $20 off the regular 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! 

Productivity Tip

Virtual Internet Search Tips for Auditors (VISTA)
Using Titles in Searches

Most major search engines allow you to search within the HTML title of a web page. The "title" appears within the title tag of a document. The Title tag does not show up on your monitor but will be listed when you print a page.  For example, this page has an HTML title like this:

<title>AuditNet Monthly Newsletter</title>

If someone were to do a title search for "AuditNet Monthly Newsletter," then this page would show up, because those words appear in the HTML title.

Search engines that support title searching such as Altavista, use the following command:

title:terms

where "terms" are the words you wish to search for in the title. Make sure you look at the help section of your favorite search engine to see if it supports title searching. Using the Title command can be a powerful addition to searching for elusive audit resources on the Internet. 

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

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.

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. 

 
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.

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


 

No Budget for Audit Software
(
AuditNet Article exclusive from PCProfile)

An AuditNet exclusive from PCProfile discusses the issue of overcoming management resistance to investing in software audit tools. The article provides very convincing arguments on why management should be taking this risk seriously!

Click here for the complete AuditNet exclusive! 

Declaring War on Software Pirates 

AAsmall banner.gif (2891 bytes)

Save $$ on the 
Software Compliance Auditors Toolkit

Be prepared when the software police come knocking on your door!

AuditNet Users Save $200 - Save $$ and get legal! Check it out!


Online Workpaper Tips for Auditors

Auditors are always looking at operating more efficiently and effectively. This means not only looking at entities external to the audit function but also looking within. Automating working papers has been an endeavor that audit functions have implemented or considered. This subject also appears in online discussion forums periodically. Recently the following question was raised in the Audit-L discussion list. 

Our department is considering moving to online work papers. We have examined several software packages, but we have not found anything that we like enough to spend that kind of money. We are a small office (director, one staff auditor, three student auditors), and we are thinking of developing our own system. Our plan is to have a main document in Excel and use hyperlinks to supporting documents which would be stored in appropriate subdirectories.

Have any of you developed your own online work paper system? What kind of advice do you have for us?

The following response was provided by Dez (DNyitray@Victaulic.com)

We have started putting the supporting documents into the actual audit program as inserted files using the procedure below. It works in both Word and Excel.

Put cursor where you want the doc.
Click on Insert
Object
Create from file
Browse - find it
Click on "Display as Icon"
OK

Click here for an example of how this works. 

If you have an automated workpaper tip to share send it to editor@auditnet.org and I will post it in next month's newsletter!

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

al_logo.gif (1206 bytes)    

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/

pentana_banner.jpg (53289 bytes)


CAREER TIPS FOR AUDITORS

Will Your Resume Make the Cut?

by Robbie Miller Kaplan

A colleague had an opening to fill and received 20 resumes from human resources. He asked me to take a look and help him select five qualified candidates.

The resumes surprised me. They were so poorly prepared I found it difficult to select any applicants that had the desired qualifications. What was wrong? There is an old saying that "actions speak louder than words." Here is a list of real-life resume errors and what they tell a prospective employer:

1. Resumes typed on an electric typewriter. This resume sends a red flag that the applicant does not know how to use a computer.

2. Resumes that use different fonts for several jobs. Details are important and this resume appears as if the applicant updated only part of the resume. It demonstrates a lack of professionalism in how the applicant will approach their responsibilities.

3. Redundant use of words. Indicates limited vocabulary and a lack of imagination.

4. Resumes produced with just one font. Suggests the applicant is unsure which qualifications are important and of interest to the employer.

5. Crowded documents that are impossible to read. Signals the applicant does not have familiarity in word processing and document production.

6. Credentials that have no relevance to the potential position. Indicates the applicant either has no understanding of the position they are seeking or is sending resumes to open positions, regardless of the requirements.

7. Inclusion of activities and experiences that clearly indicate the applicant's religion, origin, or ethnicity. Gives an employer personal information they can not legally query and allows them to discriminate against the applicant.

It is imperative that job seekers use resumes to market their qualifications to prospective employers. Produce a good one and you will be head and shoulders ahead of the pack.

Good luck!

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.


idealogo.jpg (59139 bytes)Book Review 

Digital Analysis Using Benford's Law 

by Mark J. Nigrini

Benford's Law, first identified by Simon Newcomb in 1881, states that if you randomly select a number from a table of physical constants or statistical data, the probability that the first digit will be a "1" is about 30%, rather than 10% as we might expect if all digits were equally likely.

According to Mark Nigrini, the author of Digital Analysis Using Benford's Law, the audit technology known as Digital Analysis (DA), tests for abnormalities in the digit patterns and abnormal number duplication in corporate data. Mr. Nigrini does a formidable job of explaining how to use digital analysis in performing audit tests of data.

For the full book review click here!


al_logo.gif (1206 bytes)

Help Desk Resources for Auditors

Check out this new page with resources for help desks! If  you  have  any help desk resources send them to AuditNet and I will add them to this page. 

Save $$ on the 
Software Compliance Auditors Toolkit

Be prepared when the software police come knocking on your door!

AuditNet Users Save $200 - Save $$ and 
get legal! Check it out!


  What's Coming? 

Guides for Auditors and New Pages

Watch for new pages for public school auditors, bank auditors and more. 

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

I am also developing a Guide for Preparing, Documenting, and Referencing Spreadsheets based on a 1987 guide produced by the U.S. General Accounting Office. The guide will include a template that auditors can use to standardize spreadsheets and provide for adequate workpaper documentation. 

Special Discounts Exclusively for Auditnet Members!

Click on www.thompson.com/auditnet to learn about Thompson, its publications and how to save up to 20 percent on these valuable services. You can also call Thompson's customer service number 
1-800-677-3789 for more information. Be sure to mention the Auditnet priority code CN691064 when ordering.


The KnowledgeSpace Internal Audit Community  
from  Andersen has an online bookstore, sponsored 
by FatBrain (a Barnes & Noble Company). 
AuditNet users can order any book through this link 
and receive free shipping in the US, or discounted shipping outside the US.


Afentis Security Consulting - www.afentis.com As an exclusive offer
 to AuditNet clients, Afentis is provi-
ding a 15% discount on the overall 
value of a Penetration Test or, Security Evaluation (including, but not restricted to the evaluation of 
Firewall devices, Testing of Intrusion Detection 
Systems, or web-based applications and programs) 
or Training & Advisory Services.

Go to the Partners Discount page for more 
information!

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 the 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 November 30, 2001:

AuditNet-l subscribers 4,348
AuditPrograms-l discussion list subscribers 632
Audit-l discussion list subscribers 335
Total resources in KARL - 1,189
Number of pages in KARL- 109
Number of audit programs in the inventory (364):

In addition, the following information comes from the November 2001 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) 926,867
Average Per Day 30,895
Home Page 25,024
Page Views Page Views (Impressions) 166,543
Average Per Day 5,551
Document Views 162,774
Visitor Sessions Visitor Sessions 56,738
Average Per Day 1,891
Average Visitor Session Length 00:12:20
International Visitor Sessions 13.55%
Visitor Sessions of Unknown Origin 49.71%
Visitor Sessions from United States 36.73%
Visitors Unique Visitors 22,992
Visitors Who Visited Once 16,769
Visitors Who Visited More Than Once 6,223
 

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:

Atlanta Public Schools Internal Audit Web site provides information about the office, audit reports, self assessment guides and more.

Audit Practice Aids from the Iowa State Auditor provides comprehensive step-by step guidelines for audits of specific governmental subdivisions.

Audit of Developing Systems training material from INTOSAI includes a case study, student notes and leaders guide.

Benchmarking in Australia is the most comprehensive Australian site devoted to benchmarking.

Business Continuity Planning training material from INTOSAI includes student notes and leaders guide.

Business Index Database provides links to business resources on the Internet.

Business Process Improvement Online in an online repository of information including methods, tools, and more.

Can-Plan free small project management software capable of producing reports suitable for project status meetings or executive reporting.

Community College Audit Program Guide is a comprehensive audit guide from the State of Iowa.

Computer Assisted Audit Techniques training material from INTOSAI includes student notes and leaders guide.

County Audit Program Guide is a comprehensive audit guide from the State of Iowa.

Data Downloading and Conversion training material from INTOSAI includes student notes and leaders guide.

Information Technology Investment Management Guide from the U.S. General Accounting Office provides a framework for evaluating investments in IT.

PeopleSoft Reporting List (PSREPORT) - Reporting is an essential part of any PeopleSoft implementation, a Higher Education Product Advisory Group on Reporting and Analysis was created this year to provide user feedback that will guide the development of PeopleSoft products. The PeopleSoft reporting listserv lets users in all functional areas share their reporting problems, questions, and solutions. To subscribe send an e-mail to: listserv@listserv.it.northwestern.edu and Leave the subject header blank. In the body of the message, write: subscribe PSREPORT yourfirstname yourlastname

Spreadsheet xlNavigator is a Excel add-on that lets you see the relationship of formula cells in your complex workbooks. Free demo offered as well as links to other spreadsheet resources.

Value for Money Audit  training material from INTOSAI includes student notes and leaders guide.

Modifications:  

Business Research on the Internet

Resources No Longer Available:

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: January 14, 2008

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