← Back to self-paced courses

QuickBooks Desktop Advanced

Beyond the Basics: Advanced QuickBooks Desktop Topics

Get confident with advanced QuickBooks Desktop training. Become a report expert and build on what you learned in QuickBooks Desktop for Beginners.

Course Content

07:00

Meet Your Instructor: Alanna

History-Reason for QB

Resources – ProAdvisors

Editions of QuickBooks

What QuickBooks Doesn’t Do

54:56

Should I Start Over?

Remove Transactions

Start a New File

Create a Company File

Advanced Setup – Intro

Advanced Setup – Company Information

Advanced Setup – Industry and Password

Advanced Setup – Sales Tax and Customer Orders

Advanced Setup – Vendor and Employee Transactions

Advanced Setup – Start Date Intro

Advanced Setup – Start Date & Accounts

Opening Balances – Intro

Opening Balances – Journal Entry

Special Accounts-Bank

Special Accounts-A/R Intro

Special Accounts – Accounts Receivable Accrual Basis

Special Accounts – Accounts Receivable Cash Basis

Special Accounts – Accounts Payable

Special Accounts – Credit Cards

Special Accounts – Equity Intro

Special Accounts – Manage Opening Balance Equity

Choose Payroll Service

Payroll Setup Interview

1 of 2

39:11

Preferences – Intro

Preferences – Access Steps and Explanation

Preferences – Remove or Add Icons/Change Color Scheme

Preferences – Change Default Accounts

Preferences – Start with Payee Field on Checks

Icon Bar – View or Hide Colored Icons

Icon Bar – Add Shortcut from Presets/Delete Icon

Icon Bar – Add Shortcut from Transaction

Icon Bar – Add Favorite Reports

Custom Fields – Intro

Custom Fields – Create

Custom Fields – QuickBooks Enterprise

Custom Fields on Reports

Account Numbers

Classes – Intro

Classes – Enable & Add

Classes – Profit & Loss by Class

Classes – Balance Sheet by Class

Classes – Use on Transactions

Classes – QuickBooks Enterprise

Mileage Tracking (QB 2023 or Later)

42:47

Items/Inventory

Expenses vs. Items

Inventory Limitations

Inventory Adjustments – Quantity

Inventory Adjustments – Value

Group and Assembly Items

Group Item – Intro

Group Item – Why

Group Item – Setup

Group Item – Use

Inventory Assembly – Intro

Inventory Assembly – Setup

Inventory Assembly – Accounting

Inventory Assembly – Process

Inventory Assembly – Build

When to Use Group vs. When to Use Assembly

Item Categories (QB Enterprise 2024 or Later)

Expiration Dates (QB Enterprise 2024 or Later)

Units of Measure – Preferences

Units of Measure – Set

Units of Measure – Assign

56:07

Sales Transactions

Estimates – Record

Estimates – Intro to Invoice Creation

Estimates – Create an Invoice Based on an Estimate

Price Levels – Intro

Price Levels – Setup and Define

Price Levels – Assign and Use

Price Levels – Per Item Price Level

Sales Orders – Intro

Sales Orders – Backorder

Sales Orders – Invoice from Sales Order

Sales Orders – Record a Possible Future Order

Sales Orders – Create a Sales Order from an Estimate

Sales Orders – Customize Sales Order Report

Sales Orders – Sales Order by Item Report

Statement Charges – Intro

Statement Charges – Apply Charge to Customer

Batch Invoicing – Intro

Batch Invoicing – Customer Information Setup

Batch Invoicing – Create Customer Billing Group

Batch Invoicing – Choose Items and Create Invoices

Multi-Customer Email Selection (QB 2022 or Later)

Multiple Sales Tax Rates – Intro

Multiple Sales Tax Rates – Record Sale

1 of 2

63:20

Transfer Customer Credits (QB 2018 or Earlier) – Create Clearing Account

Transfer Customer Credits (QB 2018 or Earlier) – Remove Credit from Original Job

Transfer Customer Credits (QB 2018 or Earlier) – Apply Credit to New Job

Multiple Accounts Receivable Accounts – Intro

