CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Providing Ethical Leadership: Learning to be the Best Version of Yourself
-
Online
1.20 Credits
This course will examine certain qualities a leader must exhibit to set an ethical tone from the top.
2024 Resolving Ethical Dilemmas-You Make the Call
-
Online
1.50 Credits
By now, we should all understand the ethical obligations we have as CPAs. So, theoretically, if we just all agree to remain ethical, we should not have CPA ethical violations. But, of course, our professional ethics committees still have plenty of cases to investigate. This session will examine several ethical frameworks, including the AICPA’s Code of Professional Conduct’s and the GAO Yellow Book’s Threats and Safeguards approach to remaining ethical and resolving ethical dilemmas. The session will present several ethical case studies that illustrate the complexities of and challenges to staying ethical. By exercising our “ethical muscles”, we should be better positioned to effectively deal with the ethical dilemmas that we will inevitably encounter.
Excel for Accounting Professionals Session 6: List Comparisons and Indenting
-
Online
2.00 Credits
This session opens with how to use Excel's lookup functions to perform list comparisons. Also, this webcast covers how to perform multicolumn list comparisons without first combining several columns into a single lookup column. We discuss how a minor detail like how we indent can produce major efficiency gains. We end the webcast by comparing traditional lookup functions to Excel;'s multiple condition summing function. The webcast is designed with time for you to work along. This hands-on workshop is an effective way to learn Excel since you'll be completing the same exercises demonstrated by the instructor. A link will be provided, so you can download the necessary Excel files. During the webcast, the instructor will provide time for you to complete the exercises using your Microsoft Excel for Windows. For each topic presented, the instructor explains the topic and demonstrates it with Excel exercises. Then, the instructor provides time for you to complete many of the same exercises. Finally, the instructor demonstrates the solutions for all the exercises in the practice workbook and then moves to the next topic. This format allows you to work along rather than just watch passively, enabling you to immediately practice the skills demonstrated.
Achieve Competency in Three Basic Tool Categories - Master the Fundamentals
-
Online
4.00 Credits
Financial skills needed in many situations are constantly changing. It is prudent to routinely look into your toolbox to restock or revise your tool set. In this course we will examine three tool categories that form the foundation for many analytical processes.
Building a Better Budget in a Time of Uncertainty
-
Online
4.00 Credits
Most financial leaders would agree that budgeting is easy when business and the economy are stable. When revenues and expenses are expected to remain the same, the process becomes merely an exercise in carrying over what was done before to the current year. However, what happens when we are not sure about how the market will react to our product? What happens when the competitive landscape changes? In this course, we will discuss budgeting techniques and considerations when business lacks stability. Through a combination of theory and real-world examples, we will explore how to build flexibility into our budget - so that it can inform and drive decision-making when we don't quite know what is ahead. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
K2's 2023 Excel Best Practices
-
Online
8.00 Credits
As spreadsheets evolve, so must your practices for creating, editing, and auditing them. In this program, you will gain an in-depth understanding of the best ways to work with Excel by learning best practices associated with Excel spreadsheets in each of the following areas: creating and editing Excel workbooks, securing Excel workbooks, collaborating with others in Excel, and reporting on data contained in Excel. Today’s best practices for Excel differ significantly from those used in the past, and you will learn the best ways to work with Excel spreadsheets in this “must-see” CPE program. Course materials include relevant examples to enhance your learning experience. Join us for this program to help you utilize Excel to its fullest potential.
K2's 2023 Case Studies in Fraud and Technology Controls - 8 Hrs
-
Online
8.00 Credits
Fraud continues to plague businesses at epidemic levels, and technology control failures are a significant reason fraud occurs. Using a case study approach, in this session, you will learn about the pervasiveness of fraud, the control failures that contribute to fraud, and what you can do to mitigate fraud risk. A specific focus of this course is the application of information technology general controls and information technology application controls. In this course, you will examine numerous reported fraud cases and identify the general control and application control failures that contributed to each of these frauds. By learning through these real-world case studies, you will be positioned better to reduce fraud risk.
2024 Annual Update for Governments & Not-for-Profits
-
Online
8.00 Credits
We kick off this course with a look at the GASB standards that are effective this year including GASB 100, Accounting Changes and Error Corrections and GASB 101, Compensated Absences. We then move to the NFP side of the house with a look at the Accounting Standard Updates issued by the FASB that impacts nonprofit entities. Following that, we review the work of the Not-for-Profit Advisory Committee (NAC) and the projects they advise the FASB on. After the break, we will conduct a deeper dive into Yellow Book and Single Audit engagements. The course closes with a look at the significant changes in the 2024 Compliance Supplement, the changes to the Uniform Guidance and the common deficiencies identified by the federal agencies and peer reviewers. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
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.
Surgent's A Complete Guide to the Yellow Book
-
Online
8.00 Credits
If you work with governments and not-for-profits, a thorough understanding of the Yellow Book is essential. This course will equip you with a comprehensive knowledge of the Yellow Book requirements and increase your confidence and proficiency in performing Yellow Book audits. The course materials utilize a highly illustrative and innovative format including over 20 focused exercises on key practice issues.This course qualifies for yellow book credit.
Surgent's Audits of 401(k) Plans: New Developments and Critical Issues
-
Online
8.00 Credits
One of the most favored employee benefit plans, the 401(k) plan, provides unique challenges for auditors. Also, as many 401(k) plan administrators opt for ERISA Section 103(a)(3)(C) audits, audits of 401(k) plans will be significantly impacted by the now-effective SAS 136, the AICPA's new employee benefit plan auditing standard. Through this course, auditors will obtain an understanding of the rules and regulations unique to employee benefit plans and obtain practical guidance on applying them. Auditors will enhance their knowledge of the performance and reporting requirements of SAS 136 through real-world examples, best practices, and efficient audit techniques that can be utilized in various audit engagements. Make sure your audits don't trigger a DOL inspection by conforming to all applicable rules and regulations.
Surgent's Fiduciary Income Tax Returns - Form 1041 Workshop with Filled-in Forms
-
Online
8.00 Credits
This course is designed as a comprehensive guide to the core concepts of trust and estate income tax preparation. The course explains the common terminology and complicated income tax rules of estates and trusts, fiduciary accounting, and an introduction to or refresher on preparing Form 1041. This practical, over 300-page manual is an excellent reference source for your practice, which begins with quite simple cases. Building upon that base throughout the manual, the course ends with two complicated preparation cases, one trust and one estate, each with filled-in forms.This course qualifies for CFP credit.This course qualifies for IRS credit.
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.This course qualifies for IRS credit.
Microsoft Outlook "Must Know" Email Tips
-
Online
2.00 Credits
If you use Outlook on a daily basis to process your email, chances are pretty good that you are missing out on a lot of opportunities to improve your efficiency in composing, processing and organizing your messages. There are many different features in Outlook that often get overlooked, even though we are working in the app all day, every day. John Higgins, a strategic advisor to the profession on Microsoft 365 deployment, will review numerous tips and features to improve your productivity in Outlook. You will learn many time-saving, practical ways to improve the quality of your email message. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Imagining a World Without Non-Competes
-
Online
1.00 Credits
This course will review the Federal Trade Commission's proposed rule banning non-competes. It will also briefly go over the rule making process and timeline for the proposed rule to go into effect. In the second half, the presentation will review the patchwork quilt of state laws that have curtailed enforcement of non-competes, as well as best practices for businesses to consider when implementing non-competes in the workforce.
K2's 2023 Safeguarding Taxpayer Data - A Guide For Your RequiredSecurity Plan
-
Online
2.00 Credits
Combatting today’s cybercriminals takes everyone working together. The Internal Revenue Service works with state tax agencies and the tax industry to fight these 21st-century identity thieves. Unfortunately, data thefts at tax professionals’ offices are on the rise. Online providers also must follow the six security and privacy standards in Publication 1345, Handbook for Authorized IRS e-file Providers of Individual Income Tax Returns. In addition, you fall under the PTIN and 4557 mandates if you prepare tax returns. Learn how to fulfill your obligations by participating in this session. Regardless of size, most public accounting firms are mandated to have a written security plan in place. Failing to have such a plan in place can lead to substantial fines. Join us in this session to learn what your security plan should include and how to implement it.
Governmental Accounting 101
-
Online
2.00 Credits
Governmental Accounting 101, is a 2 hour webcast that takes the participant of a whirlwind tour of governmental accounting basics, focusing on wetting the participant’s appetite for more. This session will be the first of a series of webcasts, with each subsequent webcast delving deeper and deeper into the governmental accounting basics.
2024 Deep Dive into Quality Management
-
Online
2.00 Credits
Quality management will have a big impact on CPA firms. This course will cover both SQMS 1 and 2 as well as the related engagement level standards (SAS 146 and SSARS 26). The new standards will require a risk-based approach to quality management as well as the documentation of an information & communication process. This two hour class will provide a deep dive into what you need to know to start your implementation process!
K2's 2024 Tech Update
-
Online
2.00 Credits
Technology continues to revolutionize our professional and personal lives. Stay up to date on key technologies that may affect you in the very near future so that you may position you and your organization for success.
Surgent's Excel Lookups: Moving Beyond VLOOKUP Limitations
-
Online
2.00 Credits
How do you pull a value from a cell into another cell? Do you use a direct cell reference, like =G10? If so, you are probably missing out on some efficiency gains that could be achieved by using a variety of Excel's lookup functions. Veteran Excel users, who are aware of the VLOOKUP function, are also painfully aware of its limitations--especially that it cannot go left. We will explore how to bypass VLOOKUP's limitations by nesting functions and by moving beyond VLOOKUP altogether.