CPE Catalog & Events
Excel for Accounting Professionals Session 5: Error Trapping and Improving Lookups
-
Virtual
2.00 Credits
VLOOKUP function MATCH function INDEX function Error trapping IF function
Using ChatGPT with Excel
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Introduction to ChatGPT and other AI (Artificial Intelligence) language modelsDiscussion of best practices for using ChatGPT with ExcelUse ChatGPT to create, debug and explain formulasUse ChatGPT to learn how to use Excel featuresUse ChatGPT to automate repetitive tasks in ExcelUse ChatGPT to easily create macros
Surgent's Successful Communication
-
Virtual
4.00 Credits
The communication process and barriers that get in the way Techniques for overcoming barriers Understanding and self-assessment of each component of the communication process Gaining skills to listen more effectively, especially in stressful situations with heightened emotions Action plan to apply techniques in the workplace for communication success
Enterprise-Wide Risk Management in Accounting and Finance
-
Virtual
4.00 Credits
The major topics that will be covered in this course include:Enterprise-wide risk management best practices for identifying, evaluating, and determining how to respond to relevant risks.The importance of risk and uncertainty disclosures in the preparation and fair presentation of financial statements, including evolving risks with cybersecurity and ESG.Coordinating risk management efforts, including the required involvement of corporate governance.How to embed risk management into day-to-day accounting and finance activities.
Building Security and Efficiency With Internal Control
-
Virtual
8.00 Credits
The major topics covered in this course include:An overview of control frameworks and conceptsStrategic considerations that can be incorporated into control developmentUnderstanding and controlling risk that arises when organizations change or choose not toThe COSO Internal Control Framework and the COSO ERM Framework
Surgent's Predicting Future Financial Issues Facing the Financial Executive
-
Virtual
8.00 Credits
CPA becoming attuned to broad based business knowledge, professional skepticism, and subordination of judgment The future of medical care in the United States in a post COVID-19 environment Future of social security and impact on retirement planning and employee retention Impact on financial executive if the dollar is no longer the world currency “Fate of the States” – will the location of your business make you less competitive Future of workmen’s compensation and unemployment compensation Future of interest rates Impact of greater reliance on technology AICPA top 10 trends and technologies National infrastructure ESG and DEI trends in the global economy Impact of continuing uncertainty in markets
How to Start a CFO Service
-
Virtual
1.00 Credits
The major topics that will be covered in this course include:What business owners really want from a CFO/business advisory service (it's not what you think).How to determine if you're qualified to provide CFO/business advisory services.Why now is the right time to be providing CFO/business advisory services.How to get new clients to your practice and how to approach existing clients.Why clients need you and why you need them.How much you should be charging for this type of service.How to provide a CFO/business advisory service in the most efficient way possible.
The ABCs of Advisory Services
-
Online
2.00 Credits
Understanding the concept of “Integrated Planning” (financial, estate, asset protection, and tax planning) Changes in the landscape of a tax practitioner’s practice The bridging of services Getting started – Where do your clients fail? Understanding the primary planning issues for all clients Estate and Gift issues Traps, pitfalls, and tips in planning Practical steps in establishing a tax advisory and wealth management services practice Domicile issues
Will Your Ethics Be Burned by Burnout?
-
Virtual
2.00 Credits
The major topics covered in this class include:Explore the effects of crisis and burnout on ethical decision-makingDefine the stressors, pressures, and biases that can lead good people to make less than optimal choicesDiscuss ways to offset the pressures, ways to reduce stress on ourselves and on our team, and ways to support our teamsLearn how to recognize when an individual or an organization is heading in the wrong direction and how to stop sliding down the slippery slope
The Radar Phenomenon
-
Online
1.00 Credits
Internal Controls Fraud Prevention Fraud Investigation
ChatGPT: What Every CPA Should Know-Updated
-
Virtual
2.00 Credits
The major topics covered in this course include:Overview of the current landscape for AI in businessHistory of ChatGPT and generative AIFundamentals of generative AI technology and related nomenclatureABC's of how to use ChatGPTDemonstration of practical ChatGPT applications for accounting, finance and taxA word of caution: What you should be concerned aboutDeveloping a ChatGPT usage policy for your firm / business
Ethics With A Dash of Courage
-
Virtual
2.00 Credits
The Value of a Courageous Culture and courageous decision-making models Challenges to creating a culture of courage Communicating your courageous culture How/When to speak up? Career-ending vs teachable moment? Supporting courageous decisions Communicating courage The Journey to Leading with Courage - Building a personal action plan
Surgent's Hiring New Workers and Payroll Taxes
-
Virtual
2.00 Credits
Form W-4 Form I-9 Form W-9 End-of-year compliance Payroll tax returns Unemployment insurance
Audit & Attest Quality Matters that Should be on Your Radar - Avoiding Common Deficiencies in SAS, SSARS and SSAE Engagements
-
Online
8.00 Credits
Applying professional skepticism to ensure quality work Meaningful risk assessment when designing work programs for various levels of services Proper planning and supervision of all engagements Accountant responsibilities for evaluating internal control Strengthening analytic procedures to support conclusions Complying with the Code of Professional Conduct and quality management standards
Partnership & LLC (Form 1065) - Formation to Liquidation
-
Online
8.00 Credits
Extensive review of the partnership tax laws with an emphasis on any new legislative changes Overview of different forms of business entities including the check-the-box regulations Formation issues including the mandatory allocation of the §704(c) pre-contribution gain or losses back to the contributing partner/member Schedule K and K-1 – separately stated versus non-separately stated income and expense items Detailed Schedule K-1 reporting including the 20% qualified business income (QBI) deduction and 3.8% net investment income tax Calculating the tax and §704(b) book capital accounts Substantial economic effect requirement to have special allocations to the partners/members Allocation of recourse & non-recourse debt on K-1s Guaranteed payment issues and tax treatment of fringe benefits Self-employment tax issues and pitfalls Tax treatment of distributions – cash versus non-cash & liquidating versus non-liquidating Sales and liquidations (redemptions) of partnership interests §754 optional basis adjustments and mandatory adjustments
K2's Excel PivotTables for Accountants
-
Online
8.00 Credits
PivotTable fundamentals, including Recommended PivotTables and the six elements of PivotTables Formatting PivotTables Advanced PivotTable techniques and options, including consolidation PivotTables, user-defined calculations, and working with Power Pivot Analytical techniques available in PivotTables
Guide Strategy, Attract Investments with Financial Forecasts
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Introduction to Financial Statement ForecastingOverview of the importance and benefits of forecasting for strategic planning and investment attraction.The Forecasting Process: Steps to project future income, expenses, and resources using historical data and market trends.Analyzing Historical Data: Methods for leveraging past financial data to inform future projections.Incorporating Market Trends: How to integrate market insights into financial forecasts.Forecasting Profitability: Techniques for predicting future earnings and their implications for budgeting, cash flow management, and investment planning.Forecasting the Balance Sheet: Approaches for predicting future financial positions, including growth potential, solvency, and capital structure
2025 A&A Update With Technology Implementation
-
Virtual
4.00 Credits
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).
The Controllership Series - The Treasury Function Part 1 - Cash and Investing
-
Online
2.00 Credits
Accounting Finance Cash Investments
Corporate Transparency Act Developments
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Background of the Corporate Transparency ActBeneficial Ownership Information Reporting (BOIR) Rule Entities required to report.Reporting requirements imposed by the CTADue dates of reportsInformation needed to satisfy the BOIRImpact of failure to reportHow to submit a reportCourt rulings on CTA’s unconstitutionalityImplications to entities as a result of the ruling in NSB.Potential reporting requirements due to FinCen’s proposed rulemaking with respect to non-financed purchases of residential real estate and gratuitous transfers.
