Back to self-paced courses
Advanced LevelQuickBooks Desktop
QuickBooks Desktop Accountant Edition - Beyond the Basics
This course explores advanced topics for QuickBooks Desktop for accountants. Watch it and learn to use QuickBooks Desktop to meet the unique needs of accountants.
Course Duration
Ready to learn with us?
This course is included in all of our QuickBooks training plans.
Course Content
Overview
✓Meet Your Instructor: Alanna
✓Class Overview
✓History – Reason for QuickBooks
✓Resources – ProAdvisors
✓Editions of QuickBooks
✓What QuickBooks Doesn’t Do
Setup Issues
✓Setup Issues
✓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 Transactions
✓Advanced Setup – Vendor and Employee Transactions
✓Advanced Setup – Start Date Intro
✓Advanced Setup – Select Start Date in QuickBooks
✓Convert From Existing Company File
✓Complete Lists
✓Opening Balances – Intro
✓Opening Balances – Journal Entry
✓Special Accounts – Bank
✓Special Accounts – Accounts Receivable 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
Customizing
✓Customizing
✓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)
Items/Inventory
✓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
Sales Transactions
✓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)
✓Billable Costs
✓Multiple Sales Tax Rates – Intro
✓Multiple Sales Tax Rates – Record Sale
Sales Workarounds
✓Sales Workarounds
✓Customer Deposit Method 1 – Intro to Down Payment as Credit
✓Customer Deposit Method 1 – Record Down Payment
✓Customer Deposit Method 1 – Create Invoice and Apply Customer Down Payment
✓Customer Deposit Method 1 – Year End Journal Entry
✓Customer Deposit Method 2 – Intro to Down Payments Liability
✓Customer Deposit Method 2 – Create Customer Deposits Liability Account
✓Customer Deposit Method 2 – Set Up Deposit Item
✓Customer Deposit Method 2 – Record Invoice for Deposit
✓Customer Deposit Method 2 – Receive Deposit and View Customer Balance
✓Customer Deposit Method 2 – Create Final Invoice and Apply Customer Deposit
✓Set up Customer Prepayments (QB Enterprise 2024 or Later)
✓Use Customer Prepayments (QB Enterprise 2024 or Later)
✓Write off Bad Debt – Intro
✓Write off Bad Debt – No Sales Tax
✓Write off Bad Debt with Sales Tax – Create Bad Debt Item
✓Write off Bad Debt with Sales Tax – Record Credit Memo
✓Write off Bad Debt with Sales Tax – Apply Credit Memo to Invoice
✓Under/Over Payments
✓Customer Underpayments
✓Customer Overpayment – Built In
✓Customer Overpayment – Refund Overpayment
✓Customer Overpayment – Retain Overpayment for Future Invoices
✓Transferring Customer Credits – Intro
✓Transfer Customer Credits (QB 2019 or Later) – Record Transfer
Purchasing
✓Purchasing
✓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)
Advanced Purchases
✓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
✓Refunds from Vendors – 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 Customer / Vendor
✓Trade Customer and Vendor Balances – Set Up Clearing Account
✓Trade Customer and Vendor Balances – Move Payment to Clearing
✓Trade Customer and Vendor Balances – Close Bill
✓Void Prior Period Check – Intro
Payroll
✓Payroll
✓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
W-2s & 1099s
✓W-2s & 1099s
✓Forms Background
✓How to Generate W2s
✓W2 and W3 Form Interview
✓1099 Intro
✓Prepare to File 1099-NEC
✓File 1099-NEC
✓1099-MISC & Conclusion
Reports
✓Reports
✓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
✓QuickZoom
✓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
Reports-Expert
✓Reports-Expert
✓Report Considerations – Consider End Goal
✓Report Considerations – Report 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
✓Combine Financial Statements – Intro
✓Combine Financial Statements – How To
✓Combine Financial Statements – Review
File Utilities
✓File Utilities
✓Backup – Auto/Schedule
✓Condense Data – Why
✓Condense Data – How
✓Condense Data – Remove Audit Log
✓Steps to Improve Performance in QuickBooks
✓Steps to Improve Performance in Windows
✓Corrupt Data Files – Intro
✓Corrupt Data Files
✓Verify/Rebuild File
✓Move a Company File
Import/Export
✓Import/Export
✓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 Applications – Intro
✓App Center
✓Manage Apps
✓Import Excel List – Intro
✓Add Multiple List Entries Process
✓Edit Multiple List Entries Process
✓Import from Excel – Intro
✓Import From Excel – Chart of Accounts
✓Import From Excel – Create List Mappings
✓Import From Excel – Import Preferences and Finish Import
Accountants
✓Accountants
✓Journal Entries – Intro
✓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
✓Send General Journal Entry to Client
✓Year-End Procedures
✓Set Closing Date – Why
✓Closing Date – How
✓Restrict Access to Closed Period
✓What do Closed Period Restricted Users See?
✓Get Info to Accountant
✓Accountants Copy – Intro
✓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
✓Condense Data – Why
✓Condense Data – How
✓Year-End Closing Entry
✓Closing Entry – Intro
✓Closing Entry – Why
Multicurrency
✓Multicurrency
✓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
✓Gain/Loss for Exchange Rate – Balance Sheet
✓Gain/Loss for Exchange Rate – Profit & Loss
✓Home Currency Adjust
✓Class Conclusion