CPE Catalog & Events

PivotTable basics Row fields Value fields Column fields Filters Updating data automatically in PivotTables Groups and subtotals Value formats

The major topics that will be covered in this course include:Evidence Preservation & Cryptographic Security: Prioritizing immediate data protection by exporting defensible QuickBooks Online (QBO) snapshots and utilizing Windows PowerShell or Command Prompt to generate file hashes to prove data integrity.Standards Compliance & Access Management: Navigating the legal and professional boundaries of AICPA SSFS No. 1 and ACFE standards, which prohibit CPAs and CFEs from making final legal conclusions of fraud, while managing administrative access levels and uncooperative gatekeepers.Ledger Auditing & Transaction Reconstruction: Using the QBO Audit Log to uncover deleted or voided entries, performing reconciliation health checks, auditing bank feed gaps, and examining Undeposited Funds and journal entries to trace hidden or manipulated cash.Analytical Procedures & Metadata Analysis: Applying comparative horizontal and vertical financial statement analysis, drilling down into General Ledger transaction details, and evaluating created-date metadata to flag anomalies like weekend or after-hours entries.Targeted Fraud Detection & Testing: Cross-matching vendor and payroll records to expose shell vendors or ghost employees, analyzing accounts receivable write-offs for lapping schemes, and applying safe, isolated scenario-testing techniques within QBO

The major topics that will be covered in this course include:AI fundamentals: how large language models work, why they hallucinate, and the distinction between generative and agentic AIPractical applications of AI in damages calculations, financial statement and ratio analysis, and books-and-records reconstructionProfessional ethics under the AICPA Code of Professional Conduct, SSFS No. 1, and the ACFE Code of Professional Ethics as applied to AI-assisted workCourt requirements for disclosure and discovery of AI use, including judicial standing orders, Federal Rule of Civil Procedure 26, and proposed Federal Rules of Evidence 707 and 901(c)Preparation for cross-examination on AI use, including how to build and document a defensible AI-assisted workflow.

The major topics that will be covered in this course include:Update and integration of recent tax legislation impacting 2026 individual returnsUpdate on significant individual tax developments related to cases and rulingsIndividual tax changes including the earned income credit, child credit, and child and dependent care creditSection 199A changes, including use of carryforward passive activity and 199A losses and latest tax formsCrypto reporting update2027 tax rate schedule and other inflation adjusted itemsPassive activity and hobby loss rules changes.

The major topics that will be covered in this course include:Introduction to the Gramm-Leach-Bliley Act and its impact on data security.Circular 230 compliance and due diligence for practitioners.AICPA Statements of Standards relevant to WISP requirements.Key components of a Written Information Security Plan.Training requirements for employees, staff, and contractors.Practical guidance for drafting and implementing a WISP.FTC enforcement of data security standards for PTIN holders.Best practices for maintaining and updating WISP compliance.

AICPA Code of Professional Conduct CPA responsibilities and AU-C 315 The new AICPA Ethics Codification Disciplinary cases and actions CPA Vision Seminal events The impact of ethical and unethical conduct on our profession

The major topics that will be covered in this course include:Customizing your settingsRefining your Chart of AccountsCreating your products and servicesManaging your vendors listMeals vs. owner drawsUsing undeposited fundsProper use of the banking feedMaintaining supporting documentationReconciling properlyGetting help when you need it 

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 that will be covered in this course include:Ethos, Logos, Pathos frameworkCredibility and authority in professional communicationLogical argument structure and clarityEmotional dynamics and engagementEmotional contrast and volatility in persuasive messagingBalancing persuasive appealsApplication analysis of professional communication examples 

The major topics that will be covered in this course include:Cost segregation study fundamentals Depreciation methods used in cost segregation Technical and compliance considerations for cost segregation studies IRS Cost Segregation Audit Techniques Guide (ATG) Section 1245 property Section 1250 property Classification of Section 1245 versus Section 1250 property Cost allocation methodologies Engineering documentation requirements Supportable cost estimates Key elements of a well-prepared cost segregation report Documentation supporting cost segregation conclusions Common cost segregation study deficiencies Red flags that may trigger IRS scrutiny Audit-defensible cost segregation reports Remedies for strengthening study credibility Audit resilience of cost segregation studies

