Course Description

This advanced course is designed for those who are experienced with QuickBooks and who are looking for insight on how to deal with the more difficult issues that advanced users often face.  The course includes coverage of techniques and features of which even advanced users are often not aware as well as useful workarounds for common problems. 

Some of the key topics covered are the best ways to exchange QuickBooks data with others, inventory accounting issues and solutions, tracking and managing sales taxes, working with and resolving payroll issues, advanced financial and operational reporting matters, job costing, time tracking, and much more.  In addition, a detailed discussion on troubleshooting QuickBooks performance is included to ensure that your QuickBooks installation is operating at peak performance. If you are an experienced QuickBooks user and want to get more out of the product for your company and/or your clients, you need this course.

“Instructor gave excellent tidbits increasing my effectiveness with my clients! Very impressive!” C.M., CPA MO

“Great course. I am now knowledgeable enough to go back to my office and make some changes that will allow more effective use of our QuickBooks tools.” N.R., CPA WY

Course Information

CPE Credit: Recommended for 6 hours Accounting and 2 hours Specialized Knowledge and Applications

Instructional delivery method: Group-live demo and discussion using color computer projection – NOT a hands-on course

Prerequisites: Experience with QuickBooks

Program level: Advanced

Advanced preparation: None

Designed for: Accountants who use or support clients who use QuickBooks

Who should attend: Accountants in public practice and in private industry seeking a deeper and more thorough knowledge of QuickBooks software

Course Highlights

  • Describe and differentiate key techniques for exchanging QuickBooks data with others, including QuickBooks Accountants' Copy, Remote Access, and Portable Company Files and Backups; describe how Client Data Review and using the Working Trial Balance tool can streamline the process of managing changes to QuickBooks data files
  • Explain how to manage inventory in QuickBooks, including using Items, QuickBooks' Average Costing Methodology, working with Assembly Items, Purchasing and Receiving Inventory, Adjusting Inventory Quantities and Valuations, and Using Inventory Reports to Assist in Managing Inventory
  • Explain how to use QuickBooks in a job costing environment, including Creating and Managing Jobs, Working with Reimbursable Expenses, Creating Estimates and Change Orders, Invoicing for Jobs (including Progress Invoicing), Tracking Payroll to Jobs,  and Handling Retainage
  • Explain how to track and manage sales taxes in QuickBooks, including Establishing Sales Tax Preferences, Maintaining Sales Tax Items and Sales Tax Groups, Understanding Sales Tax Codes, Managing the Tax Status of Customers and Items, Entering Sales Tax Adjustments, and Remitting Sales Taxes
  • Explain how to work with QuickBooks payroll, including differentiating between various Payroll Subscriptions, Setting Up Payroll in QuickBooks, Running Payroll, Recording After-the-Fact Payroll, Using QuickBooks to Prepare Payroll Tax Returns, Adjusting Payroll Liabilities, and Accruing Workers' Compensation Liabilities
  • Describe different techniques for handling advanced reporting issues, including the Intuit Statement Writer, Using an ODBC Connection with QuickBooks, and Multi-company Reporting in QuickBooks
  • Describe techniques for integrating QuickBooks into various third-party applications, including Lacerte, ProSeries, WriteUp CS, UltraTax CS, ProSystem fx Write-Up, ProSystem fx Tax, and SmartVault

Dates & Locations

Event Date Location Sponsor Name
6/5/2012 LaVista, NE Nebraska Society of CPAs
8/2/2012 Phoenix, AZ Arizona Society of CPAs
8/10/2012 Roseland, NJ NJSCPA Education Foundation, Inc.
8/22/2012 West Columbia, SC South Carolina Association of CPAs
9/7/2012 Mobile, AL Alabama Society of CPAs
9/13/2012 Chicago, IL Illinois CPA Foundation
9/25/2012 Livonia, MI Michigan Association of CPAs
9/25/2012 Oklahoma City, OK Oklahoma Society of CPAs
9/27/2012 Brentwood, TN Tennessee Society of CPAs
10/19/2012 Brookfield, WI Wisconsin Institute of CPAs
11/1/2012 Bloomington, MN Minnesota Society of CPAs
11/8/2012 Louisville, KY Kentucky Society of CPAs