CPE Catalog & Events

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.

This course provides a comprehensive update on the key developments impacting not-for-profit (NFP) accounting and auditing in 2025. While the FASB hasn't recently issued NFP-specific standards, several Accounting Standard Updates (ASUs) will significantly affect nonprofit organizations. We'll review these changes and their implications. We also explore the growing relevance of programmatic investments and their interplay with the Current Expected Credit Losses (CECL) standard, and examine the IFR4NPO initiative, a global project aimed at establishing universal financial reporting standards for nonprofits. On the auditing side, we'll delve into the impact of the new quality management standards, impacting firms that provide attestation services, including compilations and reviews for nonprofits. This session will equip you with the insights needed to navigate these changes and stay compliant.

Many Microsoft 365/Office 365 subscriptions include robust Cloud services for improving productivity. Foundational services, such as SharePoint Online, OneDrive for Business, and Exchange Online, join with other powerful tools such as Teams, Planner, Power Automate, Forms, and Power Apps to provide a productivity platform second to none. Unfortunately, most users will never benefit from working with these tools simply because they remain unaware of these features. Plan to attend this session to learn about the “rest of 365” and how these Cloud-based applications can enhance personal and team productivity while simultaneously facilitating remote working arrangements. Don’t miss this opportunity to get all the knowledge and guidance necessary to leverage your investment in Microsoft 365/Office 365 fully.

Security is not optional, and yesterday’s security techniques do not minimize today’s security threats. Therefore, now is the time for you to tune up what you know about protecting sensitive data. This program will teach you the latest tools and techniques for securing your data, including encryption, virus protection, safe communications, electronic signatures, secure authentication, and more. You will also learn how to implement a practical, five-step approach to securing your PC and the questions you should ask your staff to ensure server-based information remains protected. Security failures, such as a breach of client or customer data, are costly – they can even drive your company out of business. So, what security tools do you need, and how should you use them to secure your sensitive data and systems? Can you afford to risk attempting to manage today’s threats using yesterday’s techniques? Participate in this program to learn how to identify viable and practical solutions to mitigating today’s security threats.  

Fraud continues to plague businesses at epidemic levels, and technology control failures are a significant reason fraud occurs. Using a case study approach, in this session, you will learn about the pervasiveness of fraud, the control failures that contribute to fraud, and what you can do to mitigate fraud risk. A specific focus of this course is the application of information technology general controls and information technology application controls. In this course, you will examine numerous reported fraud cases and identify the general control and application control failures that contributed to each of these frauds. By learning through these real-world case studies, you will be positioned better to reduce fraud risk.  

This course is designed to assist CPAs who perform financial statement preparation, compilation, or review engagements. Our panelists will provide an in-depth analysis of the SSARS and will provide practice tips that will assist you in performing profitable standard compliant engagements.

If you think applying one set of audit standards is tough enough, how about applying three different sets of audit standards in one “single” audit?  That’s exactly what happens when the auditor applies GAAS, the Yellow Book and the OMB requirements in a Single Audit.  This session will start with a single audit “nuts and bolts” overview before delving into unique aspects and audit issues of the continued era of pandemic-related funding, and, of course, provide an update of any recent changes to the funding related to the Infrastructure and Investment in Jobs Act, or IIJA.  Recent changes to the Single Audit and Uniform Guidance rules will also be covered.  Join our expert panel of federal, state and local auditors and practitioners to learn what you need to know if you are performing audits under these audit standards and the Uniform Guidance for Federal Awards.

This course goes beyond the basics and addresses important practical issues that an experienced practitioner must know. Even if you have attended other S corporation courses, you will learn something new in this course.

Preparing Form 1041 is essential for tax professionals working with estates and trusts. This course provides a practical, step- by-step approach to completing the U.S. Income Tax Return for Estates and Trusts, covering key issues such as distributable net income (DNI), income in respect of a decedent (IRD), and tax compliance for fiduciary entities. Participants will gain a clear understanding of Subchapter J of the Internal Revenue Code and learn how to apply tax rules to real world situations. Through case studies and line-by-line instruction, this course equips professionals with the skills needed to prepare Form 1041 accurately and efficiently. Additionally, it will include updates on any new legislation or IRS guidance introduced by the current administration and its impact on fiduciary taxation. *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

A detailed analysis of the calculations related to determining a shareholder's tax basis for S corporation shares and loans, with a focus on how to use Form 1120S, Schedule K-1 information for basis determination. An illustrative example demonstrates how the process works, as well as the many potential pitfalls. *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

Most leadership development focuses on a single direction within the organizational hierarchy: downstream to subordinates. While it is important to be a good boss, leadership is much more than that. The best leaders learn to lead well in all directions. They lead upward to superiors and across among peers throughout the organization. And it all starts with self-leadership. This often overlooked or misunderstood leadership principle is essential to build a thriving and productive culture. This topic is based on Jon’s book, Mission-Critical Leadership: How Smart Managers Lead Well in All Directions. 

