QuickBooks Desktop

Comprehensive QuickBooks course that starts at the basics and moves forward in a well planned and understandable way

Buy $100.00

Course curriculum

1. 1005 QuickBooks Desktop vs QuickBooks Online
2. Documents to Download
3. 1009 QuickBooks Desktop
4. 1010 How To Download the Software
5. 1012 30 Day Free Trial or Purchase Process
6. 1015 Install QuickBooks Desktop
7. 1017 Increase Display Size
1. 1020 Download & Open Sample File
2. 1080 Home Page Overview
3. 1100 Bank Feeds
4. 1120 Preferences
1. 1140 Vendors Section
2. 1160 Vendor
3. 1180 Bill Form
4. 1200 Pay Bills Form Check
5. 1220 Purchase Order Form P.O
6. 1222 Bill With Inventory Connected to P.O.
7. 1227 Inventory Adjustment
8. 1240 Manage Sales Tax
9. 1260 Check Form
10. 1280 Void Check Prior Period
1. 1300 Customer Section Customer Cycle98df20c.autosave
2. 1320 Customer Center
3. 1340 Invoice Form
4. 1360 Receive Payment Form
5. 1380 Deposit Form
6. 1400 Sales Receipts Form
7. 1405 Barter Sale Transaction
8. 1420 Credit Memo Refund Form & Bad Debt Expense
9. 1423 Statement Charges
10. 1426 Finance Charges
1. 1440 Banking Section, Company Section Shortcuts
2. 1460 Customize Shortcuts & Home Page Icons
1. 1480 Employee Section Payroll Process
2. 1500 Employee Center
3. 1540 Pay Payroll Liabilities Form
4. 1545 Process Payroll Forms
5. 1548 Enter Time Form
1. 1560 Lists
2. 1600 Item Lists
1. 2020 Balance Sheet Report Overview
2. 2040 Report Formatting Basics
3. 2045 Report Filters
4. 2060 Report Header Footer Formatting
5. 2080 Report Fonts Numbers Formatting
6. 2100 Comparative Balance Sheet Creation
7. 2120 Balance Sheet Vertical Analysis
8. 2140 Memorize Report Group Setup
9. 2160 Memorize Reports
10. 2180 Reports - Print, Save as PDF Organize
11. 2181 Export Balance Sheet to Excel
1. 3020 Profit and Loss, PandL, Income Statement Overview
2. 3040 Comparative Profit & Loss, P&L, Income Statement
3. 3060 Vertical Analysis Profit Loss, P&L, Income Statement
4. 3080 Memorize Profit & Loss, P&L, Income Statement Reports
5. 3100 Print, Save as PDF Organize Profit Loss or Income Statement Reports
6. 3105 Export to Excel Profit and Loss or Income Statement Reports
1. 4020 Statement of Cash Flows
2. 4040 Accounts Receivable Aging Reports
3. 4060 Accounts Payable Aging Reports
4. 4065 1099 Reports
5. 4080 Sales by Customer and Sales by Item
6. 4140 Inventory Reports
7. 4160 Payroll & Employee Reports
8. 4180 Banking Reports
9. 4200 Transaction List by Date Report
10. 4220 Journal Report
11. 4225 Trial Balance
12. 4240 Budget Reports
13. 4260 Accounts Receivable Graphs
14. 4280 Accounts Receivable Graphs Excel
15. 4300 Accounts Payable Graphs
16. 4305 Accounts Payable Graphs in Excel
17. 4320 Sales by Customer, Account, & Item Graphs
18. 4360 Income & Expense Graph
19. 4380 Internal or External Report
1. 6010 Restore & Backup Data Files
2. Backup Files
3. Documents to Download
4. 6040 Create a New Company File135ba48.autosave
1. 6080 Company Preferences Accounting
2. 6100 Benefits HR, Company Preferences Bills, Calendar, & Checking
3. 6140 Company Preferences Integrated Application & Items & Inventory
4. 6160 Jobs and Estimates, Multiple Currencies, Payments, and Payroll
5. 6180 Company Preferences Reminders & Reports & Graphs
6. 6200 Company Preferences Sales & Customers & Sales Tax
7. 6220 Company Preferences Search, Send Forms, Service Connection
1. 6240 Options for Interring Items, Customers & Vendors
2. 6260 Enter Service Items
3. 6280 Inventory Tracking Options
4. 6300 Set Up Inventory Items
1. 6320 Sales Tax Set Up
2. 6340 New Customers Setup AND Accounts Receivable Beginning Balances165745c.autosav
3. 6360 New Vendors Setup & Accounts Payable Beginning Balances
1. 6380 Add New Accounts AND Opening Balances
2. 6400 Adjust Opening Balances
3. 6420 Manual Payroll Set up
1. 6440 Generate Reports After Entering Beginning Balances
1. 7020 Deposits - Owner Investment & Loan
2. 7040 Record Investment
3. 7043 Purchase of Fixes Assets
1. 7060 Enter Purchase Order P.O.
2. 7080 Cash Payment for Inventory Linked to Purchase Order P.O.
1. 7100 Invoice Selling Inventory
2. 7140 Sales Receipt Payment Received at Point of Sale
3. 7160 Deposits From Undeposited Funds
1. 7180 Invoice Created From Check Created From Purchase Order
2. 7200 Receive Payment and Make Deposit
3. 7220 Write Checks for Expenses & Prepaid Assets
4. 7240 Bill Pay1968546.autosave
1. 7260 Customer Jobs
2. 7280 Pay Employees
3. 7282 Change Payroll Item for Payroll Taxes
4. 7300 Enter Billable Time & Expense & Invoice
1. 7320 Month One Reports
1. 8020 Make Amortization Table2d01e19.autosave
2. 8022 Make Loan Paymentsd8329e.autosave
3. 8040 Short Term Investment Sales & Gains
4. 8060 Change Account Categorization to Other Expense
1. 8080 Purchase Order Adding New Items
2. 8120 Sales Receipt AND Deposit
3. 8122 Record Receipt of Inventory with Bill Linked to P.O.
1. 8130 Populate Invoice Using Billable Item That was Created From P.O.
2. 8140 Advanced Customer Payment or Unearned Revenue Method 1ff5ed1.autosave118eb0
3. 8160 Apply Customer Deposit (Credit) to Invoice
4. 8200 Advanced Customer Payment or Unearned Revenue Method 2
1. 8320 Bill for Hourly Services of Staff Set up Items & Enter Billable Time
2. 8322 Create Invoices Using Billable Timed68a1e.autosave559e75.autosave
1. 8340 Rental Income Set Up Items
2. 8342 Rental Estimate & Customer Deposit
3. 8344 Rental Income Invoice from Estimate
1. 8360 Purchase and Finance Equipment and Create Loan Sub Accounts1f01010.autosave
2. 8362 Subaccounts Categories For Fixed Assets
1. 8365 Bills - Enter, Sort, & Pay
2. 8370 Pay Sales Tax
1. 8380 Enter Payroll For Second Month
2. 8385 Pay Payroll Taxes
1. 8420 Create Reports After Second Month of Data Input
1. 9020 Bank Reconciliation Myth Busting
2. 9040 Bank Reconciliation Month One Overview
3. 9060 Bank Reconciliation Month #1 Deposits
4. 9080 Bank Reconciliation Month number1 Checks.autosavebdd5a8.autosave
5. 9100 Bank Reconciliation Opening Balance Problem
6. 9120 Bank Reconciliation Reports Month # 1
7. 9140 Bank Reconciliation Month #2 Deposits
8. 9160 Bank Reconciliation Month #2 Reports
9. 9165 Correction of Data Input Error
1. 10120 Adjusting Entries & Reversing Entries Introduction
2. 10180 Adjusting Entry Accrued Interest
3. 10220 Reversing Entry Accrued Interest
4. 10260 Adjusting Entry Accounts Receivable Sales
5. 10300 Reversing Entry Accounts Receivable Sales
6. 10340 Adjusting Entry Prepaid Insurance
7. 10380 Adjusting Entry Depreciation
8. 10400 Adjusting Entry Unearned Revenue Customer Deposit
9. 10460 Reversing Entry Unearned Revenue Customer Deposit
10. 10465 Adjusting Entry Loan Payable Short-Term and Long-Term Portions
11. 10467 Reversing Entry Loan Payable Short-Term and Long-Term Portions
12. 10480 Adjusting Entry & Reversing Entry Journal Reports
1. 11100 Budgeting Overview
2. 11120 Budgeted Income Statement Export to Excel & Modify Part 1
3. 11140 Budgeted Income Statement Data Input
4. 11160 Budgeted Income Statement Reports
5. 11180 Budgeted Balance Sheet Export to Excel
6. 11181 Budgeted Balance Sheet Export to Excel Part 2
7. 11200 Budgeted Balance Sheet Data Input
8. 11220 Budgeted Balance Sheet Reports
9. 11122 Budgeted Income Statement Export to Excel & Modify Part 2
1. 305 Setup New Bank Feed Test Company File
2. 315 How do Bank Feeds Fit Into My Accounting System
3. 320 Setting up Bank Feeds
4. 360 Download Bank Feed Transactions From Bank
5. 364 Import Bank Transactions Into QuickBooks
6. 365 Bank Feed Center Navigation
7. 370 Add Normal Expenses To Books From Bank Feed Limbo & Make Rules
8. 375 Enter Transaction Purchasing Equipment Using Bank Feeds
9. 380 Enter Transaction Purchas of Inventory Using Bank Feeds Overview
10. 381 Bank Feeds Purchase Inventory – Period & Perpetual Systems
11. 385 Enter Transaction Purchasing Investments Using Bank Feeds
12. 390 Enter Transaction For Owner Withdrawal or Personal Payment Using Bank Feeds
13. 395 Bank Feed Transaction for Income Deposit For Online Cash-Basis Business Overview
14. 396 Income From Bank Feeds & Income Categories
15. 400 Enter Transaction for Owner Deposit or Loan Deposit Using Bank Feeds
16. 405 Sales Tax & Bank Feeds
17. 440 Bank Feeds Matching Invoice to Deposit
18. 445 Bank Feeds Matching Receive Payment Form
19. 447 Bank Feeds Matching Deposit From Customer
20. 449 Bank Feeds Matching Sales Receipt
21. 460 Bank Feeds Credit Card Data Setup
22. 465 Credit Card Bank Feed Add Dataf7b0fe2.autosave
23. 467 Bank Feed to Bank Feed Transaction
24. 475 Credit Card Reconciliation Month One
25. 480 Credit Card Reconciliation Month Two
26. 505 PayPal Bank Feeds
27. 515 Bank Feeds Import PayPal Data
28. 520 Bank Feeds PayPal Data Input and Transfers
29. 660 Bank Rules – Same Customer Different Income Accountsaba26a.autosave
30. 665 Bank Rules Same Vendor Filter by Amount
31. 680 Bank Feeds Add Remaining Transactions and Bank Rules1ac950a.autosave
32. 685 Bank Reconciliation Bank Feeds First Month12ff347.autosave
33. 695 Financial Reports Generated From Bank Feeds

