Self-paced training
Ultimate Enterprise
What's included
What you'll learn

5 Full courses – over 33 hours of practical knowledge, shortcuts, tips, and tricks that you can apply immediately!

You get all the content covered in Mastering QuickBooks Enterprise Solutions Level 1, Mastering QuickBooks Enterprise Solutions Level 2, Mastering Accounting Basics, Mastering Payroll, and Mastering Word & Excel for QuickBooks Desktop. To see a detailed list of what’s covered in each course, see the What you’ll learn tab to the right.

Includes a 241-page PDF manual

We recommend you begin with the basics covered in Mastering QuickBooks Enterprise Solutions Level 1. This course is the foundation that you’ll build on with Mastering Accounting Basics and Mastering QuickBooks Enterprise Solutions Level 2. And because it’s so important to your foundation, you’ll receive a work manual, so you can follow along and take notes as you go.

Free updates – for life!

QuickBooks Desktop changes every year. But you don’t have to worry about outdated training. Unlike other software training that eventually becomes outdated when the software changes, your purchase includes all the updates we make in the future. Rest assured knowing you have the latest and greatest content…at no additional cost.

Full High Definition video

The courses are all filmed in crystal clear HD, so you don’t miss any details. Expand the viewing area to full screen or watch it in a smaller format…either way, you can easily follow the instructions and see every detail.

Access to all the courses: Anywhere. Anytime.

You can view the courses as many times as you want from any device connected to the internet.

Everything you need to know to master QuickBooks “A to Z,” and understand the “behind the scenes” accounting basics

Whether you love bookkeeping or you’re a “reluctant” bookkeeper, being QuickBooks Confident means coming to work each day with the confidence that you know what to do, how to do it, and most importantly, WHY you need to do it! All this with the confidence that you’re saving time applying the tips, tricks, and shortcuts you discover.

