CPE Catalog & Events
Advanced Excel for Staff - Build Reports and Analyze Data
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Building Reports Workflow: Understand the steps for creating professional and functional reports.Gather and Organize Data: Learn best practices for compiling and cleaning data for accurate analysis.Set Calculations and Key Metrics: Apply formulas and functions to calculate meaningful insights. Format and Structure Report: Use formatting tools to create visually appealing and structured reports.Review and Validate: Verify data accuracy and troubleshoot potential errors.Share the Report: Learn methods for distributing reports effectively within your organization.
ACPEN: Behind the Rx: Demystifying Pharmacy Benefit Management and Creating Transparency
-
Online
2.00 Credits
PBM
ACPEN: New PCAOB Quality Control Standard Overview
-
Online
2.00 Credits
Background of the new PCAOB Quality Control Standard Overview of the elements of a quality control system Examples of quality risks and potential responses Highligts of what is different between the AICPA Quality Management Standard
ACPEN: How to Choose the Right Business Entity for Your Client
-
Online
2.00 Credits
Recent tax legislation and developments related to choice of entity - such as sole proprietorships, single member LLCs, partnership/LLCs, S corporations, and C corporations Impact of the Section 199A deduction Ramifications of the C to S election and the S to C election; Corporate tax rate to individual tax rate comparison examples Other related topics
Ethics and Professional Conduct
-
Virtual
2.00 Credits
Discussion of what makes an ethical dilemma. Review of recent ethical violations Practical applications of the independence and conflict of interest rules Current PCAOB concerns
ACPEN: Data Analytics: Practical Insights for Today's Accountant
-
Online
2.00 Credits
Apply new effective tools in business processes Better understand how to use data analytics in public accounting engagements Identify popular software packages that may be useful for accomplishing data analytics
Surgent's Key Roth IRA and Roth 401(k) Rules for Funding and Tax-free Distributions
-
Virtual
2.00 Credits
Funding options for Roth accounts Roth IRA contribution eligibility and income limits Enhanced catch-up contributions and age-based limits The Roth catch-up mandate for employer plans Roth 401(k) contribution rules, including catch-ups Roth SEP and Roth SIMPLE IRAs 529 plan rollovers to Roth IRAs Backdoor Roth strategies and pro-rata considerations The tax impact of rolling a 401(k) to a Roth IRA Who can start the Roth IRA 5-year clock? The 5-year rules for Roth IRAs and Roth 401(k)s Direct and indirect Roth conversions Direct and indirect rollovers from Roth 401(k) plans Ordering rules for Roth IRA distributions FIFO treatment and when it applies The risk of recapturing the 10% early distribution penalty Case studies and practical cheat sheets to reinforce key concepts
Surgent's Raising Financially Capable Children
-
Virtual
0.00 Credits
Discussion of the importance of financial education for the next generation Understanding a client’s financial values Determining a client’s financial literacy Helping clients develop a teaching roadmap Using knowledge to protect against entitlement Developing a knowledge base for the information, including a full list of recommended books on the topic and games for families to play Discussion of specific topics, including tips and tricks related to: Allowances Earning, work, and entrepreneurship Spending, saving, and investing Philanthropy Taxes Credit cards, crypto, and financial fraud
The CPA's 2026 Guide to Cryptocurrency and Blockchain
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Blockchain technology primerCryptocurrency technology primerUpdate on the cryptocurrency marketplaceCryptocurrency exchanges - the good, the bad and the uglyOverview of cryptocurrency taxation and legislationSmart contracts - what they are and how they work
Surgent's Tax Loss Limitations Imposed on Individuals and Pass-through Entities
-
Virtual
3.00 Credits
How to calculate a partner or S corporation shareholder’s basis Form 7203 and an S corporation shareholder’s basis The at risk basis rules and Form 6198 The passive activity loss limits The Section 461(l) loss rule The net operating loss limitation rules The Section 163(j) business interest limitation New OBBBA changes impacting business interest and Section 461(l)
ACPEN: Mary Jane Hourani’s Federal Tax Update: Individual
-
Online
4.00 Credits
Recent federal tax legislation and proposed changes IRS regulations, rulings, and procedural updates Recent tax-related court cases Application of deductions, credits, and tax benefits for individuals Practical application of tax law changes to individual scenarios
Ethics: 10 Crucial Qualities of High Character CPAs
-
Virtual
2.00 Credits
The major topics covered in this class include:Discover why the ten crucial qualities of high-character CPAs are essential to your successLearn how to evaluate these qualities in job candidates and why you must do so
ACPEN: Generation Intelligence: Navigating the Generational Divide
-
Online
1.00 Credits
Generations
ACPEN: Benefits and Best Practices for Telework
-
Online
2.00 Credits
Communication Business Management
ACPEN: Financial Accounting for Related Party Transactions
-
Online
2.00 Credits
FASB codification provisions for transactions with related parties, including business owners and special purpose entities Compares and contrasts those rules with the AICPA financial reporting framework for small and medium-sized entities Reviews the tax accounting related taxpayer standards Several real-life situations illustrate the various authoritative standards and discuss the consequences of failing to comply with those standards
ACPEN: Microsoft Excel: Moving Beyond the Basics
-
Online
2.00 Credits
Using formulas to manipulate and transform data Using formulas and reference formulas such as =VLOOKUP Using pivot tables Understanding Solver to perform multivariate analysis
Money Laundering Awareness for Accountants
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Money laundering overviewRole of tax examiners and auditorsTax return examinationPre-audit indicatorsAudit flagsReal estate issuesCash indicatorsInternational trade signalsLoan considerationsProfessional service provider concernsMoney laundering and ethics
ACPEN: HR Investigations – Episode 1 – Introduction-Assessing-Planning
-
Online
1.00 Credits
Investigation terminology Assessment skills Investigative methodology
Using ChatGPT with Excel
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Introduction to ChatGPT and other AI (Artificial Intelligence) language modelsDiscussion of best practices for using ChatGPT with ExcelUse ChatGPT to create, debug and explain formulasUse ChatGPT to learn how to use Excel featuresUse ChatGPT to automate repetitive tasks in ExcelUse ChatGPT to easily create macros
ACPEN: Current Fraud Trends - Nonprofit and Government Entities
-
Online
2.00 Credits
Best practices for fraud prevention and detection Common fraud schemes in nonprofit and government entities including cash misappropriation, payroll fraud, vendor fraud, falsified billings, improper use of credit cards or purchase cards, the redirection of cash and non-cash contributions, personal use of assets, the redirection of grant benefits, other grant related fraud, travel and expense reporting fraud
