CPE Catalog & Events
ACPEN: K2’s Mastering Advanced Excel Functions
-
Webinar
4.00 Credits
Member Price: $149
Powerful new functions and features in Excel, such as XLOOKUP and Dynamic Arrays How to use "legacy" features and functions such as AGGREGATE Creating effective forecasts in Excel
Al Capone to Cybercrime: The Journey of IRS Special Agents
-
Webinar
4.00 Credits
Member Price: $149
The major topics that will be covered in this course include:Introduction to IRS Criminal Investigation (CI): Overview of its mission, role, and significance in maintaining tax compliance.Historical Evolution: From its inception in 1919 to its current role, highlighting key milestones and notable cases.Investigative Techniques and Tools: Detailed look at the methods and technologies used by CI agents to uncover financial crimes.Importance of IRS CI: Discussion on the impact of CI’s work on tax compliance, public confidence, and the broader financial system.Training of CI Agents: Insight into the rigorous training programs at FLETC and ongoing professional development.Process of Investigations: Step-by-step breakdown of how tax fraud and money laundering cases are initiated, investigated, and prosecuted.
ACPEN: Fringe Benefits & Compensation Planning - Today and Beyond
-
Webinar
8.00 Credits
Member Price: $250
Fringe Benefit Planning Fundamentals Strategies Tailored for Business Owners and Employees Navigating IRC §132 Fringe Benefit Option Cafeteria Plans Demystified Tax Management in Compensation Planning Understanding the Implications of Dependent Care and Educational Assistance Plans Implementing Flexible Spending Account Plans Effectively Design Features and Regulations of Group Term Life Insurance Plans Medical Savings Accounts Regulations Financing Options for Retiree Medical Benefits Health Care Benefits: Insured Plan vs. HMO Comparison ERISA Reporting and Disclosure Requirements IRC Common Control RulesOverview of Age and Sex Discrimination Rules
ACPEN: Strategies for Guiding Clients Through Challenging Situations: Tax Insights
-
Webinar
8.00 Credits
Member Price: $250
Tax considerations in complex client situations Divorce and separation tax issues Filing status considerations Property division and marital property rules Child support and alimony tax treatment Bankruptcy and debt cancellation Foreclosure tax consequences Business dissolution and ownership transitions Dependency and family tax issues Refunds, deficiencies, and taxpayer obligations
Understanding and Creating an Internal Control System
-
Webinar
8.00 Credits
Member Price: $239
The major topics covered in this course include:Underlying concepts of internal controlDefining where and why controls, policies and procedures are neededLegacy control measures that are still important for businesses todayCreating control measures that address the use and protection of technology
Microsoft 365 for CPAs: Unlocking Hidden Productivity Tools
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Round robin review of lesser known M365 appsReduce / eliminate internal email communications with Teams and SharePointCollaborate on spreadsheet and documents with your colleagues in real timeGet control of your appointment schedule with the Bookings appTap the full potential of OneNote as your primary repository for notes, correspondence and moreReplace email attachments with secure file sharing linksDocument business processes with the Stream appLeverage the power of AI in M365 with Copilot
ACPEN: Don't Be Spooked: Mastering Conflict Resolution
-
Webinar
1.00 Credits
Member Price: $39
Employee relations Conflict resolution
AICPA's New SSTS #4 - New Ethics Standard for Tax Resolution
-
Webinar
1.00 Credits
Member Price: $55
The major topics that will be covered in this course include:This session will provide a comprehensive overview of the ethical guidelines outlined in Circular 230 and the newly updated Statements on Standards for Tax Services (SSTS) #4. Gain insights into how these standards apply to real-world tax resolution scenarios, ensuring compliance and integrity in your practice.
ACPEN: Emerging Risks and Resilience - How Accountants and Finance are Leading the Way - Part 2 Technology Disruption, Artificial Intelligence an
-
Webinar
1.60 Credits
Member Price: $79
Artificial Intelligence Emerging Risks for Acccountants and Finance Cybersecurity Risks
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.
Ethics in the Real World 26-27
-
Webinar
4.00 Credits
Member Price: $175
Why model codes of ethics fail The science behind organizations "Ethical DNA" Understanding the psychology behind "Tone at the Top" The interaction between critical thinking and ethics Breaking myths about motivation related to decision-making Ethical decision-making under pressure Are ethics and morals "fixed" or can we learn to improve
How to Review Financial Statements 26-27
-
Webinar
4.00 Credits
Member Price: $175
Practice reviewing financial statements Financial statement case studies
SSARS Practice Issues and Standards Update 26-27
-
Webinar
4.00 Credits
Member Price: $175
Review of applicable SSARS standards, including standards updates Review of AICPA professional ethics requirements In-depth discussion of non-attest services Review of independence issues for SSARS services Overview of SSARS #21'performance, documentation and other requirements Detailed analysis of preparation vs. compilation engagements Detailed analysis of review engagements
Tax Planning for Seniors 26-27
-
Webinar
4.00 Credits
Member Price: $175
Income for seniors: retirement, earnings and investments Tax Deductions: planning, bunching, strategies Planning to help family members
Hands-On Tax Return Workshop - S Corporations (Form 1120S) Partnered with the Oregon Society
-
Webinar
8.00 Credits
Member Price: $270
This session is taught using a Hands-On methodology. Using a comprehensive trial balance, the participant will walk through the steps to prepare a complete and accurate Form 1120S (and related schedules). Each participant will receive a comprehensive S corporation income tax reference manual that includes numerous practice aids, real world examples, new Federal income tax forms and schedules, and Pat Garverick's Quick Reference Chart. Topics include: Comprehensive review of S corporation income tax laws, with emphasis on new legislative changes (e.g., the One Big Beautiful Bill) and the status of expiring or extended provisions. Schedule K analysis- determine if income statement items are separately (i.e. schedule K) or non-separately stated income and expense items. Discuss how schedule K items get allocated to shareholders on their schedule K-1s. Look at detailed Schedule K-1 information reporting to shareholders needed for the qualified business income (QBI) deduction, 3.8% net investment income tax and business interest expense limitations. Talk about the unreasonably low officer compensation issues. Learn the special tax treatment of fringe benefits paid to 2% shareholders and family members. Schedule M-1 - calculate the reconciliation of income or loss per books with income or loss per income tax return. Schedule M-2 - detailed step-by-step calculation of the AAA, PTI, E&P and OAA accounts. Basic overview of the tax treatment of distributions including when a S corporation has prior C corporation earnings and profits (E&P). Review the importance and basics of calculating a shareholder's stock and debt basis. Basic overview of the potential S corporation built in gains tax from the conversion of a C to S corporation.
Metrics Management: Choose and Use Key Performance Indicators 26-27
-
Webinar
8.00 Credits
Member Price: $329
Link long term strategy to short term financial plans Use benchmarking to determine what performance should be
ACPEN: Shortcuts to Personal and Professional Success
-
Webinar
4.00 Credits
Member Price: $250
1. What really leads to success in the modern world The five things that correlate with fulfillment The five skills that lead to personal success Why "inner technology" is so important to succeed 2. Mastering the Art of Communication Why communication is so important The five mistakes people often make when they communicate How to solve problems without bruising egos How to get people to want to work with you 3. The Magic of Motivation: The key to success is consistency Why people normally don't stay motivated, and how to overcome this Why procrastination is a problem, and how it can be easily handled How to motivate other people 4. Overcoming Your Fears Why people have fears, and how they can be overcome The three skills needed to overcome any fear Identifying the fears that stop you, and creating a plan to overcome them 5. What makes people really happy—and what doesn’t The 3 most important things you can do to increase both happiness and productivity How to handle stress in under two minutes How to tap into a greater sense of purpose and meaning How to use positive psychology principles to help your business
ChatGPT Vision for Financial Analysis
-
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.DDPP Analysis - Applying descriptive, diagnostic, predictive, and prescriptive analysis to visual data.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.
2026/27 Not-for-Profit GAAP Update
-
Webinar
1.00 Credits
Member Price: $55
The major topics that will be covered in this course include:Recently issued Financial Accounting Standards Board Accounting Standards Updates (ASUs) impacting NFP financial reporting, along with standard-setting projects currently in the FASB pipeline.The International Non-Profit Accounting Standard (INPAS)-the first comprehensive global accounting framework designed specifically for non-profit organizations, launched in October 2025.
ACPEN: Compensation Fundamentals and Pay Transparency: Driving Fairness & Engagement
-
Webinar
1.00 Credits
Member Price: $39
Compensation