CPE Catalog & Events
Complete Guide to Analyze Data with Excel PivotTables
-
TBD
4.0 Credits
Member Price: $149
The major topics that will be covered in this course include:Introduction to PivotTables: Gain a solid understanding of what PivotTables are, their benefits in Excel, and how to prepare your data for creating effective PivotTables.Creating and Customizing PivotTables: Learn step-by-step how to build and format PivotTables, including filtering, sorting, and customizing layouts for optimal data analysis. Focus on Using PivotTables to Analyze Data: Explore techniques to summarize, group, and compare data with PivotTables, uncovering trends and insights for better decision-making.Advanced PivotTable Features: Discover advanced tools such as slicers, timelines, and using PowerPivot for deeper analytical capabilities. Data Visualization with PivotCharts: Learn to create PivotCharts from your PivotTables and customize them to visually present data insights effectively to stakeholders.
Financial & Tax Accounting for S Corporations & Partnerships
-
TBD
8.0 Credits
Member Price: $239
The major topics that will be covered in this class include:Review the Accounting Standards Codification, OCBOA/Special Purpose Frameworks, and AICPA financial reporting framework and their application to partnerships, LLCs and S corporationsFinancial accounting issues arising from changes in ownershipFinancial vs. tax accounting for partnership/LLC capital accountsSection 704(b) substantial economic effect rules and their relation to financial accountingThe integration of financial accounting with Forms 1065 and 1120SFinancial accounting basis for ownership interests vs. tax accounting basis for ownership interestsDeferred tax accounting for partnerships/LLCs and S corporationsFinancial accounting for the operations of a partnership/LLCFinancial accounting impact of the C to S election and the S to C electionFinancial and tax accounting for S corporation shareholder equity and partner capital accountsFinancial vs. tax accounting for loans to and from S corporations and their shareholders
How to Get a Better Return on Yellow Book and Single Audits - Avoiding the Most Misapplied Audit Concepts
-
TBD
8.0 Credits
Member Price: $225
Discover the fundamental differences in the auditor's responsibilities between financial statement audits performed in accordance with the SASs and Yellow Book Understand risk assessment factors above those associated with a financial statement audit only Learn what must be done beyond the financial statement audit in order to issue required Yellow Book and Single Audit reports on internal controls and compliance Master designing, performing and documenting effective and efficient tests of compliance requirements Practice identifying, documenting and communicating the impact of internal control deficiencies and compliance audit findings to the client Common peer review deficiencies
Surgent's Technical Individual Practice Issues and Tax Forms for Experienced Practitioners
-
TBD
8.0 Credits
Member Price: $279
What’s NEW for this year – Items all practitioners must know Form 1040 and Schedules 1 – 3 1099-K reporting requirements Qualified Business Income -- Coverage of §199A including the real estate safe harbor A tour of the most recent forms changes, starting from gross income and ending with selected credits, including the latest IRS guidance on significant recent tax legislation How will clients (and practitioners) interact with IRS in the future and how the pandemic is steering the IRS to ramp up with digital communication efforts Hot developments and current areas of interest Virtual Currency and Digital Asset Taxation Advanced practice, reporting, and other issues intertwined with advanced planning and discussion ideas Form 6198 -- At-risk basis: Detailed case study and discussion of how this form is to be used and when it needs to be filed; learn how basis and at-risk basis are different, and why this is significant Form 6252 -- Installment sale income: A common tax area; however, a case study and discussion of this topic includes advanced issues such as gain on reacquisition of installment sale property, including worksheets on calculating gain & tax basis of reacquired property Form 5329 -- Additional taxes on qualified plans: Advanced study of how to avoid penalties
Surgent's The Complete Guide to Payroll Taxes and 1099 Issues
-
TBD
8.0 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
Hot Topics Accounting Update
-
TBD
2.0 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.
Making Culture A Competitive Advantage
-
TBD
1.0 Credits
Member Price: $39
Talent Strategy Culture Employee Engagement Employee Retention Leadership Leadership Strategy
Embracing Neurodiversity in the Workplace
-
TBD
1.0 Credits
Member Price: $39
Neurodiversity
Anti-Bullying and Sensitivity
-
TBD
1.0 Credits
Member Price: $39
Taking credit for someone else’s work. Repeatedly belittling a co-worker. Withholding essential information. Failing to invite someone to an essential meeting. Ignoring a coworker with the intent to harm or control. Engaging in ongoing passive-aggressive behavior in which words and actions appear harmless but have the intent to harm or control. Constant and unfair criticism. Social bantering and teasing. Yelling, shouting and screaming. Insults and behind-the-back put-downs. Hostile glares and other intimidating gestures. Malicious gossiping. Monopolizing supplies and other resources. Aggressive e-mails or notes. Overt threats and aggression or violence Am I the bully?
Group Audits: Who is Responsible for What?
-
TBD
2.0 Credits
Member Price: $79
Responsibilities of the group audit engagement team, including the group engagement partner Clarifying roles and responsibilities of component auditors and reference auditors in audits of group financial statements Special considerations on audit planning and audit reporting in a group audit
ProActive Response: Active Shooter Training - Recognize. Respond. Survive.
-
TBD
2.0 Credits
Member Price: $79
Early Warning Signs Concerning Behavior Changes Getting out Barricading your area Fighting for survival Disarming the assailant Tourniquets (commercial and improvised) Pressure Dressings Chest Seals
K2's Office Scripts - The New Macros
-
TBD
2.0 Credits
Member Price: $79
Introduction to Office Scripts Recording your first script Integration with Power Automate
Business Losses: Going Backward and Forward
-
TBD
2.0 Credits
Member Price: $79
Recent legislative developments for deducting business losses TCJA net operating losses rules of §461(l) §163(j) Business Interest Expense Limitations of deducting losses and basis What is the “quickie” refund; Section 465 At-Risk amount Section 469 Passive Activity Loss rules
Securing Your Data with a Password Management App - Updated
-
TBD
2.0 Credits
Member Price: $89
The major topics covered in this course include:Introduction to the world of password management apps and what makes them so secureReview and demonstration of top selling password management appsSoftware features that will be reviewedPassword generationEmergency user accessEntity vs. individual password managementDesktop vs. cloud basedMulti device synchronizationPII (personally identifiable information) forms fillerCredit card storageDigital data vault
Surgent's Business Writing: Professional & Effective Emails
-
TBD
2.0 Credits
Member Price: $99
Preparing to write: what is my purpose and objective and who is my audience When email is the appropriate communication methodology and when it’s not Common email mistakes and how to avoid them Proven techniques for writing more efficient, readable, and outcome-focused emails
Surgent's Update on the SECURE 2.0 Act
-
TBD
2.0 Credits
Member Price: $99
Automatic enrollment requirements for 401(k) plans Change in the credit for small employer pension plan startup costs $2,000 saver’s match Changes in pooled employer plans Multiple employer 403(b) plans Increase in age for required beginning date for mandatory distributions Indexing IRA catch-up limit Higher catch-up limit to apply at age 60, 61, 62, and 63 Treatment of student loan payments as elective deferrals for purposes of matching contributions Application of credit for small employer pension startup costs to employers who join an existing plan Small immediate financial incentives for contributing to a plan Withdrawals for certain emergency expenses Starter 401(k) plans for employers with no retirement plans Improving coverage for part-time workers Recovery of retirement plan overpayments Tax treatment of IRAs involved in a prohibited transaction Clarification of substantially equal periodic payment rule
What's Going on at the GASB
-
TBD
3.0 Credits
Member Price: $99
Leases SBITAs Public Private Partnerships Revenue & Expense Recognition Financial Reporting Model
K2's Excel Best Practices
-
TBD
8.0 Credits
Member Price: $225
Best practices associated with creating Excel workbooks, including managing workbooks How to secure Excel workbooks Collaboration options and best practices in Excel Effective reporting techniques in Excel
Advanced Excel: Hidden Secrets and Gems
-
TBD
2.0 Credits
Member Price: $89
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
Business Tax Update for Industry
-
TBD
2.0 Credits
Member Price: $79
“Tax-mageddon” – the all-important impending expiration/extension/renewal of the TCJA Other recent Federal legislative, rules and tax developments impacting business taxpayers Current status of Research and Experimentation costs and Interest Expense Limitation Phaseout of Bonus Depreciation and MACRS issues Latest legislative, judicial, and IRS developments