CPE Catalog & Events
The 10 Must Know Excel Features
-
Virtual
2.00 Credits
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
-
Virtual
4.00 Credits
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
-
Virtual
0.00 Credits
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
-
Virtual
4.00 Credits
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
-
Virtual
4.00 Credits
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
The Best Federal Tax Update Course by Surgent
-
Virtual
8.00 Credits
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
-
Virtual
2.00 Credits
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
ACPEN: Performance Management
-
Online
1.00 Credits
Setting and resetting performance expectations On-the-spot counseling Addressing erratic performance Drafting and presenting performance appraisals
ACPEN: Advanced Cost Accounting: Eliminate Calculation Distortions
-
Online
2.00 Credits
Cost Accounting
Surgent's A Complete Guide to Reporting Form 1099-DA
-
Virtual
2.00 Credits
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?
-
Virtual
2.00 Credits
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
Surgent's The Risks and Benefits of ChatGPT and Artificial Intelligence
-
Virtual
0.00 Credits
What are AI tools? Where are we with AI tool development? What is ChatGPT? ChatGPT – what kind of queries are possible? Copyright and intellectual property issues Benefits of AI tools Concerns with AI tools Impact on business use of AI Policy on AI tools
ACPEN: Audit Skills for Beginners
-
Online
4.00 Credits
Professional skepticism – Creating a mindset for finding fraud and error Audit documentation basics – Creating workpapers that pass review The audit risk model – Understanding the foundational principles Internal control fundamentals - Satisfying the requirements for evaluating the design and implementation of internal control over financial reporting
ACPEN: Leading and Managing the Accounting Department
-
Online
4.00 Credits
Accounting Leadership Management
CPA to CFO: Essential Competencies for Finance Leaders
-
Virtual
1.00 Credits
To purchase the report referenced in this presentation, or any of the research papers published by CPA Crossings, visit https://www.cpacrossings.com/research. The major topics that will be covered in this course include: Top competencies hiring executives seek in CFO candidates based on survey of 320+ CEOs and recruiters Critical thinking frameworks and strategy creation techniques for financial leadership Forward-looking financial skills including capital management, forecasting, and funding strategies Industry-specific requirements for high-growth companies and nonprofit organizations Practical career development strategies to build CFO-ready competencies
ACPEN: Cost and Pricing Models: Boost Your Bottom Line
-
Online
2.00 Credits
Cost Accounting Activity-based Costing
CFO Series: Beyond Likes & Shares: Social Media at Work
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:The huge scale of social media; what are the many issues?The impact on trust, reputation, our workforce and confidentiality The legal and ethical impact of social media with examples of firings, dismissals and silly blundersHow to develop a marvelous policy for social media at workReduce riskAdvance preparation for crisis management
ACPEN: Ultimate Small Business HR Guide: Essential Tips for Success
-
Online
1.00 Credits
Small Business Management
How to Audit: Property, Plant, & Equipment
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:The foundation of auditing PP&E, including the related audit assertions, risks, & threats to the PP&E balance.The various substantive auditing procedures that staff should perform.Real world auditing examples.
ACPEN: Partnership Checkup: Tax Issues & Forms Reporting
-
Online
4.00 Credits
Clarify the importance of partnership capital accounts and partnerships debt on partner's tax basis Impact of contributed property Explain the importance of shareholder loans to the entity Discuss how basis is impacted by distributions of corporation property and the sale/or liquidation of the S corporation interest Comprehensive examples illustrate the mechanics of the basis determination process Discusses how S corporation losses impact Form 1040 Schedule E reporting How to get from the Schedule K-1 information to the basis calculations
