CPE Catalog & Events
Excel for Accounting Professionals Session 7: Date-Driven Workbooks and Concatenation
-
Virtual
2.00 Credits
EOMONTH MONTH and YEAR DATE CONCAT basics SUMIFS with CONCAT
Surgent's Ethics for Tax Professionals
-
Virtual
2.00 Credits
What does practicing before the IRS mean? Who may practice before the IRS? What should a tax preparer do if he or she has knowledge of a client's omission of income from a tax return? May a tax preparer rely on the work of other tax return preparers? May a tax preparer rely on and use client-provided information? Standards associated with giving advice to clients Abolition of the disclaimer requirement When must a tax preparer examine a client’s books and records?
Surgent's 2025 Tax Update for Client Advisory Services
-
Virtual
4.00 Credits
Common tax deadlines and penalties Employee Retention Credit – new developments Beneficial ownership information reporting Bonus depreciation changes Form 1099 reporting and changes Online accounts and IP PINs Virtual currency updates Green energy credit compliance
Surgent's Auditing 401(k) Plans: Critical Issues and Annual Update
-
Virtual
4.00 Credits
Key requirements of recently issued SASs Changes affecting 401(k) plans Audit strategy and improving overall efficiency Common mistakes as noted in peer reviews and DOL inspections
Surgent's Essential Depreciation and Expensing Update
-
Virtual
4.00 Credits
Resolved technical glitches for qualified improvement property Detailed coverage of §179 expense elections and §168(k) bonus or additional first-year depreciation – how to maximize them, definitions, limitations, qualified property, etc. Sale of property and the depreciation recapture rules (§1245, §1250, unrecaptured §1250 gain for real estate, §291 for corporations) MACRS depreciation – finding the proper method, convention, and recovery period Listed property and the current limitations Amortization of start-up, organization, and other expenditures AMT depreciation adjustments and how to avoid them Examples, cases, and rulings of depreciation and amortization issues and how they impact clients, along with useful planning opportunities
Tax Season Update for Individuals with Steve Dilley
-
Virtual
4.00 Credits
The major topics covered in this class include:2024/25 legislative developments, cases and rulings impacting individual taxpayersChanges to Form 1040 and other related forms, worksheets and schedulesIndividual income items, itemized deductions and creditsUpdated tax rate schedule and other inflation adjusted itemsImplications for self-employed taxpayers of various legislationSection 199A changes, including use of carryforward passive activity and 199A lossesCapital gains and lossesPassive activity and hobby loss rules changes
2025 Annual Update for Governmental Accountants & Auditors
-
Virtual
8.00 Credits
The major topics that will be covered in this course include:GASB 100, Accounting Changes and Error Corrections.GASB 101, Compensated Absences.Yellow Book and Single Audit engagements.Yellow Book independence requirements.Changes to the Uniform Guidance.2024 Compliance Supplement and the common deficiencies identified by the federal agencies and peer reviewers.
Leases: Mastering the New FASB Requirements
-
Virtual
8.00 Credits
Lease classification Amortization of the lease asset Derecognition of the underlying asset Recognition of lease receivables Lease modifications Sale and leaseback transactions Presentation and disclosure requirements
The Best Federal Tax Update Course by Surgent
-
Virtual
8.00 Credits
Comprehensive coverage of the Inflation Reduction Act, including: The Clean Vehicle Credit, Credit for Previously Owned Clean Vehicles, Credit for Qualified Commercial Clean Vehicles, Residential Clean Energy Credit, Energy Efficient Home Improvement Credit, Premium Tax Credit, Elective Payment, Transferability, and Prevailing Wage and Apprenticeship Requirements Comprehensive coverage of the SECURE 2.0 Act, including: Expanding Enrollment in Retirement Plans, Increase in Age for Required Beginning Date for Mandatory Distributions, New Exceptions to Penalty-Free Withdrawal from Retirement Plans, and recent IRS guidance Timely coverage of breaking tax legislation Form 1099-K reporting requirements Detailed analysis and examples of Sale of Passthrough Entity Interest and Net Investment Income Tax The Gig Economy -- Tax implications, Independent Contractor vs. Employee Classification, and the DOL Final Rule FinCEN reporting requirements under the Corporate Transparency Act Employee Retention Tax Credit updates Practice aids, including all the numbers applicable for the current year -- inflation-adjusted amounts, mileage rates, retirement contributions, and more Advanced practice, reporting, and other issues intertwined with advanced planning and discussion ideas
How SAS Nos. 134-145 Improve Risk-Based Audits
-
Virtual
4.00 Credits
The major topics that will be covered in this class include:Key changes to audit report elements intended to improve the understandability of the nature and results of financial statement auditsEnhanced required by-product communications with management and those charged with governance to promote more reliable financial statementsClarifications related to obtaining sufficient and appropriate audit evidence, including significant unusual transactions, related parties, going concern uncertainty, and accounting estimatesNew definitions and requirements related to identifying and evaluating risks of material misstatementOther important matters contained in SAS Nos. 134-145
GPT Builder for Accountants
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Introduction to GPT Builder platform and interface for accounting professionalsCreating accounting-specific custom instructions and knowledge basesImplementing financial data analysis capabilities through GPTsDesigning GPTs for tax preparation assistance and compliance checkingBuilding client communication tools with accounting terminologyEnhancing bookkeeping efficiency with automated GPT workflowsSecurity and confidentiality considerations for financial data
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
Surgent's Advanced Critical Tax Issues for S Corporations
-
Virtual
8.00 Credits
Final regulations on “eligible terminated S corporations” (ETSCs) Cases, rulings, and tax law changes affecting S corporations Compensation planning in S corporations, including limitations in a family-controlled business; self-employment tax issues, including IRS efforts to address underreporing of S corporation officer compensation Use of redemptions: still some advantages Planning for the liquidation of an S corporation Tax issues for family ownership of S corporation stock Impact of the tax on net investment income on sales of S corporation stock Stock basis: Loss limitations, AAA, and distribution issues in depth Debt basis: what the regulations on back-to-back loans mean to investors Estate planning for S corporation shareholders, including buy-sell agreements, QSubs, ESBTs, and uses of life insurance Built-in gains: the 5-year recognition period S corporation structuring: one class of stock Methods of accounting Legislation on mortgage interest reporting, basis, statute of limitations, and tax return due dates
Everyday Ethics at Work: Don't be the Next News Story!
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Discuss ethics from an every-day real-world perspectiveHow to prevent an ethical lapse that can turn your business into the next news story
How SAS Nos. 134-145 Improve Risk-Based Audits
-
Virtual
4.00 Credits
The major topics that will be covered in this class include:Key changes to audit report elements intended to improve the understandability of the nature and results of financial statement auditsEnhanced required by-product communications with management and those charged with governance to promote more reliable financial statementsClarifications related to obtaining sufficient and appropriate audit evidence, including significant unusual transactions, related parties, going concern uncertainty, and accounting estimatesNew definitions and requirements related to identifying and evaluating risks of material misstatementOther important matters contained in SAS Nos. 134-145
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.
Excel for Accounting Professionals Session 8: Dynamic Headers, Mapping Tables and Error Check
-
Virtual
3.50 Credits
Dynamic headers Horizontal reports Mapping Tables Data Validation Improve error checking Concepts applied
Integrate ChatGPT into Your Client Advisory Services-Updated
-
Virtual
2.00 Credits
The major topics covered in this course include:ChatGPT and generative AI technology primerBuilding your generative AI vocabularyDig deeper into your engagement research to develop a higher quality advisory servicePolish your client reporting with the help of ChatGPTDeveloping your ChatGPT client advisory servicesStart with client education. You don’t need to be a technical expert to be an educatorUse AI to help your clients automate their workflows / business processesBuild better spreadsheets with ChatGPT and ExcelHelp your clients identify, evaluate and select applications for their business
Disrupt to Dominate: Mastering Change Leadership
-
Virtual
4.00 Credits
The major topics that will be covered in this course include:The urgency of leading change now & the steps in leading changeThe power of crafting a vision that encourages buy-inThe art and science of building strong partnershipsAccelerating change through relationship networksCommunication strategies for changeEstablishing a feedback culture for successful changeManaging self in times of changeCase studies and real-world scenarios
Invest in Your Mental Health and Avoid Burnout
-
Virtual
2.00 Credits
The major topics covered in this course include:How to recognize burnout and evaluate where you are on the burnout scale.How impostor syndrome drives coping reactions of overworking, over preparing and perfectionism.How mindfulness can reduce stress and save time.Silencing the critical inner voice.Tools to help you become more attuned to your needs and emotions.How attending to and regulating your nervous system impacts your mood and well-being.
