CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Excel - Create KPI Dashboards for Maximum Impact
-
Online
2.00 Credits
Most accountants use Excel to help them make decisions about their data. However, as the amount of data grows, it becomes difficult to make strategic decisions based on rows and rows and columns and columns of data. In this course, you will learn how to build robust dashboards for analyzing key metrics in Excel. We will begin with some dashboard design guidelines, such as understanding your audience and identifying necessary metrics. Then, we will work through importing data, setting up calculated fields and columns, and creating key performance indicators (KPIs) for the dashboards. You will learn how you can add charts and eye-catching visuals with Power View, in order to make your dashboards easily understood. This session is presented using Excel 2013. Regardless of the version you are using, ALL concepts covered in this course apply to ALL versions of Excel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Transition from SSAE 16 to SSAE 18
-
Online
1.00 Credits
In April 2016, the American Institute of Certified Public Accountants (AICPA) Auditing Standards Board (ASB) issued the Statement on Standards for Attestation Engagements (SSAE) No. 18, Attestation Standards: Clarification and Recodification, to supersede the former standard SSAE 16 This course will help you if your organization has the need to obtain or provide a SOC (Systems Organization Control) report or if you wonder what changes the new SSAE 18 standard will bring to the process. SSAE 18 is effective for SOC report opinions dated on or after May 1, 2017, and early adoption was permitted. This course focuses on the specific requirements of SSAE18 and highlights changes from SSAE16 In today’s economic environment, many companies utilize outsourced services to perform varied functions. These functions can span from payroll and accounts payable to information technology processes or even call center functions. The list can be endless however these services are often a critical component to the internal control environment of the organization A service organization should implement a robust third-party vendor management policy if one is not already in place. Often, initial vetting occurs of the subservice organization however that same diligence is not maintained as the service continues. It is just as important to ensure that subservice organizations are monitored on an ongoing basis using the methods outlined in SSAE 18.
How Prevalent Is Retaliation Within Your Culture?
-
Online
1.00 Credits
Does your organization encourage timely reporting? Does your organization provide substantive protection for those who report? Organizations should be aware of characteristics indicative of a retaliatory culture - one in which bad actors are provided ample opportunity and cover to retaliate.
The Future of Work - Building a New Model of Work - Micro-Credential Series Part 2
-
Online
1.20 Credits
Most of the models of work that we use today were not built for the pace of change and the dynamism of work today. In this course, you will learn how so many models we use at work are fundamentally broken and no longer useful. Models that rely on people staying a long time in a firm are no longer helpful in a reality where employees are staying for increasingly shorter periods with their employers. This course will reveal how so much of the architecture of work was not built with short tenure in mind: career paths, compensation, and retention objectives.
The Controllers Role in Data Analytics and Big Data
-
Online
1.50 Credits
Today’s economy and all of the digital enhancements have impacted the way companies engage with their customers as well as how the company manages their internal practices. The business control function needs to keep pace. The rising importance of analytical capability is critical when defining the role of the modern controller. Execution of analytics can vary but there are still key questions that must be asked. What are the options and what we need to understand to decide the best way forward? This course focuses on the value that can be brought by the Controller when becoming involved with data analytics powered by technology and also Big Data. The digitized world we live in has made it important for the Controller function to evolve and take on this advanced task.
Introduction to Forensic Accounting
-
Online
1.80 Credits
This course provides a high-level overview and introduction into the world of the forensic accountant. Most accountants have an understanding of the concept of fraud and how it impacts companies, but many individuals do not have a full comprehension of the variance in the work performed by a forensic accountant versus a typical management accountant. This course is meant for those individuals interested in understanding the variances in the job tasks and responsibilities of forensic accountants versus typical financial or management accountants. Forensic accountants or auditors take a unique focus on performing their work. Typically, when a person with forensic experience is called in to examine financial records, it is due to suspicion of fraud, evaluation of assets, or even to track down fundamentally incorrect accounting – intentional or not. As fraud continues to raise its head in business processes, forensic accountants are discovering new and unique ways to identify, examine, and support their hypotheses and investigative techniques. The work performed by a forensic specialist can be interesting and full of potential potholes if evidence isn’t examined according to proper protocols and standards.
Form 1120S - Preparation and Analysis
-
Online
2.00 Credits
This course provides an in-depth exploration of Form 1120S, the tax return form used by S corporations. Students will learn the intricacies of preparing and analyzing this form, including how to determine the taxable income of the S corporation, how to properly report and allocate income, deductions, and credits, and how to calculate the shareholder's basis in the S corporation. **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 ABCs of Advisory Services
-
Online
2.00 Credits
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.
Illicit to Essential: Marijuana & Hemp/CBD Evolving Issues
-
Online
2.00 Credits
The webinar will provide an overview of the regulated, legal side of the industry which now includes 19 states with recreational/adult use access and 38 states with medical access. This session will lay a foundation focusing on the modern historical background of the cannabis plant and the evolution of laws and regulations related to marijuana and agricultural hemp. The segment is designed to be useful for CPA practitioners desiring to provide or enhance their services within the cannabis and hemp niches. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Let's End Business Ethics
-
Online
2.00 Credits
Most ethics courses focus on unethical individuals and their terrible misdeeds. We don’t need another course on lessons from Enron or individuals committing fraud. Most unethical failures result from unethical individuals. Instead, this session will focus on how good people can do better, why there is no such thing as business ethics and why we only need one rule to lead ethical lives.
Profitability Pricing: Boost your Bottom Line
-
Online
2.00 Credits
Two seemingly similar products can have very different costs, yet many companies are completely oblivious to these differences causing them to lose money or competitive bids. When companies compete, those with good information win the “gravy” contracts and those with bad information lose money on “dog” jobs. Attend this session to gain insights on how to win bids for the best opportunities and give the money-losers to your competitors. Achieve your target profitability in the process.
Surgent's Summary and Analysis of the Inflation Reduction Act of 2022
-
Online
2.00 Credits
In late 2022, Congress enacted the Inflation Reduction Act of 2022 (IRA), which provided many significant tax law changes tax practitioners should be knowledgeable about. This program will cover the tax legislation embodied in the IRA in detail so that those attending can properly advise their clients on if and how these various tax changes impact their individual and business planning.This course qualifies for IRS credit.
2022 Tax Legislation: the Inflation Reduction Act and CHIPS Act
-
Online
2.20 Credits
In a surprise twist, Inflation Reduction Act (IRA) was passed in short order after secret negotiations were revealed in late July, 2022. Seismic changes in tax legislation is currently taking place, and the well-informed tax practitioner will want to attend this two hour program in order to stay abreast of these developments! This course will provide a concise look at these hot topics. Who should Attend: This course is suitable for Corporate tax and finance executives, directors, managers and staff, CPAs, CAs Enrolled Agents, accountants, attorneys and business/financial advisors who work with and advise businesses that have these tax implications. All in-house and public practice tax professionals will benefit from this timely and insightful seminar **Please Note: If you need credit reported to the IRS for this IRS approved program (2 Hours only), please download the IRS CE request form on the Course Materials Tab and submit to leighanne.conroy@acpen.com.
Auditing For Fraud
-
Online
2.00 Credits
Auditors are required by Generally Accepted Auditing Standards to perform audit procedures to determine if the financial statements are materially misstated due to error OR FRAUD. Unfortunately, in the past the profession has focused on misstatements due to errors and largely ignored to possibility of misstatements due to fraud. While SAS No. 122, AU 240, Consideration of Fraud in a Financial Statement Audit sets forth the procedures that auditors are required to perform in each audit to determine if the financial statements are materially misstated due to fraud, this program presents a practical approach to making such a determination. It’s not a substitute for the requirements in SAS 122, AU 240, but rather an informal supplement to the standard with some common-sense procedures which are designed from my over 30 plus years of directing fraud investigations. After attending this session, you will more than likely never look at a financial statement audit the same way.
Achieving Balance in Work and Life - Part 1
-
Online
4.00 Credits
Due to the constant stress of a fast paced life, overwork, and family demands, it’s easy to feel one’s life is out of balance. When this happens, all areas of your life can suffer. By learning key methods for setting priorities and goals, overcoming stress, and deciding what’s most important to you, you can achieve new levels of balance and greater results. Having more balance in your life will allow you to do less of what you don’t want and more of what is truly important to you.
New Mergers & Acquisitions: Tricks, Traps, & Terrors
-
Online
4.20 Credits
Welcome to a course that makes the process of M&A easy to understand and easy to implement within your organization or your clients' organization. The course will provide an intensive overview of the M&A process. Focus will be on practical techniques to guide you through the M&A jungle and avoid the traps that have befallen many organizations.
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
K2's 2023 Next Generation Excel Reporting
-
Online
8.00 Credits
New features in Excel provide tremendous opportunities to improve Excel-based operational and financial reports. For example, Data Models, Power Query, Data Analysis Expressions, Power Pivot, and many others can help you create more powerful summaries and schedules in less time than ever. Bundle these tools with some of Excel’s “legacy” features, and you have significant new opportunities to improve your Excel-based reporting environments. In this fast-paced seminar, you will learn about the importance of using Power Query to link data into Excel data models and how you can manage these data models to facilitate better and more efficient reporting. Additionally, you will learn how to incorporate Key Performance Indicators, Slicers, and Timelines into your reports to enhance the analytics and understandability of the data. Further, you will learn best practices to quickly and easily format your spreadsheets to give them a polished and professional appearance. This course should be at the top of your professional development list if you use Excel for any reporting process.
Making the Best of Bad Situations: Tax Planning in a COVID-19 Environment
-
Online
8.00 Credits
This course helps the practitioner understand planning considerations and potential problems when certain “bad situations” happen to his/her client. Updated for COVID-19 issues, this course will explore a variety of bad situations and provide the practitioner an understanding of the tax and non-tax circumstances to be considered when advising a client who is experiencing a bad situation in these trying times. **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 leighanne.conroy@acpen.com.
ACPEN Signature 2024: Single Audit and Uniform Guidance Issues Update
-
Online
8.00 Credits
If you thought 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 era of pandemic-related funding, and of course the new funding related to the Infrastructure and Investment in Jobs Act, or IIJA. Join our expert panel of federal, state and local auditors and practitioners, along with a representative of a large Federal Agency to learn what you need to know if you are performing audits under these audit standards and the Uniform Guidance for Federal Awards.