CPE + Events Catalog

Stay current on recent changes in accounting and auditing. Review Financial Accounting Standards Board (FASB), U.S. Securities and Exchange Commission (SEC), Private Company Council (PCC), Public Company Accounting Oversight Board (PCAOB) and American Institute of Certified Public Accountants (AICPA) standard-setting activity in the current year. Implementation dates will be provided so you can plan for changes, and the course will highlight the changes that will be implemented in the current year. We'll also discuss the difference between public and private company requirements.

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. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

PivotTable is a fancy term for an Excel report that summarizes data. If you have not yet had the good fortune of exploring PivotTables, it is about time. In this session, we'll dig into PivotTables, understand the report layout options, and examine PivotTable formulas.

Are you preparing for your next peer review? Join us as we walk through the peer review process, the necessary elements of quality control and offer tips to help enhance the quality of your peer review.

Storytelling makes wisdom stick.

Difficult conversations tend to be avoided because professionals shy away from the uncomfortable, and the fear of polarizing their relationships. Participants will learn strategies and tactics to engage in productive conversations which address challenges and deepen relationships. They will understand where and why they are avoiding having difficult conversations. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Maximizing Analytic Procedure Evidence - Adding Value Through Useful Financial Statement Analysis will enhance an ability to read and interpret financial information as a critical audit skill. Financial statement auditors need to be able to analyze financial results to not only enhance audit quality, but to also improve client service through being a better business advisor. Note: This course is recommended as a part of a 16-hour audit skills curriculum for supervisory or managerial auditors, while it is also appropriate for anyone who has responsibilities for analyzing and interpreting financial statements. 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 is designed to assist practitioners in preparing Offers in Compromise (OIC). After this course, you should have an understanding of how proper planning can make a significant difference in the amount eventually paid to the IRS and the resulting financial well-being of your client. This program covers the basics, from choosing the proper forms to utilize through the filing of an appeal if necessary. We will also explain how to increase your chances of having your OIC approved by the IRS by going over the complexities involved.

Explore the intricacies of federal income taxation as it intertwines with rental real estate activities. This course delves into the calculation of rental income, understanding the nuances of deductions, and unraveling the complexities of passive activity loss rules. Whether it's mastering Schedule E or understanding Congress' intent behind tax laws, professionals will leave with an enriched understanding.

Globalization continues to make it easier for taxpayers to live abroad, do business in other countries, or invest in foreign enterprises. This creates significant complications and tax planning opportunities when it comes to filing U.S. tax returns. This course provides an overview of the unique tax challenges and solutions presented to U.S. expats or investors living or investing abroad. It examines how foreign-source income is taxed in the U.S. and how the tax consequences could be mitigated by applying the tax treaties, claiming credit for foreign taxes paid, or excluding foreign-earned income. Additionally, the course discusses the numerous foreign informational form reporting requirements and the significant penalties that could be imposed by the IRS. Examples from real-life client scenarios are included.

Recent legislation in Congress has provided the IRS with substantially increased funding to bolster its human staff and purchase software that will allow the IRS to audit many more taxpayers in a more effective way. The IRS believes it can target the right kinds of taxpayers for audits so that it will not waste its time on audits that produce little, if any, revenue. The purpose of this program is to discuss the current state of IRS audits and the anticipated increases in the IRS's ability to audit wealthier taxpayers in an efficient way. Panelists will discuss the state of the IRS's current audits and where the IRS is headed with audits in the coming years. Tax practitioners should also be aware of the state of the IRS's efforts to target efficiencies so as to produce the most revenue.

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.

Stay up-to-date on rapidly changing developments by participating in the 2024 Governmental Accounting and Auditing Update! Take advantage of this opportunity to find out about breaking government issues. This is your opportunity to hear about the latest challenges facing state and local governments and practitioners who work with them and audit them, presented by leading experts on governmental accounting and auditing, both those who work in the trenches and those from the regulatory world. With all of the fiscal, regulatory, and new standards challenges facing governments and their auditors, it is important to keep current on critical issues and developments. In 2024, governments and their auditors continue to operate in a rapidly changing environment as they continue to face the many challenges associated with significant federal funding with complex requirements. From a governmental accounting, auditing, and compliance perspective, 2024 will be a critical year for addressing the complex federal funding challenges as well as focusing on implementing new standards and requirements! Plus, it is imperative that you start planning for the significant changes coming in 2024 and beyond! Exciting new topics this year include focused discussions on addressing the new GASB pronouncement on risk disclosures and the GAO’s 2024 Yellow Book! You’ll receive an update on the most recent accounting and auditing developments affecting governments and government auditors. This includes Single Audit issues, AICPA and Yellow Book issues, new and recently effective GASB pronouncements, audit issues, and a look at what’s on the horizon. Join ACPEN’s panel of experts as they discuss, not only the technical requirements of new standards, but also the key implementation issues that must be addressed by auditors and their governmental clients! Benefit from their experience and insights from many perspectives, as well as their long experience in governmental accounting and auditing. **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 today’s real estate market, IRC §1031 tax-deferred exchanges can be one of the most important planning tools available to the real estate investor. The use of this technique is filled with pitfalls and traps. This new course will assist the practitioner in understanding the mechanics of a tax-deferred exchange and the value of a tax-deferred exchange in both tax and financial planning. Updated August 2022

This program addresses the Section 199A deduction for flow-through entity income, including a review of the major provisions, forms reporting, and recent developments. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

It is easy for us to get caught up in our work, but it is better to examine the ‘big picture’ by studying the outside factors that impact our business beyond our internal processes and day to day responsibilities. We are sometimes so busy with our tasks that we miss new developments until the developments have a profound impact on us and the organization. This session is designed to review many of these current trends, while thinking and discussing how these trends can impact our organizations and us. This is a fun and lively session that is intended to be interactive with participants either live, virtual or both. Our ever-changing world is evolving more than many realize.

As the population of the United States ages, tax practitioners will be asked to advise their individual clients with respect to when they should begin to take Social Security benefits. This program will provide you with the background to knowledgeably discuss the benefit options available to Social Security beneficiaries and the alternative payment options available to married couples, dependents, a surviving spouse, and a divorced individual.

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 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. 

Stay current on recent changes to the AICPA Code of Professional Conduct and keep abreast of emerging trends in ethics standards and regulatory initiatives and their potential impact on your practice. Explore frequent practitioner ethics compliance challenges, including competence, due professional care, audit quality, and independence. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.