CPE Catalog & Events
Advanced Excel: Hidden Secrets and Gems
-
Virtual
2.00 Credits
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
Best Non-Google Search Tools for Accountants
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Why Advanced Search Skills Are So Critical for AccountantsWhy You Need More than Google to Search the InternetGARP: Generally Accepted Research PrinciplesAlternatives to GoogleAdvisory SearchSocial SearchSpecialty searchSearch Engine resourcesWhat's Ahead in Search
Tactics to Find Work Life Balance in a Complex World
-
Virtual
1.00 Credits
The major topics covered in this class include:How to get more out of one's workHow to achieve greater balance between today's ever more demanding and complex demands of work without losing sight of what is important in daily routinesExample of how to develop and be challenged by your own personal bucket list
CPAs and Addictions: Finding Hope and Healing
-
Online
2.00 Credits
Prevalence of substance abuse and depression among CPAs compared to the general population Factors that cause CPAs to be particularly susceptible to drug and alcohol abuse and mental health issues Identifying reasons why CPAs are reluctant to seek help Resources available for CPAs seeking help Support role that friends, loved ones and colleagues can play AICPA Code of Professional Conduct
Independence for Auditors - AICPA, PCAOB, GAO & DOL
-
Online
4.00 Credits
Auditing Yellowbook AICPA, GAO, DOL and PCAOB
What's Changing in Risk Assessment
-
Online
2.00 Credits
Auditing Yellowbook
Private Company Simplified GAAP Alternatives
-
Online
2.00 Credits
Guidance, related to "plain vanilla" interest rate swaps that convert variable into fixed rate debt and other derivatives Guidance related to amortization and impairment of goodwill Guidance related to separately recognizing intangible assets from goodwill in a business combination Guidance related to lease accounting and revenue recognition options
Individual Tax Update: Recent Developments
-
Online
2.00 Credits
Recent tax legislation, rulings and developments impacting individual taxpayers Credits (child, dependent care, earned income, health) Key rulings and regulations affecting individual taxpayers, including the Section 199A deduction, capital gains and losses, rental real estate and other passive activities losses, and other topics
Accounting of the Soul: Making the World a Better Place
-
Virtual
1.00 Credits
The major topics covered in this course include:Overview of Virtue Ethics and the Common GoodProfessionalismThe Virtue of CompassionGossip in the WorkplaceGratitude
The AB5s of Employees and Independent Contractors
-
Online
2.00 Credits
Four ways to classify a worker IRS 20 Factors 20% Section 199A deduction Cost of misclassifying an employee Section 530 relief Game changing impact of the Dynamex case and AB5
Surgent's Employer's Handbook: Health Care, Retirement, and Fringe Benefit Tax Issues
-
Virtual
4.00 Credits
ERISA compliance: employee welfare plans and qualified plans Fringe benefit issues: COBRA, Family and Medical Leave Act, and new developments in health care Health care plans: HRAs, HSAs, and other employer-sponsored plans Qualified plan requirements: eligibility, coverage, and vesting
Forensic Accounting: Finding Hidden Treasure in Tax Returns
-
Virtual
4.00 Credits
The major topics that will be covered in this course include:The rules of IRS disclosure of tax informationUnderstanding the role of IRS transcriptsInterpreting the actions of the IRS in transcriptsFOIA requestsAnalyzing tax information and returns for financial leads
Managing Current Fraud Trends in a Shifting Environment
-
Virtual
8.00 Credits
The major topics that will be covered in this course include:Summary of the impact of fraud on entities worldwide.Common fraud schemes and typical median losses that result.How smaller entity fraud risk differs from those of larger entities.The statistical profile of the most common fraud perpetrator.The most effective methods for preventing and detecting fraud.Cybersecurity risk management trends and best practices.
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
Understanding the New Forms K-2 and K-3
-
Virtual
2.00 Credits
The major topics covered in this class include:Introduction to Schedules K-2 and K-3Review the filing requirementsDiscuss the different parts of the schedules and what needs to be included
Create Measures in Power BI that Define Your Metrics
-
Virtual
4.00 Credits
The major topics that will be covered in this class include:Introduction to DAX: Understanding the fundamentals of DAX and its role in Power BI.Advanced DAX Formulas: Delving into complex DAX functions and formulas for creating sophisticated measures.Time Intelligence in DAX: Exploring time-based functions to analyze data over different periods.Validating Measures with DAX: Techniques for ensuring accuracy and reliability in your DAX measures.Using PivotTables for Measure Validation: Employing PivotTables in Power BI to test and confirm the effectiveness of DAX measures.
Strategies for Guiding Clients Through Challenging Situations: Tax Insights
-
Online
8.00 Credits
Navigating the tax and non-tax dimensions of divorce. Unveiling tax and non-tax considerations in personal bankruptcy, debt cancellation, foreclosure, repossession, and bad debt reporting. Exploring the tax and non-tax aspects of personal relationship matters, encompassing cohabitation, property rights, premarital agreements, filing status, exemptions, and dependents. Grasping the intricacies of support considerations for spouses and former spouses. Addressing support matters for children of divorced or separated parents, alongside the tax treatment of back child support. Delving into the business implications in instances of business dissolution. Tackling specialized topics, including marital property rules, tax rate comparisons for married and unmarried individuals, head of household status, and treatment of refunds and deficiencies.
State Tax Nexus: Frequently Awkward Questions
-
Online
2.00 Credits
Frequently asked questions about income tax and sales tax nexus New developments Key factors in reviewing potential nexus consequences Nexus road trip to eight large states Tax impacts of remote work Free, multistate resources
Clean, Transform & Load Data in Power BI
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Introduction to Power Query in Power BI: Understanding the interface and basic functionalities.Data Cleaning Techniques: Removing duplicates, handling null values, and data type conversions.Data Transformation: Advanced methods for manipulating data, including pivoting, merging, and appending queries.Data Loading: Efficiently loading data into the Power BI data model.Document the Process Steps: Setting up details for each step in the process so you can document what is happening and why.
Mastering Partnership Basis: Inside and Outside Basis
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Explain the use of both "inside" and "outside” basis determination.How to calculate tax basis capital accounts, including when the entity is formed, including the impact of contributed property.Clarify the importance of partnership capital accounts and partnerships debt on partner's tax basis.Explanation of how basis is impacted distributions and by sale and/or liquidation of the partnership interest.Comprehensive example to illustrate the mechanics of the basis determination process.
