Udemy

Platform

English

Language

Money Management Tools

Category

QuickBooks Desktop vs. Excel

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

4.45 (24 reviews)

2445

Students

37.5 hours

Content

Jun 2019

Last Update
$94.99
Regular Price


What you will 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


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 & 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:

  • QuickBooks backup files allowing us to jump forward in the course or to rework sections.
  • PDF instruction files to support the entering of QuickBooks data and allowing us to do work offline
  • Excel worksheet that are formatted so that we can consentrate on the accounting relationships and on using the fundamentals of Excel.

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. The number series may change, however.

Start a New Company File

  • Start a New Company File Section Overview
  • QuickBooks 6.05 Set Up New Company & Preferences
  • Excel 6.05 Set up New Company Worksheet
  • QuickBooks 6.10 Setting Up Items
  • Excel 6.10 Set Up Inventory Items
  • QuickBooks 6.15 Customer Setup
  • Excel 6.15 Set Up Customer Balances
  • QuickBooks 6.20 Set up Vendors and Beginning Balances
  • Excel 6.20 Set Up Vendors Beginning Balances
  • QuickBooks 6.25 Set up new account & Enter Opening Balances
  • Excel 6.25 Enter Opening Account Balances
  • QuickBooks 6.30 Adjust New Account Balances
  • QuickBooks 6.35 Payroll Set Up
  • QuickBooks 6.40 New Employee Setup
  • QuickBooks 6.45 Export Transaction List By Date

Accounting Methods

  • Accounting Concepts Section Overview
  • Accounting Method Overview
  • Cash Method Vs Accrual Method
  • Revenue Recognition Principle
  • Financial Transaction Rules

Enter Data for the First Month of Operations

  • Enter Data for the First Month of Operations Section Overview
  • QuickBooks 7.05 Record Deposit from Owner & Loan
  • Excel 7.05 Owner Deposit & Loan Deposit
  • QuickBooks 7.10 Record Transactions In Register Investment & Furniture
  • Excel 7.10 Purchase Furniture & Record Investment
  • QuickBooks 7.17 Purchase Order
  • QuickBooks 7.20 Create an Invoice
  • Excel 7.20 Part 1 Invoice Transaction
  • Excel 7.20 Part Two Create on Invoice Transaction
  • QuickBooks 7.25 Record Receipt of Payment
  • Excel 7.25 Receive Payment Part 1
  • Excel 7.25 Receive Payment Part 2
  • Excel 7.25 Receive Payment Part 3
  • QuickBooks 7.30 Sales Receipts Cash Sales Transaction
  • Excel 7.30 Cash Sales Transaction Part 1
  • Excel 7.30 Part 2 Cash Sales Service
  • QuickBooks 7.35 Deposit
  • Excel 7.35 Deposit Part 1
  • Excel 7.35 Deposit Part 2
  • QuickBooks 7.40 Write Check for Inventory from Purchase Order
  • Excel 7.40 Part 1 Inventory Payment
  • Excel 7.40 Part 2 Inventory Payment
  • QuickBooks 7.45 Invoice for Pre-Order Inventory P.O.
  • Excel 7.45 Invoice for Preordered Item Part 1
  • Excel 7.45 Invoice for Preordered Item Part 2
  • QuickBooks 7.50 Receive Payment & Make Deposit
  • Excel 7.50 Receive Payment & Make Deposit
  • QuickBooks 7.55 Write Check for Expenses
  • Excel 7.55 Part 1 Write Check
  • Excel 7.55 Part 2 Write Check Part 2
  • QuickBooks 7.60 Pay Bills
  • Excel 7.60 Pay Bills
  • QuickBooks 7.65 Set Up Customer Jobs
  • Excel 7.65 Customer Jobs
  • QuickBooks 7.70 Payroll Process Check
  • Excel 7.70 Payroll
  • QuickBooks 7.75 Job Sales Receipt
  • Excel 7.75 Job Sales Receipt
  • QuickBooks 7.80 Review Reports & Export to Excel
  • Excel 7.80 Financial Statements & Reports
  • Excel 7.90 Closing Process January
  • Excel 7.92 Worksheet Month Two

