CPE Catalog & Events

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

The basic financial statements that nonprofits prepare Best practices for nonprofit reporting Tailoring the financial statements to fit the nonprofit

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

Timely coverage of breaking tax legislation 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 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

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

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

Old and new style of planning The attitude and culture of being nimble Planning at the department level Planning and risk management Technology planning Reinventing the organization for speed

What are AI tools? Where are we with AI tool development? What is ChatGPT? ChatGPT – what kind of queries are possible? Copyright and intellectual property issues Benefits of AI tools Concerns with AI tools Impact on business use of AI Policy on AI tools

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

Self-employment tax issues: what you can and cannot do Capital accounts: book vs. tax issues Determining basis: key issues and technical analysis in calculating basis Dealing with debt: recourse, nonrecourse, and why it matters Guaranteed payments, distributive shares, and draws: understanding the difference