Jim Kaplan's
audnet.gif (4937 bytes)
 

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

 

January 2005

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 Links
AuditNet Library

Sarbanes-Oxley Page
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

 

 
Corporate Governance Certification

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.

This month check out Paisley Consulting products that address the needs of today's changing internal audit departments. Products include AutoAudit (audit automation software), and Workforce (audit staff scheduling software).  Remember! Clicking on sponsored ads helps support AuditNet®. Remember: visiting sponsors helps support AuditNet®.


IT Controls Impact Sarbanes-Oxley Compliance Efforts

 

Information technology (IT) is, incontrovertibly, a central business process element in most organizations today. To illustrate this point, consider that, as many organizations make the decision to outsource noncore business functions (such as human resources), a trend has emerged to include IT in these outsourcing initiatives so that the function will be viewed and treated in an integrated, comprehensive way.
In other words, leaving IT out of the picture is no longer an option.

This article was contributed by Protiviti KnowledgeLeader, an online service providing tools, templates, and other resources for internal audit and risk management. Free trials available at www.knowledgeleader.com. For a limited time KnowledgeLeader memberships are available for the reduced rate of $550 per year. Tell them you heard about it from AuditNet.org.

Click here for the article!


Understand IT's role with the Sarbanes-Oxley Act

A guide by Mike Tarrani, IT Consultant

What is the Sarbanes-Oxley Act?
Cutting to the chase and through the hyperbole, it is a law enacted in 2002 that legislates record retention and prescribes standards for corporate accountability. The essence of the Act are internal controls and corporate governance. IT auditing is an element of compliance, as well as the maintenance and administration of systems supporting all facets of compliance.

For the complete article click here!


Audit of Construction Projects: Buildings and Infrastructure

by Gursharan Singh

The construction industry is a multi-million/billion dollar industry in most countries in the world. Unfortunately, it is given comparatively low priority by the audit profession and receives little support from the owners/management.

The objective of this article/program is to give some guidelines on the more important aspects of audit of construction projects.

Click here for the article including the audit program.


AuditNet® Adds a New SOx Resource

AuditNet added a new e-mail discussion group for Sarbanes-Oxley 404. This discussion group will focus on issues related to complying with Section 404 of the Sarbanes-Oxley Act including sharing of resources and experiences, asking questions and gaining a better understanding of compliance issues related to the Act.

Section 404 of the Sarbanes-Oxley Act (SOX) says that publicly traded companies must establish, document, and maintain internal controls and procedures for financial reporting. It also requires companies to check the effectiveness of internal controls and procedures for financial reporting.

In order to do this, companies must

  • Document existing controls and procedures that relate to financial reporting.
  • Test their effectiveness.
  • Report on any gaps or poorly documented areas.

To subscribe to this free new e-mail discussion group go to http://www.auditnetlists.org/sox404-l/


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
FBI Combats Financial Fraud with CFEs

By Dick Carozza

Brian Lamkin, chief of the FBI's Financial Crimes Section, directs his team of agents and analysts to tackle fraud while working toward additional recognition for CFEs.

Brian Lamkin is the once and current leader of the band. But the results are no longer music performances but fraud convictions.

This article is from Fraud Magazine, 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 Fraud Magazine click here.


Scapegoatism

by Kastuv Ray

Scapegoatism unfortunately happens to be an inherent part of human nature. At some point in our life, even the best of individuals blame someone for something, which was not their fault.

Click here for the rest of the story!


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.


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 October 2004 issue includes articles on legal traps to avoid in cyber-investigations, getting serious about fighting Nigerian fraud and more.   For more information visit www.cybercrimefighter.net


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

5th Annual Technology Conference
Productivity-Enhancing Technology Albany, NY January 2005
*

The IIA's Information Technology Conference for Today's Auditor San Francisco February 2005 *

Government Auditing Conference  Feb 2005 Arlington, VA *

2005 ACFE Fraud Conferences and Training

2005 IIA Conferences and Training

* indicates events where Jim Kaplan is speaking


