CPE Catalog & Events
Smart Formula Selection in Excel: What to Use When
-
Webinar
2.00 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 Understanding S Corporation Taxation: Shareholder Basis, AAA, and Retained Earnings
-
Webinar
2.00 Credits
Member Price: $99
S corporation earnings layers Observations on earnings layers S corporation basis calculation IRC 351 transactions Four loss tiers Appreciated property distributions
Surgent's Government and Nonprofit Frauds and Controls to Stop Them
-
Webinar
4.00 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
Surgent's Required Minimum Distributions: Compliance and Planning
-
Webinar
4.00 Credits
Member Price: $159
Minimum distribution requirement changes by the SECURE Act 2.0 Latest IRS guidance, including final regulations The calculation of required minimum distributions using the Uniform Life Table Required minimum distributions from multiple accounts New §401(k) rules of SECURE Act 2.0 Inherited employer retirement accounts and IRAs: Changes to spousal and non-spousal beneficiary distribution options and stretch IRAs under the SECURE Act Required minimum distributions in the year of death Roth conversions for estate planning and avoiding required minimum distributions Timing of distributions for maximum tax-free compounding Section 529 rollovers to Roth accounts under SECURE Act 2.0 Qualified charitable distributions from IRAs and the relationship between deductible IRAs and QCDs under the new anti-abuse rules. Includes SECURE Act 2.0 rollovers to CRUTs and CRATs Taxation of distributions Penalties for missed required minimum distributions and reasonable cause for abatement of penalties. Includes SECURE Act 2.0 changes
ACPEN: Federal Tax Update for Business with Doug Van Der Aa
-
Webinar
4.00 Credits
Member Price: $149
"Tax-mageddon" - the all-important impending expiration/extension/renewal of the TCJA Other recent legislative, judicial, and IRS developments impacting business taxpayers Current status of Research and Experimentation costs and Interest Expense Limitation Phaseout of Bonus Depreciation and MACRS issues S corporation and partnership developments Other miscellaneous business developments
ACPEN: Partnership Essentials: Review & Update
-
Webinar
4.00 Credits
Member Price: $149
Recent legislative, rules and tax developments impacting partnerships and their partners Transfer of partnership interests TCJA §461(l) Excess Business Losses and §163(j) Business Interest Expense Importance of capital accounts Form 1065, Schedules K-1 and M-2 Schedules K-2 and K-3 update Reporting partner capital accounts Effect of the Ceiling Rule Alternative and Remedial Methods Effect on financial capital accounts Tax basis capital accounts
Master the Art of CPA Communication: Boost Your Influence!
-
Webinar
4.00 Credits
Member Price: $149
The major topics that will be covered in this course include:Techniques for simplifying complex financial information for clients and stakeholdersPersuasive communication principles aligned with CPA rolesBuilding and maintaining trust and credibility with diverse stakeholdersCase studies and Interviews with Finance, Accounting and CPA professionalsDeveloping empathy and emotional intelligence in communicationsBest practices for active listening to strengthen client relationshipsApplication of Influencer principles for impactful change in communication
Comprehensive S Corporation Taxation Form 1120S 26-27
-
Webinar
8.00 Credits
Member Price: $329
Learn how to qualify and to make the S corporation election Determine how to calculate initial and annual stock and debt basis amounts and the three reasons why they are maintained Understand the four loss limitation rules applied on the shareholder's individual income tax return (i.e., basis, at-risk, passive, and excess business loss limitations) Understand the proper tax treatment and reporting of a distribution from the S corporation to a shareholder Determine how to calculate AAA and OAA account for an S corporation as well as the 3 potential taxes Determine the impact of health insurance, the net investment income tax, qualified business income tax deduction and unreasonable compensation issues on the reporting function of the S corporation
Leases: ASC Topic 842 in Depth 26-27
-
Webinar
8.00 Credits
Member Price: $329
FASB ASC 842, Leases All recently released updates to ASC 842, Leases
Retirement Distributions: Planning Options 26-27
-
Webinar
8.00 Credits
Member Price: $329
Roth IRA: The right choice" Income tax treatment of distributions from retirement plans of all types Laws, regulations and IRS rulings concerning plan distributions Avoiding penalty on distributions that happen too early or too late Beneficiary choices - eligible or not" Self-directed IRA investment problems
ACPEN: K2’s Excel Best Practices
-
Webinar
8.00 Credits
Member Price: $250
Best practices associated with creating Excel workbooks, including managing workbooks How to secure Excel workbooks Collaboration options and best practices in Excel Effective reporting techniques in Excel
Surgent's Advanced Individual Income Tax Return Issues
-
Webinar
8.00 Credits
Member Price: $279
New issues for the current year tax return and §199A Installment sales — understanding the complicated issues Form 8582: Passive losses with carryovers — Complicated case with filled-in forms Puts, calls, straddling, and unusual investments — Understanding the tax laws and reporting them correctly on the tax return Capital gain and loss issues — The problem with proper reporting of installment sales issues; capital gains and losses; when is a stock worthless; and much more... At-risk rules: What a return preparer really needs to know Passive loss issues — You cannot just trust your software. What to watch out for and the questions you need your clients to answer in order to do it right! Incentive and nonqualified stock options — Reporting; key strategies for planning; dealing with the alternative minimum tax Alternative minimum tax — Understanding it; planning strategies to avoid it; using the minimum tax credit; explaining it to a client Form 6251: Detailed calculation example
Surgent's Annual Accounting and Auditing Update
-
Webinar
8.00 Credits
Member Price: $299
Recently issued FASB Accounting Standards Updates, PCC Update, and items on the FASB’s Technical Agenda Recently issued ASUs covering derivatives, credit losses under ASC 326, government grants, and expense disaggregation FASB Final PIR Report for Leases (Topic 842) Statement on Quality Management Standards: SQMS 1, SQMS 2, and SQMS 3 Proposed SAS on the auditor’s responsibility relating to fraud Recently issued SASs and other AICPA activity Recently issued PCAOB standards and SEC rulemaking activities Other important A&A practice matters
Surgent's Compilations, Reviews, and Preparations: Engagement Performance and Annual Update
-
Webinar
8.00 Credits
Member Price: $299
SSARS No. 21, Clarification and Recodification, and updates to SSARS No. 21 due to the issuance of SSARS No. 23, Omnibus Statement on Standards for Accounting and Review Services SSARS No. 22, Compilation of Pro Forma Financial Information SSARS No. 24, Omnibus Statement on Standards for Accounting and Review Services -- 2018 SSARS No. 25, Materiality in a Review of Financial Statements and Adverse Conclusions SSARS No. 26, Quality Management for an Engagement Conducted in Accordance With Statements on Standards for Accounting and Review Services Sample comprehensive engagement work programs for preparation, compilation and review engagements Reporting and disclosure illustrations for each level of service, including attesting on personal financial statements, prescribed form, special purpose framework and other engagement variations Other communication requirements, such as sample engagement letters and management representation letters
Surgent's Technical Business Practice Issues and Tax Forms for Experienced Practitioners
-
Webinar
8.00 Credits
Member Price: $279
Bonus depreciation and §179 changes under the OBBBA Schedules K-2 and K-3 and filing exceptions Form 7203 IRS Tax Pro Account IRS modernization initiatives Information Returns Intake System (IRIS) Identity Theft warnings IRS guidance for the marijuana industry “Recycled” Form 1099-NEC to report nonemployee compensation Form 1065 steps for reporting capital Centralized audit regime; late filing penalties and small partnership relief “Substance over Form” argument of shareholder loans Advanced study of “At-Risk” loans Employer W-2 correction requests Don't get caught watching the paint dry -- What is hot and new What is terminating S corporations today? Special allocation issues of §704 Final regulations for allocating depreciation recapture to partners and members of LLCs
You Don't Know What You Don't Know About Microsoft Excel
-
Webinar
8.00 Credits
Member Price: $239
The major topics covered in this course include:Excel shortcuts and time saversWorking with templates, formats, styles, and themesCustomizing and enhancing ExcelProtecting and securing workbooksFormula building and the Excel function libraryNote: This session is taught using a 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.
Financial Accounting Standards: A Comprehensive Review 26-27
-
Webinar
16.00 Credits
Member Price: $589
Application of professional judgment Codification, GAAP and the GAAP hierarchy Recent changes in financial statement presentation Hot Topics in financial reporting & accounting
Unlocking Deep Secrets: Case Studies in Financial Analysis
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Overview of financial statement analysisThe impact of GAAP on financial analysisOverview of the Balance SheetOverview of the Income StatementThe importance of the Statement of Cash FlowsCommon Size AnalysisTrend AnalysisProfitability Ratio AnalysisLiquidity Ratio AnalysisSolvency Ratio Analysis
Operations Level Internal Control
-
Webinar
4.00 Credits
Member Price: $149
The major topics covered in this course include:An overview of controls that drive proceduresConsiderations for procedural control developmentUnderstanding and controlling risk that arises when organizations change
ACPEN: Compensation Fundamentals and Pay Transparency: Driving Fairness & Engagement
-
Webinar
1.00 Credits
Member Price: $39
Compensation