In a competitive economy, CPA's  and their firms need a way to stand out. The best way to do this is to give outstanding service to your clients. In this experiential workshop, you’ll learn skills that lead to dramatic client satisfaction. In addition, you'll learn several specific ways to guarantee you'll get a lot of word of mouth referrals that will lead to a dramatic increase in your number of clients.

This business coaching course is designed to enhance your coaching effectiveness by integrating innovative tools like ChatGPT (Generative AI) to support and elevate your coaching practice. You'll explore the key differences and similarities between coaching and managing, uncover the most important skill every coach should master, and learn how to get to the root cause of any problem. With hands-on coaching strategies, including neuro-linguistic programming (NLP) techniques, you'll enhance your ability to drive results. Additionally, you’ll discover how to use performance gap analysis to identify and bridge gaps, ensuring the success and growth of the individuals you coach.

Recent generally accepted auditing standards were written to improve the quality of risk-based financial statement audits, audit reporting, and required by-product communications. This course will discuss the important clarifications and enhancements intended to improve audit quality to ensure better compliance with requirements contained in SAS Nos. 134-145. 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 will elevate your individual income tax preparation skills and knowledge. It will help you go beyond the basics and will help you provide superior service to your clients. We will cover topics including taxation of investments, reporting of partnership and S-corporation income, net investment income tax, calculation of self-employment taxes, household employer taxes, social security taxation, basic retirement planning opportunities and Alternative Minimum Tax (AMT). In addition, we will also do a review of loss limitations and much more.

Whether saving for retirement, reducing taxes, or combining the two, pension and profit-sharing plan strategies are your go-to solution. Get up to speed with the recently enacted SECURE Act 2.0 and learn the rules of the game. Discover the type of plan documents that work best for your clients, how to terminate a plan, different retirement plans you can choose from, contribution & deduction limits, reporting & disclosure rules, Form 5500 & participant communication requirements, and even how to do in-plan Roth conversions. Get ready to make retirement planning for your clients a breeze!

This course covers SSARS requirements for preparing, compiling and reviewing financial statements through SSARS 26. With SSARS 21, the AICPA Accounting and Review Services Committee (ARSC) introduced the Preparation service to SSARS and rewrote the Compilation and Review Standards in a clarified format. SSARS 22 and 23 made minor modifications to SSARS 21. SSARS 24 and 25 made substantive modifications to the SSARS, mainly when performing review engagements. SSARS 26 updates the SSARS with conforming changes made necessary by the new Quality Management standards.

Dive into an in-depth analysis of this year's pivotal changes in Federal and California tax law. Discover the latest legislation and stay informed on crucial IRS and FTB guidance. We cover key developments from the IRS, FTB, and courts, providing essential compliance and planning lessons gleaned from recent rulings. Prepare for the tax season by thoroughly reviewing due diligence considerations relevant to all new laws. Titans of Tax 2025 Lineup: Titans of Tax Mid-Year Update 2025 Titans Annual Federal Tax Planning Individual Update 25-26 Titans Annual Federal Tax Planning: Business & Estate Update 25-26

Embark on a journey to master Power BI, a powerful tool for data analysis and business intelligence, in our comprehensive course, "Get Started with Power BI." This course is meticulously designed for professionals who seek to understand the full spectrum of Power BI capabilities, including its integration with Excel's Power BI features like Power Pivot and Power Query, and its comparison with standalone Power BI tools such as Power BI Desktop, Power BI Service, and Power BI Report Server. In the first part of the course, participants will be introduced to the fundamentals of Power BI. This includes an overview of Power BI's interface, key features, and its seamless integration with Excel. The course will cover Excel's Power BI tools - Power Pivot, for advanced data modeling, and Power Query, for efficient data transformation and preparation. This segment is essential for understanding how Power BI extends and enhances the data processing and analytical capabilities of Excel. The second section of the course delves into the standalone Power BI tools. Here, participants will explore Power BI Desktop for creating complex data models and sophisticated reports, Power BI Service for cloud-based collaboration and sharing, and Power BI Report Server for on-premises report deployment. This part of the course will focus on the unique features and strengths of these standalone tools, providing attendees with the skills to leverage Power BI in a variety of business contexts. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Relevant Excel methods for accounting experts In Excel, there are several opportunities to apply features, functions and methods to build a dynamic workbook. In this hands-on demonstration of several Excel skills, you'll review the following topics through engaging expert-led instruction: Dynamic headers Horizontal reports Mapping Tables Data Validation Excel error checking skill development Designed with time for you to work along with the facilitator, this webcast examines the importance of automating reporting workbooks in Excel. You will review various topics, including: Horizontal or crosstab reports Mapping tables and how they are the key to unlocking major efficiency gains. Data validation in digital reports Error Check *Session 8 is one of eight sessions that is available as an individual session. Each session builds on the prior sessions, so you'll want to consider watching other parts of the bundle. [Excel for Accounting Professionals Webcast Series] (https://www.aicpa-cima.com/cpe-learning/webcast/excel-for-accounting-professionals-webcast-series-bundle) to further prepare to tackle real-world issues and build powerful workbooks.*