CPE Catalog & Events

This intensive 2-hour course is designed to unlock the potential of array formulas in Microsoft Excel. Array formulas are a vital tool in Excel for their unique ability to perform multiple calculations on one or more items within an array, making them indispensable for complex data analysis and calculations. They enable users to write fewer, more powerful formulas, leading to cleaner and more efficient spreadsheets. This course is tailored to enhance your data analysis and spreadsheet management skills by delving into the advanced aspects of array functions. Through a combination of theoretical knowledge and practical exercises, you will learn to streamline your work and improve efficiency in Excel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

SSARS #21 codified and clarified all previous SSARS standards and was effective for financial statements ending on or after December 15, 2015. It revised existing standards, upgraded service requirements, and introduced a new level of service ? the ?Preparation Engagement.? SSARS #21 requires numerous practice issues for the various service levels, including confirming the services to be provided to the client, attest vs. non-attest services, required procedures to be performed and documentation of them, and reporting requirements for each level of service. SSARS #21 also addresses specific issues overlooked in the original standard. Updates to SAS #21 are also provided and discussed.

A deeper dive into Cybersecurity topics specific to CPAs and Fintech Organizations, expanding on the fundamentals from Cybersecurity 101 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 considered a tax audit from the perspective of an IRS examiner? This session explains how you can use IRS Audit Technique Guides (ATGs) to enhance tax compliance. You will obtain a glimpse of the audit process from the viewpoint of an IRS agent as we explore insights that the IRS provides to its own examiners. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Technical expertise may get you in the door—but emotional intelligence (EQ) is what builds trust, earns loyalty, and sustains lasting success. For CPAs, attorneys, financial professionals, bankers, and insurance agents, your ability to navigate emotions—your own and others'—is often the difference between a good client interaction and a great one, between a team that functions and a team that thrives. This interactive course goes beyond theory and dives into real-world application. You’ll uncover what emotional intelligence really is, why it matters more than ever in today’s professional world, and how to strengthen your EQ to improve performance, strengthen relationships, and manage stress with confidence. You’ll walk away with tools you can use immediately to transform how you lead meetings, manage conflict, build client trust, and drive results—while also enriching your personal life. Whether you're looking to become a better leader, communicate with more clarity, or create meaningful client connections, this course gives you the insight and strategies to make it happen.  

This seminar will introduce the process from filing a tax return to the IRS audit, IRS Appeals, Collections and litigation at courts of original jurisdiction.  We will discuss the options taxpayers have at any point in the process with reference to real-life stories from the trenches.  **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.  

Over the next decade, the area of “Advisory Services” has the greatest potential for growth in your practice.  Complexities within your clients’ financial, estate, and asset protection plans coupled with the ever-changing Internal Revenue Code has created an opportunity for the CPA, the EA, and other advisors to expand their client offerings. This course provides the practitioner with the framework for practice expansion as well as an understanding of a variety of necessary issues and techniques.  

This course equips tax professionals with the knowledge and strategies needed to handle the most common IRS letters, including general notices, audit requests, collections, return inquiries, and error notices. Participants will learn how to interpret IRS correspondence, adhere to response deadlines, and effectively communicate with the IRS to resolve issues and minimize risks. The session also highlights best practices for ensuring compliance and avoiding penalties or escalation, empowering attendees to navigate IRS correspondence with confidence. *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 provides an overview of the key aspects and tax implications of S Corporations. Participants will learn the mechanics of electing Subchapter S status, compare S Corporations to other entity structures, and explore compliance requirements such as corporate formalities. Highlights include a detailed discussion of Form 1120S, accountable plans, taxable fringe benefits, officer reasonable compensation, and IRS audit strategies. The course also covers Schedules K-1, K-2, and K-3, as well as the concept of effectively connected income. Practitioners will gain practical insights into advisory services and strategies for representing clients before the IRS. *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 Accountant role is evolving from data aggregation to knowledge extraction, with a significant emphasis on understanding and leveraging technological advancements. In this era of rapid digital transformation, it is crucial for accountants to grasp the shift towards more analytical roles, learn the tools, and integrate Business Intelligence (BI) and Data Analytics (DA) in their organization and daily practices. This course will focus on raising the accountant's awareness of BI and DA practices, the impact of AI technologies like ChatGPT, and how these can benefit their organization. By embracing these technologies, accountants can enhance their value proposition by transitioning from traditional accounting roles to becoming strategic advisors and decision-makers.

