Jim Kaplan's
audnet.gif (4937 bytes)

 

 

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

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

 

AuditNet Links
Audit Programs
AuditNet Library

AuditNet Newsletter
Ask the Auditor
AuditNet Lists
Audit Jobs
Travel

Career Links
Partner Discounts
Search
Sign Guestbook

AuditNet Sponsors

Advertising Opportunities
About AuditNet
About Jim Kaplan
AuditNet Seminars
AuditNet Homepage
 

al_logo.gif (1206 bytes)  

AAsmall banner.gif (2891 bytes)




 

 

 

AuditNet® Trademark

In case you hadn't noticed AuditNet® now bears the official ® symbol of a registered trademark. After a two year application and approval process on September 3, 2002,  the term AuditNet® became the official trademark owned by Jim Kaplan. In use since 1994 AuditNet® I have observed others using the term and felt it was time to register and protect what I conceived of when I first began this project. If you observe anyone using the term inappropriately please contact me at editor@auditnet.org

Thanks for your support!


Book Review

Using Microsoft Access for Data Analysis and Interrogation

By Mark J. Nigrini Ph.D.

Auditors in the 21st century must deal with greater volumes of data than ever before. As much of that data is in electronic or digital format, auditors must therefore rely on sophisticated tools and techniques for testing and evaluating evidence. Medium and large audit shops rely on tools such as I.D.E.A. and ACL for data extraction and analysis. Many audit shops however do not use software for data extraction and analysis either because of budget constraints or non-availability of technical auditors. Every auditor has Microsoft Access on their desktop but how many have considered using this bundled software for digital analysis and interrogation?  

Click here for a review of Mark's latest book.


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.


CAREER BOOT CAMP FOR AUDITORS

Write Your Letter of Resignation

by Robbie Miller Kaplan

When it is time to move on to another organization or transition into a new life experience, it is important to leave your current position on a positive note. Never burn bridges; you may need to interact with this organization or some of the employees in future business endeavors or you may need them as a future reference.

To read the rest of the article and check out the tips to help you 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


CAATT's 

Proving the Numbers

By Cynthia Thompson, Business Development Manager, SGP International, Inc.

Reconciliation can be a tedious process, but data accuracy is too important for companies to ignore. Companies make decisions based on the belief that their data is accurate, so all efforts must be put forth to validate the data. With the proliferation of database systems and the variety of source data contained in them, there is an increasing need to validate data to assure consistent, accurate information. However, there are a number of challenges that arise in pursuit of this effort. This article will explore these challenges as well as explain how the two most prevalent reconciliation methods, the Line Grouping Method and the Source Transaction Method, can be used to locate inaccuracies.

This article will also explore where and how technology is employed in these efforts. With all of the technology available today, one would assume that software is commonly applied to automate these methods. In reality, many organizations are still using spreadsheets or rudimentary manual paper to perform these reconciliation processes. While the Source Transaction Method can be easily computerized, the Line Grouping Method, which often depends on the unique requirements and processes of the unit being evaluated, is more complicated to automate.

Click here for the complete article.


AuditNet Resource List Updates

Click here for the new links!

Please let us know of links that are not working!


AuditNet Statistics

For those who like to wade through the details on how popular AuditNet is, click here for the current stats or go to the online WebTrends report.


CAATTs Case Study

Use of CAATTs in audit of Long Term Deposit (Fixed deposit) accounts.

by N.Nagarajan

This is a case study of using computer assisted audit tools and techniques in an audit of fixed deposit accounts. The author used IDEA to analyze the data and presents the solution using that software.

Read the complete article by Mr. Nagarajan


Preview of Coming Attractions!

The AuditNet Monograph Series is under development. Useful guides for all levels of auditors from juniors right up to audit directors. If you are interested in developing a monograph on a contract basis, send an email to editor@auditnet.org