Enter Data for the Second Month of Operation

  • Enter Data for the Second Month of Operation Section Overview
  • QuickBooks 8.05 Loan Payments, Interest, Principle
  • Excel 8.05 Make Loan Payments
  • QuickBooks 8.10 Deposit Investment & Interest
  • Excel 8.10 Short Term Investment
  • QuickBooks 8.15 Purchase Order New Item & Customer
  • QuickBooks 8.20 Receive Inventory with Bill
  • Excel 8.20 Receive Inventory With Bill Part 2
  • QuickBooks 8.25 Sales Receipt & Deposit
  • Excel 8.25 Sales Receipt & Deposit
  • Excel 8.25 Part 2 Sales Receipt & Deposit
  • QuickBooks 8.30 Advanced Payment From Customer
  • Excel 8.30 Advanced Payment From Customer
  • QuickBooks 8.35 Apply Credit to Invoice
  • Excel 8.35 Apply Credit to Invoice
  • QuickBooks 8.40 Record Sale on Account
  • Excel 8.40 Record Sales on Account
  • QuickBooks 8.45 Advance Customer Payment
  • Excel 8.45 Advance Customer Payment
  • QuickBooks 8.50 Bills Track & Pay
  • Excel 8.50 Bills Track & Pay
  • QuickBooks 8.55 Customer Payment on Account & Deposit
  • Excel 8.55 Customer Payment on Account
  • QuickBooks 8.60 Pay Sales Tax
  • Excel 8.60 Pay Sales Tax
  • QuickBooks 8.65 Pay Payroll Taxes
  • Excel 8.65 Pay Payroll Tax
  • QuickBooks 8.70 Enter Bills & Pay Bills
  • Excel 8.70 Enter Bills & Pay Bills
  • QuickBooks 8.75 Enter Service Item & Invoices
  • Excel 8.75 Service Item & Invoices
  • QuickBooks 8.77 Purchase Equipment with Debt
  • Excel 8.77 Purchase Equipment with Debt
  • QuickBooks 8.80 Enter Payroll
  • Excel 8.80 Payroll
  • QuickBooks 8.90 Rental Income, New Account, New Item
  • Excel 8.90 Rental Income
  • QuickBooks 8.95 Comparative Balance Sheet & Income Statement
  • Excel 8.95 Financial Statements

Bank Reconciliations

  • Bank Reconciliations Section Overview
  • QuickBooks 9.10 Bank Reconciliation First Bank Reconciliation
  • Excel 9.10 Bank Reconciliation January
  • Excel 9.12 Bank Reconciliation Adjusting Entries January
  • QuickBooks 9.15 Bank Reconciliation Second Bank Reconciliation
  • Excel 9.15 Bank Reconciliation February
  • Excel 9.20 Bank Reconciliation Feb. Adjusting Entries

Adjusting Entries and Reversing Entries

  • Adjusting Entries, Financial Statements, Closing Entries, and Reversing Entries
  • QuickBooks 10.10 Short term loan Adjusting Entry
  • Excel 10.10 Loan Payable Adjusting Entry Part 1
  • QuickBooks 10.15 Short term portion of loan Adjusting Entry
  • Excel 10.15 Loan Payable Adjusting Entry Part 2
  • QuickBooks 10.20 Accrued Interest Adjusting entry
  • Excel 10.20 Accrued Interest Adjusting Entry
  • QuickBooks 10.25 Invoice Adjusting Entry
  • Excel 10.25 Invoice Adjusting Entry
  • QuickBooks 10.40 Prepaid Insurance Adjusting Entry
  • Excel 10.40 Prepaid Insurance Adjusting Journal Entry
  • QuickBooks 10.45 Depreciation Adjusting Journal Entry
  • Excel 10.45 Depreciation Adjusting Entry
  • QuickBooks 10.50 Unearned Revenue Adjusting Entry
  • Excel 10.50 Unearned Revenue Adjusting Entry
  • QuickBooks 10.30 Reversing Entry Accrued Interest
  • Excel 10.300 Accrued Interest Reversing Entry
  • QuickBooks 10.35 Reversing Entry Accounts Receivable
  • Excel 10.350 Accounts Receivable Reversing Entry
  • QuickBooks 10.55 Reverse Unearned Revenue Adjusting Entry
  • Excel 10.550 Unearned Revenue Reversing Entry
  • QuickBooks 10.60 Journal Report & Financial Statements
  • Excel 10.60 Financial Statements
  • Excel 10.60 Financial Statements

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