Economic trends and their effect on business Ways to drive operational efficiency Leveraging technology in finance Cash management and working capital Effective talent management Sustainability and corporate responsibility

The major topics that will be covered in this course include:Planning the Exit or Ownership ChangeChoice of transaction structureAsset sale vs. equity sale vs. redemption vs. liquidationBuy-sell agreement design and valuation implicationsCore Basis ArchitectureInside vs. outside basisPartnership liability allocations under Section 752S corporation stock basis and debt basis limitationsSales and Transfers of Ownership InterestsPartnership interest sales and Section 751 hot assetsS corporation stock salesDeath, Section 1014 basis adjustments, and successor-owner issuesPotential Section 1202 considerations where relevantLiquidations and DissolutionsPartnership liquidating distributions under Sections 731, 732, and 736S corporation liquidations under Sections 336 and 331Treatment of cash, property, liabilities, and built-in gain or lossRedemptions and Internal Ownership ShiftsSection 302 testsSection 301 fallback treatmentCross-purchase vs. redemption economics and tax consequencesRestructuring and Entity ModernizationF reorganizationsPre-sale and post-sale restructuring considerationsBasis and attribute preservation issuesSpecial SituationsTransfers incident to divorce under Section 1041Suspended losses and carryover basis issuesGoodwill and Section 197 intangiblesFamily and related-party complicationsAncillary Tax ConsequencesSection 1411 NIITState tax nexus, trailing nexus, and dissolution-related state filingsTransfer tax and valuation overlap where applicableFinal-Year Reporting and ComplianceFinal Forms 1065 and 1120-SForm 966 and related dissolution filingsEIN closure and administrative wrap-upPractical reporting checklistsValuation of Closely Held InterestsRev. Rul. 59-60 principlesDLOM and minority discountsSection 2703 and buy-sell agreement enforceability for transfer tax purposes

The major topics that will be covered in this course include:Understanding ethical implications of AIData privacy and security considerationsCompliance with regulations and professional standardsDeveloping ethical AI policies and procedures

Case studies that clarify the challenges of making appropriate ethical decisions in the fast-paced modern organizational world A frank discussion of how to decide between a teaching moment rather than a termination moment when bad decisions are made. Applying the structure of understanding ethical dilemmas, and then applying the nine-step resolution process to arrive at a fair and consistent decision.

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:Why one visible machine error collapses trust while identical human error does not, and what that asymmetry costs firms in both directionsWhere small and midsize firms actually stand on AI adoption, and why a firm that has not adopted broadly is not automatically behindCalibrated trust: the difference between misuse (overtrust), disuse (undertrust), and trust matched to what a tool actually does wellThe five-stop adoption spectrum: paralysis, accidental delay, informed caution, responsible piloting, and reckless adoptionThe AI Trust and Usage Quadrant: four firm postures and the next step each one impliesGoverned versus unstructured AI use, and why staff already bringing their own tools makes abstention a decision rather than an optionWhat the evidence says about human and AI combinations, and the two task questions that predict whether a tool will help or hurtReading vendor claims: the gap between a demo and production, and why fluent explanations increase acceptance of wrong answersFive trust questions to ask any AI vendor: permission, uncertainty, audit trail, explainability, and change controlThe NIST AI Risk Management Framework trustworthiness characteristics as a technical backboneThree vulnerabilities that current firm financial performance can conceal: client expectations, talent, and deferred learningCognitive offloading and skill retention: what firms lose by waiting, and the conditions under which offloading frees capacity insteadFive actions a firm can take this week, and four evidence-based rollout rules for a first pilot

The major topics that will be covered in this course include:Professional accountability for AI-generated workAI errors, hallucinations, and malpractice exposureEmerging cases, sanctions, and disciplinary actionsAI regulatory expectations in the US, Canada, and UKProfessional liability insurance and AI coverage gapsConfidentiality, privilege, privacy, and data exposureVerification, documentation, governance, and defensibility

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:Claude Cowork advanced workflow architectureFinance Plugin and domain-specific intelligenceModel selection and token optimization strategiesVariance analysis and cross-file reasoningInvoice extraction and automation workflowsThe Sparring Partner Protocol (SPP)AI governance, risk, and performance measurement

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