CPE Catalog & Events

This intensive two-hour course addresses the critical need for accuracy and efficiency when developing spreadsheets using Microsoft Excel. Recognizing that even minor errors can have significant implications, this course delves deep into strategies and skills required to detect and correct errors in Excel. By the end of this course, participants will have a comprehensive understanding of how to efficiently identify and correct errors in Excel spreadsheets, enhancing their overall productivity and accuracy in their professional roles. 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 refresh your understanding of the critical importance of risk assessment in the audit practice. We'll briefly discuss the impact of AICPA's Clarity Project for audits and the need to update firm processes to incorporate the risk assessment standards. Participants may alternatively need to fine-tune an implementation of the risk assessment standards. These standards are designed to eliminate the connect-the-dots methodology of checklist auditing and add critical thinking back into the audit process. They remain a problem area for many firms, resulting in engagement and peer review deficiencies. This course has been updated to include a more in-depth discussion of SAS No. 145, Understanding the Entity and Its Environment and Assessing the Risks of Material Misstatement. We will break down this complex and misunderstood subject with an easy-to-understand approach.

It's essential to stay current on Form 5500 filing rules and requirements. Get a practical review of Form 5500, including 5500SF and 5500EZ. We'll discuss the changes for 2025 and how different government agencies use the form to target enforcement efforts. We'll review the related schedules, how to report late contributions, and what to do if your clients miss a filing deadline.

Revenue involves significant risks that warrant special consideration during audits. The Financial Accounting Standards Board (FASB) has issued a new standard—"Revenue from Contracts with Customers" that replaces most industry-specific revenue recognition requirements in US GAAP. A new principles-based, five-step revenue recognition model now applies. Recent disclosures of qualitative and quantitative information, significant judgments, and changes in judgments are also required. New systems, processes, and controls may be needed. Poor design or implementation may pose heightened risks of material misstatement, including those due to fraud.

Seniors face issues that complicate return preparation and planning. For example, when should they apply for social security" How is it taxed" What if they continue to work" Will an increased standard deduction affect charitable planning" What about downsizing" How can they help children or grandchildren pay for a home or a college education" This course will help you advise your clients on these topics and more.

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. Also, we'll discuss the difference between public and private company requirements.

Participants will go over the changes on preparation, compilation and review engagements using SSARS rules, followed by a general overview of how to perform these services. This interactive workshop is designed for practitioners in small and medium-sized CPA firms and will include a lecture with generous time for questions and case studies.

Many business professionals consider PivotTables the most powerful feature in Excel, yet most accounting and financial professionals do not use them in their day-to-day activities. If you are ready to learn how to take advantage of PivotTables or extend your existing knowledge, then this course is for you! In this dynamic and engaging session, you'll master how to: •    Build PivotTables from scratch •    Group data inside PivotTables, including options for fiscal periods •    Create user-defined calculations in your PivotTables We start with the fundamentals and quickly move to advanced techniques, including: •    Building PivotTables that consolidate data from multiple ranges •    Connecting PivotTables dynamically to external databases and financial accounting systems •    Leveraging other Excel features associated with PivotTables, such as Slicers, Power Query, and Power Pivot This seminar is a must for anyone eager to enhance their Excel skills and transform their workflow. With guidance and coaching from your K2 instructor, you'll be ready to use PivotTables to analyze and report on extensive data sets in a fraction of the time you spend completing such tasks.

Cybersecurity protection is one of the most important responsibilities of every CPA professional to protect the confidentiality of sensitive client information. While there are many aspects of cybersecurity that need to be addressed, the biggest vulnerability to protect against is unauthorized access to your application login credentials. Once your login credentials are breached, the cybercriminal essentially has the keys to your data kingdom. John Higgins, a national leader in the CPA technology, will demonstrate the ease with which you can protect all of your login credentials with maximum security with minimal expense. You will leave this course prepared to deploy this state of the art security tool in your organization. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Master the essential skills to build a high-performing team with our online course on interviewing, onboarding, and training. This comprehensive program dives into proven best practices for identifying top talent, creating a seamless onboarding experience, and fostering a culture of continuous development. Whether you’re a seasoned manager or new to hiring, this course equips you with the tools to make confident decisions, engage new hires effectively, and set your team up for success from day one.