Screenshots

QuickBooks Desktop vs. Excel
QuickBooks Desktop vs. Excel
QuickBooks Desktop vs. Excel
QuickBooks Desktop vs. Excel

Content

Introduction

Introduction - Course Overview

Start a New Company File

Start a New Company File Section Overview

PDF 6.05

QuickBooks 6.05 Set Up New Company & Preferences

Excel Files 6.05

Excel 6.05 Set up New Company Worksheet

PDF 6.10

QuickBooks Backup File

QuickBooks 6.10 Setting Up Items

Excel Files 6.10

Excel 6.10 Set Up Inventory Items

PDF 6.15

QuickBooks 6.15 Customer Setup

Excel Files 6.15

Excel 6.15 Set Up Customer Balances

PDF 6.20

QuickBooks 6.20 Set up Vendors and Beginning Balances

Excel Files 6.20

Excel 6.20 Set Up Vendors Beginning Balances

PDF 6.25

QuickBooks Backup File

QuickBooks 6.25 Set up new account & Enter Opening Balances

Excel Files 6.25

Excel 6.25 Enter Opening Account Balances

PDF 6.30

QuickBooks 6.30 Adjust New Account Balances

PDF 6.35

QuickBooks 6.35 Payroll Set Up

PDF 6.40

QuickBooks 6.40 New Employee Setup

QuickBooks 6.45 Export Transaction List By Date

Accounting Comic Break

Accounting Concepts

Accounting Concepts Section Overview

Cash Method Vs Accrual Method

Revenue Recognition Principle

Financial Transaction Rules

Enter Data for the First Month of Operations

Enter Data for the First Month of Operations Section Overview

PDF 7.05

QuickBooks Backup File

QuickBooks 7.05 Record Deposit from Owner & Loan

Excel 7.05 Owner Deposit & Loan Deposit

PDF 7.10

QuickBooks 7.10 Record Transactions In Register Investment & Furniture

Excel 7.10 Purchase Furniture & Record Investment

PDF 7.17

QuickBooks 7.17 Purchase Order

PDF 7.20

QuickBooks 7.20 Create an Invoice

Excel Files 7.20

Excel 7.20 Part 1 Invoice Transaction

Excel 7.20 Part Two Create on Invoice Transaction

PDF 7.25

QuickBooks 7.25 Record Receipt of Payment

Excel Files 7.25

Excel 7.25 Receive Payment Part 1

Excel 7.25 Receive Payment Part 2

Excel 7.25 Receive Payment Part 3

PDF 7.30

QuickBooks Backup File

QuickBooks 7.30 Sales Receipts Cash Sales Transaction

Excel Files 7.30

Excel 7.30 Cash Sales Transaction Part 1

Excel 7.30 Part 2 Cash Sales Service

PDF 7.35

QuickBooks 7.35 Deposit

Excel Files 7.35

Excel 7.35 Deposit Part 1

Excel 7.35 Deposit Part 2

PDF 7.40

QuickBooks 7.40 Write Check for Inventory from Purchase Order

Excel Files 7.40

Excel 7.40 Part 1 Inventory Payment

Excel 7.40 Part 2 Inventory Payment

PDF 7.45

QuickBooks 7.45 Invoice for Pre-Order Inventory P.O.

Excel Files 7.45

Excel 7.45 Invoice for Preordered Item Part 1

