CPE Catalog & Events
Mastering the Excel Lookup Functions
-
Webinar
2.00 Credits
Member Price: $89
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
Not Just Your Everyday FASB Update
-
Webinar
4.00 Credits
Member Price: $129
Analysis of relevant GAAP provisions Reminders regarding the continuing importance of ASC 606 for revenue recognition Fresh perspectives of lease accounting in the wake of ASC 842 implementation Overview of U.S. GAAP alternatives for certain entities Summary of selected, salient standards for today’s audit, review, and compilation engagements
Revenue Recognition Determine the Transaction Price Part 2
-
Webinar
1.00 Credits
Member Price: $39
Revenue Recognition Accounting
The Controllership Series: The Controllers Role in Internal Controls
-
Webinar
1.50 Credits
Member Price: $59
Accounting Finance Internal Controls
What's Going on at the AICPA (2025)
-
Webinar
1.50 Credits
Member Price: $99
EBP Audits Auditing AICPA
K2's Next Level Home Networking
-
Webinar
1.00 Credits
Member Price: $39
Explanation of common network services such as file sharing, VPN's, media servers, and network isolation using multiple SSIDs Hardware options and examples of solutions for every budget Tips and tricks for rebuilding your home network to meet your needs today and into the future
Resistance to Resiliency: Striving for Technology Change Acceptance
-
Webinar
1.00 Credits
Member Price: $39
Yellowbook Accounting and Auditing Strategic Alignment Model
The Controllership Series - The Controllers Role in Financial Forecasting
-
Webinar
1.50 Credits
Member Price: $59
Accounting Finance
Cash Management: Strategies for Long-Term Success
-
Webinar
2.00 Credits
Member Price: $79
Developing short-term cash flow projections How do we assure adequate cash availability without having idle cash? Take advantage of your bank’s cash management services Working capital loans Controlled disbursement accounts Sweep accounts and other short-term investments ACH transactions Direct transfers Lock boxes Credit and collections Reconciliation frequency Managing cash short-falls
ChatGPT Vision: How Accountants can Chat with Imagery
-
Webinar
2.00 Credits
Member Price: $89
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.
The AB5s of Employees and Independent Contractors
-
Webinar
2.00 Credits
Member Price: $79
Four ways to classify a worker IRS 20 Factors 20% Section 199A deduction Cost of misclassifying an employee Section 530 relief Game changing impact of the Dynamex case and AB5
Surgent's Critical Issues Involving Taxation of Construction Contractors
-
Webinar
4.00 Credits
Member Price: $159
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
-
Webinar
4.00 Credits
Member Price: $159
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
-
Webinar
4.00 Credits
Member Price: $149
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.
Accounting Industry Update 25-26
-
Webinar
8.00 Credits
Member Price: $329
FASB Technical Agenda and upcoming changes ASUs Implementation dates and methods Audit quality initiatives Changes to AICPA auditing standards; and PCAOB standards
Comprehensive Passive Activity Losses (PAL) 25-26
-
Webinar
8.00 Credits
Member Price: $329
Overview of the four loss limitation rules and how the PAL rules interact with the other limitations Definition of a PAL including a detailed review of the 7 determining factors contained in the Treasury Regulations with a review of several recent court decisions that interpret this regulation Impact of PAL rules on real estate ownership Learn the six Nonshelterable Passive Activity (NOPA) rules that act as anti-abuse rules to the PAL rules Discuss how the PAL rules impact tax credits Discuss tax elections and planning techniques associated with PALs
Everything You Need to Know About Trusts 25-26
-
Webinar
8.00 Credits
Member Price: $329
Trust obstacles and pitfalls Revoking irrevocable trusts Trust protectors Succession planning, retirement planning and estate planning through trusts Basic issues related to special needs and Medi-Cal planning General Outline of planning with GRATs, QPRTs, IDGTs, etc. Planning with A-B and A-B-C (QTIP) trusts Asset protection through domestic and foreign trusts
K2's Next Generation Excel Reporting
-
Webinar
8.00 Credits
Member Price: $225
Identifying weaknesses in traditional reporting processes Using leading-edge features in Excel to improve reporting practices How to work with Power Query to solve common reporting challenges Adding Slicers and Timelines to your Excel-based reports
Building Security and Efficiency With Internal Control
-
Webinar
8.00 Credits
Member Price: $239
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
-
Webinar
8.00 Credits
Member Price: $299
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