About This Course

Many accounting students get the feeling they are learning accounting theory without practical application, while many accounting practitioners and business professionals have the opposite problem, learning accounting software without understanding the theory that would allow them to be more confident and proficient. 

Practical contentment combining accounting theory and accounting software, QuickBooks, in a way rarely found, but in a way highly useful. 

This course will link theory and content by providing practical examples in a step by step, and side by side, process. 

We will work through a comprehensive problem, a complete accounting cycle, including the entering of financial transactions, posting transactions to the general ledger, creating a trial balance, entering adjusting entries, creating financial statements, and processing the closing process. 

The course will break each step in the accounting cycle into small digestible pieces and demonstrate each step as it is done with journal entries, accounting theory, and with data input, accounting software. 

We will provide backup files and Excel worksheets for each step along the way, allowing learners to work through the content as we go and allowing learners to jump forward or rework any part of the course at any time.

Our Promise to You

By the end of this course, you will have learned about journal entries and QuickBooks data entry side by side and comparing accounting theory to accounting practice in a practical way.

30 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 and learn more about combining accounting theory, accounting software and QuickBooks in a highly useful way. 

Course Curriculum

Section 1 - Introduction
QuickBooks Desktop Vs. Excel Thinkific 00:00:00
Downloadable Materials 00:00:00
Section 2 - Start A New Company File
Start A New Business Section Of Accounting And Excel Course 00:00:00
QuickBooks – New Company File 00:00:00
QuickBooks – Company Preferences Accounting 00:00:00
QuickBooks – Company Preferences Checking 00:00:00
QuickBooks – Company Preferences General 00:00:00
QuickBooks – Company Preferences Items And Inventory 00:00:00
QuickBooks – Company Preferences Payroll Preferences 00:00:00
Excel – Set Up New Company Worksheet 00:00:00
QuickBooks – Set Up Service Items 00:00:00
Excel – Set Up Inventory Items 00:00:00
QuickBooks – Inventory Tracking Options 00:00:00
QuickBooks – Set Up Inventory Items 00:00:00
QuickBooks – Set Up Customers 00:00:00
Excel – Set Up Customer Balances 00:00:00
QuickBooks – Set Up Vendors 00:00:00
Excel – Set Up Vendors Beginning Balances 00:00:00
QuickBooks – Import Items Customers Vendors 00:00:00
QuickBooks – Add New Accounts And Opening Balances 00:00:00
Excel – Enter Opening Account Balances 00:00:00
QuickBooks – Adjust New Account Balances 00:00:00
QuickBooks – Set Up Manual Payroll 00:00:00
QuickBooks – Set Up New Employee 00:00:00
QuickBooks – Generate Transaction Detail Report To Review New Company Setup 00:00:00
Section 3 - Enter Data For The First Month Of Operations
Enter Data For First Month Section Of Accounting And Excel Course 00:00:00
QuickBooks – Record Owner And Loan Deposit 00:00:00
Excel – Owner Deposit And Loan Deposit 00:00:00
QuickBooks – Record Purchase Furniture And Investment 00:00:00
Purchase Furniture And Record Investment 00:00:00
QuickBooks – Purchase Order 00:00:00
QuickBooks – Create An Invoice 00:00:00
Excel – Part One Invoice Transaction 00:00:00
Excel – Part Two Create On Invoice Transaction 00:00:00
QuickBooks – Receive Payment 00:00:00
Excel – Receive Payment Part One 00:00:00
Excel – Receive Payment Part Two 00:00:00
Excel – Receive Payment Part Three 00:00:00
QuickBooks – Create Sales Receipts 00:00:00
Excel – Cash Sales Transaction Part One 00:00:00
Excel – Cash Sales Service Part Two 00:00:00
QuickBooks – Record Deposit 00:00:00
Excel – Deposit Part One 00:00:00
Excel – Deposit Part Two 00:00:00
QuickBooks – Make Payment For Inventory Linked To Purchase Order 00:00:00
Excel – Inventory Payment Part One 00:00:00
Excel – Inventory Payment Part Two 00:00:00
Excel – Invoice For Custom Order Linked To P.O. And Payment 00:00:00
Excel – Invoice For Preordered Item Part One 00:00:00
Excel – Invoice For Preordered Item Part Two 00:00:00
QuickBooks – Receive Payment And Make Deposit 00:00:00
Excel – Receive Payment And Make Deposit 00:00:00
QuickBooks – Write Checks For Expenses 00:00:00
Excel – Write Check Part One 00:00:00
Excel – Write Check Part Two 00:00:00
QuickBooks – Pay Bill 00:00:00
Excel – Pay Bills 00:00:00
QuickBooks – Customer Jobs Add 00:00:00
Excel – Customer Jobs 00:00:00
QuickBooks – Pay Employees 00:00:00
Excel – Payroll 00:00:00
QuickBooks – Job Sales Receipt 00:00:00
Excel – Job Sales Receipt 00:00:00
QuickBooks – Review Reports After Month Of Data 00:00:00
QuickBooks – Financial Statements And Reports 00:00:00
Excel – Closing Process January 00:00:00
Excel – Worksheet Month Two 00:00:00
Section 4 - Enter Data For The Second Month Of Operation
Enter Data For Second Month Section Of Accounting And Excel Course 00:00:00
QuickBooks – Enter Loan Payments From Amortization Table 00:00:00
Excel – Make Loan Payments 00:00:00
QuickBooks – Short Term Investment Matures 00:00:00
Excel – Short Term Investment 00:00:00
QuickBooks – Create Purchase Order With New Item 00:00:00
QuickBooks – Receive Inventory With Bill Part One 00:00:00
Excel – Receive Inventory With Bill Part Two 00:00:00
QuickBooks – Sales Receipt And Deposit 00:00:00
Excel – Sales Receipt And Deposit Part One 00:00:00
Excel – Sales Receipt And Deposit Part Two 00:00:00
QuickBooks – Advanced Payment From Customer 00:00:00
Excel – Advanced Payment From Customer 00:00:00
QuickBooks – Apply Credit To Invoice 00:00:00
Excel – Apply Credit To Invoice 00:00:00
QuickBooks – Record Sales On Account 00:00:00
Excel – Record Sales On Account 00:00:00
QuickBook – Advance Customer Deposit 00:00:00
Excel – Advance Customer Payment 00:00:00
QuickBooks – Bills Track And Pay 00:00:00
Excel – Bills Track And Pay 00:00:00
QuickBooks – Customer Payment On Account And Deposit 00:00:00
Excel – Customer Payment On Account 00:00:00
QuickBooks – Pay Sales Tax 00:00:00
Excel – Pay Sales Tax 00:00:00
QuickBooks – Pay Payroll Taxes 00:00:00
Excel – Pay Payroll Tax 00:00:00
QuickBooks – Enter Bills And Pay Bills 00:00:00
Excel – Enter Bills And Pay Bills 00:00:00
QuickBooks – Enter Service Item And Invoices 00:00:00
Excel – Service Item And Invoices 00:00:00
QuickBooks – Purchase Equipment With Debt Or Financing 00:00:00
Excel – Purchase Equipment With Debt 00:00:00
QuickBooks – Enter Payroll For Second Month 00:00:00
Excel – Payroll 00:00:00
QuickBooks – Record Rental Income 00:00:00
Excel – Rental Income 00:00:00
QuickBooks – Comparative Financial Statements 00:00:00
Excel – Financial Statements 00:00:00
Section 5 - Bank Reconciliations
Bank Reconciliations Section Of Accounting And Excel Course 00:00:00
QuickBooks – Bank Reconciliation First One 00:00:00
Excel – Bank Reconciliation January 00:00:00
Excel – Bank Reconciliation Adjusting Entries January 00:00:00
QuickBooks – Bank Reconciliation Second Month 00:00:00
Excel – Bank Reconciliation February 00:00:00
Excel – Bank Reconciliation Feb. Adjusting Entries 00:00:00
Section 6 - Adjusting Entries, Financial Statements, Closing Entries, And Reversing Entries
Adjusting Entries, Financial Statement Section Of Accounting And Excel Course 00:00:00
QuickBooks – Loan Payable Adjusting Entry Short Term Loan 00:00:00
Excel – Loan Payable Adjusting Entry Part One 00:00:00
QuickBooks – Short Term Portion Installment Loan Adjusting Entry 00:00:00
Excel – Loan Payable Adjusting Entry Part Two 00:00:00
QuickBooks – Accrued Interest Adjusting Entry 00:00:00
Excel – Accrued Interest Adjusting Entry 00:00:00
QuickBooks – Invoice Or Accounts Receivable Adjusting Entry 00:00:00
Excel – Invoice Adjusting Entry 00:00:00
QuickBooks – Prepaid Insurance Adjusting Entry 00:00:00
Excel – Prepaid Insurance Adjusting Journal Entry 00:00:00
QuickBooks – Depreciation Adjusting Entry 00:00:00
Excel – Depreciation Adjusting Entry 00:00:00
QuickBooks – Unearned Revenue Adjusting Entry 00:00:00
Excel – Unearned Revenue Adjusting Entry 00:00:00
QuickBooks – Reversing Entry Accounts Receivable Entry 00:00:00
Excel – Accrued Interest Reversing Entry 00:00:00
QuickBooks – Reversing Entry Accrued Interest 00:00:00
Excel – Accounts Receivable Reversing Entry 00:00:00
QuickBooks – Reverse Unearned Revenue Adjusting Entry 00:00:00
Excel – Unearned Revenue Reversing Entry 00:00:00
QuickBooks – Journal Report And Financial Statements 00:00:00
Excel – Financial Statements 00:00:00
Excel – Closing Process February 00:00:00
Template Design © VibeThemes. All rights reserved.

Setup Menus in Admin Panel