K2’s Accountant’s Guide To QuickBooks Online

Course - K2's Accountant's Artificial Intelligence Conference

Major Topics

  • Understanding your QBO subscription and licensing options
  • Recording routine and non-routine transactions in QBO
  • Importing and exporting data to/from QBO
  • Creating effective reports
  • Describing the process for integrating third-party applications with QBO
  • Troubleshooting issues with QBO reports and data

Learning Objectives

  1. Identify and access the appropriate QBO subscription for an organization
  2. List the steps necessary to set up a QBO company
  3. Differentiate between the reporting options in QBO
  4. List the fundamental processes for recording transactions in QBO
  5. Identify examples of automation opportunities in QBO
  6. List examples of vital internal controls to enable in QBO

Description

QuickBooks Online’s (QBO) market share continues to expand, and the Cloud-based accounting platform now dominates the small business market. Yet, most accounting and financial professionals have not participated in any formal training on the Cloud-based accounting service. Thus, they are unaware of many of the tool’s available features and do not work with QuickBooks Online as efficiently and effectively as they should.

This course teaches you how to set up QBO and convert QuickBooks Desktop files into a QBO instance. You will learn how to process all types of transactions, including accounts payable, accounts receivable, bank feeds, inventory, and payroll. Further, you will learn how to implement appropriate internal controls and how to capitalize on advanced features such as workflow management and management reports. Join us in this session to learn how to set up QBO properly and take full advantage of all it offers while avoiding common errors and mistakes.

Compliance Information

Business professionals desiring a deeper understanding of how to work efficiently and effectively with QuickBooks Online None Accounting, Computer Software and Applications 8 Credits January 1, 2024

Overview

QuickBooks Online’s (QBO) market share continues to expand, and the Cloud-based accounting platform now dominates the small business market. Yet, most accounting and financial professionals have not participated in any formal training on the Cloud-based accounting service. Thus, they are unaware of many of the tool’s available features and do not work with QuickBooks Online as efficiently and effectively as they should.

This course teaches you how to set up QBO and convert QuickBooks Desktop files into a QBO instance. You will learn how to process all types of transactions, including accounts payable, accounts receivable, bank feeds, inventory, and payroll. Further, you will learn how to implement appropriate internal controls and how to capitalize on advanced features such as workflow management and management reports. Join us in this session to learn how to set up QBO properly and take full advantage of all it offers while avoiding common errors and mistakes.

Course Details

  • Powerful new functions and features in Excel, such as XLOOKUP and Dynamic Arrays
  • How to use “legacy” features and functions such as AGGREGATE
  • Creating effective forecasts in Excel

  1. List examples of best practices for constructing formulas in Excel spreadsheets
  2. Identify situations in which each of the following functions might be useful: SUMIFS, SWITCH, and STOCKHISTORY
  3. Distinguish between the XLOOKUP function and legacy Excel functions such as VLOOKUP, HLOOKUP, INDEX, and MATCH
  4. Cite examples of when using Dynamic Arrays would be useful
  5. Differentiate between Excel’s AGGREGATE and SUBTOTAL functions
  6. Identify conditions in which the FORECAST.ETS function is preferable to the FORECAST function

Intended Audience — Business professionals who work with Excel and want to extend their knowledge of advanced features and functions to become more accurate, effective, and efficient with spreadsheets

Advanced Preparation — None

Field of Study — Computer Software and Applications

Credits — 4 Credits

IRS Program Number

Published Date – November 2, 2022

Revision Date – September 24, 2025

Course Authors

No items found

About Us

K2’s goal is to produce and deliver the highest quality technology seminars and conferences available to business professionals. We work cooperatively with professional organizations (such as state CPA societies and associations of Chartered Accountants) and vendors of technology products. K2 also provides consulting services and advice on technology.

We make every effort to maintain a high level of integrity, family values, and friendship among all involved.

Professional Certifications

cpe-sponsors-logo

Other K2 Affiliated Sites

Get In Touch With Us

Drop Us A Line

1905 W. Thomas Street, Ste D, #363 Hammond, LA 70401-2901

Give Us A Call

(985) 542-9390
Monday - Friday, 8AM - 5PM CT
Closed Most Holidays

Shoot Us An Email

info@k2e.com

© 2025 K2 Enterprises. All rights reserved.