Mastering QuickBooks Enterprise Solutions Level 1
Getting Started
Setting up your data files
Moving around QuickBooks...EFFICIENTLY
Everyday Transactions
Selling: invoices, sales receipts, payments, deposits, credit memos, statement charges, linking to 3rd party software, and customer statements
Buying: bills, bill payments, checks, bills vs. checks, and credit memos
Inventory: purchase orders, receiving items, adjusting inventory
Sales Taxes: setting up, adjusting, paying, and reporting sales taxes
Banking: reconciling bank accounts and locating discrepancies
Special Transactions
Giving and receiving refunds
Voiding vs. deleting a check
Applying credit memos
Working with Lists
Special "Window" tricks
Cleaning up lists (delete, hide and merge)
Sorting and customizing lists
"Collapsing" financial statements
Preparing P&L by month, or as a percent of income
Financial Statements
Really understand QuickBooks financial statements
Setting up the Chart of Accounts
Changing and fixing the Chart of Accounts
Cash vs. Accrual accounting
Using general journal entries
Creating and using subaccounts
Combining financial statements
Setting up payroll
Entering year-to-date payroll information
Setting up employees
Creating payroll items
Tracking and invoicing time
Processing paychecks
Modifying paychecks
Making tax deposits
Preparing tax forms
Summarizing payroll data in Excel
Working with Reports
Adding, deleting, resizing, and reordering columns
Filtering and formatting reports
Saving reports and creating memorized report groups
Advanced Features
Password protecting QuickBooks
Updating QuickBooks
Working with Microsoft Excel
Closing the books
Finding transactions quickly and other time saving features
Working with the Accountant's Copy feature
Protecting your QuickBooks data
Tips & Tricks
Keyboard shortcuts
Tailoring company preferences
Creating custom invoices and other forms
Adding logos and custom fields to forms
Tricky Transactions
Using online banking
Handling bounced checks...easily
Entering customer down payments/deposits
Creating automatic transactions (memorizing transactions)
Using credit cards
Enterprise Solutions Features
Assigning the administrator
Creating roles
Setting user access levels
Adding new users
Working in different user “modes”
Using inventory management features
Working with special report features
Mastering QuickBooks Enterprise Solutions Level 2
Customizing QuickBooks
Modifying important preferences
Customizing your Home Page
Modifying the Icon Bar
Creating and using custom fields
Using account numbers
Using classes (for departments, locations, etc.)
Sales Transactions, Tricks, and Workarounds
Setting up Price Levels
Sales Orders/backorders
Batch invoicing
Invoicing for billable costs
Complex sales tax situations
Creating and using estimates
Progress invoicing
Finding and fixing common errors in accounts receivable
Two methods for handling customer deposits
Managing collections
Writing off bad debts
Customer under- and over-payments
Transferring customer credits
Working with multiple accounts receivable accounts
Entering retail sales
Purchase Transactions, Tricks, and Workarounds
Purchasing and accounting for fixed assets
Entering company loans with the Loan Manager
Lines of credit
Typical bill payment errors
Preparing 1099’s at year-end
Employee and owner purchases
Prepaid expenses
Vendor deposits
Vendor refunds
Barter transactions
Voiding prior period checks
Using the Cash Flow Projection Tool
Items & Inventory
Expenses vs. Items
Inventory limitations
Inventory adjustments
Creating group items
Working with inventory assemblies
Units of measure
Advanced Tricks
When should you start over with a new file?
The limitations of QuickBooks
Handling bank reconciliation errors
Use multiple currencies
Fixing errors in all areas of QuickBooks
Completing Set Up
Account setup: opening balances, special accounts, and opening balance equity
Two methods for entering transaction history
Checking the setup
Payroll Transactions, Tricks, and Workarounds
Correcting the setup of payroll items
Adding difficult payroll items
Using payroll effectively for job costing
Voiding/Reprinting paychecks
Handling special payroll deductions and payments
Preparing and adjusting W-2s
Tracking employee loans
Setting up and tracking workers compensation insurance
Net to Gross paycheck calculations
Mastering QuickBooks Reporting
Advanced report customization
Report types in QuickBooks
Importing and exporting reports
Using special fields to improve reports
Troubleshooting reports filters
Memorizing reports and creating report groups
Adding reports to the Icon Bar
Powerful techniques for modifying reports in Excel
Generating custom summary and transaction reports
Graphing QuickBooks data in Excel
Budgets and forecasts
Combining financial statements
Extending the QuickBooks database
Using advanced fields for reports (customer type, custom fields, and more!)
Unlocking the Power of QuickBooks
Deleting and archiving old transactions in your file
Remote access (accessing your company file through the internet)
Automating backups
Tricks to make QuickBooks run faster and more efficiently
Corrupt data files: how & why it happens, and what to do
Verify and rebuild company files
Importing and Exporting
Exchanging data between QuickBooks files
Importing and exporting lists
Importing and exporting customized forms
Using reports with multiple company files
Exchanging data between QuickBooks and other programs
Working with integrated applications
Using special Excel import feature
Secrets Your Accountant Should Know
Common mistakes and their fixes
Closing the books
Getting information to and from your accountant
Finding changes made to closed periods
Understanding and using retained earnings
Discovering quirks of QuickBooks journal entries
Using reversing journal entries
Understanding year-end procedures
Using the Audit Trail and other reports to find errors
Cash basis financial statements
Special reports for your accountant
What you really need to know to become an advanced user!
Little known power features in all areas of QuickBooks
Mastering Accounting Basics
Accounting Basics
Defining accounting from the small business' perspective
Why do you need accounting?
Financial statements: what are they?
What is an account?
Double entry accounting and how it applies to QuickBooks
Debits and Credits: The essence of accounting
Accounting Principles
Introduction to Accounting Principles
The Reporting Principle
The Reliability Principle
The Comparability Principle
The Cost Principle
The Revenue Principle
The Matching Principle
Applying the principles
Accounting Basics in QuickBooks
The Balance Sheet and Profit & Loss Statement
Working with account types
Setting up the Chart of Accounts
Management reporting vs. financial reporting
Working with subaccounts
Techniques to review account detail
Understanding debits/credits in common QuickBooks transactions
Reviewing Numbers for Accuracy
Basic review techniques
Using QuickZoom as an investigative tool
Reconciling accounts to external documentation
Verifying numbers on key reports
Checking Accounts Receivable, Accounts Payable, and Inventory balances
Analyzing and Interpreting Data
Basic financial interpretations
Analyzing business trends
Interpreting variable expenses
Understanding and using key financial ratios
The Accounting Cycle
What is the accounting cycle, and why is it important?
Daily accounting tasks
Weekly accounting tasks
Pay period accounting tasks
Monthly accounting tasks
Quarterly accounting tasks
Annual accounting tasks
Closing the books
Restricting access to closed periods
Working with Your Accountant
Speaking the same language as your accountant!
Creating a client/accountant agreement
Methods for getting information to your accountant
Accountant's Copy process
Special reports for your accountant
More Accounting
Using account numbers
Setting up classes to segment financial statements
Budgeting and planning in QuickBooks
Cash vs. Accrual accounting
Understanding and using Retained Earnings
Year-end closing entries
Finding prior year changes
Valuable Resources Included with the Course:
Glossary of Accounting Terms
QuickBooks Keyboard Shortcuts List
Summary of Account Types (and the financial statements they flow to)
A Debits and Credits "Cheat Sheet"
Financial Ratios List (and how they're calculated)
Sample Tax Calendar
List of Record-Keeping Requirements (as recommended by The IRS)
Periodic Activities Checklist (avoid overlooking important tasks!)
Year-end Closing Checklist
Step-by-Step Summary of Exchanging Data with your Accountant
Help Guide for Creating a Client/Accoutnant Agreement (and assigning responsibilities)
Backup Log (to schedule and monitor timely backups)
Mastering QuickBooks Payroll
Payroll...Before You Begin
The top 10 payroll mistakes to avoid
Know your payroll risks and responsibilities
Standard forms for new employees
Contractors vs. employees (when to use each)
Set Up
Information you need to get started
Using the Payroll Setup Wizard
Setting up employees
Adding compensation types (hourly, salary, bonus, etc.)
Setting up employee benefits (insurance, reimbursements, etc.)
Adding retirement benefits like 401(k) plans
Adding PTO (sick & vacation time)
Setting up federal taxes (Income tax, FICA, etc.)
Setting up the right taxes for your state
Reviewing your payroll set up
Entering payroll history
Customizing payroll
Creating payroll schedules
Understanding and adding payroll items
Creating unique and special payroll items
Running Payroll
Entering employee time
Running employee productivity reports
Preparing employee paychecks
Printing & modifying paychecks
Printing employee paystubs
Running payroll reports
Exporting payroll data to Microsoft Excel
Taxes & Tax Forms
Making tax deposits
Paying other payroll liabilities
Using E-file/E-pay to file forms and make payments electronically
Correcting & adjusting payroll liabilities
Preparing & filing your quarterly & annual tax returns (federal and state)
Special Transactions
Entering "net to gross" paychecks
Running unscheduled & termination paychecks
Handling unexpected changes during the year
Voiding paychecks
Tracking & paying employee commissions
Custom liability payments
Depositing tax refunds
Advanced Transactions
Handling unique expenses (e.g. employee & employer contributions to insurance)
Mapping payroll items to get meaningful financial statements
Job costing payroll
Tracking employee loans
Handling wage garnishments
Paycheck issues
Tracking payroll by "class"
Mastering Word & Excel
Excel: The Basics
What are spreadsheets and workbooks?
Moving around in Excel
Understanding the Excel interface
Getting Help
Tips for exporting to QuickBooks
Working with Excel & QuickBooks Together
Sending reports to a new workbook
Transferring reports to an existing workbook
Moving and naming worksheets
Aligning, deleting, and inserting worksheets
Changing report headings
Selecting, moving, merging, and editing cells
Deleting columns and rows
Formatting in Excel
Creating the look you want 
Adding borders 
Number styles: Accounting vs. Currency
Using the Format Painter
Adding tab colors and comments
Freezing Panes (column and row heading show while scrolling)
Understanding date formats
Calculations and Formulas in Excel
Relative vs. absolute references
Creating and copying formulas 
Array formulas
3-D formulas
Using the formula Error Checking feature
Summarizing and Analyzing Data in Excel
How to analyze numbers in Excel
Using the Count, Average, and Mean functions
Collapsing Excel reports (to hide and show relevant data)
Using the Auto-Outline feature
Filtering reports in Excel
Grouping and sorting data
Pivot Tables
Using the What-If Analysis tool
Real World Applications for Excel
Creating an amortization schedule
Building an expense reimbursement form 
Speeding up bank reconciliations 
Creating graphs of QuickBooks data (in Excel!)
Importing lists from Excel into QuickBooks
Importing IIF files into QuickBooks 
Customizing Excel
Creating personalized toolbars 
Building your own menus
Changing the screen layout
Password protecting Excel files 
Setting the default format 
Shortcuts and Saving Time in Excel
Creating macros to automate Excel steps
Mouse Shortcuts
Keyboard Shortcuts
Printing tips and tricks
Word: The Basics
What are files and templates?
Moving around in Word
Understanding the Word interface
Using different layout views
Getting Help 
Working with Word and QuickBooks Together
Using the QuickBooks to Word link 
Creating a letter from scratch
Converting an existing Word document 
Modifying Word letter templates
Creating invoice cover letters 
Fixing “missing information” errors 
Word Techniques
Working with Word documents 
Understanding document compatibility issues 
Setting the Auto Recover options
Entering, selecting, dragging, dropping, cutting, copying, pasting, and deleting in Word 
Using the built-in spelling and grammar checkers
Formatting in Word
Understanding and using the Home tab
Customizing fonts 
Highlighting fonts 
Using the format painter feature 
Creating and using bulleted and numbered lists 
Setting tabs, tab stops, and indents 
Creating and using styles and style sheets 
Adjusting margins 
Setting page breaks 
Printing word documents
Working with Document Objects in Word
Adding a company logo to letters
Re-sizing and re-positioning objects
Creating watermarks 
Using Word symbols 
Using and modifying clip art and other pictures 
Working with tables 
Importing tables from Excel
Inserting files
Adding “Hyperlinks” to documents, web pages, and spreadsheets 
Customizing Word
Creating smart tags to use Word information in other programs
Creating personalized toolbars
Building your own menus 
Changing the screen layout 
Password protecting files 
Setting the default format 
Tracking changes in Word 
Shortcuts and Saving Time
Using keyboard shortcuts to find information
Other keyboard shortcuts 
Auto-correcting Word documents
Using different languages 
Creating and using Word templates
How does the OnDemand class work?
After you place your order, you receive log-in credentials for the course via email. Follow the link in the email, type your username and password, and start learning!
Do you offer a money-back guarantee on your OnDemand training?
Absolutely! If you are not completely satisfied with the training, send us an email, or call us within 30 days, and you will receive a full refund (minus a processing fee of $15). We stand behind our classes. No hassle. No question.
Are the self-paced courses hands-on?
If you have QuickBooks installed on your computer, you can pause the class and switch to QuickBooks to practice hands-on.
Do I need QuickBooks on my computer?
No. You can view the training on any device with an internet connection. Anytime, anywhere.

No risk, money-back guarantee

If you're not satisfied for any reason, return your materials to the instructor by the end of the first day of class and you will receive a full refund. See details
Chat with us

QuickBooks training near your location

United States

Cancelation and refund policies

Cancelation policy We'll refund your tuition (less a $45 processing fee) if you email us 5 (five) days prior to the class. Regrettably we have to be strict about this policy because we finalize our room and set up fees with the hotel 5 days before class begins.

Refund policy If you're not satisfied for any reason, return your materials to the instructor by the end of the first day of class and you will receive a full refund. We do not provide refunds if you do not attend class. We will, however, keep your credit so that you may attend another class in the future.