QuickBooks Desktop 2023, 2022, & 2021
What you'll 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
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.
Who this course is for:
- Business Owners
- Accounting Professionals
- Accounting Students
- Anybody who wants to learn accounting software
Through working with students from many different schools, Mr. Steele has learned best practices for helping people understand accounting fast. Learning new skills and finding the best way to share knowledge with people who can benefit from it is a passion of his.
Mr. Steele has experience working as a practicing Certified Public Accountant (CPA), an accounting and business instructor, and curriculum developer. He has enjoyed putting together quality tools to improve learning and has been teaching, making instructional resources, and building curriculum since 2009. He has been a practicing CPA since 2005. Mr. Steele is a practicing CPA, has a Certified Post-Secondary Instructor (CPI) credential, a Master of Science in taxation from Golden Gate University, a Bachelor’s Degree in Business Economics with an emphasis in accounting from The University of California Santa Barbara, and a Global Management Accounting Designation (CGMA) from The American Institute of CPA (AICPA).
Mr. Steele has also authored five books that can be found on Amazon or in audiobook format on Audible. He has developed bestselling courses in accounting topics including financial accounting and QuickBooks accounting software.
In addition to working as an accountant, teaching, and developing courses Mr. Steele has helped create an accounting website at accountinginstruction, a YouTube channel called Accounting Instruction, Help, and How Too, and has developed supplemental resources including a Facebook Page, Twitter Page, and Podcasts that can be found on I-tunes, Stitcher, or Soundcloud. Mr. Steele's teaching philosophy is to make content applicable, understandable, and accessible.
Adult learners are looking for application when they learn new skills. In other words, learners want to be able to apply skills in the real world to help their lives. Mr. Steele’s formal accounting education, practical work experience, and substantial teaching experience allow him to create a curriculum that combines traditional accounting education with practical knowledge and application. He accomplishes the goals of making accounting useful and applicable by combining theory with real-world software like Excel and QuickBooks.
Many courses teach QuickBooks data entry or Excel functions but are not providing the real value learners want. Real value is a result of learning technical skills like applications, in conjunction with specific goals, like accounting goals, including being able to interpret the performance of a business.
Mr. Steele makes knowledge understandable by breaking down complex concepts into smaller units with specific objectives and using step by step learning processes to understand each unit. Many accounting textbooks cram way too much information into a course, making it impossible to understand any unit fully. By breaking the content down into digestible chunks, we can move forward much faster.
Mr. Steele also makes use of color association in both presentations and Excel worksheets, a learning tool often overlooked in the accounting field, but one that can vastly improve the speed and comprehension of learning accounting concepts.
The material is also made understandable through the application of concepts learned. Courses will typically demonstrate the accounting concepts and then provide an Excel worksheet or practice problems to work through the concepts covered. The practice problems will be accompanied by an instructional video to work through the problem in step by step format. Excel worksheets will be preformatted, usually including an answer tab that shows the completed problem, and a practice tab where learners can complete the problem along with a step by step presentation video.
Mr. Steele makes learning accounting accessible by making use of technology and partnering with teaching platforms that have a vision of spreading knowledge like Udemy.