Course curriculum

  • 01

    Getting Started - Getting Setup with QuickBooks Pro 2020

    • 05 Recommendations For Success

    • 10 Sage 50 Cloud Free Test Drive

    • 15 QuickBooks Desktop Options

    • 20 Purchase & Download QuickBooks Pro 2020

    • 30 Install QuickBooks Pro 2020

  • 02

    Navigating Through QuickBooks - QuickBooks Pro 2020

    • QuickBooks Download Backup Files

    • Sage Download Backup Files

    • QuickBooks Answer Key and Documents

    • Sage Documents to Download

    • Sage 1.05 Navigation Overview

    • Quickbooks 1.10 Restore Backup File

    • Quickbooks 1.20 Home Page Customer Section

    • Quickbooks 1.15 Home Page Vendors Section

    • Sage 1.15 Customers Section Flow

    • Sage 1.16 Customer Section Invoice

    • Sage 1.17 Customers Section Receive Payment

    • Sage 1.19 Customers Section Sales Receipts

    • Sage 1.20 1 Vendors Section Overview

    • Sage 1.20 2 Vendors Section Bill Form

    • Sage 1.22 Vendor Section Pay Bill

    • Sage 1.23 Vendors Section Purchase Order

    • Sage 1.24 Vendors Section Check

    • Quickbooks 1.25 Home Page Banking Section

    • Quickbooks 1.28 Home Page Employee Section

    • Sage 1.28 Other Sections

    • Quickbooks 1.30 Reports Center

    • Sage 1.30 Reports Overview

    • Quickbooks 1.35 Forms

    • Quickbooks 1.37 Lists

    • Quickbooks 1.40 Help Options

    • Sage 1.40 Help Options

    • Quickbooks 1.45 Print & Export Reports

    • Sage 1.45 Print & Export Reports to Excel

    • Quickbooks 1.50 Create Backup File

    • Sage 1.50 Backup

  • 03

    Balance Sheet and Balance Sheet Options in QuickBooks Pro 2020

    • Quickbooks 2.10 Balance Sheet

    • Sage 2.10 Balance Sheet

    • Quickbooks 2.15 Balance Sheet Display Options

    • Quickbooks 2.20 Header Footer Report Options

    • Quickbooks 2.25 Fonts & Numbers Report Options

    • Quickbooks 2.35 Comparative Balance Sheet

    • Quickbooks 2.40 Summary Balance Sheet

    • Quickbooks 2.45 Create a Memorize Report Group

    • Quickbooks 2.50 Memorize Reports to a Custom Group

  • 04

    Profit & Loss / Income Statement QuickBooks Pro 2020

    • Quickbooks 3.10 Profit and Loss Report

    • Sage 3.10 Income Statement

    • Quickbooks 3.15 Custom Income Statement

    • Quickbooks 3.20 Comparative Profit & Loss

    • Quickbooks 3.25 Vertical Analysis Profit & Loss

  • 05

    Other Reports & Graphs in QuickBooks 2020

    • Quickbooks 4.10 Sales Graph

    • Quickbooks 4.15 Income & Expense Graph

    • Sage 4.10 Statement of Cash Flows

    • Quickbooks 4.20 Sales by Customer Report

    • Quickbooks 4.25 Sales by Item Report

    • Sage 4.20 Sales By Customer Report

    • Quickbooks 4.30 Accounts Receivable Aging Report

    • Sage 4.30 Aged Receivables Report

    • Quickbooks 4.35 Accounts Payable Aging Report

    • Sage 4.35 Aged Payables Reports

    • Quickbooks 4.40 Accounts Payable Graph

    • Quickbooks 4.50 Accounts Receivable Graph

    • Sage 4.40 Sales Graphs

  • 06

    2020 Course Project Start - Set Up New Company File, Preferences, & Users

    • Quickbooks 6.002 New Company Set Up in QuickBooks Pro 2020

    • Quickbooks 6.004 Company Preferences Accounting

    • Quickbooks 6.006 Company Preferences Checking

    • Quickbooks 6.008 Company Preferences Items & Inventory

    • Quickbooks 6.007 Company Preferences General

    • Quickbooks 6.008 Company Preferences Items & Inventory

    • Quickbooks 6.009 Company Preferences Payroll

    • Quickbooks 6.009 Import Items, Customers, & Vendors

    • Sage 6.01 Set up New Company

    • Sage 6.09 Objective

    • Quickbooks 6.10 Set up Service Items

    • Quickbooks 6.11 Inventory Tracking Options

    • Sage 6.10 1 Inventory & Service Items Part 1

    • Quickbooks 6.11 Inventory Tracking Options

    • Sage 6.11 2 Inventory & Service Items Part 2

    • Quickbooks 6.12 Set up Inventory Items

    • Quickbooks 6.15 Set Up Customers

    • Sage 6.15 Set Up Customers & Beginning Balances Part 1

    • Sage 6.16 Set Up Customers & Beginning Balances Part 2

    • Quickbooks 6.20 Set Up Vendors

    • Sage 6.20 Set Up Vendors & Beginning Balances

    • Quickbooks 6.25 Add New Accounts & Opening Balances

    • Quickbooks 6.30 Adjust New Account Balances

    • Sage 6.25 Add Bank Account

    • Sage 6.26 Add Credit Card

    • Sage 6.27 Add Notes Payable

    • Sage 6.28 Add Equipment Account

    • Quickbooks 6.40 Set Up New Employee

    • Sage 6.35 Payroll Options

    • Quickbooks 6.45 Generate Transaction Detail Report To Review New Company Setup

    • Sage 6.55 Generate Transaction Detail Report

  • 07

    Enter Data for the first month of operations - QuickBooks 2020

    • Quickbooks 7.05 Record Owner & Loan Deposit

    • Sage 7.05 Record Owner & Loan Deposit

    • Quickbooks 7.10 Record Purchase Purchase of Furniture & Investment

    • Sage 7.10 1 Record Purchase Furniture

    • Sage 7.10 2 Record Short-Term Investment

    • Sage 7.16 Sales Tax Set Up

    • Quickbooks 7.17 Purchase Order P.O.

    • Sage 7.17 1 Purchase Order Part 1

    • Sage 7.18 Purchase Order & Add Inventory Item

    • Quickbooks 7.20 Create an Invoice

    • Sage 7.20 1 Create an Invoice with Inventory Part 1

    • Sage 7.20 2 Create an Invoice with Inventory Part 2

    • Sage 7.25 1 Receive Payment Part 1

    • Quickbooks 7.25 Receive Payment

    • Sage 7.25 2 Receive Payment Part 2

    • Quickbooks 7.30 Create Sales Receipts

    • Sage 7.30 1 Sales Receipt Part 1

    • Quickbooks 7.35 Create Sales Receipts

    • Sage 7.30 2 Sales Receipt Service Item

    • Sage 7.35 Deposit Records Group Deposits

    • Quickbooks 7.40 Make Payment for Inventory linked To Purchase Order

    • Sage 7.40 2 P.O. Billed & Paid Part 2

    • Sage 7.40 1 P.O. Billed & Paid Part 1

    • Quickbooks 7.45 Invoice for Custom Order Linked To P.O. & Payment

    • Sage 7.45 Invoice After Purchase Order Part 1

    • Quickbooks 7.50 Receive Payment & Make Deposit

    • Sage 7.50 Receive Payment and Make Deposit

    • Quickbooks 7.55 Write Checks for Expenses & Prepaid Expenses

    • Sage 7.55 Enter Check & Expense Forms

    • Sage 7.60 Pay Bills

    • Quickbooks 7.60 Pay Bill

    • Quickbooks 7.65 Customer Jobs Add

    • Sage 7.65 Jobs Set Up

    • Quickbooks 7.70 Pay Employees

    • Sage 7.70 Pay Employees

    • Sage 7.71 Pay Employees Part 2

    • Quickbooks 7.75 Job Sales Receipt

    • Sage 7.75 Sales Receipt To a Job

    • Quickbooks 7.80 Review Reports After Month of Data

    • Sage 7.80 Generate Report Export to Excel

  • 08

    Enter Data for the second month of operation in QuickBooks 2020

    • Sage 8.02 Consolidate Loans

    • Quickbooks 8.05 Make Loan Payments

    • Sage 8.03 Loan Amortization Table

    • Quickbooks 8.10 Short Term Investment Matures

    • Sage 8.05 Make Loan Payments

    • Sage 8.10 Short Term Investment Sale

    • Quickbooks 8.15 Create Purchase Order With New Item

    • Sage 8.15 Purchase Order With New Inventory Item

    • Quickbooks 8.20 Receive Inventory With Bill

    • Sage 8.20 Receive Inventory Requested With P.O. Enter Bill

    • Quickbooks 8.25 Sales Receipt & Deposit

    • Sage 8.25 Garcia Guitar

    • Quickbooks 8.30 Advanced Payment From Customer

    • Sage 8.30 Advanced Payment From Customer

    • Quickbooks 8.35 Apply Credit To Invoice

    • Sage 8.35 Apply Credit Or Advanced Payment to Invoice

    • Quickbooks 8.40 Record Sales on Account - Invoice for Inventory Item

    • Sage 8.40 Record Sales on Account

    • Quickbooks 8.45 Advance Customer Deposit

    • Sage 8.45 Advance Customer Payment or Deposit

    • Quickbooks 8.50 Bills Track & Pay

    • Sage 8.50 Bills Track & Pay

    • Quickbooks 8.55 Customer Payment on Account & Deposit

    • Sage 8.55 Customer Payment & Deposit

    • Quickbooks 8.60 Pay Sales Tax

    • Quickbooks 8.65 Pay Payroll Taxes

    • Sage 8.60 Pay Sales Tax

    • Sage 8.65 Pay Payroll Taxes

    • Quickbooks 8.70 Enter Bills & Pay Bills

    • Quickbooks 8.75 Enter Service Item & Invoices

    • Sage 8.70 Enter Bills & Pay Bills

    • Quickbooks 8.77 Purchase Equipment with Debt or Financing

    • Sage 8.77 Purchase Equipment with Debt

    • Quickbooks 8.80 Enter Payroll For Second Month

    • Sage 8.75 Enter Service Items & Invoices

    • Quickbooks 8.90 Record Rental Income

    • Sage 8.80 Payroll

    • Sage 8.90 Rental Income New Service Item New Income Account

    • Quickbooks 8.95 Comparative Financial Statements

    • Sage 8.95 Month End Reports

  • 09

    Bank Reconciliations in QuickBooks 2020

    • Quickbooks 9.10 Bank Reconciliation First One

    • Quickbooks 9.15 Bank Reconciliation Second Month

    • Sage 9.02 Bank Reconciliation Objective

    • Sage 9.10 Bank Reconciliation First Month Part 1 Deposits

    • Sage 9.12 Bank Reconciliation First Month Part 3

    • Sage 9.14 Bank Reconciliation Second Month Part 1 Deposits

    • Sage 9.11 Bank Reconciliation First Month Part 2

    • Sage 9.15 Easy Window Repairs

  • 10

    Adjusting Entries and Reversing Entries in QuickBook 2020

    • Quickbooks 10.10 Loan Payable Adjusting Entry Short Term Loan

    • Sage 10.11 Short Term Portion Of Loan Adjusting Entry

    • Quickbooks 10.15 Short Term Portion Installment Loan Adjusting Entry

    • Sage 10.15 Accrued Interest

    • Sage 10.17 Reversing Entry Notes Payable

    • Quickbooks 10.20 Accrued Interest Adjusting Entry

    • Sage 10.25 Accrued Interest Reversing Entry

    • Quickbooks 10.25 Invoice or Accounts Receivable Adjusting Entry

    • Sage 10.26 Invoice & AR Adjusting Entry Part 2 Solution

    • Quickbooks 10.30 Reversing Entry Accounts Receivable

    • Quickbooks 10.35 Reversing Entry Accrued Interest

    • Quickbooks 10.40 Prepaid Insurance Adjusting Entry

    • Sage 10.35 Accounts Receivable Reversing Entry

    • Sage 10.40 Prepaid Insurance Adjusting Entry

    • Quickbooks 10.45 Depreciation Adjusting Entry

    • Sage 10.45 Depreciation Adjusting Entry

    • Quickbooks 10.50 Unearned Revenue Adjusting Entry

    • Quickbooks 10.55 Reverse Unearned Revenue Adj. Entry

    • Sage 10.45 Unearned Revenue Adjusting Entry

    • Quickbooks 10.60 Journal Report & Financial Statements

    • Sage 10.57 Journal Report & Financial Statements

