Quickbooks Online Vs Quickbooks Desktop Vs Excel

QuickBooks and Excel accounting cycle, reporting financial transaction to both QuickBooks and Excel compare and contrast

Last updated 2022-01-10 | 3.9

- Enter normal business transactions in QuickBooks
- Enter normal business transactions in Excel using debits and credits
- Reconcile bank accounts in QuickBooks

What you'll learn

Enter normal business transactions in QuickBooks
Enter normal business transactions in Excel using debits and credits
Reconcile bank accounts in QuickBooks
Reconcile bank accounts in Excel
Generate Reports in QuickBooks
Make Reports in Excel
Analyze Reports
Add new employees
Generate reports
Export reports to Excel

* Requirements

* QuickBooks Software would be best although we can review the content without the software

Description

Would we like to run our business better using accounting software?

Would we like to better understand accounting concepts, how they apply to accounting software, and work accounting problems MUCH faster?

Would we like to advance our career by increase our skills with business software?

This comprehensive QuickBooks Online, QuickBooks Desktop & Excel course can help to achieve these goals

Why choose this course?

Current video content means all QuickBooks lectures are done recently as of this post rather than adding a few new videos to content from prior years.

This course also includes:

  • Excel worksheet that are formatted so that we can concentrate on the accounting relationships and on using the fundamentals of Excel.
  • PDF files providing a reference to material as well as the ability to work part of the problem without internet connection
  • QuickBooks backup files allowing us to jump to future parts of the course of go back to prior components. 

Who will we be learning from?

You will be learning from somebody who has technical experience in accounting concepts and in accounting software like QuickBooks, as well as experience teaching and putting together curriculum.

You will be learning from somebody who is a:

  • CPA – Certified Public Accountant
  • CGMA – Chartered Global Management Accountant
  • Master of Science in Taxation
  • CPS – Certifies Post-Secondary Instructor
  • Curriculum Development Export

As a practicing CPA the instructor has worked with many technical accounting issues and helped work through them and discuss them with client of all levels.

As a CPS and professor, the instructor has taught many accounting classes and worked with many students in the fields of accounting, business, and business applications.

The instructor also has a lot of experience designing courses and learning how students learn best and how to help students achieve their objectives. Experience designing technical courses has also help in being able to design a course in a logical fashion and deal with problems related to technical topics and the use of software like QuickBooks Pro.

How will we be Taught?

We will learn by doing, by providing a presentation, and providing the tools to work through the processes presented. Learning QuickBooks and Excel is something best learned by doing, by applying skills to the QuickBooks application.

A partial list of topics covered is below.

  • Start a New Company File
  • Accounting Methods
  • Enter Data for the First Month of Operations
  • Enter Data for the Second Month of Operation
  • Bank Reconciliations
  • Adjusting Entries and Reversing Entries

Please Join Use for QuickBooks Desktop 2018 vs. Excel Course. It will be Great

Who this course is for:

  • Business Owners
  • Accounting Professionals
  • Bookkeepers
  • Accounting Students

Course content

7 sections • 314 lectures

Start a New Company File Section Overview Preview 02:12

PDF 6.05 Preview 00:53

Desktop 6.05 Set Up New Company & Preferences Preview 30:40

Online - 6.05 Set Up New Company & Preferences Preview 12:29

Excel Files 6.05 Preview 01:17

Excel 6.05 Set up New Company Worksheet Preview 14:22

PDF 6.10 Preview 00:08

QuickBooks Backup File Preview 02:50

Desktop 6.10 Setting Up Items Preview 26:36

Online - 6.10 Part 1 Item - Service Set Up Preview 18:31

Online - 6.10 Part 2 Item - Service Set Up Preview 28:55

Excel Files 6.10 Preview 00:14

Excel 6.10 Set Up Inventory Items Preview 34:28

PDF 6.15 Preview 00:08

Desktop 6.15 Customer Setup Preview 14:05

Online - 6.15 Customer Balance Setup Preview 19:37

Excel Files 6.15 Preview 00:14

Excel 6.15 Set Up Customer Balances Preview 13:52

PDF 6.20 Preview 00:08

Desktop 6.20 Set up Vendors and Beginning Balances Preview 16:18

Online - 6.20 Vendor - New Vendor & Opening Balance Preview 07:28

Excel Files 6.20 Preview 00:14

Excel 6.20 Set Up Vendors Beginning Balances Preview 12:44

