CPE Catalog & Events
Get started with Power BI
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Overview of the Power BI Tools: Introduction to the Power BI ecosystem, including Excel’s Power BI features (Power Pivot and Power Query) and standalone tools (Power BI Desktop, Power BI Service, Power BI Report Builder and Power BI Report Server).Tour of the Tools: Introduction to the interfaces of Power Pivot, Power Query, Power BI Desktop and Power BI Services.Comparative Analysis: Understand the strengths and limitations of Excel’s Power BI features versus standalone Power BI tools.Strategic decision-making on when to use each tool for optimal efficiency and accuracy in data analysis tasks.
ACPEN: Are You Qualified? The Ethics of Practice Development and Skill Enhancement
-
Online
2.00 Credits
The Catch-22 of Practice Development and Skill Enhancement The Ethics of Education and Experience Requirements Examples of Skill-Expansion Resources Practice- and Skill-Expansion Cases to Consider Conclusion
AI & Accounting in Construction
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Overview of AI adoption in constructionPredictive analytics and risk managementAI-integrated Building Information Modeling (BIM)Real-time compliance and financial reportingTaxation challenges in AI-driven constructionAI in project scheduling, supply chains, and quality controlRegulatory frameworks and ethical AI use in audits
ACPEN: Partnership Checkup: Tax Issues & Forms Reporting
-
Online
4.00 Credits
Clarify the importance of partnership capital accounts and partnerships debt on partner's tax basis Impact of contributed property Explain the importance of shareholder loans to the entity Discuss how basis is impacted by distributions of corporation property and the sale/or liquidation of the S corporation interest Comprehensive examples illustrate the mechanics of the basis determination process Discusses how S corporation losses impact Form 1040 Schedule E reporting How to get from the Schedule K-1 information to the basis calculations
Tax Implications of Retirement Plan Distributions
-
Virtual
1.00 Credits
The major topics that will be covered in this course include:Required minimum distributions for a deceased’s heirs2025 retirement plan contribution limitsRequired minimum distributions and contributions to charityKey provisions of Secure Act 2.0
ACPEN: K2’s Better Reporting With QuickBooks Online
-
Online
1.00 Credits
The types of reports available in QuickBooks Online, by subscription level Customizing reports to meet your needs Spreadsheet Sync in QuickBooks Online Advanced
AICPA's New SSTS #4 - New Ethics Standard for Tax Resolution
-
Virtual
1.00 Credits
The major topics that will be covered in this course include:This session will provide a comprehensive overview of the ethical guidelines outlined in Circular 230 and the newly updated Statements on Standards for Tax Services (SSTS) #4. Gain insights into how these standards apply to real-world tax resolution scenarios, ensuring compliance and integrity in your practice.
ACPEN: A Guide to Sampling - Part 1
-
Online
2.00 Credits
Auditing Yellowbook
ACPEN: Real Estate Professionals: Passive Activity, Sec. 199A and Investment Income Tax
-
Online
2.00 Credits
Definition, pros and cons of being a real estate professional Integration of the real estate professional rules with reporting on Form 1040, Schedule E Real estate professionals and indirectly owned (partnerships, S corporations) entity’s reporting on Form 1040 How ""real estate business"" is interpreted under the Section 199A rules and how it integrates with the passive activity rules Real estate professionals and the Form 8582 (Passive Activities) How to make the ""grouping"" election for passive activities and the flow-through deduction
Surgent's Build an AI Agent With ChatGPT: A Hands-on Lab for Financial Professionals
-
Virtual
0.00 Credits
Agentic simulation using prompt design and structured interaction Flipped agent/user roles in ChatGPT (autonomy emulation) Use case walkthroughs: audit Q&A bot, tax helper, financial planning agent Risk scenarios: hallucinations, scope creep, prompt hacking Governance, professional skepticism, and documentation best practices
Surgent's Tax Planning for Rental Real Estate
-
Virtual
4.00 Credits
Rental activities and passive activities Material participation Real estate professional status Active participation status Depreciation recapture – Sections 1245, 1250, and 291 Vacation homes rented out QBI deduction and rental properties Section 1237 safe harbor for divided parcel sales Practitioner considerations
Applying the Uniform Guidance in Your Single Audits
-
Virtual
8.00 Credits
Introduction to single audits Preparation of the schedule of expenditures of federal awards and determining major programs Understanding, assessing, and testing internal control Testing compliance with federal statutes and regulations and applicable compliance requirements Auditor reporting in a Uniform Guidance compliance audit Program-specific audits Administrative requirements and cost principles in a single audit
Finance and Innovation: Reinvent Your Organization and Dept.
-
Virtual
8.00 Credits
The major topics that will be covered in this course include:What is innovation?The different forms of innovation, e.g., sustaining and disruptive.The five discovery skills needed to be innovative?The value of why we need to find ways to say, “Yes!” How to change your processes, rules and departments to be more innovative? Lessons learned from innovative businesses with examples.How does innovation happen and how to make innovation stick?The need to improvise and embrace broad experiences.
Individual Tax Update: OBBA and Recent Developments
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Legislation impacting individual taxpayersThe One Big Beautiful Bill ActExtenders legislation updateChild tax and dependent care creditsSection 199A deductionCapital gains and lossesRental real estateOther passive activities losses
ACPEN: Maximizing the Tax Benefits of an Installment Sale
-
Online
1.00 Credits
Installment sale treatment eligibility When to elect out of installment sale treatment Installment sales of business assets Installment sale default and the rules for personal property vs real property Depreciation recapture
Surgent's Section 754 Step-Up in Basis: Understanding the Tax Issues for Partnerships and LLCs
-
Virtual
2.00 Credits
How and why a partnership makes a 754 election The effect of the 754 election when an interest in a partnership is sold or inherited How the 754 election applies when a partnership makes a distribution of property to one or more of its partners How to make the 754 basis adjustment
ACPEN: The Essential SSARS Update with Renee Rampulla
-
Online
4.00 Credits
Preparation Engagements Compilation Engagements Review Engagements Quality Management Components Common Accounting and Reporting Issues Frequent Peer Review Matters
Common Deficiencies in SSARS Engagements
-
Virtual
4.00 Credits
The major topics that will be covered in this course include:Frequent problem areas in preparation, compilation, and review engagementsThe root causes of noncompliancePractical approaches firms can use to improve consistency, documentation, and overall engagement performance
ACPEN: Audit & Attest Quality Matters that Should be on Your Radar – Avoiding Common Deficiencies in SAS, SSARS and SSAE Engagements
-
Online
8.00 Credits
Applying professional skepticism to ensure quality work Meaningful risk assessment when designing work programs for various levels of services Proper planning and supervision of all engagements Accountant responsibilities for evaluating internal control Strengthening analytic procedures to support conclusions Complying with the Code of Professional Conduct and quality management standards
Finding Errors in Excel Spreadsheets
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Understanding Common Excel Errors: Gain insights into the most common types of errors encountered in Excel, including formula errors, reference errors, and logic errors.Advanced Formulas and Functions: Learn to use advanced Excel functions and formulas that are crucial for error detection and data analysis.Data Validation Techniques: Master the art of data validation to prevent errors before they occur. This includes setting up data validation rules and using conditional formatting to highlight potential inaccuracies.Error Tracing and Auditing Tools: Delve into Excel's auditing tools to trace and fix errors. Learn to use Trace Precedents, Trace Dependents, and the Error Checking tool effectively.
