CPE Catalog & Events
Finding Errors in Excel Spreadsheets
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Understanding Common Excel Errors: Gain insights into the most common types of errors encountered in Excel, including formula errors, reference errors, and logic errors.Advanced Formulas and Functions: Learn to use advanced Excel functions and formulas that are crucial for error detection and data analysis.Data Validation Techniques: Master the art of data validation to prevent errors before they occur. This includes setting up data validation rules and using conditional formatting to highlight potential inaccuracies.Error Tracing and Auditing Tools: Delve into Excel's auditing tools to trace and fix errors. Learn to use Trace Precedents, Trace Dependents, and the Error Checking tool effectively.
Preparing to be a Forensic Accountant - Cloud Forensics
-
Online
1.40 Credits
Forensic Accounting Accounting Auditing Finance
The Role of Internal Audit in Operational Audits
-
Online
2.00 Credits
The important role of operational audits Best practices for designing and performing operational audits Identifying causes of operational issues and risk exposures Developing solutions to enhance the operational performance of business activities, processes, and resourced deployed across the organization Delivering clear, transparent, and objective audit reports to convey critical information
Retaining Top Talent: Strategies for CPA Firms
-
Virtual
1.00 Credits
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: The true cost of turnover versus retention investment Research findings on why professionals leave or stay Whole-person retention strategies beyond compensation Work-life balance solutions that maintain productivity Career development paths for non-partner track professionals Business model transformations for sustainable staffing Technology and outsourcing strategies to reduce burnout Retention strategies specific to diverse talent and younger professionals
Written Information Security Plans
-
Online
1.00 Credits
Introduction to the Gramm-Leach-Bliley Act and its impact on data security Circular 230 compliance and due diligence for practitioners AICPA Statements of Standards relevant to WISP requirements Key components of a Written Information Security Plan Training requirements for employees, staff, and contractors Practical guidance for drafting and implementing a WISP FTC enforcement of data security standards for PTIN holders Best practices for maintaining and updating WISP compliance
Bytes, Bias, and Balance: Data Ethics for Savvy Accountants
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:The transformative role of artificial intelligence (AI) in accounting and auditingEnhancing efficiency and innovation with AI toolsMitigating challenges such as overreliance, data security vulnerabilities, and ethical dilemmas
Surgent's Current Issues in Accounting and Auditing: An Annual Update
-
Virtual
4.00 Credits
Recently issued but newly implemented Accounting Standards Updates (ASUs), the PCC Update, and items on the FASB’s Technical Agenda New ASUs covering disaggregated expenses, crypto assets (e.g., cryptocurrency), and business combinations Results and findings of the FASB’s Final (Stage 3) Post-Implementation Review (PIR) Report on Topic 606 Recently issued SASs and other AICPA activity through SAS No. 149 Detailed review of the three new Statement on Quality Management Standards (SQMS 1, SQMS 2, and SQMS 3) Other important A&A practice matters
Surgent's Introduction to Forensic Accounting
-
Virtual
4.00 Credits
Review of the different aspects of forensic accounting The civil litigation process as it relates to forensic accounting Litigation services provided by forensic accountants Fraud detection and prevention Various types of fraud Training and certifications in forensic accounting Forensic accounting in bankruptcy proceedings Forensic accounting in family law proceedings Calculating damages for use in litigation Valuations Ethical issues pertinent to forensic accounting
Intermediate Individual Taxation - Tax Staff Essentials
-
Virtual
8.00 Credits
Gains and losses on property transactions Fringe benefits Retirement plan distributions Hobby losses Home offices Depreciation and amortization Qualified business income under Section 199A Passive activities Business transactions
Surgent's Employer's Handbook: Legal, Tax, and Health Care Issues
-
Virtual
8.00 Credits
Hiring and firing issues – What questions cannot be asked in an interview; how to document employee performance; establishing an annual review system; when an employer may and may not fire an employee, and much more Employment contracts – An analysis of the legal and planning issues in structuring employment contracts; when noncompetition agreements will and will not work Employment issues in the economy – Telecommuters and other special situations Legal liability issues – Recognition of age discrimination, sex discrimination, FLSA issues, minimum wage, overtime, sexual harassment, and more Fringe benefit issues – COBRA, Family and Medical Leave Act, and new developments in health care Medical plans – Who is a full-time employee?
Mergers and Acquisitions: Complete Guide to Relevant Issues
-
Online
2.00 Credits
Taxable asset acquisitions vs. non-taxable stock/equity acquisitions What happens in an asset acquisition What happens in a stock or equity acquisition 338 and 336 elections Basics of 382 Basics of 280G Earnouts and contingent payments Assumed liabilities Acquired reserves Acquired deferred revenue Treatment of transaction costs Basics of mixed entity transactions, examples such as: C-Corp buys an interest in a partnership C-Corp buys an S-Corp C-Corp buys an interest in an LLC (lots of possibilities here) S-Corp buys a partnership S-Corp buys a C-Corp S-Corp buys an interest in an LLC Partnership acquisitions of various entity types Very basic overview of tax-free re-organizations High level overview of entity formations High level overview of entity liquidations or termination
Surgent's Stock vs. Asset Acquisitions of C Corporations
-
Virtual
2.00 Credits
Advantages and disadvantages to buyer and seller of an asset acquisition and a stock acquisition Tax treatment of consulting agreements and covenants not to compete Sale of personal goodwill associated with an asset acquisition Tax consequences associated with a stock acquisition and an asset acquisition Acquisitive reorganizations Non-tax issues that must be considered when a corporation is acquired
How SAS Nos. 134-145 Improve Risk-Based Audits
-
Virtual
4.00 Credits
The major topics that will be covered in this class include:Key changes to audit report elements intended to improve the understandability of the nature and results of financial statement auditsEnhanced required by-product communications with management and those charged with governance to promote more reliable financial statementsClarifications related to obtaining sufficient and appropriate audit evidence, including significant unusual transactions, related parties, going concern uncertainty, and accounting estimatesNew definitions and requirements related to identifying and evaluating risks of material misstatementOther important matters contained in SAS Nos. 134-145
The Original Secure Act and Secure Act 2.0 Retirement Planning Strategies
-
Online
4.00 Credits
Mandatory Automatic Enrollment Credit For Small Employer Pension Plan Startup Costs Enhancement Of The Saver’s Credit Increase In Starting Age For RMDs Indexing IRA Catch-Up Higher Catch-Up Limit Age 61, 62, 63, And 64 Student Loan Payments As Elective Deferrals For Matching Contributions Start Up Credit Costs For Employers Joining An Existing Plan Financial Incentives For Contributing To a Plan Withdrawals For Certain Emergency Expenses SIMPLE Plan changes Starter 401(K) Plans Sec 529 Plan To Roth Rollovers Emergency Savings Accounts Enhancement of 403(B) Plans Qualified Charitable Distributions to Split Interest Entity Retirement Savings Lost and Found
Securing Your Data with a Password Management App - Updated
-
Virtual
2.00 Credits
The major topics covered in this course include:Introduction to the world of password management apps and what makes them so secureReview and demonstration of top selling password management appsSoftware features that will be reviewedPassword generationEmergency user accessEntity vs. individual password managementDesktop vs. cloud basedMulti device synchronizationPII (personally identifiable information) forms fillerCredit card storageDigital data vault
Accounting for Digital Assets Under U.S. GAAP: Crypto lending and borrowing
-
Virtual
1.00 Credits
What is crypto lending? The meaning of commonly used crypto lending terms How the nature of the crypto asset and the terms of the lending arrangement affect accounting arrangements Which disclosures are applicable based on the facts and circumstances FASB ASU No. 2023-08, *Intangibles—Goodwill and Other—Crypto Assets (Subtopic 350-60): Accounting for and Disclosure of Crypto Assets*
Self-Rental Real Estate: Passive Activity & Section 199A
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Definition of self-rental property - both for Sections 199A and 469Self-rental income from directly owned properties and reporting on Form 1040, Schedule E, page 1Self-rental income from indirectly owned (partnerships, S corporations) and reporting on Form 1040, Schedule E, page 2Form 8582 (passive activity)The flow-through entity grouping electionIllustrative examples and consequences of failing to comply with the reporting standardsSelf-rental property and "former passive activities" rules
Accounting & Attestation for ESG
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Current ESG-related initiatives and projects underway at the Financial Accounting Standards Board, Governmental Accounting Standards Board, and the AICPA. Types of services CPAs may provide in connection with ESG reporting, including advisory and attestation engagements.
Ethical Leadership: Power, Influence, Integrity, and Trust
-
Online
2.00 Credits
The difference between personal power and positional power How proper use of power can be used to influence an ethical culture Leadership requires trust Knowing why trust cannot exist without credibility Understanding why ethics and trust require one another Appreciating the competitive benefits of commitment to ethical leadership
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.
