CPE Catalog & Events

Application of ASC 606 to contractual situations Identifying key information necessary to apply ASC 606 Assessing compliance with the guidance of ASC 606

Optimal resource requests to support an appropriate search for unrecorded liabilities Tracing transactions to the detail to identify whether liabilities are properly recorded Evaluation of evidence to meet management’s assertions

Observation and professional skepticism Interviewing the client Performing test counts Evaluating the results obtained

Differentiating array formulas from regular Excel formulas and explaining their significance Practical application of array formulas: how to effectively implement and utilize these formulas in a variety of common Excel tasks and scenarios Utilization of dynamic arrays and spill functions, highlighting their role in modern Excel data handling Complex functions such as SUMPRODUCT, UNIQUE, SORT, and FILTER, focusing on multi-condition summing and data management How to simplify the use of static values called array constants

How does the IRC define an installment sale under IRC Sec 453? When can a taxpayer utilize the provisions of IRC Sec 453? When should a taxpayer utilize the provisions of an installment sale and when should it be avoided? How does the issue of a “dealer” vs. a “non-dealer” impact the use of the installment sale method? Reporting an installment sale when related parties are involved Calculating an installment sale How has the Tax Cuts and Jobs Act impacted the use of the installment sale method?

How to calculate a partner or S corporation shareholder’s basis Form 7203 and an S corporation shareholder’s basis The at risk basis rules and Form 6198 The passive activity loss limits The Section 461(l) loss rule The net operating loss limitation rules The Section 163(j) business interest limitation

Nonqualified deferred compensation (NQDC) Nonqualified stock options (NQSOs) Incentive stock options (ISOs) Restricted stock/restricted stock units (RSUs) Stock appreciation rights (SARs) and phantom stock Employee stock purchase plans (ESPPs) Applicable tax forms and schedules Stock sale reporting Estimated taxes Filing deadlines and extensions State taxation

Tax code hierarchy Organization of an Internal Revenue Code section Special rules for IRC citation  Citing other primary authority Private letter rulings  Primary vs. secondary authority  Secondary sources of authority Steps in the tax research process Research memoranda

Types of partnership distributions Liquidating partnership distributions Basis of property distributed by a partnership Special basis adjustments under Section 732(d) Abandoned and worthless partnership interests Section 751(a) exchange Transactions between partners and their partnerships Disguised sales Section 736(a) and (b) payments

Data-driven decision making processes Top technology trends and related risks, including cloud computing, AI, RPA, and blockchain applications Common IT security risks and controls Requirements of SAS 142 Use of analytical procedures on professional engagements

Refresher on understanding internal controls When testing internal controls is required When testing of internal controls is an effective strategy to reduce substantive testing Designing tests of controls Responses when deviations are discovered in the design or operating effectiveness of internal control

Using Excel tables for efficient data management, including sorting, filtering, and structured references, to manage  data more effectively Using custom sorting options to organize data in a way that best suits your needs, enhancing data readability and analysis Using XLOOKUP for advanced data retrieval, allowing you to extract specific data from extensive datasets with ease Using the SUBTOTAL function, a versatile tool for calculating data in visible cells, ideal for analyses that require dynamic calculations Using SUMIF and SUMIFS functions for conditional summing, crucial for precise budgeting, expense tracking, and financial reporting Using array formulas to perform multiple calculations on one or more items in an array, enhancing the efficiency of complex accounting computations Implementing data validations to ensure data integrity and prevent errors in financial data entry, a critical skill for maintaining accurate accounting records Using slicers for interactive data segmentation in tables and PivotTables, enabling accountants to quickly filter and analyze specific subsets of financial data Applying conditional formatting to highlight critical financial data points, trends, and variances, making data analysis and interpretation more intuitive Introducing PivotTables, one of the most powerful Excel features, for summarizing, analyzing, and presenting large sets of financial data in a digestible format

Establishing a system: identifying forces that support the status quo; setting milestones and goals; the role of the CMA Necessary first steps: set a framework for the project’s activities; identify needed resources; obtain support; decide on a structure; establish a team for a specific project; identify necessary team skill sets Project evaluation: analytical tools, strategic evaluation; sources of risk Maintaining focus: monitoring and measuring results; keeping to the project’s scope Avoiding frequent traps: sunk costs; financing pitfalls; project creep; tunnel vision; failure to integrate the team’s work internally and/or the final project with the remaining organization Introduction and examples of analytical tools throughout the session: mapping; CPM; Gantt charts; benchmarking; Pareto analysis; PESTLE analysis; valuation techniques; post-completion evaluations

Comparison with other SEC filings Overview of the Securities Exchange Act of 1934 Purpose and importance of MD&A Risk factors, controls, and corporate governance disclosures

Overview of the latest updates in Excel, focusing on their purpose and potential impact on efficiency and productivity New automation tools, including features that streamline repetitive tasks and data analysis Fuzzy matching of textual data in Microsoft Excel Features that help to efficiently use data

The 2024 implementation of GASB No. 100 on accounting changes and error corrections The end of 2024 application of GASB No. 101 addressing compensated absences Additional recently issued GASB standards and projects

Lessons learned (and lessons remaining) for the implementation of FASB ASC 842, Leases, and the new requirements related to contributions of nonfinancial assets in ASU No. 2020-07 Solving contribution conundrums (e.g., conditional contributions, restricted contributions, contributed services, etc.) Additional issues in not-for-profit financial reporting

Understanding whistle-blowing When should you blow the whistle? Types of whistle-blower channels The whistle-blower's dilemma Successful whistle-blower letters When is whistle-blowing unethical? Laws to protect whistle-blowers Ten whistle-blowing myths

Timely coverage of breaking tax legislation, including the SECURE 2.0 Act and Inflation Reduction Act provisions applicable to individuals Changes to the lifetime estate tax exemption by the TCJA in light of April 2022 proposed regulations Considerations when selling a principal residence Tax benefits of HSAs An overview of the mechanics and practical considerations of Donor Advised Funds Virtual currency and digital assets The Corporate Transparency Act and FinCEN Beneficial Ownership Information reporting An update on income tax and estate-planning ideas, including any recent changes Tax ideas for the current year Miscellaneous tax-planning techniques that can add up to significant tax savings How to use the whole family for tax savings Up-to-the-minute ideas reflecting new tax law changes in cases, regulations, and rulings

Managing interruptions The role of activity logs, to-do lists and a priority matrix The psychology of time management Staying on track of your time management plan Controlling procrastination Blocking out time Creating an effective time management plan