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