CPE Catalog & Events
Internal Control - Testing for Operating Effectiveness
-
Virtual
2.00 Credits
The major topics covered in this class include:Generally accepted audit requirements related to testing controls for operating effectivenessIdentifying key controls that may prove effective and efficient to test in a control reliance strategyResponses when deviations are discovered when evaluating the design or operating effectiveness of internal controlLeveraging audit evidence available for Service Organization Control (SOC1) ReportsGeneral computer control considerations when evaluating the design and operating effectiveness of internal control over financial reporting
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
How to Double Your Firm's Revenue Through CFO and Advisory
-
Virtual
1.00 Credits
The major topics that will be covered in this course include:The average revenue of most accounting firms.The number of advisory clients you'll need to double your firm's revenue.How much you should be charging for advisory services.How we define CFO and advisory services.What business owners really want from their advisor.The three types of CFO/Advisory firms.How to get clients to pay you approximately $2,500 per month for advisory services.The three systems you'll need to add a CFO/Advisory service to your firm.
Mastering IRS Form 7217: Partnership Property Distributions
-
Virtual
1.00 Credits
The major topics that will be covered in this course include:Property distributions in liquidation of a partner’s interestSection 751 and its impact on property distributions from a partnershipMechanics of completing Form 7217 – new for 2024The Section 754 election and its role in partnership property distributions
Forgotten Managerial Accounting Tools for CPAs
-
Virtual
2.00 Credits
The major topics covered in this class include:Target profit analysisBreak-even analysisRelevant costs and decision-makingStandard costs and variancesActivity-based costingSegment reporting and analysis
Surgent's Advising a Client Regarding the Tax Consequences Associated with Buying or Selling a Business
-
Virtual
3.00 Credits
Asset sales and stock sales and their attendant results to buyers and sellers Section 1060 and using the residual method Consequences of making a Section 754 election with adjustments under Sections 743(b) and 734(b) Section 338 and Section 338(h)(10) elections Allocating some of the purchase price of a business to personal goodwill Partnership distributions to retiring partners under Section 736(a) and 736(b) Consulting agreements and employment agreements as between buyers and sellers Advantages of a C corporation having Section 1202 stock
How Fraud Can Affect Smaller Organizations
-
Virtual
4.00 Credits
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
Form 990: Best Practices for Accurate Preparation
-
Virtual
8.00 Credits
Primacy of the Form 990 as a "one size fits all" reporting mechanism Form 990 preparation sequencing and data gathering; and keys to getting Form 990 preparation right the first time Addressing presence of "related organizations" Identification of managers and measurements of their compensation 990 versus books-and-records financial statement detail Disclosures of governance inputs and Boards' employ of policies
Surgent's Employer's Handbook: Legal, Tax, and Health Care Issues
-
Virtual
8.00 Credits
Hiring and firing issues – What questions cannot be asked in an interview; how to document employee performance; establishing an annual review system; when an employer may and may not fire an employee, and much more Employment contracts – An analysis of the legal and planning issues in structuring employment contracts; when noncompetition agreements will and will not work Employment issues in the economy – Telecommuters and other special situations Legal liability issues – Recognition of age discrimination, sex discrimination, FLSA issues, minimum wage, overtime, sexual harassment, and more Fringe benefit issues – COBRA, Family and Medical Leave Act, and new developments in health care Medical plans – Who is a full-time employee?
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
Leverage PowerBI.com to Create Data Analysis for Others
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Tour of the PowerBI.com Interface: An in-depth walkthrough of the PowerBI.com environment, focusing on user interface elements, navigation, and customization.PowerBI.com Concepts: Fundamental concepts of PowerBI.com, including its architecture, data handling capabilities, and integration features.Connecting to Data: Techniques for connecting various data sources to PowerBI.com, ensuring seamless data integration and synchronization.Visualizations and Dashboards: Creating impactful visualizations and assembling informative dashboards to present data compellingly.Q&A Feature: Explore the interactive Q&A feature to derive insights through natural language queries.Sharing Datasets, Reports, Dashboards: Best practices for sharing datasets, reports, and dashboards with different audiences so they can leverage your data analysis work.Creating Apps: Learn how to package reports and dashboards into apps for easy distribution and consumption.
Building a Better Budget in a Time of Uncertainty
-
Virtual
4.00 Credits
The major topics that will be covered in this class include:Budgets vs. ForecastsCyclicalityCore Earnings & Sustainable GrowthIdentifying Key Forecast DriversReasonableness in ForecastingApproaches to BudgetingBudgeting VariancesHorizontal AnalysisFlexible Budgeting
Advanced ChatGPT for Accountants
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Introduction to ChatGPT and its Applications in Accounting.Custom Instructions (CI) for Persistent Context in Financial Conversations.Analyzing Financial Statements and News Releases using ChatGPT.Exploring Business Opportunities through Hyper-Local and Sectoral Analysis.Advanced Data Analysis for Financial Comparisons and Capital Asset Audits.Image Analysis for Asset, Space, and User Interface Design.Voice Interaction with ChatGPT for Enhanced User Experience and Accessibility.
Surgent's Guide to the AICPA Quality Management Standards
-
Virtual
2.00 Credits
Quality management standards SAS 146, SSARS No. 26, and SSAE 23 Risk assessment, which forms the basis of the SQM Monitoring and evaluating the SQM
Surgent's International Tax Challenges and Opportunities for U.S. Filers
-
Virtual
3.00 Credits
Residency status for U.S. federal income tax purposes Key provisions of U.S. income tax treaties Overview of the taxation of income from foreign entities Understanding Foreign Tax Credit Identifying foreign-source and U.S.-source income Foreign earned income and housing exclusion Foreign informational form filing requirements
Supervision/Management Competencies: An Ethical Approach
-
Virtual
2.00 Credits
The major topics covered in this course include:Overview of Virtue EthicsMilgram and Zimbardo case studiesNavigating the transition from "Buddy to Boss"Self-Awareness and Regard for OthersSetting Standards and Analyzing PerformanceUnconscious BiasCommunication Skills
Monthly Federal Tax Updates - August 2025
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Current individual tax issuesCurrent business entity tax issuesAny current tax legislation occurring during the periodOther issues affecting the profession, including IRS procedure, current cases, payroll, and other federal tax issues
Professional Ethical Considerations for CPAs
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Core principles of any Code of Professional Conduct applicable to all CPAs, including conflicts of interest, preparing and reporting information, competence, confidential information, and moreThe importance of maintaining independence for CPAs in public practice, especially when also performing nonattest services for the attest client Comparing and contrasting various ethical standards, including those promulgated by the AICPA, PCAOB, and international bodies
Create Measures in Power BI that Define Your Metrics
-
Virtual
4.00 Credits
The major topics that will be covered in this class include:Introduction to DAX: Understanding the fundamentals of DAX and its role in Power BI.Advanced DAX Formulas: Delving into complex DAX functions and formulas for creating sophisticated measures.Time Intelligence in DAX: Exploring time-based functions to analyze data over different periods.Validating Measures with DAX: Techniques for ensuring accuracy and reliability in your DAX measures.Using PivotTables for Measure Validation: Employing PivotTables in Power BI to test and confirm the effectiveness of DAX measures.
Determining Reasonable Compensation for Owner Employees
-
Virtual
1.00 Credits
The major topics covered in this class include:An analytical framework for analyzing and opining on reasonable replacement compensation for owner-employees of closely held businesses and professional practices in the context of tax planning, compliance, management consulting and business appraisal assignmentsExecutive compensation components, including the valuation of non-qualified plans and restricted stock units
