CPE + Events Catalog

Financial skills needed in many situations are constantly changing. It is prudent to routinely look into your toolbox to restock or revise your toolset. This course will examine three tool categories that form the foundation for many analytical processes. The first category is Financial Statement Analysis. This tool does not have to be complicated. We will present an effective and efficient financial statement analysis approach. The second category is Integrated Strategic and Financial Planning. Businesses need to know where they are going and integrate strategic direction into financial and individual plans. Learn to build an effective integrated planning model. The third category is Action-oriented Business Metrics. Financial professionals generate a vast quantity of metrics. Examine how to turn these financial measures into operating results. Companion course: Corporate Finance Competency: Analytical Toolbox

In June 2022, the AICPA Auditing Standards Board (ASB) issued three interrelated standards on quality management (collectively, the QM standards). The new QM standards represent a significant change in how CPA firms will approach audit and attestation quality in the future, moving from a policies-based approach to a risk-based approach. The new standards will affect every firm that performs engagements in accordance with the SASs, SSARSs and SSAEs. Implementation of these new standards is required by Dec. 15, 2025. The key changes brought about by the new standards are: A new risk-based approach, incorporating a risk assessment process driving firms to focus on quality management tailored to their circumstances Revised components of the system of quality management-two new components, including information and communication More robust leadership and governance requirements Enhanced monitoring and remediation processes New requirements for networks and service providers The new standards require firms to determine their quality management risks, to determine the root cause for the identified risk,; and to develop responses to eliminate the identified risks and avoid non-performance

Unlock the full potential of your data with our specialized course, "Create Measures in Power BI that Define Your Metrics". Designed for professionals who aspire to excel in the dynamic world of data analysis, this 4-hour intensive training delves deep into the advanced functionalities of Microsoft Power BI. You'll embark on a journey to master the art of Data Analysis Expressions (DAX), a powerful tool in the Power BI suite to create metrics. This course is meticulously crafted to transform you into a proficient user, capable of harnessing complex DAX calculations to bring your data to life. The course content is thoughtfully structured to ensure a comprehensive learning experience. Starting with the foundational elements of DAX, you'll rapidly progress to tackle advanced formulas and time-intelligent functions, essential for nuanced data analysis. The highlight of the course is the emphasis on the DAX calculation process, a crucial aspect for validating measures in Power BI. Additionally, the practical application of PivotTables for measure validation will equip you with the skills to confirm the accuracy and effectiveness of your data measures. These advanced techniques are not just theoretical concepts but are presented through engaging, real-world scenarios, enabling you to apply your learning immediately to your daily tasks. This course is an invaluable step towards mastering Power BI and making data-driven decisions with confidence. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Substantive Analytic Procedures - Strengthening Evidence to Satisfy Audit Objectives will provide the tips and best practice techniques for strengthening substantive analytic procedures in order to reduce over-reliance on tests of details. One of the ways to perform a more effective and efficient audit is to maximize the use of substantive analytic procedures in the detailed audit plan. Note: This course is recommended as a part of a 16-hour audit skills curriculum for in-charge or supervisor auditors, while it is also appropriate for anyone who has responsibilities for analytical procedures. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This course provides a complete framework for transforming the culture in your organization. Key topics covered include: - What is organizational culture - A self assessment - Why culture matters - How to change your culture This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

AI is an extremely popular topic these days, and for good reason! However, does AI present yet another threat to your privacy? Get answers to this question and more in this session.

This is a two-part series that discuss new trends and concepts the financial controller should begin to execute in order to truly become a valued member of the senior leadership team. The rapid pace of the evolving technological landscape has promoted changes in how accountants and financial professionals focus attention on strategy and modernize their roles to leverage digital technology. There is increased demand for enhancing flexibility into finance cycles and initiating real-time reporting and insights. These are the core attributes that will assist in transforming the work that controllership function performs. Is the financial controllership prepared to meet future business demands? The IMA® (Institute of Management Accountants) and Deloitte’s Center for Controllership aimed to better understand the current state of controllership and expectations of future demands for controllers and accounting professionals. They conducted a survey in late 2022 and identified several trends. The survey takes a look at how prepared controllership is to meet future business demands. It also highlights some insights for leaders to consider that may increase their preparedness. It also identified areas of additional insight and questions to answer on the controllership transformation journey. In this segment one, we go through numerous concepts in detail and the remaining concepts will be covered in segment two.

Quality management will have a big impact on CPA firms. This course will cover both SQMS 1 and 2 as well as the related engagement level standards (SAS 146 and SSARS 26). The new standards will require a risk-based approach to quality management as well as the documentation of an information & communication process. This two hour class will provide a deep dive into what you need to know to start your implementation process!

This course will start with a review of the impact of the 2024 Compliance Supplement on Single Audits as well as the changes to the Uniform Guidance. We will also review common audit deficiencies found in Single Audits.

Understand the statements, disclosures, and considerations for plans that file Form 11-K, as well as the impact of SAS No. 136. Learn ways to plan and conduct effective risk-based ERISA plan audits.

Modern planning ideas and tax-saving strategies to keep more of your clients' money in their pockets.

