CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Resolving Ethical Conflicts
-
Online
2.00 Credits
At some point in his or her career, every financial manager will face a choice of doing the right thing or taking the easy way out. Skillfully handling a conflict, ethical or otherwise, can make a big difference your career's trajectory. Professional standards provide procedures for resolving ethical conflicts. Yet, following these procedures alone will often cause a financial professional to lose their job. This webcast will show you how to both do the right thing and keep your job.
K2's 2023 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.
How Fraud Can Affect Smaller Organizations
-
Online
4.00 Credits
Many small to medium sized companies do not properly address the risk that arises related to fraud because these organizations do not have the resources needed to mitigate this risk or because owners or those in top level management underestimate the scope of the issue. All organizations, regardless of size, must be aware of the risks associated with intentional fraudulent acts and know that a significant and effective fraud scheme could even create going concern issues for some entities. In this session, we delve into the reasons that fraud takes place. The material discusses the types of defalcations that are often executed against smaller entities and then explores measures that organizations can implement to help stop fraud activities and add security. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Reviewing S Corporation Tax Returns: What Are You Missing?
-
Online
4.00 Credits
The complexity of S corporation tax law creates a formidable challenge to the tax practitioner for accurate compliance and reporting of their client's S corporation activities. Join us as we discuss the common errors practitioners make on S corporation tax returns that are often missed by review staff. The intent is to sharpen skills for reviewers by examining case studies and discussing issues where additional information from the client may be warranted and areas of tax law where proper treatment requires additional analysis and information. Multiple issues will be discussed including income, deductions, K-1 reporting, and K-2 and K-3 reporting. This course follows a highly illustrative case study format to increase participant comprehension and retention.
2024 The Complete Guide to the Preparation for Form 1041
-
Online
8.00 Credits
Navigate the intricate world of tax compliance for fiduciary entities with confidence through this comprehensive course tailored for financial professionals. Gain practical insights and expertise in preparing the U.S. Income Tax Return for Estates and Trusts (Form 1041), addressing specific issues surrounding decedents' estates and trusts. Delve into the fundamentals of Subchapter J of the Internal Revenue Code and master the art of compliance while decoding complex tax regulations. With engaging case studies and line-by-line instruction, participants will acquire the skills necessary to recognize and address key components of Form 1041, ensuring accuracy and efficiency in tax preparation. Don't miss this opportunity to enhance your proficiency and advance your career in fiduciary taxation. **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.
Managing Current Fraud Trends in a Shifting Environment
-
Online
8.00 Credits
As our business environment shifts, so do trends with fraud schemes and perpetrators. This course will give you the absolutely latest information with how to identify and mitigate shifting fraud risks in any entity. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Improve Design and Productivity with Excel Tables
-
Online
2.00 Credits
Excel tables are a fundamental feature that streamlines data organization, analysis, and visualization in Excel. Throughout this course, you will discover how to transform raw data into elegant, efficient, and visually appealing tables. By harnessing the full potential of Excel tables, you will be able to make better data-driven decisions and collaborate more effectively in various professional settings. Join us in "Improve Design and Productivity with Excel Tables" and unlock the full potential of Excel tables to revolutionize the way you manage, analyze, and present data, leading to improved efficiency and better decision-making in your personal and professional endeavors. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
2024 Reference Rate Reform
-
Online
1.00 Credits
At its height, LIBOR was the benchmark for over US $350 trillion in financial contracts worldwide. Yet, due to concerns over the manipulation of the rate, standard setters determined that LIBOR should be discontinued. The global response to reference rate reform required financial reporting standard setters to provide practical expedients and exceptions to current modification guidance. This course will provide an overview of the standards issued (including amendments) from both the FASB and GASB to address the transition away from LIBOR.
Eight Biggest Threats to your business and introducing Three Pillars of Cybersecurity
-
Online
1.00 Credits
Cybercrime is on the rise and CPAs that handle sensitive client data are often the target of cybercrimes. By attending this session you'll learn what the eight biggest threats are to your business and uncover the three pillars of cybersecurity that you can build your firm's defense around.
AI & You
-
Online
1.00 Credits
Every organization today is facing an onslaught of pressure to master Artificial Intelligence “AI” strategies across their enterprises. Never before have we witnessed such a steep expectation for how a “technology” can transform a business, and never before have we been expected to leverage a technology so quickly and so completely. There is no denying AI presents perhaps the opportunity of a lifetime to transform and improve operations, but to date few plans or roadmaps on how to unlock the promise of AI exist. In this class, Steve Cadigan, a globally renowned future of work expert, will present a practical plan for how you can build your own AI strategy, and how you can thrive in the AI revolution. Steve will show present a roadmap of how to build your confidence with AI to address this massive change management challenge.
Coaching & Counseling - Addressing Misconduct
-
Online
1.20 Credits
The objective of corrective action is to change conduct through teaching. Corrective action may be sequential, out of order, repetitive, or not appropriate to take at all. The action selected should reflect the type, frequency, and severity of the misconduct. Changing conduct through teaching requires effective employee relations skills. This course provides practical knowledge and scripts for handling a wide array of sensitive misconduct situations with good judgment, such that personal and employer liability is avoided.
Why Auditors Fail To Detect Fraud
-
Online
2.00 Credits
Prior to the original SAS No. 82 on Consideration of Fraud In A Financial Statement Audit (now codified as SAS No. 122, AU 240), the word fraud never appeared in a single SAS, nor was it described anywhere. SAS No. 82 stated that auditors failed to detect fraud for two reasons: 1) They did not know what it looked like and 2) They had not been trained to look for it. Although the SASs did not provide any guidance, auditors have always been responsible for the detection of anything that would cause a material misstatement of the financial statements whether caused by error or irregularities. (They would not even say the word fraud until it appeared in SAS No. 82) The standards were replete with guidance on the detection of an error but silent on how to detect irregularities. Now auditors are required to document in every financial statement audit their process of determining the risk of financial misstatement due to fraud. This presentation is designed to focus on frauds that were missed by the auditors and, in some cases, why it was missed. There will also be discussion as to what the auditor must do in order to improve their track record on detecting fraud. As reported on the Association of Certified Fraud Examiners Occupational Fraud 2022: A Report to the Nations, only 4% of frauds were initially discovered by the external auditor. It was reported that more frauds were discovered by accident, (5%) then was discovered by the external auditor.
Resolving Ethical Conflicts
-
Online
2.00 Credits
At some point in his or her career, every financial manager will face a choice of doing the right thing or taking the easy way out. Skillfully handling a conflict, ethical or otherwise, can make a big difference your career's trajectory. Professional standards provide procedures for resolving ethical conflicts. Yet, following these procedures alone will often cause a financial professional to lose their job. This webcast will show you how to both do the right thing and keep your job.
Securing Your Data with a Password Management App - Updated
-
Online
2.00 Credits
Cybersecurity protection is one of the most important responsibilities of every CPA professional to protect the confidentiality of sensitive client information. While there are many aspects of cybersecurity that need to be addressed, the biggest vulnerability to protect against is unauthorized access to your application login credentials. Once your login credentials are breached, the cybercriminal essentially has the keys to your data kingdom. John Higgins, a national leader in the CPA technology, will demonstrate the ease with which you can protect all of your login credentials with maximum security with minimal expense. You will leave this course prepared to deploy this state of the art security tool in your organization. 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 International Tax Challenges and Opportunities for U.S. Filers
-
Online
3.00 Credits
Globalization continues to make it easier for taxpayers to live abroad, do business in other countries, or invest in foreign enterprises. This creates significant complications and tax planning opportunities when it comes to filing U.S. tax returns. This course provides an overview of the unique tax challenges and solutions presented to U.S. expats or investors living or investing abroad. It examines how foreign-source income is taxed in the U.S. and how the tax consequences could be mitigated by applying the tax treaties, claiming credit for foreign taxes paid, or excluding foreign-earned income. Additionally, the course discusses the numerous foreign informational form reporting requirements and the significant penalties that could be imposed by the IRS. Examples from real-life client scenarios are included.This course qualifies for IRS credit.
Data & Predictive Analytics & Business Intelligence for Controllers/CFOs
-
Online
4.00 Credits
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.
Ethics - A Line in the Sand; Implications for Daily Business
-
Online
4.20 Credits
Ethical behavior continues to be a problem in society and even in the CPA ranks. "Ethics - A Line in the Sand" looks at the behavioral issues that influence how CPA's act. The course will address why individuals make ethical blunders, the state of ethical conduct in business organizations, the relationship between strong cultures, policy and procedures and successful ethical work environments. In addition, the course will highlight the one behavior to watch for as an indicator of potential ethical violations.
2024 Accounting & Auditing Update
-
Online
4.00 Credits
The course will start off with a look at the Accounting Standard Updates (ASUs) issued by the FASB that will be effective in 2024 as well as those that may be great for early adoption. The course will also review year 2 issues in lease accounting including how to handle lease modifications. We'll then turn our attention from accounting to auditing where we will cover the audit standards coming down the pike including group audit and quality management.
K2's 2024 Improving Productivity With Microsoft 365/Office 365 Cloud Applications
-
Online
4.00 Credits
Isn’t it time you learned how to take advantage of critical features available in your Microsoft 365/Office 365 subscription? In this session, you will learn to use tools such as Teams, Planner, Power Automate, and others to enhance productivity and efficiency.
2024 Fringe Benefit Planning - Today and Beyond
-
Online
8.00 Credits
In today's dynamic economic landscape, staying ahead with effective fringe benefit planning is more critical than ever for both businesses and individual clients. With evolving tax laws and shifting market dynamics, understanding the intricacies of fringe benefit planning is essential to ensure financial well-being and compliance. This course offers a comprehensive overview of essential tools and techniques tailored for financial professionals, allowing them to navigate the complexities of fringe benefit planning with confidence and precision. By attending this course, practitioners will gain invaluable insights into various planning tools and techniques essential for meeting fringe benefit planning objectives. From mastering the subtleties of employee benefit planning, including ERISA reporting and disclosure requirements, to unraveling the complexities of IRC §132 fringe benefit options, attendees will enhance their expertise to deliver superior advisory services. The curriculum also delves into the practical aspects of cafeteria plans, flexible spending accounts, group term life insurance plans, and strategies for financing retiree medical benefits, among others. With a focus on practical application and real-world scenarios, this course equips participants to tackle fringe benefit planning challenges head-on, providing them with the tools and knowledge needed to optimize benefits for both business and personal needs, now and in the future. **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.