CPE Catalog & Events

You spent your life building retirement savings.  Now you want to make sure your savings last the rest of your life and perhaps pass some on to the next generation.  Come hear a veteran financial educator talk about money management and planning issues for this phase of your life.  

This updated course offers an in-depth look at the FASB leases standard (ASC 842), which requires organizations to recognize lease assets and liabilities on the balance sheet. This comprehensive course will cover recognition, measurement, presentation, and disclosure requirements, while also focusing on a critical area of change which is the proper identification of a lease using a principles-based approach. We will discuss implementation requirements from both the lessee and lessor accounting models.  In addition, we explore a variety of scenarios, including short-term leases, purchase options, variable lease payments, and remeasurement. This course offers practical journal entry examples, lessons learned from implementation, and explores recently issued amendments to the lease accounting guidance.

This session provides an overview of compilation, review, and audit engagements. We will explore major considerations regarding each type of engagement in addition to contrasting and comparing these three major professional services provided by certified public accountants. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Join us for an in-depth webcast on Charitable Remainder Trusts (CRTs) and the essential aspects of preparing Form 5227.  This course will provide a comprehensive overview of CRTs, including their purpose, benefits, and practical considerations. Moreover, we will delve into the intricacies of Form 5227, the informational return for charitable remainder trusts, ensuring you have the necessary knowledge to accurately complete and file this crucial document. During this webcast, Art Werner will guide you through the fundamental concepts of Charitable Remainder Trusts, illustrating how they can be utilized as a strategic tool for tax planning. We will explore various types of CRTs, their formation, and the different scenarios in which they are most beneficial.  A significant portion of the webcast will be dedicated to Form 5227, the reporting requirement for charitable remainder trusts. We will provide an in-depth analysis of the form's components, line by line, ensuring you gain a comprehensive understanding of the information it requires. From trust assets and income to distributions and charitable beneficiaries, we will cover each section, discussing common pitfalls and best practices for accurate reporting. Mr. Werner will address the recent updates and changes to Form 5227, enabling you to stay up to date with the latest compliance requirements.

When do they exist and how to report them? This program will provide a detailed analysis of the real estate professional passive activity rules, including forms reporting examples, and integrates those rules with when real estate is considered a "business" under the Section 199A flow-through entity deduction.  **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.

With approximately 500 functions now available in Excel, some newer and more powerful tools are easy to overlook. But, if you do that, your productivity will suffer. In this session, you will learn how to take advantage of many of Excel’s more advanced features – some new and some legacy – to elevate your productivity to higher levels. In this session, you will learn about many of Excel’s newer tools, including XLOOKUP, SUMIFS, SWITCH, and STOCKHISTORY. Also included in this session are discussions of advanced financial functions, such as IPMT and PPMT, and how to retrieve summarized data easily using GETPIVOTDATA and CUBEVALUE. Additionally, you will learn how to make sophisticated calculations easier with Dynamic Array formulas, harness the AGGREGATE function's power, and create more accurate forecasts with Excel’s FORECAST.ETS function. No matter your experience working with Excel, participating in this course will help you work more efficiently and effectively in Excel.

Valuation techniques and cash management activities are two other tool categories that can round out your analytical toolbox. In this course we will initially discuss how to turn your financial plan into a powerful valuation engine.  We then will discuss the formation of an efficient cash management program based on solid banker relationships.  Finally, we will review Ten Steps for keeping your financial toolbox full.

This course is an updated overview of the single audit of state and local governments and not-for-profit organizations under the OMB Unified Circular, as well as the applicable AICPA standards for compliance audits. 

A comprehensive review of the newest version of the U.S. Government Accountability Office’s Government Auditing Standards, otherwise known as “the Yellow Book.”  The standard will affect all auditors who perform audits of government and nonprofit organizations who receive federal funds, or where application of GAO standards is required by law, regulation or contract.  It does not address the standards applicable to performance audits.

Managing expenses is a key for business success, and overhead costs play a pivotal role in realizing favorable profit margins. Almost all companies have some form of overhead consisting of specific categories of indirect expenses. The better organizations are able to manage overhead costs, the more competitive they are in the marketplace. It is incumbent in the Controller’s role to effectively manage, monitor and perform ongoing assessment of overhead costs, allocations and rates. Overhead refers to the ongoing business expenses not directly attributed to creating a product or service. A company must pay overhead on an ongoing basis, regardless of how much or how little the company sells. It is important for budgeting purposes but also for determining how much a company must charge for its products or services to make a profit. Overhead can be fixed, variable, or a hybrid of both. There are different categories of overhead, such as administrative overhead, which includes costs related to managing a business. In short, overhead is any expense incurred to support the business while not being directly related to a specific product or service.      

Environmental, Social and Governance (ESG) has become a hot topic among standard setters. This session will look at the work of the FASB, GASB, and AICPA in the areas of ESG. We’ll also look at the types of engagements CPAs can provide to entities who want assurance around their ESG reporting.

Financial skills needed in many situations are constantly changing.  It is prudent to routinely look into your toolbox to restock or revise your tool set.  In this course we will examine three tool categories that form the foundation for many analytical processes.

This course will address the most recent tax legislation, rulings and developments occurring in 2023-24 that will impact both the business and individual taxpaying client.  The course is designed to prepare the practitioner for the upcoming filing season and provide useful strategies to assist in the tax preparation process. **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.

Isn’t it time you learned about PivotTables – Excel’s best feature? If so, participate in this session to learn PivotTables from A to Z to take full advantage of this terrific tool's many benefits.

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.  

Today’s economy and all of the digital enhancements have impacted the way companies engage with their customers as well as how the company manages their internal practices. The business control function needs to keep pace. The rising importance of analytical capability is critical when defining the role of the modern controller. Execution of analytics can vary but there are still key questions that must be asked. What are the options and what we need to understand to decide the best way forward? This course focuses on the value that can be brought by the Controller when becoming involved with data analytics powered by technology and also Big Data. The digitized world we live in has made it important for the Controller function to evolve and take on this advanced task.  

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.  

The budgeting process can be a time consuming and frustrating process for accountants.  The constraints and pressures can lead to poor decisions in both the technical and human components.  This session will cover: Avoiding Budget People Issues:  Managing Budgeting’s Soft Side •    Financial plans have a technical component and human component.  We can resolve some of our budget issues by exploring the process’ human aspect.  This session includes a case study that measures an individual’s personality type and then explores how to use our strengths and weaknesses to create to a better plan.  

Imagine being able to see into the future with confidence.  The ability to be a great forecaster is not innate but learned.  By examining great forecasters, we can learn to improve our ability to predict the future.  We will examine best practices and current research to improve our ability to predict events that will affect our business.  

Breaking the Wall of blind acceptance; avoiding habitual complacency and Yoking the dots between cause and effect.