CPE Catalog & Events
Microsoft Excel: Moving Beyond the Basics
-
Online
2.00 Credits
Member Price: $89
This course explores the increasingly complex features of Excel that facilitate efficient data analysis. We will introduce numerous analytical methods and techniques by using practical examples to illustrate how to unleash the power of Excel when manipulating, analyzing and reporting information. Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate
K2’s Eight Awesome PivotTable Features
-
Online
2.00 Credits
Member Price: $89
Unlock the full potential of Excel's most powerful feature-PivotTables! While many users rely on them daily, few tap into the advanced capabilities that can transform data into dynamic insights. Join us for an eye-opening session where you'll discover eight game-changing PivotTable techniques that go far beyond the basics. From custom calculations and KPI integration to multi-source consolidation and advanced reporting tricks, we'll show you how to elevate your analytics and impress stakeholders. Whether you're a seasoned Excel user or just getting started, this session will equip you with the tools to turn ordinary PivotTables into extraordinary decision-making engines. Don't just use PivotTables-master them! Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate
Eliminating Busy Season: Transforming Your Practice to Year- Round Advisory Services
-
Online
2.00 Credits
Member Price: $89
This course provides tax and accounting professionals with a comprehensive framework for transitioning from a compliance-driven busy season model to a sustainable, year-round advisory practice. Participants will explore strategies for expanding services into tax, financial, and estate planning. The course addresses both transitioning existing clients and attracting new, higher-value clients while improving efficiency, client value, and revenue stability. Delivery Method: Individual webcast CPE Credit: 8Program Level: Intermediate
Failure to Detect Fraud and the Reasons Why
-
Online
2.00 Credits
Member Price: $89
SAS 122, AU 240, Consideration of Fraud in A Financial Audit state that auditors fail to detect fraud for two reasons. One, they haven’t been trained to look for it and two, they don’t know what it looks like. I would like to add a third reason: they don’t want to find fraud because it causes problems for the audit. This session is designed to familiarize auditors with the many faces of fraud; where and how to look for them and what to do if you think you have found fraud. Not everyone is able to recognize fraud. During this program, the attributes a fraud auditor (frauditor) will be discussed. In order to recognize fraud, an auditor must understand their client’s operation. What is an indicator in one client’s operation may be business as usual in another, and you have to know the difference. After viewing this program, chances are you will never look at your client the same way! Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate
Introduction to Governmental Accounting
-
Online
2.00 Credits
Member Price: $89
Governmental accounting differs significantly from other forms of accounting and requires a distinct approach to financial reporting. This course introduces the foundational principles of governmental accounting, including fund accounting concepts and the modified accrual basis of accounting. Participants will explore the structure and purpose of governmental fund financial statements and government-wide financial statements, gaining clarity on their objectives, layouts, and key elements. The course also addresses essential topics such as component units, the role and structure of Management's Discussion and Analysis (MD&A), and the preparation and significance of the Annual Comprehensive Financial Report (ACFR). Designed for those new to governmental accounting—or those seeking a refresher-this course provides a solid foundation for understanding and applying governmental financial reporting principles. The course has been updated to reflect recent guidance issued by the Governmental Accounting Standards Board, including GASB Statements 101-105. Delivery Method: Individual webcast CPE Credit: 2Program Level: Update
Surgent's Where To Live in Retirement
-
Online
2.00 Credits
Member Price: $119
Deciding where to live in retirement is a challenge that involves a multitude of factors that differ for everyone. Each person and couple should evaluate their current living situation to see where their goals and lifestyles in retirement can best be met. The program covers the various factors that most people should consider when thinking about where to spend their retirement years.Delivery Method: Individual webcastCPE Credit: 2Program Level: BasicThis course is being offered by a learning partner. You may access the Surgent platform through the My CPE page on vscpa.com after purchase.
Taxation of the Cannabis Industry
Online
2.00 Credits
Member Price: $89
This course offers a comprehensive exploration of the cannabis industry, delving into essential topics such as cannabis regulations, business models, financial management, and ethical considerations. A key focus is on distinguishing between Marijuana and Industrial Hemp, including their respective tax treatments. Participants will gain a thorough understanding of the unique challenges and opportunities within the cannabis sector, covering federal and state tax implications, licensing requirements, and market trends. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.This course is being offered by a learning partner and will not be accessible on your My CPE page. Access information will be emailed directly to you by CPA Crossings.
See more dates
The Many Faces of Fraud
Online
2.00 Credits
Member Price: $89
What does fraud look like? It depends. What may appear to be an indicator of fraud in one client’s operation could be normal in another, making it critical to understand your client and the transactions you expect to see. Look for what should be present but isn’t—and for what is present but shouldn’t be. This course emphasizes the importance of professional skepticism, which has no on/off switch—it must be applied continuously. As auditors, our role is to independently verify, yet too often we rely on client representations without sufficient validation, increasing the risk of missing fraud. Many auditors recognize, in hindsight, that they have encountered fraud indicators but failed to identify them at the time. This session will provide you with the tools to recognize those indicators and strengthen your ability to detect fraud—so you are better prepared for what you may find. Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate
Fraud Assessment for Small and Medium Sized Businesses
Online
4.00 Credits
Member Price: $149
It is virtually impossible to pick up the daily newspaper and not find an article on some type of fraudulent event. In the wake of the “Era of Fraud, Waste and Excess,” one might suspect that potential fraudsters would think twice before committing illegal acts. However, just the opposite seems to be the case. Is there really more fraud or is there simply more fraud awareness? The harsh reality is that it is a little bit of each. Not only has fraud worldwide reached a level of over $7.0 billion in lost revenue but savvy C-level executives now realize that it could happen to their companies—very easily. When you put these facts together, it adds up to a completely new era of vigilance. Delivery Method: Individual webcast CPE Credit: 4Program Level: Intermediate
Year-End Tax Planning: Thinking Outside the Box
Online
4.00 Credits
Member Price: $149
Tax planning is more than an estimated tax calculation, it's a process. Where are we now and what can we change? This timely program will highlight significant 2022-23 tax developments and discuss key tax planning ideas for your clients as you prepare for the upcoming tax season. Don’t wait until late December to start planning for your clients! **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. Delivery Method: Individual webcast CPE Credit: 4Program Level: Intermediate
Proper Financial Accounting for Partnerships and LLCs
Online
4.00 Credits
Member Price: $149
Although they are the most common entities for small and mid-sized business, financial (book) accounting for partnerships and LLCs are rarely discussed. This course examines the proper financial accounting for these tax-driven entities. Delivery Method: Individual webcast CPE Credit: 4Program Level: Intermediate
The Essential A&A Update with Renee Rampulla
Online
4.00 Credits
Member Price: $149
This course is essential and designed to assist those who need to remain up to date on recently issued and effective guidance impacting the accounting and auditing of private companies. Learn about the accounting requirements involving crypto assets, income taxes, joint ventures, governmental grants, interim reporting, and hedging. Understand the American Institute of Certified Public Accountants' (AICPA) recently issued Statements on Auditing Standards (SASs) and Statements on Standards for Accounting and Review Services (SSARSs). Delivery Method: Individual webcast CPE Credit: 4Program Level: Update
Comprehensive Audit & SSARS Update
Online
4.00 Credits
Member Price: $149
This course covers recently issued standards from the AICPA Auditing Standards Board and AICPA Accounting and Review Services Committee including the new Quality Management Standards. The session will highlight projects in progress at the Public Company Accounting Oversight Board, and International Auditing and Assurance Standards Board. The course will also recap recent changes and present common peer review findings and best practices to improve practice quality. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.This course is being offered by a learning partner and will not be accessible on your My CPE page. Access information will be emailed directly to you by CPA Crossings.
See more dates
S Corporation Preparation, Basis Calculations & Distributions – Form 1120S Schedule K & K-1 Analysis
Online
8.00 Credits
Member Price: $300
This comprehensive training is designed to get the accountant up to speed quickly with S corporation formation and preparation issues as well as a complete understanding of calculating a shareholder’s stock and debt basis. The cornerstone of this course is the in-depth line-by-line analysis of the Form 1120S Schedule K and K-1 and how these items affect the shareholder’s Federal individual income tax return. *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 Delivery Method: Individual webcast CPE Credit: 8Program Level: Intermediate
Estate and Financial Planning for the Older Client
Online
8.00 Credits
Member Price: $250
Enter the complex world of elder planning with this comprehensive course tailored for financial professionals. Gain invaluable insights into estate and financial strategies designed specifically for older clients, equipping you with the knowledge and skills to address their unique needs and challenges. Throughout the course, participants will explore a wide range of topics, from understanding the complexities of Medicare and various life insurance types to navigating Social Security considerations and exploring Medicaid planning details. With a focus on practical application, attendees will learn to customize estate planning strategies, explore housing and care alternatives, and address gifting complexities relevant to older clients. By the end of the program, you'll develop expertise in executing specialized planning requirements for mature clients, ensuring you're well-prepared to provide informed counsel and support in this important aspect of financial practice. Join us and enhance your knowledge in estate and financial planning for the older client today. *Please Note: If you need credit reported to the IRS for this IRS approved program, please download the IRS CE request form on the Handouts Tab and submit to kori.herrera@acpen.com Delivery Method: Individual webcast CPE Credit: 8Program Level: Basic
Excelling at Excel: The Magic of Power Query
Online
2.00 Credits
Member Price: $89
Elevate your data analysis capabilities with our focused course on Power Query. Tailored for financial professionals, this training will show you how to get started using Power Query and teach you some of the ways to take advantage of its ability to handle messy data and automate repetitive tasks. Harness the efficiency of Power Query to revolutionize the way you work with data. Learn how to "program" your tasks once and set them on repeat, eliminating the need for repetitive, robotic work. This automation not only saves time but also ensures consistency and accuracy in your data processes. Whether you're dealing with complex datasets or simply looking to streamline your reporting processes, this course will equip you with the tools and knowledge to make Excel work for you like never before. Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate
K2’s Office Scripts – The New Macros
Online
2.00 Credits
Member Price: $89
Discover the power of Office Scripts, the game-changing feature that lets you automate tasks in Excel and other Office applications effortlessly. Unlike VBA, which is limited to Windows, Office Scripts run on any platform and device that supports Office on the web. With its modern and intuitive interface, you can easily create, edit, and share your scripts, all stored securely in the Cloud. Office Scripts seamlessly integrate with Office Online apps and Power Automate, enabling you to streamline processes and boost productivity like never before. Say goodbye to repetitive tasks and hello to efficiency with Office Scripts in Excel and beyond! Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate
Current Fraud Trends - Nonprofit and Government Entities
Online
2.00 Credits
Member Price: $89
Nonprofit entities and governmental entities have a high degree of public accountability. This course will examine the most common fraud schemes and provide multiple examples of how to prevent or detect these schemes. Delivery Method: Individual webcast CPE Credit: 2Program Level: Basic
Inventory Accounting GAAP, Software and Recognizing Variances
Online
2.00 Credits
Member Price: $89
Many organizations struggle to keep budgets current in an ever-changing business climate. Twenty-first century performance metrics focus on determining what budgets should be rather than what they were in the past. Using performance metrics effectively reduces work, reduces politics, provides flexibility and substantially improves the performance management process. This session will show you powerful techniques to drive your organization’s performance. Delivery Method: Individual webcast CPE Credit: 2Program Level: Basic
Tax Depreciation: Review and Update
Online
2.00 Credits
Member Price: $89
A discussion of recent law changes that impact capitalization, depreciation, and disposition of assets. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.This course is being offered by a learning partner and will not be accessible on your My CPE page. Access information will be emailed directly to you by CPA Crossings.
See more dates