CPE Catalog & Events

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

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

Becoming qualified as an expert witness Best practices for testifying at trial Understanding the different roles accountants can play in litigation Working with attorneys to prepare and present a case at trial The role of experts in commercial versus personal injury litigation Confidentiality orders Compensation for expert witnesses Preparing for and attending depositions Daubert challenges to experts Expert reports The role of experts in antitrust, securities litigation, and professional liability cases Credibility as a witness

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

The impact of recent legislation Unique planning opportunities and tax traps involved in the liquidation of a business entity Installment sales and the big hurdles to favorable tax treatment in liquidation Form 966 and its importance An analysis of liquidation timing Strategies to pursue in light of the tax rates on dividends and capital gains The special problems of liquidating subchapter S corporations Key planning issues and benefits in liquidating partnerships and limited liability companies Expansion of the carried interest provisions of Rev. Proc. 93-27

Payroll tax requirements for wages, including wages subject to the .9 percent tax, employee benefits and reimbursements, nonqualified deferred compensation, stock options, and tips Fringe benefits issues, such as health insurance, life insurance, cafeteria plan benefits, accountable and non-accountable plans, standard mileage rates, and per diem rates Special issues -- Using a common paymaster, how to file W-2s after a takeover, merger, or acquisition, and state and local tax withholding Statutory employees, independent contractors, and possible changes to §530 relief Penalties -- Who is a responsible person? Expenses and gross-up calculations Pension issues and payroll taxes including SIMPLE plans, and §401(k) and pension distributions The Electronic Federal Tax Payment System (EFTPS) Forms I-9, W-9, W-2, 1099, 1099-NEC, SS-8, and 940 Understanding payroll tax responsibilities in the gig economy

Payroll tax requirements for wages, including wages subject to the .9 percent tax, employee benefits and reimbursements, nonqualified deferred compensation, stock options, and tips Fringe benefits issues, such as health insurance, life insurance, cafeteria plan benefits, accountable and non-accountable plans, standard mileage rates, and per diem rates Special issues -- Using a common paymaster, how to file W-2s after a takeover, merger, or acquisition, and state and local tax withholding Statutory employees, independent contractors, and possible changes to §530 relief Penalties -- Who is a responsible person? Expenses and gross-up calculations Pension issues and payroll taxes including SIMPLE plans, and §401(k) and pension distributions The Electronic Federal Tax Payment System (EFTPS) Forms I-9, W-9, W-2, 1099, 1099-NEC, SS-8, and 940 Understanding payroll tax responsibilities in the gig economy

Comprehensive coverage of The One Big Beautiful Bill Act Guide to legislative changes and their impact on trust planning Introduction to trusts with emphasis on typical provisions Revocable living trusts Common testamentary trust arrangements -- Bypass trusts, QTIP trusts, and other marital trusts Asset protection trusts Sophisticated trusts for estate planning and asset transfer -- GRATs, GRUTs, and QPRTs Charitable trusts -- Charitable remainder trusts, charitable lead trusts, and pooled income funds Irrevocable life insurance trusts Medicaid trusts: special needs and Miller Trusts for minors -- Sections 2503(b) and 2503(c), and other trusts Dynasty trusts Section 461(l) as applied to trusts and estates Trusts to hold S corporation stock Special problems of estates and trusts relating to the 3.8-percent tax on investment income and specific solutions Increased scrutiny of donor advised funds

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

Employees working in multiple states: Withholding issues (when to start and where to withhold) special issues depending on type of tax assessed in the state or locality Emerging sales tax topics: Elimination of the physical presence standard in determining nexus (Wayfair case); economic nexus for remote sellers; assisting remote sellers in determining a plan of action in states that enforce economic nexus Emerging compliance issues in the new sales tax economy Income Tax (and other forms of tax): Economic nexus (taxation without physical presence) Will states shift away from income tax and increase reliance on sales tax after Wayfair? Treatment of Tax Cuts and Jobs Act by the states: presence of intangible property; is P.L. 86-272 still valid? Pass-through problems: Nexus issues for interest owners Treatment of the 199A deduction for pass through entities by states: Withholding issues Practical considerations in dealing with multistate taxation: Dealing with state nexus questionnaires When to consider voluntary compliance: Responsibility of officers, members, partners, and shareholders; planning ideas and opportunities; updates on pending federal legislation relative to state tax

Employees working in multiple states: Withholding issues (when to start and where to withhold) special issues depending on type of tax assessed in the state or locality Emerging sales tax topics: Elimination of the physical presence standard in determining nexus (Wayfair case); economic nexus for remote sellers; assisting remote sellers in determining a plan of action in states that enforce economic nexus Emerging compliance issues in the new sales tax economy Income Tax (and other forms of tax): Economic nexus (taxation without physical presence) Will states shift away from income tax and increase reliance on sales tax after Wayfair? Treatment of Tax Cuts and Jobs Act by the states: presence of intangible property; is P.L. 86-272 still valid? Pass-through problems: Nexus issues for interest owners Treatment of the 199A deduction for pass through entities by states: Withholding issues Practical considerations in dealing with multistate taxation: Dealing with state nexus questionnaires When to consider voluntary compliance: Responsibility of officers, members, partners, and shareholders; planning ideas and opportunities; updates on pending federal legislation relative to state tax

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 implementation of GASB No. 101 on compensated absences GASB No. 103 addressing improvements to the financial reporting model The application of GASB No. 102 on certain risk disclosures and GASB No. 104 on disclosure of certain capital assets

The implementation of GASB No. 101 on compensated absences GASB No. 103 addressing improvements to the financial reporting model The application of GASB No. 102 on certain risk disclosures and GASB No. 104 on disclosure of certain capital assets

Key issues related to not-for-profit financial reporting (e.g., presenting a measure of operations, various disclosures, concentrations of risk, and etc.) Key challenges encountered in not-for-profit accounting (e.g., contributed services, restricted contributions, conditional contributions, membership dues, noncash contributions, and etc.)   Additional issues in not-for-profit financial reporting

Key issues related to not-for-profit financial reporting (e.g., presenting a measure of operations, various disclosures, concentrations of risk, and etc.) Key challenges encountered in not-for-profit accounting (e.g., contributed services, restricted contributions, conditional contributions, membership dues, noncash contributions, and etc.)   Additional issues in not-for-profit financial reporting

The SALT cap The Child and Dependent Care Credit The Child Tax Credit Trump Accounts Tips, overtime, and car loan interest Senior Deduction Estate tax changes 529 plans Investments in students and education Section 199A – QBI deduction Elimination of energy incentives Bonus depreciation and Section 179 changes Changes in the deduction of business interest and business losses R&E expenditures Form 1099 changes Expansion of Section 1202 stock Individual and corporate charitable contribution changes Opportunity Zones Limitation on wagering losses

The $6,000 senior deduction The QBI deduction Changes in the estate tax Wagering losses The SALT cap Tips, overtime, and car loan interest 1099 changes Trump Accounts Investments in students and education Bonus and Section 179 changes, including depreciation for qualified production property Full expensing of domestic research and experimental expenditures Changes in the deduction of business interest and business losses Renewal of Opportunity Zones Individual and corporate charitable contribution changes Expansion of Section 1202 stock Termination of credits for environmentally clean autos and expenditures Many other individual and business income tax changes contained in the OBBBA