We will enter a bank reconciliation for the first month of operations into both an Accounting Excel worksheet and to QuickBooks. We will first enter the bank reconciliation into Excel accounting problem. We will then record the bank reconciliation into QuickBooks. For more information about QuickBooks see our QuickBOoks 2018 course. More information about the online course at the link below. http://accountinginstruction.info/qui… For more information about a comprehensive Accounting and Excel course see our Accounting and Excel Course. More information about the online course at the link below. http://accountinginstruction.info/qui…
This page is for those taking the QuickBooks & Excel Bank Reconciliation course. Below are links to the Excel workbook files that complement the course.
The files are in a zipped folder. Please download and unzip for use. The names of each workbook will include a presentation number that will correspond with the related presentation in the course.
We will record financial transactions related to rental income in both QuickBooks and a comprehensive Excel accounting problem. We will first enter the financial transaction into Excel using debits and credits. We will then inter the accounting data into QuickBooks For more information about QuickBooks see our QuickBOoks 2018 course. MOre information about the online course at the link below. http://accountinginstruction.info/qui… For more information about a comprehensive Accounting and Excel course see our Accounting and Excel Course. More information about the online course at the link below. http://accountinginstruction.info/qui…
For more information about a comprehensive Accounting and Excel course see our Accounting and Excel Course. More information about the online course at the link below.
Would we like to run our business better using accounting software?
Would we to choose between an online accounting software and a desktop accounting software?
Would we like to advance our career by increasing our skills with business software?
This comprehensive QuickBook course can help to achieve these goals.
Why choose this course?
Althugh this course has much more then just instructional vidoe it does include about 50 hours of current video content.
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.
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 is something best learned by doing, by applying skills to the QuickBooks application.
In addition to presentation video we will include PDF files to allow the completion of part of the work offline with no internet access.
We also provide backup files so that we can jump to later points in the course or rework components of the course while having the data set exactly as it is shown in the presentation.
A partial list of topics covered is below. The number series may change, however.
Getting Started – Getting Setup
Desktop – Download and Install
Desktop – Download Backup File
QuickBooks Backup File
Desktop – Restore Backup Files
Online – Set Up
Navigating Through QuickBooks
Desktop – 1.10 Restore Backup File
Desktop – 1.15 Home Page – Vendors Section
Online – 1.15 Vendor Section
Desktop – 1.20 Home Page – Customer Section
Online – 1.20 Customers Section
Desktop – 1.25 Home Page – Banking Section
Desktop – 1.27 Home Page – Company Section
Online – 1.25 Other Section
Desktop – 1.28 Home Page – Employees Section
Online – 1.28 Employee Section
Desktop – 1.35 Forms
Online – 1.35 Forms
Desktop – 1.37 Lists
Online – 1.35 Lists
Desktop – 1.40 Help Options
Online – 1.40 Help Options
Desktop – 1.45 Print & Export Reports
Online – 1.45 Pint & Export Reports
Desktop – 1.50 Backup Data
Online – 1.50 Backup Files
Double entry accounting system
Accounting Objectives
Accounting Equation
Balance Sheet and Balance Sheet Options
Desktop- 2.10 Balance Sheet
Online – 2.10 Balance Sheet
Desktop – 2.15 Balance Sheet Display Options
Online – 2.15 Balance Sheet General Options
Desktop – 2.20 Remove Date Time From Reports
Desktop – 2.25 Balance Sheet Fonts & Numbers
Online – 2.20 Balance Sheet Remove Date Time
Desktop – 2.30 Balance Sheet Header & Footer
Online – 2.30 Balance Sheet Header & Footer
Desktop – 2.35 Comparative Balance Sheet
Online – 2.30 Comparative Balance Sheet
Desktop – 2.40 Summary Balance Sheet
Online – 2.40 Summary Balance Sheet
Desktop – 2.45 Memorize Report Group
Desktop – 2.50 Memorize Report
Online – 2.50 Memorize Report
Income Statement & Statement of Equity
Income Statement
Statement of Owner’s Equity
Balance Sheet & Income Statement Relationship
Profit & Loss / Income Statement
Desktop – 3.10 Profit and Loss
Online – 3.10 Profit & Loss
Desktop – 3.15 Income Statement Custom
Online – 3.15 Income Statement Custom
Desktop – 3.20 Comparative Profit & Loss
Online – 3.20 Comparative Profit & Loss
Desktop – 3.25 Vertical Analysis Profit & Loss
Online – 3.25 Vertical Analysis Profit & Loss
Desktop – 3.30 Percentage of Expense Profit & Loss
Online – 3.30 Percent of Expense Profit & Loss
Other Reports & Graphs
Desktop – 4.10 Sales Graph
Desktop – 4.15 Income & Expense Graph
Desktop – 4.20 Sales by Customer Report
Online – 4.20 Sales by Customer Report
Desktop – 4.25 Sales by Item Report
Online – 4.25 Sales by Item Summary Report
Desktop – 4.30 Accounts Receivable Aging Report
Online – 4.30 AR Aging Summary
Desktop – 4.35 Accounts Payable Aging Report
Online – 4.35 Accounts Payable Aging Report
Desktop – 4.40 Accounts Payable Graph
Desktop – 4.50 Accounts Receivable Graph
Desktop – 4.60 Export Balance Sheet to Excel
Start a New Company File
Start a New Business Section Overview
Desktop – 6.05 Set Up New Company & Preferences
Online – 6.05 Set Up New Company & Preferences
Desktop – 6.10 Setting Up Items
Online – 6.10 Part 1 Item – Service Set Up
Online – 6.10 Part 2 Items Inventory Set Up
Desktop – 6.15 Customer Setup
Online – 6.15 Customer Balance Setup
Desktop – 6.20 Set up Vendors and Beginning Balances
Online – 6.20 Vendor – New Vendor & Opening Balance
Desktop – 6.25 Set up new account & Enter Opening Balances
Online – 6.25 Set up New Accounts & Export Trial Balance to Excel
Desktop – 6.30 Adjust New Account Balances
Online – 6.50 Adjusted Beginning Account Balances
Desktop – 6.35 Payroll Set Up
Online – 6.35 Payroll Options
Desktop – 6.40 New Employee Setup
Online – 6.40 Set Up New Employees
Desktop – 6.45 Export Transaction List By Date
Online – 6.45 Transaction List by Date
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 Second Month of Operations Section Overview
Desktop – 7.05 Record Deposit from Owner & Loan
Online – 7.05 Record Owner & Loan Deposit
Desktop – 7.10 Record Transactions In Register Investment & Furniture
Online – 7.10 Part 1 Record Purchase Furniture
Online – 7.10 Part 2 Record Short-Term Investment
Online – 7.16 Sales Tax u
Desktop – 7.17 Purchase Order
Online – 7.17 Part 1 Purchase Order
Online – 7.17 Part 2 Purchase Order Add Inventory Item
Desktop – 7.20 Create an Invoice
Online – 7.20 Part 1 Create Invoice with Inventory
We will cover the financial transaction related to rental income. We will first take a quick look at QuickBooks and then enter the financial transaction into Excel using debits and credits. For more information about QuickBooks see our QuickBOoks 2018 course. MOre information about the online course at the link below. http://accountinginstruction.info/qui… For more information about a comprehensive Accounting and Excel course see our Accounting and Excel Course. More information about the online course at the link below. http://accountinginstruction.info/qui…
We will enter the financial transaction related to payroll. We will first enter the accounting transaction into Excel and then enter the financial data into QuickBooks. For more information about QuickBooks see our QuickBOoks 2018 course. MOre information about the online course at the link below. http://accountinginstruction.info/qui… For more information about a comprehensive Accounting and Excel course see our Accounting and Excel Course. More information about the online course at the link below. http://accountinginstruction.info/qui…
We will enter the accounting transaction related to payroll in both QuickBooks and a comprehensive Excel problem. We will first enter financial transaction into Excel using debits and credits. We will then enter the accounting transaction into QuickBooks. For more information about QuickBooks see our QuickBooks 2018 course. More informatin about the online course at the link below. http://accountinginstruction.info/qui… For more information about a comprehensive financial accounting course see our Accounting and Excel course. MOre information about the online course at the link below. http://accountinginstruction.info/fin…
We will enter financial transactions related to purchase of equipment with debt. We will first take a quick look at QUickBooks and then enter the accounting transaction into Excel. For more information about QuickBooks see our QuickBooks 2018 course. More information about the online course at the link below. http://accountinginstruction.info/qui…
We will record transactions related to entering bills and paying bills. We will first take a quick look at QuickBooks and then enter the financial transaction into a comprehensive Excel problems. For more information about QuickBooks see our QuickBooks 2018 course. More information about the online course at the link below. http://accountinginstruction.info/qui…