This session will address the complex rules of retirement distributions, review key provisions of the SECURE Act 2.0, and provide practical strategies of maximizing tax benefits for your client. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

According to the FBI, “white-collar crime is … synonymous with the full range of frauds committed by business and government professionals … characterized by deceit, concealment, or violation of trust …. The motivation behind these crimes is financial—to obtain or avoid losing money, property, or services or to secure a personal or business advantage.”  CPAs can and should play a crucial role in preventing and detecting white-collar crime, as well as in prosecuting the perpetrators.  This session will explore whether we are up to this challenge, heighten awareness regarding the CPA’s role as a front-line defender of the public interest, and assess whether we are deserving of the public trust we enjoy.

This course provides a focused and practical overview of the Generation Skipping Transfer (GST) Tax, designed specifically for professionals involved in estate and gift tax planning. As Part 4 of the Form 706 and 709 series, this session zeroes in on the rules, definitions, and application of GST tax, including the mechanics of calculating the inclusion ratio and how the GST exemption operates in real-world planning scenarios. Participants will gain clarity on how to identify skip persons, the types of transfers subject to the GST tax, and the proper treatment of direct skips, taxable terminations, and taxable distributions. Through clear examples and practical instruction, this course walks participants through voluntary, timely, late, and retroactive GST exemption allocations. With increasing regulatory complexity and heightened exemption limits, understanding the GST tax is critical for practitioners assisting clients in multigenerational wealth transfers. This course supports more accurate return preparation and strategic allocation of exemptions to minimize tax exposure. *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 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

This two-hour course covers the IRS collection process, detailing each step from the initial notice to enforced collection actions and payment options. You'll gain a thorough understanding of how the IRS initiates collections, what taxpayers should expect as the process unfolds, and the various options for settling debts. We will review when Form 433-A or 433-B is required, and discuss the specific criteria for submitting an Offer in Compromise (OIC) to settle tax debt for less than the full amount owed. This session is designed to provide tax professionals with the tools to guide their clients through the IRS collection process, ensuring compliance and presenting the best possible payment solutions. We’ll also review key scenarios where Forms 433 and OIC are necessary, providing practical insight for resolving tax liabilities.   *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  

This course provides a focused analysis of the individual and small business provisions in Pub. L. 119-21 (H.R.1), "One Big Beautiful Bill." Tailored for tax professionals working with Form 1040 filers, the course explores impactful updates, from the no-tax-on-tips provision to enhanced bonus depreciation. Designed to inform planning strategies and compliance for the 2025 tax year and beyond. Participants will gain actionable insight into newly proposed deductions and expanded credits. 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 equips financial and information technology auditors with an understanding of cybersecurity risks and their impact on financial reporting as well as cybersecurity best practices. Participants will learn to identify threats, evaluate controls, and assess risk using recognized frameworks, with a focus on audit implications.

People skills are the most significant skills that professionals need to develop and yet are often the last skills perfected. This course will help participants understand personality types and the successful interactions with clients, peers and family. In addition, participants will learn Neuro-linguistic programming and develop the ability to better understand nonverbal language, which is key to communication. Participants will also learn techniques to enhance memory and to improve the ability to recall key facts.

Proper financial accounting for S corporations involves adhering to specific accounting principles and tax regulations designed for this unique business structure.  This course examines the proper financial accounting for S Corporations.

Navigating the complexities of estate and trust administration is a vital skill for professionals, who play an integral role in the administration team. This comprehensive course is designed to equip professionals with a thorough understanding of their responsibilities and the processes involved in estate administration, enhancing their ability to address estate settlement issues effectively. Participants will be provided with a detailed overview of the professional’s role in estate and trust administration, emphasizing practical insights and strategies for managing assets, addressing the legitimacy of debts and creditors, and ensuring the proper distribution of assets. **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.