1 / 98

FTA Technology Conference

FTA Technology Conference. Creation of Audit Applications with Microsoft Office 97 Software. North Carolina Department of Revenue. Introduction of Speakers. James Mclain, Software Development Specialist, Field Examination Section Jerry Coble, Workload Management Specialist.

Gideon
Download Presentation

FTA Technology Conference

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. FTATechnologyConference Creation of Audit Applications with Microsoft Office 97 Software North Carolina Department of Revenue

  2. Introduction of Speakers James Mclain, Software Development Specialist, Field Examination Section Jerry Coble, Workload Management Specialist

  3. Presentation Objectives • Assessment of NCDOR • History of Hardware and Software Utilization by Field Examinations • Explore Software Development • MS Excel 97 • MS Access 97 • MS Word 97

  4. Assessment of North Carolina Department of Revenue

  5. NC Department of Revenue Field Examinations 175 Field Employees (Auditors & Staff) • 13 In-state Field Audit Offices • 20 Interstate Field Audit Offices

  6. History Software and Hardware Development

  7. Hardware and Software • Pre 1988 - No computers were in use by Field Examination personnel. Audit reports were prepared manually and a variety of report designs were used by the audit staff.

  8. Hardware and Software • 1988 - The Field began to experiment with computers. The first computers tested were dual floppy drive laptops. The software was Professional File, Write, and a short time later Professional Plan .

  9. Hardware and Software • Basic databases were developed by auditors for use in creating audit working papers. • Later a Development and Training Team was created to aid auditors with software development.

  10. Hardware and Software • 1996 - We went to a Windows 3.11 platform and Microsoft Excel, Word and Access. • This was the first time all auditors had same hardware with a Dell Latitude 75 laptops with docking station & 14” monitor.

  11. Today’s Hardware • Dell Latitude CPI D266XT laptop • 64 RAM, Pentium II, 4.3 GB hard drive • CD-ROM drive & 1.44 MB Floppy drive • Docking Station & 17” Monitor • Desktop Dell P6400 (100MHz FSB) • 64 RAM, 6.4 GB hard drive, • CD-ROM drive & 1.44 MB Floppy drive • 17” Monitor • Server for each In-State office • 31.8 GB, Compaq tower

  12. Tax Schedules Audited by Field Examinations • Sales and Use Tax • ASTS • White Goods Disposal Tax • Scrap Tire Disposal Tax • Utilities Sales Tax • Motor Vehicle Lease / Rental Tax • Dry-Cleaning Solvent Tax

  13. Tax Schedules Audited by Field Examinations • Individual Income Tax • Corporate Income and Franchise Tax • Individual Income Tax Withholding • Tobacco and Soft Drink Tax • Privilege Tax • Alcohol BeverageTax • Inheritance & Gift Tax

  14. Software Objectives • Create Applications for Use by Field Auditors for the Completion of Audits • Aid the Entry of Audit Data Into the Integrated Tax Administration System (ITAS) • Provide a Basic Software Package That Allows Flexibility in Conducting Audits on a Multitude of Tax Schedules

  15. Implementation Process • Convert Audit Applications From MS Excel 5.0 to MS Excel 97 • Incorporate New Features of MS Excel 97 Into the Converted Audit Applications • Testing of the Converted Applications • Train the Key Users • Train Remaining Field Audit Personnel

  16. Microsoft Windows NT Workstations 4.0

  17. The Field Auditor’s Desktop

  18. Special Customization for Auditors

  19. The Field Auditor’s Desktop Custom Help for Field Auditors

  20. Software Development

  21. The Field Auditor’s Desktop Microsoft Office 97 • Microsoft Excel 97 • Microsoft Word 97 • Microsoft Access 97

  22. Microsoft Excel 97

  23. Audit Applications • Sales and Use Tax • Sales and Use Tax - 2% and 3% State • Mecklenburg Transit Tax Sales & Use Tax Applications

More Related