CPE Catalog & Events
Taking Advantage of Array Formulas in Excel
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Introduction to Array Formulas: This segment establishes the foundation by differentiating array formulas from regular Excel formulas and explaining their significance.Using Array Formulas: This section focuses on the practical application of array formulas, teaching participants how to effectively implement and utilize these formulas in a variety of common Excel tasks and scenarios.Dynamic Arrays and Spill Functions: This part covers the utilization of dynamic arrays and spill functions, highlighting their role in modern Excel data handling.Advanced Array Functions: Participants will delve into complex functions such as SUMPRODUCT, UNIQUE, SORT, and FILTER, focusing on multi-condition summing and data management.Using Array Constants: This section teaches how simplify the use of static values called Array Constants
Accounting for digital assets under US GAAP: Derivatives and mining
-
Virtual
2.00 Credits
How to recognize a derivative or embedded derivative in a digital asset transaction How to determine if a derivative or embedded derivative meets the net settlement criterion Understand the financial statement impact and disclosure considerations related to derivatives and embedded derivatives How the mining process is used to validate transactions How revenue is recognized by mining entities.
Fraud Busters: Controls to Prevent & Detect Fraud
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Fraud motivators - the fraud triangle, typical profiles of fraud perpetratorsRevisiting the basics of controls - design vs effectiveness, preventative vs. detectiveEntity-wide controls and how they can assist in fraud deterrenceSpecific fraud types and the controls that could prevent and detect them
Surgent's Strategies for Maximizing Social Security Benefits
-
Virtual
2.00 Credits
When is a person eligible to take Social Security benefits? Factors to consider when selecting an option for taking Social Security benefits Is there a best age to start taking Social Security benefits? How to maximize Social Security benefit payments for surviving spouses How can a divorced spouse collect Social Security benefits based on the work record of a former spouse? How minor children can collect Social Security benefits based on the work record of an older parent
What's Going on at the FASB (2025)
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Accounting Standard Updates effective in 2024 for public entities, private entities, and nonprofits. Review year 2 implications of the leases standard including modification accounting. A look at the projects identified by the FASB's Invitation to Comment: Agenda Consultation.
AI Privacy, Security, and Compliance Masterclass
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Introduction: What is AI Security, Privacy and Compliance (AISPC)?Why AI Security, Privacy and Compliance (AISPC) is Increasingly Important for AccountantsAISPC Policy Best PracticesKey Tactical Questions for Addressing Data Security and PrivacyOpenAI and Compliance with Government RegulationsOpenAI and Two-Factor AuthenticationOther OpenAI Security, Privacy and Compliance ConsiderationsBest Practices for Secure Data Sharing with GPT How to Create a GenAI and ChatGPT Usage Policy for Your OperationsGeneral AI Policy Do’s and Don’tsAI Copyright Compliance & Protection GuideDeepfakes and Synthetic Media: A New Frontier for Fraud and MisinformationFrom Financial Oversight to AI Governance: The Sarbanes-Oxley Legacy and Accountants' New Frontier in AI Security, Privacy, Compliance and EthicsKey Takeaways
Corporate Transparency Act Developments
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Background of the Corporate Transparency ActBeneficial Ownership Information Reporting (BOIR) Rule Entities required to report.Reporting requirements imposed by the CTADue dates of reportsInformation needed to satisfy the BOIRImpact of failure to reportHow to submit a reportCourt rulings on CTA’s unconstitutionalityImplications to entities as a result of the ruling in NSB.Potential reporting requirements due to FinCen’s proposed rulemaking with respect to non-financed purchases of residential real estate and gratuitous transfers.
Microsoft 365 Application Lightning Round Review-Updated
-
Virtual
1.00 Credits
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
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
Impact of GASB Activities on State and Local Government
-
Virtual
3.50 Credits
GASB statements issued GASB projects
Fraud Case Studies: 21st Century Professional Misbehavior
-
Virtual
4.00 Credits
The major topics that will be covered in this course include:Salient provisions the AICPA Code of Professional ConductExamination of actual fraudsDiscussion of internal controls that could have prevented or mitigated actual fraudsContemplation of epiphanies for your own professional scenarios.Implications for professional conduct and compliance with professional standards
Pass-Through and Corporate Annual Tax Update
-
Virtual
4.00 Credits
Strategies for tax savings Business entity changes IRS administrative issues, compliance and new forms Court cases settled in the last year that provide tax return guidance Position authority IRS rulings, procedures and notices for the last year New, updated and expiring tax deductions and credits
Surgent's Fiduciary Income Tax Returns - Form 1041 Workshop with Filled-in Forms
-
Virtual
8.00 Credits
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 Forms 1120-S and 1065 Return Review Boot Camp for New and Experienced Reviewers
-
Virtual
8.00 Credits
Reviews of portions of error-prone “staff-prepared” Forms 1120-S and 1065 from client-provided information Be aware of legislative changes How to reduce input errors. When and how to rely on third-party data import software What are common errors preparers make and what are the areas generating malpractice claims? Initial administrative groundwork The importance of Schedule M-1. Learn how various schedules are related and learn how to self-review Overview of new Schedules K-2 and K-3 Don’t fall prey to reporting oddities When can seemingly separately stated Schedule K items actually be trade or business items to report on Forms 1120-S or 1065? Form 1120-S – What exactly is terminating S elections today? How do I recognize a second class of stock? Maintaining shareholder basis schedules; beware of final IRS regulations regarding “open debt”; the default method of calculating basis versus the election under §1367; can an S corporation distribute earnings and profits from C corporation years? Form 1065 – New tax reporting requirement for partners’ capital balances Why use §704(b) to maintain capital accounts; §704(c) regulations for preventing the shifting of tax consequences among partners or members; allocating recourse, nonrecourse, and qualified nonrecourse debt; a review of §754 step-up in basis rules Discussion of more complex transactions included in corporate structures Multiple checklists of efficient procedures to identify potential issues on an 1120-S or 1065 tax return
Surgent's Preparing Not-for-Profit Financial Statements
-
Virtual
8.00 Credits
Key requirements, options, and disclosures related to each of the basic financial statements The reporting of functional and natural expense information Requirements related to providing liquidity and availability of financial assets information Core not-for-profit accounting requirements related to conditional and unconditional contributions, promises to give, contributed services, net assets, special events, the classification of expenses, and more
The Best Federal Tax Update Course by Surgent
-
Virtual
8.00 Credits
Comprehensive coverage of the Inflation Reduction Act, including: The Clean Vehicle Credit, Credit for Previously Owned Clean Vehicles, Credit for Qualified Commercial Clean Vehicles, Residential Clean Energy Credit, Energy Efficient Home Improvement Credit, Premium Tax Credit, Elective Payment, Transferability, and Prevailing Wage and Apprenticeship Requirements Comprehensive coverage of the SECURE 2.0 Act, including: Expanding Enrollment in Retirement Plans, Increase in Age for Required Beginning Date for Mandatory Distributions, New Exceptions to Penalty-Free Withdrawal from Retirement Plans, and recent IRS guidance Timely coverage of breaking tax legislation Form 1099-K reporting requirements Detailed analysis and examples of Sale of Passthrough Entity Interest and Net Investment Income Tax The Gig Economy -- Tax implications, Independent Contractor vs. Employee Classification, and the DOL Final Rule FinCEN reporting requirements under the Corporate Transparency Act Employee Retention Tax Credit updates Practice aids, including all the numbers applicable for the current year -- inflation-adjusted amounts, mileage rates, retirement contributions, and more Advanced practice, reporting, and other issues intertwined with advanced planning and discussion ideas
Walter Haig's Business Financial Health Checkup
-
Virtual
8.00 Credits
The major topics that will be covered in this class include:How to use analytical procedures as a management tool to identify areas hindering the profitability of the entityHow to use analytical procedures to identify misstatements in financial informationTechniques for developing a "workable" business planRecasting GAAP financial statements into powerful management toolsDeveloping and using benchmarks to identify profitability problemsIdentifying profitability key factorsThe relationship of internal controls and the health of an entityCommon weaknesses in the internal controls of SMEs using the guidelines in the COSO Report on Internal Controls and common internal controls to address those weaknessesHow to create "goal" statements that achieve results
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.
Microsoft Teams - Everything You Need to Know from A to Z
-
Virtual
4.00 Credits
The major topics that will be covered in this course include:Understanding the "big picture" of the role the Teams app plays in your Microsoft 365 ecosystemHow to effectively design your teams / channels configurationDetailed review of all the features for creating conversation postsDetailed review of all the features for creating, editing and managing Office files within the Teams appHow to use the search features to find Teams content instantlyStep by step review of how to host and participate in Teams online meetingsUsing Teams calling features for your phone systemHow to manage your notification settings in TeamsAnd more
About the TIGTA: Who Watches the IRS?
-
Virtual
2.00 Credits
Major topics covered in this course include:The role of TIGTA in the US tax systemAuditing, investigating, and inspecting and evaluating IRS programs and operationsIdentifying opportunities to improve the administration of tax lawsPromoting integrity, economy, and efficiency in the tax systemResponding to requests from Congress and other external stakeholdersUpholding ethical standards in the accounting professionBuilding trust and confidence in the tax system
