K2’s Implementing Internal Controls in QuickBooks Environments
Auditing
4 CPE Credits
Major Topics
- Critical risks in QuickBooks environments
- Internal control options that can mitigate risk to prudently acceptable levels
- Enabling alternative control measures to improve internal controls in QuickBooks environments
Learning Objectives
- Identify the importance of internal controls in QuickBooks environments
- List four common types of internal controls and provide examples of each
- Assess the relative strength or weakness of a QuickBooks-based organization’s internal control structure
- Create and implement appropriate internal controls using tools and features found in various editions of QuickBooks
Description
The QuickBooks ecosystem of accounting tools remains the most widely-used set of accounting applications small businesses use. Yet, many of these organizations struggle because of inadequate internal controls. In this seminar, you will learn options for improving internal controls in small businesses running QuickBooks Pro, Premier, Enterprise, or Online. Participate in this program to understand how you can create a robust system of internal controls in a small business environment, including businesses using QuickBooks accounting solutions.
In this session, you will also learn about the four common types of internal controls and how to assess the relative condition of the internal control structure of a small business. With this background in place, the focus then shifts to discovering the opportunities to enhance internal controls in QuickBooks-based environments using features found in the application. In addition, you will learn about additional internal control procedures for situations where you cannot establish adequate controls in QuickBooks. While many believe that QuickBooks-based organizations will forever face weak internal control structures, participating in this session will teach you how QuickBooks-based businesses can benefit from strong internal controls.
Compliance Information
Overview
The QuickBooks ecosystem of accounting tools remains the most widely-used set of accounting applications small businesses use. Yet, many of these organizations struggle because of inadequate internal controls. In this seminar, you will learn options for improving internal controls in small businesses running QuickBooks Pro, Premier, Enterprise, or Online. Participate in this program to understand how you can create a robust system of internal controls in a small business environment, including businesses using QuickBooks accounting solutions.
In this session, you will also learn about the four common types of internal controls and how to assess the relative condition of the internal control structure of a small business. With this background in place, the focus then shifts to discovering the opportunities to enhance internal controls in QuickBooks-based environments using features found in the application. In addition, you will learn about additional internal control procedures for situations where you cannot establish adequate controls in QuickBooks. While many believe that QuickBooks-based organizations will forever face weak internal control structures, participating in this session will teach you how QuickBooks-based businesses can benefit from strong internal controls.
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
- Identify conditions in which the FORECAST.ETS function is preferable to the FORECAST function
- List examples of best practices for constructing formulas in Excel spreadsheets
- Identify situations in which each of the following functions might be useful: SUMIFS, SWITCH, and STOCKHISTORY
- Distinguish between the XLOOKUP function and legacy Excel functions such as VLOOKUP, HLOOKUP, INDEX, and MATCH
- Cite examples of when using Dynamic Arrays would be useful
- Differentiate between Excel’s AGGREGATE and SUBTOTAL functions
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 –