CPE Catalog & Events
ACPEN: K2’s Excel Tips – Today’s Best Features
-
Online
2.00 Credits
New features and functions in Excel How to improve efficiency and effectiveness when working in Excel Taking advantage of Copilot integration with Excel Better ways of creating and working with formulas
ACPEN: Cash Flow Clarity: Effectively Communicate Cash Flows for your Board and C-Suite
-
Online
2.00 Credits
The importance and structure of the cash flow statement Understanding operating, investing, and financing activities Presenting the statement using the "Sources and Uses" approach How to tell the business story through cash flows and alternative reporting methods Identifying key drivers of cash and liquidity Bridging the gap between accrual accounting and understanding cash Communicating effectively with CEOs, boards, and non-financial stakeholders
Surgent's Employee vs. Independent Contractor: Achieving Success in a Worker Classification Audit
-
Virtual
2.00 Credits
The 20 common law factors in a worker classification audit that are used to distinguish an employee from an independent contractor How disgruntled independent contractors can use IRS Form 8919 against a former employer When and how to use §530 as a defense in worker classification audits What is "industry practice" for §530 purposes Common sense steps that will avoid the recharacterization of workers treated as independent contractors to employees The IRS’s Voluntary Classification Settlement Program — advantages and disadvantages The DOL Final Rule
Surgent's Excel Budgeting Ideas
-
Virtual
0.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 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.
ACPEN: Expand Your Analytical Toolbox More Tools for Success
-
Online
4.00 Credits
5 step valuation process 2 specific valuation approaches The Gordon Model 10 thoughts on banker selection Rating your bank 10 hints for keeping your toolbox full
ACPEN: 2026 Tax Season Update for Individuals with Steve Dilley
-
Online
4.00 Credits
Update and integration of recent tax legislation impacting 2026 individual returns Update on significant individual tax developments related to cases and rulings Individual tax changes including the earned income credit, child credit, and child and dependent care credit Section 199A changes, including use of carryforward passive activity and 199A losses and latest tax forms Crypto reporting update 2027 tax rate schedule and other inflation adjusted items Passive activity and hobby loss rules changes
Surgent's Advanced Critical Tax Issues for S Corporations
-
Virtual
8.00 Credits
Inclusion of OBBBA (One Big Beautiful Bill Act) provisions that are germane to this course 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 New cases on revocation of S election in bankruptcy court and documentation of open account indebtedness and Chief Counsel Advice on carryover of losses for ESBTs
Untying the Knot: Taxes & Divorce
-
Virtual
8.00 Credits
The major topics that will be covered in this course include:Filing Status: Determining the correct filing status during and after divorce.Qualified Domestic Relations Orders (QDROs): Tax implications of dividing retirement accounts.Back Taxes: Strategies for addressing unpaid tax liabilities during and after divorce.Offers-in-Compromise & Installment Agreements: Resolving tax debts with the IRS.Currently-Not-Collectible Status: Understanding when and how to use this option.Innocent Spouse & Injured Spouse Relief: Protecting clients from unfair tax liabilities.Lien Discharges & Subordinations: Managing IRS liens on property during divorce.Reasonable Compensation: Evaluating fair compensation in divorce-related business valuations.Case Studies: Explore unusual and complex tax issues in divorce through real-world examples.
Adobe Acrobat Tips for Working with PDF Files
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Review of all that Adobe Acrobat has to offerOrganizing your PDFs with bookmarks, links, file attachments and moreFormatting the presentation of PDFs with headers, footers and watermarksCreating and processing fillable formsProcessing documents for e-signatureTips for converting email messages, documents and spreadsheets into PDF formatCombining multiple PDF files into a single binder Utilizing the security features of Adobe Acrobat to protect document confidentiality
Ethics: Giving Thanks - How to Master the Art of Gratitude
-
Virtual
2.00 Credits
We'll explore what gratitude is and how expressions of it can vary from culture to culture. We'll also unpack several ways you can regularly say "thank you" to valued clients and colleagues, and we'll examine methods for evaluating gratitude in prospective and current employees.
Lessee and Lessor Accounting
-
Virtual
2.00 Credits
Lessee and lessor accounting models Lease and non-lease components Lease classifications Initial and subsequent measurement of leases
Surgent's Purchase and Sale of a Residence: Critical Tax Issues
-
Virtual
2.00 Credits
General rules relating to the sale of a residence under § 121 Sale of a taxpayer’s main home Qualifying for a partial exclusion of gain on the sale of a home How a taxpayer meets the residence requirement Meeting the look-back requirement Separated, divorced, and widowed taxpayers Work-related moves and unforeseeable events Inherited homes and homes received in a divorce Impact of business or rental use of home on the gain exclusion Reporting gain or loss on the sale of a home
Self-Rental Real Estate: Passive Activity & Section 199A
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Definition of self-rental property - both for Sections 199A and 469Self-rental income from directly owned properties and reporting on Form 1040, Schedule E, page 1Self-rental income from indirectly owned (partnerships, S corporations) and reporting on Form 1040, Schedule E, page 2Form 8582 (passive activity)The flow-through entity grouping electionIllustrative examples and consequences of failing to comply with the reporting standardsSelf-rental property and "former passive activities" rules
ACPEN: K2's Taking A Fresh Look At Teams
-
Online
2.00 Credits
How Teams got to where it is today Major components in Teams Collaboration options Extending Teams functionality
ACPEN: Metrics Which Every CFO, Controller and CPA Advisor Should Know
-
Online
2.00 Credits
Overview of financial metrics Ratios versus key performance indicators Purpose and use of metrics Balance sheet metrics Cash flow and liquidity metrics Profitability metrics Operational metrics Use of metrics in analysis
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
Risk Assessment Under SAS No. 145
-
Virtual
2.00 Credits
Risk assessment under SAS No. 145 Overview of the steps to perform during risk assessment Testing the design, implementation, and operating effectiveness of controls New concepts due to the issuance of SAS No. 145
ACPEN: 2026/27 Not-for-Profit Accounting & Auditing Update
-
Online
4.00 Credits
Accounting Standards Updates (ASUs) affecting not-for-profit organizations Introduction to and comparison of the International Non-Profit Accounting Standard (INPAS) U.S. GAAP considerations for NFP financial reporting AICPA auditing and attestation updates Quality management: monitoring and remediation responsibilities Updates to SSAEs, SSARSs, and group audits
ACPEN: Fringe Benefits & Compensation Planning - Today and Beyond
-
Online
8.00 Credits
Fringe Benefit Planning Fundamentals Strategies Tailored for Business Owners and Employees Navigating IRC §132 Fringe Benefit Option Cafeteria Plans Demystified Tax Management in Compensation Planning Understanding the Implications of Dependent Care and Educational Assistance Plans Implementing Flexible Spending Account Plans Effectively Design Features and Regulations of Group Term Life Insurance Plans Medical Savings Accounts Regulations Financing Options for Retiree Medical Benefits Health Care Benefits: Insured Plan vs. HMO Comparison ERISA Reporting and Disclosure Requirements IRC Common Control RulesOverview of Age and Sex Discrimination Rules
