CPE Catalog & Events
Build a Data Model for Analysis in Power BI
-
Virtual
4.00 Credits
The major topics that will be covered in this class include:Data Modeling Essentials: Understanding the core concepts of data modeling in Power BI, including integration of various data sources.Building Relationships: Techniques to establish and manage relationships between different data sets.Calculated Columns and Basic DAX Measures: Introduction to DAX (Data Analysis Expressions) and its application in creating calculated columns and basic measures.Calculated Columns vs Measures: Insights into when to use calculated columns and when to opt for measures.Explicit vs Implicit Measures: Understanding the difference and appropriate application of explicit and implicit measures in data analysis.Hierarchies in Data: Creating and utilizing hierarchies to enhance data analysis and reporting.Using Pivot Tables to Validate Measures: Practical skills in using pivot tables within Power BI to validate and refine measures.
Yellow Book: Application of GAGAS Principles
-
Virtual
3.00 Credits
Foundation and principles for the use and application of generally accepted government auditing standards (GAGAS) General requirements for complying with the Yellow Book Ethics, independence and professional judgment Competence and continuing professional education Quality control and peer review
Surgent's Advanced Audits of 401(k) Plans: Best Practices and Current Developments
-
Virtual
8.00 Credits
Audit requirements for ERISA §103(a)(3)(C) audits An annual update of the changes affecting 401(k) plans Compliance issues associated with eligibility and enrollments, remittances, lack of oversight, compensation, vesting, and other topics Best practices for engagement planning, internal controls, risk assessment, and detailed testing Avoiding common mistakes while performing audit procedures Plan mergers and acquisitions Common audit reporting and disclosure issues
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
Tax Fundamentals of LLCs and Partnerships - Tax Staff Essentials
-
Virtual
8.00 Credits
Basic tax structure of partnerships and LLCs Check-the-box elections to be taxed as a partnership Partnership distributions Compensatory payments to partners At-risk and passive activity limits Profit and loss allocations: general rules and restrictions
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
Servant Leadership 101
-
Virtual
1.00 Credits
The major topics that will be covered in this course include:Assessing your organization’s culture The benefits of great cultures The basics of what servant leadership is, and is not How to coach using a servant leadership style
Exploring the New Lease Accounting Standard
-
Virtual
2.00 Credits
The major topics covered in this class include:What is a lease?Recognition and measurement of lease assets and liabilities Impact on lessors and lesseesDisclosures and transition rulesEffective dates
K2's Time To Advance Automation - Strategies And Tools For Efficiency
-
Online
2.00 Credits
Advanced Automation Strategies: Best practices for starting or enhancing your automation journey Key Tools for Automation: Exploring the latest features in Zoho, Zapier, Microsoft, and other tools Practical Automation in Finance: Automating tasks in accounts payable, banking, and approval workflows Navigating Common Pitfalls: Identifying and avoiding typical obstacles in automation projects
Profitability Pricing: Boost your Bottom Line
-
Online
2.00 Credits
Competitive bids Achieving target profitability
Surgent's Communicating Financial Results to Stakeholders: A Guide for Client Advisory Services
-
Virtual
2.00 Credits
Communicating financial results The role of the accountant in communication The challenges accountants face in communication Creating better awareness of a company’s financials Behavioral biases of stakeholders Tips for staying on-point in communication Case study
Surgent's Top Business Tax Planning Strategies
-
Virtual
2.00 Credits
Use of the budget reconciliation process to enact major tax legislation Whether the Tax Cuts and Jobs Act of 2017 expires after 2025 Elimination of income taxation on tips, Social Security payments, and overtime Changes in marginal tax rates after 2025, including 15% rate on corporations for domestic manufacturing Section 163(j) — deduction limitation based on EBIT rather than EBITDA Various tariff proposals ranging from 10% to 200% Reinstatement of 100% bonus depreciation Changes in research and development expensing Increased tax-free benefits for commuting, health, and child care
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.
ACPEN Signature 2025: Critical Real Estate Taxation Issues
-
Online
8.00 Credits
The importance of correctly classifying property as capital gains property, inventory real estate, development real estate and real estate used in trade or business and applicable cost recovery recapture rules Preserving capital gains treatment for pre-development appreciation with a related party lot developer Cost Segregation Studies for Real Estate and their Tax Consequences Qualified Nonrecourse Debt under the At-Risk Rules Distinguishing repairs from improvements and the tax consequences of the difference Tax consequences of renting real estate Common issues in Ground Leases, Percentage Leases and Net Leases Classification as a Real Estate Professional under the PAL Rules and Interaction with the Rental Real Estate Rules and the Aggregation Election for rental real estate Review of current actions by Congress and the IRS affecting real estate.
Using e-Signature Software to Process Agreements-Updated
-
Virtual
2.00 Credits
The major topics covered in this course include:Review of the digital document signing process.Key features to evaluate in selecting a solution.Review and distinguish top selling e-signature applications.Best practices for deploying e-signature software in your practice or business.
Be the Sun, Not the Salt, featuring Harry Cohen and John Daly
-
Online
1.00 Credits
What is the Heliotropic Effect? Be the Six Sun Pearls. Today is a good day to do good Be the bright spot in the room Be your own sun Do the next right thing Pet peeves bite Knowing isn't doing
Revenue Recognition - Recognize Revenue
-
Online
1.00 Credits
Revenue Recognition Accounting
AI Ethics 2025 (VBOA-Approved)
-
Virtual
2.00 Credits
Ethical principles of AI usage. Strategies for ethical decision making. Compliance and governance in AI adoption. Balance of innovation and responsibility.
To Verify or Let It Fly: What to Do About Questionable Tax Return Information
-
Online
2.00 Credits
Clear Reflection of Income: Really? The Verification Drill Tax Ethics and the Conceptual Framework The Tax Uncertainties Dance (Tax and Financial Reporting) Cases and Controversies Blanco v. United States U.S. v. Fairchild Conclusion
