QuickBooks Online Vs QuickBooks Desktop Vs Excel 2022 #1 - Navigation, Forms, And Reports

Learn the basics of setting up an accounting system using QuickBooks Online and Desktop as well as with Microsoft Excel. Read more.

Robert Bob

No ratings yet

Course Skill Level

Beginner

Time Estimate

40h 33m

Robert (Bob) Steele CPA, CGMA, M.S. Tax, CPI

Access all courses in our library for only $9/month with All Access Pass

Get Started with All Access Pass Buy Only This Course

About This Course
Curriculum

About This Course

Who this course is for:

Accountants
Bookkeepers
Business owners

What you’ll learn:

The process of creating an accounting system using QuickBooks Desktop, QuickBooks Online, and Excel
The core financial statement reports, the balance sheet, and the income statement or Profit and Loss

Requirements:

No prior knowledge is required to take this course

Software version used in the course:

QuickBooks Online and Desktop 2022

This course will compare the process of creating an accounting system using QuickBooks Desktop, QuickBooks Online, and Excel. Because Excel is a much more transparent tool, it will provide us a much better understanding of the workings of QuickBooks

Excel components of the course

In the Excel sections, we will build an accounting system starting with a blank Excel worksheet, creating a general journal, a general ledger, a trial balance, subledgers, and financial statements.

For each new step in the process, you will have access to a downloadable Excel Workbook, containing at least two tabs, one with the answer, the new steps having been completed, the other starting out where the prior presentation left off.

Once we have created our accounting system worksheet, we will use it to record common transactions, entering the journal entries into the general journal, posting to the general ledger, creating the trial balance, adjusting the subsidiary ledgers, and constructing the financial statements.

As we enter each transaction, we will consider the data input often used in accounting software like QuickBooks. Accounting software will use data input forms like bills, invoices, credit memos, checks, sales receipts, and more, to simplify the data input process, allowing users with little accounting experience to learn data input.

Accountants are generally more valuable when they understand both the accounting theory, the impact on financial statements of each transaction, as well as how an accounting database program like QuickBooks works, including the data input forms used to enter normal financial transactions.

Because spreadsheets are so transparent, they are the perfect tool to gain an understanding of both accounting theory and accounting software.

Conversely, building an accounting system in Excel is a great way, one of the best ways, to improve your Excel skills.

QuickBooks Desktop and Online components of the course

These sections will cover the fundamentals of QuickBooks, the things you need to know to get up and running.

We will first talk about how to get access to QuickBooks, possibly with the 30-day free trial often offered by QuickBooks.

We will practice navigating the software, locating the settings, the general ledger and other core lists, the reports, and the primary forms used to enter financial transactions.

We will break the accounting process down into accounting cycles, including the revenue or accounts receivable cycle, the purchases or expense or accounts payable cycle, and the payroll or employee cycle.

Thinking about the accounting process by cycle is much easier to visualize, the data input forms falling into place, the order and linking of many data input forms becoming much clearer.

This course will demonstrate the core financial statement reports, the balance sheet, and the income statement or profit and loss. We will then look at many other reports, considering how most will expand on, and provide more information to line items on the primary financial statement reports, the balance sheet, and income statement, or profit and loss.

Our Promise to You

By the end of this course, you will have learned the process of creating an accounting system.

10 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.

Get started today!

Course Curriculum

Section 1 QBO - Getting Started
	1005 Getting Access To Software For Free	00:00:00
	1007 30–Day Free Trial	00:00:00
	1009 Free Test Drive	00:00:00
	1011 QuickBooks Online Vs QuickBooks Desktop	00:00:00
	1012 QuickBooks Online Software Options	00:00:00
	1013 Increase Screen Size And Toggle	00:00:00
	1015 Navigation Overview	00:00:00
	1017 Bank Feeds	00:00:00
	1018 Preferences Account And Settings	00:00:00
	1080 Accounting Process And Forms Overview	00:00:00
Section 2 - QBD - Getting Started
	1009 QuickBooks Desktop Options	00:00:00
	1012 30 Day Free Trial Or Purchase Process And Download From Intuit Website	00:00:00
	1015 Install QuickBooks Pro Plus Desktop	00:00:00
	1017 Increase Display Size	00:00:00