PDF 6.25 Preview 00:08

QuickBooks Backup File Preview 00:28

Desktop 6.25 Set up new account & Enter Opening Balances Preview 29:56

Online - 6.25 Set up New Accounts & Export Trial Balance to Excel Preview 16:28

Excel Files 6.25 Preview 00:14

Excel - 6.25 Enter Opening Account Balances Preview 24:16

PDF 6.30 Preview 00:08

Desktop 6.30 Adjust New Account Balances Preview 17:59

PDF 6.35 Preview 00:08

Desktop 6.35 Payroll Set Up Preview 08:51

Online - 6.35 Payroll Options Preview 06:41

PDF 6.40 Preview 00:08

Desktop 6.40 New Employee Setup Preview 24:58

Online - 6.40 Set Up New Employees Preview 09:54

Desktop 6.45 Export Transaction List By Date Preview 19:07

Online - 6.45 Transaction List by Date Preview 12:21

Accounting Comic Break Preview 00:14

Accounting Concepts Section Overview Preview 01:10

Cash Method Vs Accrual Method Preview 16:19

Revenue Recognition Principle Preview 08:49

Financial Transaction Rules Preview 07:48

Enter Data for the First Month of Operations Section Overview Preview 03:41

PDF 7.05 Preview 00:08

QuickBooks Backup File Preview 00:28

Desktop 7.05 Record Deposit from Owner & Loan Preview 11:15

Online - 7.05 Record Owner & Loan Deposit Preview 08:47

Excel 7.05 Owner Deposit & Loan Deposit Preview 00:14

PDF 7.10 Preview 00:08

Desktop 7.10 Record Transactions In Register Investment & Furniture Preview 23:17

Online - 7.10 Part 1 Record Purchase Furniture Preview 09:15

Online - 7.10 Part 2 Record Short-Term Investment Preview 10:30

Excel 7.10 Purchase Furniture & Record Investment Preview 00:14

Online - 7.16 Sales Tax u Preview 12:08

PDF 7.17 Preview 00:08

Desktop 7.17 Purchase Order Preview 18:06

Online - 7.17 Part 1 Purchase Order Preview 09:34

Online - 7.17 Part 2 Purchase Order Add Inventory Item Preview 08:10

PDF 7.20 Preview 00:08

Desktop 7.20 Create an Invoice Preview 25:20

Online - 7.20 Part 1 Create Invoice with Inventory Preview 15:17

Online - 7.20 Part 2 Invoice with Inventory Preview 13:13

Excel Files 7.20 Preview 00:14

Excel 7.20 Part 1 Invoice Transaction Preview 30:00

Excel 7.20 Part Two Create on Invoice Transaction Preview 24:12

Online - 7.23 Undeposited Funds Set Up Preview 03:29

PDF 7.25 Preview 00:08

Desktop 7.25 Record Receipt of Payment Preview 16:58

Online - 7.25 Part 1 Receive Payment f Preview 06:47

Online - 7.25 Part 2 Receive Payment Preview 07:25

Excel Files 7.25 Preview 00:14

Excel 7.25 Receive Payment Part 1 Preview 11:49

Excel 7.25 Receive Payment Part 2 Preview 10:12

Excel 7.25 Receive Payment Part 3 Preview 08:53

PDF 7.30 Preview 00:08

QuickBooks Backup File Preview 00:28

Desktop 7.30 Sales Receipts Cash Sales Transaction Preview 23:33

Online - 7.30 Part 1 Sales Receipt f Preview 15:06

Online - 7.30 Part 2 Sales Receipt Preview 11:00

Excel Files 7.30 Preview 00:14

Excel 7.30 Cash Sales Transaction Part 1 Preview 23:45

Excel 7.30 Part 2 Cash Sales Service Preview 11:56

Online - 7.32 Sales Receipt & Payment Correct Preview 10:40

PDF 7.35 Preview 00:08

Desktop 7.35 Deposit Preview 19:06

Online - 7.35 Deposit Record Preview 10:38

Excel Files 7.35 Preview 00:14

Excel 7.35 Deposit Part 1 Preview 10:35

Excel 7.35 Deposit Part 2 Preview 12:53

Online - 7.37 Expense Billable Setting Turn On Preview 03:11

PDF 7.40 Preview 00:08

Desktop 7.40 Write Check for Inventory from Purchase Order Preview 22:55

Online - 7.40 Inventory Payment Tied to Purchase Order f Preview 11:13

