QuickBooks Desktop 2023, 2022, & 2021
Learn QuickBooks from a Certified Public Accountant (CPA) and experienced instructor
Become an Expert at QuickBooks in 1 Hour. . .: STOP!!!
That’s A LOAD OF CRAP
OK, it takes a little longer to be an expert. Fortunately, this course is designed to be useful for both beginners and experts.
Our course starts at the basics, such as how to access the QuickBooks software, possibly for free, and then moves through an in-depth analysis of the software.
The course is designed so learners can go from start to finish but also have the option of jumping to the most relevant parts of the course, using the course as a reference guide to fall back on as needed, a dependable and up-to-date reference guide.
We have updated this course each year and plan on continuing to do so as long as learners find it useful.
Courses on how to use software become outdated fast unless instructors are committed to updating the material, as we are. We also show lectures using the prior software versions, which will be relevant if you use an older version.
This course will include backup files, a great tool to jump ahead or rework a portion of a problem. The backup files allow learners to have the exact same data as the example problem, so they can follow the presentation and perform the task in an easy, step-by-step process.
The first part of the course will demonstrate how to access the QuickBooks software, possibly for free, download it, and install it.
We will then use the sample file provided by QuickBooks to learn how to navigate the accounting software, locate the most commonly used areas, and understand the relationship between data input and the final product of financial statements and related reports.
The sample file is an excellent tool for learning how to navigate the software because it already has data in it, allowing us to deconstruct the process of data input by going to the end result of financial statements and drilling back to the source documents used to enter the data.
We will analyze transactions by accounting cycle: vendor cycle, customer cycle, and employee cycle. The vendor cycle may also be called the payment cycle, purchases cycle, account payable cycle, or expenses cycle. The customer cycle may also be called the revenue cycle, sales cycle, or accounts receivable cycle.
The course will break down the flow of data input forms in each cycle and the impact of each form on the financial statements and related reports.
In the next major section of the course, we will start a new company file, an essential process for learning how to set up the foundational accounting system components like the chart of accounts, service items, revenue items, and beginning balances.
Learners will enter two months of data input along with instructional videos, entering a wide variety of common transactions and analyzing the impact of each on the financial statements and related reports.
After entering two months of data input, learners will prepare bank reconciliations using demonstration bank statements, learning how to perform a bank reconciliation, why we reconcile, and what outstanding items are.
The course also has an extensive section on how to use bank feeds. Learners will learn how to connect to the bank, download bank feeds into QuickBooks, and add the necessary data to include the bank data into the accounting system to create financial transactions or verify transactions that have already been created. We will also cover how to use bank rules to make data input much faster and more efficient. The course will demonstrate data input using bank feeds for checking, credit card, and PayPal accounts.
Next, we will enter adjusting entries; entries used to adjust financial statement reports more closely to their accounting basis as of the end of the month or year. Common accounting basis includes accrual basis, cash basis, or tax basis.
Learners will also understand how budgets fit into the accounting process, what some best practices are to construct a budget, how to enter a budget into QuickBooks, and how to run budget reports.
The course also has information on more specialized topics like using account numbers, customizing forms, using class tracking, memorizing transactions, fixed asset tracking, tax mapping, and multiple currencies.
What You Will Learn!
- How to access QuickBooks, possibly for free
- How to download and install the software
- How to set up a company file
- How to set up and use bank feeds including bank rules
- How to enter common transactions in the customer, vendor, and employee cycle
- How to analyze the major financial statement reports of the balance sheet and income statement or profit and loss
- How most reports relate to and provide more detail about the major financial statement reports
- How to enter period end adjusting entries
- How to reconcile bank accounts and credit card accounts
- How to enter a budget and use budget reports
- How to make and restore backup files
- How to use account numbers
- How to customize forms
- How to use class tracking
- How and why to memorize transactions
- How to track fixed assets
- How to use tax mapping
- How to use multiple currencies
Who Should Attend!
- Business Owners
- Accounting Professionals
- Accounting Students
- Anybody who wants to learn accounting software