Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Language
English
Taught by
Robert (Bob) Steele
Rating
Course Overview
Navigate & Compare QuickBooks Online and Excel: Learn the Ins & Outs of Accounting Cycles and Transactions
Welcome to our QuickBooks Online course, a comprehensive and in-depth journey into the mechanics of QuickBooks Online Accounting Software and Excel. This course is designed to grant you a unique 'under-the-hood' perspective of accounting software and processes, utilizing Excel's transparent data input as a comparative tool.
The first phase of our course delves deeply into QuickBooks Online, a leading accounting software solution. Here, we will guide you through the intricacies of the software, deciphering its interface and extensive functionality. This involves a thorough analysis of common data input forms within various accounting cycles - the sales cycle, the expense cycle, and the payroll cycle. By drawing comparisons with Excel, our aim is to give you an intuitive understanding of these cycles, their interrelationships within the accounting environment, and how they mirror manual data input in Excel's journal entry format.
As we venture into the second half of the course, our emphasis shifts to practical applications. This segment is structured around a comprehensive problem, wherein we simulate two months of data input in QuickBooks Online, mirroring each transaction in an Excel accounting worksheet. This experiential learning method offers a hands-on experience of the nuances of accounting processes. You will delve into transaction entries, adjustments, and closing entries in both QuickBooks Online and Excel, in addition to performing bank reconciliations - a critical task for any accountant.
By the end of this course, you'll be well-versed in the operational aspects of QuickBooks Online Accounting Software and understand how it compares against manual data input processes in Excel. More importantly, you will possess the skills to use both platforms effectively for diverse accounting tasks, positioning you strongly for handling real-world accounting scenarios.
This course goes beyond imparting knowledge; it is about gaining hands-on experience, understanding the rationale behind the processes, and empowering you to maximize the potential of these powerful accounting tools.
If you're ready to delve into the world of accounting software, unravel the complexities of transactions, and explore the intricacies of QuickBooks Online and Excel, this course is just a click away. Embark on your journey towards mastering the contemporary accounting landscape today!
Course Content
- 63 section(s)
- 440 lecture(s)
- Section 1 2023- Getting Started
- Section 2 Excel - Setup Worksheet
- Section 3 Vendor, Accounts Payable, Expenses, or Purchases Cycle 2023
- Section 4 Excel-Vendor Cycle, Purchases Cycle, or Accounts Payable Cycle Transactions
- Section 5 Customer Cycle , Sales Cycle, or Accounts Receivable Cycle 2023
- Section 6 Excel-Customer Cycle, Sales Cycle, or Accounts Receivable Cycle Transactions
- Section 7 Other Important Forms & Functions, Shortcuts, & Employee Cycle 2023
- Section 8 Excel-Employee Cycle - Payroll Cycle Transactions
- Section 9 Lists-Chart of Accounts & Products & Services Lists
- Section 10 Help/Support & Reports Overview
- Section 11 Balance Sheet Report
- Section 12 Profit & Loss / Income Statement
- Section 13 Statement of Cash Flows & Supplemental Reports
- Section 14 Start a New Company File in QuickBooks
- Section 15 Company Preferences
- Section 16 Excel-Create Worksheet for New Company Accounting Transactions
- Section 17 Adding Service Items & Inventory Items
- Section 18 Excel-Adding Inventory Items & Related Inventory Account Balances
- Section 19 Sales tax Setup, Add Customers & Add Vendors
- Section 20 Excel-Add Customers, Add Vendors, & Accounts Receivable & Accounts Payable Balan
- Section 21 Opening Balances, Adjustments to Equity, & Manual Payroll Setup
- Section 22 Excel-Add Opening Account Balances
- Section 23 Month 1- Record Owner Investment, Purchase of Fix Asset & Investment
- Section 24 Excel-Month 1-Record Owner Investment, Purchase of Fixed Assets & Inventory
- Section 25 Month 1- Enter Purchase Order & Enter Check or Expense Form from PO
- Section 26 Excel-Month 1-Enter Transactions for Purchase of Inventory
- Section 27 QBO- Month 1- Enter Invoice, Sales Receipt, & Deposits
- Section 28 Excel-Month 1-Enter Transactions for Sale of Inventory and Deposits
- Section 29 QBO- Month 1- Enter Invoice, Receive Payment Bill
- Section 30 Excel-Month 1-Enter Transaction for Sale of Inventory, Receive Payment, & Bill
- Section 31 QBO-Month 1- Create Customer Job, Pay Employees, & Create Sales Receipt for job
- Section 32 Excel-Month 1-Transactions for Payroll & Create Sales Receipt
- Section 33 QBO- Month One Reports
- Section 34 Excel-Month 1-Create Financial Statements
- Section 35 QBO- Month 2- Enter Loan Payments, Create Amortization Tables, & Investment 202
- Section 36 Excel-Month 2-Enter Loan Transaction, Create Amortization Table, & Investment
- Section 37 QBO-Month 2- Enter Purchase Order, Sales Receipt, Bill for Inventory
- Section 38 Excel-Month 2-Enter Sale, Cash Received at Same Time & Bill for Inventory
- Section 39 QBO- Month 2- Invoice from Billable Item, Advanced Customer Deposit
- Section 40 Excel-Month 2-Invoices for Service Sales & Advanced Customer Deposit
- Section 41 QBO- Month 2- Invoicing for Hourly Service
- Section 42 Excel-Months 2-Transaction for Billable Time
- Section 43 QBO- Month 2- Invoicing for Rental Income with Advanced Customer Deposit
- Section 44 Excel-Month 2-Rental Income Transaction & Advanced Customer Deposit
- Section 45 QBO- Month 2- Purchase & Finance Equipment & Recategorize Fixed Assets
- Section 46 Excel-Month 2-Purchase & Finance Equipment
- Section 47 QBO- Month 2- Enter & Pay Month End Bills & Pay Sales Tax
- Section 48 Excel-Month 2-Enter & Pay Month End Bills & Pay Sales Tax
- Section 49 QBO- Month 2- Enter Payroll & Pay Payroll Tax for Prior Period
- Section 50 Excel-Month 2-Enter Payroll & Pay Payroll Tax for Prior Period
- Section 51 QBO- Month 2- Generate Month End Report & Review Work
- Section 52 Excel-Month 2 Financial Statements
- Section 53 QBO- Bank Reconciliations
- Section 54 Excel-Bank Reconciliations
- Section 55 QBO- Adjusting & Reversing Entries
- Section 56 Excel-Adjusting Entries
- Section 57 Prior Year - Introduction
- Section 58 Prior Year - Start a New Company File
- Section 59 Accounting Concepts
- Section 60 Enter Data for the first month of operations
- Section 61 Enter Data for the second month of operation
- Section 62 Bank Reconciliations
- Section 63 Adjusting Entries, Financial Statements, Closing Entries, and Reversing Entries
What You’ll 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
Skills covered in this course
Reviews
-
MMD. RAYHAN HOSSAIN
Extensive & Detailed
-
SSalah Zeinalabedeen
sure it was great
-
CChristopher Ricardo Chinchilla Alvarado
In-depth journey through the QuickBooks Online system while at the same time the instructor takes the time to explain in detail why he does every step and what all the elements of the sofware do. If this wasn´t enough, the Excel lessons teach us the inner workings of an accountant sofware set up by ourselves, which in turn helps us to better understand the Quickbooks Online cycles and the Accountability´s day-to-day dynamics. This without mentioning that with his knowledge and experience he´s able to lecture us on Accounting from the ground up, thus making the course accessible to a large range of users.
-
FFizzah Qureshia
Good, what I expected.
