CPE Catalog & Events
Surgent's The 10 Must-Know Excel Features
Available Until
Virtual
2.00 Credits
Using Excel tables for efficient data management, including sorting, filtering, and structured references, to manage data more effectively Using custom sorting options to organize data in a way that best suits your needs, enhancing data readability and analysis Using XLOOKUP for advanced data retrieval, allowing you to extract specific data from extensive datasets with ease Using the SUBTOTAL function, a versatile tool for calculating data in visible cells, ideal for analyses that require dynamic calculations Using SUMIF and SUMIFS functions for conditional summing, crucial for precise budgeting, expense tracking, and financial reporting Using array formulas to perform multiple calculations on one or more items in an array, enhancing the efficiency of complex accounting computations Implementing data validations to ensure data integrity and prevent errors in financial data entry, a critical skill for maintaining accurate accounting records Using slicers for interactive data segmentation in tables and PivotTables, enabling accountants to quickly filter and analyze specific subsets of financial data Applying conditional formatting to highlight critical financial data points, trends, and variances, making data analysis and interpretation more intuitive Introducing PivotTables, one of the most powerful Excel features, for summarizing, analyzing, and presenting large sets of financial data in a digestible format
Surgent's The CMA's Guide to Project Management
Available Until
Virtual
2.00 Credits
Establishing a system: identifying forces that support the status quo; setting milestones and goals; the role of the CMA Necessary first steps: set a framework for the project’s activities; identify needed resources; obtain support; decide on a structure; establish a team for a specific project; identify necessary team skill sets Project evaluation: analytical tools, strategic evaluation; sources of risk Maintaining focus: monitoring and measuring results; keeping to the project’s scope Avoiding frequent traps: sunk costs; financing pitfalls; project creep; tunnel vision; failure to integrate the team’s work internally and/or the final project with the remaining organization Introduction and examples of analytical tools throughout the session: mapping; CPM; Gantt charts; benchmarking; Pareto analysis; PESTLE analysis; valuation techniques; post-completion evaluations
Surgent's The Complete Guide to Liquidation of Business Entities
Available Until
Virtual
8.00 Credits
The impact of recent legislation Unique planning opportunities and tax traps involved in the liquidation of a business entity Installment sales and the big hurdles to favorable tax treatment in liquidation Form 966 and its importance An analysis of liquidation timing Strategies to pursue in light of the tax rates on dividends and capital gains The special problems of liquidating subchapter S corporations Key planning issues and benefits in liquidating partnerships and limited liability companies Expansion of the carried interest provisions of Rev. Proc. 93-27
Surgent's The Complete Guide to Payroll Taxes and 1099 Issues
Available Until
Virtual
16.00 Credits
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
Surgent's The Complete Guide to Payroll Taxes and 1099 Issues
Available Until
Virtual
8.00 Credits
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
Surgent's The Complete Trust Workshop
Available Until
Virtual
16.00 Credits
Timely coverage of breaking tax legislation Guide to legislative changes and their impact on trust planning Introduction to trusts with emphasis on typical provisions Revocable living trusts Common testamentary trust arrangements -- Bypass trusts, QTIP trusts, and other marital trusts Asset protection trusts Sophisticated trusts for estate planning and asset transfer -- GRATs, GRUTs, and QPRTs Charitable trusts -- Charitable remainder trusts, charitable lead trusts, and pooled income funds Irrevocable life insurance trusts Medicaid trusts: special needs and Miller Trusts for minors -- Sections 2503(b) and 2503(c), and other trusts Dynasty trusts Section 461(l) as applied to trusts and estates Trusts to hold S corporation stock Special problems of estates and trusts relating to the 3.8-percent tax on investment income and specific solutions Increased scrutiny of donor advised funds
Surgent's The Essential Guide to SEC Form 10-K: Compliance, Disclosures, and Best Practices
Available Until
Virtual
4.00 Credits
Comparison with other SEC filings Overview of the Securities Exchange Act of 1934 Purpose and importance of MD&A Risk factors, controls, and corporate governance disclosures
Surgent's The Essential Multistate Tax Update
Available Until
Virtual
4.00 Credits
Employees working in multiple states: Withholding issues (when to start and where to withhold) special issues depending on type of tax assessed in the state or locality Emerging sales tax topics: Elimination of the physical presence standard in determining nexus (Wayfair case); economic nexus for remote sellers; assisting remote sellers in determining a plan of action in states that enforce economic nexus Emerging compliance issues in the new sales tax economy Income Tax (and other forms of tax): Economic nexus (taxation without physical presence) Will states shift away from income tax and increase reliance on sales tax after Wayfair? Treatment of Tax Cuts and Jobs Act by the states: presence of intangible property; is P.L. 86-272 still valid? Pass-through problems: Nexus issues for interest owners Treatment of the 199A deduction for pass through entities by states: Withholding issues Practical considerations in dealing with multistate taxation: Dealing with state nexus questionnaires When to consider voluntary compliance: Responsibility of officers, members, partners, and shareholders; planning ideas and opportunities; updates on pending federal legislation relative to state tax
Surgent's The Essential Multistate Tax Update
Available Until
Virtual
4.00 Credits
Employees working in multiple states: Withholding issues (when to start and where to withhold) special issues depending on type of tax assessed in the state or locality Emerging sales tax topics: Elimination of the physical presence standard in determining nexus (Wayfair case); economic nexus for remote sellers; assisting remote sellers in determining a plan of action in states that enforce economic nexus Emerging compliance issues in the new sales tax economy Income Tax (and other forms of tax): Economic nexus (taxation without physical presence) Will states shift away from income tax and increase reliance on sales tax after Wayfair? Treatment of Tax Cuts and Jobs Act by the states: presence of intangible property; is P.L. 86-272 still valid? Pass-through problems: Nexus issues for interest owners Treatment of the 199A deduction for pass through entities by states: Withholding issues Practical considerations in dealing with multistate taxation: Dealing with state nexus questionnaires When to consider voluntary compliance: Responsibility of officers, members, partners, and shareholders; planning ideas and opportunities; updates on pending federal legislation relative to state tax
Surgent's The Latest and Greatest Excel Features
Available Until
Virtual
2.00 Credits
Overview of the latest updates in Excel, focusing on their purpose and potential impact on efficiency and productivity New automation tools, including features that streamline repetitive tasks and data analysis Fuzzy matching of textual data in Microsoft Excel Features that help to efficiently use data
Surgent's The Most Critical Challenges in Governmental Accounting Today
Available Until
Virtual
4.00 Credits
The 2024 implementation of GASB No. 100 on accounting changes and error corrections The end of 2024 application of GASB No. 101 addressing compensated absences Additional recently issued GASB standards and projects
Surgent's The Most Critical Challenges in Governmental Accounting Today
Available Until
Virtual
4.00 Credits
The implementation of GASB No. 101 on compensated absences GASB No. 103 addressing improvements to the financial reporting model The application of GASB No. 102 on certain risk disclosures and GASB No. 104 on disclosure of certain capital assets
Surgent's The Most Critical Challenges in Not-for-Profit Accounting Today
Available Until
Virtual
4.00 Credits
Lessons learned (and lessons remaining) for the implementation of FASB ASC 842, Leases, and the new requirements related to contributions of nonfinancial assets in ASU No. 2020-07 Solving contribution conundrums (e.g., conditional contributions, restricted contributions, contributed services, etc.) Additional issues in not-for-profit financial reporting
Surgent's The Most Critical Challenges in Not-for-Profit Accounting Today
Available Until
Virtual
4.00 Credits
Key issues related to not-for-profit financial reporting (e.g., presenting a measure of operations, various disclosures, concentrations of risk, and etc.) Key challenges encountered in not-for-profit accounting (e.g., contributed services, restricted contributions, conditional contributions, membership dues, noncash contributions, and etc.) Additional issues in not-for-profit financial reporting
Surgent's The Risks and Benefits of ChatGPT and Artificial Intelligence
Available Until
Virtual
2.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
Surgent's The Role of the Whistle-Blower
Available Until
Virtual
2.00 Credits
Understanding whistle-blowing When should you blow the whistle? Types of whistle-blower channels The whistle-blower's dilemma Successful whistle-blower letters When is whistle-blowing unethical? Laws to protect whistle-blowers Ten whistle-blowing myths
Surgent's The Top Five Tax Issues in Dealing with LLCs and Partnerships
Available Until
Virtual
4.00 Credits
Self-employment tax issues: what you can and cannot do Capital accounts: book vs. tax issues Determining basis: key issues and technical analysis in calculating basis Dealing with debt: recourse, nonrecourse, and why it matters Guaranteed payments, distributive shares, and draws: understanding the difference
Surgent's This Year's Best Income Tax, Estate Tax, and Financial-Planning Ideas
Available Until
Virtual
12.00 Credits
Timely coverage of breaking tax legislation Preident Trump's tax proposals - Review key components of President Trump's tax agenda presented during his presidential campaign The SECURE 2.0 Act and Inflation Reduction Act provisions applicable to individuals Changes to the lifetime estate tax exemption in light of proposed regulations Considerations when selling a principal residence Tax benefits of HSAs An overview of the mechanics and practical considerations of Donor Advised Funds Virtual currency and digital assets - understand the new Form 1099-DA for reporting digital assets The best new income tax and estate-planning ideas The changing Social Security landscape: long-term solvency issues and what it means for retirement planning Creative charitable giving strategies Financial planning strategies Maximizing retirement plan benefits Using intentionally defective grantor trusts Miscellaneous tax-planning techniques that can add up to significant tax savings How to use the whole family for tax savings Life insurance Up-to-the-minute ideas reflecting new tax law changes in cases, regulations, and rulings
Surgent's This Year's Top Tax and Financial-Planning Ideas
Available Until
Virtual
8.00 Credits
Timely coverage of breaking tax legislation, including the SECURE 2.0 Act and Inflation Reduction Act provisions applicable to individuals Changes to the lifetime estate tax exemption by the TCJA in light of April 2022 proposed regulations Considerations when selling a principal residence Tax benefits of HSAs An overview of the mechanics and practical considerations of Donor Advised Funds Virtual currency and digital assets The Corporate Transparency Act and FinCEN Beneficial Ownership Information reporting An update on income tax and estate-planning ideas, including any recent changes Tax ideas for the current year Miscellaneous tax-planning techniques that can add up to significant tax savings How to use the whole family for tax savings Up-to-the-minute ideas reflecting new tax law changes in cases, regulations, and rulings
Surgent's Time Management for Professionals
Available Until
Virtual
2.00 Credits
Managing interruptions The role of activity logs, to-do lists and a priority matrix The psychology of time management Staying on track of your time management plan Controlling procrastination Blocking out time Creating an effective time management plan
