Advanced LevelQuickBooks Desktop

Beyond the Basics: Advanced QuickBooks Desktop Topics

11 hr 11 min

This advanced course takes experienced QuickBooks Desktop users beyond the basics into the program's most powerful and complex features. You'll dig into setup issues, customizing QuickBooks, items and inventory, sales transactions and workarounds, purchasing, and payroll, plus expert-level reporting. The course also covers file utilities, import/export, accounting tools, and multicurrency, providing the workarounds and advanced techniques to solve real-world problems.

You’ll learn how to…

Resolve common setup issues
Customize QuickBooks to fit your needs
Master items and inventory
Handle sales transactions and tricky workarounds
Manage purchasing and advanced purchases
Run payroll with confidence
Build standard and expert-level reports
Use file utilities and import/export tools
Work with accountant features
Set up and use multicurrency

This class is included in all of our training plans

Self-paced

All training plans include instant and lifetime access to this course.

Course Content

402 lessons · 11 hr 11 min

Meet Your Instructor: Alanna0:50

Overview Introduction1:23

History-Reason for QB0:49

Resources-ProAdvisors0:41

Editions of QuickBooks1:44

What QB Doesn't Do1:40

Setup Issues1:00

Should I Start Over?2:19

Remove Transactions0:54

Start a New File2:10

Create a Company File3:55

Advanced Setup-Intro0:25

Advanced Setup-Company Information3:08

Advanced Setup-Industry and Password2:45

Advanced Setup - Sales Tax and Customer Transactions1:12

Advanced Setup - Vendor and Employee Transactions2:45

Advanced Setup-Start Date Intro2:13

Advanced Setup-Start Date & Accounts1:35

Complete Lists1:32

Opening Balances-Intro2:00

Opening Balances-Journal Entry2:57

Special Accounts-Bank2:01

Special Accounts-Accounts Receivable Intro0:52

Special Accounts-Accounts Receivable Accrual2:35

Special Accounts-Accounts Receivable Cash2:32

Special Accounts-Accounts Payable1:28

Special Accounts-Credit Cards0:43

Special Accounts-Equity Intro1:17

Special Accounts-Equity Continued2:04

Payroll-Choose Service1:04

Payroll Setup Interview2:26

Enter Transaction History1:32

Check New File Setup0:42

Edit Beginning Balance Start Date0:59

Customizing QuickBooks1:29

Preferences-Intro0:37

Preferences - Access Steps and Explanation2:12

Preferences - Remove or Add Icons/Change Color Scheme2:56

Preferences-Change Default Accounts1:30

Preferences - Start with Payee Field on Checks1:26

Icon Bar - View or Hide Colored Icons1:14

Icon Bar - Add Shortcut from Presets/Delete Icon1:42

Icon Bar - Add Shortcut from Transaction1:29

Icon Bar - Add Favorite Reports0:38

Custom Fields - Intro1:10

Create Custom Fields1:32

Custom Fields - QuickBooks Enterprise2:43

Custom Fields on Reports1:25

Account Numbers3:24

Classes-Intro1:52

Classes-Enable & Add2:02

Profit & Loss By Class1:15

Balance Sheet by Class1:18

Classes-Use1:41

Classes - QuickBooks Enterprise1:33

Mileage Tracking (QB 2023 or Later)3:26

Items & Inventory1:49

Expenses vs. Items2:33

Inventory Limitations1:59

Inventory Adjustments - Quantity3:01

Inventory Adjustments - Value2:03

Group and Assembly Items0:22

Group Item-Intro0:38

Group Item-Why1:46

Group Item-Add1:33

Group Item-Use1:47

Inventory Assembly-Intro1:36

Inventory Assembly - Setup2:29

Inventory Assembly - Accounting1:58

Inventory Assembly-Process1:35

Inventory Assembly - Build2:43

When to Use Group vs. When to Use Assembly1:38

Units of Measure-Preferences1:07

Units of Measure-Set2:24

Units of Measure-Assign1:18

Item Categories (QB Enterprise 2024 or Later)2:34

