CPE Catalog & Events
Building Security and Efficiency With Internal Control
-
TBD
0.0 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
-
TBD
2.0 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
-
TBD
0.0 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
-
TBD
1.0 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
-
TBD
1.0 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
AICPA's New SSTS #4 - New Ethics Standard for Tax Resolution
-
TBD
1.0 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: A Guide to Sampling - Part 1
-
TBD
2.0 Credits
Member Price: $89
Auditing Yellowbook
ACPEN: State Tax Nexus: Frequently Awkward Questions
-
TBD
2.0 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
-
TBD
2.0 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.
Accounting and Tax Ethics: Standards, Issues, & Case Studies 26-27
-
TBD
4.0 Credits
Member Price: $175
AICPA Code of Professional Conduct Threats to compliance with Code of Ethics Updated Statement of Standards for Taxpayer Services (SSTS) Ethical challenges in selecting appropriate GAAP alternatives
Firm Ethics—A Practical Approach 26-27
-
TBD
4.0 Credits
Member Price: $175
AICPA Code of Professional Conduct Ethics requirements for CPA firms
K2's Mastering Advanced Excel Functions 26-27
-
TBD
4.0 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
-
TBD
8.0 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
-
TBD
0.0 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
-
TBD
1.0 Credits
Member Price: $39
Internal Controls Fraud Prevention Fraud Investigation
The Future of Audit: Technology, Talent & Transformation
-
TBD
0.0 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
-
TBD
1.0 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
-
TBD
1.5 Credits
Member Price: $79
Compensation
ACPEN: Benford’s Law and Other Digital Analysis Techniques
-
TBD
1.8 Credits
Member Price: $79
Benford’s Law Digital Analysis Data analytics
ACPEN: GASB 96 –SBITA, GASB 94 P3, and GASB 87 Leases (Year 2)
-
TBD
2.0 Credits
Member Price: $89
Requirements of GASB 96, GASB 94, and GASB 87 Implementation of GASB 96, 94 and 87