Section 3 - Excel - Setup Worksheet
	1025 Create Accounting Worksheet Part 1	00:00:00
	1028 Create Accounting Worksheet Part 2	00:00:00
	1031 Create Accounting Worksheet Part 3	00:00:00
	1034 Create Accounting Worksheet Part 4	00:00:00
	1037 Create Accounting Worksheet Part 5	00:00:00
	1040 Create Accounting Worksheet Part 6	00:00:00
	1043 Create Accounting Worksheet Part 7	00:00:00
	1046 Create Accounting Worksheet Part 8	00:00:00
	1049 Create Accounting Worksheet Part 9	00:00:00
	1052 Create Accounting Worksheet Part 10	00:00:00
	1055 Create Accounting Worksheet Part 11	00:00:00
Section 4 - QBD - Open Practice File - Review Home Page And Accounting Cycles
	1020 Download And Open Sample File	00:00:00
	1080 Home Page Overview	00:00:00
	1100 Bank Feeds	00:00:00
	1120 Preferences	00:00:00
Section 5 - QBD - Vendor Cycle, Purchases Cycle, Or Accounts Payable Cycle
	1140 Vendors Section	00:00:00
	1160 Vendor Center	00:00:00
	1180 Bill Form	00:00:00
	1200 Pay Bills Form Check	00:00:00
	1220 Purchase Order Form	00:00:00
Section 6 - QBO - Vendor, Accounts Payable, Expenses, Or Purchases Cycle
	1155 Vendor, Expense, Purchases, Pay, Or AP Cycle	00:00:00
	1160 Vendor, Expense, Purchases, Or Pay Center	00:00:00
	1180 Bill Form	00:00:00
	1200 Pay Bills Form Check	00:00:00
	1220 Purchase Order Form – P.O.	00:00:00
	1240 Manage Sales Tax Form	00:00:00
	1260 Check And Expense Form	00:00:00
	1280 Void Check Prior Period Adjustment	00:00:00
Section 7 - Excel - Vendor, Accounts Payable, Expenses, Or Purchases Cycle
	1180 Bill Form	00:00:00
	1200 Pay Bills Form Check	00:00:00
	1260 Check Form	00:00:00
	1280 Void Check Prior Period Adjustment	00:00:00
Section 8 - QBD - Customer Cycle, Sales Cycle, Or Accounts Receivable Cycle
	1300 Customer Section Customer Cycle	00:00:00
	1320 Customer Center	00:00:00
	1340 Invoice Form	00:00:00
	1360 Receive Payment Form	00:00:00
	1380 Deposit Form	00:00:00
	1400 Sales Receipts Form	00:00:00
	1405 Barter Sale Transaction	00:00:00
	1407 Barter Sale Transaction #2 Invoice And Bill	00:00:00
	1420 Credit Memo Refund Form And Bad Debt Expense	00:00:00
Section 9 - Excel - Customer Cycle, Sales Cycle Or Accounts Receivable And Cycle Transactions
	1340 Invoice Form	00:00:00
	1360 Receive Payment Form	00:00:00
	1380 Deposit Form	00:00:00
	1400 Sales Receipts Form	00:00:00
	1420 Credit Memo Refund Form And Bad Debt Expense Service Item	00:00:00
	1488 Credit Memo with Inventory	00:00:00
Section 10 - QBD -Other Home Page Items, Shortcuts, And Customizing Shortcuts
	1440 Banking Section, Company Section And Shortcuts	00:00:00
	1460 Customize Shortcuts And Home Page Icons	00:00:00
Section 11 - QBO - Other Important Forms And Functions, Shortcuts And Employee Cycle
	1440 Other Section Banking Or Company Section	00:00:00
	1442 Transfer Form	00:00:00
	1444 Journal Entry	00:00:00
	1446 Statement Form	00:00:00
	1448 Inventory Quantity Adjustment	00:00:00
	1450 Pay Down Credit Card Form	00:00:00
	1460 Keyboard Shortcuts	00:00:00
	1480 Employee Section Payroll Process	00:00:00
	1500 Payroll Center Cycle	00:00:00
Section 12 - QBD - Employee Cycle - Payroll Cycle
	1480 Employee Section Payroll Process	00:00:00
	1500 Employee Center	00:00:00
	1520 Pay Employees Form	00:00:00
	1540 Pay Payroll Liabilities Form	00:00:00
	1545 Process Payroll Forms	00:00:00
Section 13 - Excel - Employee Cycle - Payroll Cycle Transactions
	1520 Pay Employees Form	00:00:00
	1522 Pay Employees Form Part 2	00:00:00
Section 14 - QBD - Lists - Chart Of Accounts Items List
	1560 Lists	00:00:00
	1580 Chart of Accounts	00:00:00
	1600 Item Lists	00:00:00
Section 15 - QBO - List Chart Of Accounts And Products And Services Lists
	1560 Lists	00:00:00
	1580 Chart Of Accounts	00:00:00
	1600 Products And Services List	00:00:00
