CPE Catalog & Events
ACPEN: Maximizing Fringe Benefits: Strategies for Business and Personal Needs for Today and Beyond
-
Webinar
8.00 Credits
Member Price: $250
Legislative and regulatory updates affecting fringe benefit planning Employer-sponsored fringe benefits and tax compliance under evolving regulations IRC §132 fringe benefit options and applications Cafeteria plans: benefits, limitations, and tax considerations Tax treatment of dependent care and educational assistance programs Flexible spending accounts and health savings accounts Group term life insurance: design features and tax treatment Financing strategies for retiree medical benefits Comparing health care benefits: insured plans vs. HMOs ERISA reporting and disclosure requirements Common control rules and nondiscrimination regulations
ACPEN Signature 2026: The Risk of Fraud in State & Local Government
-
Webinar
8.00 Credits
Member Price: $250
Types of Fraud in State and Local Government (financial fraud, procurement fraud, corruption, abuse of power) Fraud Risk Assessment and Internal Control Systems Regulatory Frameworks and Compliance Requirements Fraud Investigation Techniques and Forensic Accounting Ethics, Governance, and Organizational Culture in Fraud Prevention
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
ACPEN: Excelling at Excel: The Magic of Power Query
-
Webinar
2.00 Credits
Member Price: $89
Intro to Power Query & how to get started Examples of data clean up using Power Query Combining workbooks and files with Power Query
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.
ACPEN: K2’s Better Reporting With QuickBooks Online
-
Webinar
1.00 Credits
Member Price: $39
The types of reports available in QuickBooks Online, by subscription level Customizing reports to meet your needs Spreadsheet Sync in QuickBooks Online Advanced
ACPEN: K2's Ten Questions To Ask Your IT Team
-
Webinar
1.00 Credits
Member Price: $39
Ten Strategic Question Frameworks for Technology Assessment Cybersecurity and Infrastructure Oversight Through Targeted Dialogue Cloud Governance and Remote Work Technology Evaluation
Auditing digital assets: Entity’s use of a service organization
-
Webinar
1.00 Credits
Member Price: $49
Understanding the entity and its environment and the service organizations role related to digital assets SOC 1® and SOC 2® reports as sufficient appropriate evidence Risks and challenges associated with performing audit procedures involving service organizations.
ACPEN: A Guide to Sampling - Part 1
-
Webinar
2.00 Credits
Member Price: $89
Auditing Yellowbook
ACPEN: State Tax Nexus: Frequently Awkward Questions
-
Webinar
2.00 Credits
Member Price: $89
Frequently asked questions about income tax and sales tax nexus New developments Key factors in reviewing potential nexus consequences Nexus road trip to eight large states Tax impacts of remote work Free, multistate resources
Corporate Transparency Act Developments
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Background of the Corporate Transparency ActBeneficial Ownership Information Reporting (BOIR) Rule Entities required to report.Reporting requirements imposed by the CTADue dates of reportsInformation needed to satisfy the BOIRImpact of failure to reportHow to submit a reportCourt rulings on CTA’s unconstitutionalityImplications to entities as a result of the ruling in NSB.Potential reporting requirements due to FinCen’s proposed rulemaking with respect to non-financed purchases of residential real estate and gratuitous transfers.
K2's Mastering Advanced Excel Functions 26-27
-
Webinar
4.00 Credits
Member Price: $175
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
ACPEN: S Corporation Preparation, Basis Calculations & Distributions – Form 1120S Schedule K & K-1 Analysis
-
Webinar
8.00 Credits
Member Price: $300
Extensive review of the S corporation tax laws with an emphasis on any new legislation Review the Form 1120S and discuss how items get reported on the S corporation tax return (i.e. page 1 versus Schedule K) and flow-thru to the shareholders on their schedule K-1 Analyze the Schedule K-1 line-by-line and discuss where the items get reported on the individual’s Federal income tax return and how the items affect the shareholder’s stock and debt basis 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 S corporation formation issues under IRC §351 Tax ramifications and reporting of distributions at the S corporation level including when the S corporation has prior C corporation earnings and profits (E&P) Preparation of the Schedule M-2 and the ordering rules for distributions out of the AAA, PTI, E&P and OAA accounts
Cybersecurity: Protecting Your Firm's Data and Reputation
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Assessment of the current cybersecurity threat level and vulnerabilitiesDeveloping your WISP (Written Information Security Program) Deploying a password management app (PMA) to fortify the security of your login credentialsImplementing an incident response plan to minimize the damage from a cybersecurity attackUnderstanding the role of cybersecurity insurance
ACPEN: A Fox in the Henhouse/Courthouse
-
Webinar
1.00 Credits
Member Price: $39
Internal Controls Fraud Prevention Fraud Investigation
The Future of Audit: Technology, Talent & Transformation
-
Webinar
1.00 Credits
Member Price: $55
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: Explore AI, blockchain, and data analytics impact on audits Address talent crisis through retention and upskilling strategies Navigate PCAOB standards and regulatory sandbox concepts Expand audits to include ESG and nonfinancial metrics Implement technology solutions for firms of all sizes
ACPEN: Maximizing the Tax Benefits of an Installment Sale
-
Webinar
1.00 Credits
Member Price: $39
Installment sale treatment eligibility When to elect out of installment sale treatment Installment sales of business assets Installment sale default and the rules for personal property vs real property Depreciation recapture
ACPEN: A Strategic Approach to Understanding Compensation Structures
-
Webinar
1.50 Credits
Member Price: $79
Compensation
ACPEN: Benford’s Law and Other Digital Analysis Techniques
-
Webinar
1.80 Credits
Member Price: $79
Benford’s Law Digital Analysis Data analytics
ACPEN: GASB 96 –SBITA, GASB 94 P3, and GASB 87 Leases (Year 2)
-
Webinar
2.00 Credits
Member Price: $89
Requirements of GASB 96, GASB 94, and GASB 87 Implementation of GASB 96, 94 and 87