CPE Catalog & Events
Common Yellow Book & Single Audit Deficiencies - 2023
-
Online
4.00 Credits
ICOC Compliance Testing Major Program Determination
2024 Key Tax Issues Facing Business & Industry
-
Online
4.00 Credits
Update and review of recent and key tax developments impacting business and industry Tax depreciation update and review Research & Experimentation review and update Interest expense deduction Business losses Travel and entertainment expense rules Independent contractor vs. employee
The 10 Must Know Excel Features
-
Online
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 Guide and Update to Compilations, Reviews, and Preparations
-
Online
4.00 Credits
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 Sample comprehensive engagement work programs for preparation, compilation, and review engagements
2024 Section 174: New Rules for the R&E Deduction
-
Online
1.00 Credits
Impact of the Section 174 law change requiring capitalization of research and experimental costs Comparison of the Section 41 R&E credit to the Section 174 R&E deduction Financial accounting for R&E costs Required change of accounting method and Form 3115 Revised treatment of software development costs Comprehensive case problems explaining implementation of the law changes
Advanced Excel: Hidden Secrets and Gems
-
Online
2.00 Credits
The major topics covered in this class include:Awareness of advanced functionsCreative methods for data manipulationUsing intellectual curiosity and professional skepticism to develop a problem-solving mentalityReal-life examples of innovative ways to analyze and report data with ExcelUsing Excel to perform e-mail mergesMany other functions and techniques that inspire you to continue exploring the depths of Excel and its seemingly bottomless toolboxEnhance creativity in your approach to developing Excel models
Surgent's Strategies for Maximizing Social Security Benefits
-
Online
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
Surgent's Federal Tax Update
-
Online
4.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, and Premium Tax Credit Comprehensive coverage of the SECURE 2.0 Act, including: Expanding Enrollment in Retirement Plans, Increase in Age for Required Beginning Date for Mandatory Distributions, and New Exceptions to Penalty-Free Withdrawal from Retirement Plans Timely coverage of breaking tax legislation Bonus depreciation Section 174 Research and Experimental Expenditures New FinCEN reporting requirements in 2024 Advanced practice, reporting, and other issues intertwined with advanced planning and discussion ideas
Consideration of Fraud in a Financial Statement Audit
-
Online
2.00 Credits
The major topics that will be covered in this course include:The auditor's responsibilities for fraud when performing an audit as contained in AU-C 240, Consideration of Fraud in a Financial Statement AuditReviewing the components of the fraud triangleA Fraud Prevention Checklist to be used by auditors and shared with their clientsA review of how selected fraud were uncovered in small and medium size entities, including for-profit organizations, not-for-profit organizations, and governmental entitiesOther important matters covered in AU-C 240
Payroll Essentials: The Payroll Cycle of Life
-
Online
2.00 Credits
The major topics covered in this class include:A general review of compensation and payroll taxes from a broad perspectiveA walk through of the payroll processExplanations and examples of payroll processing, payroll tax deposits, and payroll returnsResources, recommendations, and guidance on compensation, payroll and payroll related topics
There is NO Such Thing as `Business Ethics' featuring John Levy and Don Minges
-
Online
1.00 Credits
Should ethical behavior be something that we always do? Is ethical behavior situational? Why being ethical will help you succeed personally and professionally. Consequences of not behaving ethically? Why trust matters? How we can make better ethical decisions in our professional lives.
ProActive Response Group De-Escalation Training
-
Online
1.20 Credits
Definition of De-Escalation Recognizing Anger Situational Awareness LOWLINE Technique MR EBS Technique Posturing Controlling the Environment
Transition from SSAE 16 to SSAE 18
-
Online
1.00 Credits
SSAE 18 Intent Impact of Change Subservice Organization Modifications of SSAE 18 Monitoring Risk Assessment Complimentary Controls Evidence
Power, Influence, and Ethics
-
Online
2.00 Credits
The two sides of leadership Practices that build and destroy an organization’s value and spirit Toxic leader characteristics Four sources of leadership power Push vs. pull leadership styles Six 'Rules of Influence' that cause one person to say 'yes' to another person Ways to defend ourselves against toxic leaders How to use corporate politics to our advantage and still do the right thing
Inventory, Expense and Payroll Fraud
-
Online
2.00 Credits
Methods of committing inventory, expense and payroll fraud What to look for when observing inventory Detection of inventory fraud How to recognize fictitious expenses How to recognize altered expenses Indicators of fake documentation The three main reason we ask for documentation Detection and prevention of ghost employees
Introduction to Governmental Accounting
-
Online
2.00 Credits
Fund Accounting MD&A ACFR
Love it or Leave It: Engagement and Retention at Work
-
Online
2.00 Credits
The major topics that will be covered in this course include:Ethical Values and Engagement and RetentionEnhancing Employee engagementStrategic/Intentional Actions to Enhance RetentionGeneration X
Surgent's Ethical Considerations for CPAs
-
Online
2.00 Credits
Auditor independence and its importance to the public accounting profession Common threats to auditor independence AICPA’s framework for assessing conflicts of interest Unique threats related to non-attest services to attest clients Common safeguards to help assure compliance with relevant rules and regulations
The Happiness Advantage: How to Use Positive Psychology to Enjoy Work More, Get More Done, and Be a Better Professional
-
Online
4.00 Credits
What makes people really happy—and what doesn’t The 3 most important things you can do to increase both happiness and productivity How to handle stress in under two minutes How to deal with difficult people so they don’t bring you down How to use positive psychology principles to help your business
Triple Your Memory, Prevent Dementia and Halve Your Stress - Part 2
-
Online
4.00 Credits
How our emotions follow the motion of our body, and how that can be used to instill instant confidence How to tap into a completely relaxed and/or confident state of mind in 10 seconds or less using advanced hypnotic conditioning and Neuro-Linguistic Programming techniques How to stay motivated to use the methods outlined in this course to advance your career and achieve a higher quality of life How to use the concept of constant learning to help you maintain a balanced and fulfilling lifestyle