Section 16 - QBD - Help Or Support, Reports Overview, And Backing Up Data File
	1620 Help And Support Options	00:00:00
	1640 Reports Overview	00:00:00
	1660 Backup File	00:00:00
Section 17 - QBO - Help Or Support And Reports Overview
	1620 Help And Support Options	00:00:00
	1640 Reports	00:00:00
Section 18 - QBD - Balance Sheet Reports
	2020 Balance Sheet Report Overview	00:00:00
	2040 Report Formatting Basics	00:00:00
	2045 Report Filters	00:00:00
	2060 Report Header And Footer Formatting	00:00:00
	2080 Report Fonts And Numbers Formatting	00:00:00
	2100 Comparative Balance Sheet Creation	00:00:00
	2120 Balance Sheet Vertical Analyses	00:00:00
	2140 Memorize Report Group Setup	00:00:00
	2160 Memorize Reports	00:00:00
	2180 Reports – Print, Save As PDF, Export To Excel Part 1	00:00:00
	2181 Export Balance Sheet to Excel	00:00:00
Section 19 - QBO - Balance Sheet Reports
	2020 Balance Sheet Report	00:00:00
	2040 Report Formatting Basics	00:00:00
	2045 Report Customization General Category	00:00:00
	2060 Report Header And Footer Formatting	00:00:00
	2080 Report Customization Filters	00:00:00
	2100 Comparative Balance Sheet Creation	00:00:00
	2120 Balance Sheet Vertical Analyses	00:00:00
	2125 Summary Balance Sheet	00:00:00
	2140 Save Customization Or Memorize Report	00:00:00
	2160 Management Reports Customization	00:00:00
	2180 Print Email And Create PDF Of Reports	00:00:00
	2181 Export Balance Sheet Reports	00:00:00
Section 20 - QBD - Income Statement - Profit And Loss Reports
	3020 Profit And Loss, P And L, Income Statement Overview	00:00:00
	3040 Comparative Profit And Loss, P And L, Income Statement	00:00:00
	3060 Vertical Analysis Profit Loss, P And L, Income Statement	00:00:00
	3080 Memorize Profit And Loss, P And L, Income Statement Reports	00:00:00
	3100 Profit And Loss Print, Save As PDF, And Create Management Report	00:00:00
	3105 Export To Excel Profit And Loss Income Statement Reports Part 2	00:00:00
Section 21 - QBO - Profit And Loss - Income Statement
	3020 Profit Loss PL Income Statement Overview	00:00:00
	3040 Comparative Profit Loss PL Income Statement	00:00:00
	3060 Vertical Analysis Profit Loss PL Income Statement	00:00:00
	3080 Save Customization Or Memorize Profit And Loss Reports	00:00:00
	3100 Profit And Loss Print, Save As PDF, And Create Management Report	00:00:00
	3105 Profit And Loss	00:00:00
Section 22 - QBO - Statement Of Cash Flows Of Supplemental Reports
	4020 Statement Of Cash Flows	00:00:00
	4040 Accounts Receivable Aging Reports	00:00:00
	4060 Accounts Payable Aging Reports	00:00:00
	4080 Sales By Customer Income By Customer Reports	00:00:00
	4120 Expense And Vendor Reports	00:00:00
	4200 Transaction List By Date Report	00:00:00
	4220 Journal Report	00:00:00
	4240 Budget Reports	00:00:00
	4320 Sales By Customer Account Item Graphs	00:00:00
	4360 Sales By Product And Service Graph	00:00:00
	4380 Internal Or External Report	00:00:00
Section 23 - QBD - Statement Of Cash Flows Of Supplemental Reports
	4020 Statement Of Cash Flows	00:00:00
	4040 Accounts Receivable Aging Reports	00:00:00
	4060 Accounts Payable Aging Reports	00:00:00
	4080 Sales By Customer And Income By Customer Reports	00:00:00
	4120 Form 1099 Report	00:00:00
	4140 Inventory Reports	00:00:00
	4160 Payroll Employee Reports	00:00:00
	4180 Banking Reports	00:00:00
	4200 Transaction List By Date Report	00:00:00
	4220 Journal Report	00:00:00
	4240 Budget Reports	00:00:00
	4260 Accounts Receivable Graphs	00:00:00
	4280 Accounts Receivable Graphs Excel	00:00:00
	4300 Accounts Payable Graphs	00:00:00
	4305 Accounts Payable Graphs In Excel	00:00:00
	4320 Sales By Customer Graphs	00:00:00
	4360 Income Expense By Month Graph	00:00:00
	4380 Internal And External Reports	00:00:00