Comprehensive QuickBooks Class - February 1- May 10, 2021 Monday & Wednesdays
Meeting ID: 867 1107 2224
Recordings - External link opens in new tab or windowFEB 1 | External link opens in new tab or windowFEB 3 | External link opens in new tab or windowFEB 8 | External link opens in new tab or windowFEB 10 | External link opens in new tab or windowFEB 15 | External link opens in new tab or windowFEB 17 | External link opens in new tab or windowFEB 22 | External link opens in new tab or windowFEB 24 | External link opens in new tab or windowMar 1 | External link opens in new tab or windowMar 3 | External link opens in new tab or windowMar 8 | External link opens in new tab or windowMar 10
External link opens in new tab or windowMar 15 |External link opens in new tab or window Mar 17 | External link opens in new tab or windowMar 22 | Mar 24 | External link opens in new tab or windowApr 5 | Apr 7

Intro to QuickBooks Spring Class - (External link opens in new tab or windoworientation Feb 28) Mar 7 - Apr 5, 2021  Mondays 9:30-11:30
Meeting ID: 820 2077 5233
Homework - Homework for March 22nd is below:Lesson 3
CH01_A1_Explore QuickBooks Worksheet. To submit homework, send to: cookiesetton@gmail.com


External link opens in new tab or windowLink for QuickBooks Premier 2020 desktop

External link opens in new tab or windowForm for license

Please email me at cookiesetton@gmail.com if you didn't received your license and keycode for the software.


External link opens in new tab or windowebook       |   External link opens in new tab or windowelab   -   Course Code: 2HF5L600-27024
- Last updated July 9, 2020   ELAB - CONTENT


Lesson 3 for Spring 21 Intro Class
QB 5 TestBank.docx
Files for QB comprehensive
Files for Intro Mar'21 class
Reinforce Your Skills 3-1.pdf
QB20_C03_Test_Bank.docx
QB20_C04_Test_Bank.docx
Add Vendors 2/21/22
Chapter 1-5 test


Handy Date Shortcuts

Date shortcuts



 



What's on the QuickBooks Desktop Certification test 

QUICKBOOKS SETUP

A Student should know:

  • What information is required before they set up a QuickBooks file
  • How to start a new company data file in QuickBooks (Express Start and Advanced Setup - formerly called the Easy Step Interview)
  • How to keep the lists and preferences from an old file while removing old transactions
  • How to customize the Home page
  • How to set up lists (customers, vendors, items, etc.). This includes understanding which names and items should appear on which lists.

UTILITIES & GENERAL PRODUCT KNOWLEDGE

A Student should know:

  • How to navigate or move around QuickBooks (use Home page, menus, icon bar, etc.)
  • How to back up and restore a data file
  • How to determine the release number and how to update QuickBooks
  • How to use QuickBooks in single-user and multi-user mode
  • What editions of QuickBooks are available and how to find out which one they are using.
  • How to password-protect QuickBooks
  • How and why to use preferences

PAYROLL

A Student should know:

  • The differences between the payroll services available from QuickBooks
  • How to set up payroll (including employees, Federal and State taxes and basic payroll deductions) using the Payroll Setup Wizard.
    • How to set up an employee's earnings and sick or vacation time
    • How to track sick or vacation time (accruing hours and using "banked" hours)
  • How and why to setup payroll schedules
  • How to run payroll
  • How and why to pay payroll liabilities
  • How to prepare payroll forms (Form 941, W-2) in QuickBooks
  • Track time and use it for payroll or for invoicing customers

ITEMS

A Student should know:

  • How QuickBooks uses items to perform the necessary accounting behind the scenes
  • The different types of items and when to use each type
  • How to use items for different types of scenarios. These include companies that sell:
    • Products for a specified price
    • Deleting entries
    • Services for a specified price
    • Unique products or services that have different prices for each sale
    • One service or product

SALES

A Student should know:

  • Who should be listed in the Customer Center
  • How to navigate and use the Customer Center
  • How to complete the workflow (from the sale-making the deposit) for:
    • Invoicing (A/R)
    • Sales Receipts (no A/R)
  • How QuickBooks uses the Undeposited Funds, Accounts Receivable, and checking accounts in the invoicing cycle
  • How and why to record a customer credit
  • How and why to create statements
  • How to handle bounced (NSF) checks

PURCHASES

A Student should know:

  • Who should be listed in the Vendor Center
  • How to navigate and use the Vendor Center
  • The different workflows for making purchases:
    • Entering and paying bills (A/P)
    • Writing checks
    • Using a Credit Card
    • Using a Debit Card
  • How to record the transactions in the purchase workflows
  • How and why to record a vendor credit
  • How to complete the inventory workflow (Purchase Order to payment)
  • How to set up, collect and pay sales tax
  • Bank reconciliation

BASIC ACCOUNTING

A Student should know:

  • What the basic financial statements are and have a basic understanding of what they mean.
  • The difference between cash and accrual reports
  • How and why to set a closing date
  • How to enter a Journal Entry if asked to do so by an accountant (they do not need to fully understand what accounts to debit or credit)

REPORTS

A Student should know:

  • Why and how to use the Report Center
  • How to customize reports (collapsing subaccounts, etc.)
  • The basic question that each report answers (basic understanding of each report)
  • How and why to send reports to Excel (how to update/refresh Excel reports from QuickBooks)
  • How and why to process multiple reports
  • How and why to memorize reports

LIST MANAGEMENT

A Student should know:

  • How to manage lists (customers, vendors, items, etc.). List management includes:
    • Adding new entries
    • Deleting entries
    • Editing entries
    • Merging entries

CUSTOMIZATION/SAVING TIME & SHORTCUTS

A Student should know:

  • How and why to memorize transactions (Automate Transaction Entry)
  • How to set up multiple users and what level of access can be granted or denied
  • How and why to create custom fields (customers, vendors, and employees)
  • How to customize an invoice