Excel 7.45 Invoice for Preordered Item Part 2

PDF 7.50

QuickBooks 7.50 Receive Payment & Make Deposit

Excel Files 7.50

Excel 7.50 Receive Payment & Make Deposit

PDF 7.55

QuickBooks 7.55 Write Check for Expenses

Excel Files 7.55

Excel 7.55 Part 1 Write Check

Excel 7.55 Part 2 Write Check Part 2

PDF 7.60

QuickBooks 7.60 Pay Bills

Excel Files 7.60

Excel 7.60 Pay Bills

PDF 7.65

QuickBooks 7.65 Set Up Customer Jobs

Excel Files 7.65

Excel 7.65 Customer Jobs

PDF 7.70

QuickBooks 7.70 Payroll Process Check

Excel Files 7.70

Excel 7.70 Payroll

PDF 7.75

QuickBooks Backup File

QuickBooks 7.75 Job Sales Receipt

Excel Files 7.75

Excel 7.75 Job Sales Receipt

PDF 7.80

QuickBooks 7.80 Review Reports & Export to Excel

Excel Files 7.80

Excel 7.80 Financial Statements & Reports

Excel Files 7.90

Excel 7.90 Closing Process January

Excel Files 7.92

Excel 7.92 Worksheet Month Two

Enter Data for the Second Month of Operation

Enter Data for the Second Month of Operation Section Overview

PDF 8.05

QuickBooks Backup File

QuickBooks 8.05 Loan Payments, Interest, Principle

Excel Files 8.05

Excel 8.05 Make Loan Payments

PDF 8.10

QuickBooks 8.10 Deposit Investment & Interest

Excel Files 8.10

Excel 8.10 Short Term Investment

PDF 8.15

QuickBooks 8.15 Purchase Order New Item & Customer

PDF 8.20

QuickBooks 8.20 Receive Inventory with Bill

Excel Files 8.20

Excel 8.20 Receive Inventory With Bill Part 2

PDF 8.25

QuickBooks 8.25 Sales Receipt & Deposit

Excel Files 8.25

Excel 8.25 Sales Receipt & Deposit

Excel 8.25 Part 2 Sales Receipt & Deposit

PDF 8.30

QuickBooks 8.30 Advanced Payment From Customer

Excel Files 8.30

Excel 8.30 Advanced Payment From Customer

PDF 8.35

QuickBooks 8.35 Apply Credit to Invoice

Excel Files 8.35

Excel 8.35 Apply Credit to Invoice

PDF 8.40

QuickBooks 8.40 Record Sale on Account

Excel Files 8.40

Excel 8.40 Record Sales on Account

PDF 8.45

QuickBooks 8.45 Advance Customer Payment

Excel Files 8.45

Excel 8.45 Advance Customer Payment

PDF 8.50

QuickBooks 8.50 Bills Track & Pay

Excel Files 8.50

Excel 8.50 Bills Track & Pay

PDF 8.55

QuickBooks Backup File

QuickBooks 8.55 Customer Payment on Account & Deposit

Excel Files 8.55

Excel 8.55 Customer Payment on Account

PDF 8.60

QuickBooks 8.60 Pay Sales Tax

Excel Files 8.60

Excel 8.60 Pay Sales Tax

PDF 8.65

QuickBooks 8.65 Pay Payroll Taxes

Excel Files 8.65

Excel 8.65 Pay Payroll Tax

PDF 8.70

QuickBooks 8.70 Enter Bills & Pay Bills

Excel Files 8.70

Excel 8.70 Enter Bills & Pay Bills

PDF 8.75

QuickBooks 8.75 Enter Service Item & Invoices

Excel Files 8.75

Excel 8.75 Service Item & Invoices

PDF 8.77

QuickBooks 8.77 Purchase Equipment with Debt

Excel Files 8.77

Excel 8.77 Purchase Equipment with Debt

PDF 8.80

QuickBooks 8.80 Enter Payroll

Excel Files 8.80

Excel 8.80 Payroll

