CPE Catalog & Events

Ethical frameworks Threats and safeguards to objectivity and independence

Rules of civil and criminal procedure Applicable standards Testifying basics Cross-examination techniques

Quality Management Risk Assessment SQMS Independence

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.

The major topics covered in this class include:Review of special purpose frameworksDiscussion of non-GAAP options for financial reportingU.S GAAP alternatives for certain entities

How to recognize a derivative or embedded derivative in a digital asset transaction How to determine if a derivative or embedded derivative meets the net settlement criterion Understand the financial statement impact and disclosure considerations related to derivatives and embedded derivatives How the mining process is used to validate transactions How revenue is recognized by mining entities.

The major topics covered in this course include:The power of keyboard shortcutsOft used features with more capability than meets the eyeNew helpful featuresNote: This session is taught using Hands-On methodology. We provide practice files that tie to the examples in the course materials so participants can undertake all the steps in unison with the instructor.

An overview of the beginning of the process and documents for preliminary tax planning Recognizing the need for due diligence in acquisitions, including checklists of important points Deemed asset sales – §338 and §338(h)(10) The impact of the §197 amortizable intangibles regulations on the acquisition and disposition of a business Allocating purchase price for tax advantage Planning to avoid double taxation under the repeal of the General Utilities doctrine Special problems and opportunities when an S corporation is the buyer or seller Installment sale and interest issues Avoiding tax pitfalls and recognizing tax planning opportunities Unique issues in buying and selling LLC/partnership interests Impact of the net investment income tax (NIIT) and the §199A pass-through deduction on the tax due on the sale of a pass-through entity Individually owned goodwill

The major topics that will be covered in this course include:Role of cloud computing as the foundation for all tech trendsBig data and data analytics the new frontier for CPAsWorkflow automation with RPA, ML and AI with a focus on ChatGPTBlockchain technology, the revolutionary data storage modelCryptocurrency 15 years later, an update on the market and technologyMetaverse - what's it all aboutCloud based financial and ERP software market update

Developing issues related to Yellow Book audits and single audits Key AICPA developments affecting audits of governments and nonprofits (including SAS No. 145 on risk assessment) Recent GASB activities directed toward state and local governments (e.g., the implementation of GASB Nos. 100 and 101, and additional GASB projects) Lessons learned by nonprofits (and lessons remaining) from the implementation of FASB ASC 842, Leases and ASU No. 2020-07 related to contributions of nonfinancial assets Other issues related to nonprofits

Legislative developments A full chapter devoted to determining the best planning options for maximizing joint Social Security benefits Retirement benefits: Amount of benefits in various circumstances; how the amounts are distributed within the family unit Qualification: Has the client retired? How business entities may be used for Social Security advantage Income taxation of Social Security: avoidance tactics Spousal benefits: Should a spouse return to work? What benefits does a spouse have and when and how do they relate to benefits decisions by the client? When can hiring the spouse increase overall benefits?  Why should both spouses qualify for survivor benefits? Disability benefits When to start Social Security benefits: Advantages and disadvantages at ages 62, full retirement age, and 70 Coordinating benefits: Should you take Social Security first and higher-balance IRA distributions later, or take IRA balances first and enhanced Social Security benefits later? Pensions: Distribution strategies; how to use the minimum distribution rules in concert with Social Security benefits IRAs: Is it time to convert to a Roth? Medicare, Part D prescription drugs: what retirees need to know

