CPE Catalog & Events
The 10 Must Know Excel Features
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Excel Tables: Master the use of Excel tables for efficient data management, including sorting, filtering, and structured references, to manage data more effectively.Custom Sorting: Get to grips with custom sorting options to organize data in a way that best suits your needs, enhancing data readability and analysis.XLOOKUP: Discover the power of XLOOKUP for advanced data retrieval, a game-changer for complex analysis, allowing you to extract specific data from extensive datasets with ease.SUBTOTAL: Gain proficiency in using the SUBTOTAL function, a versatile tool for calculating data in visible cells, ideal for analyses that require dynamic calculations.SUMIF(S): Explore the functionality of SUMIF and SUMIFS functions for conditional summing, crucial for precise budgeting, expense tracking, and financial reporting.Array Formulas: Dive into array formulas to perform multiple calculations on one or more items in an array, enhancing the efficiency of complex accounting computations.Data Validations: Learn to implement data validations to ensure data integrity and prevent errors in financial data entry, a critical skill for maintaining accurate accounting records.Slicers: Learn to use slicers for interactive data segmentation in tables and PivotTables, enabling accountants to quickly filter and analyze specific subsets of financial data.Conditional Formatting: Understand how to apply conditional formatting to highlight critical financial data points, trends, and variances, making data analysis and interpretation more intuitive.PivotTables: An introduction to PivotTables, one of the most powerful Excel features, for summarizing, analyzing, and presenting large sets of financial data in a digestible format.
Using e-Signature Software to Process Agreements-Updated
-
Virtual
2.00 Credits
The major topics covered in this course include:Review of the digital document signing process.Key features to evaluate in selecting a solution.Review and distinguish top selling e-signature applications.Best practices for deploying e-signature software in your practice or business.
AI Ethics 2025 (VBOA-Approved)
-
Virtual
2.00 Credits
Ethical principles of AI usage. Strategies for ethical decision making. Compliance and governance in AI adoption. Balance of innovation and responsibility.
CFO Series: Changing Corporate Culture: How to Improve it?
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:The eight types of corporate cultures.Determining which culture(s) exist in your organization.How to introduce change in an acceptable way.What are core values, and why they are so important?What kind of culture(s) fits in the organization?Where do you need the culture to develop so the organization can thrive?Why people are so resistant to change?What is the 'right' speed for change?How to grow your team into a better culture.
Navigating IRS Collections: Overview of Form 433 & OIC
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Overview of the IRS collection process and enforcement actions.Initial notices, taxpayer rights, and IRS timelines.When to use Forms 433-A or 433-B and required documentation.Offer in Compromise (OIC): criteria, process, and practical considerations.Payment options: installment agreements, partial payment plans, and OIC.Advising clients on IRS collections and avoiding penalties.Compliance strategies for minimizing tax liabilities.Real-world scenarios and examples for tax debt resolution.
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
Capitalized Costs & Depreciation - Tax Staff Essentials
-
Virtual
5.50 Credits
Tax basis of property acquisitions Initial basis of property acquired in an exchange transaction Materials, supplies, repairs and improvements Accounting method changes Depreciation: MACRS, Section 179 and bonus Intangible assets and amortization Organization and start-up costs Research and experimental expenditures
Ethics: How to Give and Receive Criticism the Right Way
-
Virtual
2.00 Credits
The major topics covered in this course include:Entertaining lecture by a professional presenter, illustrated with relevant video clips and photographs, to cover the main points of the webinarWriting exercises, so you can see how these lessons apply to your own CPA practice and personal lifeTrue stories about CPAs and other leaders to show what can happen when apologies and criticism are done right, and the pitfalls of doing them the wrong way
Partnership/LLC Taxation: Tax Basis Capital Accounts
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Discuss the impact of the Section 199A flow-through entities deduction on partnerships and their partnersThe meaning of a "tax basis capital account"How the financial accounting and tax capital accounts differ from one anotherDetermine a partner's share of the partnership's liabilitiesDistinguish "recourse" loans from "nonrecourse" loansWhat are "qualified nonrecourse financing" loans and how they affect partnersSection 704 "built-in gain or loss" rules and how they impact Schedule K-1 reportingSection 4655 "at risk" rules and how they impact Schedule K-1 reporting
What's Changing in A&A for Governmental Entities (2025)
-
Virtual
4.00 Credits
The major topics that will be covered in this course include:A look at the GASB standards that are effective this year.GASB 100, Accounting Changes and Error Corrections.GASB 101, Compensated Absences.The impact of the 2024 Compliance Supplement on Single Audits.Changes to the Uniform Guidance.Common deficiencies found in Single Audits.
The Ethical Management of Conflict
-
Virtual
2.00 Credits
The major topics covered in this class include:Professionalism, Conflict and EthicsSources and approaches to conflictManaging Conflict from the Inside: Awareness of human tendencies, human emotions, and gossipGuidelines for managing conflict collaboratively
Reasonable Compensation for S Corps
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Explain the payroll tax advantage of taking distributions over wagesReview key court cases that shape todays reasonable compensation landscapeHow to use court factors to stress test reasonable compensationBest practices for determining reasonable compensationReview of the IRS’s enforcement on reasonable compensation; past, present and future
Surgent's Tax Reporting for Executive Compensation
-
Virtual
2.00 Credits
Nonqualified deferred compensation (NQDC) Nonqualified stock options (NQSOs) Incentive stock options (ISOs) Restricted stock/restricted stock units (RSUs) Stock appreciation rights (SARs) and phantom stock Employee stock purchase plans (ESPPs) Applicable tax forms and schedules Stock sale reporting Estimated taxes Filing deadlines and extensions State taxation
Surgent's Understanding S Corporation Taxation: Compensation Issues and Entity-Level Taxes
-
Virtual
2.00 Credits
Reasonable compensation Fringe benefits for S corporation shareholders Built-in gains tax Excess passive income tax Notice 2020-75: PTE elections
Surgent's Avoiding Deficiencies in Peer Reviews: Focus on Engagement Quality
-
Virtual
4.00 Credits
AICPA’s Enhancing Audit Quality initiative Recent revisions to Quality Management standards Feedback from peer reviews, including areas driving deficiencies in audit Elements of an effective risk assessment and how to link to audit procedures performed Understanding internal controls and making the decision whether or not to test them Best practices in documentation
Surgent's Buying and Selling a Business: Tax and Structuring Overview
-
Virtual
4.00 Credits
An overview of the beginning of the process and documents for preliminary tax planning Recognizing the need for due diligence in acquisitions, including checklists of important points Deemed asset sales – §338 and §338(h)(10) The impact of the §197 amortizable intangibles regulations on the acquisition and disposition of a business Allocating purchase price for tax advantage Planning to avoid double taxation under the repeal of the General Utilities doctrine Special problems and opportunities when an S corporation is the buyer or seller Installment sale and interest issues Avoiding tax pitfalls and recognizing tax planning opportunities Unique issues in buying and selling LLC/partnership interests Impact of the net investment income tax (NIIT) and the §199A pass-through deduction on the tax due on the sale of a pass-through entity Individually owned goodwill
Surgent's Examining ASC 842, Leases: More Than Meets the Eye
-
Virtual
4.00 Credits
ASU No. 2016-02, Leases (Topic 842) Overall lease accounting guidance Lessor Accounting 101 Lessee Accounting 101 Detailed review of accounting by lessees and lessors Sale and leaseback transactions Transition guidance Other operational issues Recently issued updates to the lease accounting guidance FASB guidance on accounting for COVID-19-related rent concessions Feedback from the public company adoption of Topic 842
Money Laundering 101 for CPAs
-
Virtual
4.00 Credits
The major topics covered in this class include:The theory of money launderingCommon money laundering statutesExamples from court cases of money laundering statutesCommon occurrences with CPAsPossible money laundering transactionsApplying the money laundering statutes in real life scenarios
Partnership Tax Updates (2025)
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Court decisions covering partnership issues such as TEFRA, Statute of Limitations, Economic Substance, and Sec. 754 Elections.IRS procedural updates on passthrough entities.New developments on conservation easements.
Talk This Way - Communication Skills for the CPA
-
Virtual
2.00 Credits
The major topics covered in this course include:Pervasive best practices for effective communicationSpecific strategies for written materialsUnique considerations for verbal presentationsThe importance of recursive revisionTips for successPitfalls to avoid
