CPE Catalog & Events
Analyzing Financial Statements
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Balance sheet analysisIncome statement analysisCash flow statement analysisClues in the notes and MD&AIndustry nuances
Adobe Acrobat Tips for Working with PDF Files
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Review of all that Adobe Acrobat has to offerOrganizing your PDFs with bookmarks, links, file attachments and moreFormatting the presentation of PDFs with headers, footers and watermarksCreating and processing fillable formsProcessing documents for e-signatureTips for converting email messages, documents and spreadsheets into PDF formatCombining multiple PDF files into a single binder Utilizing the security features of Adobe Acrobat to protect document confidentiality
The 10 Must Know Excel Features
-
Virtual
2.00 Credits
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.
Numbers to Narrative: Storytelling in Business Communication
-
Virtual
1.00 Credits
The major topics that will be covered in this course include:Role of narrative in professional communicationSituation–complication–resolution frameworkNarrative arcs in business contextsIntegrating data within a structured storyDefining tension and resolution logicallyMaintaining accuracy while improving clarityApplication of storytelling framework to a workplace scenario
AI Prompt Engineering Masterclass for Accountants
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Introduction to Prompt Engineering: Basics of structuring effective prompts for meaningful AI responses.Understanding AI's "Lazy" Defaults: Why LLMs provide basic answers and how to push them to deliver richer insights.Multi-Layered Prompting: Techniques to encourage AI to provide responses across beginner to expert levels.Candid and Contrarian Responses: Using prompts that elicit honest and balanced insights, even on controversial topics.Ripple Effect and Cobra Effect: Probing the broader impacts and unintended consequences of financial decisions.Avoid Stupidity Checklist: A practical prompt for reducing mistakes in AI-assisted accounting tasks.Role-Based Perspective Prompts: Crafting prompts that guide AI to respond from specific professional viewpoints.Automation Ideas: Leveraging AI to optimize repetitive accounting tasks.Emotion-Driven Prompting: Exploring how emotion-focused prompts can enhance AI performance and engagement.Practical Applications in Accounting: How to apply prompt engineering in real-world financial analysis and decision-making.
Enterprise-Wide Risk Management in Accounting and Finance
-
Virtual
4.00 Credits
The major topics that will be covered in this course include:Enterprise-wide risk management best practices for identifying, evaluating, and determining how to respond to relevant risks.The importance of risk and uncertainty disclosures in the preparation and fair presentation of financial statements, including evolving risks with cybersecurity and ESG.Coordinating risk management efforts, including the required involvement of corporate governance.How to embed risk management into day-to-day accounting and finance activities.
Ethics, AI, and Music: What Every CPA Must Know
-
Virtual
1.00 Credits
The major topics that will be covered in this course include: Four key aspects of artificial intelligence that are relevant to CPAs: machine learning, generative AI, large language models, and GPT.The role that five powerful principles—the principles of ethical intelligence—play in using AI the right way. Short, focused writing exercises (30 seconds each) designed to deepen understanding of the topic. Real-world case studies about the use of AI in music as well as accountingAnswers to several crucial questions about how to use artificial intelligence with ethical intelligence.
Google Gemini Deep Dive Hands-on Bootcamp for CPAs
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Getting started with GeminiTour of the Gemini app and how to use itVariety of hands-on case study examples for accounting, finance, and taxProtecting your data privacy in Google GeminiAdvanced Gemini features reviewIntegration with Google appsSubscription plan option
Business Tax Update: OBBA and Recent Developments
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Recent legislation impacting business taxpayersThe One Big Beautiful Bill ActExtenders legislation updateMeals and entertainment expense reportingPartnership and S corporation updateIncome and deductions
AICPA's New SSTS #4 - New Ethics Standard for Tax Resolution
-
Virtual
1.00 Credits
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.
Tax Implications of Retirement Plan Distributions
-
Virtual
1.00 Credits
The major topics that will be covered in this course include:Required minimum distributions for a deceased’s heirs2025 retirement plan contribution limitsRequired minimum distributions and contributions to charityKey provisions of Secure Act 2.0
Ethics and Technology for CPAs
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:The foundational ethical principles CPAs are required to follow and how these principles apply to audit quality, data privacy and security, and the use of emerging technologies.The profession's need to change to meet its ethics standard in a technology-centric environment.Changes being considered by the AICPA and the National Association of State Boards of Accountancy that could impact the profession.
What's Behind the Data?
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Ways in which data and information can be misleadingCommon pitfalls when encountering dataHow to re-evaluate the data to avoid those pitfalls
Reviewing Partnership Tax Returns: What Are You Missing?
-
Virtual
4.00 Credits
Common errors made involving the following: Form 1065 Schedules K and K-1 Schedules M-1 and M-2 Calculating recourse and nonrecourse liabilities Partner inside and outside basis Partner's capital account analysis Sections 704(b), 704(c), 721, 722, 732(b), 734(b), 737, 743(b)
Applying the Uniform Guidance in Your Single Audits
-
Virtual
8.00 Credits
Introduction to single audits Preparation of the schedule of expenditures of federal awards and determining major programs Understanding, assessing, and testing internal control Testing compliance with federal statutes and regulations and applicable compliance requirements Auditor reporting in a Uniform Guidance compliance audit Program-specific audits Administrative requirements and cost principles in a single audit
AI Lessons Learned for Accountants
-
Virtual
2.00 Credits
The major topics that will be covered in this course include:Introduction to AI R&D in Accounting: Why internal AI research is essential for modern firms.Theory to Practice: Moving quickly from speculative AI concepts to actionable strategies.Managing Exponential Change: Understanding the urgency of adapting to AI’s rapid evolution.Proactive AI Engagement: Conducting in-house AI benchmarks, research, and hackathons.The Dual Role in AI Development: Balancing innovation with data security and ethical responsibilities.Internal AI Tools Creation: Encouraging accountants to develop AI solutions tailored to their needs.Data Security and Cyber Threats: Addressing AI-enabled cybercrime and protecting against internal risks.Mitigating AI Misuse: Recognizing abuse patterns and implementing safe practices.Challenges in AI Integration: Handling resistance, management concerns, and rapid technological shifts.Continuous Learning and Adaptation: Building a resilient, R&D-focused AI culture in accounting.
Workforce Transformation and Talent Management in 2025
-
Virtual
1.00 Credits
To purchase the report referenced in this presentation, or any of the research papers published by CPA Crossings, visit https://www.cpacrossings.com/research. The major topics that will be covered in this course include: Understanding why the traditional pyramid structure is failing firms The inverted pentagon framework and its talent retention advantages Impact of technology and AI on entry-level accounting roles The 6 Ps of Business Model Transformation implementation Accelerating specialized skills acquisition in your workforce Effective knowledge transfer through mentorship and job rotation Technology-driven training and development strategies Best practices from other industries for workforce transformation Building and retaining specialized middle layers of expertise Strategic pricing models to support the pentagon structure
Self-Rental Real Estate: Passive Activity & Section 199A
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Definition of self-rental property - both for Sections 199A and 469Self-rental income from directly owned properties and reporting on Form 1040, Schedule E, page 1Self-rental income from indirectly owned (partnerships, S corporations) and reporting on Form 1040, Schedule E, page 2Form 8582 (passive activity)The flow-through entity grouping electionIllustrative examples and consequences of failing to comply with the reporting standardsSelf-rental property and "former passive activities" rules
Improve Spreadsheets by Building Controls in Excel
-
Virtual
2.00 Credits
The major topics that will be covered in this class include:Learn best practices when designing your spreadsheets How to create a proper worksheet structureLearn to use Excel's built in features to find errorsHow to create your custom controls to prevent and find errorsUsing links to quickly move to controlsUsing Conditional Formatting to highlight errors
Corporate Finance Technology Selection: Practical Frameworks
-
Virtual
1.00 Credits
The major topics that will be covered in this course include:The changing finance technology landscape: continuous processing, modular ecosystems, automated controls, and real-time visibility (and the risks these shifts introduce)Technology trends and “AI” definitions: automation vs. machine learning vs. generative AI vs. agentic AI—what each means for governance and auditabilityFive common challenges in finance tech projects and how to address them:Cutting through vendor claims and AI hypeIntegration complexity and hidden costsChange management and proving ROIData quality readiness for AI and automationRisk, security, and governanceVendor Evaluation Scorecard: 20 criteria across five categories, including control “deal-breakers” (audit trails, segregation of duties, logging, SOC reporting, error handling)Five-Year Total Cost Framework: software, implementation, data migration/cleanup, integration build & maintenance, internal costs, training, and ongoing operations (plus common underestimates)Industry-specific considerations (manufacturing, distribution/wholesale, SaaS/tech, professional services)Four-phase implementation roadmap with checkpoints and red flags: Assessment & Planning; Selection & Negotiation; Implementation & Testing; Optimization & Ongoing GovernanceWorking with external advisers (CPA/auditor involvement, implementation partner expectations, and common deficiencies to avoid)