This is a two-part series that discuss new trends and concepts the financial controller should begin to execute in order to truly become a valued member of the senior leadership team. The rapid pace of the evolving technological landscape has promoted changes in how accountants and financial professionals focus attention on strategy and modernize their roles to leverage digital technology. There is increased demand for enhancing flexibility into finance cycles and initiating real-time reporting and insights. These are the core attributes that will assist in transforming the work that controllership function performs. Is the financial controllership prepared to meet future business demands? The IMA® (Institute of Management Accountants) and Deloitte’s Center for Controllership aimed to better understand the current state of controllership and expectations of future demands for controllers and accounting professionals. They conducted a survey in late 2022 and identified several trends. The survey takes a look at how prepared controllership is to meet future business demands. It also highlights some insights for leaders to consider that may increase their preparedness. It also identified areas of additional insight and questions to answer on the controllership transformation journey. In this segment, we will go through numerous concepts in detail.  

This course addresses the most recent legislative developments impacting business taxpayers, with a focus on important provisions, rules and concepts to apply when preparing client returns.     **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.

It’s a whole new world for lessees under ASC topic 842.  Soon nearly all leases will need to be disclosed as a liability on the balance sheet – from buildings right down to autos and copiers.  Although the greatest impact will be on large entities, this will affect the financial statements of small and mid-size entities as well.  This program will dive into the new standard on leases, effective dates, and address what you need to know now.

Are you aware there are 470+ formula functions in Excel? Do you realize that they add new functions in every major version of Excel? Did you know that Microsoft adds new functions throughout the year in the Office 365 version of Excel? Are you stuck using old or simple functions like SUM or ROUND? Do you want to expand your knowledge of the extensive function library in Excel? If these questions peak your interest in becoming an Excel function expert, this course is right up your alley. This past-paced course digs into some of the most powerful functions in Excel. Although we cannot cover 470 functions, we will look at over 20 functions that will allow you to create advanced calculations in your spreadsheets. Some examples are: VLOOKUP, IF, IFS, FORECAST, RAND, SWITCH, TEXTJOIN, UNIQUE, SUBTOTAL, IS, TEXT and more! We will also provide example files that will include all the functions used during the class. It's time to take your Excel spreadsheets to the next level. This session is presented using Excel 2019/Office 365. 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.

Not a big fan of insurance? Many CPAs are not comfortable providing insurance evaluations and recommendations. And what clients realize is it's too late to plan after the fact! Attend this workshop and learn everything you need about insurance to advise your clients wisely and help them prepare for the unexpected. Insurance can be a powerful tool to mitigate potentially financially devastating perils, but only if you understand the inherent risks and how to sort the wheat from the chaff. In this course, you'll cover contractual red flags, product types, taxation issues and all the essentials on a full spectrum of insurance, including life, disability, health, homeowners, automobile and liability insurance.

Resilience training was originally developed to strengthen individuals in high-risk groups like law enforcement, firefighters, and the military. This course also speaks to accounting and finance experts in a very challenging discipline. Resilience training is based on the intriguing assumption that resilience can be learned. A resilience leader possesses mental toughness, competence, and confidence. A confident accounting or finance person makes better decisions and thinks in deliberate ways to meet adversity and pressure. Resilience is the ability to exercise tenacity, bounce back from tough times, or even triumph in the face of adversity. Today's accounting professionals will experience challenges but are able to reframe then as learning opportunities. Resilient accounting and finance professionals push their limits, learn from their mistakes, and are able to transform an organization and themselves.

Since the early 2000s, the estate tax burden on taxpayers has gradually decreased along with the number of practitioners specializing in the field. Nevertheless, some of your most wealthy clients will have a taxable estate. For these select clients, making large gifts before death can be extremely tax efficient for the client and profitable for the practitioner filing the gift tax return. Learning how to file a basic gift tax return can help you attract and retain clients, increase your value-add, and generate revenue.

Over 9 billion data records have been lost or stolen since 2013. With a frequency of almost 5.5 million records exposed every day, it is no longer a question of whether a firm has been compromised, but more a question of when it will happen. Does your team have the cybersecurity knowledge and auditing skills to prevent or mitigate the next big breach? In this course, participants will learn the basics of cybersecurity awareness and safeguarding sensitive data, how to address cybersecurity threats within a firm, and how to use AICPA best practices to manage and obtain assurance of cybersecurity risks. By its conclusion, participants will know how to address cybersecurity threats with reasonable assurance in audit engagements.

The QuickBooks platform - including the desktop and online environments - is one of the leading accounting solutions for small and growing businesses. Further, Intuit has incorporated numerous advanced features and changes into the tools over the past few releases. This seminar will teach you how to use many new and advanced features in the desktop and online environments to help you solve critical issues. For example, you will learn advanced inventory management techniques, including changing the default costing methodology and implementing lot and serial number tracking. You will also learn how to build complete sets of financial statements in Excel that link in real-time to underlying QuickBooks data files and how to create multi-company financial statements. Additionally, you will learn how to use the Client Data Review feature to streamline how to identify and correct errors and close accounting periods in QuickBooks. Knowing how to take advantage of the advanced tools and features available can determine your level of success when working with QuickBooks. So, take advantage of this opportunity to learn about QuickBooks' "deep" features to maximize your effectiveness with QuickBooks.