Learn QuickBooks Online 2021 in a comprehensive online course taught by a practicing CPA, CGMA, CPI, with BS tax
☑ Set up QuickBooks Account
☑ Navigate QuickBooks Software
☑ Enter normal business transaction
☑ Reconcile bank accounts
☑ Generate reports including a balance sheet, and income statement, and supporting reports
☑ Analyze Reports
☑ Export Reports to Excel
QuickBooks Online 2021 updates are being prepared. The current course community will have access to the updates as we create them.
We will update this course each year at no additional cost, so the course community has access to the latest look and feel of QuickBooks Online and can also look back to see the changes that have been made.
We have received a lot of positive feedback and suggestions for improvements that we will put into place as we update.
We greatly appreciate the feedback and support we have received with this course and we look forward to continually improving it with your help.
The new material will provide learners with the most current look and format of QuickBooks Online.
We have listened to, and are grateful for, many reviews over the year and will implement many changes as we update the course including shortening unnecessary introductions, adding more ways for learners to work in a hands-on approach, and adding new content related to specific industries and circumstances including a cash basis business.
—————————————————————————————————————————–
This is a comprehensive QuickBooks Online course.
If you are a student at an accredited academic institution, you may be eligible for a free trial version of QuickBooks from Intuit, which is a great tool allowing you to maximize the use of this course. We may also utilize a free 30 trial often offered by Intuit, the owner of QuickBooks
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.
English
Language
Introduction
Introduction Course Overview
2020 QuickBooks Online
2020 Introduction
2020 – Getting Started – Getting Setup
2 Getting Set Up
.05 Recommendations
.07 QuickBooks Desktop Vs QuickBooks Online
.10 Purchase With 30 Day Trial
.12 Bank Feeds
1.05 Navigation Overview
2020 – Customer Cycle , Cycle, or Accounts Receivable Cycle
3 Navigating Through QuickBooks
1.15 Customers Section Flow
1.16 Customers Section Invoice
1.17 Customers Section Receive Payment
1.18 Customers Section Deposit
1.19 Customers Section Sales Receipts
2020 Vendor Cycle, Purchases Cycle, or Sales Cycle
1.20 P1 Vendors Section Flow
1.20 P2 Vendors Section Bill Form
1.22 Vendors Section Pay Bill Form
1.23 Vendors Section Purchase Order
1.24 Vendors Section Check
2020 Employee Cycle and Other Core Features
1.25 Employee Section
1.28 Others Section
1.30 Reports
1.35 Lists
1.40 Help Options
1.45 Print & Export Reports to Excel
1.50 Backup Options
2020 Balance Sheet Reports
Data Files to Download
2.10 Balance Sheet
2.15 Balance Sheet Report Options
2.20 Header Footer Options
2.22 Formatting Options
2.30 Comparative Balance Sheet
2.40 Summary Balance Sheet
2.50 Memorize Custom Report Group
2020 Profit and Loss or Income Statement Reports
Data Files to Download
3.10 Profit and Loss
3.15 Income Statement Custom & Memorize
3.20 Comparative Profit & Loss
3.25 Vertical Analysis Profit & Loss
3.30 % of Expense Profit & Los
2020 Statement of Cash flows & Other Common Reports
Data Files to Download
4.10 Statement of Cash Flows
4.20 Sales By Customer Report
4.25 Sales by Product Or Item Report
4.30 Accounts Receivable Aging Report
4.35 Accounts Payable Aging Report
2020 Course Project Start – Set Up New Company File, Preferences, & Users
9 Start a New Company File
Data Files to Download
6.05 Set up Company Information & Preferences Part 1
6.07 Set up Company Information & Preferences Part 2
6.08 Manage Users Custom Form Styles
2020 Set Up Service & Inventory Items & Enter Inventory Beginning Balance
Data Files to Download
6.09 Objective
6.10 Items – Service Set Up Part 1
6.11 Items – Service Set Up Part 2
6.13 Items – Inventory Set Up Part 1
6.14 Items – Inventory Set Up Part 2
6.14 Items – Inventory Reports
2020 Add Customers & Vendors – Enter AR and AP Beginning Balances
Data Files to Download
6.15 Set Up Customers & Beginning Balances Part 1
6.16 Set Up Customers & Beginning Balances Part 2
6.20 Set Up Vendors & Beginning Balances
Add Accounts & Beginning Balances, Checking, Credit Card, Notes Payable, Equip.
Data Files to Download
6.25 Add Bank Account
6.26 Add Credit Card Account
6.27 Add Notes Payable Account
6.28 Add Equipment Account
2020 Adjust Equity, Payroll Options, & Reports
Data Files to Download
6.35 Payroll Options
6.50 Adjust Beginning Account Balances
6.55 Generate Transaction Detail Report
2020 Month 1 – Deposits from Owner & Loan, Purchase Furniture, Sales Tax Set Up
Data Files to Download
7.05 Record Owner & Loan Deposit
7.10 Record Purchase Furniture
7.10 Part 2 Short Term Investment
7.16 Sales Tax Set Up
2020 Month 1 – Purchase Orders & Invoices
Data Files to Download
7.17 Purchase Order Part 1
7.18 Purchase Order & Add Inventory Item
7.20 Create an Invoice with Inventory Part 1
7.20 Create an Invoice with Inventory Part 2
2020 Month 1 – Receive Payments Forms
Data Files to Download
7.25 Part 1 Receive Payment
7.25 Part 2 Receive Payment
2020 Month 1 – Sales Receipt & Deposit
Data Files to Download
7.30 Part 1 Sales Receipt Part 1
7.30 Part 2 Sales Receipt Service Item
7.35 Deposit Records Group Deposits
2020 Month 1 – Receive Inventory & Link Expense Form to Purchase Order
Data Files to Download
7.40 Inventory Payment Link to P.O. Part 1
7.40 Inventory Payment Link to P.O. Part 2
2020 Month 1 – Create Invoice From Linked Billable Expense & Make Deposit
Data Files to Download
7.45 Invoice Created By Billable Expense Part 1
7.46 Create Invoice From Billable Expense Part 2
7.50 Receive Payment & Make Deposit
2020 Month 1 – Enter Checks & Expenses & Pay Bills
Data Files to Download
7.55 Enter Check & Expense Forms
7.60 Pay Bills
2020 Month 1 – Customer Jobs & Sub Customers, Projects, & Payroll
Data Files to Download
7.65 Customer Jobs or Sub Customer
7.70 Pay Employees Part 1
7.71 Pay Employees Part 2
7.75 Job or Sub Customer Sales Receipt
2020 Month 1 – Reports & Review of Data Input
Data Files to Download
7.80 Generate Report Export to Excel
2020 Month 2 – Loan Payments & Short Term Investment Sale
Data Files to Download
8.02 Consolidate Loans
8.03 Loan Amortization Table
8.05 Make Loan Payments
8.10 Short Term Investment Deposit
2020 Month 2–Purchase Order, Enter Bill for Inventory, Sales Receipt, & Deposit
Data Files to Download
8.15 Purchase Order With New Inventory Item
8.20 Receive Inventory Requested With P.O. Enter Bill
8.25 Sales Receipts & Deposit
2020 Month 2 – Advanced Payments & Apply Credit to Invoice
Data Files to Download
8.30 Advanced Payment From Customer
8.35 Apply Credit Or Advanced Payment to Invoice
8.40 Record Sales on Account
8.45 Advance Customer Payment or Deposit
2020 Month 2 – Enter Bills, Pay Bills, Customer Payment, Pay Sales & Payroll Tax
Data Files to Download
8.50 Bills Track & Pay
8.55 Customer Payment & Deposit
8.60 Pay Sales Tax
8.65 Pay Payroll Tax
8.70 Enter Bills & Pay Bills
2020 Month 2 – New Service Items to Invoice, Finance Equipment, & Payroll
Data Files to Download
8.75 Enter Service Items & Invoices
8.77 Purchase Equipment with Debt
8.80 Payroll
8.90 Rental Income New Service Item New Income Account
2020 Month 2 – Month End Reports
Data Files to Download
8.95 Comparative Financial Statements
2020 Bank Reconciliations
13 Bank Reconciliation
Data Files to Download
9.02 Bank Reconciliation Objective
9.10 Bank Reconciliation First Month Part 1 Deposits
9.11 Bank Reconciliation First Month Part 2
9.12 Bank Reconciliation First Month Part 3 Review Report
9.14 Bank Reconciliation Second Month Part 1
9.15 ank Reconciliation Second Month Part 2
9.17 Bank Reconciliation Second Month Part 3
2020 Month End Adjusting Entries & Reversing Entries
14 Adjusting Entries and Reversing Entries
Data Files to Download
10.10 Short Term Loan Adjusting Entry
10.11 Short Term Portion Of Loan Adjusting Entry
10.15 Accrued Interest Adjusting Entry
10.17 Reversing Entry Notes Payable
10.25 Invoice & AR Adjusting Entry Part 1 The Problem
10.26 Invoice & AR Adjusting Entry Part 2 Solution
10.25 Accrued Interest Reversing Entry
10.35 Accounts Receivable Reversing Entry
10.40 Prepaid Insurance Adjusting Entry
10.45 Depreciation Adjusting Entry
10.45 Unearned Revenue Adjusting Entry
10.55 Unearned Revenue Reversing Entry
10.57 Journal Report & Financial Statements
2020 Budgeting
11.10 Budgeted Profit and Loss-Data Input
11.15 Budgeted Profit and Loss Report
2020 Bank Feeds
Data Files to Download
315 How Do Bank Feeds Fit Into My Accounting System
320 Project Outline
325 Set Up Bank Feeds
360 Download Transactions From Bank
365 Import Bank Data
370 Add Expense transactions
375 Add Capital Expenditures
380 Add Inventory Purchase
385 Add Amount Paid for Investment
390 Add Owner Withdraws
395 Add Bank Service Charge
395 Add Customer Deposits
400 Sales Tax
405 Deposit Loan
405 Deposit Owner
407 Bank Reconciliation
410 Compare Cash to Accrual
415 Upload Bank Transactions
420 Add Expenses
420 Add Insurance
425 Add Payroll Checks
430 Add Inventory
430 Add Loan Payments
435 Add Draw
440 Invoice & Bank Feeds
440 Receive Payments & Bank Feeds
445 Sales Receipt & Bank Feeds
450 Bank Reconciliation
455 Reports After Second Month
460 Credit Card Bank Feeds Upload
465 Add Credit Card Bank Feed Data
470 Reconcile Credit Card
470 Upload Bank Transactions
475 Bank Rules Deposit Same Customer Different Account
480 Bank Rules Amount Limit
485 Bank Rules Split Into Two Accounts
490 Bank Rules One Vendor Two Expense Accounts
495 Bank Rules More Rules & Techniques
Payroll
250 Paid Payroll QuickBooks Online New Company
255 Purchase Payroll Payroll Options
257 Payroll Set Up Process After Purchased
258 Add Checking Account to Chart of Accounts
260 Process Payroll Plain Payroll
261 Payroll Tax Forms & Payment Set Up
262 Payroll Forms After Plain Payroll Financials & 941
264 Add 401(K) Payroll Item
266 Process Payroll With 401(K) Plan
268 Payroll Forms After Payroll With 401(K) Plan
270 Process Payroll 401 K Employer Match
272 Payroll Forms After 401(K) With Employer Matching
274 Payroll Item Setup Dental Insurance Employee Paid After Tax
276 Process Payroll After Adding Dental Insurance Employee Paid After Tax
278 Reports After Payroll Item Setup Dental Insurance Employee Paid After Tax
280 Payroll Item Setup Vision Insurance Employee Paid Before Taxes
282 Process Payroll with Vision Insurance Employee Paid Before Taxes
284 Payroll Reports After Vision Insurance Employee Paid Before Taxes
285 New Employee Add
286 Payroll Item Setup Health Insurance Employer paid
288 Process Payroll With Health Insurance Employer paid
290 Payroll Reports With Health Insurance Employer Paid
298 Payroll Item Setup Health Savings Account
300 Process Payroll With Health Savings Account
302 Payroll Forms Health Savings Account
304 Payroll Items Setup Garnishments
306 Process Payroll With Garnishments
308 Payroll Forms With Garnishments
310 Payroll Item Setup Paid Sick Time Off
312 Process Payroll With Paid Sick Time Off
314 S-Corp Owner Payroll & S Corp Medical Insurance Item Setup
316 Process Payroll With S Corp Medical Insurance Item Setup
318 Payroll Forms With S Corp Medical Insurance Item Setup
320 Process Payroll That Includes A Bonus
322 Process Payroll Forms With Year End Bonus
‘;
}});
328 Payroll Report Compared To Income Statement
330 Setup Owner Payroll Expense Account
335 Form W-3
