CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
ACPEN: Qualified Business Income (QBI) Deduction (§199A) – The Ins & Outs
-
Online
8.00 Credits
The Tax Cuts and Jobs Act (TCJA) was a major overhaul of our tax system that lowered the income tax rates for individual and corporate taxpayers and introduced the new 20% qualified business income (QBI) deduction for sole proprietors and pass-through entities. The cornerstone of this course is the comprehensive discussion of the 20% QBI deduction final regulations under IRC §199A. *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 terri.storer@acpen.com Presented by: J. Patrick GarverickType: Live Webcast Replay
ACPEN: K2’s Next Generation Excel Reporting
-
Online
8.00 Credits
Unlock the full potential of Excel and transform your operational and financial reports like never before. With cutting-edge tools such as Data Models, Power Query, Data Analysis Expressions, and Power Pivot, you can create powerful summaries and schedules in record time. Combine these with Excel's legacy features, and you have a game-changing opportunity to elevate your reporting environment. Join our fast-paced seminar to discover the magic of Power Query and how it seamlessly links data into Excel data models, enabling more efficient and insightful reporting. Learn to incorporate Key Performance Indicators, Slicers, and Timelines into your reports to enhance data analytics and understandability. Plus, master best practices for quickly and efficiently formatting your spreadsheets, giving them a polished and professional appearance. This course is a must for anyone using Excel for reporting processes. Elevate your skills and stay ahead of the curve with our expert guidance. You will truly learn how you can revolutionize your Excel-based reporting practices by participating in this session. Presented by: Thomas StephensType: Live Webcast Replay
ACPEN: K2’s QuickBooks Online For Accountants
-
Online
8.00 Credits
Discover the power of QuickBooks Online (QBO)! Intuit's cloud-based accounting platform has evolved and thrived over the past decade, now generating approximately five times the revenue of its desktop counterpart. Yet, many accountants and business professionals are still unaware of the extensive features QBO offers. Unlock the advantages of the subscription model and learn how to leverage QBO to manage inventory, enhance internal controls, create presentation-quality financial statements, and seamlessly migrate from QuickBooks Desktop or other accounting platforms. Join our dynamic session to explore the best practices for implementing, using, and excelling with QuickBooks Online. Don't miss out on the opportunity to elevate your accounting game with this surprisingly robust platform! Presented by: Thomas StephensType: Live Webcast Replay
Avoiding the Most Misapplied Audit Concepts
-
Online
8.00 Credits
Recent new auditing standards are designed to improve overall audit quality. The course will address the most common misapplied audit concepts in planning and performing effective and efficient financial statement audits. 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 Preparing C Corporation Tax Returns for New Staff and Paraprofessionals
-
Online
8.00 Credits
This course is a great foundation to introduce new preparers to tax rules related to business returns. The course covers tax areas affecting all business entities, providing a solid basis for staff to handle business entity returns. Such business tax topics include the sale of assets used in a trade or business (Form 4797), depreciation (Form 4562), deductible and nondeductible items, and the basics of uniform capitalization. The objective of this course is to train new staff accountants, data processing employees, paraprofessionals, and bookkeepers to prepare complicated federal corporate income tax returns. It is a hands-on and practical course, with extra emphasis on changes to forms under new tax law.
Using ChatGPT with Excel
-
Online
2.00 Credits
In this innovative course, participants will learn to combine the power of artificial intelligence with the functionality of Microsoft Excel. You will learn how to leverage ChatGPT, OpenAI's powerful language model, to improve your Excel skills and decrease the time it takes to build spreadsheets. The course will include a quick introduction to ChatGPT but the majority of the time will be spent using ChatGPT to create an Excel spreadsheet. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
ACPEN: Overcome Your Obstacles to Abundance
-
Online
4.00 Credits
Getting rich requires many things. First, you need to know how to overcome previous limitations you may have had about making a lot of money. Second, you need to know and use the best financial strategies for becoming wealthy--including the latest investment and marketing strategies. And third, you need to be able to enjoy your lifestyle, and look at what obstacles get in the way of you being rich and fully contented. By exploring the latest methods for achieving financial and personal success, you'll be able to make a lot more money and have a great time doing it. Presented by: Jonathan RobinsonType: Live Webcast Replay
CFO Series: AI in the Digital World
-
St. Louis
8.00 Credits
*Register for 2 or more of MOCPA's CFO Series programs in person or virtual and save up to $200! Use promo code: CFO26 at checkout to receive discount. This presentation focuses on four perspectives on how technology has changed our profession and life. Are you and your organization using AI? Are you using AI effectively? What happens when a teammate posts something offensive on social media? We must stay abreast of and be aware of the myriad uses, perils, ethics, and advantages of AI. What are the numerous considerations? The spotlight is to always enhance our skills and help our organization improve. Technology is always moving forward, just as we should. Otherwise, we risk being left behind. Join us to learn best practices.
ACPEN: Sticky Ethical Choices, featuring Bob Mims and Don Minges
-
Online
1.00 Credits
If ethics were easy, then why do so many professionals have a Code of Conduct? Some Ethical decisions are easy, others are not. We will discuss several thorny ethical issues and the ramifications. What are the considerations and evaluation criteria to use? The need to carefully deliberate alternatives – is paramount. Be aware. Presented by: Don Minges, Bob MimsType: Live Webcast Replay
ACPEN: The Psychology of Fraud
-
Online
1.50 Credits
We all know that Fraud Happens. But, why? Why do people we think we can trust let us down? This session will explore the minds of white-collar criminals and examine some recent high-profile fraud cases. Why did they do it? How did they do it? What were the warning signs? If you think that fraud cannot happen to your organization, this session might give you pause. Presented by: David CottonType: Live Webcast Replay
ACPEN: Global Internal Audit Standards (GIAS) – Overview and Contrast to 2017 International Professional Practices Framework (IPPF)
-
Online
1.60 Credits
In May 2023, the IIA released a draft of the new Global Internal Audit Standards. The intent was to provide more effective standards for Internal Audit globally. The new Global Internal Audit Standards were released on January 9, 2024, and will become effective January 9, 2025. The previous version, the International Standards for the Professional Practice of Internal Auditing, released in 2017, remains approved for use during a one-year transition period. The Global Internal Audit Standards guide the worldwide professional practice of internal audit. They serve as a basis for evaluating and elevating the quality of the internal audit function. The Standards use 15 guiding principles with five separate domains that enable effective internal audit implementation and examples of evidence of conformance. The Global Standards are organized into five domains. Domain I: Purpose of Internal Auditing Domain II: Ethics and Professionalism Domain III: Governing the Internal Audit Function Domain IV: Managing the Internal Audit Function Domain V: Performing Internal Audit Service Presented by: Lynn FountainType: Live Webcast Replay
ACPEN: Data Analytics: Practical Insights for Today's Accountant
-
Online
2.00 Credits
This session explores tools and techniques that can enhance the efficiency and effectiveness of client engagements and business processes using data analysis tools. We will introduce some of today's popular and software tools and examine the AICPA's Five-step approach to incorporating data analytics into public accounting engagements. Presented by: Dr. Chris HarperType: Live Webcast Replay
Mastering Partnership Basis: Inside and Outside Basis
-
Online
2.00 Credits
This course will provide a detailed analysis of how to determine a partner's tax basis for a partnership interest, with an explanation of the use of both "inside" and "outside" basis determination. An illustrated example with filled in forms will demonstrate how the process works and the potential pitfalls. 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 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.
Surgent's Liquidation of Flow-Through Entities for LLCs and Partnerships
-
Online
2.00 Credits
Part of the technical competence of most experienced accounting and finance professionals is the ability to advise owners of S corporations and partnerships or multiple-member LLCs treated as partnerships regarding the tax rules that apply when these entities liquidate. Entity liquidations do not occur every day; but they do occur, and often at very critical times in the business life of the entity and its owners. All accounting and finance professionals should be able to advise their clients about the tax issues associated with client businesses that go out of existence and liquidate. This program explains the tax consequences associated with liquidating S corporations, partnerships, and multiple-member limited liability companies treated as partnerships.
Surgent's Taxation of the Mobile Workforce
-
Online
2.00 Credits
Today's workforce looks a lot different than it used to. With more people working from home and across state lines, employers must examine withholding and unemployment laws in a new light. In this course, we will examine tried and true rules in this area and examine statutes that are still developing. Using real-life examples and discussion, we will examine state laws on reciprocity and residency requirements. We will also look at what to do when state laws are silent or conflict on a particular issue so you can keep your clients in compliance and be well-prepared for the questions that will come your way in these ever-changing times.
ACPEN: Employee Theft: Understanding the Why and Preventing the Loss with Terry Shulman
-
Online
2.40 Credits
Employee theft is a growing problem, costing businesses billions of dollars annually. In this compelling session, Terry Shulman provides an in-depth look at the psychological, social, and organizational factors that drive employees to steal. As both a legal and behavioral expert, Shulman blends real-world case studies with psychological insights to explore why good employees make bad choices—and what businesses can do to prevent it. Presented by: Chuck Gallagher, Terry ShulmanType: Live Webcast Replay
ACPEN: Expand Your Analytical Toolbox More Tools for Success
-
Online
4.00 Credits
Valuation techniques and cash management activities are two other tool categories that can round out your analytical toolbox. In this course we will initially discuss how to turn your financial plan into a powerful valuation engine. We then will discuss the formation of an efficient cash management program based on solid banker relationships. Finally, we will review Ten Steps for keeping your financial toolbox full. Presented by: William O’BrienType: Live Webcast Replay
ACPEN: 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. Presented by: James LindellType: Live Webcast Replay
ACPEN: The Essential SSARS Update with Renee Rampulla
-
Online
4.00 Credits
This update is essential and designed to assist you in the application of Statements on Standards for Accounting and Review Services (SSARSs) issued by the American Institute of Certified Public Accountants (AICPA). Learn about recently issued SSARS Nos. 26 and 27, identify common accounting and reporting issues, and hear about other recent developments. Presented by: Renee RampullaType: Live Webcast Replay