AuditNet®
a
ACL Webinar Training – via Practical Application
or If you are only interested in the training without CPE then subscribe to AuditSoftwareVideos
Cost $89 (2.0 CPE) each or the complete series of 12 for $899 (24.0 CPE)
Receive the expert ACL training you’ve been looking for right from your own office. AuditSoftware.net developed a specialized web-based ACL training course focused on retention and quick practical application of your ACL knowledge. This web-based program of ACL and other related courses provides you with the know-how and tools to use ACL effectively- and quickly - within your organization. Already developed ACL scripts and sample data files will be included to jump start your project work and can be used in future testing and training. Two live webinar courses will be offered giving you the opportunity to apply new skills to your audit projects with measurable results. Accessing the recorded version of these webinars provides the reference capability you need during project work throughout the month and beyond.
Speaker - Richard B. Lanza, CPA, CFE – President – Cash Recovery Partners, LLC
Helps companies identify their hidden
financial assets, mostly using technology and referring them to
specialists. He has two decades of experience in audit technology and
recovery auditing, becoming a leading authority in these areas.
Rich is the author of 13 publications and training courses including his first, 101 ACL Applications: A Toolkit for Today’s Auditor, the IIA’s Proactively Detecting Fraud With Computer Audit Reports, which earned him an award from the ACFE and recently, Cost Recovery: Turning Your Accounts Payable Department Into a Profit Center for John Wiley & Sons. Rich was also recently a key contributor to the IIA’s Global Technology Audit Guide (GTAG) Fraud in an Automated World and ISACA's Data Analytics - A Practical Approach research whitepapers.
He has worked for companies ranging in size from $30 million to $30 billion, and in all he has helped them produce tremendous savings through the use of technology and cost recovery initiatives. His websites, www.findmillions.net and www.auditsoftware.net, help companies to identify cost recovery and prospective savings in all areas of their business while implementing the latest in audit technology.
*** - Key Note for All Webinars – Once a webinar is complete, the user will have 12 months access to a taped version of the webinar in its entirety, along with links to any needed data files for the courses. This access will expire one year after the date of the live webinar. No CPE credits are available for this video yet it is provided for later viewing and practice, such as closer to an actual audit date.
FEBRUARY 2012
1. Completing an Accounts Payable Audit With ACL February 15
This course is based on the well-known book, Payables Test Set for ACL, as written by the instructor. Accounts Payable is the #1 area that auditors test for value-and for good reason, it is a top area for errors and fraud with a very prized asset…..cash. This course presents a comprehensive list of objectives that every audit of the accounts payable function must meet, along with an alignment of scripts that assist in meeting the objectives.
The specific learning topics are:
- Being able to map audit objectives in accounts payable to the specific test scripts to perform the task (sampling of these scripts are provided with the course)
- See how a test set of scripts can be developed to uncover duplicate payments, untaken discounts, and other efficiency draws on the organization…..or fraud
- Learn the top questions to ask when extracting accounts payable data and which tables map best to the audit objectives
- Understand how ACL scripts can be written (beyond those provided in the course) to complete many common testing routines in accounts payable
Freebies
- A sampling of ACL scripts, from the Payables Test Set for ACL as written by the instructor. ($50 value)
- List of audit objectives to ACL scripts to run to test the objectives ($15 value)
Date: February 15, 2012
Time: 11:00 AM- 1:00 PM (Eastern, GMT -0500)
CPE: 2 Credits are available for attending the seminar which are awarded
based on a 50-minute hour.
Program Level / Prerequisites and
Advance Preparation: Basic / None
Basic Delivery Method: Group Internet Based
Recommended Category: Specialized Knowledge and Applications
Cost: $89
MARCH 2012
2. Statistical Analysis in ACL - All commands under the Analyze menu item in ACL March 28
The power of ACL lies in the final results which are usually presented using the commands in the Analysis menu item. Learn best practices and advanced techniques in identifying patterns using the Analyze menu commands.
The specific learning topics are:
- Learn to use Statistics, Count and Total in your reporting results
- Be able to utilize the Classify, Stratify, Summarize, and Crosstab functions to identify patterns in the data
- See how to place a Break into a Stratify to get segmented results by transaction type
- Understand how to Analyze data to a table and then improve the final output of commands such as Stratify.
- See how to use the Age functionality to assess timing issues in the data or to get a perspective of the data.
- Learn to complete sequence tests and, more specifically, how to complete a same, same, different duplication test in ACL
- Case study examples of when to use the Summarize and Crosstab, as well as, unique ways to maximize the Summarize command
Date: March 28, 2012
Time: 11:00 AM- 1:00 PM (Eastern, GMT -0500)
CPE: 2 Credits are available for attending the seminar which are awarded
based on a 50-minute hour.
Program Level / Prerequisites and
Advance Preparation: Basic / None
Basic Delivery Method: Group Internet Based
Recommended Category: Specialized Knowledge and Applications
Cost: $89
APRIL 2012
3. Importing Data - The Complete Course in All File Types and Data Tricks to Get Your Data Ready for Analysis April 10, 2012
This course will teach you to import and define various types of data into ACL SoftwareTM as you work through some of the top best practices learned over two decades.
The specific learning topics are:
- Be able to request data for your next review that will meet your reporting requirements.
- Define Fixed field, Variable length, Excel, Delimited, Report files, and more
- Use top computed fields (SPLIT, TRIM functions, etc.) to cleanse data prior to analysis.
- Validate data tables to ensure data quality using common ACL techniques
- Use text editors and other tools to assist in your next import process
- Review an SAP data import process for accounts payable to understand a full case study of the data import process
Date: April 10, 2012
Time: 11:00 AM- 1:00 PM (Eastern, GMT -0500)
CPE: 2 Credits are available for attending the seminar which are awarded
based on a 50-minute hour.
Program Level / Prerequisites and
Advance Preparation: Basic / None
Basic Delivery Method: Group Internet Based
Recommended Category: Specialized Knowledge and Applications
Cost: $89
MAY 2012
4
. Completing a Revenue Recognition Audit With ACL May 1, 2012
Revenue and receivables are the top-rated areas for financial statement fraud. It can also be an area prone to control weaknesses and inefficiencies. Based on the well-known book, Revenue Test Set for ACL as written by the instructor, this course provides instruction on using test sets with included scripts to reach objectives unique to receivables and revenue accounting.
The specific learning topics are:
- Understand how to supplement the revenue recognition audit using ACL
- Learn to run test sets and corresponding test scripts to identify control weakness and inefficiencies
Date: May 1, 2012
Time: 11:00 AM- 1:00 PM (Eastern, GMT -0500)
CPE: 2 Credits are available for attending the seminar which are awarded
based on a 50-minute hour.
Program Level / Prerequisites and
Advance Preparation: Basic / None
Basic Delivery Method: Group Internet Based
Recommended Category: Specialized Knowledge and Applications
Cost: $89
5. Data Manipulation in ACL - All commands under the Data menu item in ACL May 8, 2012
Once data has been imported into ACL, the next step is to manage the data and prepare the data for meaningful analysis. This course will show you how to pull the right data together as well as be able to filter and view information in a results-oriented way.
The specific learning topics are:
- Using the JOIN function including effective many to many JOINs
- Learn Merge, Relate, and Combine multiple tables
- Sort records, Count transactions, and Extract data
- Using top computed fields (SPLIT, TRIM functions)
Date: May 8, 2012
Time: 11:00 AM- 1:00 PM (Eastern, GMT -0500)
CPE: 2 Credits are available for attending the seminar which are awarded
based on a 50-minute hour.
Program Level / Prerequisites and
Advance Preparation: Basic / None
Basic Delivery Method: Group Internet Based
Recommended Category: Specialized Knowledge and Applications
Cost: $89
JUNE 2012
6. Basic Script Writing in ACL June 7, 2012
Basic concepts of script writing and benefits of automating your data projects will be covered in this ACL course. Developing scripts and implementing best practices will show you how to increase the efficiency of your data analytics projects by analyzing transaction sets on a regular basis.
The specific learning topics are:
- Understand ACL scripts and the value of automating data work
- Build menu scripts similar to the pre-developed scripts used in previous courses
- Learn and document best practices for script development
Date: June 7, 2012
Time: 11:00 AM- 1:00 PM (Eastern, GMT -0500)
CPE: 2 Credits are available for attending the seminar which are awarded
based on a 50-minute hour.
Program Level / Prerequisites and
Advance Preparation: Basic / None
Basic Delivery Method: Group Internet Based
Recommended Category: Specialized Knowledge and Applications
Cost: $89
7. Intermediate ACL Scripting June 19
Continue building on skills learned in Basic Script Writing in ACL by moving to advanced techniques for script writing. Working with groups, interactive scripts, and script menus are covered in this course that takes the basic ACL Script skills to the next level.
The specific learning topics are:
- Intermediate techniques including Many to Many, Monthly Stratification, and Loop and Group, and Sorting vs. Pre-Sorting
- Best Practices in Advanced ACL Scripting
- Creating Application Menus and developing interactive scripts
Date: June 19, 2012
Time: 11:00 AM- 1:00 PM (Eastern, GMT -0500)
CPE: 2 Credits are available for attending the seminar which are awarded
based on a 50-minute hour.
Program Level / Prerequisites and
Advance Preparation: Basic / None
Basic Delivery Method: Group Internet Based
Recommended Category: Specialized Knowledge and Applications
Cost: $89
JULY 2012
8. Data Manipulation in ACL - All commands under the Data menu item in ACL July 24
Once data has been imported into ACL, the next step is to manage the data and prepare the data for meaningful analysis. This course will show you how to pull the right data together as well as be able to filter and view information in a results-oriented way. This course will work off the concepts learned in the original Data Manipulation in ACL course and will apply techniques to intermediate examples.
Date: July 24, 2012
Time: 11:00 AM- 1:00 PM (Eastern, GMT -0500)
CPE: 2 Credits are available for attending the seminar which are awarded
based on a 50-minute hour.
Program Level / Prerequisites and
Advance Preparation: Basic / None
Basic Delivery Method: Group Internet Based
Recommended Category: Specialized Knowledge and Applications
Cost: $89
SEPTEMBER 2012
9. Sampling Data in ACL - All Techniques September 12, 2012
This session will explain selection techniques of sample items which may be based on 100% testing of data tests or a statistical sample. All ACL sampling techniques will be explained, and when each may best be used, including:
- Record Samples (Random, Fixed Interval)
- Monetary Unit Samples
- Stratified Samples (including explaining a provided script to help create a stratified sample)
- Other Sampling approaches
Date: September 12, 2012
Time: 11:00 AM- 1:00 PM (Eastern, GMT -0500)
CPE: 2 Credits are available for attending the seminar which are awarded
based on a 50-minute hour.
Program Level / Prerequisites and
Advance Preparation: Basic / None
Basic Delivery Method: Group Internet Based
Recommended Category: Specialized Knowledge and Applications
Cost: $89
10. Statistical Analysis in ACL - All commands under the Analyze menu item in ACL - Part 2 - September 27
This will work off the concepts learned in the original Statistical Analysis in ACL course held in 2012 and will apply techniques to intermediate examples.
Date: September 27, 2012
Time: 11:00 AM- 1:00 PM (Eastern, GMT -0500)
CPE: 2 Credits are available for attending the seminar which are awarded
based on a 50-minute hour.
Program Level / Prerequisites and
Advance Preparation: Basic / None
Basic Delivery Method: Group Internet Based
Recommended Category: Specialized Knowledge and Applications
Cost: $89
11. Advanced ACL Scripting October 9
Continue building on skills learned in Basic Script Writing in ACL by moving to advanced techniques for script writing. Working with groups, interactive scripts, and script menus are covered in this course that takes the basic ACL Script skills to the next level.
The specific learning topics are:
- Intermediate techniques including Many to Many, Monthly Stratification, and Loop and Group, and Sorting vs. Pre-Sorting
- Best Practices in Advanced ACL Scripting
- Creating Application Menus and developing interactive scripts
Date: October 9, 2012
Time: 11:00 AM- 1:00 PM (Eastern, GMT -0500)
CPE: 2 Credits are available for attending the seminar which are awarded
based on a 50-minute hour.
Program Level / Prerequisites and
Advance Preparation: Basic / None
Basic Delivery Method: Group Internet Based
Recommended Category: Specialized Knowledge and Applications
Cost: $89
NOVEMBER 2012
12. Completing a GL Audit with ACL November 14, 2012
Using case studies and sample data / scripts, basic to intermediate ACL techniques will be discussed for completing a year end audit of journal entry postings in the general ledger.
Date: November 14, 2012
Time: 11:00 AM- 1:00 PM (Eastern, GMT -0500)
CPE: 2 Credits are available for attending the seminar which are awarded
based on a 50-minute hour.
Program Level / Prerequisites and
Advance Preparation: Basic / None
Basic Delivery Method: Group Internet Based
Recommended Category: Specialized Knowledge and Applications
Cost: $89
Questions, complaint resolution, and refund policy
If you have any questions regarding the course, our administrative and complaint policies, or were not satisfied with this course and would like a refund of your seminar fee, please contact:
Richard B. Lanza,
President of Cash Recovery Partners, via the following means:
Phone: 201-650-4150
Fax: 973-270-2428
Email: rich@auditsoftware.net
Address: PO Box 31, Lake Hopatcong, NJ 07849
Cash Recovery Partners, LLC is registered
with the National Association of State Boards of Accountancy (NASBA) as
a sponsor of continuing professional education on the National Registry
of CPE Sponsors. State boards of accountancy have final authority on the
acceptance of individual courses for CPE credit. Complaints regarding
registered sponsors may be submitted to the National Registry of CPE
Sponsors through its website:
www.learningmarket.org.
ABOUT TRUST ONLINE |