CPE Catalog & Events
The 10 Must Know Excel Features
-
TBD
0.0 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.
Surgent's Controller/CFO Update: Hot Topics Facing Today's Financial Professional
-
TBD
4.0 Credits
Member Price: $159
Economic update Leadership and management changes because of recent developments, including AI Managing for productivity Hiring the best people for the organization New motivation techniques
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
Surgent's Mastering Accounting for Income Taxes
-
TBD
2.0 Credits
Member Price: $159
The sources of deferred tax assets and liabilities Calculating the deferred tax asset or liability Reporting income-tax expense and balance sheet items Defining, analyzing, and reporting uncertain tax positions Classification of deferred tax assets and liabilities Disclosure requirements Finalized and proposed changes to ASC 740, including ASU 2023-09, CAMT, and global tax transparency initiatives
Surgent's Update on Recent AICPA Standard Setting: Staying Current in a Changing Environment
-
TBD
4.0 Credits
Member Price: $159
AICPA hot topics and standard-setting initiatives AICPA Quality Management Standards: SQMS No. 1, SQMS No. 2, and SQMS No. 3 Consideration of fraud in a financial statement audit Discussion of the standard on audit evidence effective for years ended December 31, 2022 Discussion of the standard on auditing accounting estimates and disclosures effective as of December 31, 2023 Discussion of the two standards on use of specialists and information from a pricing service, and the newly updated risk assessment standard effective for years ended December 31, 2023 Discussion of standards that are effective as of 2025, including those dealing with client acceptance and questions asked of the predecessor auditor, the partner’s responsibility for engagement quality, group audits, conforming changes to compliance auditing, and more
ACPEN: Becoming an AI-Savvy Controller/CFO: Mastering Tools and Technologies
-
TBD
4.0 Credits
Member Price: $149
Strategic Finance Leadership Advanced Financial Analysis Business Intelligence & AI in Finance Economic Intelligence for Decision Makers Operational Insight & Business Strategy The Future Role of the Controller/CFO
How Fraud Can Affect Smaller Organizations
-
TBD
0.0 Credits
Member Price: $149
The major topics included in this course include:The reasons for fraudFraudulent acts that are initiated against smaller organizationsMethods to stop fraud attempts against small businesses
ACPEN: The Complete Guide to the Preparation of Form 1041
-
TBD
8.0 Credits
Member Price: $250
Step-by-step Form 1041 preparation Key issues in decedent’s estates and trusts Understanding Subchapter J and its impact on taxation Compliance strategies for fiduciary entities Tax treatment of DNI and IRD Case studies illustrating real-world application Legislative updates affecting estate and trust taxation
An Exhaustive Look At Fraud and Ways To Control It
-
TBD
0.0 Credits
Member Price: $239
The major topics covered in this course include:Fraudulent acts initiated from outside organizationsWhy internal fraud occursThe importance of fighting cyber-fraudSteps that verify anti-fraud activities are working
The Best Federal Tax Update Course by Surgent
-
TBD
8.0 Credits
Member Price: $299
Comprehensive coverage of the One Big Beautiful Bill Act Review of key components of President Trump's tax bill, including a tip income exemption, overtime pay relief, Social Security tax exemption, auto loan interest deductibility, SALT deduction modifications, a lower corporate tax rate, restoration of 100% bonus depreciation, immediate R&D expensing, and permanent extension of select TCJA provisions Tariff policy and implementation - analyze the use of tariffs as a fiscal and trade policy tool Digital assets and tax implications - understand the new Form 1099-DA for reporting digital asset transactions, along with updated IRS guidance on cryptocurrencies, NFTs, and broker responsibilities Artificial intelligence - discover how AI and generative tools are transforming tax practices, as well as how the IRS is leveraging AI to enhance audit selection Form 1099-K reporting requirements - understand the evolving IRS thresholds and rules for third-party payment platforms Sale of Passthrough Entity Interests and Net Investment Income Tax - analyze the tax implications of selling interests in passthrough entities, including relevant examples, and how the Net Investment Income Tax (NIIT) applies to these transactions The Gig Economy - examine key tax implications for gig workers, including Independent Contractor vs. Employee classification challenges, reporting responsibilities, and the impact of the 2024 Department of Labor Final Rule on worker status Timely coverage of breaking tax legislation 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
Google Gemini Deep Dive Hands-on Bootcamp for CPAs
-
TBD
0.0 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
Al Capone to Cybercrime: The Journey of IRS Special Agents
-
TBD
4.0 Credits
Member Price: $149
The major topics that will be covered in this course include:Introduction to IRS Criminal Investigation (CI): Overview of its mission, role, and significance in maintaining tax compliance.Historical Evolution: From its inception in 1919 to its current role, highlighting key milestones and notable cases.Investigative Techniques and Tools: Detailed look at the methods and technologies used by CI agents to uncover financial crimes.Importance of IRS CI: Discussion on the impact of CI’s work on tax compliance, public confidence, and the broader financial system.Training of CI Agents: Insight into the rigorous training programs at FLETC and ongoing professional development.Process of Investigations: Step-by-step breakdown of how tax fraud and money laundering cases are initiated, investigated, and prosecuted.
ACPEN: Performance Management
-
TBD
1.0 Credits
Member Price: $39
Setting and resetting performance expectations On-the-spot counseling Addressing erratic performance Drafting and presenting performance appraisals
ACPEN: Compensation Fundamentals and Pay Transparency: Driving Fairness & Engagement
-
TBD
1.0 Credits
Member Price: $39
Compensation
ACPEN: Powerful Public Speaking
-
TBD
1.5 Credits
Member Price: $39
Communications
ACPEN: Audit Risk Assessment in Plain English
-
TBD
2.0 Credits
Member Price: $89
Overview of Audit Risk Assessment AICPA's clarified Risk Assessment Standards SAS 145 Assessing the Entity's Environment
ACPEN: Fraud Risk Management
-
TBD
1.0 Credits
Member Price: $89
Fraud risk management Fraud risk assessments Data analytics Fraud risk management tools
ACPEN: Advanced Cost Accounting: Eliminate Calculation Distortions
-
TBD
2.0 Credits
Member Price: $89
Cost Accounting
Surgent's A Complete Guide to Reporting Form 1099-DA
-
TBD
2.0 Credits
Member Price: $119
Definition of a digital asset for purposes of Form 1099-DA What is a sale of a digital asset affected by a broker on behalf of another person? Mandatory 2025 reporting of gross proceeds information and voluntary reporting of basis information Treatment of sales of digital assets Who is a broker for purposes of Form 1099-DA? Information required to complete Form 1099-DA Reporting closing transactions and covered securities Who is a processor of digital asset payments? How many transactions to report on each Form 1099-DA and how many forms to file for each transaction Optional reporting methods for digital asset transactions Substitute statements for the Form 1099 Reporting a disposition of digital assets held by a widely held fixed investment trust
Surgent's Exploring Client Advisory Services: Tax Due Dates and Penalties/Where Do I Need To File?
-
TBD
2.0 Credits
Member Price: $99
Estimated taxes and deadlines Tax due dates for common returns and filings Potential penalties and interest Information return penalties Penalties applicable to pass-through entities Accuracy-related penalties First-time abatement (FTA) FTA eligible returns Reasonable cause Nexus: sales tax vs. income tax Sales tax nexus with state specific examples Remote work and sales tax nexus Income tax nexus with state-specific examples Remote work and income tax nexus Sales factor: throwback rules