Expiration Dates (QB Enterprise 2024 or Later)4:29

Sales Transactions1:13

Estimates - Record4:16

Estimates - Intro to Invoice Creation1:07

Estimates - Create an Invoice Based on an Estimate2:36

Price Levels-Intro1:43

Price Levels-Setup & Define3:13

Price Levels-Assign/Use2:33

Price Levels-Per Item2:31

Sales Order-Intro1:11

Sales Order-Backorder2:12

Sales Orders - Invoice from Sales Order2:08

Sales Orders - Record a Possible Future Order1:45

Sales Orders - Create a Sales Order from an Estimate1:40

Sales Orders - Customize Sales Order Report0:47

Sales Orders - Sales Order by Item Report1:43

Intro to Statement Charges0:51

Statement Charges - Apply Charge to Customer2:11

Batch Invoicing - Intro1:22

Batch Invoicing - Customer Information Setup1:08

Batch Invoicing - Create Customer Billing Group2:41

Batch Invoicing - Choose Items and Create Invoices1:11

Billable Costs3:33

Multiple Sales Tax Rates - Intro0:53

Multiple Sales Tax Rates - Record Sale2:28

Sales Tax Paid Incorrectly2:48

List Invoices - Customer Center1:04

Locate Missing Invoices2:28

Aging Errors2:22

Multi-Customer Email Selection (QB 2022 or Later)1:01

Sales Workarounds1:18

Customer Deposit Method 1 - Intro to Down Payment as Credit0:50

Customer Deposit Method 1 - Record Down Payment1:43

Customer Deposit Method 1 - Create Invoice and Apply Customer Down Payment2:08

Customer Deposit Method 1 - Year End Journal Entry1:10

Customer Deposit Method 2 - Intro to Down Payments Liability1:02

Customer Deposit Method 2 - Create Customer Deposits Liability Account0:36

Customer Deposit Method 2 - Set Up Deposit Item1:06

Customer Deposit Method 2 - Record Invoice for Deposit0:37

Customer Deposit Method 2 - Receive Deposit and View Customer Balance1:02

Customer Deposit Method 2 - Create Final Invoice and Apply Customer Deposit1:53

Write off Bad Debt - Intro0:53

Write off Bad Debt - No Sales Tax1:42

Write off Bad Debt - with Sales Tax - Create Bad Debt Item1:45

Write off Bad Debt - with Sales Tax - Record Credit Memo1:42

Write off Bad Debt - with Sales Tax - Apply Credit Memo to Invoice0:45

Under/Over Payments1:10

Customer Underpayment1:07

Customer Overpayment - Built In1:24

Customer Overpayment - Refund Overpayment1:01

Customer Overpayment - Retain Overpayment for Future Invoices0:49

Transfer Customer Credits - Intro0:42

Transfer Customer Credits (QB 2019 and Later)1:29

Transfer Customer Credits (QB 2018 or Earlier) - Create Clearing Account1:11

Transfer Customer Credits (QB 2018 or Earlier) - Remove Credit from Original Job0:59

Transfer Customer Credits (QB 2018 or Earlier) - Apply Credit to New Job1:27

Multiple Accounts Receivable Accounts - Intro0:55

Multiple Accounts Receivable Accounts - Create and Use Accounts2:24

Automated Customer Statements (QB 2021 or Later)2:33

Schedule Automated Customer Statements (QB 2021 or Later)1:36

Retail Sales - Challenges of Daily Sales Entry1:14

Retail Sales - Workaround for Daily Sales Entry0:50

Retail Sales - Item Setup3:07

Retail Sales-Paid Outs1:39

Retail Sales - Credit Card Payments1:24

Retail Sales-Over/Short1:40

Retail Sales-Deposits0:33

NSF Checks - Intro0:47

NSF Checks - Mark Check as Bounced1:30

NSF Checks - Transactions QuickBooks Creates2:29

NSF Checks - Review Customer Statement0:54

Set up Customer Prepayments (QB Enterprise 2024 or Later)2:17

