CPE Catalog & Events
Smart Formula Selection in Excel: What to Use When
-
TBD
0.0 Credits
Member Price: $89
The major topics that will be covered in this class include:Introduction to Strategic Formula Use:Why choosing the right formula matters: clarity, performance, and maintenanceCommon traps: overusing IF, defaulting to familiar tools, ignoring modern functionsHow Excel offers multiple ways to solve the same problem and how to pick wiselyConditional Logic and Branching Tools:IFS vs SWITCH vs nested IF: comparing readability and structureWhen to simplify logic and how to avoid nested nightmaresSummarizing Data:SUMIFS vs SUMPRODUCT: multiple conditions, weighted sums, totalsFiltering and Output Control:FILTER vs IF + INDEX: dynamic data extraction with vs without Excel 365Trade-offs in backward compatibility and ease of useCustom Output and Decision Trees:CHOOSE vs SWITCH vs LOOKUP: logic trees and category mappingEmbedded Variables and Reusability:LET vs named ranges: clarity and efficiency for long formulasUsing LAMBDA with LET to create custom functionsSimplifying and documenting complex calculationsBest Practices for Formula Selection:Criteria for deciding: readability, flexibility, future maintenanceTips for avoiding overengineering and formula bloat
Surgent's Government and Nonprofit Frauds and Controls to Stop Them
-
TBD
4.0 Credits
Member Price: $159
Examine real-world misappropriations of cash, check frauds, vendor scams, credit card abuse, grant frauds, benefit schemes, inventory thefts, and payroll frauds Identify and develop practical controls to prevent and detect fraud Tailor controls to the size and fit of the government or nonprofit
ACPEN: K2’s Artificial Intelligence For Accounting And Financial Professionals
-
TBD
4.0 Credits
Member Price: $149
Exploring AI applications in accounting and finance Understanding AI features in everyday tools Embracing the future: AI's impact on finance and accounting
The Role of Internal Control in the Risk-Based Audit
-
TBD
0.0 Credits
Member Price: $149
The major topics that will be covered in this course include:Specific matters auditors should consider when obtaining and documenting an understanding of the client's internal control systemDevelopment of a tailored audit approach that considers the potential reliance on internal controlsGuidance for establishing an adequate basis for reliance on internal controls of less formal, smaller clients
Comprehensive Partnership Taxation Form 1065 26-27
-
TBD
8.0 Credits
Member Price: $329
Special and Targeted allocations Proper calculation of outside and inside tax basis Tax consequences of distributions including the impact of "hot assets" Transfer of partnership interests Issuance of partnership interests to service partners
Financial Reporting Fundamentals 26-27
-
TBD
8.0 Credits
Member Price: $329
Financial statements, disclosures and presentations Review of two Annual Financial Reports (IFRS and U.S. GAAP)
Real Estate Taxation Full Circle 26-27
-
TBD
8.0 Credits
Member Price: $329
Personal residence and vacation home advantages and traps Depreciation, credits, passive losses, qualified business income (QBI) under the One Big Beautiful Bill Installment sales Involuntary conversions Like-kind exchanges Real estate investment trusts (REITs)
Implementing and Maintaining an Internal Control System
-
TBD
0.0 Credits
Member Price: $239
The major topics covered in this course include:Control creation and implementation basicsImplementation and update procedures for an Internal Control systemMaintaining existing internal controls
Surgent's Fiduciary Income Tax Returns – Form 1041 Workshop with Filled-in Forms
-
TBD
8.0 Credits
Member Price: $279
Classifying receipts between “income” and “corpus” under the Uniform Principal and Income Act Calculation of DNI utilizing three different methods, a “forms” method (Schedule B), a “code” method, and a “shortcut” method, utilizing a worksheet of common income and expenses Proper W-2 preparation and procedures in the year of death Taxpayer passes before taking a required minimum distribution; what must be done? Forgetful fiduciaries of simple trusts Fluctuating trusts – Simple one year, complex the next Dividing income in the year of death Overview of Subchapter J Form preparation issues – Filing requirements and line-by-line explanations of Form 1041 Taxable income of estates and trusts and expense allocation issues Specific deductions and miscellaneous itemized deductions Income in respect of a decedent The income distribution deduction calculation Relation of principal and income law to DNI Understanding how to handle capital gains and losses Allocating tax items to beneficiaries: another K-1 Other considerations: excess deductions on termination Comprehensive DNI case study, with principal (cost and FMV) and income reconciliation Comprehensive trust and estate case studies, with filled-in forms
Surgent's Individual and Financial-Planning Tax Camp
-
TBD
8.0 Credits
Member Price: $299
Comprehensive coverage of the One Big Beautiful Tax Bill Act Reading a tax return for developing client-specific tax strategies Changes to the lifetime estate tax exemption considering proposed regulations The net investment income tax: planning for compliance Family income-splitting strategies that need to be considered Income tax issues: impact on timing of other income Selling a principal residence Two principal residences at the same time Use of life insurance to protect families: Whole Life Insurance, Term Life Insurance, Universal Life Insurance, and Variable Life Insurance Using Roth IRAs and Roth contribution programs to best advantage Conversions: do they still make sense? Taking distributions: matching timing to client requirements Qualified plan contributions to reduce current income and Social Security tax: implications for business owners and self-employed Social Security - the latest on the looming solvency crisis Incentive Stock Options and Employee Stock Purchase Plan considerations What to do about itemized deductions Trans-generational planning: conversions, income, and gain-splitting Tax benefits of HSAs and other tax-advantaged accounts Identifying tax opportunities: reviewing the prior-year return to develop a plan for the future Planning for middle-income taxpayers: financial planning for the young, the working, and those approaching or in retirement Best financial planning ideas for young people
Partnership/LLC Taxation: Tax Basis Capital Accounts
-
TBD
2.0 Credits
Member Price: $89
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
Shortcuts that Excel Users Love
-
TBD
0.0 Credits
Member Price: $89
The major topics covered in this course include:The power of keyboard shortcutsOft used features with more capability than meets the eyeNew helpful featuresNote: This session is taught using Hands-On methodology. We provide practice files that tie to the examples in the course materials so participants can undertake all the steps in unison with the instructor.
Managerial Accounting: Your Prescription for Better Decision
-
TBD
0.0 Credits
Member Price: $149
The major topics that will be covered in this course include:Target profit and Break-even analysis.Relevant costs and decision-making.Standard costs and variances.Activity-based costing.Segment reporting and analysis.Budgeting.
ACPEN: World-Class Cost Accounting: A Practical Application - 8 Hour Version
-
TBD
4.0 Credits
Member Price: $250
Classifying the five cost types Direct materials - comprehensive coverage Direct labor - including all labor burden costs Tracing all the prime costs to products Budgeting and setting standard costs Classifying manufacturing overhead costs into 5 cost types Selecting the bases for tracing overhead costs to products Period Manufacturing Inefficiencies cost of sales - categories and costing Segregating inventory for costing and analysis Accounting for variances - budgeting, analyzing, timing for recording
ACPEN: HR Investigations – Episode 1 – Introduction-Assessing-Planning
-
TBD
1.0 Credits
Member Price: $39
Investigation terminology Assessment skills Investigative methodology
ACPEN: Revenue Recognition Topic 606 - Identify Performance Obligations Part 2
-
TBD
1.4 Credits
Member Price: $39
Revenue Recognition Accounting
ACPEN: Sarbanes-Oxley Update - Accounting Risk Assessment considerations - 20 years later
-
TBD
1.8 Credits
Member Price: $79
Sarbanes-Oxley Accounting Risk Assessment
ACPEN: Common Audit and Financial Reporting Deficiencies in State and Local Governments
-
TBD
1.0 Credits
Member Price: $89
Financial Statement Preparation Common Mistakes made in Preparing Financial Statements GASB Financial Statement Preparation Standards
ACPEN: Partnership Essentials: Tax Basis Capital Accounts
-
TBD
2.0 Credits
Member Price: $89
Importance of tax basis capital accounts Reporting negative tax basis Tax accounting for property contributed to a partnership Effect of the Ceiling Rule Allocation of depreciation to partners Alternative and Remedial Methods Effect on financial capital accounts Form 1065, Schedule K-1
ACPEN: Tactical Business Systems – Getting the Most from Information Systems and ERP
-
TBD
2.0 Credits
Member Price: $89
The CFO’s role in IT and systems governance Understanding what IT, ERP, and AI actually do—and don’t do Common system problems and why implementations fail Defining system needs before selecting software Documenting current processes and identifying gaps ERP selection, implementation steps, and risk management Cybersecurity, data security, and technology risk Post-implementation measurement and continuous improvement