
Learn QuickBooks™ Online
Preparation for the Intuit QBCU Certification Exam
Unlike traditional textbooks (which are usually sent to the publisher 4 to 6 months before they go into service for fall semesters), this online video course has the flexibility to be updated on-the-fly as needed throughout the semester, regardless of how many changes Intuit may throw into the software during the school year.
This fourteen to sixteen-week comprehensive course with 100+ video lessons (averaging 8 to 10 minutes each) is fully supported with printable student resources and complete instructor ancillaries.
Working through 10 separate projects, students will:
Learn all general aspects of QuickBooks™ Online
Complete a QBO practice set covering one month of business transactions including:
Setting up QBO for use
Building lists for Customers, Vendors, Products/Services, Payment Types, and more
Recording sales transactions, invoices, payments received, credit memos, and more
Recording purchases, bills, bill payments, electronic payments, prepare reconciliations, and more
Recording EOM and EOY activities
Spend an entire project studying and preparing for Intuit’s QBCU Certification Exam*
*QBCU certification exam sold and administered separately
Unit 1 projects include:
Video lessons with follow along activities allowing students to practice and check their work
A multiple-choice chapter quiz
A course-long, real world simulation (Ongoing Assignment) where each chapter’s information will build on the work for a fictitious business
Also included are two Exam Projects
Exam Project #1 covers Chapters 1 - 8
Exam Project #2 covers Chapters 1 - 12
The course is structured to use the actual Intuit QBCU Certification exam as the final for the course.
However, a simulated version of the exam text bank is included, if instructor chooses not to offer actual certification.
Over 3 units students will:
Unit 1 • Learn QuickBooks™ Online
Content subject to change prior to final release on July 1, 2024
-
Learning Objectives: After completing this project, the student should be able to:
1-1 • Have a basic understanding of how QuickBooks Online (QBO) is used by businesses and how the cloud-based platform performs
1-2 • Explain how and why QBO only requires a transaction to be recorded one time for its data to be available in a variety of formats
1-3 • Understand the cloud-based system and the differences between company files you will be using in QBO… The Test Drive company and your own project
1-4 • Access various help support included in the QBO system
Project 1 Lessons:
• Lesson 1: Course Overview
• Lesson 2: Intro - What is QBO?
• Lesson 3: Before We Go Any Further...
• Lesson 4: Recording A Transaction
• Lesson 5: Test Drive Company vs Your Company
• Lesson 6: Help Functions and Advice
• Check “Your Turn” Answers - Project 1
• Quiz - Project 1
• Assignment - Project 1
-
Learning Objectives: After completing this project, the student should be able to:
2-1 • Navigate and understand setting up QBO, as well as change its basic settings
2-2 • Customize company and personal settings of QBO
2-3 • Understand the differences between different types of QBO users and set up their access to the company file
2-4 • Connect third-party, electronic financial accounts to QBO and use the Bank Rules to organize and streamline your work
2-5 • Understand the ability of QBO to work with third-party applications designed to add functionality to the platform along with saving time and work
2-6 • Purge company data within a new QBO file to start over (within 60 days)
Project 2 Lessons:
• Lesson 1: Introduction to QBO Setup
• Lesson 2: Navigating QB
• Lesson 3: Set up QBO / Changing Basic Settings
• Lesson 3: Customizing QBO
• Lesson 4: Setting Up Users Access
• Lesson 5: Connecting financial accounts to QBO
• Lesson 6: Bank Rules
• Lesson 7: Connecting Apps
• Lesson 8: Purging company data
• Check “Your Turn” Answers - Project 2
• Quiz - Project 2
• Begin Ongoing Assignment - Project 2
-
Learning Objectives: After completing this project, the student should be able to:
3-1 • Understand the importance of how QBO uses Lists as the framework of recording transactions
3-2 • Understand how the Chart of Accounts serves a one of the more important QBO lists and how to create a new list item, in general
3-3 • Edit existing list items to update information
3-4 • Remove or merge list items
3-5 • Import items into certain lists to reduce labor and the possibility of errors
Project 3 Lessons:
• Lesson 1: Introduction to Lists
• Lesson 2: Chart of Accounts / Adding a New Item
• Lesson 3: Editing List Entries
• Lesson 4: Removing / Merging List Entries
• Lesson 5: Importing Lists
• Check “Your Turn” Answers - Project 3
• Quiz - Project 3
• Ongoing Assignment - Project 3
-
Learning Objectives: After completing this project, the student should be able to:
4-1 • Understand the QBO flow of sales for different types of business processes using the Product and Services List, the Customer List, and more
4-2 • Receive and process payments from customers including tracking payments ready to be deposited into the bank
4-3 • Record sales when payments are received immediately as well as we credit is extended to the customer for payment later
4-4 • Process estimates, credits, and refunds to customers along with applying discounts to their purchases
4-5 • Reconciling bank (and other) accounts with statements
Project 4 Lessons:
• Lesson 1: Introduction to the QBO Sales Process
• Lesson 2: Product and Services List - Part A
• Lesson 3: Customer List
• Lesson 4: Undeposited Funds
• Lesson 5: Recording Sales/Revenue
• Lesson 6: Customer Credit Memos and Refunds
• Lesson 7: Estimates, Delayed Charges, etc.
• Lesson 8: Customer Discounts
• Lesson 9: Reconciling accounts
• Check “Your Turn” Answers - Project 4
• Quiz - Project 4
• Ongoing Assignment - Project 4
-
Learning Objectives: After completing this project, the student should be able to:
5-1 • Understand the QBO flow of purchases for different types of business processes using the Product and Services List, the Vendor List, and more
5-2 • Create, track, and process Purchases Orders
5-3 • Enter and pay Bills into the Accounts Payable system
5-4 • Record and print checks created within QBO, as well as manual checks
5-5 • Record purchases made by card and electronic payment
5-6 • Create, send, and apply credits given to vendors
5-7 • Track and process expenses which should be passed along to customers
5-8 • Setup and process IRS-1099 forms for Independent Contractors
Project 5 Lessons:
• Lesson 1: Introduction to Recording Expenses
• Lesson 2: Product and Services List - Part B
• Lesson 3: Vendor List
• Lesson 4: Entering Purchase Orders
• Lesson 5: Receiving Purchase Orders
• Lesson 6: Entering and Paying bills (A/P)
• Lesson 7: Recording Checks
• Lesson 8: Recording Card and Electronic Purchases
• Lesson 9: Vendor/Supplier Credits
• Lesson 10: Billable Expenses
• Lesson 11: 1099 Setup
• Check “Your Turn” Answers - Project 5
• Quiz - Project 5
• Ongoing Assignment - Project 5
-
6-1 • Understand how QBO works with basic accounting functions including Cash vs Accrual reporting
6-2 • Prepare financial statements including the Balance Sheet and Profit & Loss Report in different formats
6-3 • Record a Journal Entry
6-4 • Understand the importance and mechanics of setting a Closing Date in QBO
6-5 • Access Transaction Reports and Ledgers
6-6 • Understand the difference between voiding and deleting a transaction in QBO, along with the effects of each process
Project 6 Lessons:
• Lesson 1: QBO Basic Accounting and Reports
• Lesson 2: Balance Sheet
• Lesson 3: Profit & Loss
• Lesson 4: Journal Entry
• Lesson 4: Closing Date
• Lesson 5: Transaction Reports / Ledger
• Lesson 6: Void versus Delete
• Check “Your Turn” Answers - Project 6
• Quiz - Project 6
• Ongoing Assignment - Project 6
-
Learning Objectives: After completing this project, the student should be able to:
7-1 • Better understand the ability of QBO to create standard and customized reports
7-2 • Work with reports focusing on Customers’ and Vendors’ information and activity
7-3 • Prepare and understand Accounts Receivable and Accounts Payable reports
7-4 • Set up reports which can be automatically emailed
7-5 • Export QBO reports into Excel format
7-6 • Prepare and use the Audit Log, if the need arises
Project 7 Lessons:
• Lesson 1: A Deeper Dive Into QBO Reports
• Lesson 2: Customizing Reports
• Lesson 3: Customer Reports
• Lesson 4: Vendor Reports
• Lesson 5: A/R and A/P Aging Reports
• Lesson 6: Automatically Email Reports
• Lesson 7: Exporting with Excel
• Lesson 8: Audit Log
• Check “Your Turn” Answers - Project 7
• Quiz - Project 7
• Ongoing Assignment - Project 7
-
Learning Objectives: After completing this project, the student should be able to:
8-1 • Identify and use various tools in the QBO system that allows users to customize their work environment and save time
8-2 • Use Multiple Locations and Classes to track financial activity between different areas of the business
8-3 • Customized both the formatting of reports, and the specific data that is included within reports
8-4 • Create and use Recurring Transactions and Keyboard Shortcuts
8-5 • Use the integrated QBO system to receive and track purchase receipts
8-6 • Be familiar with various other tools and tips to streamline your work in QBO
Project 8 Lessons:
• Lesson 1: Customize Work And Save Time
• Lesson 2: Time-saving benefits of QBO
• Lesson 3: Multiple locations
• Lesson 4: Classes
• Lesson 5: Customizing Forms - Data
• Lesson 6: Customizing Forms - Formatting
• Lesson 7: Recurring Transactions
• Lesson 7: Keyboard Shortcuts
• Lesson 8: Managing Receipts
• Lesson 9: The Junk Drawer
• Check “Your Turn” Answers - Project 8
• Quiz - Project 8
• Ongoing Assignment - Project 8
Unit 2 • Practice QuickBooks™ Online
-
• Step 1: Project Intro and Accessing Instructions
• Step 2: Set Up The Practice Set QBO file
• Step 3: Process Week #1
• Step 4: Process Week #2
• Step 5: Process Week #3
• Step 6: Process Week #4
• Step 7: Process Week #5
• Step 8: Process End-of-the-Month Activities
• Step 9: Process End-of-the-Year Activities
• Step 10: Project Exam
Unit 3 • Prepare for the QBCU Certification Exam
-
Details to come