QuickBooks Online Certified user

  • What information QuickBooks does and does NOT require when creating a new QuickBooks account
  • What lists can be imported and the basic steps to do so (including what is NOT imported)
  • How to modify/change basic elements after set up (e.g. accounts, company address, etc.)
  • How to setup users including a basic knowledge of the access rights available for different user types.
  • How to navigate or move around QuickBooks. A student should know:
    • What info and functionality is found in the 3 key access points – navigation bar,
    • global create, and company settings
    • What’s located on the home page and how to control what is or isn’t seen
    • What each button (e.g. save, more, etc.) does on major forms (e.g. invoice, bill, etc.)
  • The names of the major lists in QuickBooks and what type of information is tracked on each.
  • How to manage lists (Customers, Chart of Accounts, Products and Services, etc.). This includes:
    • Who should appear on which names list (e.g. employees or customers) and how to handle situations where the same person/ company should be on more than one list.
    • Adding new list entries
    • Removing list entries (including what QuickBooks does if an entry has a balance) Editing list entries
    • Merging list entries (including the basic rules of what can and can’t be merged)
  • Which names MUST appear on which forms (i.e. which names are required on specific transactions otherwise QuickBooks will NOT save the transaction)
  • Knowing the advantages of using built in sales forms (e.g. invoice) over other methods (e.g. Bank Deposit or Journal Entry)
  • Completing the Invoicing (A/R) and Sales
  • Receipt (no A/R) workflow from sale to bank deposit. A student should know the differences between these methods and when to use each.
  • How QuickBooks impacts and uses the Undeposited Funds, Accounts Receivable, and the bank accounts in the invoicing cycle.
  • How to invoice for billable expenses (includes how to turn this feature on and record expenses to begin the process)
  • How and why to record a customer credit
  • How to set up a Product or Service to be used on purchase Forms and when this is appropriate
    • How this set up allows QuickBooks to perform the appropriate accounting behind the scenes to correctly impact Financial Statements
  • How to set up Vendors
  • When to use the following transactions/workflows. This includes knowing the steps to record them in QuickBooks when the company does NOT have connected bank accounts (online banking). And how each affects the Vendor’s Balance
    • Purchase Orders
    • Entering and paying bills (A/P)
    • Recording Checks (hand written or printed)
    • Recording Credit and Debit Card transactions
    • Recording EFT’s, online payments, wire transfers, etc.
    • Vendor Credits
  • When and how to void vs. delete a check
  • How to use the Vendor page and reports to identify how much your company owes, and when payment is due.
  • What the basic financial statements are and have a basic understanding of their sections and 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 (students do not need to understand how to determine which accounts to debit or credit)
  • How to use the Audit Log to determine changes made by specific users.
  • How to set up QuickBooks to track income and expenses for multiple locations, or to separate transactions by class (e.g. department, profit center, etc.)
  • How to create custom fields on invoices.
  • How and why to make transactions recurring, including which transactions can be made recurring.
  • Which forms can be customized and the steps to customize a sales form
  • How to use a keyboard shortcut to find a list of keyboard shortcuts.
  • The time saving benefits of using QuickBooks online. These include:
    • Using QuickBooks on phones and tablets (IOS and Android). Students just need to be familiar with basic functionality and understand that QuickBooks mobile can use a mobile device’s camera, phone, and GPS to save time.
    • Connecting Apps to expand what QuickBooks does. Students should know where to find apps and know that apps expand what QuickBooks does and automatically synch data with QuickBooks.
    • Theabilitytohaveusers/employeeswith different operating systems (e.g. Mac vs. P.C.) and web browsers (e.g. Chrome vs. Safari) still access the same data.
    • Not needing to backup, and no IT issues (e.g. reinstalling software in cases of crashes or new computer purchases) usually associated with desktop software.