Online - 7.40 Part 2 Inventory Payment Tied to Purchase order f Preview 08:51

Excel Files 7.40 Preview 00:14

Excel 7.40 Part 1 Inventory Payment Preview 17:31

Excel 7.40 Part 2 Inventory Payment Preview 14:57

Online - 7.42 Correct Check Add Billable Customer Preview 09:15

PDF 7.45 Preview 00:08

Desktop 7.45 Invoice for Pre-Order Inventory P.O. Preview 19:50

Online - 7.45 Part 1 Invoice Created by Billable Expense Preview 15:08

Online - 7.45 Part 2 Invoice Populated By Billable Expense Preview 22:26

Excel Files 7.45 Preview 00:14

Excel 7.45 Invoice for Preordered Item Part 1 Preview 25:24

Excel 7.45 Invoice for Preordered Item Part 2 Preview 23:02

PDF 7.50 Preview 00:08

Online - 7.50 Receive Payment & Make Deposit Preview 11:29

Desktop 7.50 Receive Payment & Make Deposit Preview 17:59

Excel Files 7.50 Preview 00:14

Excel 7.50 Receive Payment & Make Deposit Preview 19:59

PDF 7.55 Preview 00:08

Desktop 7.55 Write Check for Expenses Preview 25:17

Online - 7.55 Write Checks for Expenses Preview 17:39

Excel Files 7.55 Preview 00:14

Excel 7.55 Part 1 Write Check Preview 16:39

Excel 7.55 Part 2 Write Check Part 2 Preview 15:48

PDF 7.60 Preview 00:08

Desktop 7.60 Pay Bills Preview 15:02

Online - 7.60 Pay Bills Preview 09:08

Excel Files 7.60 Preview 00:14

Excel 7.60 Pay Bills Preview 11:00

PDF 7.65 Preview 00:08

Desktop 7.65 Set Up Customer Jobs Preview 06:12

Online - 7.65 Customer Jobs or Sub Customers Preview 04:40

Excel Files 7.65 Preview 00:14

Excel 7.65 Customer Jobs Preview 05:19

PDF 7.70 Preview 00:08

Desktop 7.70 Payroll Process Check Preview 26:09

Online - 7.70 Pay Employees Preview 32:25

Excel Files 7.70 Preview 00:14

Excel - 7.70 Payroll Preview 33:28

PDF 7.75 Preview 00:08

QuickBooks Backup File Preview 00:28

Desktop 7.75 Job Sales Receipt Preview 11:08

Online - 7.75 Job or Sub-Customer Sales Receipt Preview 09:14

Excel Files 7.75 Preview 00:14

Excel 7.75 Job Sales Receipt Preview 09:39

PDF 7.80 Preview 00:08

Desktop 7.80 Review Reports & Export to Excel Preview 18:57

Online - 7.80 Generate Report & Export to Excel Preview 21:49

Excel Files 7.80 Preview 00:14

Excel 7.80 Financial Statements & Reports Preview 40:44

Excel Files 7.90 Preview 00:14

Excel 7.90 Closing Process January Preview 27:04

Excel Files 7.92 Preview 00:14

Excel 7.92 Worksheet Month Two Preview 06:33

Enter Data for the Second Month of Operation Section Overview Preview 03:35

PDF 8.05 Preview 00:08

QuickBooks Backup File Preview 00:28

Online - 8.05 Loan Payments Preview 19:50

Desktop 8.05 Loan Payments, Interest, Principle Preview 23:08

Excel Files 8.05 Preview 00:14

Excel 8.05 Make Loan Payments Preview 29:16

PDF 8.10 Preview 00:08

Desktop 8.10 Deposit Investment & Interest Preview 11:32

Online - 8.10 Short Term Investment Deposit Preview 10:20

Excel Files 8.10 Preview 00:14

Excel 8.10 Short Term Investment Preview 11:42

PDF 8.15 Preview 00:08

Online - 8.15 Purchase Order New Item Payment Preview 11:06

Desktop 8.15 Purchase Order New Item & Customer Preview 09:54

PDF 8.20 Preview 00:08

Desktop 8.20 Receive Inventory with Bill Preview 11:59

Online - 8.20 Receive Inventory With Bill Preview 15:41

Excel Files 8.20 Preview 00:14

Excel - 8.20 Receive Inventory With Bill Part 1 Preview 15:39

