|
Federation of Tax Administrators | Multistate Tax Commission |
![]() |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
202-624-5890 |
444
North Capitol St., NW., Washington, D.C. 20001 |
202-624-8699 |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Audit and Computer Technology Workshop
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 3:00 p.m.–6:00 p.m. | Registration |
| 5:30 p.m.–7:00 p.m. | Opening Reception with light hors d’oeuvres |
| 8:00 – 8:10 a.m. | Welcome and Opening Comments |
| 8:10 – 9:10 a.m. | Data Downloads of Records (Methods of transfer, acceptable formats, and problems encountered) Thad Cable, North Carolina Dept. of Revenue (invited) |
| 9:10 – 10:10 a.m. | Data Screening in Access and Excel (Techniques to correct mainframe conversion errors, convert date fields, remove window dressing, identify duplicates, etc.) |
| 10:10 – 10:30 a.m. | BREAK |
| 10:30 – 11:30 a.m. | Reconciling Taxpayer's Electronic Data (Verifying the completeness and accuracy of data downloads with taxpayer’s books and records)
Dan Olivero, Steve Entrekin and Jean Presson, Illinois Dept. of Revenue |
| 11:30 a.m. – 1:00 p.m. | LUNCH (on your own) |
| 1:00 – 2:15 p.m. | Demonstration of Sesam Software |
| 2:15 – 2:50 p.m. | Stratification Techniques (Comparing the Cumulative Square Root of the Frequency method with other alternatives, determining how many strata ranges are sufficient, and evaluating the stratification programs that are included in various software products) |
| 2:50 – 3:10 p.m. | BREAK |
| 3:10 – 4:00 p.m. | Automating the Sampling Design Process (Simplifying the routine to calculate sample sizes, stratifying the sampling frame, and the random selection of transactions using ACL, Access, Excel, and other software programs) |
| 4:00 – 5:00 p.m. | Computer Assisted Audits (CAA) on Small Taxpayers (Methods of simplifying the CAA process when auditing smaller populations with less than 50,000 total transactions for the entire audit period) |
Tuesday, October 4
| 8:00 – 9:00 a.m. | Pursuing Electronic Records for Multiple Tax Types (Examples of electronic records received from taxpayers that expedited the audit process for tax types other than Sales and Use Tax—such as Corporate Franchise, Employer Withholding, and Personal Property Tax) |
| 9:00 – 10:00 a.m. | Exporting "as filed" Data from Tax Software Programs (Reducing inputting of data and eliminating transposition errors by importing information and uploading this data on auditor’s worksheets from tax return data that was prepared from proprietary software programs) |
| 10:00 – 10:20 a.m. | BREAK |
| 10:20 – 11:00 a.m. | Audit Inventory and Case Management Systems (Demonstration of software products that address these issues as well as assist in the audit selection process) |
| 11:00 – 12:00 Noon | Web or CD Based Training for Staff Development (Training alternatives and advances in software applications to assist with web and CD based development) |
| 12:00 Noon – 1:30 p.m. | LUNCH (on your own) |
| 1:30 – 2:15 p.m. | Data Warehousing for Income Tax (Use of data for filing compliance, especially in the area of EITC, withholding and itemized deductions. Includes a demo of a system that New York developed that utilizes historical data and predictive modeling to identify potential areas of "Questionable Activity" by taxpayers) |
| 2:15 – 3:15 p.m. | Data Mining for Audit Selection (Discussion of how states have used this technique to improve the audit selection process) |
| 3:15 – 3:30 p.m. | BREAK |
| 3:30 – 4:30 p.m. | Developing & Maintaining a CAA Group in a Small State(How to initiate and maintain a computer assisted audit group and implement a statistical sampling program within a small state with limited staff and resources) |
| 4:30 – 5:00 p.m. | Reference Databases for Researching Laws & Policies(Demonstration of the dtSearch computer program that the State of Illinois maintains to enable their audit staff to quickly access laws, administrative rules, court cases, directives, information releases, policies and procedures) |
| 8:00 – 9:15 a.m. | Remote Access (Wireless and Broadband) VPN, etc.(Presentation of a system that has been implemented to connect field auditors to a Department of Revenue’s LAN system via high-speed remote access) |
| 9:15 – 10:15 a.m. | Using Internet Research to Assist in the Audit Process(Informative web sites and useful techniques to assist auditors in obtaining or verifying information that can prove beneficial within their audits) |
| 10:15 – 10:35 a.m. | BREAK |
| 10:35 – 11:35 a.m. | Auditing Taxpayer Records Stored in SAP Software (Suggestions on how to utilize this software program to search and extract specific data required to conduct an electronic tax audit) |
| 11:35 a.m. – Noon | Complete Evaluations and discuss the direction and frequency of future workshops |
| 12:00 Noon | ADJOURN |