AuditNet® Vendor News

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

ACL News

Caseware-Idea News and Events

Paisley Consulting press releases

Pentana news and announcements

TeamMate news and events


AuditNet® Review

Using Microsoft Access to Audit Payables for Fraud!

Accounts payable have always been a preferred target for fraud by employees. This CD-based CPE course from the Association of Certified Fraud Examiners will help you gain a clear understanding of the concepts used to audit payables for fraud with Microsoft Access® and why certain tests area more effective than others.

For the review click here!


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!

Electronic Edition Available to Paid Subscribers


Heard on the Net!
Guide to Audit Work Programs on the Net'

Auditors are constantly searching the Internet for tools and techniques that will help them in their jobs. Audit program steps and procedures are a highly sought after commodity for all level of auditors. In the early 1990’s I noticed that there were periodic postings on e-mail discussion lists or listservs requesting audit programs for a specific cycle or application. Many times, due to the changing nature of subscribers, repeat requests would be posted in subsequent months. In order to increase efficiency and meet the needs of auditors I thought it would be beneficial to establish a centralized inventory of audit programs.

For the rest of the story click here!

Stay up to date with announcements on new portals, tools and sharing resources on Sarbanes-Oxley and other audit related issues by subscribing to the AuditNet® newsletter

Until next month!

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 not currently in the inventory.  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. Accreditation Criteria Audit Program (Jan 2005)

  2. Cash Disbursements Key Controls (Jan 2005)

  3. Cashier Services & Petty Cash (Jan 2005)

  4. Cuestionario de Control Interno (Jan 2005)

  5. Matriz de Objetivos de Controles para Interfaces (Jan 2005)

  6. Payroll Audit Program (Jan 2005)

  7. Sox Testing Template (Jan 2005)

  8. Virtual Private Network Audit Program (Jan 2005)

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. College Library Audit Program

  2. Liquor & Gaming Store Compliance Audit Program

  3. PCAOB Standard 2

  4. S-Ox Code of Ethics Example

  5. S-Ox Framework for Evaluating Exceptions

  6. S-Ox Staff Internal Control Q&A

 

Contribution Required Audit Documents!

The following documents require the contribution of an audit program not currently in the inventory. They are also available to subscribers to the Audit Programs Subscription Service.

  1. Sarbanes-Oxley Section 404 Application Baseline Audit Program

  2. S-Ox Mapping Financial Statements to Controls Template

  3. S-Ox Inventory Management and Risk Controls

  4. S-Ox Revenue Process Audit Program

  5. S-Ox Revenue and Risk Controls

  6. S-Ox Treasury and Risk Controls

  7. UNIX Servers APG


AuditNet® What's New This Month?

This month AuditNet® welcomes a new CAATT Corner featured columnist. Rich Lanza, CAATTs and audit software guru will provide readers with an AuditNet® exclusive featuring tips, tools and techniques for improving audit efficiency with digital solutions. There are new articles on construction audit, book reviews and more. Watch for new additions to the audit programs subscription service available as an alternative for those auditors that are unable to contribute material to AuditNet®. 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.


A PERFORMANCE MEASUREMENT FRAMEWORK FOR INTERNAL AUDIT

by Stan Farmer

There are three compelling reasons why internal audit should be concerned with performance measurement:

  • The need to comply with Professional Standards
  • The need to demonstrate value
  • To respond to changes in the global environment

The objectives of this research are therefore to:

  • identify best practice in the measurement of business performance;
  • identify current practice in the measurement of performance in internal audit;
  • compare and contrast current practice with best practice; to,
  • develop a performance measurement framework for internal audit.

For the rest of the results of this dissertation click here!


AuditNet® CAATT Corner

Turning Microsoft Excel Into An Audit Software

By Richard B. Lanza, CPA, CFE, PMP

Although audit-specific software should be used when necessary, spreadsheet software like Microsoft Excel can be a trusty tool when analyzing small data sets. Furthermore, auditors can often summarize large data sets down to a "spreadsheet size," allowing them to use Excel to present the results of more powerful audit software analysis to coworkers.