Multiple Accounts Receivable Accounts – Create and Use Accounts

Automated Customer Statements (QB 2021 or Later)

Schedule Automated Customer Statements (QB 2021 or Later)

Retail Sales – Challenges of Daily Sales Entry

Retail Sales – Workaround for Daily Sales Entry

Retail Sales – Item Setup

Retail Sales – Paid Outs

Retail Sales – Credit Card Payments

Retail Sales – Over/Short

Retail Sales – Deposits

NSF Checks – Intro

NSF Checks – Mark Check as Bounced

NSF Checks – Transactions QuickBooks Creates

NSF Checks – Review Customer Statement

2 of 2

58:50

Purchase a Fixed Asset – Intro

Purchase a Fixed Asset – Set up Fixed Asset Accounts

Purchase a Fixed Asset – Set Up Fixed Asset Item List (Optional)

Purchase a Fixed Asset – Record the Purchase/Financing of a Fixed Asset

Loan Manager – Intro

Loan Manager – Set Up Liability Account

Loan Manager – Deposit Loan into Bank Account

Loan Manager – Schedule Loan Payments

Loan Manager – Record Loan Payment

Loan Manager – Track Loan Payment Details

Line of Credit – Intro

Line of Credit – Set Up Liability Account

Line of Credit – Transfer Funds

Line of Credit – Pay Down Balance

Receipt Management (QB 2021 or Later)

Reconciliation Balance Discrepancy – Intro

Reconciliation Balance Discrepancy – Why

Reconciliation Balance Discrepancy – Locate Discrepancies Tool

Reconciliation Balance Discrepancy – Find Problems from Register

Bill Payment Errors – Intro

Bill Payment Errors – Delete Bill

Bill Payment Errors – Delete Check and use Pay Bills Window

Online Bill Payment (QB 2022 or Later)

Bill Payment Stub (QB 2022 or Later)

1 of 2

55:18

Advanced Purchases

Employee/Owner Purchases – Set Up Liability Account

Employee/Owner Purchases – Record Purchase

Employee/Owner Purchases – Reimburse for Purchase

Prepaid Expenses – Intro

Prepaid Expenses – Set Up Asset Account

Prepaid Expenses – Record Prepayment

Prepaid Expenses – Set Up Monthly Journal Entry to Expense Insurance

Vendor Deposits – Intro

Vendor Deposits – Set Up Asset Account

Vendor Deposits – Record Deposit to Vendor

Vendor Deposits – Apply Deposit

Support Schedule – Intro

Support Schedule – Reconcile Vendor Prepayments Account

Support Schedule – Build Report

Vendor Refund – Intro

Refunds from Vendors – Deposit Refund

Refunds from Vendors – Apply Refund Against Credit

Refunds from Vendors – Record Refund without Prior Credit

Trade Customer and Vendor Balances – Intro

Trade Customer and Vendor Balances – Set Up Clearing Account

Trade Customer and Vendor Balances – Set up Customer / Vendor

Trade Customer and Vendor Balances – Move Payment to Clearing

Trade Customer and Vendor Balances – Close Bill

Void Prior Period Check – Intro

1 of 2

72:03

Payroll Items – Intro

Payroll Items – Add

Payroll Items – Edit Name/Linked Accounts

Payroll Items – Edit Deduction Account

Payroll Items – Create Custom

Map Payroll Items – Intro

Map Payroll Items – How To

Map Payroll Items – Problems

Order of Payroll Items

Apply Benefits/Tax to Job Cost – Intro

Apply Benefits/Tax to Job Cost – Turn on Class Tracking

Apply Benefits/Tax to Job Cost – Set Preference

Apply Benefits/Tax to Job Cost – Turn On Track Expenses by Job/Class

Job Cost Salary-Intro

Job Cost Salary – Setup

Job Cost Salary – Enter Timesheet

Job Cost Salary – Review Paycheck

Void Paychecks – Intro

Void Paychecks – Use the Void Checks Button

Void Paychecks – Issue a Replacement Check

Void Paychecks – Void Original Check from Replacement Check

Employee Loans/Advances – Intro

