CPE Catalog & Events
What's Going on at the FASB (2025)
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Accounting Standard Updates effective in 2024 for public entities, private entities, and nonprofits. Review year 2 implications of the leases standard including modification accounting. A look at the projects identified by the FASB's Invitation to Comment: Agenda Consultation.
Surgent's Excel Budgeting Ideas
-
Virtual
2.00 Credits
Set up an in-cell drop-down list of budget methods Change the calculations in the cells based on the selected budget method Use names in worksheets
The Bookkeeper Goes to Prison
-
Virtual
2.00 Credits
The major topics covered in this class include:Career choicesEthical dilemmasJudicial proceedingsMitigation strategiesCreating tools to help make better decisionsAtonement and reconciliation
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
Accounting for the Gig Economy
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Characteristics unique to the gig economyIndependent contractor and employee classification considerationsRecordkeeping considerations for independent contractorsAccounting and reporting issues for gig economy participantsAudit and attestation for clients who participate in the gig economyTax and regulatory considerationsThe CPA as a trusted advisor for independent contractors
Tech It to the Next Level: Slim Your Team for Max Efficiency
-
Virtual
1.00 Credits
The major topics that will be covered in this course include:How to leverage tech and automation to fill workflow gaps, How to build a strong tech stack, and connect tools seamlessly.How one proven tech stack replaced more than half a traditional team while improving client satisfaction and reducing overhead.
ChatGPT: What Every CPA Should Know-Updated
-
Virtual
2.00 Credits
The major topics covered in this course include:Overview of the current landscape for AI in businessHistory of ChatGPT and generative AIFundamentals of generative AI technology and related nomenclatureABC's of how to use ChatGPTDemonstration of practical ChatGPT applications for accounting, finance and taxA word of caution: What you should be concerned aboutDeveloping a ChatGPT usage policy for your firm / business
Surgent's What Practitioners Need to Know About Estate Planning and Administering a Client's Estate
-
Virtual
3.00 Credits
The federal transfer tax exemption What constitutes a valid will Common trust vehicles often used to safeguard assets Consequences of intestacy How to transfer property outside of a will Legal treatment of marital property Transfer of IRAs and retirement plans Probate generally and probate for property held outside of the state of decedent’s residence When an estate tax return should be filed Portability of the Deceased Spousal Unused Exclusion (DSUE) amount
Comprehensive Accounting and Financial Reporting Update
-
Virtual
4.00 Credits
The major topics covered in this class include:CECL for nonfinancial institutions.Accounting for Paycheck Protection Program loans.Accounting for web-hosting services.Revenue recognition.Leases.FASB projects in progress.
Building Security and Efficiency With Internal Control
-
Virtual
8.00 Credits
The major topics covered in this course include:An overview of control frameworks and conceptsStrategic considerations that can be incorporated into control developmentUnderstanding and controlling risk that arises when organizations change or choose not toThe COSO Internal Control Framework and the COSO ERM Framework
About the TIGTA: Who Watches the IRS?
-
Virtual
2.00 Credits
Major topics covered in this course include:The role of TIGTA in the US tax systemAuditing, investigating, and inspecting and evaluating IRS programs and operationsIdentifying opportunities to improve the administration of tax lawsPromoting integrity, economy, and efficiency in the tax systemResponding to requests from Congress and other external stakeholdersUpholding ethical standards in the accounting professionBuilding trust and confidence in the tax system
Finance Business Partnering: A Roadmap to Strategic Influence
-
Virtual
1.00 Credits
The session is organized into five sections addressing the following key topics: 1. The Evolution of the Finance role 2. Defining Business Partnering 3. Building Relationships 4. Business Acumen 5. Strategic Thinking and Problem Solving
Business Tax Update: Recent Developments
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:2024/25 legislation impacting business taxpayersTax depreciation updateGIG workers and Form 1099-KCommercial Clean Vehicle CreditRecent business taxpayer case rulingsFINCEN Beneficial Ownership Information reporting update
Ethics at Work: Diversity, Equity and Inclusion
-
Virtual
2.00 Credits
The major topics covered in this class include:Overview of ethicsEthical values and principlesDEI working definitionsUnconscious bias, assumptions, microaggressionsStanding Up and Speaking OutDEI and Organizational Responsibility
PPP Fraud and Financial Professionals
-
Virtual
2.00 Credits
The major topics covered in this class include:Ethical dilemmasJudicial proceedingsMitigation strategiesCreating tools to help make better decisionsAtonement and reconciliation
2025 Single Audit Update
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Review of the impact of the 2024 Compliance Supplement on Single AuditsReview of the changes to the Uniform GuidanceReview of common audit deficiencies found in Single Audits
Create Measures in Power BI that Define Your Metrics
-
Virtual
4.00 Credits
The major topics that will be covered in this class include:Introduction to DAX: Understanding the fundamentals of DAX and its role in Power BI.Advanced DAX Formulas: Delving into complex DAX functions and formulas for creating sophisticated measures.Time Intelligence in DAX: Exploring time-based functions to analyze data over different periods.Validating Measures with DAX: Techniques for ensuring accuracy and reliability in your DAX measures.Using PivotTables for Measure Validation: Employing PivotTables in Power BI to test and confirm the effectiveness of DAX measures.
Professional Ethical Considerations for CPAs
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Core principles of any Code of Professional Conduct applicable to all CPAs, including conflicts of interest, preparing and reporting information, competence, confidential information, and moreThe importance of maintaining independence for CPAs in public practice, especially when also performing nonattest services for the attest client Comparing and contrasting various ethical standards, including those promulgated by the AICPA, PCAOB, and international bodies
Taking Advantage of Array Formulas in Excel
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Introduction to Array Formulas: This segment establishes the foundation by differentiating array formulas from regular Excel formulas and explaining their significance.Using Array Formulas: This section focuses on the practical application of array formulas, teaching participants how to effectively implement and utilize these formulas in a variety of common Excel tasks and scenarios.Dynamic Arrays and Spill Functions: This part covers the utilization of dynamic arrays and spill functions, highlighting their role in modern Excel data handling.Advanced Array Functions: Participants will delve into complex functions such as SUMPRODUCT, UNIQUE, SORT, and FILTER, focusing on multi-condition summing and data management.Using Array Constants: This section teaches how simplify the use of static values called Array Constants
CFO Solutions to IRS Problems
-
Virtual
4.00 Credits
The major topics that will be covered in this course include:The authority of IRS in assessing and collecting taxes.The common misconceptions when dealing with IRS.Common questionable actions by business owners.How to prepare for an IRS audit.The seven options in IRS collections.Possible criminal tax violations by CFOs and small business owners.
