CPE Catalog & Events

Many people that use Microsoft Excel know a great deal about the functionality of the application. There are, however, a tremendous number of hidden tools that a high percentage of users overlook. Additionally, there are newer features that some have not had the opportunity to explore. This session shows some of the numerous time-saving tools and features that often go unused by spreadsheet creators. People that wish to become more efficient when using Excel should take this session! This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Financial statements are a window into what is going on in the day-to-day operations of the company. They help us see what the company's strengths and weaknesses are. However, financial statements can often have different messages depending on the user. 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.

Some updates just can?t wait until the year?s end! Join CalCPA's Titans of Tax in a new one-day-only session designed to cover tax updates you?ll want to know before the end-of-year planning and updating begins. 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

The updated revenue recognition standard outlines five steps for proper compliance. At the surface, these steps seem simplistic. However, there are many considerations that should be considered within each step based on your process and industry.  

What you need to know about the lessee and lessor accounting models This course explains the lessee accounting model, including Lease and non-lease components Lease classification Amortization of the right-of-use asset Interest on the lease liability This course also explains the lessor accounting model, including Transfer of risk Profit recognition Collectibility Included in this course are detailed and illustrated examples with amortization tables and journal entries.

The Tax Cuts and Jobs Act (TCJA) introduced sweeping changes to individual and business taxation, but many provisions are set to expire after 2025. This course provides a detailed overview of the upcoming sunset provisions and their implications for taxpayers. Attendees will explore key changes to marginal tax rates, the Child Tax Credit, SALT deductions, bonus depreciation, estate and gift tax exemptions, and the Qualified Business Income (QBI) deduction. Gain practical strategies to help clients maximize opportunities under the current rules and prepare for the return of pre-TCJA tax structures. With a focus on planning and compliance, this course equips CPAs, EAs, and other tax professionals with the tools needed to navigate the sunset provisions and guide their clients effectively.

Power BI - Bringing It All Together for Data Analysis is an advanced-level course designed for professionals looking to integrate and optimize their use of Microsoft Power Pivot and Power BI. Building on the foundational knowledge from previous courses, this session focuses on the crucial next steps after creating data models and measures, guiding participants on how to fully utilize the potential of these tools to uncover insights and create impactful, actionable visualizations. This course takes a deep dive into the critical aspects of using Power BI to its fullest potential, emphasizing a holistic approach to data analytics. You'll learn how to build a streamlined workflow, ensuring every step in your data journey contributes to actionable insights. The course also focuses on optimizing performance for data models, utilizing advanced features of Power BI Services, and moving beyond basic data models to create advanced solutions tailored to real-world business needs. By the end of the course, you'll be able to synthesize all your Power BI skills to design and deliver powerful analytics solutions tailored to any audience. Whether you're presenting to stakeholders, sharing insights across teams, or managing enterprise-level reporting, this course will equip you with the tools and strategies to succeed. Perfect for Power BI users looking to tie all the pieces together into a comprehensive, efficient workflow. 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 provide a general understanding of the new reporting and disclosure requirements for employee benefit plans under the now effective SAS 136, the AICPA's new employee benefit plan auditing standard. Participants will be provided with an insight into the common errors and mistakes made by auditors and plan administrators, as well as the new requirements of both groups under the new SAS. The course will discuss the results from the Department of Labor's ("DOL") Criminal Enforcement initiative and audit quality study, and focus on the causes of the recent increase in the number of deficient engagements identified by the peer review process. This course will provide auditors and plan administrators with up-to-date information regarding defined contribution plans auditing, reporting and disclosure requirements, including those related to the new ERISA Section 103(A)(3)(c) audits under SAS 136.

When a purchaser buys an existing partner's partnership interest or the interest of a member of a limited liability corporation (LLC) taxed as a partnership, the amount paid becomes the basis for the purchaser's partnership interest (outside basis). If the partnership's assets have appreciated sufficiently, the difference between the new partner's inside and outside basis can be substantial. This disparity can deprive the new partner of depreciation deductions and inflate his or her share of the gain from subsequent property dispositions unless a Section 754 election is in effect. The Section 754 election can also apply when a partnership makes a distribution of property and the basis of the distributed property to the partnership and the basis the partner/distributee will take in the distributed property are not equal. In this case, a partnership can recover basis it would otherwise lose if the 754 election were not in effect.

