CPE Catalog & Events

With approximately 500 functions now available in Excel, some newer and more powerful tools are easily overlooked. 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. Regardless of your experience working with Excel, participating in this course will help you work more efficiently and effectively in Excel. 

Running or advising a small business? The KPI Bootcamp can help you rapidly identify and implement the right KPIs to achieve your or your client's goals. Delivered by Bernie Smith, KPI specialist and seasoned entrepreneur, this course will guide you through selecting a powerful set of measures tailored to your business. The structured approach helps you refine your objectives and choose KPIs that drive growth and profitability. The program includes access to over 400 pre-defined KPIs, each with a clear, jargon-free definition, business benefits, real-world examples, and practical implementation tips.

*** CPE SAVINGS CODES DO NOT APPLY TO STAFF TRAININGS ***Develop your soft skills in training courses that benefit both the person attending and their organization. This course is applicable for various accounting departments (i.e. audit, tax, consulting, and accounting services) but because these are universal leadership concepts, they are equally applicable to other professional business leaders. AHI soft skills training will help improve efficiency, make managers more effective with others, and increase the organization's bottom line. Also, as these courses often include other industries besides accounting, there is an opportunity to work and network with leadership professionals from other industries. Per NASBA's rules effective January 1, 2024, participants are required to be on camera and participate in the full and small group discussions to earn CPE credits for this Group Live - Virtual course. As such, please make sure you are set up properly with reliable internet (hard wired is best), a working camera, and a working microphone.

With the increasing complexity and ever-changing nature of tax laws and issues, today’s accountant needs a partnership/LLC course focusing on the hottest tax topics and most frequently encountered issues. This case driven course will deal with both partnership/LLC and partner/member developments addressing the most common, yet complex Federal partnership/LLC issues and problems.   *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 terri.storer@acpen.com    

In today's dynamic economic landscape, staying ahead with effective fringe benefit planning is more critical than ever for both businesses and individual clients. With evolving tax laws and shifting market dynamics, understanding the intricacies of fringe benefit planning is essential to ensure financial well-being and compliance. This course offers a comprehensive overview of essential tools and techniques tailored for financial professionals, allowing them to navigate the complexities of fringe benefit planning with confidence and precision. By attending this course, practitioners will gain invaluable insights into various planning tools and techniques essential for meeting fringe benefit planning objectives. From mastering the subtleties of employee benefit planning, including ERISA reporting and disclosure requirements, to unraveling the complexities of IRC §132 fringe benefit options, attendees will enhance their expertise to deliver superior advisory services. The curriculum also delves into the practical aspects of cafeteria plans, flexible spending accounts, group term life insurance plans, and strategies for financing retiree medical benefits, among others. With a focus on practical application and real-world scenarios, this course equips participants to tackle fringe benefit planning challenges head-on, providing them with the tools and knowledge needed to optimize benefits for both business and personal needs, now and in the future. **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 course equips practitioners with the knowledge needed to help clients navigate complex tax and financial challenges. It addresses difficult client situations including divorce, bankruptcy, debt issues, and other personal and business matters that create significant tax consequences. The course provides key insights into the tax implications associated with these situations and highlights planning considerations practitioners should evaluate when advising clients. Participants will explore the tax treatment of divorce-related matters, including filing status, support obligations, and property division. The course also examines bankruptcy, debt cancellation, business dissolution, and other financial hardships that may affect a taxpayer’s reporting and obligations. Through practical discussion and analysis, participants will gain strategies to help clients make informed decisions while understanding the related tax implications. 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 terri.storer@acpen.com  