Use Customer Prepayments (QB Enterprise 2024 or Later)2:51

Purchasing2:06

Purchase a Fixed Asset - Intro1:10

Purchase a Fixed Asset - Set up Fixed Asset Accounts0:58

Purchase a Fixed Asset - Set Up Fixed Asset Item List (Optional)2:51

Purchase a Fixed Asset - Record the Purchase/Financing of a Fixed Asset2:11

Loan Manager - Intro1:50

Loan Manager - Set Up Liability Account0:51

Loan Manager - Deposit Loan into Bank Account1:22

Loan Manager - Schedule Loan Payments2:22

Loan Manager - Record Loan Payment1:55

Loan Manager - Track Loan Payment Details1:13

Line of Credit - Intro0:27

Line of Credit - Set Up Liability Account0:31

Line of Credit - Transfer Funds0:46

Line of Credit - Pay Down Balance1:49

Receipt Management (QB 2021 or Later)3:53

Reconciliation Balance-Intro0:26

Reconciliation Balance Discrepancy-Why3:19

Reconciliation Balance Discrepancy - Locate Discrepancies Tool2:26

Reconciliation Balance Discrepancy - Find Problems from Register2:06

Bill Payment Errors - Intro0:40

Bill Payment Errors - Delete Bill0:55

Bill Payment Errors - Delete Check and use Pay Bills Window2:26

Check Detail Report1:53

Petty Cash - Setup and Deposits2:02

Petty Cash - Record Purchase1:27

Online Bill Payment (QB 2022 or Later)1:16

Bill Payment Stub (QB 2022 or Later)2:13

Bill Automation - Upload and Mobile App (QB 2022 or Later)4:02

Bill Approval (QB Enterprise 2022 or Later)3:35

PO Approval (QB Enterprise 2023 or Later)3:30

Advanced Purchases1:44

Employee/Owner Purchases - Set Up Liability Account1:05

Employee/Owner Purchases - Record Purchase1:48

Employee/Owner Purchases - Reimburse for Purchase1:17

Prepaid Expenses-Intro1:01

Prepaid Expenses - Set Up Asset Account0:55

Prepaid Expenses - Record Prepayment1:02

Prepaid Expenses - Set Up Monthly Journal Entry to Expense Insurance1:57

Vendor Deposit-Intro0:29

Vendor Deposits - Set Up Asset Account0:45

Vendor Deposits - Record Deposit to Vendor0:56

Vendor Deposits - Apply Deposit1:19

Support Schedule-Intro0:53

Support Schedule - Reconcile Vendor Prepayments Account2:50

Support Schedule - Build Report2:06

Vendor Refund-Intro0:32

Refunds from Vendors - Deposit Refund1:25

Refunds from Vendors - Apply Refund Against Credit1:03

Refunds from Vendors - Record Refund without Prior Credit1:03

Trade Customer and Vendor Balances - Intro1:28

Trade Customer and Vendor Balances - Set up Customer / Vendor1:33

Trade Customer and Vendor Balances - Set Up Clearing Account0:48

Trade Customer and Vendor Balances - Move Payment to Clearing1:51

Trade Customer and Vendor Balances - Close Bill1:47

Void Prior Period Check - Intro1:11

Void Prior Period Check - Void Simple Check1:27

Void Non-Simple Check - Intro1:06

Void Non-Simple Check - Locate Check/View Transaction Journal1:03

Void Non-Simple Check - Create Reversing Journal Entry2:04

Cash Flow Projector - Intro1:26

Cash Flow Projector - Enter Manual Cash Receipts2:10

Cash Flow Projector - Business Expense Entry2:06

Cash Flow Projector - Review and Adjust Accounts Payable2:09

Cash Flow Hub (QB 2023 or Later)2:05

Set up Intercompany Transactions (QB Enterprise 2023 or Later)3:33

Finish Intercompany Transactions (QB Enterprise 2023 or Later)3:50

Beyond the Basics: Payroll2:23

Payroll Items - Intro1:02

Payroll Item-Add3:38

Payroll Items - Edit Name/Linked Accounts1:42