I will interview vendors and other stakeholders to see how the Internet is changing the internal audit profession. These interviews will appear in the monthly newsletter.

Watch for a Book review of Financial Shenanigans: How to Detect Accounting Gimmicks & Fraud in Financial Reports by Howard Schilit

Software review of Flowcharting 5 from Patton and Patton.


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

Order it Now!

 

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

Order it Now!


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. Bank Reconciliation Audit Program

  2. Banking - FX Revaluation Audit Program

  3. Bank Risk Assessment Questionnaire

  4. Information Technology Policy Audit Program

  5. Insider Lending ICQ

  6. Payroll Audit Program - Retail Store

  7. Procurement and Contract Management Audit

  8. Proof of Cash Workpaper

  9. Third Party Administrator Medical Claims

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. Bank Items Processing Audit Program

  2. Bank Insurance Audit Program

  3. Cash Applications Audit Program

  4. Credit/Collections & Accounts Receivable

  5. Customer Service Audit Program

  6. Invoicing Audit Program

  7. Loan Review - Authorization and Reporting

  8. Loan Review - Compliance

  9. Loan Review - Data Integrity

  10. Loan Review - General Audit Requirements

  11. Loan Review - Other Real Estate Owned

  12. Loan Review - Physical Safeguards

  13. Loan Review - Reconciliation

  14. Management Reporting

  15. Petty Cash Audit Program Checklist

  16. Revenue Master Data Audit Program

  17. Sales Revenue Audit Program


AuditNet Productivity Tips

Leveraging the Internet for Auditing (Continued) 

How are you using the Internet for audit productivity? I always ask this question when I go to I.I.A. chapter meeting or professional conferences and seminars. I am surprised at the number of auditors that I speak to that are not using the Internet. As the director of a small internal internal audit department, I cannot conceive of doing what we do without tapping into the resources of the Internet. My office was recently asked to review internal controls for a particular agency. Through postings on an email discussion I received an audit program, tips on auditing this function and more. There is no limit to what the Internet can do for you as an auditor if you only let your imagination run wild. Find an audit work program, discover a control checklist, benchmark best practices, conduct a survey, review an audit report, send a single question to hundreds of peers for their consul and on and on! 

  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.


BREEDING GROUND FOR IDENTITY THEFT 

by Robert Brown Jr.

This is a case study in the organizational
elements that could enable an act of Identity Theft. Included, as well, are suggested management efforts to prevent such activity.

Click here to read the article.


Software Compliance Audit News

AuditNet® Exclusive Article

by Rob Harmer

Using Illegal Software is a BIG RISK - you know this already,
BUT DID YOU KNOW THAT ....................?
If a software vendor eg; Microsoft, Autocad, Oracle, Novell etc has reasonable grounds for believing that illegal software, (which also can include sounds, films, videos, games, images, fonts) being used on your systems and that evidence may be destroyed if notice is given, then the software vendor may apply to a Court of Law for an Anton Pillar Order.

Click here for the rest of the story!


Audit Street News

PricewaterhouseCoopers Report

Ten Imperatives for a Post-Enron World

Enron's collapse, and the implications of serious control issues that accompanied it, are having a profound impact on how organizations view their corporate governance and control environments. Directors and executive management are rethinking their governance processes with a heightened zeal to ensure that problems now apparent in certain organizations don't happen in theirs.

Read PricewaterhouseCoopers' ten imperatives for internal audit to provide a strong foundation for success in a radically altered business landscape.


Conferences and Seminars

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: Click for conference details.


AuditNet Feedback

"I want to extend my appreciation to auditnet for you have been a great help to auditors from all over the world. You have change the way audit are done this days. Thank you very much. You are such a great help."

"It is really a wonderful technical tool for an auditor and I believe it has become necessity for the present day auditor to know how the technology affects his approach and for that he needs AuditNet


 

 

         

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.

Send comments to: editor@auditnet.org



Revised: September 09, 2009

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