CPE Catalog & Events

Many clients end up selling one or more residences during their lifetimes. Tax practitioners must be aware of the tax rules that relate to such sales in order to assist their clients regarding these sales. This program provides general tax practitioners with the tax rules they need to know to help their clients when they sell a personal residence. This program is a comprehensive survey of the various tax issues associated with the sale of a residence.

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.

This course explores the increasingly complex features of Excel that facilitate efficient data analysis.  We will introduce numerous analytical methods and techniques by using practical examples to illustrate how to unleash the power of Excel when manipulating, analyzing and reporting information and dive into the powerful, but potentially under-utilized, capabilities of Microsoft Excel.  Designed for sophisticated users willing to approach spreadsheets from a unique perspective, this program encourages users to challenge the status quo by considering opportunities to take acceptable spreadsheets to a new level.

A comprehensive guide to estate planning and the taxation of trusts.

Retaining Talent in a Competitive Marketplace -Creating a Benefits Program Employees Care About In today's competitive marketplace, retaining talented employees is becoming increasingly difficult. A solid benefits program can make a difference in the fight for talent - but only if those benefits matter to the employees you are trying to hire! Through statistics and case studies, this course will explore what benefits are most valuable to employees. We will also explore the basic types of retirement and health insurance plans and discuss what financial leaders should consider before adopting a benefits package. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This intensive 2-hour course is designed to unlock the potential of array formulas in Microsoft Excel. Array formulas are a vital tool in Excel for their unique ability to perform multiple calculations on one or more items within an array, making them indispensable for complex data analysis and calculations. They enable users to write fewer, more powerful formulas, leading to cleaner and more efficient spreadsheets. This course is tailored to enhance your data analysis and spreadsheet management skills by delving into the advanced aspects of array functions. Through a combination of theoretical knowledge and practical exercises, you will learn to streamline your work and improve efficiency in Excel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The Inflation Reduction Act increased the IRS budget. As a result, the IRS continues to replenish its audit workforce. The IRS trains its audit workforce by examining the tax returns of individuals and small businesses. Now, more than ever, Accounting, Tax and Financial Professionals need clients to understand the need for documentation and procedures to substantiate what IRS examiners are pursuing. Learn the high audit risk areas and ways to help clients survive an IRS audit with little or no change. It is critical for Accounting, Tax, and Financial Professionals in public accounting to understand the risk to clients and to themselves in tax return preparation and planning since the IRS continues to increase its audit coverage and is examining more taxpayers than it has in the recent past.

Recent feedback from the AICPA has emphasized the importance of performing an effective risk assessment to identify and evaluate the risk of material misstatement in a financial statement audit. SAS 145, the 2023 amendment to AU-C 315, makes significant changes to the extant risk assessment standard and certain changes to other standards as well. The amendments clarify confusion that the AICPA believes auditors experienced under the existing standard and also conforms, for the most part, to the IAASB standard on the same topic. SAS 145 has been effective for two years now starting with December 31, 2023 audits. This course will focus on how to perform the risk assessment process under the new standard, providing participants with a summary of the changes to existing guidance. It will discuss linking the results of the risk assessment to further testing (internal control and substantive testing) and procedures performed in concluding on the evidence obtained. In addition, it will also discuss documentation and audit communications.

This session will explore newly-issued auditing standards. Particular emphasis will be devoted to the reformatted audit report and key audit matters.

This webinar aims to provide HR professionals with a comprehensive understanding of mental illness and depression under the Americans with Disabilities Act (ADA). It will cover key aspects of the law, provide practical advice, and address common challenges.

Tax practitioners advising their business clients must be fully informed regarding the multiple loss limitation provisions that apply to individuals conducting businesses and pass-through entities. This program covers the loss limitation rules that tax practitioners must know in order to advise their individual and pass-through entity clients fully and adequately as to when and if a loss limitation applies. The loss limitations discussed in this program start with an introductory discussion of hobby loss rules and graduate to a more substantive discussion of the remaining loss limitations: basis limits, at-risk rules, passive loss limits, excess business loss limits, net operating losses, and the Section 163(j) interest limitation. Knowing when loss limits apply is essential for any tax practitioner. This program will put you in a position to advise clients fully and intelligently regarding each of the loss limits.

If you do not understand the entity that you are auditing, you won’t know what type of transactions they should be entering into.  As a result, you won’t recognize those transactions they should not be there.  In other words, you will be performing the audit without having any idea of what you should be looking at.  This statement requires that the auditor document their understanding of the entity and its environment that it operates in as well as assessing the risks of material misstatement. Prior to this statement, auditors often assessed risk at maximum and did not evaluate internal controls.  A big change made by this statement is that, while it allowed the auditor to continue to assess risk at maximum, they now must first evaluate internal controls in order to have a basis for making such an assumption.  As a result, auditors are now required to document their evaluation of internal controls on every financial statement audit. This presentation is an overview of the many procedures auditors are now required to perform and document on every audit related to their understanding of the entity and its environment and the basis for assessing the risk of material misstatement.

Embezzlement happens often to many small businesses. Unfortunately, the lack of internal controls allow the embezzlement to remain undetected for years. But when it is discovered, the small business owner will most likely contact their CPA for advice. What should you do when your client contacts you about their employee embezzling money from their business? What options should you present to your client? How can your client protect themselves, while investigating the embezzlement? What steps need to be taken about preserving any documents, emails, texts, or phone calls? This course teaches how to engage the client, properly identify the evidence needed to prove the crime, how to write the report for civil and criminal trial, and best practices in preserving electronic and paper evidence. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

A discussion of the latest 2021/222 tax developments impacting business taxpayers, with a focus on important provisions, rules and concepts. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

An audit is an investment in reliable financial reporting and compliance, and an increased return on those dollars can be achieved by hiring the right auditors. This course will provide key factors for you to consider when evaluating whether you are getting the most quality and insight from your auditors, to enable them to perform the most value-added audit possible in the given circumstances - while retaining the trust of a CPA. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

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.  

Participants will learn to create customized AI chatbots that can enhance client interaction and internal operations-all without coding experience. This course provides a concise overview of specialized, task-oriented AI chatbots and GPT builders, focusing on how these technologies are revolutionizing professional workflows. Through hands-on exploration of platforms like AgentGPT, Claude Projects, Gemini Gems, and NotebookLM, participants will learn to design, deploy, and manage custom AI assistants tailored to their specific needs. The course emphasizes creating advanced AI apps that can understand context and solve complex problems autonomously. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

In the course of legal actions, payments may be made pursuant to a final disposition of a court case or a mutually agreed-upon settlement.  This course will cover the tax implications for payments made for personal injury, emotional distress, lost wages, punitive awards, pre- and post-judgement interest, contract claims, among other damages. **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.  

After a false start in 2022 when it failed to pass through Congress, the Secure Act 2.0 was passed in a flurry of year-end legislation. This two hour program will cover the important changes in savings and distributions of retirement plans that impact individuals. Employers will also need to consider how Secure Act 2.0 will the administration of existing plans or the creation of new ones. This course will provide a concise look at these hot topics. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This session focuses on the power of pivot tables within Microsoft Excel. We initially discuss the creation of pivot tables and various ways to summarize information. Then we explore ways to utilize summarized pivot table data. The course uses several practical examples that should inspire participants to find their own creative uses for pivot tables.