CPE Catalog & Events
The 10 Must Know Excel Features
-
Webinar
2.00 Credits
Member Price: $89
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.
Corporate Storytelling in Financial Reporting
-
Webinar
1.00 Credits
Member Price: $55
The major topics that will be covered in this course include:Purpose of Management Commentary (IFRS): Understanding the foundational objectivesPurpose of MD&A (AAP): SEC-mandated narrative disclosure requirementsHistorical Context: Past and present frameworks and the limitationsRecent Revisions: Key enhancements and ESG integrationPractical Examples: Real-world applications and improvementsConvergence & Guidance: Frameworks, comparisons, and implementation
Microsoft 365 Application Lightning Round Review-Updated
-
Webinar
1.00 Credits
Member Price: $55
The major topics covered in this course include:Lightning round review of the following apps, with an explanation and demonstration of what each of them offersTeams - the foundation of all that you do in Microsoft 365SharePoint / OneDrive - secure cloud storagePower BI - the new financial reporting modelStream - the YouTube for your organizationBookings - streamline your appointment scheduling OneNote - get your content organized for quick retrieval Lists - create custom list tracking reportsTo Do - consolidate all your Outlook, Planner and general "to do's" in one appPlanner - manage simple and complex engagements and projects in an intuitive appA quick look at many of the remaining apps
Accountants and Malpractice: Can We Get Sued for This?
-
Webinar
0.00 Credits
Member Price: $89
The major topics that will be covered in this class include:How accountant liability is a very real threat in today's litigious society.A discussion of scenarios in which accounting professionals can find themselves inadvertently involved in a lawsuit.Pitfalls in which the accountant may find him- or her- self while dealing with clients.Real-life examples from the speaker's extensive experience as a practitioner and as an expert witness in accounting malpractice cases.
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
Coping With the Growth of Online Fraud
-
Webinar
4.00 Credits
Member Price: $149
The major topics covered in this course include:The actuation of online and other cyber fraudsFraudulent acts that are initiated electronicallyAutomated and employee driven methods that can reduce cyber-fraud risk
Advanced Tax Planning S Corporations - Tax Staff Essentials
-
Webinar
7.50 Credits
Member Price: $279
Basis in S corporation stock Distributions Compensation planning Qualified subchapter S subsidiaries Liquidations, reorganizations, and redemptions Estate planning and the use of trusts Section 199A
Finance and Innovation: Reinvent Your Organization and Dept.
-
Webinar
8.00 Credits
Member Price: $239
The major topics that will be covered in this course include:What is innovation?The different forms of innovation, e.g., sustaining and disruptive.The five discovery skills needed to be innovative?The value of why we need to find ways to say, “Yes!” How to change your processes, rules and departments to be more innovative? Lessons learned from innovative businesses with examples.How does innovation happen and how to make innovation stick?The need to improvise and embrace broad experiences.
Leases: Mastering the New FASB Requirements
-
Webinar
8.00 Credits
Member Price: $319
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
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 Individual and Financial-Planning Tax Camp
-
Webinar
8.00 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
Auditing Standards: A Comprehensive Review 26-27
-
Webinar
16.00 Credits
Member Price: $589
Efficient audit planning, documentation and research Risk assessment procedures relate control risk to substantive testing and reduce the risk of lawsuits Fraud requirements Testing management's estimates Auditing standards
Google Gemini Deep Dive Hands-on Bootcamp for CPAs
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Getting started with GeminiTour of the Gemini app and how to use itVariety of hands-on case study examples for accounting, finance, and taxProtecting your data privacy in Google GeminiAdvanced Gemini features reviewIntegration with Google appsSubscription plan option
Navigating IRS Authorizations: Form 2848 & Form 8821
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Overview of IRS Power of Attorney (POA) rules.Form 2848: Authority to Represent Clients before the IRS.Form 8821: Accessing Tax Information Without Representation.Identifying errors and compliance risks in POA filings.Rules for revoking or updating POA authorizations.Managing authorizations through the CAF system.Electronic submissions and the IRS online authorization process.Ethical responsibilities when holding a POA.
Forensic Accounting: Finding Hidden Treasure in Tax Returns
-
Webinar
4.00 Credits
Member Price: $149
The major topics that will be covered in this course include:The rules of IRS disclosure of tax informationUnderstanding the role of IRS transcriptsInterpreting the actions of the IRS in transcriptsFOIA requestsAnalyzing tax information and returns for financial leads
LLC's & S Corporations: a Comparative Analysis
-
Webinar
8.00 Credits
Member Price: $239
The major topics that will be covered in this course include:Comparative analysis of LLCs and S CorporationsEntity formation, compliance, and operational structuresSelf-employment tax and its implications for LLCs and S CorporationsForm 2553 preparation and relief for late filingsRev. Proc. 2022-19 and Rev. Proc. 2023-3: analysis and applicationS Corporation eligibility errors and corrective measuresCorporate governance and formalities for both entity typesShareholder stock and debt basis for S CorporationsForms 1120S, 1065, and related schedules (K-1, K-2, K-3)Officer reasonable compensation and general partner guaranteed paymentsAudit strategies, estate planning, and business continuation planning
Surgent's Bankruptcy Basics: Understanding the Reorganization and Liquidation Process in These Uncertain Economic Times
-
Webinar
2.00 Credits
Member Price: $99
Commencement of a bankruptcy proceeding Protections provided to debtors under the Bankruptcy Code Key procedural aspects of bankruptcy The automatic stay Differences between Chapters 7, 11, and 13 bankruptcy cases The bankruptcy discharge Proofs of claim Plans of reorganization Litigation that can arise during bankruptcy Creditor committees Bankruptcy trustees Avoidable preferences and fraudulent transfers Special rights afforded to landlords and secured creditors
Surgent's Guide to Calculating S Corporation Shareholder Stock and Loan Basis
-
Webinar
2.00 Credits
Member Price: $99
Introduction to Form 7203 Introduction to the calculation of stock basis Introduction to the calculation of loan basis Taxable and nontaxable S corporation distributions to shareholders The election to reduce basis by deductible losses and expenses before reducing basis by nondeductible expenses
Surgent's Use the Data Model to Build More Powerful PivotTables
-
Webinar
2.00 Credits
Member Price: $99
Creating a data model/Power Pivot Building PivotTables from multiple tables Creating Measures Using named sets
Unlock the Power of AI with Copilot in Excel
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Introduction to Copilot in ExcelAutomating Tasks and Enhancing ProductivityAdvanced Data Insights with Copilot