Excel - 8.20 Receive Inventory With Bill Part 2 Preview 15:41

PDF 8.25 Preview 00:08

Desktop 8.25 Sales Receipt & Deposit Preview 14:27

Online - 8.25 Sales Receipt & Deposit Preview 16:44

Excel Files 8.25 Preview 00:14

Excel 8.25 Sales Receipt & Deposit Preview 18:16

Excel 8.25 Part 2 Sales Receipt & Deposit Preview 06:53

PDF 8.30 Preview 00:08

Desktop 8.30 Advanced Payment From Customer Preview 07:30

Online - 8.30 Advanced Payment From Customer Preview 10:40

Excel Files 8.30 Preview 00:14

Excel 8.30 Advanced Payment From Customer Preview 12:03

PDF 8.35 Preview 00:08

Desktop 8.35 Apply Credit to Invoice Preview 11:04

Online - 8.35 Apply Credit to Invoice Preview 16:48

Excel Files 8.35 Preview 00:14

Excel 8.35 Apply Credit to Invoice Preview 21:39

PDF 8.40 Preview 00:08

Desktop 8.40 Record Sale on Account Preview 13:21

Online - 8.40 Record Sale on Account Preview 19:08

Excel Files 8.40 Preview 00:14

Excel 8.40 Record Sales on Account Preview 32:33

PDF 8.45 Preview 00:08

Desktop 8.45 Advance Customer Payment Preview 08:17

Online - 8.45 Advance Customer Payment Preview 09:11

Excel Files 8.45 Preview 00:14

Excel 8.45 Advance Customer Payment Preview 13:36

PDF 8.50 Preview 00:08

Desktop 8.50 Bills Track & Pay Preview 10:54

Online - 8.50 Bills - Track & Pay Preview 10:01

Excel Files 8.50 Preview 00:14

Excel 8.50 Bills Track & Pay Preview 11:07

PDF 8.55 Preview 00:08

QuickBooks Backup File Preview 00:28

Desktop 8.55 Customer Payment on Account & Deposit Preview 17:38

Online - 8.55 Customer Payment on Account Preview 14:09

Excel Files 8.55 Preview 00:14

Excel 8.55 Customer Payment on Account Preview 19:14

PDF 8.60 Preview 00:08

Desktop 8.60 Pay Sales Tax Preview 13:19

Online - 8.60 Pay Sales Tax Preview 14:07

Excel Files 8.60 Preview 00:14

Excel 8.60 Pay Sales Tax Preview 10:16

PDF 8.65 Preview 00:08

Desktop 8.65 Pay Payroll Taxes Preview 18:15

Online - 8.65 Pay Payroll Taxes Preview 17:41

Excel Files 8.65 Preview 10:21

Excel 8.65 Pay Payroll Tax Preview 00:14

PDF 8.70 Preview 00:08

Desktop 8.70 Enter Bills & Pay Bills Preview 22:27

Online - 8.70 Enter Bills & Pay Bills Preview 24:56

Excel Files 8.70 Preview 31:43

Excel 8.70 Enter Bills & Pay Bills Preview 00:14

PDF 8.75 Preview 00:08

Desktop 8.75 Enter Service Item & Invoices Preview 23:03

Online - 8.75 Enter Service Item & Invoice Preview 28:05

Excel Files 8.75 Preview 00:14

Excel 8.75 Service Item & Invoices Preview 46:46

PDF 8.77 Preview 00:08

Desktop 8.77 Purchase Equipment with Debt Preview 08:05

Online - 8.77 Purchase Music Equipment with loan Preview 11:21

Excel Files 8.77 Preview 00:14

Excel 8.77 Purchase Equipment with Debt Preview 10:36

PDF 8.80 Preview 00:08

Desktop 8.80 Enter Payroll Preview 22:35

Online - 8.80 Payroll Preview 31:18

Excel Files 8.80 Preview 00:14

Excel 8.80 Payroll Preview 35:31

PDF 8.90 Preview 00:08

Desktop 8.90 Rental Income, New Account, New Item Preview 11:19

Online - 8.90 Rental Income Preview 16:05

Excel Files 8.90 Preview 00:14

Excel 8.90 Rental Income Preview 08:16

PDF 8.95 Preview 00:08

Desktop 8.95 Comparative Balance Sheet & Income Statement Preview 20:54

Online - 8.95 Comparative Financial Statements Preview 29:51

Excel Files 8.95 Preview 00:14

