CPE Catalog & Events

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.  

In today's data-driven world, Microsoft Excel has become an essential tool for professionals in any organization. To harness the full potential of Excel, it is crucial to understand and master its lookup functions. This course is designed to equip participants with the knowledge and skills needed to effectively utilize Excel's lookup functions and enhance their data analysis capabilities. Throughout this comprehensive course, participants will dive deep into the world of lookup functions and gain experience through practical exercises and real-world scenarios. Whether you're a seasoned Excel user looking to fine-tune your skills or a beginner eager to unlock Excel's full potential, this course is tailored to meet your learning needs. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

When performing a financial statement audit, auditors have always been responsible for the detection of anything that would cause a material misstatement of the financial statements whether caused by error of fraud.  However, in the past the audit profession focused on material misstatements due to errors and more or less ignored the possibility of misstatements due to fraud.  Now, SAS No. 122, AU 240 requires significant documentation as to what the auditor did in order to determine if there any material risk of a misstatement of the financial statements.  This presentation is an overview of what the auditor is to document in there working papers on every financial audit as to the procedures they performed in order to determine the risk of a material misstatement.  If a material risk is discovered, they are then required to document what they did in order to determine if the financial statements were misstated.

This course highlights significant updates that affect financial reporting and related attestation services. We will explore novel FASB pronouncements while examining the enduring impact of lease accounting and revenue recognition standards. This course will provide reminders regarding both GAAP and non-GAAP financial reporting alternatives for closely held entities. We will also explore selected guidance regarding audit, review, and compilation engagements.

Financial statement disclosures are important to provide the information necessary for financial statement users to make economic decisions. Disclosures further explain and clarify information provided in the basic financial statements, but also provide critical information about subsequent events, litigation risk, and other concerns. This course focuses on the most common financial statement disclosures for small- or medium-sized nonpublic entities. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Review of the major employment laws governing the workplace, when they are triggered, and key compliance aspects under each law. This presentation is designed to give viewers enough information to issue spot when matters arise in the workplace.   

The objective of corrective action is to change conduct through teaching. Corrective action may be sequential, out of order, repetitive, or not appropriate to take at all. The action selected should reflect the type, frequency, and severity of the misconduct. Changing conduct through teaching requires effective employee relations skills. This course provides practical knowledge and scripts for handling a wide array of sensitive misconduct situations with good judgment, such that personal and employer liability is avoided.

The annual budgeting process is often criticized as an accounting exercise that is obsolete soon after it is published, prone to gamesmanship, cumbersome, not volume sensitive, and disconnected from the organization's strategy and risk management processes. You can resolve these deficiencies using capacity-sensitive driver-based projections. Driver-based budgeting allows for quick scenario planning and far easier analysis of a growing organization whose future may look nothing like today. The driver-based budgets can be periodically refreshed to create rolling financial forecasts extending well beyond the fiscal year end. Learn how managerial accounting can become managerial economics.

Are you looking to take your PivotTables to the next level? Many experts consider PivotTables to be Excel’s most powerful feature. Yet, most who create and work with them barely scratch the surface of all that PivotTables can do. In this session, you’ll learn eight powerful features you may have missed. From user-defined calculations to consolidating reports and adding KPIs, we’ll show you how to get the most out of your PivotTables. These are just some examples of the great things you can do with PivotTables, and in this session, you will learn these and other techniques to make your PivotTables even more powerful.

This session will address the complex rules of retirement distributions, review key provisions of the SECURE Act 2.0, and provide practical strategies of maximizing tax benefits for your client. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Network forensics - defined as the investigation of network traffic patterns and data captured in transit between computing devices - can provide insight into the source and extent of an attack. It is used in forensic accounting and with the expansion of information technology it has become a growing field. Network forensics is a relatively new field of forensic science. Computing has become network centric. Data is now available outside of disk-based digital evidence. Network forensics can be performed as a standalone investigation or alongside a computer forensics analysis. When used alongside a computer forensic analysis it is used to reveal links between digital devices or reconstruct how a crime was committed. Network investigations deal with volatile and dynamic information and is a sub-branch of digital forensics. It relates to the monitoring and analysis of computer network traffic for information gathering, legal evidence, or intrusion detection. This course is a complement to our other courses in the series on becoming a forensic accountant.  

This course is one of the courses dedicated to our Controllership series. This series of courses is dedicated to exploring the traditional controller role and stepping out of the box to identify areas where the controller can continue to add strategic value to their organizations. Within this segment of our controllership series, we will discuss the area of inventory. This specific segment in the first part of a two-part series on inventory. We explore how the controller can move these responsibilities into more of a strategic role. This course takes a look at some of the typical concepts and duties involved in the inventory function that is sometimes viewed as operational roles. We explore how these areas are strongly tied to the importance of the controllership role and how the controller can add value in each area.    

This course explores the latest tax provisions impacting non-profit entities, including charities, hospitals, and universities, with a focus on common issues CPAs may face when completing their clients Form 990. *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

This program presents a detailed analysis of the self-rental passive activity rules, including forms reporting examples and integrates them with the flow-through entity rules related to self-rental.  *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

In this cutting-edge course, participants will gain a deep understanding of how to leverage ChatGPT, OpenAI's powerful language model, to innovate and enhance business advisory services in the accounting sector. The course integrates theory and practice, demonstrating how various enterprise evaluation methodologies can be applied in conjunction with ChatGPT for increased business analysis efficiency, profitability, and growth. It also provides hands-on training for implementing these techniques in real-world scenarios. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Comply With All Standards As You Prepare, Compile and Review Engagements This webcast is a go-to reference for staying in compliance with all professional standards surrounding engagements performed in accordance with Statements on Standards for Accounting and Review Services (SSARSs).

Budget methods are the key to allowing department managers to efficiently prepare their budget in Excel. For example, a budget method may be to spread prior year actuals or match prior year actuals, or match prior year actuals less 10%. In this webinar, we will explore how to allow users to pick a budget method from a drop-down list for each account and then have Excel perform different calculations depending on the budget method selected. We use several features and functions at the same time to pull this off. Even if you are not involved in the budgeting process, the underlying features and functions discussed have a wide range of uses.

Peer review deficiencies and professional liability claims result from both audit and nonaudit services. This course will provide best practices for avoiding legal liability and quality control concerns for a wide variety of professional services offered by public accountants.

Nonprofit entities have a high degree of public accountability. This course will examine the most common fraud schemes and provide multiple examples of how to prevent or detect these schemes. Nonprofit entities have a high degree of public accountability. This course will examine the most common fraud schemes and provide multiple examples of how to prevent or detect these schemes. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

New Technology, the move toward telecommuting, the widespread adoption of electronic documentation, and a wide range of other factors have significantly and forever changed the way business is conducted. It should go without saying that changes in tools and methods lead to upheaval in any organizations internal control system. In this session, we look at all the changes that are occurring and discuss what's coming in the not too distant future. The material then looks at how internal controls have been affected and what other updates are on the horizon. Anyone trying to use controls to keep their organization efficient and secure should consider this session because the rate of change to both operational methods and control processes has been and will continue to be incredible. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.