Payroll Items - Edit Deduction Account3:24

Payroll Items - Create Custom2:28

Map Payroll Items - Intro1:30

Map Payroll Items - How To1:25

Mapping Problems2:25

Order of Payroll Items3:45

Apply Benefits/Tax to Job Cost - Intro0:49

Apply Benefits/Tax to Job Cost - Turn on Class Tracking0:37

Apply Benefits/Tax to Job Cost - Set Preference0:36

Apply Benefits/Tax to Job Cost - Turn On Track Expenses by Job/Class0:45

Job Cost Salary-Intro0:52

Job Cost Salary - Setup0:33

Job Cost Salary - Enter Timesheet0:45

Job Cost Salary - Review Paycheck0:37

Void Paychecks-Intro1:25

Void Paychecks - Use the Void Checks Button0:39

Void Paychecks - Issue a Replacement Check1:20

Void Paychecks - Void Original Check from Replacement Check1:44

Employee Loans/Advances - Intro1:38

Employee Loans/Advances - Set up Liability Account0:56

Employee Loans/Advances - Issue Loan/Advance1:12

Employee Loans/Advances - Set up Repayment3:48

Employee Loans/Advances - Add Repayment to Employee Info0:49

Employee Loans/Advances - Track Employee Loan/Advance Balance0:43

Company/Employee Expenses - Intro0:58

Company/Employee Expenses - Use Liability Check to Combine Company and Employee Portion1:05

Company/Employee Expenses - Enter Check / Bill for Full Expensed Amount by Crediting Expense Account during Deduction1:29

Company/Employee Expenses - Enter Bill with Linked Payroll Item Expense Account0:59

Enhanced Payroll-Intro0:50

Workers Comp - Setup2:11

Workers Comp - Preferences0:50

Workers Comp - Add/Edit Code to Workers Comp List0:51

Workers Comp - Workers Comp Codes on Paychecks0:57

Net to Gross Calculation2:47

Time Billed Status Reports1:16

Excel Payroll Summary1:02

Payroll Journal Entries: Intro3:12

Payroll Journal Entries: Enter7:35

Reports1:37

Budgets and Forecasts - Intro0:57

Budgets and Forecasts - Create New4:24

Budgets and Forecasts - Review/Edit1:34

Budgets and Forecasts - Budget Performance Reports2:34

Types of Reports-Intro1:12

Types of Reports - Demo1:53

QuickZoom2:42

Custom Reports-Intro1:10

Custom Reports - Summary1:46

Custom Reports - Detail Intro1:08

Custom Reports - Detail Demo0:57

Custom Reports - Filters2:31

Intro to Troubleshoot Filters0:46

Troubleshoot Filters- Remove Filter1:32

Troubleshoot Filters- Filters as Columns/Change Report Type1:23

Reports-Display2:43

Reports-Header/Fonts2:05

Reports-Columns0:57

Memorize Report0:51

Report Groups - Intro0:50

Report Groups-Create2:14

Report Groups - Use0:50

Report Shortcuts1:07

Schedule Reports Email - Setup and Choose Reports2:24

Schedule Reports Email - Set Schedule and Compose3:12

Learner

Training only

1 user

$899.95

$599.95

30-day money back guarantee

Lifetime access to all included training

This course + 40 other courses
Live classes every weekday
Hands-on exercises
All future course updates

Optional Live 1-on-1 Help continues at $50/mo. Cancel anytime.

Certification

Training + Certification

1 user

$999.95

$699.95

30-day money back guarantee

Lifetime access to all included training

Everything in Learner
Training for all 7 certifications
7 QuickBooks certification exams
Practice exams and test prep

Optional Live 1-on-1 Help continues at $50/mo. Cancel anytime.

Team

Team Training + Certification

2-5 users

$1,799.95

$999.95

30-day money back guarantee

Lifetime access to all included training

Everything in Certification
Up to 5 users included
Certification for your team
Team progress tracking

Optional Live 1-on-1 Help continues at $90/mo. Cancel anytime.

Compare plans and features