Tactical CFO is a four-part series that answers the how and execution aspects of our strategies and financials. The titles include: Tactical Budgeting – Moving Beyond Traditional Budgets to Manage Performance Description – Traditional budgets often consume significant time while delivering limited operational value. This session reframes budgeting as a tactical management tool rather than a once-a-year accounting exercise. Participants will explore how to redesign the budget process to improve communication, accountability, and decision-making across the organization. The session emphasizes output-based metrics, flexible budgeting approaches, benchmarking, and educating non-financial managers so budgets become a tool for managing performance, not just controlling spending.  Tactical Business Systems – Getting the Most from Information Systems and ERP Description – CFOs are increasingly accountable for the effectiveness of information systems, even if IT does not formally report to them. This session focuses on the tactical role finance leaders play in evaluating, selecting, implementing, and managing information systems. Participants will gain a practical framework for understanding IT, ERP systems, security, and emerging technologies such as AI. The session emphasizes asking the right questions, aligning systems with strategy, and avoiding common pitfalls that cause system implementations to fail. Tactical Data Management – Turning Data into Actionable Information Description – Organizations collect massive amounts of data, but far less information that actually improves decisions. This session focuses on how CFOs and CPAs can tactically manage data to generate insight, improve performance, and reduce risk. Participants will explore financial and non-financial data, data organization, and the role of analytics in understanding customers, operations, and employees. The session emphasizes clarity, simplicity, and storytelling so data supports better decisions rather than overwhelming stakeholders. Tactical Finance Leadership – Building the Finance Team of Tomorrow Description – The finance function is changing rapidly, driven by technology, demographics, and evolving business expectations. This session focuses on the tactical leadership skills CFOs and CPAs need to build and lead high-performing finance teams in the years ahead. Participants will explore how roles, skills, and expectations are shifting, and how leaders can prepare their teams for increased automation, real-time reporting, and greater strategic involvement. The session blends practical leadership guidance with forward-looking insights.

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.

The course provides a comprehensive, hands-on, pencil pushing understanding of the preparation of both S corporation and partnership/LLC tax returns, along with the underlying laws, regulations, etc. The course uses the basic concepts underlying the two main types of business returns: 1120S and 1065 as building blocks for more complex concepts tax preparers should be aware of. The theoretical concepts get illustrated in comprehensive examples that incorporate the most up-to-date law changes and provisions.

This session provides insights for enhancing the preparation and utilization of budgets. Seasoned accountants will benefit from a refreshed awareness of popular techniques. Budding financial professionals will obtain novel insight regarding fundamental budgeting concepts. All participants will develop an appreciation for the holistic nature of budgeting as an integral tool for planning and control. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The audit profession stands at a critical inflection point, facing unprecedented challenges from technological disruption, evolving regulatory landscapes, and workforce transformation. This comprehensive course, based on the Pennsylvania Institute of CPAs' groundbreaking research report "The Future of the Audit: Building Relevance and Sustaining Quality," provides auditors with essential insights and actionable strategies to navigate these seismic shifts. Through expert perspectives from industry leaders including PCAOB board members, Big Four executives, and audit committee chairs, participants will explore how artificial intelligence, blockchain, and data analytics are fundamentally reshaping audit practices while creating new opportunities for value creation and risk assessment. Beyond technology adoption, this course addresses the pressing talent crisis facing the profession and offers practical solutions for building a future-ready workforce. Participants will learn how to leverage emerging technologies to enhance audit quality, understand the implications of regulatory modernization including the concept of "regulatory sandboxes," and develop strategies for attracting and retaining top talent in an increasingly competitive market. Whether you're a partner in a small firm, a manager in a large organization, or an audit professional seeking to future-proof your career, this course provides the roadmap for maintaining relevance, ensuring quality, and thriving in the evolving audit landscape. You'll leave with concrete action steps for immediate implementation and a clear vision for transforming your audit practice to meet the demands of tomorrow's financial ecosystem. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

New to AI? Start here. This beginner-friendly course explains how generative AI works, what terms like "LLM" and "agentic AI" really mean, and how CPAs can safely put these tools to use. You'll leave with a solid understanding of AI fundamentals and how they apply to accounting, tax, and finance. 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.  

Every two years, the Association of Certified Fraud Examiners releases a study that details fraud cases internationally. This comprehensive study can serve as an important tool in investigating fraud, establishing internal controls, and identifying red-flags in an audit.

This course is designed for the accounting and auditing professional who provides attestation services to closely held businesses. The course reviews recent standard-setting activities of the Financial Accounting Standards Board (FASB) and the AICPA, specifically focusing on those standards having the most significant impact on closely held non-public business entities. The course also discusses adopting the latest audit standards, including the new audit risk assessment requirements.

