CPE + Events Catalog
Surgent's Excel Lookups: Moving Beyond VLOOKUP Limitations (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $99
See more dates
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.
More Dates
Surgent's Found It! Reporting Findings in Yellow Book and Single Audits (2 hours)
-
Online
2.0 Credits
Member Price: $99
See more dates
When auditors detect findings in Yellow Book and single audits, they do not just communicate them in some shabby little letter to management; they get reported! In this course, we will examine what types of findings get reported, how they get reported, and where they get reported! This course will take you from just checking a box and fulfilling a requirement to developing and delivering findings that make a meaningful difference to your clients.
More Dates
Surgent's Top Individual Tax Planning Strategies (2 hours)
-
Online
2.0 Credits
Member Price: $99
See more dates
The Inflation Reduction Act (IRA) and SECURE Act 2.0 both contained tax law changes that impact many individuals in 2025 and in later years. This program covers many of these changes as well as other tax topics that continue to impact individual income taxpayers.
More Dates
Surgent's Virtual Currency: Keeping Up with the Tax Code (2 hours)
-
Online
2.0 Credits
Member Price: $99
See more dates
Whether you are an experienced veteran or new to the industry, one of the toughest parts of being a tax practitioner is keeping up with all of the changes in tax legislation. This course takes a look at recent changes to tax law from a practitioner perspective. In this session, we will explore the nuances of virtual currency and the new Form 8300 reporting requirements.
More Dates
2025 Accounting & Auditing Update (3 hours)
-
Online
3.0 Credits
Member Price: $99
See more dates
Stay informed and prepared with this comprehensive annual update on the latest developments in accounting and auditing. We'll begin with a deep dive into the Accounting Standards Updates (ASUs) effective in 2025, followed by insights from the FAF's 2024 PCC Review and an overview of FASB's Invitation to Comment - Agenda Consultation, which will shape the future of accounting standards. On the auditing side, we'll tackle the essential changes in quality management standards that firms must implement by the end of 2025. The session will also highlight common deficiencies identified by the DOL in EBP (Employee Benefit Plan) engagements and provide a peek at upcoming projects from the Auditing Standards Board (ASB). Join us to gain practical insights and actionable takeaways to navigate these updates with confidence.
More Dates
Forensic Accounting: Finding Hidden Treasure in Tax Returns (4 hours)
-
Online
4.0 Credits
Member Price: $149
See more dates
Almost every business and individual has to file tax returns, which can be a great treasure trove of information for forensic accountants. Whether in a divorce, partnership dispute, recreating books and records, or bankruptcy proceeding, analyzing tax return information should be an initial step in uncovering income and assets. The IRS retains a large amount of information, both from taxpayers and 3rd parties who report financial transactions. This course will be your guide in gathering, analyzing, and evaluating tax return information, so that you have a full picture of the financial investigation. Your presenter is a 20 year veteran with IRS-Criminal Investigation, who used this information as a basis for his federal criminal investigations. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
IRAs - Contributions & Distributions for Traditional, Roth, SEP & SIMPLE IRAs
-
Online
8.0 Credits
Member Price: $300
See more dates
This comprehensive training is designed to get the accountant up to speed quickly with the different types of individual retirement accounts (IRAs). The cornerstone of the course is an in-depth coverage of the contribution and distribution rules to the Traditional, Roth, Simplified Employee Pension (SEP) and Savings Incentive Match Plan for Employees (SIMPLE) IRAs. The course will also discuss the basics of the health savings account (HSA) as well as any newly enacted tax legislation related to IRAs. **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
More Dates
ACPEN Signature 2025: Financial Statement Preparation: Compilation and Review Update
-
Online
8.0 Credits
Member Price: $250
This course is designed to assist CPAs who perform financial statement preparation, compilation, or review engagements. Our panelists will provide an in-depth analysis of the SSARS and will provide practice tips that will assist you in performing profitable standard compliant engagements.
Coaching the Next Generation of CPAs (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
Attracting and retaining staff is critical to an organization's success, especially in the age of the millennial worker who will change jobs multiple times in the course of a career. This course will focus on best practices for nurturing the human element of your organization, especially millennial workers who comprise a growing percentage or the workforce. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Digging Deep with Excel Pivot Tables (1 hour) [NT]
-
Online
1.0 Credits
Member Price: $39
See more dates
This session focuses on the power of pivot tables within Microsoft Excel. We initially discuss the creation of pivot tables and various ways to summarize information. Then we explore ways to utilize summarized pivot table data. The course uses several practical examples that should inspire participants to find their own creative uses for pivot tables.
More Dates
Revenue Recognition - Topic 606 Disclosures (1.2 hours)
-
Online
1.2 Credits
Member Price: $39
See more dates
The standard also requires information about the following categories: disaggregation of revenue contract balances performance obligations This webinar will deal directly with disclosure requirements for the standard. Several courses currently exist on the platform related to an overview of the standard and deep dive into individual steps of the standards.
More Dates
How to Gain Efficiencies in Your Accounting Processes and Program Operations (1.5 hours)
-
Online
1.5 Credits
Member Price: $99
The current economic environment has changed how organizations view their accounting operations. Your business faces challenges that could lead to valuable opportunities for streamlining through automation, outsourcing and technology. In this webcast, accounting professionals will share insights from their experiences, including 10 key tips to keep financial reporting and accounting running smoothly during times of change and turnover. This webcast is a rebroadcast from the 2024 AICPA & CIMA Not-For-Profit Industry Conference.
Like-Kind Exchanges (2.2 hours)
-
Online
2.2 Credits
Member Price: $79
See more dates
Please join us for a discussion on like-kind exchanges (LKE), known as one of the last great tax legal “shelters” available to those buying and selling real property. We will be covering the basic structure of a LKE, and ways a taxpayer can utilize qualified third party intermediaries (QI), tenancy-in-common structures including Delaware Statutory Trusts (DST). We will also explore creative solutions to sticky situations a taxpayer may find itself in obtaining replacement property. **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
More Dates
Securing Your Data with a Password Management App - Updated (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
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.
More Dates
Clarifying Risk Assessment – SAS 145 and Beyond 25-26 (4 hours)
-
Online
4.0 Credits
Member Price: $175
See more dates
This course is designed to refresh your understanding of the critical importance of risk assessment in the audit practice. We'll briefly discuss the impact of AICPA's Clarity Project for audits and the need to update firm processes to incorporate the risk assessment standards. Participants may alternatively need to fine-tune an implementation of the risk assessment standards. These standards are designed to eliminate the connect-the-dots methodology of checklist auditing and add critical thinking back into the audit process. They remain a problem area for many firms, resulting in engagement and peer review deficiencies. This course has been updated to include a more in-depth discussion of SAS No. 145, Understanding the Entity and Its Environment and Assessing the Risks of Material Misstatement. We will break down this complex and misunderstood subject with an easy-to-understand approach.
More Dates
Form 5500 Annual Update 25-26 (4 hours)
-
Online
4.0 Credits
Member Price: $175
See more dates
It's essential to stay current on Form 5500 filing rules and requirements. Get a practical review of Form 5500, including 5500SF and 5500EZ. We'll discuss the changes for 2025 and how different government agencies use the form to target enforcement efforts. We'll review the related schedules, how to report late contributions, and what to do if your clients miss a filing deadline.
More Dates
Fraud?How to Find, How to Prevent 25-26 (4 hours)
-
Online
4.0 Credits
Member Price: $175
See more dates
Participants will review how to maintain a heightened awareness of fraud with clients and gain a better understanding of how to detect fraud. This interactive workshop, designed for practitioners in small and medium-sized CPA firms, will include a lecture with generous time for questions and case studies to reinforce the concepts.
More Dates
Lease Implementation for Private Entities 25-26 (4 hours)
-
Online
4.0 Credits
Member Price: $175
See more dates
The Financial Accounting Standards Board (FASB) has issued a new accounting standard for leases. This new standard?ASC Topic 842?replaces the existing ASC Topic 840, changes the accounting for operating leases (requiring capitalization in the financial statements), and upgrades many other lease accounting and reporting aspects.
More Dates
Tax Planning for Seniors 25-26 (4 hours)
-
Online
4.0 Credits
Member Price: $175
See more dates
Seniors face issues that complicate return preparation and planning. For example, when should they apply for social security? How is it taxed? What if they continue to work? Will an increased standard deduction affect charitable planning? What about downsizing? How can they help children or grandchildren pay for a home or a college education? This course will help you advise your clients on these topics and more.
More Dates
The Generation-Skipping Transfer Tax and Dynasty Trusts 25-26 (4 hours)
-
Online
4.0 Credits
Member Price: $175
See more dates
Transfer taxes, such as the estate and gift tax, create a drag on the accumulation of wealth over a family's generations. The government promulgated the generation-skipping transfer (GST) tax to discourage avoidance of the estate and gift tax by families. Randy Gardner explores: GST tax terminology, how the GST tax is calculated, ways to avoid the GST tax, and how to design a dynasty trust to pass property from generation to generation.
More Dates
