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 |