CPE Catalog+Events

This course will review common deficiencies identified by the AICPA and state boards of accountancy. It features discussion on a variety of topics, including analytical procedures, sampling, group audits and risk assessment. We will review the areas of concern and how you can overcome them by employing best practices. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Melisa F. Galasso, CPA

More Dates

Do you dread that annoying ERROR! message popping up on your spreadsheets? Tired of using the same long, elaborate formulas when you could be using the ones that are already built into Excel? Then this class is for you! In this webinar, we will focus on Debugging and Troubleshooting complex formulas. You will learn various techniques that will assist you in creating complex compound formulas. You will also learn techniques to resolve issues when you receive errors. This session will also discuss the 9 built-in error checking options and demonstrate resolution techniques. We will also review techniques to resolve rounding errors. This session is presented using Excel 2013. Regardless of the version you are using, ALL concepts covered in this course apply to ALL versions of Excel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Bryan L. Smith, CPA.CITP, CISA

More Dates

Planning may be one of the most important assignments of the finance professional; however, it is often accomplished in a way that can harm the organization. In many cases, huge sums are spent only to have a planning document developed that does not serve to bring the company together, but rather causes internal division. In some situations the budget can actually harm both productivity and alignment. This course is designed to bring planning, budgeting, and forecasting together into one fully aligned process that is easier, more efficient, and fully engages all parts of the organization. Rather than the plan being owned by the finance department, it is owned and followed by everyone from the CEO to the entry-level employee.

More Dates

Best Practices for Identifying and Evaluating Audit Risk - Linking Risk to the Detailed Audit Plan will emphasize the key concepts and best practices that drive a thoughtful risk-based approach to forming an opinion on the financial statements. Properly identifying, assessing, and responding to risk through a detailed audit plan is critical to an effective and efficient financial statement audit. Note: This course is recommended as a part of a 16-hour audit skills curriculum for experienced staff, while it is also appropriate for anyone who has the need to better understand how to link risk assessments to the detailed audit plan. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Jennifer F. Louis, CPA

More Dates

It is virtually impossible to pick up the daily newspaper and not find an article on some type of fraudulent event. In the wake of the “Era of Fraud, Waste and Excess,” one might suspect that potential fraudsters would think twice before committing illegal acts. However, just the opposite seems to be the case.  Is there really more fraud or is there simply more fraud awareness?  The harsh reality is that it is a little bit of each.  Not only has fraud worldwide reached a level of over $7.0 billion in lost  revenue but savvy C-level executives now realize that it could happen to their companies—very easily. When you put these facts together, it adds up to a completely new era of vigilance. Speaker - William O?Brien

More Dates

Auditing standards require auditors to assess risk-including controls-and use that assessment as a foundation for performing the audit. Risk assessment is not just a technical GAAS requirement, it has a direct impact on realization. Audit teams that perform a thorough risk assessment are more likely to have high realization engagements than those who go through the motions. This course is designed for small business audit teams. It addresses the risk assessment procedures and responsibilities for each team member and how they fit together to create more effective and efficient audits. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Michael Ramos

More Dates

Companies operating in today's business climate are weathering a storm of major FASB updates. Companies and their advisors may want to consider non-GAAP options as they develop strategies involving revenue recognition, leasing, credit losses, and other FASB pronouncements. This session will provide an overview of special purpose frameworks that may present salient alternatives to U.S. GAAP for certain entities. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Chris Harper, CPA

More Dates

Various legal tests are used to evaluate whether a worker should be classified as an employee or an independent contractor. There is no uniform standard or bright-line rule for determining whether an individual is properly classified as an independent contractor. Instead, the inquiry is always fact-intensive, and the analysis can vary based what body is performing it, i.e. the Internal Revenue Service (“IRS”), Department of Labor (“DOL”), various state agencies, or the courts. This presentation will review the various tests and highlight some of the common, most important factors for consideration.    Speaker - Alana Ackels

To move beyond the HR realm it is essential for HR professionals to understand planning at the strategic and tactical level. This session is designed to help HR professionals understand the overall strategic planning process so they can contribute at the executive level. Speaker - James Lindell

More Dates

With new accounting standards, the economic landscape and evolving technology, accounting, financial reporting and finance continue to grow in complexity. FASB has tried to address the growing complexity, by working towards making GAAP less convoluted.  The struggle to stay on top of accounting financial reporting requirements and finance changes due to the economy continues for several reasons. Lack of in-house SMEs, managing high volumes of transactions, and data and evolving information technology systems. In the future, executives must consider the challenges they will face in future years that will bring their own nuances and complexities. Budgeting is certainly one of those processes that must be evaluated and re-evaluated for efficiency. This session delves into the corporate budgeting process and discusses methods used and which methods may or may not allow for the organization’s to properly plan for a volatile future. Speaker - Lynn Fountain

More Dates

This is the beginning of a series that will cover major aspects of the Controllership function. Controllers are essential to the day-to-day accounting for organizations. Yet, the role is not often readily understood. In today’s world of acronyms such as CFO, CEO, COO, CAO, etc., the Controller function may get lost in the shuffle. However, they are a critical group of professionals who ensure the adequacy and transparency of accounting and financial reporting information. A Controller is an individual who has responsibility for all accounting-related activities including high-level accounting, managerial counting, and finance activities within a company. The duties of a Controller include assisting with the preparation of the operating budgets, overseeing financial reporting, and performing essential duties relating to payroll. However, in today’s evolving world, the Controller function can provide much more in-depth value to their organizations. This series is dedicated to exploring the traditional Controller role and stepping out of the box to identify areas where the Controller can add strategic value to their organizations. In this first course we focus on the typical Controller function and begin to identify ways to elevate the function.   Speaker - Lynn Fountain

