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

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

You get all the content covered in Mastering QuickBooks for Accountants Level 1, Mastering QuickBooks for Accountants 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 for Accountants Level 1. This course is the foundation that you’ll build on with Mastering Accounting Basics and Mastering QuickBooks for Accountants 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 Desktop for Accountants Level 1
Getting Started
Setting up your client's data files
Moving around QuickBooks...EFFICIENTLY
Everyday Client 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
Understanding QuickBooks financial statements
Setting up the Chart of Accounts
Changing and fixing the Chart of Accounts
Applying Cash vs. Accrual accounting in QuickBooks
Using general journal entries
Entering reversing journal entries
Creating and using subaccounts
Using the Company Snapshot
Special Features for Accountants & Bookkeepers
Supporting and understanding the different versions of QuickBooks
Introduction to the Accountant version of QuickBooks
Using the toggle feature to simulate your client's QuickBooks
QuickBooks journal entries: understand the unique quirks
Modifying your client's Chart of Accounts
Creating customized financial statements using the Intuit Statement Writer
Combining financial statements
Using the working trial balance feature
Finding (and stopping) changes to client financial statements
Using the Employee Organizer
Running reports from the Employee Organizer
Using the employee regulations guide
Multi-user QuickBooks in Enterprise Solutions: Assigning the administrator, creating roles, setting access levels, and adding new users
Working with the audit trail in Enterprise Solutions
Setting up your client's 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
Using petty cash
Setting up your client's multi-user QuickBooks
Password protecting QuickBooks
Updating your client's QuickBooks
Working with Microsoft Word and Microsoft Excel
Closing the client's books
Finding transactions quickly and other time saving features
Working with the Accountant's Copy feature
Protecting your client's 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
Setting up automatic transactions (memorizing transactions)
Using credit cards
Mastering QuickBooks Desktop for Accountants Level 2
Customizing QuickBooks for Your Client
Modifying important preferences
Customizing your client's 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 typical 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 1099s 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
Completing setup: completing lists, setting up payroll
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
Special payroll deductions and payments
Preparing and adjusting W-2s
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
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 client's file
Remote access (accessing a 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
Verifying and rebuilding 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
Working with Clients
Common client mistakes and their fixes
Closing the books
Getting information to and from your client
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 you'll need as the accountant
What you REALLY need to know to become an advanced user!
Little known power features in all areas of QuickBooks
More Features for Accountants
Correcting common mistakes with undeposited funds
Changing account types to correct client financial statements
Using the Client Data Review feature to review a client's file
Converting your clients from Quicken
Using the Fixed Asset Manager: Setting up for a new client, adding assets, and calculating depreciation
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.