Please ensure Javascript is enabled for purposes of website accessibility
QuickBooks Online 2022 Vs Excel #1 - Navigation, Forms, And Reports
0( 0 REVIEWS )
2 STUDENTS
23h 34m

Learn the basics of setting up an accounting system using QuickBooks Online and Microsoft Excel.

Read more.
Course Skill Level
Beginner
Time Estimate
23h 34m

Instructor

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 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 2022

This course will compare the process of creating an accounting system in both 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

The QuickBooks related sections of the course will cover the following:

We will first talk about how to get access to QuickBooks Online, possibly with the 30-day free trial often offered by QuickBooks, the 30-day free trial being a perfect tool for a course like this.

Using the test drive company file provided 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.

The Excel related sections of the course will cover the following:

In this course 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.

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 - Getting Started
Documents To Download 00:00:00
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 - 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
Section 3 - 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 4 - 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 5 - Customer Cycle, Sales Cycle Or Accounts Receivable Cycle
1300 Customer, Accounts Receivable, Or Get Paid Cycle 00:00:00
1320 Customer, Accounts Receivable, Or Get Paid 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 Or Trade Transaction 00:00:00
1420 Credit Memo Bad Debt Sales Returns 00:00:00
1422 Refund Receipt Form 00:00:00
1425 Delayed Credit And Credit Memo 00:00:00
1427 Estimate 00:00:00
Section 6 - 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 7 - 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 Qty 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 8 - Excel - Employee Cycle - Payroll Cycle Transactions
1520 Pay Employees Form 00:00:00
1522 Pay Employees Form Part 2 00:00:00
Section 9 - List Of Chart Of Accounts Items List
1560 Lists 00:00:00
1580 Chart Of Accounts 00:00:00
1600 Products And Services List 00:00:00
Section 10 - Help Or Support And Reports Overview
1620 Help And Support 00:00:00
1640 Reports 00:00:00
Section 11 - Balance Sheet Report
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 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 12 - Profit And Loss Or Income Statement
3020 Profit And Loss, P And L, Income Statement Overview 00:00:00
3060 Vertical Analysis, Profit Loss, P And L, Income Statement 00:00:00
3040 Comparative Profit And Loss, P And L, 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