CPE Catalog & Events
Ethics for CPAs: The Practical and the Possible
-
Online
2.00 Credits
Member Price: $109
The AICPA Code of Professional Conduct and its interpretations New developments in regulation at the national and state level Best practices, case studies, and disciplinary actions
Introduction to Forensic Data Analytics
-
Online
2.00 Credits
Member Price: $109
Data analytics Key fraud risk management guidance documents Data analytics frameworks Leading techniques and innovations for preventing and detecting fraud
Leverage PowerBI.com to Create Data Analysis for Others
-
Online
2.00 Credits
Member Price: $89
The major topics that will be covered in this class include:Tour of the PowerBI.com Interface: An in-depth walkthrough of the PowerBI.com environment, focusing on user interface elements, navigation, and customization.PowerBI.com Concepts: Fundamental concepts of PowerBI.com, including its architecture, data handling capabilities, and integration features.Connecting to Data: Techniques for connecting various data sources to PowerBI.com, ensuring seamless data integration and synchronization.Visualizations and Dashboards: Creating impactful visualizations and assembling informative dashboards to present data compellingly.Q&A Feature: Explore the interactive Q&A feature to derive insights through natural language queries.Sharing Datasets, Reports, Dashboards: Best practices for sharing datasets, reports, and dashboards with different audiences so they can leverage your data analysis work.Creating Apps: Learn how to package reports and dashboards into apps for easy distribution and consumption.
Surgent's Choosing the Right Business Entity
-
Online
2.00 Credits
Member Price: $99
Why businesses operate as C corporations Why businesses operate as pass-through entities Adopting C corporation status Why businesses choose S corporation status. Tax and business situations that impact entity selection.
Surgent's Excel Lookups: Moving Beyond VLOOKUP Limitations
-
Online
2.00 Credits
Member Price: $99
Using lookup functions as an alternative to direct cell references Understand the limitations of the VLOOKUP function Discover ways to move beyond these limitations
Surgent's Understanding Partnership Taxation: Debt Allocations
-
Online
2.00 Credits
Member Price: $99
Recourse debt allocations Constructive liquidation scenarios Nonrecourse debt allocations Minimum gains and nonrecourse deductions Section 704(c) gains Allocations under 704(c)
Independence for Auditors - AICPA, PCAOB, GAO & DOL
-
Online
4.00 Credits
Member Price: $159
Auditing Yellowbook AICPA, GAO, DOL and PCAOB
Federal Tax Update for Business with Doug Van Der Aa
-
Online
4.00 Credits
Member Price: $159
"Tax-mageddon" - the all-important impending expiration/extension/renewal of the TCJA Other recent legislative, judicial, and IRS developments impacting business taxpayers Current status of Research and Experimentation costs and Interest Expense Limitation Phaseout of Bonus Depreciation and MACRS issues S corporation and partnership developments Other miscellaneous business developments
Creative Strategies for Buying, Selling, or Gifting a Business
-
Online
8.00 Credits
Member Price: $275
Valuation methods for business interests Stock purchase versus asset purchase Estate transfer and tax considerations Gifting strategies for business interests Trusts and partnerships in business transfers Self-canceling installment notes in transactions Transferring S corporation stock to trusts Business interest transfer with Employee Stock Ownership Plan (ESOP)
Nonprofit Accounting and Financial Reporting Explained
-
Online
8.00 Credits
Member Price: $275
Discussion of financial reporting risks increased by the current economic environment, including increased uncertainty related to critical financial statement amounts and significant disclosures Executive summary of recent Accounting Standards Updates Overview of fair value disclosure requirements and implementation issues Discussion of issues related to donor-restricted endowment funds Classification of net assets and reclassifications Endowments, including accounting, disclosures and UPMIFA Noncascontributions Contributions received and receivable Expense recognition issues Reporting expenses by function and nature Other relevant matters unique to the nonprofit environment
Microsoft Excel: Moving Beyond the Basics
-
Online
2.00 Credits
Member Price: $109
Using formulas to manipulate and transform data Using formulas and reference formulas such as =VLOOKUP Using pivot tables Understanding Solver to perform multivariate analysis
Streamlined Excel Reporting Series Session 4: External Data and PivotCharts
-
Online
2.00 Credits
Member Price: $125
GETPIVOTDATA Text Files and Power Query Data Preparation PivotCharts
Common Yellow Book & Single Audit Deficiencies
-
Online
4.00 Credits
Member Price: $159
Auditing Yellowbook COVID-related funds
Google Gemini AI for Accountants
-
Online
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Google Gemini Quick StartGemini Standalone ChatbotMobile AppGemini integration with:WorkspaceGmailDocsSheetsSlidesUser Tips
HR Investigations - Episode 1 - Introduction-Assessing-Planning
-
Online
1.00 Credits
Member Price: $59
Investigation terminology Assessment skills Investigative methodology
Data Extraction, Transformation, Validation the Right Data Sources for Analysis
-
Online
2.00 Credits
Member Price: $109
Understand various data types Structured vs. unstructured data Completeness and validation testing Selecting the right data sources for the job Risks and pitfalls to avoid
PPP Fraud and Financial Professionals
-
Online
2.00 Credits
Member Price: $89
The major topics covered in this class include:Ethical dilemmasJudicial proceedingsMitigation strategiesCreating tools to help make better decisionsAtonement and reconciliation
Determining Reasonable Compensation for Owner Employees
-
Online
1.00 Credits
Member Price: $55
The major topics covered in this class include:An analytical framework for analyzing and opining on reasonable replacement compensation for owner-employees of closely held businesses and professional practices in the context of tax planning, compliance, management consulting and business appraisal assignmentsExecutive compensation components, including the valuation of non-qualified plans and restricted stock units
SECURE Act 2.0: What You Need to Know
-
Online
1.00 Credits
Member Price: $59
Expanding Automatic Enrollment in Retirement Plans Increased Age for RMDs Higher Catch-up Contribution Limit Emergency Expense Penalty-Free Withdrawals “Starter” 401(k)s for Certain Employers Part-time Worker Improved Coverage
Advanced Excel for Staff - Build Reports and Analyze Data
-
Online
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Building Reports Workflow: Understand the steps for creating professional and functional reports.Gather and Organize Data: Learn best practices for compiling and cleaning data for accurate analysis.Set Calculations and Key Metrics: Apply formulas and functions to calculate meaningful insights. Format and Structure Report: Use formatting tools to create visually appealing and structured reports.Review and Validate: Verify data accuracy and troubleshoot potential errors.Share the Report: Learn methods for distributing reports effectively within your organization.