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

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

You get all the content covered in Mastering QuickBooks Level 1, Mastering QuickBooks for Construction, 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 Level 1. This course is the foundation that you’ll build on with Mastering Accounting Basics and Mastering QuickBooks for Construction. 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 Level 1
Getting Started
Setting up your company
Moving around QuickBooks efficiently
Customize your Home Page
Getting help
Everyday Transactions
Selling: invoices, sales receipts, payments, deposits, credit memos, statement charges, and customer statements
Buying: bills, bill payments, checks, bills vs. checks, and credit memos
Inventory: purchase orders, receiving items, and adjusting inventory
Sales Taxes: setting up, adjusting, paying, and reporting sales taxes
Banking: reconciling bank accounts, locating discrepancies, and online banking
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
Showing P&L by month, or as a percent of income
Understanding Accounting
Really understanding your 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
Using the Company Snapshot feature
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
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 QuickBooks on a network (multi-user)
Password protecting QuickBooks
Updating QuickBooks
Working with Microsoft Word and 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
Mastering QuickBooks for Construction
Getting Started with QuickBooks
Creating a new data file
Setting up customers and jobs
Accounts: opening balances, special accounts, and opening balance equity
Completing setup: completing lists and payroll setup
Two methods for entering transaction history
Checking the setup
Job Costing
Understanding items: the core of job cost tracking
Guidelines for getting job cost information from QuickBooks
Setting up items for accurate job costing
Tracking committed costs
Job costing payroll: wages, benefits, and taxes
Allocating owner and partner time to jobs
Running job profitability reports
Tracking company's gross margin on jobs
Using the Job Costing Center
Running job status reports
Two methods for tracking Work-in-Progress
Estimating and Invoicing
Estimating jobs in QuickBooks
Estimating fixed priced jobs
Memorizing estimates (how and why)
Progress invoicing against estimates
Three methods to enter and automate change orders
Batch invoicing
Invoicing construction draws
Using billing rate levels
Sales Transactions, Tricks, and Workarounds
Entering statement charges
Working with multiple accounts receivable accounts
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
Tracking cost and sales of spec homes
Purchase Transactions, Tricks, and Workarounds
Vendor deposits
Preparing 1099s at year-end
Tracking liability certificates
Entering employee and owner purchases
Prepaid expenses
Vendor refunds
Barter transactions
Voiding prior period checks
Automating purchase orders for jobs
Payroll Transactions, Tricks, and Workarounds
Allocating benefits/taxes to jobs
Job costing salaried employees
Using payroll effectively for job costing
Handling special payroll deductions and payments
Tracking employee loans
Setting up and tracking workers' compensation insurance
Allocating owners' cost to jobs when they don't receive a paycheck
Mastering QuickBooks Reporting
Advanced report customization
Report types in QuickBooks
Importing and exporting reports
Using special fields to improve reports
Troubleshooting report 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
Creating budgets and forecasts
Combining financial statements
Extending the QuickBooks database
Using advanced fields for reports (job type, custom fields, and more!)
Reports for Job Cost
Gross margin reports for open and closed jobs
Estimate vs. actual reports
Running unpaid/paid bills reports for jobs
Job Cost by Vendor reports
Time tracking reports
Even more job cost reports!
Customizing QuickBooks
Modifying important preferences
Customizing the home page
Modifying the Icon Bar
Creating and using custom fields
Using account numbers
Using classes (for departments, locations, etc.)
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
Creating reports from multiple company files
Exchanging data between QuickBooks and other programs
Working with integrated applications
Using the 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 the 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 powerful 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
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
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.