CPE Catalog & Events

Overview of small business accounting solutions Strengths and shortfalls of various accounting and add-on solutions

Five business books, including,    “Leaders Eat Last”, by Simon Sinek,   “Zero to One” by Peter Thiel,   “American Icon” by Bryce Hoffman,   “Slide:ology” by Nancy Duarte, and   “Brain Rules” by John Molina.

How to build a flexible budget model that works? What are the steps we can take to budget for economic and external factors beyond our control? How the right Chart of Accounts can simply your work? Budget and GAAP are not the same and why they are fine not to be Efficiently modeling payroll and benefits Identifying controllable and uncontrollable expense Using key variables to stress-test your budget

The major topics covered in this course include:ChatGPT and generative AI technology primerBuilding your generative AI vocabularyDig deeper into your engagement research to develop a higher quality advisory servicePolish your client reporting with the help of ChatGPTDeveloping your ChatGPT client advisory servicesStart with client education. You don’t need to be a technical expert to be an educatorUse AI to help your clients automate their workflows / business processesBuild better spreadsheets with ChatGPT and ExcelHelp your clients identify, evaluate and select applications for their business

“Tax-mageddon” – the all-important impending expiration/extension/renewal of the TCJA  Other recent legislative, judicial, and IRS developments impacting business taxpayers. Current status of Research and Experimentation costs and Interest Expense Limitation Phaseout of Bonus Depreciation and MACRS issues. Partnership and S corporation legislative updates

Coverage of applicable rules from SECURE Act 2.0 The 10% penalty Net unrealized appreciation of employer securities Roth IRA conversions Rollovers and the limitations Direct rollovers vs indirect rollovers, and tax withholding  Beneficiary portability rules When a Roth IRA distribution is qualified to be tax-free Excess contributions and the 6% excise tax

Automatic enrollment requirements for 401(k) plans Change in the credit for small employer pension plan startup costs $2,000 saver’s match Changes in pooled employer plans Multiple employer 403(b) plans Increase in age for required beginning date for mandatory distributions Indexing IRA catch-up limit Higher catch-up limit to apply at age 60, 61, 62, and 63 Treatment of student loan payments as elective deferrals for purposes of matching contributions Application of credit for small employer pension startup costs to employers who join an existing plan Small immediate financial incentives for contributing to a plan Withdrawals for certain emergency expenses Starter 401(k) plans for employers with no retirement plans Improving coverage for part-time workers Recovery of retirement plan overpayments Tax treatment of IRAs involved in a prohibited transaction Clarification of substantially equal periodic payment rule

Types of business entities (Sole proprietorship, Partnership, Corporation, Limited Liability Company and Limited Liability Partnership) Considerations in choosing a business entity, including taxes, limited liability protection, management & control, funding options & opportunities, tax consequences for the owners and the business. Future tax considerations that will impact various business entities.

Principles of Visual Design for Dashboards and Reports Chart Design for Rapid Understanding Table Design for Efficiency Effective Use of Commentary Strategic Layout Techniques Trend Analysis Methods Developing Organizational Design Standards Excel Application Techniques Critical Review Skills Best Practices for Data Presentation

Key fraud risks impacting businesses today Examples of fraud and the monetary impact on victims How to create, implement, and assess technology-based internal controls to reduce the probability of becoming a fraud victim

U.S.  GAAP and Special purpose frameworks Form and content of financial statements: Balance sheets Income statements; Statements of cash flows Retained earnings and/or owners’ equity statements Comprehensive income Supplementary information Comparative vs. single-period financial statements Sufficiency of disclosures Illustrative disclosures frequently encountered in small-to-medium reporting entities Industry-specific nuances

The major topics that will be covered in this course include:Key changes made by the 2024 Revision to Government Auditing StandardsReview when the GAGAS requirements are applicable to a financial statement auditWhen reporting on key audit matters may apply in a GAGAS auditClarifications related to the independence requirements in a financial statement audit imposed by the 2024 Yellow BookReview the impact of the Quality Management Standards to a financial statement audit conducted under the 2024 Revision to Government Auditing StandardsOther important matters contained in the 2024 Government Auditing Standards related to financial statement audits

Accounting Standards Updates Auditing & Accounting Yellowbook

Extensive review of the partnership income tax laws with an emphasis on any new legislative changes Comparison of partnerships, LLCs and LLPs Overview the formation of a partnership/LLC and the §704(c) pre-contribution gain or loss rules Schedule K analysis– determine if income statement items are separately (i.e. schedule K) or non-separately stated income and expense items How schedule K items get allocated to partners on schedule K-1s Look at detailed Schedule K-1 information reporting to partners needed for the qualified business income (QBI) deduction, 3.8% net investment income tax and business interest expense limitations Learn the special tax treatment of fringe benefits paid on behalf of the partners and LLC members Comparing the tax and §704(b) book capital account computations Discuss partner guaranteed payments and self-employment tax issues Schedule M-1 – reconciliation of income or loss per books with income or loss per income tax return Schedule M-2 – analysis of partners’ capital accounts Review the importance and basics of calculating a partner/member’s outside tax basis. Overview of the tax treatment of distributions, recourse and nonrecourse debt allocations, §754 election for optional basis adjustments and §743/§734 mandatory basis adjustments

Risk assessment Internal controls Forensic accounting Reporting mechanisms

Subchapter S status election and compliance requirements Relief for late Form 2553 filings under Rev. Proc. 2022-19 Comparison of Rev. Proc. 2022-19 and Rev. Proc. 2023-3 I.R.C. §1361 and §1362 analysis for S Corporation elections Corporate governance and formalities compliance Shareholder stock and debt basis rules Built-in capital gains and other aspects of Form 1120S Schedules K-1, K-2, and K-3 preparation and reporting requirements Officer reasonable compensation: requirements, advisory strategies, and audit defenses S Corporation eligibility errors and corrective measures

Recently issued FASB Accounting Standards Updates, PCC Update and items on the FASB’s Technical Agenda Leases – Topic 842 Recently issued ASUs covering common control leases, crypto assets (e.g., cryptocurrency), and income tax disclosures ASC 326: CECL Review of SAS 142 – Focus on Audit Evidence Recently issued SASs and other AICPA activity SSARS No. 25 and other recently issued SSARS Detailed review of SAS 145 Other important A&A practice matters

Implications for individuals: Changes to the Saver’s Credit Changing the required minimum distribution rules for Roth 401(k)s Changes to required beginning dates for required minimum distributions of retirement plans. Penalty-Free Withdrawals for Certain Emergency Expenses Special provisions for firefighters and military personnel spouses Increases in catch-up contributions Impact on 529 plans Opportunities for student loan payment matching

The major topics that will be covered in this class include:A review of the various lookup functions, beyond VLOOKUPLearn which lookup works best for your situationHow to apply the many lookup functionsDiscover advanced lookup techniques like nested lookups, approximate matching, and handling errors effectivelyAn in-depth review of the following functions:VLOOKUP / HLOOKUPXLOOKUPMATCH / INDEXXMATCHINDIRECTFILTERSORT / SORTBYUNIQUEAn overview of some newer functions

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