CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Business Intelligence (BI) and Business Analytics (BA)
-
Online
2.00 Credits
Volatility and complexity are the new normal. Most organizations are drowning in data, but starving for information. The finance and accounting function has the opportunity to leverage Big Data and the continuum of analytics – descriptive, diagnostic, predictive, and prescriptive. All are useful for better decision making. Collecting, validating, and reporting data is not the same thing as analyzing information where we can glean valuable, actionable insights. In some ways the finance function is many years behind other disciplines such as marketing, sales, and supply chain managers, in applying analytics. How can the CFO’s function catch up?
Practical Excel Topics for Today's Accountant
-
Online
2.00 Credits
This course introduces practical ways that public accountants can use Excel to enhance both the efficiency and effectiveness of client engagements. We will reinforce core concepts by illustrating ways that Excel is a tool for analysis and reporting. We will introduce numerous analytical methods and techniques by using practical examples to illustrate how to unleash the power of Excel when obtaining, analyzing, and reporting information.
AI Lessons Learned for Accountants
-
Online
2.00 Credits
This course provides accountants with the leading AI insights and strategies drawn from real-world experience, empirical studies, countless CPA case studies, and social media commentary. It goes beyond theory, offering practical lessons learned from the front lines of AI implementation in the business world and accounting industry. Participants will gain actionable knowledge on bridging the theory-application gap, navigating exponential technological changes, and creating secure, adaptive AI policies. By the end of the session, accountants will be equipped to leverage AI responsibly and innovatively in their roles. 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 Hiring New Workers and Payroll Taxes
-
Online
2.00 Credits
When a new employee is hired, there are a lot of things the employer needs to take care of. Aside from getting employment contracts signed, training lined up, and the new hire breakfast planned, employers are tasked with making sure all of the payroll forms are filled out. For many small business owners, this can be a source of anxiety. They often wonder if they have everything they need. They also hear horror stories about potential IRS penalties for not having all of the boxes checked. In this course, we will explore the payroll compliance side of hiring new employees. From the alphabet soup of forms that need to be filled out to the initial payroll tax forms, we have you covered if you are a new practitioner or new business owner. We will even discuss the surprisingly difficult-to-navigate world of unemployment insurance.This course qualifies for IRS credit.
Surgent's The Accountant as the Expert Witness
-
Online
2.00 Credits
As litigation becomes more complex, attorneys are relying more on accountants to serve as consulting experts or expert witnesses at trial. Serving as an expert witness is not as difficult as you might expect. Accounting experts educate lawyers and jurors on issues such as valuation, tax liability, and forensics. Learn how accountants become expert witnesses, the role they play during pre-litigation through to trial, and the techniques experts employ to avoid challenges from opposing counsel.
Surgent's Use the Data Model to Build More Powerful PivotTables
-
Online
2.00 Credits
Do you love PivotTables? Of course, we all do! Traditional PivotTables are incredible, but they do have limitations. If you have ever encountered one of these limitations, you'll be excited to learn that by using the Data Model as the source for PivotTables, you'll be able to bypass many of the restrictions that exist with traditional PivotTables. The data model (also referred to as Power Pivot) is included in Excel 2016+ for Windows and available as a free download for previous versions (excluding Excel for Mac). Using the data model enables you to build PivotTables that were previously not practical. If you frequently build PivotTables and would like to do more with them, you'll want to understand how to use the data model (Power Pivot) to enhance your reports. Note about Excel versions: Power Pivot is not available in all versions of Excel, including Excel for Mac. If you would like to see if Power Pivot is available in your version of Excel, visit the Microsoft site.
Preparation, Compilation, and Review Engagements: Update and Review
-
Online
4.00 Credits
By reviewing the latest developments and issues relevant to preparation, compilation and review engagements, you'll be able to adhere to professional standards while performing these types of engagements.
Basis Calculations & Distributions for Pass-Thru Entity Owners Schedule K-1 Analysis
-
Online
8.00 Credits
This comprehensive case-driven training is designed to get the accountant up to speed quickly in the area of basis calculations and distribution planning for the owners of pass-thru entities (i.e., S corporations, partnerships, and limited liability companies (LLCs)). The cornerstone of this course is the line-by-line analysis of the Schedule K-1s and how it affects the basis calculations. **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
ACPEN Signature 2025: The Risk of Fraud in State & Local Government
-
Online
8.00 Credits
This comprehensive 8-hour course explores the pervasive issue of fraud in State and Local governments. Our panel of experts from inside and outside government will provide participants with the tools and knowledge necessary to identify, prevent, and respond to fraudulent activities in State and local governments. The course begins by examining the types of fraud commonly encountered in governmental settings, including financial fraud, procurement fraud, and abuse of power. With our experienced panelists, participants will delve into real-world case studies to understand the tactics used by fraudsters and the impact on public trust, resources, and governance. Special emphasis will be placed on understanding regulatory frameworks and compliance measures designed to mitigate fraud risks.
ACPEN Signature 2025: Single Audit and Uniform Guidance Issues Update
-
Online
8.00 Credits
If you think applying one set of audit standards is tough enough, how about applying three different sets of audit standards in one “single” audit? That’s exactly what happens when the auditor applies GAAS, the Yellow Book and the OMB requirements in a Single Audit. This session will start with a single audit “nuts and bolts” overview before delving into unique aspects and audit issues of the continued era of pandemic-related funding, and, of course, provide an update of any recent changes to the funding related to the Infrastructure and Investment in Jobs Act, or IIJA. Recent changes to the Single Audit and Uniform Guidance rules will also be covered. Join our expert panel of federal, state and local auditors and practitioners to learn what you need to know if you are performing audits under these audit standards and the Uniform Guidance for Federal Awards.
Fraud & Embezzlement: Case Studies from the Trenches
-
Online
2.00 Credits
Governmental entities are the second largest victims of embezzlement. This seminar examines recent events involving theft of public money and circumstances that allowed the fraud to occur. Case studies we examine include the 2012 $54 million embezzlement from the City of Dixon by Rita Crundwell. The events that impacted the small Illinois town of 16,000 residents was the largest governmental fraud case to date, and spanned an astonishing 20 years. This remarkable story inspired an award-winning documentary, "All the Queen's Horses." We will also examine factors that led to scandals involving the Baptist Foundation of Arizona, World Com, Collin Street Bakery and the Ohio American Cancer Society, among others. This course is ideal for CPAs, government finance personnel, all Internal Auditors, lawyers, governance professionals, accountants and human resource personnel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Promoting Mental Health in the Workplace to Prevent Violence
-
Online
1.00 Credits
Employees, now more than ever, are experiencing stress, anxiety and other mental health challenges and all of those come with them each day to the workplace. In order to ensure the safety and security of their workplace, employers need to address these issues and support their employees. Join us to discuss the challenges to providing mental health support to employees, the potential risks of deprioritizing mental health, and tangible actions employers can take to support the mental health of their work group. The cost of providing mental health resources and support pales in comparison to the cost of NOT providing it. Make a plan. Be ProActive.
How to Make Difficult People Disappear...Without Going to Jail
-
Online
1.00 Credits
Have you ever found yourself wondering why people won't just listen to you? Or maybe you have found yourself surrounded by people that make your jaw clench...you know the people...the challenging people. HR Professionals walk a tight rope of being strong, but not aggressive, polite, but not a push over. It is exhausting! In this session, you will uncover the secrets to working with (and overcoming) challenging people derived from the decades of experience Summer brings from her time on the frontlines and as an HR Professional working with companies such as Walt Disney World, H-E-B and even a dude ranch.
Appreciation Intelligence: The New AI
-
Online
1.00 Credits
Appreciation affects your bottom line and your workplace culture. Don’t think so? Think again! Your customers, clients, and co-workers want and need to know they are appreciated. How do you show them appreciation? You show them in their preferred appreciation style. You have a bias for how you like to receive appreciation, and so do the people with whom you work. In this program, we will build on the research of Gary Chapman and Paul White on appreciation languages – words, time, service, and gifts. Appreciation is a skill and practice that promises to influence your work life positively. You will experience strategies you can employ in your day-to-day lives to improve your team culture and manage work relationships.
Real Estate Professionals: Passive Activity Rules
-
Online
2.00 Credits
When do they exist and how to report them? This program will provide a detailed analysis of the real estate professional passive activity rules, including forms reporting examples, and integrates those rules with when real estate is considered a "business" under the Section 199A flow-through entity deduction. *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
What Does Fraud Look Like?
-
Online
2.00 Credits
The audit standards state that one of the reasons auditors fail to detect fraud is that they don’t know what it looks like. Prior to the original SAS No. 82, Consideration of Fraud In A Financial Statement Audit, nowhere in any SAS was there a description of what fraud looked like. So, as they say, if you don’t know what you are looking for, you can often look right at it and not recognize it! This presentation illustrates some of the more common indicators of fraud they most individuals would overlook unless they 1) knew what they were looking for and were 2) actually looking for it. Contrary to what the standards say about fraud being concealed, I have found that fraud is often laying on the table right in front of you; but no one has discovered it because they have no idea what the indicators of fraud are.
Ethics With A Dash of Courage
-
Online
2.00 Credits
Getting ethics right is a big deal, and ethics often requires courage. An organization's ethics is directly connected to its reputation in the community, and solid ethical principles are crucial for the long-term success of any organization. This facilitated discussion goes beyond a lecture on ethical principles - it is a series of executive level case studies that offer participants "real time" practice in resolving dilemmas, with participants sharpening their critical thinking skills.
Taxation of the Cannabis Industry
-
Online
2.00 Credits
This course offers a comprehensive exploration of the cannabis industry, delving into essential topics such as cannabis regulations, business models, financial management, and ethical considerations. A key focus is on distinguishing between Marijuana and Industrial Hemp, including their respective tax treatments. Participants will gain a thorough understanding of the unique challenges and opportunities within the cannabis sector, covering federal and state tax implications, licensing requirements, and market trends. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
What You Can Learn From the Statement of Cash Flows
-
Online
2.00 Credits
This course allows you to get reacquainted with the statement of cash flows. We will refresh your skills regarding both the preparation and utilization of the statement of cash flows. Significant emphasis will be placed on the informational role of the statement of cash flows and insights that can be obtained using the statement of cash flows in concert with the other elements of a company's accrual-basis financial statements. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Getting On Top of It All: How to Work Smarter, Not Harder - Part 2
-
Online
4.00 Credits
There is always too much to do and too little time to do it all. Fortunately, if you know the right ways to manage people, projects and your time, you can get on top of everything by working smarter. In Part 2 of this seminar we will go into more depth about how to get more done in less time, as well as how to not burnout from all the work you do. We will discuss additional methods for working smarter through technology, communication, stress reduction, and creating smart and helpful goals.