CPE Catalog & Events

The major topics that will be covered in this course include:Overview of supplier contractsCase studies of successful and not-so-successful supplier relationshipsRisk potentials

The major topics that will be covered in this class include:Introduction to ChatGPT and other AI (Artificial Intelligence) language modelsDiscussion of best practices for using ChatGPT with ExcelUse ChatGPT to create, debug and explain formulasUse ChatGPT to learn how to use Excel featuresUse ChatGPT to automate repetitive tasks in ExcelUse ChatGPT to easily create macros

The major topics that will be covered in this course include:Fraud motivators - the fraud triangle, typical profiles of fraud perpetratorsRevisiting the basics of controls - design vs effectiveness, preventative vs. detectiveEntity-wide controls and how they can assist in fraud deterrenceSpecific fraud types and the controls that could prevent and detect them

The major topics that will be covered in this course include:The accounting research transformation: Comparing Google vs. AI methodologiesAI ecosystems and specialized models for accounting applicationsAdvanced prompt engineering techniques for financial and tax researchAI-powered search engines and deep research platforms for accounting professionals AI as an ideation and thinking partner for complex accounting problems Specialized accounting research tools and AI superstoresPersona priming and P&P stacking methodologies for optimal AI interactionsEthical considerations and limitations of AI in accounting researchThe compliance chess effect: AI's impact on tax planning and regulatory responseAI-driven automation for regulatory updates and compliance monitoring

The major topics that will be covered in this course include:IRC § 1031 like-kind exchange rules under current law Changes to § 1031 following the Tax Cuts and Jobs Act Qualification requirements for like-kind exchanges Definition of real property under Treasury Regulations Like-kind versus non-like-kind property Relinquished property Replacement property Realized gain Recognized gain Basis calculations Interaction of § 1031 exchanges with cost segregation studies Depreciation treatment under IRC §§ 1245 and 1250 Allocation of basis to replacement property Depreciation of carryover basis Depreciation of excess basis Multiple-property exchange rules Tax return preparation and review considerations Compliance considerations for § 1031 exchanges

The major topics covered in this class include:Career choicesEthical dilemmasJudicial proceedingsMitigation strategiesCreating tools to help make better decisionsAtonement and reconciliation

The major topics covered in this course include:Lightning round review of the following apps, with an explanation and demonstration of what each of them offersTeams - the foundation of all that you do in Microsoft 365SharePoint / OneDrive - secure cloud storagePower BI - the new financial reporting modelStream - the YouTube for your organizationBookings - streamline your appointment scheduling OneNote - get your content organized for quick retrieval Lists - create custom list tracking reportsTo Do - consolidate all your Outlook, Planner and general "to do's" in one appPlanner - manage simple and complex engagements and projects in an intuitive appA quick look at many of the remaining apps

The major topics that will be covered in this course include:Professional skepticism and existing CPA standardsSix traits of the skeptical professional mindAutomation bias and other AI-related cognitive biasesEvidence and verification rules for AI outputsPractical questioning and challenge techniquesVendor claims, benchmarks, and AI due diligenceReview, documentation, accountability, and skeptical firm culture 

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

The major topics that will be covered in this course include:Why leadership capacity gets cappedExternal pressures on public accounting firms: private equity, technology disruption, talent shortageThe three kinds of work: hard (physical), smart (intellectual), uncomfortable (emotional)The cost of saying yes: avoided conversations, rework, and time lost to lower-value workThe inventory: five categories of low-value commitmentsMeetings and events (e.g., meetings without agendas, "got a minute" interruptions, fear of not being in the know)Unrealistic expectations (e.g., scope creep, upward delegation, duties outside the role)Strategies and opportunities (e.g., shiny-object initiatives, unqualified leads, FOMO partnerships)Tasks and projects (e.g., low-priority admin, unnecessary reporting, work that should be delegated, deferred, discontinued, or done differently)Suboptimal performance (e.g., avoided accountability conversations, discount requests, non-revenue activities, technology avoidance)Quantifying the gapEstimating weekly hours lost, applying a conservative haircut, annualizingWhat the reclaimed hours are worth when redirected to highest-value workCommitting to one changeSelecting one inventory item to decline for the next monthNaming the higher-value activity the time will fundWhere this step sits in the broader six-step process for doing uncomfortable work

The major topics covered in this course include:Introduction to ChatGPT and its applications in the business advisory contextIn-depth exploration of enterprise evaluation methodologies like SWOT, PESTLE, BCG Matrix, McKinsey 7S Model, Ansoff Matrix, etc.Practical case studies demonstrating application of ChatGPT in accounting business analysisKey challenges faced by accounting firms and how ChatGPT can help overcome theseBest practices for implementing AI tools in the accounting sectorFuture opportunities and trends in AI-enhanced business advisory services

The major topics that will be covered in this course include:Update on significant 2025-26 business tax developments and related cases and rulingsReview of recent business tax provisions and their integration into tax formsDepreciation changes in Section 179 and Sec. 168(k) bonus depreciationTax issues impacting “gig” workers, including Form 1099-KRulings on OBBBA of 2025 business provisions.

Excel shortcuts Conditional summing Removing duplicate values VLOOKUP function

The major topics that will be covered in this course include:Recent pronouncements issued by the Governmental Accounting Standards Board (GASB)GASB Statement No. 103 (financial reporting model)GASB Statement No. 104 (disclosures for capital assets)cGASB Statement No. 105 (subsequent events)Active GASB exposure drafts and ongoing projects

The major topics that will be covered in this course include:IRC § 274 meals and entertainment rules Tax Cuts and Jobs Act changes affecting meals and entertainment Deductible versus nondeductible expenditures Definition of “entertainment” Definition of “business associate” Reimbursement arrangements Exceptions under IRC § 274(e) Compensation-related exceptions Recreational activity exceptions Public availability exceptions Goods or services sold to customers Separately stated food and beverage costs Employer-provided meals Per diem reimbursements Compliance and documentation requirements

The major topics that will be covered in this course include:What accounts should get reconciled?Why the banking feed still needs reconciliationThe Reconcile interfaceStep-by-step reconcilingTricks to locate errors quicklyHow to solve common QBO workflow errors that create extra transactions...and a slew of time-saving techniques

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.

Constitutional limits and Public Law 86-272 Interstate activity Nexus, UDITPA and MTC Calculation of state taxable income Filing methods for multistate taxpayers Apportionment and allocation Multistate income tax planning

The major topics that will be covered in this class include:The importance of valuesIdentifying successEthical dilemmasMitigation strategiesCreating tools to help make better decisionsPersonal accountability strategies