CPE Catalog & Events
Finding Errors in Excel Spreadsheets
-
Online
2.00 Credits
Member Price: $89
The major topics that will be covered in this class include:Understanding Common Excel Errors: Gain insights into the most common types of errors encountered in Excel, including formula errors, reference errors, and logic errors.Advanced Formulas and Functions: Learn to use advanced Excel functions and formulas that are crucial for error detection and data analysis.Data Validation Techniques: Master the art of data validation to prevent errors before they occur. This includes setting up data validation rules and using conditional formatting to highlight potential inaccuracies.Error Tracing and Auditing Tools: Delve into Excel's auditing tools to trace and fix errors. Learn to use Trace Precedents, Trace Dependents, and the Error Checking tool effectively.
Partnership/LLC Taxation: Tax Basis Capital Accounts
-
Online
2.00 Credits
Member Price: $89
The major topics that will be covered in this class include:Discuss the impact of the Section 199A flow-through entities deduction on partnerships and their partnersThe meaning of a "tax basis capital account"How the financial accounting and tax capital accounts differ from one anotherDetermine a partner's share of the partnership's liabilitiesDistinguish "recourse" loans from "nonrecourse" loansWhat are "qualified nonrecourse financing" loans and how they affect partnersSection 704 "built-in gain or loss" rules and how they impact Schedule K-1 reportingSection 4655 "at risk" rules and how they impact Schedule K-1 reporting
Coaching the Next Generation of CPAs
-
Online
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Building a high-performing team comprised of multi-generational workers.How to effectively communicate with the millennial worker.Leveraging younger staff in business development opportunities.Measuring the productivity of a millennial workforce.
Surgent's Food, Beverage, and Entertainment Expensing
-
Online
2.00 Credits
Member Price: $99
The 50% deduction for meals that are ordinary and necessary in carrying on a trade or business Elimination of the temporary rules that applied for 2021 and 2022 which allowed for 100% deductibility for ordinary and necessary business-related meals When meals are still 100% deductible IRS rules relating to the nondeducibility of activities considered entertainment or amusement What constitutes entertainment/amusement for tax purposes? When employers may deduct food and beverages provided to employees 50% deductibility for occasional employee meals and for overtime meals 50% deductibility for business meals during business meetings Business meals incurred during business travel Invoice meals separately from entertainment
Surgent's Hiring New Workers and Payroll Taxes
-
Online
2.00 Credits
Member Price: $99
Form W-4 Form I-9 Form W-9 End-of-year compliance Payroll tax returns Unemployment insurance
Surgent's Key Roth IRA and Roth 401(k) Rules for Funding and Tax-free Distributions
-
Online
2.00 Credits
Member Price: $99
Funding options for Roth accounts 529 plans to Roth IRAs Backdoor Roth strategies The new Roth SEP and Roth SIMPLE IRAs Roth 401(k) contribution rules The tax impact of rolling a 401(k) to a Roth IRA Who can start the Roth IRA 5-year clock? The 5-year rules for Roth 401(k)s and Roth IRAs Direct and indirect Roth conversions Direct and indirect rollovers from Roth 401(k) plans The risky recapture of the 10% penalty How the ordering rules work and when they apply FIFO rules for Roth IRAs Case studies and cheat sheets to reinforce concepts
Surgent's Schedules K-2 and K-3: Filing Requirements
-
Online
2.00 Credits
Member Price: $99
Detailed discussion of the domestic filing exception Filing requirements and exceptions for every part of Schedules K-2 and K-3 Examples based on common client situations encountered in practice
Surgent's Strategies for Maximizing Social Security Benefits
-
Online
2.00 Credits
Member Price: $99
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 Individual and Financial-Planning Tax Camp
-
Online
8.00 Credits
Member Price: $299
Comprehensive coverage of the SECURE Act 2.0 Understanding the environment: what’s new, what’s expired or expiring, and what’s likely to change Reading a tax return for developing client-specific tax strategies Changes to the lifetime estate tax exemption in light of proposed regulations The net investment income tax: planning for compliance Family income-splitting strategies that need to be considered Income tax issues: impact on timing of other income Selling a principal residence Two principal residences at the same time Use of life insurance to protect families: Whole Life Insurance, Term Life Insurance, Universal Life Insurance, and Variable Life Insurance Using Roth IRAs and Roth contribution programs to best advantage Conversions: do they still make sense? Taking distributions: matching timing to client requirements Qualified plan contributions to reduce current income and Social Security tax: implications for business owners and self-employed Social Security solvency issues Incentive Stock Options and Employee Stock Purchase Plan considerations What to do about itemized deductions Trans-generational planning: conversions, income, and gain-splitting Tax benefits of HSAs and other tax-advantaged accounts Identifying tax opportunities: reviewing the prior-year return to develop a plan for the future Planning for middle-income taxpayers: financial planning for the young, the working, and those approaching or in retirement Best financial planning ideas for young people
Build a Data Model for Analysis in Power BI
-
Online
4.00 Credits
Member Price: $149
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.
Ethical Considerations in Working with Cannabis
-
Online
1.00 Credits
Member Price: $55
The major topics covered in this class include:Framework for assessing the propriety of offering services within the state legal, regulated cannabis industryAssist in identifying key stakeholders to be considered in conjunction to providing cannabis industry services, including:partnersstaffclientsBanking relationshipsMalpractice insurance
Surgent's The Complete Guide to Payroll Taxes and 1099 Issues
-
Online
8.00 Credits
Member Price: $279
Payroll tax requirements for wages, including wages subject to the .9 percent tax, employee benefits and reimbursements, nonqualified deferred compensation, stock options, and tips Fringe benefits issues, such as health insurance, life insurance, cafeteria plan benefits, accountable and non-accountable plans, standard mileage rates, and per diem rates Special issues -- Using a common paymaster, how to file W-2s after a takeover, merger, or acquisition, and state and local tax withholding Statutory employees, independent contractors, and possible changes to §530 relief Penalties -- Who is a responsible person? Expenses and gross-up calculations Pension issues and payroll taxes including SIMPLE plans, and §401(k) and pension distributions The Electronic Federal Tax Payment System (EFTPS) Forms I-9, W-9, W-2, 1099, 1099-NEC, SS-8, and 940 Understanding payroll tax responsibilities in the gig economy
2025 A&A Update With Technology Implementation
-
Online
4.00 Credits
Member Price: $149
The major topics that will be covered in this course include:Deep dive into the Accounting Standards Updates (ASUs) effective in 2025.Insights from the FAF's 2024 PCC Review.Overview of FASB's Invitation to Comment - Agenda Consultation.The essential changes in quality management standards that firms must implement by the end of 2025. Common deficiencies identified by the DOL in EBP (Employee Benefit Plan) engagements and provide a peek at upcoming projects from the Auditing Standards Board (ASB).
Shortcuts that Excel Users Love
-
Online
2.00 Credits
Member Price: $89
The major topics covered in this course include:The power of keyboard shortcutsOft used features with more capability than meets the eyeNew helpful featuresNote: This session is taught using Hands-On methodology. We provide practice files that tie to the examples in the course materials so participants can undertake all the steps in unison with the instructor.
IRS Penalties and Abatements
-
Online
2.00 Credits
Member Price: $89
The major topics covered in this class include:Various types of penalties: Accuracy related, fraud, understatement of valuation, reporting requirement, failure to pay, and pay or deposit penaltiesRules on waiver of penalties and interestsVarious forms and procedures for requesting reliefFirst Time Abatement: Requirements and proceduresHow an individual taxpayer qualifies for Reasonable Cause abatementProcedures for requesting refund of paid penaltiesAvailable administrative options
Surgent's Going Out on Your Own: Entity Types and Accounting Methods
-
Online
2.00 Credits
Member Price: $99
Financial planning pyramid What to consider when picking an entity Single member LLC vs. sole proprietorship Corporations – S vs. C Double taxation
Surgent's Guide and Update to Compilations, Reviews, and Preparations
-
Online
4.00 Credits
Member Price: $159
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
Hot Topics Accounting Update
-
Online
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:New accounting standards.The impact on Financial Reporting.Hot topics in financial reporting.Current and emerging US GAAP requirements.
Surgent's Basics of Employment Law for Non-HR Professionals
-
Online
4.00 Credits
Member Price: $159
How the application of policies and employment laws within the workplace can reduce employee complaints, and protect your company from claims of discrimination or wrongful behavior Examining wage and pay practices, FMLA examples, and other challenging workplace questions, to insure actions are consistent with laws/policies Key functions of employment including recruitment, interviewing and selection
Exploring Internal Controls That Could Have Prevented Frauds
-
Online
2.00 Credits
Member Price: $89
The major topics covered in this class include:Examination of actual fraudsDiscussion of internal controls that could have prevented the fraudsContemplation of epiphanies for your own professional scenarios