K2's Expense Reporting Automation

K2's Expense Reporting Automation

K2’s Expense Reporting Automation

Computer Software and Applications
2 CPE Credits
Course - K2's Expense Reporting Automation
25c-expauto
In-Person, Webinar
Live
Intermediate
100 Minutes
Topics Learning Objectives Description Compliance

Major Topics

  • Extracting and importing transaction data from bank feeds and matching to receipts
  • Overview of selected expense and corporate credit card reporting and management platforms
  • Major fraud schemes associated with expense reporting

Learning Objectives

  1. Select at least two types of employee expenses that are identified as very risky by the course
  2. Identify at least two common expense reimbursement fraud schemes.
  3. Choose responses that explain how bank feeds are different from data extraction/OCR applications
  4. Identify at least two comprehensive expense reporting solutions discussed in detail during the course which offer both OCR data extraction and mobile receipt capture
  5. Explain how artificial intelligence can be used to identify unusual items in expense reports

Description

Managing and auditing employee spending on personal and corporate credit cards is a challenge everywhere. Legacy manual expense reporting preparation and approval processes are tedious and repetitive and are an excellent place to start your company’s use of business process automation solutions. This session will cover a variety of expense workflow tools which use technologies and features like bank feeds, mobile receipt capture, OCR data extraction/filling, automated policy enforcement, and artificial intelligence-based validation to automate and eliminate the tedium. Attend this session and learn how to use automation and cure the expense reporting blues for you and your employees.

Compliance Information

Business professionals seeking to improve expense reporting process None Computer Software and Applications 2 Credits January 1, 2025
Topics

Overview

Managing and auditing employee spending on personal and corporate credit cards is a challenge everywhere. Legacy manual expense reporting preparation and approval processes are tedious and repetitive and are an excellent place to start your company’s use of business process automation solutions. This session will cover a variety of expense workflow tools which use technologies and features like bank feeds, mobile receipt capture, OCR data extraction/filling, automated policy enforcement, and artificial intelligence-based validation to automate and eliminate the tedium. Attend this session and learn how to use automation and cure the expense reporting blues for you and your employees.

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