Pass-throughs (S corporations and Partnerships) are the most popular choice of newly formed business entities. However, for years, taxpayers and their preparers have struggled to calculate, update, and maintain the pass-through entity owners" tax basis information in each investment correctly. Calculating and accounting for tax basis and adequately reporting the impact of operating and liquidating distributions for these entities are among the most frequently cited audit deficiencies. Taxpayers have also misapplied the tax rules when calculating the gain or loss from the sale of the interest. Recently, the IRS initiated enforcement initiatives designed to audit owners of pass-through entities regarding their calculations of tax basis and their tax treatment of distributions. This course will teach you how to properly account for both items for your clients who own an interest in a partnership or an S-corporation. Learn to identify the most common mistakes and errors and report these items correctly before your client is audited.

Examine significant real estate tax issues and concepts, including planning and compliance topics emphasizing tax elimination or deferral. Discuss the qualified business income deduction (Sec. 199A) as it relates to real estate investments; limited discussion of opportunity zones (Sec. 1400Z-2) relating to real estate; 1031 exchanges; home sale exclusion (IRC Sec. 121); passive activities loss rules; estate planning and gifting with real estate; and California property tax issues, updated for passage of Proposition 19 affecting parent-child transfers and transfer of assessments to a new principal residence.

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 series will offer solutions to the budgeting woes from both the big picture and in the details.  Budget Mastery: Process, Problems, and Solutions The budgeting process can be a mundane one for accountants. Let’s be realistic and agree that even the word “budget” does not bring excitement to you and your departmental colleagues.  The constraints and pressures can lead to poor decisions in both the technical and human components.  This session is the first part of a four part series and will cover the big picture of keeping the process fresh, pragmatic and useful. We discuss these keys in an engaging manner by discussing both our flaws and strengths, including how to build on these characteristics towards an enjoyable solutions-based method that should deliver effective results for your organization.  Budget Mastery: Walkthroughs and Real World Calculations Towards Tying Budgets to Value This session takes a unique review of the fundamental budget issues faced by all and walks through a detailed modeling process intended to generate discussion and best practices to improve your organization’s financial modeling.  From the beginning of the accounting process – ‘the chart of accounts’ to the end of the process – ‘the valuation of the company’, the budgeting cycle via a live case model to learn best practices common to successful companies.   This course stands on its own but is part two of a four part budget mastery series. Budget Mastery: The Human Side of Budgeting-Navigating People's issues with 360 Insight You have a fantastic budget, but certain players are not pleased. Financial plans have a technical component and human component.  We can resolve some of our budget issues by exploring the process’ human aspect.  Understanding what makes you and others operate can enhance your understanding of the entire organization and build upon the respect and influence needed to navigate and lead the budgeting cycle. 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 a better budget process and quite frankly maybe a better you.  This is a great and fun course on its own, but is also part three of a four part series on budget mastery. Budget Mastery: From Numbers to Narrative: Effectively Presenting Your Budget and Reporting  Perhaps the most important element of the budget process is its communication.  If management does not understand the budget – there is an issue. Knowing the right ways to communicate at all levels is essential to stakeholders laying an ownership claim to successful budgets.  This session reveals several key guidelines in successful budget presentations and will identify key problems in how people often communicate financial plans. Presenting your budget and reporting is the final part of a four part series, but can easily stand on its own course that is intended to be fun, enjoyable and educational.

Environmental, Social, and Governance (ESG) reporting has become an increasingly important area of focus for standard setters, regulators, and stakeholders. This course provides an overview of how ESG considerations intersect with accounting and attestation services, with attention to developments affecting both preparers and assurance providers. Participants will review current ESG-related initiatives and projects underway at the Financial Accounting Standards Board, Governmental Accounting Standards Board, and the AICPA. The course also explores the types of services CPAs may provide in connection with ESG reporting, including advisory and attestation engagements, and discusses how these engagements differ in scope and responsibility. Designed for CPAs seeking to understand the evolving ESG landscape, this course helps participants recognize where ESG fits within existing professional standards and how CPAs can support organizations seeking credibility and assurance over ESG information. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Collecting data is easy; visualizing it is an entirely different concept, which is why dashboards have become an important tool among nonprofit board members and staff. Identify practical uses for dashboards, including the organization of data, monitoring trends, tracking key performance indicators (KPIs) and more.