The new Standards emphasize that quality performance requires conformance to the Standards. Each standard within Domain III specifically identifies the responsibilities of the CAE and the board, as well as joint responsibilities. The new Global Internal Audit Standards were released on January 9, 2024, and will become effective January 9, 2025. The previous version, the International Standards for the Professional Practice of Internal Auditing, released in 2017, remains approved for use during a one-year transition period. The Global Internal Audit Standards guide the worldwide professional practice of internal audit. They serve as a basis for evaluating and elevating the quality of the internal audit function. The Standards use 15 guiding principles with five separate domains that enable effective internal audit implementation and examples of evidence of conformance. The Global Standards are organized into five domains. Domain I: Purpose of Internal Auditing Domain II: Ethics and Professionalism Domain III: Governing the Internal Audit Function Domain IV: Managing the Internal Audit Function Domain V: Performing Internal Audit Service

There is simply no denying that a sufficiently designed and effectively operating system of internal controls over reliable financial reporting is more important than ever. The primary objective of this course is to give participants "hands-on" practice in designing, evaluating, and communicating conclusions related to design and operating effectiveness of internal controls over reliable financial reporting and other risks for nonprofit environments. 

As part of the Tax Cuts and Jobs Act (TCJA), IRC § 199A was added.  This Internal Revenue Code section allows certain pass-through entities the ability to has made it deduct up to 20% of their qualified business. Although practitioners have had over three years of “experience” utilizing IRC § 100A, many practitioners still do not feel comfortable with this part of the Internal Revenue Code.  The purpose of this presentation is to provide the practitioner with an understanding of the rules of IRC § 199A as well as an understanding of the IRC § 199A regulations. **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.

U.S. Department of Treasury's Financial Crimes Enforcement Network (FinCEN) imposed a new reporting requirement that went into effect on January 1, 2024. Millions of businesses may have to file a Beneficial Ownership Information (BOI) Report. In a surprise turn of events, the Federal District Court from the Northern District of Alabama ruled on March 1, 2024 in National Small Business United v. Yellen ("NSB") that the CTA is unconstitutional. This course will discuss the CTA's provisions and the court's decision in NSB. Also covered will be future implications for business entities and steps to consider given the recent ruling. We will also discuss recent proposed rulemaking by FinCen with respect to nonfinanced purchases of residential real estate and gratuitous transfers so that businesses can prepare for any additional reporting burdens that might arise. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Employees, now more than ever, are experiencing stress, anxiety and other mental health challenges and all of those come with them each day to the workplace. In order to ensure the safety and security of their workplace, employers need to address these issues and support their employees. Join us to discuss the challenges to providing mental health support to employees, the potential risks of deprioritizing mental health, and tangible actions employers can take to support the mental health of their work group. The cost of providing mental health resources and support pales in comparison to the cost of NOT providing it. Make a plan. Be ProActive.

When the leadership in any organizations carries out their responsibilities of establishing, maintaining and monitoring internal controls, it significantly reduces the possibility of fraud occurring.  When and if it does occur, a good system of internal controls will often detect it early on.  This presentation is an illustration of what can happen when top management fails to carry out their responsibility of protecting an entity’s assets through a good system of internal controls.

Lease accounting under FASB ASC 842 is now fully effective for all entities. Transitioning to new GAAP always leads to implementation issues and concerns. This course will answer the most common questions asked related to the latest lease accounting and financial reporting requirements after adoption and transition. 

Today's savvy executives use LinkedIn to accelerate hiring, as well as, to promote employee retention and engagement. This interactive session is for the financial executive who is actively growing and nurturing a team or company and wants to leverage LinkedIn, which is the best digital resource available. Join us for this powerful webinar and unlock the full potential of LinkedIn as your HR secret weapon for recruiting top talent, retaining your best employees, and elevating overall team engagement. 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 review common deficiencies identified by the AICPA and state boards of accountancy. It features discussion on a variety of topics, including analytical procedures, sampling, group audits, and risk assessment. We will review the areas of concern and how you can overcome them by employing best practices.

This course will provide an update of Government Auditing Standards as a result of the GAO's issuance of the 2024 Revision to Government Auditing Standards. The course will focus on the Revisions impact on financial statement audits. The course will also focus on the impact of Quality Management Standards as well as clarify as to when the concept of reporting key audit matters might apply for financial audits. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.