Employee Loans/Advances – Set up Liability Account

Employee Loans/Advances – Issue Loan/Advance

1 of 2

49:04

Forms Background

How to Generate W2s

W2 and W3 Form Interview

Prepare to File 1099-NEC

1099-MISC & Conclusion

44:30

Budgets and Forecasts – Intro

Budgets and Forecasts – Create New

Budgets and Forecasts – Review/Edit

Budgets and Forecasts – Budget Performance Reports

Types of Reports – Intro

Types of Reports – Demo

Custom Reports – Intro

Custom Reports – Summary

Custom Reports – Detail Intro

Custom Reports – Detail Demo

Custom Reports – Filters

Intro to Troubleshoot Filters

Troubleshoot Filters- Remove Filter

Troubleshoot Filters- Filters as Columns/Change Report Type

Reports – Display

Reports – Header/Fonts

Reports – Columns

Memorize Report

Report Groups – Intro

Report Groups – Create

Report Groups – Use

Report Shortcuts

Schedule Reports Email – Setup and Choose Reports

1 of 2

176:19

Report Considerations – End Goal

Report Considerations – Categories Explained

Special Fields – Intro

Special Fields – Classes

Special Fields – Customer Type

Special Fields – Job Type

Special Fields – New Field for Customers/Sales

Special Fields – Reports

Special Fields – Vendor Type

Special Fields – Vendors

Special Fields – Items

Special Fields – Enter Custom Field

Excel – Reporting Intro

Excel – Export Report to Excel

Excel – Customize Report in Excel

Excel – Tips to Add Formulas in Excel

Excel – Filters

Excel – Graphs

Excel – Multiple QuickBooks Files

Combine Financial Statements – How To

Combine Financial Statements – Review

QuickBooks Statement Writer – Intro

QuickBooks Statement Writer – Open and Use

QuickBooks Statement Writer – Customize Columns

1 of 2

14:48

Backup – Auto/Schedule

Condense Data – Why

Condense Data – How

Steps to Improve Performance in QuickBooks

Steps to Improve Performance in Windows

Corrupt Data Files – Intro

Corrupt Data Files

Verify/Rebuild File

38:40

Setup Import Preferences and Finish Import

Import/Export QuickBooks Files

Lists – Export

Lists – Import

Form Templates – Export

Form Templates – Import

Reports – Export

Reports – Import

Other Programs – Import / Export

Other Programs – Export

Integrated Apps.-Intro

Import Excel List – Intro

Add Multiple List Entries Process

Edit Multiple List Entries Process

Intro to Import Excel List

Import Chart of Accounts From Excel

Create List Mappings

Setup Import Preferences and Finish Import

64:08

Intro to Journal Entries

Journal Entry Rule- Name Specification

Journal Entry Rule- Accounts Receivable / Accounts Payable Account Limitations

Journal Entry Rule- Accounts Receivable / Accounts Payable Account Applications

Journal Entry Rules – 1099s/Affect on Customer Statements and Reports

Reversing Journal Entry

Year – End Procedures

Set Closing Date

Get Info to Accountant

Intro to Accountants Copy

Accountants Copy – Create and Send

Accountants Copy – Open as Accountant

Accountants Copy – Edit Transaction(s) as Accountant

Accountants Copy – Save and Create Changed File as Accountant

Accountants Copy – Import Accountants Changed File

Why Condense Data

Condense Data – How

Year-End Closing Entry

Intro to Closing Entry

Closing Entry – Why

Change Name of Retained Earnings Account

Create New Retained Earnings Account

Transfer Net Income

1 of 2

17:53

Multicurrency Preferences

Activate a Currency

Exchange Rates – Intro

Exchange Rates – Download/Edit

Foreign Currency

Foreign Price Levels

Price Levels with Multicurrency – Setup

Price Levels with Multicurrency – Assign

Invoice Foreign Customers

Receive Payment

Realized Gains & Losses

Realized Gain Report

Multicurrency Accounts Receivable on Balance Sheet

View Gain / Loss for Current Exchange Rate

Home Currency Adjust

Class Conclusion