"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.
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!
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.
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
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!
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.
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 Fighterwww.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.
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!
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?
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
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:
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/
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.
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.
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.
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.
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.
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;
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.