CPE Catalog & Events

Using lookup functions as an alternative to direct cell references Understand the limitations of the VLOOKUP function Discover ways to move beyond these limitations

The evolving landscape of client expectations in the accounting profession Building strong and lasting client relationships through effective communication, empathy and proactive service Implementing efficient client onboarding and engagement processes Leveraging technology to streamline communication, enhance collaboration and deliver personalized service Effectively resolving client concerns and complaints Utilizing client feedback to continually improve your practice

Corporate structure entity choice comparisons Form 1120 and Schedule M-1 or M-3 Items for book-tax differences Tax accounting methods Uniform capitalization rules, overview

FASB ASC 842, Leases All recently released updates to ASC 842, Leases

Application of professional judgment Codification, GAAP and the GAAP hierarchy Recent changes in financial statement presentation Hot Topics in financial reporting & accounting

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

Nonverbal communication-Virtual

Rethinking Risk Management: Historic view Challenges Rules Recent lessons Required skills Sources of Risk: Economy Competitors Operations Investments Strategy Compensation Routine practices Unethical behavior. Enterprise Risk Management (ERM): Defining ERM Areas of focus Implementation Planning for disasters Business continuity Contingencies Analytical Tools: Post-completion evaluations Simulation Z-score Hedging Brainstorming Mind mapping Delphi technique

Explore PivotTable capabilities and functionality Retrieve data from a database and feed it into the PivotTable Pull web tables from web pages into Excel

Applicable provisions of SECURE Act 2.0 Key features for choosing a retirement plan for a small business Key questions an advisor must ask a small business owner to help determine which retirement plan is suitable for their business Key questions an advisor must ask a small business owner to help ensure compliance with a SEP IRA or a SIMPLE IRA How SEP and SIMPLE IRAs benefit the small business owner How SEP and SIMPLE IRAs benefit employees of small businesses The tax benefits that help to offset the cost of employer contributions How to determine which business is eligible to adopt a SIMPLE IRA How to determine which employees must be covered

Employment at - this means in a practical sense Implied employment contracts What a prospective employer can ask about and test for, during employment interviews Federal anti-discrimination rules applicable to hiring and firing How to fire an employee and not get sued Hiring and firing during a pandemic

Changes to the IRS Form 706 How to successfully navigate the form The ins and outs of the "portability" rules, including how the rules actually work using common examples Income tax consequences How to avoid malpractice traps Overlooked GST issues

Understanding the best types of visualizations to use in specific situations Creating compelling visualizations using Excel Adding interactivity to your Excel-based visualizations

Timely coverage of breaking tax legislation A tour of the most recent changes starting from gross income and ending with alternative minimum tax (AMT) and selected credits including the latest IRS guidance on recent tax legislation Hot, hidden, or miscellaneous developments affecting the upcoming tax season Review of new laws and changes in old forms to provide a familiarity for the upcoming tax season Key new tax and practice developments and how they impact the current-year tax forms for individuals

Statutory employees, independent contractors and possible changes to 530 relief Using SS-8 Payroll Tax Penalties -- Who is a responsible person? Forms W-2, 1099, 1099-NEC, SS-8, W-4, 941 and Form 940 reporting/deposit requirements and due dates Understanding payroll tax responsibilities in the gig economy

Leadership Development

Constructing and delivering effective presentations Identifying target audiences Common communication problems Nonverbal communication

Financial planning pyramid What to consider when picking an entity Single member LLC vs. sole proprietorship Corporations - S vs. C Double taxation

Overview of ASC 326, Credit Losses Application of ASC 326 to non-lending institutions CECL transition and disclosures Audit considerations related to the adoption and ongoing accounting for CECL

Refining key planning and general auditing considerations to the not-for-profit environment Characteristics of not-for-profit financial statements that require special attention The auditor's consideration of fraud in auditing a not-for-profit entity Audit procedures to become comfortable with management's recording and reporting of contributions and promises to give Auditing how a not-for-profit entity gets from natural expenses to functional expenses Auditing considerations and techniques related to net assets, compliance with tax laws and regulations, collections and split-interest agreements Considerations related to Yellow Book and single audits