Description

Compare two of the top accounting software packages systematically and thoroughly (QuickBooks Desktop and Sage 50cloud Accounting).

This course will compare the purchasing process.

We will take a look at installing the accounting software on our computer.

Learners will understand how to navigate through the software, breaking the navigation process into cycles, including the revenue cycle, the purchases cycle, and the employee cycle.

We will enter two months of data into each accounting software package, reflecting on the effect on the financial statements after each step.

The course will demonstrate the bank reconciliation process for both accounting software packages.

Learners will also understand the adjusting and reversing entry process and be able to enter journal entries into both accounting software packages.

Robert (Bob) Steele CPA CGMA CPI MStax

Instructor

Through working with students from many different schools, Mr. Steele has learned best practices for helping people understand accounting fast. Learning new skills and finding the best way to share knowledge with people who can benefit from it is a passion of his.

Mr. Steele has experience working as a practicing Certified Public Accountant (CPA), an accounting and business instructor, and curriculum developer. He has enjoyed putting together quality tools to improve learning and has been teaching, making instructional resources, and building curriculum since 2009. He has been a practicing CPA since 2005. Mr. Steele is a practicing CPA, has a Certified Post-Secondary Instructor (CPI) credential, a Master of Science in taxation from Golden Gate University, a Bachelor’s Degree in Business Economics with an emphasis in accounting from The University of California Santa Barbara, and a Global Management Accounting Designation (CGMA) from The American Institute of CPA (AICPA).

