CPE Catalog & Events

Realistic Excel training for skill development Shifting from manual inputs to automated formulas in Excel can help enhance data efficiency. Understanding that Excel can handle date and text values broadens the potential to improve efficiency when managing data in Excel. This webcast will focus on the following essential functions: EOMONTH MONTH and YEAR DATE CONCAT SUMIFS with CONCAT Practical hands-on Excel learning exercises taught by a highly engaging expert In this webcast, you'll develop your skills and implement Excel techniques that will boost the effectiveness of conditional summing functions using comparison operators. Additionally, you'll gain in-depth knowledge of the following: Adding helper columns Distinguishing key function differences Combining values *Session 7 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 [Session 8: Dynamic headers, mapping tables and error check] (https://www.aicpa-cima.com/cpe-learning/webcast/excel-for-accounting-professionals-session-8--dynamic-headers-mapping-tables-and-error-check) to further prepare to tackle real-world issues and build powerful workbooks.*

The mad scramble to remote work and utilize apps like Teams has been trying for most organizations over the past couple of years. With a rush to install and no time to plan, most team members did their best, prioritizing remote meetings as the primary concern. Therefore, as a result, Teams is vastly misunderstood and underutilized in most organizations. Join us in this session to go beyond the remote meetings aspect of Teams and to learn how to optimize efficiency, communication, and workflow with Teams.

Governmental Accounting 101, is a 2 hour webcast that takes the participant of a whirlwind tour of governmental accounting basics, focusing on wetting the participant’s appetite for more.  This session will be the first of a series of webcasts, with each subsequent webcast delving deeper and deeper into the governmental accounting basics. 

This course examines actual fraud circumstances through the lens of potential prevention. We will examine how selected frauds were accomplished and consider what internal controls may have prevented fraudsters' ability to accomplish their nefarious acts.

This program presents a detailed analysis of the self-rental passive activity rules, including forms reporting examples and integrates them with the flow-through entity rules related to self-rental. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

You spent your life building retirement savings.  Now you want to make sure your savings last the rest of your life and perhaps pass some on to the next generation.  Come hear a veteran financial educator talk about money management and planning issues for this phase of your life.  

The Financial Accounting Standards Board (FASB) has issued a new accounting standard for leases. This new standard?ASC Topic 842?replaces the existing ASC Topic 840, changes the accounting for operating leases (requiring capitalization in the financial statements), and upgrades many other lease accounting and reporting aspects.

This course is designed to provide a deep dive into purchase accounting, also known as business combination accounting or the "acquisition method" of accounting for business combinations. You'll become familiar with ASC 805, Business Combinations and recent Codification updates impacting purchase accounting. We'll discuss the key analysis points, including the definition of a business and identify which transactions require the application of business combination accounting. The course covers common difficulties, including joint ventures and non-controlling interests, determining the acquisition date, valuation allowances and most balance sheet categories, including intangibles, inventory and deferred income taxes. Be sure to register for both courses in this series: Mergers & Acquisitions Part 1: The Accountant's Role Mergers & Acquisitions Part 2: Financial Accounting

Stay informed and prepared with this comprehensive annual update on the latest developments in accounting and auditing. We'll begin with a deep dive into the Accounting Standards Updates (ASUs) effective in 2025, followed by insights from the FAF's 2024 PCC Review and an overview of FASB's Invitation to Comment - Agenda Consultation, which will shape the future of accounting standards. On the auditing side, we'll tackle the essential changes in quality management standards that firms must implement by the end of 2025. The session will also highlight common deficiencies identified by the DOL in EBP (Employee Benefit Plan) engagements and provide a peek at upcoming projects from the Auditing Standards Board (ASB). Join us to gain practical insights and actionable takeaways to navigate these updates with confidence. Finally, we will close the course by exploring the audit technology adoption process to help transform resistance into resilience as the industry embraces new technologies. We will learn how to overcome common barriers to deliver a successful implementation. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Do you understand the root cause for many professional and personal goals not being achieved? The SMART acronym is valuable in setting goals but insufficient for achieving them. You need two types of goals to boost your chances of success. Outcome goals focus on the results you want to attain. Process goals identify the action steps required to accomplish those desired outcomes. This session explores the essence of both types of goals, and practical examples and tips for the execution of your goals.

This session explores the nature of analytical procedures, with significant emphasis placed upon professional standards involving the use of analytical procedures in audit and review engagements. Practical examples to illustrate the application process will also be given.

The AICPA issued the new Quality Management Standards as a part of its overall quality improvement initiative.  This course will highlight the foundational principles within the new approach that everyone in the CPA firm should know. 

This course provides a concise overview of artificial intelligence and its transformative impact on the accounting profession. As we move into 2025, AI technologies are reshaping traditional accounting tasks while creating new opportunities for strategic advisory services. Participants will explore how AI differs from traditional software, understand various AI applications in accounting, and develop strategies to leverage these technologies while maintaining the essential human elements that clients value most. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This seminar provides a comprehensive overview of Schedule K-1, which taxpayers may receive from pass-through entities such as Partnerships, Subchapter S Corporations, or Estates/Trusts. The course will cover the most common characteristics of Schedule K-1, including how to report the information on Form 1040. Attendees will also learn about the Qualified Business Income (QBI) Deduction and its reporting criteria. Additionally, relevant topics such as basis and loss limitations, material participation, and integration with the QBI deduction will be addressed, along with a discussion of proposed changes to Schedules K-2 and K-3. *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

The COVID pandemic changed the way many people worked, yet others have had remote teams for decades and little changed.  Many organizations trying to bring people back to the office have experienced significant turnover.  Some practices have changed forever while some principles will always remain the same.  Keeping your people happy equals keeping your best people.  Learn the changes you should make now and the things you should do forever!

Would you like to find important documents in 10 seconds or less? Would you like to ensure your digital information is safe and secure? Would you like to improve workflow efficiency? Of course, you would, and with some planning and guidance, you will realize these and other benefits of a paperless office. Naturally, no one expects a fully “paperless” office, but reducing the amount of paper we shuffle can offer tremendous rewards. This course will teach you the best practices and proven processes for effective document management. Participating in this program will teach you how to implement simple, inexpensive document management systems at an individual, workgroup, or small business level. You will also learn about sophisticated and comprehensive document management systems appropriate for larger offices and organizations, including systems with automated workflow processing. Your instructor will guide you through issues such as digitizing paper files, exporting and importing data from specialized applications into a document management system, essential hardware and software considerations, and the policies necessary to facilitate a successful office. Upon completing this course, you will have a comprehensive understanding of your options and a clear direction for implementing your version of a Paperless Office.

Award winning discussion leader Mark Hugh discusses both nexus basics and new developments in the dynamic, ever changing world of state income and sales tax nexus. This valuable course answers your frequently asked questions, reviews key factors in examining potential nexus consequences, takes a tour through the rules in states comprising 50% of the US, and identifies free, online multistate resources.  *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

Cover the basic requirements for performing preparation, compilation, and review engagements under Statements on Standards for Accounting and Review Services (SSARS), including the new SSARS No. 25, Materiality in a Review of Financial Statements and Adverse Conclusions. Review common issues found on SSARS engagements in connection with peer reviews and the impact of various findings on the results of a peer review. Identify key issues to consider during SSARS engagements, and determine how to incorporate quality control recommendations and tips for performing high-quality SSARS engagements. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event

How does a forensic accountant calculate financial losses? Federal courts have approved various ways to calculate losses ranging from net worth method of proof to the expenditures method. Each method of proof depends on the available facts to the forensic accountant. This presentation will focus on the various court approved methods of proof, when to use them, and how to calculate the total loss. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Have you ever met an accountant who exhibits solid technical prowess but possesses lackluster communication skills? It is not unusual to meet a savvy accountant who is a technical expert, but could enhance the delivery of written and spoken words. This course is designed to help CPAs improve their written and verbal communication skills. Participants will learn how to tailor communication to their audience, with particular emphasis on techniques for crafting a message that effectively conveys technical information in an engaging manner. The course's author will share personal success tips gleaned from more than two decades of experience communicating myriad topics to a variety of audiences.