QuickBooks Pro Desktop 2021, 2020, 2019, & 2018
What you'll learn
- How to enter data related for a full accounting cycle in to QuickBooks Desktop
- Basics to advanced topics - Comprehensive course is a great tool for beginners, advanced users or to use as a reference tool to fall back on
- Learn how to navigate through QuickBooks
- Understand accounting cycles related to revenue, purchases, and payroll
- Learn by working an example problem setting up a new company and entering two month of data input
- Be able to backup files and restore backup data files. Backup data files will be provided that can also be used to jump forward in the example problem or to rework components of it
- Learn data input relate to invoices, bills, checks, deposits, purchase orders. . .
- Understand much more then data input as a CPA demonstrates how QuickBooks uses the data to construct reports
- Generate reports, read reports, format reports, and export reports to Excel
- Learn to enter bank reconciliation by using practice bank statements, a format of learning not often provided but very useful
- Create budgets in QuickBooks
- Understand how bank feeds are set up and how the work
- Learn both accounting terminology and Quickbooks terminology so we can communicate with QuickBooks users and accountants who do not use QuickBooks
- Enter period end adjusting entries into QuickBooks
Requirements
- QuickBooks Pro Software would be best although we can review the content without the software
Description
This comprehensive course will provide an understanding of QuickBooks Pro Desktop 2021, 2020, 2019 & 2018 in a format beneficial to both beginners & advanced users.
We will start at the basics & go far beyond simple data entry, explaining how the software works in a clear step by step format.
We continually update this course, making it a community and recourse you can regularly return to and learn from. Current students will have access to the updates as they are created.
How can I get access to the software?
If you do not have access to QuickBooks, Intuit, the owner of QuickBooks, often provides a free 30-day trial, perfect for our needs.
Try typing into your favorite browser: Download a trial of QuickBooks Desktop
Students at accredited educational institutions may be able to get access to a trial version that lasts a year rather than 30 days. Try typing into your favorite browser: QuickBooks Desktop for Students
QuickBooks updates the software each year and we updated the course content each year, so you have the latest look and feel of the software.
One benefit of QuickBooks Desktop is that you can use the same software for multiple years. Therefore, you may have an older version of the software or may work with a client using an older version of the software.
Along with the most current software, this course will also include demonstrations in older versions of the software so that users can refer them when needed. We will also provide backup files related to older versions of the software that can be used to work through practice problems.
Note that there are some drawbacks to updating the course each year we want to be upfront about. We think the benefits outweigh the problems.
The course can feel bloated with content as we work similar demonstrations in new versions of the software. We will add the new content to the top of the course so you can jump right into the newest version. Each version of the software will include at least 25 hours of content once completed which makes it one of the most comprehensive courses you will find.
Adding new counted each year also makes it a little more difficult to fulfill the requirements for Udemy to provide a certificate of completion. However, you do not need to watch each video to receive the certificate of completion. Once you have finished the portion of the course that relates to you, the rest of the videos can be marked as completed manually, allowing Udemy to issue the certificate of completion.
This course will start at the basics, assuming you know nothing about the software or accounting.
We will start by comparing the different versions of QuickBooks. We will then go through the purchasing process, the downloading process, and the installation process.
The first half of the course will be dedicated to navigating the software, getting a feel for the major components of the software, and the primary accounting cycles such as the customer section or revenue cycle, the vendor section or payments cycle, and the employee section or payroll cycle.
Once we learn the primary sections or accounting cycles we will analyze the forms and transactions within each section, considering the impact each has on the financial statements.
The second half of the course will be in the format of a comprehensive problem, working through two months of data impute.
We will enter every standard type of transaction as we work through the comprehensive problem. The comprehensive problem format will provide context to the data entry process, so we understand how the data impute fits into the accounting workflow.
A comprehensive problem also allows us to do more than simple data entry, data entry generally being the easiest part of the accounting process. We will be able to see how to set up the system to make the data entry as easy as possible.
We will also be able to see the impact on the financial statements of every transaction we make and be able to check our work after each transaction.
QuickBooks backup files will be provided. Backup files allow us to restore a data file and are very useful for learning. Backup files permit us to jump forward in a practice problem and have the data needed to work along with the step by step presentations, having the same data as is in the example presentation, in our system as we start the practice problem. Backup files also allow us to rework a problem or start over if we make an error.
If a course teaches in the form of a comprehensive problem, the best way to teach, and they do not provide backup files you will need to start the problem with no data and then follow the entire problem without any errors to line up with each step of the example problem being presented. Backup files allow you much more flexibility, being able to jump to future parts of the practice problem or rework any part of the problem.
Who this course is for:
- Business Owners
- Accounting Professionals
- Accounting Students
- Anybody who wants to learn accounting software
Course content
- Preview15:07
- 00:05Resource Using OneNote
- Preview00:32
- Preview17:39
Instructor
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.