CPE Catalog & Events
Excel for Accounting Professionals Session 5: Error Trapping and Improving Lookups
-
Online
2.00 Credits
Member Price: $125
VLOOKUP function MATCH function INDEX function Error trapping IF function
Surgent's Successful Communication
-
Online
4.00 Credits
Member Price: $159
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
-
Online
4.00 Credits
Member Price: $149
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.
Accounting Fraud 25-26
-
Online
8.00 Credits
Member Price: $329
The elements of fraud and the Fraud Triangle Theory Types of fraud with a focus on management fraud Best practices in fraud detection and deterrence
Advanced Personal Financial Planning Update 25-26
-
Online
8.00 Credits
Member Price: $329
Retirement: accumulation and decumulation techniques, Social Security, Medicare and long-term care Debt management, including reverse mortgages and education financing Insurance and investments from a life-planning perspective Income tax legislation, cases, and rulings Estate and trust planning strategies
Not-for-Profit Organizations: Treasury Utilizing QuickBooks 25-26
-
Online
8.00 Credits
Member Price: $329
Financial entity IRS filing status Recent ASC updates affecting nonprofits Inflows and Outflows QuickBooks Desktop Setup Data entry Reporting Governance policies and budgeting
Building Security and Efficiency With Internal Control
-
Online
8.00 Credits
Member Price: $239
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
-
Online
8.00 Credits
Member Price: $279
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
The Yellow Book: From Beginning to End
-
Online
8.00 Credits
Member Price: $275
Introduction Foundation and principles General requirements for complying with Government Auditing Standards Ethics, independence and professional judgment Competence and continuing professional education Quality control and peer review Standards for financial audits Standards for attestation engagements and reviews of financial statements
Internal Control Frameworks for Single Audit
-
Online
1.00 Credits
Member Price: $59
COSO 2013 Update Yellowbook Accounting
The Radar Phenomenon
-
Online
1.00 Credits
Member Price: $59
Internal Controls Fraud Prevention Fraud Investigation
PowerPoint: Tips & Tricks for Today's Accountant
-
Online
2.00 Credits
Member Price: $109
Exploration of tabs within PowerPoint’s ribbon Initial creation of a slide deck Using slide masters Utilization of external content SmartArt Alignments and layouts Tips and tricks for efficiency Best practices for effective presentation delivery Other creative uses for PowerPoint
Roadmap to Ethical Decision Making
-
Online
2.00 Credits
Member Price: $109
Provide best practice tips and practical strategies for preserving independence when assisting clients with technical matters Discuss the principles of professional conduct Address compliance with professional standards Use case studies to address circumstances that may create threats to independence
Advanced Excel: Hidden Secrets and Gems
-
Online
2.00 Credits
Member Price: $109
Awareness of advanced functions Creative methods for data manipulation Real-life examples of innovative ways to analyze and report data with Excel Using Excel to perform e-mail merges Many other functions and techniques that inspire you to continue exploring the depths of Excel and its seemingly bottomless toolbox
ChatGPT: What Every CPA Should Know-Updated
-
Online
2.00 Credits
Member Price: $89
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
-
Online
2.00 Credits
Member Price: $125
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
-
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
Gamed: Why Performance Targets and Incentives Fail and How to Fix Them
-
Online
4.00 Credits
Member Price: $159
Diagnosing problems with existing performance targets and incentives Designing performance targets (that work in the real world) Designing incentives the drive the intended behaviours and outcomes Avoiding common mistakes, problems and pitfalls with performance targets and incentives
Partnership & LLC (Form 1065) - Formation to Liquidation
-
Online
8.00 Credits
Member Price: $400
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
Guide Strategy, Attract Investments with Financial Forecasts
-
Online
2.00 Credits
Member Price: $89
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