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.)
Complete Guide to Analyze Data with Excel PivotTables
-
Webinar
4.00 Credits
Member Price: $149
The major topics that will be covered in this course include:Introduction to PivotTables: Gain a solid understanding of what PivotTables are, their benefits in Excel, and how to prepare your data for creating effective PivotTables.Creating and Customizing PivotTables: Learn step-by-step how to build and format PivotTables, including filtering, sorting, and customizing layouts for optimal data analysis. Focus on Using PivotTables to Analyze Data: Explore techniques to summarize, group, and compare data with PivotTables, uncovering trends and insights for better decision-making.Advanced PivotTable Features: Discover advanced tools such as slicers, timelines, and using PowerPivot for deeper analytical capabilities. Data Visualization with PivotCharts: Learn to create PivotCharts from your PivotTables and customize them to visually present data insights effectively to stakeholders.
Agentic AI for CPAs: Automate Workflows with Intelligence
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Introduction to Agentic AI concepts and terminologyCase studies for using AI agents in accounting, finance, and tax servicesStep by step demonstration of creating and deploying an AI agentIntroduction to Microsoft Copilot Studio agent builderDeveloping your AI agent deployment strategy
Surgent's Choosing the Right Business Entity
-
Webinar
2.00 Credits
Member Price: $99
Why businesses operate as C corporations Why businesses operate as pass-through entities Adopting C corporation status Why businesses choose S corporation status. Tax and business situations that impact entity selection.
Surgent's Time Management for Professionals
-
Webinar
2.00 Credits
Member Price: $99
Managing interruptions The role of activity logs, to-do lists and a priority matrix The psychology of time management Staying on track of your time management plan Controlling procrastination Blocking out time Creating an effective time management plan
Surgent's Unique Tax Attributes of Different Entity Types
-
Webinar
2.00 Credits
Member Price: $99
Considerations for a small business owner Self-employment taxes Guaranteed payments to partners QBI deductions: Section 199A Built-in gains tax: S corporations Excess passive income tax: S corporations PTE elections: S corporations and partnerships Taxation of fringe benefits: S corporations Double taxation of C corporation dividends Taxation of limited liability companies Which entity to choose?
More Money: Strategic Ways to Improve Cash Flow
-
Webinar
4.00 Credits
Member Price: $149
The major topics that will be covered in this class include:How do I optimize cash flow?Qualitative Evaluations – Core Earnings & Sustainable GrowthQuantitative Evaluations – Liquidity RatiosIncreasing Customer Base vs. Payment TermsBusiness Cycle & CashInvesting Company CashWhat keeps companies from becoming streamlined?Behavioral Finance BiasesInformation Processing BiasesEmotional BiasesDealing with Behavioral Biases
Finance and Innovation: Reinvent Your Organization and Dept.
-
Webinar
8.00 Credits
Member Price: $239
The major topics that will be covered in this course include:What is innovation?The different forms of innovation, e.g., sustaining and disruptive.The five discovery skills needed to be innovative?The value of why we need to find ways to say, “Yes!” How to change your processes, rules and departments to be more innovative? Lessons learned from innovative businesses with examples.How does innovation happen and how to make innovation stick?The need to improvise and embrace broad experiences.
Surgent's Audit Skills Training Level 2: Preparing for Increasing Responsibilities in Public Accounting
-
Webinar
8.00 Credits
Member Price: $279
Each module includes a lecture followed by in-class group case studies and activities. In this two-day course, the following two-hour modules will be presented: Day 1: Auditing accounts receivable Physical inventory observations Sampling fundamentals Assessing fraud risk in a financial statement audit Day 2: Auditing common investments Financial statement fundamentals SSARS refresher and attestation engagement overview Analytical procedures fundamentals
Surgent's Forms 1120-S and 1065 Return Review Boot Camp for New and Experienced Reviewers
-
Webinar
8.00 Credits
Member Price: $279
Reviews of portions of error-prone “staff-prepared” Forms 1120-S and 1065 from client-provided information What are common errors preparers make and what are the areas generating malpractice claims? Initial administrative groundwork The importance of Schedule M-1. Learn how various schedules are related and learn how to self-review Reporting requirements and filing exceptions for Schedules K-2 and K-3 Don’t fall prey to reporting oddities When can seemingly separately stated Schedule K items actually be trade or business items to report on Forms 1120-S or 1065? Form 1120-S – What exactly is terminating S elections today? How do I recognize a second class of stock? Maintaining shareholder basis schedules; beware of final IRS regulations regarding “open debt”; the default method of calculating basis versus the election under §1367; can an S corporation distribute earnings and profits from C corporation years? Form 1065 – New tax reporting requirement for partners’ capital balances Why use §704(b) to maintain capital accounts; §704(c) regulations for preventing the shifting of tax consequences among partners or members; allocating recourse, nonrecourse, and qualified nonrecourse debt; a review of §754 step-up in basis rules Multiple checklists of efficient procedures to identify potential issues on an 1120-S or 1065 tax return
Surgent's Tax Forms Boot Camp: LLCs, Partnerships, and S Corporations
-
Webinar
8.00 Credits
Member Price: $279
Compare and contrast the tax consequences, opportunities, and pitfalls of operating a business as a partnership, LLC, or S corporation Reporting Requirements 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”
The 10 Must Know Excel Features
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this class include:Excel Tables: Master the use of Excel tables for efficient data management, including sorting, filtering, and structured references, to manage data more effectively.Custom Sorting: Get to grips with custom sorting options to organize data in a way that best suits your needs, enhancing data readability and analysis.XLOOKUP: Discover the power of XLOOKUP for advanced data retrieval, a game-changer for complex analysis, allowing you to extract specific data from extensive datasets with ease.SUBTOTAL: Gain proficiency in using the SUBTOTAL function, a versatile tool for calculating data in visible cells, ideal for analyses that require dynamic calculations.SUMIF(S): Explore the functionality of SUMIF and SUMIFS functions for conditional summing, crucial for precise budgeting, expense tracking, and financial reporting.Array Formulas: Dive into array formulas to perform multiple calculations on one or more items in an array, enhancing the efficiency of complex accounting computations.Data Validations: Learn to implement data validations to ensure data integrity and prevent errors in financial data entry, a critical skill for maintaining accurate accounting records.Slicers: Learn to use slicers for interactive data segmentation in tables and PivotTables, enabling accountants to quickly filter and analyze specific subsets of financial data.Conditional Formatting: Understand how to apply conditional formatting to highlight critical financial data points, trends, and variances, making data analysis and interpretation more intuitive.PivotTables: An introduction to PivotTables, one of the most powerful Excel features, for summarizing, analyzing, and presenting large sets of financial data in a digestible format.
Accounting for the Gig Economy
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Characteristics unique to the gig economyIndependent contractor and employee classification considerationsRecordkeeping considerations for independent contractorsAccounting and reporting issues for gig economy participantsAudit and attestation for clients who participate in the gig economyTax and regulatory considerationsThe CPA as a trusted advisor for independent contractors
Current Audit Environment and ASB Activity
-
Webinar
2.50 Credits
Member Price: $99
Current environment and implication for audit planning Key risk issues Audit challenges Recent Statements on Auditing Standards (SASs). ASB workplan SQMS No. 1, No. 2, and No. 3 SSARS No. 26
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
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
The Ethics of Care in the Workplace
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this class include:Ethical Values and PrinciplesCompassionManaging ExpectationsRespect and HumilityAttribution Theory
What If Your Client Didn't Take Reasonable Compensation
-
Webinar
1.00 Credits
Member Price: $55
The major topics that will be covered in this course include:Review best practices to help your client evaluate if an S election is an appropriate choiceHow to be proactive and head off common reasonable compensation issues before they happenExplore strategies for cash management if cash isn't available at year endExplore what’s at stake when reasonable compensation isn’t paid timely
Accountants and Malpractice: Can We Get Sued for This?
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this class include:How accountant liability is a very real threat in today's litigious society.A discussion of scenarios in which accounting professionals can find themselves inadvertently involved in a lawsuit.Pitfalls in which the accountant may find him- or her- self while dealing with clients.Real-life examples from the speaker's extensive experience as a practitioner and as an expert witness in accounting malpractice cases.
Surgent's Where To Live in Retirement
-
Webinar
2.00 Credits
Member Price: $119
Does continuing to live at the current location meet retirement goals and lifestyle? Are there family concerns such as an elderly parent that prevent moving away from the current location? Is the current location affordable when income from a salary ceases? What health concerns are there that would limit the ability to move to another location? Is an assisted living facility something that should be considered now or in the future and is a suitable one available? What happens if a person is disabled while retired? Are there state and local tax considerations that would encourage staying in place or moving? Are there climate and weather concerns that would encourage a person to stay in place or move to a more desirable location? Should a retiree downsize?
Tax Depreciation: Review and Update
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this class include:Recent tax legislation and developments related to capitalizationEligible property for Section 179 and Section 168(k)Discussion of the Section 179 deduction and its use to depreciate real propertyThe Section 168(k) deduction and its use to depreciate real propertyDisposition of segments of real propertyExchanges of tangible personal property after repeal of the like-kind exchange rulesOther related topics