PDF 8.90

QuickBooks 8.90 Rental Income, New Account, New Item

Excel Files 8.90

Excel 8.90 Rental Income

PDF 8.95

QuickBooks 8.95 Comparative Balance Sheet & Income Statement

Excel Files 8.95

Excel 8.95 Financial Statements

Bank Reconciliations

Bank Reconciliations Section Overview

PDF 9.10

QuickBooks 9.10 Bank Reconciliation First Bank Reconciliation

Excel Files 9.10

Excel 9.10 Bank Reconciliation January

Excel 9.12 Bank Reconciliation Adjusting Entries January

PDF 9.15

QuickBooks 9.15 Bank Reconciliation Second Bank Reconciliation

Excel Files 9.15

Excel 9.15 Bank Reconciliation February

Excel 9.20 Bank Reconciliation Feb. Adjusting Entries

Adjusting Entries, Financial Statements, Closing Entries, and Reversing Entries

Adjusting Entries, Financial Statements, Closing Entries, and Reversing Entries

PDF 10.10

QuickBooks 10.10 Short term loan Adjusting Entry

Excel Files 10.10

Excel 10.10 Loan Payable Adjusting Entry Part 1

PDF 10.15

QuickBooks 10.15 Short term portion of loan Adjusting Entry

Excel Files 10.15

Excel 10.15 Loan Payable Adjusting Entry Part 2

PDF 10.20

QuickBooks 10.20 Accrued Interest Adjusting entry

Excel Files 10.20

Excel 10.20 Accrued Interest Adjusting Entry

PDF 10.25

QuickBooks 10.25 Invoice Adjusting Entry

Excel Files 10.25

Excel 10.25 Invoice Adjusting Entry

PDF 10.40

QuickBooks 10.40 Prepaid Insurance Adjusting Entry

Excel Files 10.40

Excel 10.40 Prepaid Insurance Adjusting Journal Entry

PDF 10.45

QuickBooks 10.45 Depreciation Adjusting Journal Entry

Excel Files 10.45

Excel 10.45 Depreciation Adjusting Entry

PDF 10.50

QuickBooks 10.50 Unearned Revenue Adjusting Entry

Excel Files 10.50

Excel 10.50 Unearned Revenue Adjusting Entry

QuickBooks 10.30 Reversing Entry Accrued Interest

Excel Files 10.300

Excel 10.300 Accrued Interest Reversing Entry

PDF 10.35

QuickBooks 10.35 Reversing Entry Accounts Receivable

Excel Files 10.350

Excel 10.350 Accounts Receivable Reversing Entry

PDF 10.55

QuickBooks 10.55 Reverse Unearned Revenue Adjusting Entry

Excel Files 10.550

Excel 10.550 Unearned Revenue Reversing Entry

PDF 10.60

QuickBooks 10.60 Journal Report & Financial Statements

Excel Files 10.60

Excel 10.60 Financial Statements

Excel Files 10.65

Excel 10.65 Closing Process February



Reviews

K
Kumarajith26 February 2019

In fact the lecturer explained lesson flow step by step in a appropriate speed so that learner can grasp the subject materials.So then he goes to excel files,having summarized the QB lesson steps,same thing is recorded in the excel files.The student touches the learning materials three times in his explanation process and grasp things easily.In addition the lecturer explains how the student can work with excel sheets as well.He demonstrates very clearly how manually keeps records in excel sheets and prepares financial satements.This is not only learning QB lessons but also learning how to use excel sheets to record business transactions.Hence he teaches Qb and excel for recording business transactions and preparing financial statements.

B
Bobbie12 February 2018

The teacher was very thorough while providing a lot of helpful information on QuickBooks. Thank you.

D
Dianna1 February 2018

The Excel worksheet help a lot in understanding how transactions are connected to the financial statements.



Coupons

StatusDateDiscount
Expired9/20/2020100% OFF

1481350

Udemy ID

12/25/2017

Course created date

8/5/2019

Course Indexed date
Bot
Course Submitted by