About this course

$100.00
201 lessons
56 hours of video content

Description

Our course starts at the basics, such as how to access the QuickBooks software, possibly for free, and then moves through an in-depth analysis of the software.

The course is designed so learners can go from start to finish but also have the option of jumping to the most relevant parts of the course, using the course as a reference guide to fall back on as needed.

This course will include backup files, a great tool to jump ahead or rework a portion of a problem. The backup files allow learners to have the exact same data as the example problem, so they can follow the presentation and perform the task in an easy, step-by-step process.

The first part of the course will demonstrate how to access the QuickBooks software, possibly for free, download it, and install it.

We will then use the sample file provided by QuickBooks to learn how to navigate the accounting software, locate the most commonly used areas, and understand the relationship between data input and the final product of financial statements and related reports.

The sample file is an excellent tool for learning how to navigate the software because it already has data in it, allowing us to deconstruct the process of data input by going to the end result of financial statements and drilling back to the source documents used to enter the data.

We will analyze transactions by accounting cycle: vendor cycle, customer cycle, and employee cycle. The vendor cycle may also be called the payment cycle, purchases cycle, account payable cycle, or expenses cycle. The customer cycle may also be called the revenue cycle, sales cycle, or accounts receivable cycle.

The course will break down the flow of data input forms in each cycle and the impact of each form on the financial statements and related reports.