Mr. Steele has also authored five books that can be found on Amazon or in audiobook format on Audible. He has developed bestselling courses in accounting topics including financial accounting and QuickBooks accounting software.

In addition to working as an accountant, teaching, and developing courses Mr. Steele has helped create an accounting website at accountinginstruction, a YouTube channel called Accounting Instruction, Help, and How Too, and has developed supplemental resources including a Facebook Page, Twitter Page, and Podcasts that can be found on I-tunes, Stitcher, or Soundcloud. Mr. Steele’s teaching philosophy is to make content applicable, understandable, and accessible.

Adult learners are looking for application when they learn new skills. In other words, learners want to be able to apply skills in the real world to help their lives. Mr. Steele’s formal accounting education, practical work experience, and substantial teaching experience allow him to create a curriculum that combines traditional accounting education with practical knowledge and application. He accomplishes the goals of making accounting useful and applicable by combining theory with real-world software like Excel and QuickBooks.

Many courses teach QuickBooks data entry or Excel functions but are not providing the real value learners want. Real value is a result of learning technical skills like applications, in conjunction with specific goals, like accounting goals, including being able to interpret the performance of a business.

Mr. Steele makes knowledge understandable by breaking down complex concepts into smaller units with specific objectives and using step by step learning processes to understand each unit. Many accounting textbooks cram way too much information into a course, making it impossible to understand any unit fully. By breaking the content down into digestible chunks, we can move forward much faster.

Mr. Steele also makes use of color association in both presentations and Excel worksheets, a learning tool often overlooked in the accounting field, but one that can vastly improve the speed and comprehension of learning accounting concepts.

The material is also made understandable through the application of concepts learned. Courses will typically demonstrate the accounting concepts and then provide an Excel worksheet or practice problems to work through the concepts covered. The practice problems will be accompanied by an instructional video to work through the problem in step by step format. Excel worksheets will be preformatted, usually including an answer tab that shows the completed problem, and a practice tab where learners can complete the problem along with a step by step presentation video.

Mr. Steele makes learning accounting accessible by making use of technology and partnering with teaching platforms that have a vision of spreading knowledge.