Please ensure Javascript is enabled for purposes of website accessibility
QuickBooks Desktop Vs Excel 2022 #1 - Navigation, Forms, And Reports
0( 0 REVIEWS )
26h 8m

Learn the process of creating an accounting system using QuickBooks Desktop and Excel.

Read more.
Course Skill Level
Time Estimate
26h 8m


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

Only want this course? Buy this course for $199 $29 and keep lifetime access. Click here

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


  • No prior knowledge is required to take this course

Software version used in the course:

  • QuickBooks Desktop 2022

This course will compare the process of creating an accounting system using QuickBooks Desktop 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 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 how to create 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 - QuickBooks Pro Desktop Overview
QuickBooks Pro Plus Desktop 2022 New Stuff 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 - 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 6 - 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 7 - 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 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 - 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 10 - Excel - Employee Cycle - Payroll Cycle Transactions
1520 Pay Employees Form 00:00:00
1522 Pay Employees Form Part 2 00:00:00
Section 11 - 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
1545 Process Payroll Forms 00:00:00
1540 Pay Payroll Liabilities Form 00:00:00
Section 12 - 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 13 - 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 14 - 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 15 - 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 16 - 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