K2's QuickBooks for Accountants

K2's QuickBooks for Accountants

K2’s QuickBooks for Accountants

Accounting, Computer Software and Applications
8 CPE Credits
Course - K2's QuickBooks for Accountants
23s-qbp
Webinar
Live
Intermediate
400 Minutes
Topics Learning Objectives Description Compliance

Major Topics

  • New features in QuickBooks Desktop and Online
  • Enhancing internal controls in QuickBooks-based environments
  • Improving financial and operational reporting when using QuickBooks and QuickBooks Online
  • Best practices for setting up companies

Learning Objectives

  1. List new features added to recent versions of QuickBooks Desktop and QuickBooks Online and apply these features; additionally, differentiate between the different products in the QuickBooks family
  2. Define appropriate procedures for setting up client data files in QuickBooks, including converting data from other accounting applications, creating data files, using templates, entering beginning balances, establishing user access and security rights and privileges, and establishing preferences
  3. Identify techniques for making reports and analyzing data in QuickBooks, including creating and customizing reports and exporting reports to Excel
  4. Identify situations where QuickBooks Online may be an appropriate solution for a business currently using or considering using QuickBooks
  5. Identify appropriate responses to common QuickBooks user issues, such as closing accounting periods, eliminating payables and receivables from cash-basis financial statements, purging old transactions from QuickBooks, voiding checks in prior periods, viewing underlying debit and credit entries, and recommended end-of-period procedures

Description

The QuickBooks platform is robust with features and capabilities that many users are unaware of or do not know how to utilize effectively. This course helps you get more out of QuickBooks Desktop and QuickBooks Online and resolve the issues even experienced QuickBooks users struggle with, such as locking down prior periods. This program starts fast with a chapter covering the top issues accountants face with QuickBooks. Then, the day continues with practical guidance and solutions designed to help accountants get the most out of QuickBooks for themselves or their clients. You will learn about issues like setting up a new company, configuring and customizing QuickBooks preferences, and enabling system security and password protection features. Also, you will learn how to lock down transactions in prior periods, use the audit trail, customize reports, export reports to Excel, and extend QuickBooks’ usefulness with tools such as the Fixed Asset Manager and Loan Manager.

Compliance Information

Accountants and other business and financial professionals who use or support clients who use QuickBooks or QuickBooks Online None Accounting, Computer Software and Applications 8 Credits November 2, 2022
Topics

Overview

The QuickBooks platform is robust with features and capabilities that many users are unaware of or do not know how to utilize effectively. This course helps you get more out of QuickBooks Desktop and QuickBooks Online and resolve the issues even experienced QuickBooks users struggle with, such as locking down prior periods. This program starts fast with a chapter covering the top issues accountants face with QuickBooks. Then, the day continues with practical guidance and solutions designed to help accountants get the most out of QuickBooks for themselves or their clients. You will learn about issues like setting up a new company, configuring and customizing QuickBooks preferences, and enabling system security and password protection features. Also, you will learn how to lock down transactions in prior periods, use the audit trail, customize reports, export reports to Excel, and extend QuickBooks’ usefulness with tools such as the Fixed Asset Manager and Loan Manager.

Course Details

  • Fundamental Excel techniques all accounting and financial professionals should know and use
  • Creating date-based calculations in Excel
  • How to create Excel templates
  • Key options you should enable in Excel
  • Linking data in Excel

  1. Implement tools and techniques for formatting data in Excel, including multiline column headings, the Accounting Format, custom date and number formats, and Conditional Formatting
  2. Customize Excel’s user environment, including the Ribbon and the Quick Access Toolbar, adjust Excel’s Options to improve efficiency, and create and use Templates to increase efficiency and productivity
  3. Utilize various formula-building tools to create formulas more efficiently and create multiple types of formulas, including formulas to manipulate text and dates, formulas containing XLOOKUP functions, formulas that contain conditional calculations, and formulas that contain circular references
  4. Link data across multiple Excel worksheets and workbooks, update and manage links, and create sum-through formulas and rolling reports

Intended Audience — Accounting and financial professionals who want to learn how to use Excel more efficiently and effectively

Advanced Preparation — None

Field of Study — Accounting, Computer Software and Applications

Credits — 8 Credits

IRS Program Number –

Published Date – November 2, 2022

Revision Date –

Course Authors

No items found