CPE Catalog & Events
Society Events are In-Person or Via NVCPA Hosted Zoom - All times listed in PST (cancellation policies apply, contact NVCPA for details.)
Smart Formula Selection in Excel: What to Use When
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this class include:Introduction to Strategic Formula Use:Why choosing the right formula matters: clarity, performance, and maintenanceCommon traps: overusing IF, defaulting to familiar tools, ignoring modern functionsHow Excel offers multiple ways to solve the same problem and how to pick wiselyConditional Logic and Branching Tools:IFS vs SWITCH vs nested IF: comparing readability and structureWhen to simplify logic and how to avoid nested nightmaresSummarizing Data:SUMIFS vs SUMPRODUCT: multiple conditions, weighted sums, totalsFiltering and Output Control:FILTER vs IF + INDEX: dynamic data extraction with vs without Excel 365Trade-offs in backward compatibility and ease of useCustom Output and Decision Trees:CHOOSE vs SWITCH vs LOOKUP: logic trees and category mappingEmbedded Variables and Reusability:LET vs named ranges: clarity and efficiency for long formulasUsing LAMBDA with LET to create custom functionsSimplifying and documenting complex calculationsBest Practices for Formula Selection:Criteria for deciding: readability, flexibility, future maintenanceTips for avoiding overengineering and formula bloat
2026/27 AICPA Regulatory Ethics Update
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Update on ethics and independence developments from the AICPA Professional Ethics Executive Committee (PEEC)Recent developments shaping ethical requirements for the professionProposed and ongoing projects on PEEC's agenda
Partnership/LLC Taxation: Tax Basis Capital Accounts
-
Webinar
2.00 Credits
Member Price: $89
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
Executive Presence, Personal Brand: Structure Your Narrative
-
Webinar
1.00 Credits
Member Price: $55
The major topics that will be covered in this course include:Components of executive presenceAudience-centered elevator pitch structureProfessional value proposition frameworkStructuring a concise executive biographyAligning personal narrative with organizational valueCommon pitfalls in professional self-presentationApplication and refinement exercise
Calculating the Retirement Need
-
Webinar
1.00 Credits
Member Price: $55
The major topics that will be covered in this course include:Overview of retirement expenses and needsOverview of risk tolerance, time value of money and retirement planning factorsExamples of client retirement situations
Analyzing Financial Statements
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this class include:Balance sheet analysisIncome statement analysisCash flow statement analysisClues in the notes and MD&AIndustry nuances
ChatGPT and Advanced Financial Analysis for Accountants
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Financial Modeling with ChatGPT IntegrationAdvanced Ratio Analysis TechniquesRisk Assessment and Scenario AnalysisValuation Methods and ChatGPT ApplicationsUtilizing Performance Metrics in Financial AnalysisData Analysis and Interpretation with AIInvestment Analysis Enhanced by ChatGPT
Integrate ChatGPT into Your Client Advisory Services-Updated
-
Webinar
2.00 Credits
Member Price: $89
The major topics covered in this course include:ChatGPT and generative AI technology primerBuilding your generative AI vocabularyDig deeper into your engagement research to develop a higher quality advisory servicePolish your client reporting with the help of ChatGPTDeveloping your ChatGPT client advisory servicesStart with client education. You don’t need to be a technical expert to be an educatorUse AI to help your clients automate their workflows / business processesBuild better spreadsheets with ChatGPT and ExcelHelp your clients identify, evaluate and select applications for their business
CFO Solutions to IRS Problems
-
Webinar
4.00 Credits
Member Price: $149
The major topics that will be covered in this course include:The authority of IRS in assessing and collecting taxes.The common misconceptions when dealing with IRS.Common questionable actions by business owners.How to prepare for an IRS audit.The seven options in IRS collections.Possible criminal tax violations by CFOs and small business owners.
Surgent's A Complete Guide to the Yellow Book
-
Webinar
8.00 Credits
Member Price: $279
Circumstances requiring auditors to follow the Yellow Book (Government Auditing Standards or GAGAS) Relationship of Yellow Book requirements to GAAS and single audit requirements Auditor qualifications under the Yellow Book: independence, CPE, peer review, and related requirements The Yellow Book requirements related to the performance of and reporting on a financial audit Identifying and reporting findings under the Yellow Book The Yellow Book requirements related to attestation engagements (examinations, reviews, and agreed-upon procedures) and performance audits
Surgent's Form 1040 Return Review Boot Camp for New and Experienced Reviewers
-
Webinar
8.00 Credits
Member Price: $279
Key provisions of the recent HR 1, One Big Beautiful Bill Act, have been incorpoated throughout the course Review an error-prone "staff-prepared" Form 1040 from client-provided information. Where do you start? Get to know your client and ask the questions Several new reporting issues for the reviewer to consider, including the main credit provisions as enacted under the American Rescue Plan What are common errors preparers make and what are the areas generating malpractice claims? The importance of engagement letters, questionnaires, and §7216 permission statement Initial administrative groundwork Identifying organizing issues in the tax return to be reviewed Avoiding “willful blindness.” Handling ethical and moral dilemmas Efficient review of certain advanced issues for income, adjustments, deductions, and credits Effective procedures for delinquent clients, filing past-due tax returns First-time client issues requiring extra scrutiny Multiple checklists of efficient procedures to identify potential issues on a 1040 return Listing of schedules for staff to prepare to make a review easier, including basis issues for 1040 clients Reconciling time pressure with thoroughness and quality control Professionals acting professionally
The Best Federal Tax Update Course by Surgent
-
Webinar
8.00 Credits
Member Price: $299
Comprehensive coverage of the One Big Beautiful Bill Act Review of key components of President Trump's tax bill, including a tip income exemption, overtime pay relief, Social Security tax exemption, auto loan interest deductibility, SALT deduction modifications, a lower corporate tax rate, restoration of 100% bonus depreciation, immediate R&D expensing, and permanent extension of select TCJA provisions Tariff policy and implementation - analyze the use of tariffs as a fiscal and trade policy tool Digital assets and tax implications - understand the new Form 1099-DA for reporting digital asset transactions, along with updated IRS guidance on cryptocurrencies, NFTs, and broker responsibilities Artificial intelligence - discover how AI and generative tools are transforming tax practices, as well as how the IRS is leveraging AI to enhance audit selection Form 1099-K reporting requirements - understand the evolving IRS thresholds and rules for third-party payment platforms Sale of Passthrough Entity Interests and Net Investment Income Tax - analyze the tax implications of selling interests in passthrough entities, including relevant examples, and how the Net Investment Income Tax (NIIT) applies to these transactions The Gig Economy - examine key tax implications for gig workers, including Independent Contractor vs. Employee classification challenges, reporting responsibilities, and the impact of the 2024 Department of Labor Final Rule on worker status Timely coverage of breaking tax legislation Practice aids, including all the numbers applicable for the current year -- inflation-adjusted amounts, mileage rates, retirement contributions, and more Advanced practice, reporting, and other issues intertwined with advanced planning and discussion ideas
Untying the Knot: Taxes & Divorce
-
Webinar
8.00 Credits
Member Price: $239
The major topics that will be covered in this course include:Filing Status: Determining the correct filing status during and after divorce.Qualified Domestic Relations Orders (QDROs): Tax implications of dividing retirement accounts.Back Taxes: Strategies for addressing unpaid tax liabilities during and after divorce.Offers-in-Compromise & Installment Agreements: Resolving tax debts with the IRS.Currently-Not-Collectible Status: Understanding when and how to use this option.Innocent Spouse & Injured Spouse Relief: Protecting clients from unfair tax liabilities.Lien Discharges & Subordinations: Managing IRS liens on property during divorce.Reasonable Compensation: Evaluating fair compensation in divorce-related business valuations.Case Studies: Explore unusual and complex tax issues in divorce through real-world examples.
How AI Fits into the Accounting World
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:An overview of AI constructs.How artificial intelligence is being used by accountants today.Accounting-centric AI developments on the horizon.
Schedule K-1: What is it & What do I do with it?
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Overview of Schedule K-1 for Partnerships, S Corporations, and Estates/TrustsReporting Schedule K-1 information on Form 1040Basis limitations, loss limitations, and material participation rulesQualified Business Income (QBI) Deduction and Schedule K-1 integrationSchedules K-2 and K-3 requirements
Surgent's Guide to Partner Capital Account Reporting
-
Webinar
2.00 Credits
Member Price: $99
How a partner’s outside basis and capital account differ Reconciling Schedule M-2 Form 1065 with Partnership K-1 Schedule L IRS requirement to report partner tax basis on the transactional approach Implications if a capital account is negative Deficit restoration accounts and qualified income offsets Modified outside basis method and modified previously taxed capital method Determining a partner’s beginning capital account Beginning capital account for partnerships and partners consistently reporting on the tax basis The two types of adjustments under 754 and how 743 and 734 require different capital account presentations
Surgent's Understanding S Corporation Taxation: Compensation Issues and Entity-Level Taxes
-
Webinar
2.00 Credits
Member Price: $99
Reasonable compensation Fringe benefits for S corporation shareholders Built-in gains tax Excess passive income tax Notice 2020-75: PTE elections
All About Fraud - Examples, Prevention and Auditing
-
Webinar
4.00 Credits
Member Price: $149
The major topics that will be covered in this course include:2026 Report to the Nations issued by the Association of Certified Fraud Examiner.Practical approaches organizations use to prevent and deter fraud, highlighting controls, policies, and cultural factors that can reduce fraud risk.Recent fraud cases reported in the news to reinforce how these schemes manifest in real-world settings.Discussion of the auditor's responsibilities related to fraud under AU-C 240, including an overview of proposed changes to the fraud standards and what they may mean for future audit engagements.
Construction Contractors: Auditing Considerations
-
Webinar
4.00 Credits
Member Price: $139
Auditing contractor accounting and revenue from contracts with customers Planning and risk assessment for construction contractors Key controls Substantive procedures for long-term contractors
An Exhaustive Look At Fraud and Ways To Control It
-
Webinar
8.00 Credits
Member Price: $239
The major topics covered in this course include:Fraudulent acts initiated from outside organizationsWhy internal fraud occursThe importance of fighting cyber-fraudSteps that verify anti-fraud activities are working