CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
K2's Mastering Advanced Excel Functions
-
Online
4.00 Credits
With approximately 500 functions now available in Excel, some newer and more powerful tools are easy to overlook. But, if you do that, your productivity will suffer. In this session, you will learn how to take advantage of many of Excel’s more advanced features – some new and some legacy – to elevate your productivity to higher levels. In this session, you will learn about many of Excel’s newer tools, including XLOOKUP, SUMIFS, SWITCH, and STOCKHISTORY. Also included in this session are discussions of advanced financial functions, such as IPMT and PPMT, and how to retrieve summarized data easily using GETPIVOTDATA and CUBEVALUE. Additionally, you will learn how to make sophisticated calculations easier with Dynamic Array formulas, harness the AGGREGATE function's power, and create more accurate forecasts with Excel’s FORECAST.ETS function. No matter your experience working with Excel, participating in this course will help you work more efficiently and effectively in Excel.
Hands-On Tax Return Workshop - Partnerships & LLCs (Form 1065)
-
Online
8.00 Credits
This case-driven training is designed to get the inexperienced accountant up to speed quickly in the most common areas of partnership, limited liability company (LLC) and limited liability partnership (LLP) taxation. A cornerstone of this course is the preparation of the Form 1065 using a fairly complex trial balance common to most partnership, LLP and LLC income tax returns. **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
S Corporation Preparation, Basis Calculations & Distributions - Form 1120S Schedule K & K-1 Analysis
-
Online
8.00 Credits
This comprehensive training is designed to get the accountant up to speed quickly with S corporation formation and preparation issues as well as a complete understanding of calculating a shareholder’s stock and debt basis. The cornerstone of this course is the in-depth line-by-line analysis of the Form 1120S Schedule K and K-1 and how these items affect the shareholder’s Federal individual income tax return. **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
2025 Business Federal Tax Update - Navigating the Current Tax Landscape
-
Online
8.00 Credits
Get ready to elevate your tax game with the Business Tax Update, designed exclusively for tax practitioners looking to sharpen their skills in business income taxation. This course doesn't just scratch the surface – it thoroughly explores the complexities of the tax code, ensuring you're equipped to navigate the ever-evolving tax landscape with confidence. From recent legislative updates to complex tax considerations like COVID-19-related subsidies, this course covers it all. Gain practical strategies and insights that you can immediately apply to assist your clients in optimizing their business income tax planning. Don't miss this opportunity to stay ahead in business taxation and enhance your expertise in a rapidly changing regulatory environment. With a focus on real-world application and comprehensive exploration of essential topics, the Business Tax Update promises to be a game-changer for your tax practice. Whether you're dealing with partnership, corporation, or LLC taxation issues, this course provides precise guidance tailored to diverse business clients. Plus, you'll gain invaluable insights into recent legislative changes, including their implications on tax code sections like Section 199A. Stay at the forefront of business taxation and ensure you're delivering top-notch advice to your clients by enrolling in this essential course today. **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.
Look Lead Love Learn
-
Online
1.50 Credits
Collaborate, connect, innovate and inspire for success (bold) It's a new world for accountants and finance professionals. Ground-breaking shifts in regulation, leadership and technology mean that "business as usual" doesn't cut it anymore. Success now depends on our ability to collaborate, connect, innovate and inspire. For the past decade, Bill Sheridan has used the Maryland Association of CPAs acclaimed blog, CPA Success, to advise us on how to collaborate, connect, innovate and inspire. In doing so, he's learned a valuable lesson along the way: We build better businesses, live better lives and conquer complexity when we master the ability to look, lead, love and learn. Join this webcast to hear more.
How Much Are Your Ethics Worth?
-
Online
2.00 Credits
Ethics are of central importance to the CPA profession. But what do we mean by ethics? Is it just appropriate behavior, compliance with laws, or is it more than that? In this course, we'll discover what sets ethics apart and, therefore, sets the profession apart as well. We'll explore the tools available, the role of bias, and dive into real life case studies. We'll apply the AICPA's ethical framework and detect where bias was involved in the case studies. We'll even discover that one person set the price tag on their ethics at $53.7 million, only to lose it all in the end. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
It Is Legal, But Is It Really Ethical?, featuring Rob Berry and Bob Mims
-
Online
1.00 Credits
This discussion outlines situations where ‘legal’ and ‘ethical’ are not necessarily in alignment. How should you handle these issues? We will detail a better thought process to help you avoid ‘crossing the line.’ Each topic and each day stand on its own. If you are not sure about making a multi-day commitment, sign up for just a single day. We think you will come back for more!
Audit Risk Assessment in Plain English
-
Online
2.00 Credits
Audit Risk Assessment in Plain English, is a 2 hour webcast highlighting the AICPA’s clarified risk assessment standards, along with a new Statement on Auditing Standard (SAS 145) related to understanding the entity, the entity’s environment, the entity’s internal controls, and assessing the risks of material misstatement. This session will attempt to simplify the requirements using common sense examples and language.
Ethical Performance Management
-
Online
2.00 Credits
Today, more than ever, effective performance management is critical to the well-being of an organization, as well as the engagement and satisfaction of staff. Unfortunately, performance management is also often one of the most dreaded responsibilities managers face. This session will provide insight into what performance management is, how to prepare and conduct performance appraisals, how to coach the marginal employee, legal considerations to be aware of when conducting an appraisal, and ways to engage and motivate staff. In addition to providing tools to conduct effective appraisals, we will also look at the ethical implications of employee reviews. When done well, performance management has the power to improve communication between managers and their staff as well as help foster stronger career paths and routes for growth. It can motivate, re-engage, and energize everyone involved. Ethical values such as fairness, accountability, respect, intellectual honesty, and trust will be incorporated into 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.
Mission-Critical Leadership: How Smart Managers Lead Well in All Directions
-
Online
2.00 Credits
Most leadership development focuses on a single direction within the organizational hierarchy: downstream to subordinates. While it is important to be a good boss, leadership is much more than that. The best leaders learn to lead well in all directions. They lead upward to superiors and across among peers throughout the organization. And it all starts with self-leadership. This often overlooked or misunderstood leadership principle is essential to build a thriving and productive culture. This topic is based on Jon’s book, Mission-Critical Leadership: How Smart Managers Lead Well in All Directions.
Contract and Procurement Fraud
-
Online
2.00 Credits
This session will focus on the most common types of fraud in the procurement and contracting arena, with a focus on fraud in construction. The session will examine fraud vulnerabilities in the four key phases of the procurement process: Presolicitation. Negotiation. Performance. Closeout and Claims. Within each phase, “red flags” will be discussed. These are the indicia of possible fraud that managers should be alert for. Also, within each phase, the most common fraud schemes will be highlighted and discussed. Finally, the session will describe the generally accepted safeguards or controls that should be established to prevent the various fraud schemes that can occur. This part of the program will make extensive use of actual fraud case studies designed to demonstrate fraud risks and fraud detection strategies.
Global Internal Audit Standards (GIAS) Domain IV - Part 1
-
Online
2.40 Credits
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
Financial & Tax Accounting for S Corporations
-
Online
4.00 Credits
This program addresses the many complex financial and tax accounting issues that are common in S corporation transactions, with discussion of common pitfalls and the AICPA "small" GAAP accounting standards. This course does not qualify for IRS credit.
2024 Revision to Government Auditing Standards Impact
-
Online
4.00 Credits
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.
Invest in Your Mental Health and Avoid Burnout
-
Online
2.00 Credits
For the ambitious female finance professional, working hard and going above and beyond are necessary for success. Sadly, taking time to care for themselves can be seen as counter-productive to meeting their career goals. Over ninety percent of women executives are feeling significantly higher levels of stress that they attribute to increased responsibilities and priorities outside the workplace compared to life before the pandemic. Burnout is a syndrome resulting from chronic workplace stress that causes exhaustion, negativity toward one's job and reduced professional efficacy. It has become so pervasive that it's now recognized as an occupational phenomenon by the World Health Organization. To reignite your enthusiasm at work, you don't necessarily need to find a new job or time for a spa day or bubble bath. You need concrete strategies to invest in your mental health without compromising your ability to rise to the next level in your career. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Asset Misappropriation - Let Me Count the Ways
-
Online
2.00 Credits
As discussed in the Association of Certified Fraud Examiners’ Occupational Fraud 2022: A Report to the Nations, 86% of all frauds are misappropriation of assets. Why is the misappropriation of assets so large? Because there as so many of them it creates many, many opportunities. And the asset which is stolen the most? CASH! Because it’s easy to conceal and you don’t have to convert it. During this presentation, the many, many different ways to misappropriate (steal) assets and which assets (besides cash) are most subject to misappropriation are discussed as well as how to recognize such and more importantly, how easy it is to prevent it!
Current Fraud Trends - Nonprofit and Government Entities
-
Online
2.00 Credits
Nonprofit entities and governmental entities have a high degree of public accountability. This course will examine the most common fraud schemes and provide multiple examples of how to prevent or detect these schemes.
Integrate ChatGPT into Your Client Advisory Services-Updated
-
Online
2.00 Credits
Two of the hottest topics in the CPA profession today are CAS (client advisory services) and ChatGPT. This course will explain how to bring these two worlds together by integrating ChatGPT and other generative AI applications into your client advisory services. John Higgins, a leading advisor to the profession on ChatGPT and a seasoned client advisor on technology based solutions, will show you how you can position your firm and yourself as a "go to" advisor on how to embrace this technology in virtually any type of business. John will address how to use this technology as a research and writing assistant in your client services and how to advise your clients on this revolutionary technology and all benefits and "gotchas" that come with it. If you want to step up your advisory game, this course is a "must take." This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Surgent's Lessons Learned from Successful Companies
-
Online
2.00 Credits
Why do some companies fail while others grow and succeed for generations? Common perceptions often attribute organizational success to great leadership, timing, or unique ideas. Although these traits certainly play a role in helping companies grow, research shows that corporate success often hinges on whether a company is value driven. Such companies have core ideologies that drive almost every major decision. In this course, we look at empirical data on why some companies succeed while others fail. By looking at companies that were created prior to 1950 (e.g., Disney, Marriott, or 3M), we can understand why certain organizations have been able to grow and achieve exceptional success through many different eras in the American economy. The lessons learned from these visionary companies can be broadly applied to organizations of all sizes, including accounting and financial service firms.
Taxation of Judgements and Settlements
-
Online
2.40 Credits
In the course of legal actions, payments may be made pursuant to a final disposition of a court case or a mutually agreed-upon settlement. This course will cover the tax implications for payments made for personal injury, emotional distress, lost wages, punitive awards, pre- and post-judgement interest, contract claims, among other damages. **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.