Comprehensive coverage of the Inflation Reduction Act, including: The Clean Vehicle Credit, Credit for Previously Owned Clean Vehicles, Credit for Qualified Commercial Clean Vehicles, Residential Clean Energy Credit, Energy Efficient Home Improvement Credit, and Premium Tax Credit Comprehensive coverage of the SECURE 2.0 Act, including: Expanding Enrollment in Retirement Plans, Increase in Age for Required Beginning Date for Mandatory Distributions, and New Exceptions to Penalty-Free Withdrawal from Retirement Plans Timely coverage of breaking tax legislation New Form 1099-K reporting requirements Detailed analysis and examples of Sale of Passthrough Entity Interest and Net Investment Income Tax Residency and Domicile Selling a principal residence, including tax planning strategies Real Estate professional requirements Virtual currency, including recent developments regarding NFTs Review of pertinent cases and rulings affecting taxpayers Practice aids, including all the numbers applicable for the current year -- inflation-adjusted amounts, mileage rates, retirement contributions, and more Advanced practice, reporting, and other issues intertwined with advanced planning and discussion ideas

Comprehensive coverage of the Inflation Reduction Act, including: The Corporate Alternative Minimum Tax, The Clean Vehicle Credit, Credit for Previously Owned Clean Vehicles, and Credit for Qualified Commercial Clean Vehicles Comprehensive coverage of the SECURE 2.0 Act with a focus on provisions applicable to employers Retirements and redemptions: considerations for partnerships and S corporations Timely coverage of breaking tax legislation Schedules K-2 and K-3 reporting requirements, including the 2022 domestic filing exception and Form 1116 exemption Form 7203, S Corporation Shareholder Stock and Debt Basis Limitations, with examples of how to calculate stock basis Overview of the economics and tax consequences of crowdfunding campaigns  Selected Practice and Reporting Issues: What’s new? A review of recent cases and tax law changes and IRS guidance affecting S corporations, partnerships, limited liability companies, and limited liability partnerships New Form 1099-K reporting requirements Bonus depreciation  Section 163(j)  Section 174 Research & Experimental Expenditures New FinCEN reporting requirements in 2024 Employee vs independent contractor considerations that companies should be aware of A review of like-kind exchange transactions under §1031 State and local taxes: pass-through entity workarounds Special basis adjustments, including comprehensive examples

The major topics that will be covered in this class include:AICPA auditing standards issued during the 18-month period prior to the program that impact audits of Small- and Medium- sized entities (SMEs)The new SAS 145 risk assessment requirementsThe new SAS 134 as amended audit reportsHow to fulfill responsibility to detect fraud under AU-C Section 240How to help clients design, implement and maintain their internal controlsTroublesome areas in the audits of Small- and Medium-sized Entities (SMEs) as identified in peer reviews and litigationHow to perform profitable audits of Small- and medium-Sized Entities (SMEs)

Emotions Relationships

We will begin with a "What would you do?" quiz with five challenging scenarios. You'll be asked to choose among several options in each situation (don't worry, we won't collect the results).Next we'll do a deep dive into the five principles of ethical intelligence:Do No HarmMake Things BetterRespect Others (by keeping confidences, telling the truth, and keeping your promises)Be FairCareComplete a few fun writing exercises (optional) during the webinar. After which, Bruce shows how the principles of ethical intelligence reveal which option in each scenario is best.We'll conclude with a Call to Action so that some of the lessons from this webinar can be put into practice immediately. Even doing one of the things Bruce suggests will enrich your accounting practice and your life.

Should ethical behavior be something that we always do? Is ethical behavior situational? Why being ethical will help you succeed personally and professionally. Consequences of not behaving ethically? Why trust matters? How we can make better ethical decisions in our professional lives.

Languages of appreciation Appreciation strategies

The shift to “predictive accounting” for Decision Making, Planning, and Budgeting Problems with traditional annual budget processes Develop a driver-based “operational budget” based on resource capacity planning Classify resource capacities and their expenses as sunk, fixed, step-variable, and variable Create closed loop capacity plans Forecast demand for budgeting and rolling financial forecasts Integrating enterprise risk management (ERM) with management accounting Applying target costing for cost estimating

Why great predictions are not intuitive but the result of critical thinking, gathering information and updating predictions when needed How to separate correlation from causation How to recognize and overcome bias Who is Thomas Bayes and why he matters