CPE Catalog & Events
ACPEN: Microsoft Excel: Moving Beyond the Basics
-
Online
2.00 Credits
Using formulas to manipulate and transform data Using formulas and reference formulas such as =VLOOKUP Using pivot tables Understanding Solver to perform multivariate analysis
Money Laundering Awareness for Accountants
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Money laundering overviewRole of tax examiners and auditorsTax return examinationPre-audit indicatorsAudit flagsReal estate issuesCash indicatorsInternational trade signalsLoan considerationsProfessional service provider concernsMoney laundering and ethics
ACPEN: HR Investigations – Episode 1 – Introduction-Assessing-Planning
-
Online
1.00 Credits
Investigation terminology Assessment skills Investigative methodology
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
ACPEN: Current Fraud Trends - Nonprofit and Government Entities
-
Online
2.00 Credits
Best practices for fraud prevention and detection Common fraud schemes in nonprofit and government entities including cash misappropriation, payroll fraud, vendor fraud, falsified billings, improper use of credit cards or purchase cards, the redirection of cash and non-cash contributions, personal use of assets, the redirection of grant benefits, other grant related fraud, travel and expense reporting fraud
ACPEN: Advanced Negotiations: Never Split the Difference
-
Online
2.00 Credits
Negotiations Business Management
ACPEN: Schedule C of Form 1040
-
Online
2.00 Credits
When Schedule C applies Cash v. Accrual method Typical business deductions Business vehicle expenses Section 179 and bonus depreciation
Current Audit Environment and ASB Activity
-
Virtual
2.50 Credits
Current environment and implication for audit planning Key risk issues Audit challenges Recent Statements on Auditing Standards (SASs). ASB workplan SQMS No. 1, No. 2, and No. 3 SSARS No. 26
Surgent's Achieving High Levels of Compliance and Customer Service in Your Organization
-
Virtual
4.00 Credits
Why customer service is not just having nice people; it is truly serving the customer Analysis of the value of the customer to compare it to various costs creating an ROI How to develop a compliance program that adds value to the customer A hard look at several companies and industries that have mastered the dual objectives How recent developments have affected compliance and customer service
Surgent's You’ve Got This: An Introduction to Yellow Book and Single Audits
-
Virtual
0.00 Credits
What’s included (and excluded) in a Yellow Book audit Key qualification, performance, and reporting standards under the Yellow Book How single audits differ from financial statement audits, plus core concepts like the SEFA, major program determination, and findings reporting Fundamentals of testing internal controls over compliance and performing compliance testing
Surgent's Compilations, Reviews, and Preparations: Engagement Performance and Annual Update
-
Virtual
8.00 Credits
SSARS No. 21, Clarification and Recodification, and updates to SSARS No. 21 due to the issuance of SSARS No. 23, Omnibus Statement on Standards for Accounting and Review Services SSARS No. 22, Compilation of Pro Forma Financial Information SSARS No. 24, Omnibus Statement on Standards for Accounting and Review Services -- 2018 SSARS No. 25, Materiality in a Review of Financial Statements and Adverse Conclusions SSARS No. 26, Quality Management for an Engagement Conducted in Accordance With Statements on Standards for Accounting and Review Services Sample comprehensive engagement work programs for preparation, compilation and review engagements Reporting and disclosure illustrations for each level of service, including attesting on personal financial statements, prescribed form, special purpose framework and other engagement variations Other communication requirements, such as sample engagement letters and management representation letters
Introduction to Governmental Budgeting
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:The basics of governmental budgeting.Common steps and timeline of the budget process.What, when and how we should be monitoring the budget throughout the year.How long-term budgets fit in with the annual budget process.
ACPEN: The SECURE Act 2.0 – Planning Opportunities for Individuals
-
Online
1.20 Credits
Implications for individuals: Changes to the Saver’s Credit Changing the required minimum distribution rules for Roth 401(k)s Changes to required beginning dates for required minimum distributions of retirement plans. Penalty-Free Withdrawals for Certain Emergency Expenses Special provisions for firefighters and military personnel spouses Increases in catch-up contributions Impact on 529 plans Opportunities for student loan payment matching
ACPEN: Mergers & Acquisitions: Tips and Speed Bumps to Avoid
-
Online
2.00 Credits
Making strategic acquisitions Identifying potential acquisition candidates Alternatives to M&A Identifying and understanding organizational culture Understanding the keys to effective and efficient due diligence Planning and executing an effective integration Key considerations
Leverage PowerBI.com to Create Data Analysis for Others
-
Virtual
2.00 Credits
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 How to Effectively Represent Clients Under IRS Audit
-
Virtual
2.00 Credits
Why the IRS selects a tax return for audit What happens when the taxpayer disagrees with the results of the audit IRS employees who interact with taxpayers during an audit FATCA audits Types of IRS examinations Potential IRS audit outcomes Substitute for returns Large Partnership Compliance Program IRS’s shift in audit strategies Responding to IRS Notices online Audits of high income and high net-worth individuals The Bipartisan Budget Act of 2015 (BBA) and its impact on auditing partnerships IRS Letters of Concern
Surgent's Trump Accounts Created by OBBBA: A Comprehensive Guide for Accounting and Finance Professionals
-
Virtual
2.00 Credits
Establishing and administering a Trump Account Who can make contributions to a Trump Account Limits on contributions to a Trump Account Employer contributions to a Trump Account Participation in the pilot program What a Trump Account can invest in Basis tracking for after-tax contributions Taxation of distributions from a Trump Account Rolling a Trump Account into another account The potential advantages and disadvantages of having a Trump Account Opting out of a Trump Account Issues impacting a Trump Account, such as distribution, when the beneficiary turns 18
Surgent's Virtual Currency: Keeping Up with the Tax Code
-
Virtual
2.00 Credits
Overview of virtual currency Property transactions with virtual currency Receiving virtual currency as payment Paying using virtual currency Charitable donations with virtual currency Gifting of virtual currency Form 8300 reporting
Independence for Auditors - AICPA, PCAOB, GAO & DOL
-
Virtual
4.00 Credits
The major topics that will be covered in this course include:Independence requirements issued by the AICPA, Government Accountability Office (GAO), Department of Labor (DOL), and the Public Company Accounting Oversight Board / SEC. Common areas of confusion, nuanced differences among the frameworks, and considerations auditors should keep in mind when performing attest services for different types of clients.
Google Gemini AI for Accountants
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Google Gemini Quick StartGemini Standalone ChatbotMobile AppGemini integration with:WorkspaceGmailDocsSheetsSlidesUser Tips