More Dates

Forensic accounting, forensic accountancy or financial forensics is the specialty practice area of accounting that investigates whether firms engage in financial reporting misconduct. Forensic accountants apply a range of skills and methods to determine whether there has been financial reporting misconduct. Financial forensic engagements may fall into several categories.  Economic damages calculations, whether suffered through tort or breach of contract. Post-acquisition disputes such as earnouts or breaches of warranties Bankruptcy, insolvency and reorganization Securities and tax fraud Money laundering Business valuation Computer forensics/e-discovery This session is designed to delve a bit deeper into the world of forensic accounting and identify some of the specific areas of expertise required to become a forensic accountant. We will then first delve deeper into the art of document analysis and handwriting analysis.   Speaker - Lynn Fountain

More Dates

One of the most important aspect of transforming your practice or business to a digital model is to know how to prioritize the applications and initiatives that you focus on and invest in. There is an abundance of "low hanging fruit" initiatives that can provide useful benefits quickly and economically. Using Microsoft Teams meeting app is a perfect example. Chances are pretty good that you are already investing in Microsoft 365 subscriptions for your office. This course will show you how to use the Microsoft 365 subscription ROI by fully utilizing the meeting app and eliminate the unnecessary cost of a separate third-party meeting app. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - John Higgins, CPA.CITP

More Dates

One of the most talked about emerging technologies that has the potential to significantly disrupt the accounting profession is blockchain. This course is designed to bring you up to speed on what this revolutionary technology is all about. You will learn about the concepts, nomenclature, technology and potential applications related to blockchain. This will prepare you to participate in conversations about blockchain technology with your colleagues, peers and others. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - John H. Higgins, CPA.CITP

More Dates

Due to increasing scrutiny in the employee benefit plan area, it is imperative for auditors of 401(k) plans to remain up to date on the rules and regulations that may impact the audit engagement. With SAS 136, the AICPA's new employee benefit plan auditing standard, now effective, this knowledge is even more critical. In this course, auditors will enhance their knowledge by understanding the changes affecting audit procedures and reporting under SAS 136, identifying best practices, and performing efficient audit engagements.

More Dates

This fast-paced course focuses on using Excel Power Pivot features to enhance data analysis. One of the strengths of Power Pivot is the formula language DAX (Data Analysis eXpressions). We will spend considerable time using the power of DAX to create meaningful calculations that add new dimensions to our data. We will also review the use of a date or calendar table that allows us to perform date analysis that was never possible before. This will allow us to use the new time-intelligent functions to perform complex calculations on our data such as: month-to-date, quarter-to-date, year-to-date, last year same period, last year-to-date, etc. We will also demonstrate the hottest tips and tricks that will take your data analysis to the next level. Although our focus will be on using Power Pivot, we will review some of the other Power BI Tools including: Power Query (Get & Transform), Power BI Desktop and Power BI Services (PowerBI.com). NOTE: If you want to apply the concepts presented, you will need Excel 2013, 2016 or 2019/Office 365 AND the Power Pivot add-in pre-installed. To see our full prerequisite recommendations, see PROGRAM CONTENT section below. This session is presented using Excel 2019/Office 365. Regardless of the version you are using, most concepts covered in this course apply to all versions of Excel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Bryan L. Smith, CPA.CITP, CISA

More Dates

In this course, participants will learn about key trends and innovations impacting the field of forensic data analytics.  From generative AI to ChatGPT, machine learning and transaction review, data sharing consortiums and cryptocurrency trends, this course is for the futurist who wants to be leading edge in compliance and anti-fraud technology innovation.  Speaker - Vincent Walden

More Dates

Transform your Excel skills with our comprehensive training program, designed for users at all levels seeking to master the full suite of Excel capabilities. From powerful data analysis tools like PivotTables and advanced functions such as XLOOKUP, to the nuances of Data Validations and Conditional Formatting, this course offers a deep dive into Excel's most impactful features. Whether you're streamlining complex data sets, enhancing your reporting skills, or just looking to boost your productivity, this session provides the insights and techniques you need to leverage Excel to its fullest potential, making it an indispensable tool in your professional or personal toolkit. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Bryan L. Smith, CPA.CITP, CISA

More Dates

This course is designed to provide learners with an understanding of the Internal Revenue Service (IRS) Cybersecurity Checklist and how it can be used to protect taxpayer data. The course will cover the basics of cybersecurity, including threats, risks, and vulnerabilities. Learners will be introduced to the IRS Cybersecurity Checklist, which provides a framework for organizations to assess and enhance their cybersecurity practices. The course will cover the various elements of the IRS Cybersecurity Checklist, including access control, data protection, and employee training. Learners will gain an understanding of the importance of each element and how it contributes to the overall security of taxpayer data. The course will also cover best practices for implementing each element of the IRS Cybersecurity Checklist. Throughout the course, learners will be presented with real-world examples of cybersecurity threats and breaches, highlighting the importance of effective cybersecurity practices. Learners will also be given practical exercises and assessments to reinforce their understanding of the IRS Cybersecurity Checklist. *Please Note:  If you need credit reported to the IRS for this IRS approved program, please download the IRS CE request form on the Course Materials Tab and submit to Kori.herrera@acpen.com. Speaker - Arthur Werner

More Dates

This course begins with a look at the GASB standards effective this year, including GASB 100, Accounting Changes and Error Corrections and GASB 101, Compensated Absences. We'll include practical application of the topics in the form of case studies. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Melisa F. Galasso, CPA

More Dates