This course covers recently issued standards from the AICPA Auditing Standards Board and AICPA Accounting and Review Services Committee including the new Quality Management Standards. The session will highlight projects in progress at the Public Company Accounting Oversight Board, and International Auditing and Assurance Standards Board. The course will also recap recent changes and present common peer review findings and best practices to improve practice quality. 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 empowers accountants with the knowledge and skills needed to strategically implement generative AI within their firms, positioning them at the forefront of innovation and operational efficiency. As generative AI platforms like ChatGPT, Claude, and Gemini transform business practices, accountants will learn to harness these tools to drive value, streamline processes, and enhance decision-making. Through examination of the current AI landscape, practical frameworks, and real-world applications, participants will learn how to leverage AI technologies to enhance accounting operations while maintaining professional standards and ethical considerations. The course emphasizes a balanced approach to AI adoption that focuses on augmenting human capabilities rather than replacement. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Technology adoption often comes with resistance, but it's possible to transform this challenge into an opportunity for growth. This course explores the journey from resistance to resilience in embracing new technologies, focusing on overcoming barriers and ensuring successful implementation. Participants will examine cutting-edge audit technologies, including AI, data analytics, and automation, and learn how to align these innovations with both organizational and personal goals. Through case studies, insights into the Technology Acceptance Model (TAM), and practical discussions, participants will gain the tools and strategies to foster acceptance, driving seamless integration of new technology into both individual tasks and team workflows.

Cloud computing has become a source of cyber-crime. “Cloud forensics is the application of digital forensics in cloud computing as a subset of network forensics to gather and preserve evidence in a way that is suitable for presentation in a court of law.” Cloud forensics is a combination of the varied types of accounting forensics including: •    Digital forensics •    Network forensics. •    Hardware forensics In cloud crime, the cloud is considered the object when the target of the crime is the cloud service provider they are directly affected by the act. It is considered the subject of the crime when the criminal act is committed within the cloud environment. It is considered the tool when it is used to plan or conduct a crime. This course will delve into the many concepts involved in cloud forensics. The course complements other courses in the series of Becoming a Forensic Accountant.  

Financial forecasting is an important part of any successful business. It enables businesses to plan for the future and anticipate scenarios based on strategy. The controller helps forecast financials by calculating future revenue and income streams. In recent years, corporate finance has undergone many dramatic changes due to the growth of a number of high-tech tools. The responsibilities/competencies of the Financial Controller position (FC) has changed in recent years To maximize performance, Controllers must be aware of how the FC position is changing, and how they must adjust to these changes. There are many types and methods of financial forecasting. This course will review the most prevalent forecasts and relative methods being used.

Office Scripts is a new feature that allows you to automate tasks in Excel and other Office applications. Unlike VBA, a legacy language that runs only on Windows, Office Scripts can run on any platform and device that supports Office on the web. Further, Office Scripts has a modern and intuitive interface that lets you easily create, edit, and share your scripts. Office Scripts are stored in the Cloud, and they work with Office Online apps and integrate with Power Automate for process automation. Save time and improve productivity using Office Scripts in Excel and other Office applications.

Freelance work and other non-permanent employment arrangements are becoming increasingly popular ways for people to earn a living. Although these non-traditional activities offer novel, flexible ways to earn income from diverse sources, they also introduce nuanced recordkeeping, reporting, and attestation issues. We investigate characteristics of the gig economy, employee-versus-contractor considerations, bookkeeping, regulatory compliance, and external reporting considerations. We also explore best practices for CPAs who fulfill the role of trusted advisor for gig economy clients.

Loans, rental agreements, business combinations - what do these all have in common? They all have the potential of creating a related party transaction. This program presents a detailed analysis of the financial accounting rules for transactions with related parties, as well as compares and contrasts those rules with the AICPA financial reporting framework for small and medium-sized entities. This course does not qualify for IRS credit.

This program reviews the statutory and regulatory guidance as they relate to fringe benefits. There will be an emphasis on entertainment, meals and business transportation expenses, including qualified employer-provided parking, with a focus on planning opportunities. Recent federal tax legislation, cases and rulings will also be addressed. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Although they are the most common entities for small and mid-sized business, financial (book) accounting for partnerships and LLCs are rarely discussed.  This course examines the proper financial accounting for these tax-driven entities.