Free Course Coupon Logo
QuickBooks Desktop vs. Excel
114$
0.00$
4 days ago

[100 % OFF] QuickBooks Desktop vs. Excel

Instructors:

Robert (Bob) Steele
Robert (Bob) Steele

Language:

English

Ratings:

4.5

What you'll learn:

Course content:

Getting Started - QuickBooks Desktop 202342min
Excel - Setup Worksheet2hr 55min
Open Practice File-Review Home Page & Accounting Cycles 202346min
Vendor Cycle, Purchases Cycle, or Accounts Payable Cycle 20232hr 45min
Excel-Vendor Cycle, Purchases Cycle, or Accounts Payable Cycle Transactions4hr 0min
Customer Cycle, Sales Cycle, or Accounts Receivable Cycle 20233hr 34min
Excel-Customer Cycle, Sales Cycle, or Accounts Receivable Cycle Transactions3hr 9min
Other Home Page Items, Shortcuts, & Customizing Shortcuts 202342min
Employee Cycle - Payroll Cycle 20231hr 41min
Excel-Employee Cycle-Payroll Cycle Transactions55min
List - Chat of Accounts & Items List 202356min
Help/Support, Reports Overview, & Backing Up Data File 202353min
Balance Sheet Reports 20232hr 55min
Income Statement - Profit & Loss Reports 20231hr 39min
Statement of Cash Flows & Supplemental Reports 20234hr 33min
Start a New Company File in QuickBooks Pro 202338min
Excel-Create Worksheet for New Company Accounting Transactions49min
Company Preferences2hr 34min
Adding Service Items & Inventory Items1hr 16min
Excel-Adding Inventory Items & Related Inventory Account Balances25min
Sales Tax Setup, Add Customers, & Add Vendors59min
Excel-Add Customers, Add Vendors, & AR & AP Beginning Balances40min
Opening Balances, Adjustments to Equity, & Manual Payroll Setup1hr 33min
Excel-Add Opening Account Balances31min
Month 1-Record Owner Investment, Purchase of Fixed Asset & Investment 202351min
Excel-Month 1-Record Owner Investment, Purchase of Fixed Assets & Inventory28min
Month 1-Enter Purchase Order & Enter Check or Expense Form from PO 202339min
Excel-Month 1-Enter Transactions for Purchase of Inventory23min
Month 1 - Enter Invoice, Sales Receipt, & Deposits 20231hr 25min
Excel-Month 1-Enter Transactions for Sale of Inventory & Deposits1hr 28min
Month 1-Enter Invoice, Receive Payment, Bill 20221hr 15min
Excel-Month 1-Enter Transaction for Sale of Inventory, Receive Payments, & Bill1hr 19min
Month 1 - Create Customer Job, Pay Employees, & Create Sales Receipt for job1hr 16min
Excel-Month 1-Transactions for Payroll & Create Sales Receipt1hr 16min
Month One Reports28min
Excel-Month 1-Create Financial Statements22min
Month 2-Enter Loan Payments, Create Amortization Tables, & Investment 20221hr 5min
Excel-Month 2-Enter Loan Transaction, Create Amortization Table, & Investment58min
Month 2 – Enter Purchase Order, Sales Receipt, Bill for Inventory37min
Excel-Month 2-Enter Sale, Cash Received at Same Time & Bills for Inventory39min
Month 2 – Invoice from Billable Item, Advanced Customer Deposit 20221hr 0min
Excel-Month 2-Invoices for Service Sales & Advanced Customer Deposit1hr 18min
Month 2 – Invoicing for Hourly Service 202228min
Excel-Month 2-Transaction for Billable Time31min
Month 2 – Invoicing for Rental Income with Advanced Customer Deposit 202339min
Excel-Month 2-Rental Income Transaction & Advanced Customer Deposit35min
Month 2 – Purchase & Finance Equipment & Recategorize Fixed Assets 202238min
Excel-Month 2-Purchase & Finance Equipment28min
Month 2 – Enter & Pay Month End Bills & Pay Sales Tax 202239min
Excel-Month 2-Enter & Pay Month End Bills & Pay Sales Tax36min
Month 2 – Enter Payroll & Pay Payroll Tax for Prior Period 202239min
Excel- Enter-Month 2-Enter Payroll & Pay Payroll Tax for Prior Period52min
Month 2 – Generate Month End Report & Review Work25min
Excel-Month 2-Financial Statements42min
Bank Reconciliations 20232hr 26min
Excel-Bank Reconciliation1hr 52min
Adjusting & Reversing Entries 20233hr 50min
Excel-Adjusting Entries4hr 18min
Budgeting 20232hr 13min
Bank Feeds 202310hr 55min
Introduction Prior Years4min
Start a New Company File4hr 54min
Accounting Concepts34min
Enter Data for the First Month of Operations12hr 39min
Enter Data for the Second Month of Operation10hr 41min
Bank Reconciliations2hr 27min
Adjusting Entries, Financial Statements, Closing Entries, and Reversing Entries6hr 3min

Description

QuickBooks and Excel accounting cycle, reporting financial transaction to both QuickBooks and Excel compare and contrast

Reviews:

4.5