CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
K2's 2023 Introduction To Excel Macros
-
Online
4.00 Credits
You have used Excel for years and perhaps Lotus 123 before that. And through all that time, you have repeatedly said, “One day, I’ll learn how to write macros.” Finally, that time has arrived because this four-hour program will introduce you to the wide world of Excel macros and Visual Basic for Applications (VBA). This course teaches the fundamentals of creating and working with macros in Excel and is designed specifically for those with little experience working with macros. More specifically, taking this course will teach you how to use Excel’s Macro Recorder to write simple yet effective macros. You will also learn how to secure and share macros with other Excel users and create user-defined functions to solve specific accountant-centric problems in Excel. Further, you will learn how to create macros that run when a user opens a workbook and VBA basics. Don’t miss this unique opportunity to learn how to begin working with macros – one of Excel’s most powerful tools.
K2's 2024 Small Business Accounting Shootout
-
Online
4.00 Credits
Small business accounting solutions have never been better, with many fantastic options. In this session, you will learn about the relative strengths of these platforms so you can make the right choice when selecting and implementing a solution.
K2's 2023 Accounting Solutions Mid-Market
-
Online
1.00 Credits
Many businesses are being held back by legacy solutions. The old way of doing things doesn't work anymore. Instead, Software as a Service (SaaS) has transformed many mid-market companies. In this new world of cloud-based, workflow-enabled, data-centric, and connected solutions, you can solve existing and future business problems in new ways without being bogged down by paper-centric environments. This session covers integrated and ERP solutions that should work for businesses in the $10 Million to $1 Billion range. If your existing system has been in place for seven or more years, it is time to consider upgrading or replacing it. Leverage your instructor's knowledge of the market to minimize your risk.
2024 Upholding Independence While Holding Your Client's Hand
-
Online
2.00 Credits
Many entities look to their CPA as a trusted advisor when tackling complex accounting topics. This is more relevant now than ever. The FASB's big three accounting pronouncements involving revenue recognition, leasing and credit losses have placed a magnifying glass on this reality. Practitioners need to exercise caution to ensure they maintain independence as they assist their review and audit clients with such matters, as well as with compilation engagements. This course addresses these issues and explores best practices and guidance provided by the AICPA's Code of Professional Conduct. **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.
Auditing Impairment of Long-Lived Assets
-
Online
2.00 Credits
Long-lived assets may be either finite or indefinite-lived, tangible or intangible in nature. The carrying value of these long-lived assets should be evaluated at each measurement date to determine whether there is an impairment loss necessary due to declines in an asset's fair value. This course describes the tips and techniques for determining whether an impairment loss risk exists, and how to calculate, record, and disclose any such loss. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Excel - Auditing Your Spreadsheets for Maximum Accuracy
-
Online
2.00 Credits
Did you know Excel has 400-500 functions depending on your version? Did you know there are 12 different function categories? Did you know you could create your own functions? After you attend this class, you will be in the know! In this webinar, we will focus on proofing and auditing your spreadsheets. You will learn how to build spreadsheets that validate the accuracy of your calculations and techniques to use the Data Validation feature to validate data entry. You will also learn techniques to cross-foot your data to ensure accuracy as well as how to use the various Excel Auditing Tools. 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.
Surgent's Federal Tax Update
-
Online
4.00 Credits
Both businesses and individual clients face major changes as a result of new legislation, and tax professionals face the considerable challenge of delivering effective planning advice and services to address this myriad of recent developments. This course addresses this challenge and also encompasses the latest cases and rulings applicable to individual and business clients. Continually updated to reflect enacted legislation. Please Note: Due to content overlap, it is recommended that this course NOT be taken together with BIT4.This course qualifies for IRS credit.
Surgent's Guide and Update to Compilations, Reviews, and Preparations
-
Online
4.00 Credits
Specifically designed for preparation, compilation, and review practitioners, this course will provide you with a comprehensive review and hands-on application for performing financial statement preparation, compilation, and review engagements. You will learn the ins and outs of applying SSARS No. 21, Clarification and Recodification, as well as the additional guidance related to SSARS engagements through the issuance of SSARS Nos. 22-25 by the ARSC. The course will also review recent peer review feedback on SSARS engagements, providing insights on how to successfully apply this guidance. Not only will this course bring you up to date on SSARSs requirements and guidance, but more importantly, it will provide you with practical examples and illustrations to help you effectively and efficiently perform compilation, preparation, and review engagements.
Auditing Financial Statements of ERISA Plans
-
Online
4.00 Credits
Conduct a compliant audit Identify proper audit procedures to test the line items of the statement of net assets available for benefits, including investments. Identify proper audit procedures to test the activity in the statement of changes in net assets available for benefits, including participant testing. Plan investments Differentiate plan investment procedures based upon the type of audit and risk assessment. Identify types and classifications of common plan investments. Identify audit procedures required for investment activity, contributions and benefit payment or withdrawals at the participant level. GAAP presentation and disclosure Understand GAAP requirements for presentation and disclosure for employee benefit plan financial statements. Other audit considerations Recognize procedures needed to determine the plan's tax status Learn how to identify related parties, parties in interest, and prohibited transactions. Recognize additional audit procedures needed for Form 11-K filers.
Shorten Month-End: Closing Best Practices
-
Online
4.00 Credits
Surveys show that the average North American company completes its monthly financial statement closing in six days. However, some companies can close their books in one day or less. You don't have to sacrifice accuracy for speed. This session will show you how to close month-end faster, better and cheaper. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Walter Haig's SSARS Prep, Comp and Review Update
-
Online
8.00 Credits
This course includes an analysis of all of the relevant authoritative pronouncements that a CPA must have an understanding of in order to properly perform preparation, compilation and review engagements. Troublesome areas as identified in peer reviews and litigation will be addressed. This course is loaded with practical aids to enable CPAs to comply with the standards! Participants who take this course will enjoy a smooth sailing in their peer reviews...guaranteed! This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Emotional Intelligence
-
Online
1.00 Credits
Emotions get us every time. We all feel emotion. It’s what we do after we experience them that defines us. Emotional intelligence is critical in moving you, your teams, and your life forward. It’s all about your awareness and relationships with people. In this course, you will learn what emotional intelligence is and why it is one of the essential factors in determining your success in your career and your life. You will apply the four key areas of emotional intelligence and strategies you can immediately use to increase your emotional intelligence. Emotional intelligence is a skill and practice that promises to influence your life positively. You will learn the value it brings to how you approach your work and your relationships with co-workers, clients, and customers.
2024 Yellow Book Ethics
-
Online
2.00 Credits
SAS 145, Understanding the Entity and Its Environment and Assessing the Risks of Material Misstatement, was issued in October 2021. The audit standard amends AU-C 315, including many changes to address common audit deficiencies. This course will provide an overview of SAS 145 and its changes to AU-C 315. Attendees will have an opportunity to evaluate the impact on audit methodology and documentation.
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 Business Losses: Going Backward and Forward
-
Online
2.00 Credits
The TCJA made turning business losses into tax refunds far more difficult. The CARES Act suspended and modified many of these changes. This course will address the revised rules for deducting business losses and discuss planning ideas and potential pitfalls. **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.
PowerPoint Fundamentals - Create Engaging Presentations
-
Online
2.00 Credits
In this course you will learn how to create presentations that look professional and clearly deliver your message to your audience. You'll benefit from a step-by-step guide for building a presentation, including understanding the PowerPoint interface. We will also dive into topics such as using themes and layouts; adding graphics, photos and other objects to engage the viewer; and tips & tricks for delivering your PowerPoint presentation. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Professional Development for Busy Women: The CliffsNotes! 13
-
St. Louis
2.00 Credits
There is a plethora of literature out there, but who has time to read it all? Between work and family commitments, most of us can’t stay awake to read for more than a few minutes at night. No worries! We’ve done the hard work for you! Please join us for another edition of Professional Development for Busy Women: The CliffsNotes 13.0. You’ll hear from four speakers, each of whom will deliver a high-level summary of the key points from a professional development book that they personally found to be helpful, inspiring and educational. Now is a good time to invest in improving your skills in leadership, communication, innovation, time management, productivity, and mindset! You’ll learn insights from the following:• Leadership is a Relationship: How to Put People First in the Digital World by Michael S. Erwin & Willys DeVollPresented by: Kate Turner | CGMA, CIA, CRMA, CPA | IT Admin & Governance, Hussmann • Ego is the Enemy by Ryan HolidayPresented by: Lauren Hunt | CFP, MBA, ABFP | Senior Advisor, Moneta Group • Uptime by Laura Mae MartinPresented by: Jill Zeller | MBA | Membership & Communications Manager, MOCPA• Stories That Stick: How Storytelling Can Captivate Customers, Influence Audiences, and Transform Your Business by Kindra Hall Presented by: Amanda Simmonds | Senior Manager, Armanino Moderated by Amanda Koehler, CPA | CFO, MOCPA
Surgent's Reducing a Business Owner Client's Exposure to Social Security and Self-Employment Taxes
-
Online
2.00 Credits
Many business owner clients wish to minimize their Social Security and self-employment tax liabilities. This course provides tax practitioners with the background to understand what kinds of income constitute self-employment income and earned income. It covers strategies that can be used to reduce clients' exposure to the self-employment tax and Social Security tax.This course qualifies for IRS credit.
Surgent's Successfully Completing a Gift Tax Return -- Form 709
-
Online
2.00 Credits
Since the early 2000s, the estate tax burden on taxpayers has gradually decreased along with the number of practitioners specializing in the field. Nevertheless, some of your most wealthy clients will have a taxable estate. For these select clients, making large gifts before death can be extremely tax efficient for the client and profitable for the practitioner filing the gift tax return. Learning how to file a basic gift tax return can help you attract and retain clients, increase your value-add, and generate revenue.This course qualifies for IRS credit.
Top 10 Business Myths and How to Avoid Them
-
Online
2.00 Credits
Every business has risks, but some myths seem to damage or kill more enterprises than others do. This session will review ten of the most problematic myths that may doom a business and discuss action steps to prevent these myths from holding your business back. This session discusses the common myths, mistakes, risks, and hidden landmines inherent in every business. We will learn from the mistakes of others who often paid a steep price so that we may learn valuable lessons. If you are a leader who wants your business to become even more successful, this session is for you.