For the rest of the article click here!

ABOUT THE AUTHOR Rich Lanza (CPA, CFE, PMP) enables organizations in the use of technology to (1) generate cash recoveries, (2) stop profit leaks, (3) move away from control issues, and (4) work towards process improvements. To contact Rich, receive his free e-newsletter, get a free diagnostic, or to order his products/services, e-mail him at rich@auditsoftware.net, call him at 973-601-3701, or visit his website at www.infomagician.com.


AuditNet® Software Compliance Audit Corner

“Is Your Number Up?”

This new AuditNet® monograph focuses on the issues auditors face with Microsoft Windows XP Service Pack 2. Microsoft Windows XP has been around for some time now and Microsoft has been shipping Service Pack 2 for XP. There has been lots of press and publicity about its release and the need for sites to embrace the Service pack as a means to protect themselves against security issues. Some of you may have already discovered the hard way that is has caused some significant disruption to your systems for technical reasons!

For the new monograph click here!

Current Views on Governance and Compliance


Your Secret Weapon in the War on Fraud

The December 2004 issue of this fraud newsletter features articles on auditing for internal fraud, how to avoid being conned, independent fraud investigations 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®.

Book Reviews

PDF Hacks

PDF Hacks: 100 Industrial-Strength Tips and Tools

by Sid Steward

Review by Jim Kaplan CIA CFE
AuditNet® LLC Executive Director

Every auditor that searches the Web for audit resources is familiar with PDF or portable document format. Typically these documents downloaded from the Web have a “reputation for being slow to load and slower to print, hopelessly unsearchable, and all but impossible to cut and paste from”. I know from experience that there is more to PDF than meets the eye. Too many times I have downloaded large PDF files that cannot be navigated (no table of contents). Creating PDF documents is as much an art as it is a science and a knowledgeable digital author can enhance the usefulness of prepared documents. Beyond that, many individuals have created tools and libraries that make PDF do exactly what they want. PDF Hacks, by Sid Steward provides hacks or tools, tips and solutions to common problems. There are 100’s of hacks that cover every aspect of PDF functionality. Converting files to text or Word, adding, moving and editing bookmarks to PDF files are just a few of the “hacks” you will want to check out. If you are an auditor that has been frustrated by PDF this is the answer to your problems. If you, or your audit office, use Adobe Acrobat to create PDF files, you will want to add this book to your professional library.

Order the book!

How to Say It When You Don't Know What to Say  The Right Words for Difficult Times

By Robbie Miller Kaplan

As auditors we constantly interact with diverse stakeholders such as colleagues, managers, employees and others. Frequently we encounter people dealing with challenging and difficult times that may or may not be related to work. Our reaction to these situations is conveyed in our behavior both nonverbal and verbal.

For the rest of the review 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 an electronic copy of the book. Contact us for details.


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!

A new e-book, Sarbanes Oxley Section 404 Compliance Tips for IT Managers by Darcy Soleil, will be available free for subscribers to the Audit Programs subscription service. Non-subscribers will be able to purchase this e-book directly from AuditNet.  

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 Sarbanes-Oxley, internal controls and Internet for auditors. If you are interested in developing a monograph on a contract basis, contact us.

Watch for new articles on Finance for Non Financial Executives, CAATTs, and more from contributors. Reviews are in the works for AskSam PowerPoint Personal Trainer, and Excel Personal Trainer. Watch the newsletter for more products, services and tools for auditors. Have an idea for a column? Contact us.

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


AuditNet® Feedback

I'm so happy to find a professional web site relating to audit field like your site, I'm so interested coz I'm IT Audit manager, and always looking for resources which can help me in my work, please keep me updated with all your resources and news Thank you & best regards Tamer A. Hameed IT Audit Manager Kuwait Finance House

One of the ways to better mankind is to share information --- your site has contributed to the betterment of mankind -- well done ! - BigKell

For more comments click here!


         

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