CPE Catalog & Events
Mastering the Excel Lookup Functions
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:A review of the various lookup functions, beyond VLOOKUPLearn which lookup works best for your situationHow to apply the many lookup functionsDiscover advanced lookup techniques like nested lookups, approximate matching, and handling errors effectivelyAn in-depth review of the following functions:VLOOKUP / HLOOKUPXLOOKUPMATCH / INDEXXMATCHINDIRECTFILTERSORT / SORTBYUNIQUEAn overview of some newer functions
ChatGPT Vision: How Accountants can Chat with Imagery
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Introduction to GPT Vision - Understanding the fundamentals of GPT Vision and its capabilities.Advantages of Vision Mode Research - Exploring the unique benefits of visual data analysis over traditional methods.Accessing GPT Vision - Guidance on how to access and utilize GPT Vision capabilities.Financial Screenshot Analysis - Techniques for analyzing financial documents and reports through screenshots.Operational Insights from Visual Data - Using images to gain insights into operational processes and asset management.Integration with Google Maps - Learning how to combine ChatGPT's vision capabilities with mapping technologies for enhanced spatial analysis.Sentiment and Facial Expression Analysis - Techniques for interpreting emotions and sentiments in images to gauge client and employee feedback.Body Language Interpretation - Analyzing body language in images to understand non-verbal cues in business contexts.Effective Photo Capturing Techniques - Best practices for taking photos that provide optimal insights for financial analysis.
Surgent's Critical Issues Involving Taxation of Construction Contractors
-
Virtual
4.00 Credits
The impact of recent legislation on the construction industry How to qualify for the “small contractor exemption” and its advantages to the taxpayer Options available to the “small” contractor regarding taxation of long-term contracts How the choice of entity impacts taxation of contractors How AMT impacts the construction industry IRC §460 and “large” contractors How “uninstalled materials” impact taxation of contractors How the “look-back” rules impact contractors How the “10 percent method” can allow certain contractors to defer recognizing taxable income Critical tax planning strategies for contractors
Surgent's Government and Nonprofit Frauds and Controls to Stop Them
-
Virtual
4.00 Credits
Examine real-world misappropriations of cash, check frauds, vendor scams, credit card abuse, grant frauds, benefit schemes, inventory thefts, and payroll frauds Consider and develop controls to stop fraud Tailor controls to the size and fit of the government or nonprofit
Deep Dive Into Common Auditing Deficiencies
-
Virtual
4.00 Credits
The major topics that will be covered in this course include:Review common deficiencies identified by the AICPA and state boards of accountancy.Feature discussion on a variety of topics, including analytical procedures, sampling, group audits and risk assessment.Review of the areas of concern and how you can overcome them by employing best practices.
Building Security and Efficiency With Internal Control
-
Virtual
8.00 Credits
The major topics covered in this course include:An overview of control frameworks and conceptsStrategic considerations that can be incorporated into control developmentUnderstanding and controlling risk that arises when organizations change or choose not toThe COSO Internal Control Framework and the COSO ERM Framework
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
Surgent's Individual and Financial-Planning Tax Camp
-
Virtual
8.00 Credits
Comprehensive coverage of the SECURE Act 2.0 Understanding the environment: what’s new, what’s expired or expiring, and what’s likely to change Reading a tax return for developing client-specific tax strategies Changes to the lifetime estate tax exemption in light of proposed regulations The net investment income tax: planning for compliance Family income-splitting strategies that need to be considered Income tax issues: impact on timing of other income Selling a principal residence Two principal residences at the same time Use of life insurance to protect families: Whole Life Insurance, Term Life Insurance, Universal Life Insurance, and Variable Life Insurance Using Roth IRAs and Roth contribution programs to best advantage Conversions: do they still make sense? Taking distributions: matching timing to client requirements Qualified plan contributions to reduce current income and Social Security tax: implications for business owners and self-employed Social Security solvency issues Incentive Stock Options and Employee Stock Purchase Plan considerations What to do about itemized deductions Trans-generational planning: conversions, income, and gain-splitting Tax benefits of HSAs and other tax-advantaged accounts Identifying tax opportunities: reviewing the prior-year return to develop a plan for the future Planning for middle-income taxpayers: financial planning for the young, the working, and those approaching or in retirement Best financial planning ideas for young people
Surgent's Preparing C Corporation Tax Returns for New Staff and Paraprofessionals
-
Virtual
8.00 Credits
Preparation of a reasonably complicated Form 1120, “U.S. Corporate Income Tax Return,” from trial balance to completed return The importance of Schedule M-1, including adjustments in reconciling book income to tax income and items staff may look for on all business returns New tax-planning strategies for depreciation deductions, including changes to §179 and first-year depreciation under §168(k) as a result of new tax legislation Methods of accounting In-depth analysis of Form 4797 dealing with depreciation recapture Deductible expenses, including rules on meals and entertainment Section 163(j) Computation of tax liability Overview of common business deductions – deductibility and Schedule M-1 How to practically handle uniform capitalization and inventory accounting for a small manufacturing concern And more!
Surgent's Tax Forms Boot Camp: LLCs, Partnerships, and S Corporations
-
Virtual
8.00 Credits
Compare and contrast the tax consequences, opportunities, and pitfalls of operating a business as a partnership, LLC, or S corporation Reporting requirements and filing exceptions for Schedules K-2 and K-3 Form 7203, S Corporation Shareholder Stock and Debt Basis Limitations Gain a comprehensive understanding of income tax laws for S corporations from eligibility and election to tax return preparation, stock basis, and loss limitation issues Recognize and properly handle special pass-through items of income and expense Accurately prepare S corporation returns and reconcile book income to taxable income Accurately prepare partnership returns and reconcile book income to taxable income What the transactional method entails and how to report partners’ capital accounts under this method Properly handle the tax treatment of distributions to shareholders, partners, or members Understand the special restrictions and sanctions for tax year-end selection Review the basics of partnership and LLC formation and basis calculation Self-employment tax or NOT, for each entity Filling in K-1s correctly for S corporations, partnerships, and LLCs. Major changes in K-1 reporting on both partnership and S corporation forms and content The most frequently used forms and schedules, including some form “oddities”
Tax Fundamentals of LLCs and Partnerships - Tax Staff Essentials
-
Virtual
8.00 Credits
Basic tax structure of partnerships and LLCs Check-the-box elections to be taxed as a partnership Partnership distributions Compensatory payments to partners At-risk and passive activity limits Profit and loss allocations: general rules and restrictions
VSCPA Tax Series Webinar
-
Virtual
2.00 Credits
TBD
CPA to CFO
-
Virtual
1.00 Credits
The major topics that will be covered in this course include:The steps necessary to effectively transform a tax or accounting practice into an advisory service.What it means to be a CFO/advisor to small-to-medium sizes businesses.What qualifications are necessary to offer an advisory service.How to find and convert leads and how to price and package services, including combining advisory services with the firm’s current offerings.
The Ethic of Recruitment and Selection
-
Virtual
2.00 Credits
The major topics covered in this course include:Discussion of ethical and effective recruiting strategiesSelection processes that foster diversity and inclusionHow to increase talent pools to ensure hiring success
Partnership/LLC Taxation: Tax Basis Capital Accounts
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Discuss the impact of the Section 199A flow-through entities deduction on partnerships and their partnersThe meaning of a "tax basis capital account"How the financial accounting and tax capital accounts differ from one anotherDetermine a partner's share of the partnership's liabilitiesDistinguish "recourse" loans from "nonrecourse" loansWhat are "qualified nonrecourse financing" loans and how they affect partnersSection 704 "built-in gain or loss" rules and how they impact Schedule K-1 reportingSection 4655 "at risk" rules and how they impact Schedule K-1 reporting
Surgent's Purchase and Sale of a Residence: Critical Tax Issues
-
Virtual
2.00 Credits
General rules relating to the sale of a residence under § 121 Sale of a taxpayer’s main home Qualifying for a partial exclusion of gain on the sale of a home How a taxpayer meets the residence requirement Meeting the look-back requirement Separated, divorced, and widowed taxpayers Work-related moves and unforeseeable events Inherited homes and homes received in a divorce Impact of business or rental use of home on the gain exclusion Reporting gain or loss on the sale of a home
Capitalized Costs & Depreciation - Tax Staff Essentials
-
Virtual
5.50 Credits
Tax basis of property acquisitions Initial basis of property acquired in an exchange transaction Materials, supplies, repairs and improvements Accounting method changes Depreciation: MACRS, Section 179 and bonus Intangible assets and amortization Organization and start-up costs Research and experimental expenditures
Take Command of your Time
-
Virtual
2.00 Credits
The major subjects that will be covered in this course include:Identify time wasters and adopt strategies for eliminating themRecognize the variety of causes of procrastination and apply techniques to overcome themUse practical techniques for prioritizing workDelegation strategiesIncorporate wellness and stress management into your day in short incrementsUnderstand their energy cycles and use it to manage your scheduleLearn techniques to decrease stress in the moment (based on neuroscience)
Selected Ethics Topics - 2024 - 2025
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Stay in compliance with recent ethics standards changes that impact your practice.Learn about key regulatory changes and initiatives impacting CPAs and the future of the profession.Discuss emerging issues and standard-setting activity that could affect your practice in the future. Explore practical applications of the standards and hear about common practice issues and challenges. Examples include private equity, technology, tax planning, audit quality, regulatory enforcement and standard-setting environment.Learn how failure to follow the standards can result in unwanted regulatory actions and publicity.
Tax Season Update for Business with Steve Dilley
-
Virtual
4.00 Credits
The major topics covered in this class include:2021/22 legislative developments, cases and rulings impacting various business entity taxpayersDetailed discussion of the partnership and S corporation Schedule K-1 changesBusiness income, deductions and creditsTravel expense reportingSection 199A update and business lossesDepreciation update: Section 179 and 168(k)S Corporation and partnership update
