CPE Catalog & Events
Clean, Transform & Load Data in Power BI
-
Online
2.00 Credits
Member Price: $89
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.
Create Measures in Power BI that Define Your Metrics
-
Online
4.00 Credits
Member Price: $149
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.
Spring Tax Update with Steve Dilley
-
Online
8.00 Credits
Member Price: $239
The major topics that will be covered in this course include:Update and integration of the most recent tax legislation impacting individual and business taxpayers.Review of individual and business provisions of the Inflation Reduction Act.Update on significant individual and business tax developments related to cases and rulings.Update on earned income credit, child credit, and child and dependent care credit.Crypto reporting update.Depreciation changes in Sec. 179 and Sec. 168(k) bonus depreciation.Tax issues impacting "gig" workers, including Form 1099-K.Update on partnership and S corporations, including Schedules K-2 and K-3 of Forms 1065 and 1120S related to foreign transactions.
Performance Management
-
Online
1.00 Credits
Member Price: $59
Setting and resetting performance expectations On-the-spot counseling Addressing erratic performance Drafting and presenting performance appraisals
Productivity Hacks for Working Remote
-
Online
1.20 Credits
Member Price: $59
Virtual Work Remote Work Telecommuting Flexible Work Options
The New Quality Management Standards - What Everyone Needs to Know
-
Online
2.00 Credits
Member Price: $109
Overview of the new quality management standards Focus on the most important elements of a quality management system Implementation tips that everyone in the firm should know Audit and attest standards impacted
Keeping Up with the FASB
-
Online
2.00 Credits
Member Price: $89
The major topics covered in this class include:Review of current items on the FASB agendaDiscuss the new revenue recognition standardProvide an update on the new lease accounting standardAddress U.S. GAAP alternatives for certain entities
Surgent's How to Effectively Represent Clients Under IRS Audit
-
Online
2.00 Credits
Member Price: $99
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
-
Online
2.00 Credits
Member Price: $119
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
-
Online
2.00 Credits
Member Price: $119
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
Risk Assessment Under SAS No. 145
-
Online
2.00 Credits
Member Price: $125
Risk assessment under SAS No. 145 Overview of the steps to perform during risk assessment Testing the design, implementation, and operating effectiveness of controls New concepts due to the issuance of SAS No. 145
CFOs and Controllers Conference (Day 1)
-
Online
5.00 Credits
Member Price: $249
Details for this conference are subject to change, please follow this link to see the most up to date information: https://cpacrossings1.box.com/s/fz3yh8p2nt87vovs2osvmauiqtylzwhrSession 1: Economic UpdateCredits: 1 - FinanceGain insights into the latest economic trends and market changes shaping strategic decision-making for finance leaders.Session 2: AI Hot Topics for ControllersCredits: 1 - Information TechnologyA discussion of emerging applications of artificial intelligence in finance, including automation, compliance, and risk considerations. Session 3: Data Analytics and Business IntelligenceLearn how to leverage data-driven insights to enhance forecasting, performance measurement, and strategic growth. Credits: 1 - FinanceSession 4: IRS Federal Tax UpdateStay ahead of key federal tax changes and compliance considerations impacting businesses in the year ahead. Credits: 1 - TaxesSession 5: The Finance Executive's Guide to CybersecurityAn analysis of evolving cybersecurity threats and frameworks for protecting organizational financial systems and sensitive data. Credits: 1 - Information Technology
CONFERENCE: CFOs and Controllers
-
Online
9.00 Credits
Member Price: $498
Details for this conference are subject to change, please follow this link to see the most up to date information: https://cpacrossings1.box.com/s/fz3yh8p2nt87vovs2osvmauiqtylzwhrFollow the links below to register for individual days.Day 1: CFOs and Controllers Conference (Day 1)Day 2: CFOs and Controllers Conference (Day 2)The major topics that will be covered in this conference include:AI Hot TopicsData Analytics and Business IntelligenceFederal Tax UpdateCybersecurity for Financial ProfessionalsForecastingKPIsCorporate Insurance
Workforce Transformation and Talent Management in 2025
-
Online
1.00 Credits
Member Price: $55
To purchase the report referenced in this presentation, or any of the research papers published by CPA Crossings, visit https://www.cpacrossings.com/research. The major topics that will be covered in this course include: Understanding why the traditional pyramid structure is failing firms The inverted pentagon framework and its talent retention advantages Impact of technology and AI on entry-level accounting roles The 6 Ps of Business Model Transformation implementation Accelerating specialized skills acquisition in your workforce Effective knowledge transfer through mentorship and job rotation Technology-driven training and development strategies Best practices from other industries for workforce transformation Building and retaining specialized middle layers of expertise Strategic pricing models to support the pentagon structure
Internal Control - Testing for Operating Effectiveness
-
Online
2.00 Credits
Member Price: $89
The major topics covered in this class include:Generally accepted audit requirements related to testing controls for operating effectivenessIdentifying key controls that may prove effective and efficient to test in a control reliance strategyResponses when deviations are discovered when evaluating the design or operating effectiveness of internal controlLeveraging audit evidence available for Service Organization Control (SOC1) ReportsGeneral computer control considerations when evaluating the design and operating effectiveness of internal control over financial reporting
Financial Acumen for Today's HR Leader
-
Online
2.00 Credits
Member Price: $79
Financial Statement Insight Trend Analysis Financial Benchmarks
Partnership/LLC Taxation: Understanding Tax Basis Capital Accounts
-
Online
2.00 Credits
Member Price: $109
Discussion of the impact of the Section 199A flow-through entities deduction on partnerships and their partners The meaning of a "tax basis capital account" - how do the financial accounting and tax capital accounts differ from one another How to determine a partner's share of the partnership's liabilities Distinguishing "recourse" loans from "nonrecourse" loans What are "qualified nonrecourse financing" & loans and how they affect partners Section 704 "built-in gain or loss" & ules and how they impact Schedule K-1 reporting Section 465 "at risk" rules and how they impact Schedule K-1 reporting
Ethics: IRS Criminal Investigations: Key Lessons for Accountants
-
Online
2.00 Credits
Member Price: $89
Snapshot of IRS Criminal InvestigationsGeneral tax fraudAbusive tax schemesRefund fraudEmployment tax fraudIdentity theftData compromisesMoney launderingPublic corruptionCorporate fraudGeneral fraudsCyber crimesGlobal tax and economic crimesNarcotics, counter-terrorism and transnational organized crimeSelected Field Office Case Files from Across USNew EnglandMiddle AtlanticEast NorthCentralWest North CentralSouth AtlanticEast South Central West South CentralMountainPacificHow accountants can add value to their operations by aiding law enforcement and fighting economic crime
Surgent's Social Security: Dispelling Common Myths with Essential Truths
-
Online
2.00 Credits
Member Price: $119
Will Social Security be there for me? How is my benefit calculated? Can I claim my benefit and work too? When do I stop paying Social Security taxes? Why does my government pension cause my benefits to be reduced? Can I claim spousal benefits now and my own later? What is my breakeven? Can I claim benefits from my ex-spouse? What do you mean I may pay taxes on my income benefits? … and more!
Financial Decisions that Led Two Businessmen to Prison
-
Online
2.00 Credits
Member Price: $89
The major topics covered in this class include:Career choicesEthical dilemmasJudicial proceedingsMitigation strategiesCreating tools to help make better decisionsAtonement and reconciliation