CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Advanced Excel: Hidden Secrets and Gems
-
Online
2.00 Credits
This course dives into the powerful, but potentially under-utilized, capabilities of Microsoft Excel. Designed for sophisticated users willing to approach spreadsheets from a unique perspective, this program encourages users to challenge the status quo by considering opportunities to take acceptable spreadsheets to a new level. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Relationship Networking: The Art Of Conversation
-
Online
1.00 Credits
In the fast moving world where everyone is communicating through email, text and instant messaging we have forgotten the power of face-to-face conversation. Communication and connection is the foundation for building a thriving network and business. During this talk, The Connector’s Advantage author, Michelle Tillis Lederman will inspire you to leverage the power of personal connection in the digital age while still incorporating the efficiency of virtual communication.
Aligning Analytics to COSO's Fraud Risk Management Principles
-
Online
1.00 Credits
In this course, participants will learn about the five principals of COSO's Fraud Risk Management Guide and the linkages each principal has to the use of forensic data analytics to measurably demonstrate effectiveness and ROI. We will also explore key elements to a successful program that is sustainable as well as pitfalls to avoid. Finally, we will cover several case studies that demonstrate the key concepts discussed.
K2's Accounting Solutions And Add-Ons For Small Businesses
-
Online
2.00 Credits
Working with a small business, you know that keeping the company's finances in order is critical to success. While numerous software programs and tools are available to help you do this, they vary substantially in many significant aspects. In addition to conventional options like QuickBooks and Sage 50, you can choose from Cloud-based tools such as Zoho Books, QuickBooks Online, Spire Systems, Xero, Accounting Suite, Accounting Power, and many more. In this session, we'll look at the best accounting tools for small businesses and discuss the benefits of each one. This session covers accounting solutions that should work for startups and companies with up to $10 million in annual revenue. We also cover various add-on solutions that can enhance the overall functionality of your accounting platform. Join us to learn your options for achieving your small business management financial goals.
K2's Optimizing Your Tech Stack For Efficiency And Cost-Effectiveness
-
Online
2.00 Credits
In the ever-evolving landscape of business technology, it is about having the right tools and optimizing for efficiency and cost- effectiveness. K2's Optimizing Your Tech Stack for Efficiency and Cost-Effectiveness is designed for professionals seeking to balance functionality with financial prudence. This session delves into strategies for streamlining your technology stack without sacrificing performance. We will guide you through assessing your current tech tools, identifying redundancies, and exploring less expensive yet effective alternatives. You will learn techniques to evaluate the total cost of ownership of tech tools and make informed decisions to avoid overspending. This course is necessary for professionals seeking the most value from their technology investments.
Employees Today and Tomorrow : Are Employees Assets?
-
Online
2.00 Credits
As the managers' role continue to evolve, it is crucial for us to understand the strategic aspects of managing a diverse workforce, beginning with understanding the big trends in employee demographics. We begin with a rhetorical question - asking if employees are assets? GAAP tells us they are not, so discussion will revolve around whether this treatment delivers an unhealthy bias on our view of the people in our organization. What do the most successful organizations believe and why? If you have an opinion as to whether employees are an asset or not, this is a fun session intended to be interactive with participation either live, virtual or both.
K2's Office Scripts - The New Macros
-
Online
2.00 Credits
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.
Taxation of Non-fungible Tokens (NFTs)
-
Online
2.00 Credits
Non-fungible Tokens (NFTs), unique, identifiable digital assets based on blockchain technologies, have become a fast-growing industry. This course will provide a background on how NFTs came into the mainstream marketplace. These materials will assist the practitioner to understand the tax implications of the creation, purchase and sale of these 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.
Clean, Transform & Load Data in Power BI
-
Online
2.00 Credits
This intensive 2-hour course is designed specifically for those aiming to master data management skills in the modern business environment. As data becomes increasingly central to accounting and financial analysis, the ability to effectively manage, clean, and transform this data is critical. This course delves into Microsoft Power Query, a potent tool within Excel and Power BI Desktop, known for its robust data processing capabilities. This course is designed to take participants from the basics of Power Query to exploring its more sophisticated features. It is an ideal blend of theoretical knowledge and practical application, centered around diverse data scenarios encountered in multiple industries. The aim is to ensure that the skills and techniques learned are universally applicable and beneficial in any professional context. Structured to be participant-focused, the course encourages active learning through a series of practical exercises, live demonstrations, and illustrative case studies. This approach not only deepens the understanding of Power Query's features but also demonstrates how to turn complex data sets into actionable insights. While the course is broad in its application, it remains detailed in its instruction, catering to both the novice and the seasoned professional. It is particularly beneficial for those who regularly interact with data, such as business analysts, project managers, and financial professionals, providing them with the tools to streamline data processes and enhance data analysis capabilities. Additionally, the course underscores best practices in data management. Participants will learn strategic approaches to data challenges, ensuring that their data processes are efficient, scalable, and sustainable. This is not just a course about mastering a tool; it's about empowering professionals with the skills to transform data into a strategic business resource. By the end of the course, participants will be equipped to leverage Power Query in Excel or Power BI desktop to its full potential, turning data into a powerful driver for business success and innovation. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Communicate Financial Concepts to Non-Accountants
-
Online
2.00 Credits
Do you ever get blank looks when you present your company's financial statements? Does your board nod knowingly, during your presentation, but never seem to have any meaningful questions? It could be that they have no idea what you are talking about and are just pretending to understand! Learn how to connect with your CEO, board, fellow managers, and ordinary employees so they understand your message.
Key Tax Issues for Business Taxpayers
-
Online
2.00 Credits
This course will address the most recent tax legislation, IRS guidance and developments occurring in 2024-25 that will impact business taxpayers. Designed to prepare the practitioner for the upcoming filing season, this course will provide useful strategies to assist in the tax preparation process. **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.
Mergers & Acquisitions: Tips and Speed Bumps to Avoid
-
Online
2.00 Credits
Mergers, acquisitions and alliances have been and continue to be major avenues to organizational growth and increased competitive advantage. Despite the great initial promise of many mergers and alliances, few seem to yield the anticipated results. Numerous studies indicate that between 55% and 77% of mergers fail to accomplish their intended purpose. This course helps financial professionals, and their advisors identify, execute, and consummate mergers and acquisitions that create shareholder value while avoiding the many traps that can cause post-acquisition failure.
Surgent's Comparing and Contrasting Retirement Plans for Small- and Medium-Sized Businesses
-
Online
2.00 Credits
Clients often ask their tax advisors whether they have the "best" pension plan and whether they are using it to its maximum advantage. This program explains how various pension plans work and analyzes why a small or medium-sized business owner would choose one plan over another.This course qualifies for IRS credit.
Surgent's Understanding Partnership Taxation: Debt Allocations
-
Online
2.00 Credits
How debt is allocated to the partners in a partnership is important. It dictates how much money may be taken tax-free as a distribution, the losses that flow down to the partners, and the gain or loss on the sale of a partnership interest. However, the allocation of debt can differ depending on the type of debt it is and the type of partner we are talking about. Furthermore, 704(c) can complicate things. And what in the world is a constructive liquidation scenario? In this course, we will tackle the concept of debt allocations - how you do it, what it means, and why you do it.This course qualifies for IRS credit.
Critical "Soft" Skills for CFOs and Controllers
-
Online
4.00 Credits
Accounting and finance managers and executives must demonstrate sound soft skills necessary for personal growth and organizational success. This course will provide insights into the most crtical personal skills critical for CFOs and Controllers - or those that want to be!
Corporate Ethics Cases: Discuss Real Life Conflicts
-
Online
4.00 Credits
If you have ever had someone just read you the rules in an ethics class, you know there is a better way. Cases in Corporate Ethics reviews 8 real life cases and puts you in the position of someone in the middle of it all. You'll learn about conflicts that corporate financial professionals often encounter, you'll gain skills for dealing with a boss who is behaving badly and find out where to go for help. Once you have studied ethics using real world cases, you'll never want to do it any other way.
Forensic Accounting: Crafting Expert Reports
-
Online
4.00 Credits
When forensic accountants are hired to conduct an analysis and investigations, they are commonly expected to write a report. This report can be short or long, depending on the circumstances. This presentation is how to write an effective expert report that will withstand scrutiny of both parties of litigation and the court. The presentation will also include best practices, ethics, and components of an effective report. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
ACPEN Signature 2025-2026: Business Fraud Update and Managing the Risk of Fraud
-
Online
8.00 Credits
Fraud has not been conquered. Although most organizations like to think, “it can’t happen to us,” the fact of the matter is that fraud can happen to any organization and its impact can be catastrophic. Accountability professionals are the first line of defense against fraud. When fraud happens, management always turns to the accountability professional and either says (a) “this must be your fault,” or (b) “you were right; you warned us; help us make sure this cannot happen again.” Consequently, accountants, internal auditors, external auditors, fraud examiners, and risk management professionals need to develop the skills needed to prevent, detect, and deter fraud and need to be proactive in promoting and effecting organizational change. According to the Association of Certified Fraud Examiners’ (ACFE) 2024 Report to the Nations: The median loss per fraud case is $145,000; the average loss per fraud case is $1.7 million. 43% of frauds are discovered by tips, usually from employees. Asset misappropriation schemes are the most common (89%) but least costly ($120,000 median loss). Financial statement fraud schemes are the least common (5%) but most costly ($766,000 median loss). Corruption is the most common scheme in all global regions. Median losses for frauds by owners/executives ($459,000) were more than 7X GREATER than those carried out by employees ($60,000). 84% of fraudsters exhibited at least one behavioral red flag. Organizations that have implemented anti-fraud measures suffer significantly lower losses and find fraud much more quickly. These conclusions are alarming and should be a wake-up call for all business and government professionals. The impact of fraud is always devastating and can be catastrophic. The 2025 Business Fraud Update is another fast-moving seminar that will provide a comprehensive look at the latest developments about fraud from the technical, legal, and operational perspectives and update participants on the most recent legal and regulatory developments in this important area of professional responsibility. In addition, our panel of legal, accountability, and forensic experts will explain key steps and methods in conducting a successful fraud investigation: Establishing predicate for an investigation Gathering and preserving evidence Conducting interviews and obtaining confessions When to involve law enforcement professionals and regulators The CPA's Role Preparing an expert report Providing expert testimony Implementing corrective action plans
S Corporations: Tax Compliance, Elections, and Best Practices
-
Online
8.00 Credits
This comprehensive course covers the most common aspects and tax implications of S Corporations, providing a deep dive into their structure, tax treatment, and compliance requirements. Participants will learn the mechanics of electing Subchapter S status, with discussions on Form 2553 and relief options for late filings. The course also explores the application of Rev. Proc. 2022-19 and Rev. Proc. 2023-3, analyzing their differences and implications under I.R.C. §1361 and §1362. Key topics include corporate formalities, shareholder stock and debt basis, and highlights of Form 1120S and its schedules (K-1, K-2, and K-3). Additionally, participants will gain insights into officer reasonable compensation requirements, audit strategies, and corrective measures for eligibility errors. *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 Best S Corporation, Limited Liability, and Partnership Update Course by Surgent
-
Online
8.00 Credits
This year practitioners need to keep abreast of tax changes affecting pass-through entities used by their business clients and employers, and this enlightening course delivers that information. You will learn invaluable strategies, techniques, innovative tax-planning concepts, income-generating ideas, and other planning opportunities available to S corporations, partnerships, LLCs, and LLPs. In addition, this course will discuss current trends and emerging issues, helping practitioners stay informed about relevant and significant topics that may impact their clients. Continually updated to reflect enacted legislation.