In the next major section of the course, we will start a new company file, an essential process for learning how to set up the foundational accounting system components like the chart of accounts, service items, revenue items, and beginning balances.

Learners will enter two months of data input along with instructional videos, entering a wide variety of common transactions and analyzing the impact of each on the financial statements and related reports.

After entering two months of data input, learners will prepare bank reconciliations using demonstration bank statements, learning how to perform a bank reconciliation, why we reconcile, and what outstanding items are.

The course also has an extensive section on how to use bank feeds. Learners will learn how to connect to the bank, download bank feeds into QuickBooks, and add the necessary data to include the bank data into the accounting system to create financial transactions or verify transactions that have already been created. We will also cover how to use bank rules to make data input much faster and more efficient. The course will demonstrate data input using bank feeds for checking, credit card, and PayPal accounts.

Next, we will enter adjusting entries; entries used to adjust financial statement reports more closely to their accounting basis as of the end of the month or year. Common accounting basis includes accrual basis, cash basis, or tax basis.

Learners will also understand how budgets fit into the accounting process, what some best practices are to construct a budget, how to enter a budget into QuickBooks, and how to run budget reports.

The course also has information on more specialized topics like using account numbers, customizing forms, using class tracking, memorizing transactions, fixed asset tracking, tax mapping, and multiple currencies.