Excel 8.95 Financial Statements Preview 06:40

Bank Reconciliations Section Overview Preview 04:25

PDF 9.10 Preview 00:08

Desktop 9.10 Bank Reconciliation First Bank Reconciliation Preview 00:28

Excel Files 9.10 Preview 23:29

Excel 9.10 Bank Reconciliation January Preview 23:29

Excel 9.12 Bank Reconciliation Adjusting Entries January Preview 17:48

PDF 9.15 Preview 00:08

Desktop 9.15 Bank Reconciliation Second Bank Reconciliation Preview 30:03

Excel Files 9.15 Preview 21:01

Excel 9.15 Bank Reconciliation February Preview 21:01

Excel 9.20 Bank Reconciliation Feb. Adjusting Entries Preview 14:16

Adjusting Entries, Financial Statements, Closing Entries, and Reversing Entries Preview 05:29

PDF 10.10 Preview 00:08

Desktop 10.10 Short term loan Adjusting Entry Preview 13:39

Online - 10.10 Short Term Loan Preview 27:59

Excel Files 10.10 Preview 00:14

Excel 10.10 Loan Payable Adjusting Entry Part 1 Preview 21:01

PDF 10.15 Preview 00:08

Desktop 10.15 Short term portion of loan Adjusting Entry Preview 13:57

Online - 10.15 Short Term Loan #2 Preview 23:38

Excel Files 10.15 Preview 00:14

Excel 10.15 Loan Payable Adjusting Entry Part 2 Preview 14:33

PDF 10.20 Preview 00:08

Desktop 10.20 Accrued Interest Adjusting entry Preview 12:45

Online - 10.20 Accrued Interest Adjusting Entry Preview 14:18

Excel Files 10.20 Preview 00:14

Excel 10.20 Accrued Interest Adjusting Entry Preview 09:25

PDF 10.25 Preview 00:08

Desktop 10.25 Invoice Adjusting Entry Preview 22:13

Online - 10.25 Invoice Adjusting Entry Preview 25:54

Excel Files 10.25 Preview 00:14

Excel 10.25 Invoice Adjusting Entry Preview 13:57

PDF 10.40 Preview 00:08

Desktop 10.40 Prepaid Insurance Adjusting Entry Preview 10:50

Online - 10.40 Prepaid Insurance Adjusting Entry Preview 13:37

Excel Files 10.40 Preview 00:14

Excel 10.40 Prepaid Insurance Adjusting Journal Entry Preview 08:39

PDF 10.45 Preview 00:08

Desktop 10.45 Depreciation Adjusting Journal Entry Preview 11:58

Online - 10.45 Depreciation Adjusting Entry Preview 18:35

Excel Files 10.45 Preview 00:14

Excel 10.45 Depreciation Adjusting Entry Preview 10:53

PDF 10.50 Preview 00:08

Desktop 10.50 Unearned Revenue Adjusting Entry Preview 13:58

Online - 10.50 Unearned Revenue Adjusting Entry Preview 19:10

Excel Files 10.50 Preview 00:14

Excel 10.50 Unearned Revenue Adjusting Entry Preview 10:43

Desktop 10.30 Reversing Entry Accrued Interest Preview 08:50

Online - 10.30 Accrued Interest Reversing Entry Preview 13:54

Excel Files 10.300 Preview 00:14

Excel 10.300 Accrued Interest Reversing Entry Preview 10:20

PDF 10.35 Preview 00:08

Desktop 10.35 Reversing Entry Accounts Receivable Preview 00:14

Online - 10.35 Accounts Receivable Reversing Entry Preview 20:34

Excel Files 10.350 Preview 00:14

Excel 10.350 Accounts Receivable Reversing Entry Preview 13:21

PDF 10.55 Preview 00:08

Desktop 10.55 Reverse Unearned Revenue Adjusting Entry Preview 08:48

Online - 10.55 Reverse Unearned Revenue Adjusting Entry Preview 11:51

Excel Files 10.550 Preview 00:14

Excel 10.550 Unearned Revenue Reversing Entry Preview 09:21

PDF 10.60 Preview 00:08

Desktop 10.60 Journal Report & Financial Statements Preview 26:07

Excel Files 10.60 Preview 45:31

Excel 10.60 Financial Statements Preview 45:31

Online - 10.60 Journal Report & Financial Statements Preview 25:10

Excel 10.65 Closing Process February Preview 28:13