CPE Catalog & Events

Navigating around worksheets Selecting cells and ranges How to use custom number formatting How to leverage Views How to build better formulas with referenced variables and defined names How to quickly format cells with Cell Styles Proper worksheet structure

Overview of setting up spreadsheets for data analysis and how Excel tables can help Learning the importance of consistent column calculations How to use conditional formatting to highlight important information How to leverage Excel tables by analyzing them in PivotTables Learning to leverage array formulas

The steps for creating professional and functional  Best practices for compiling and cleaning data for accurate analysis Applying formulas and functions to calculate meaningful insights Strategies for using formatting tools to create  Data accuracy verification and potential error troubleshooting Methods for distributing reports effectively within your organization

Demonstration in Excel: where to locate the data tools of Power Query and Power Pivot Data skills demonstrated: data preparation and data modeling Demonstrations in Power Query – the Extract Transform and Load tool for data preparation of the Power BI ecosystem, including data sources Power Query can connect to; transformations; load options; operations; and sample of use cases Demonstrations in Power Pivot, the data modeling tool of the Power BI ecosystem, including query organization; custom columns; parameters; and database capabilities

What does value mean? Technical vs. fundamental analysis Intrinsic value Other discounted cash flow models Assumptions in the Gordon Growth Model Valuations using free cash flows Residual income model Enterprise value Value in mergers and acquisitions Small business valuations and discounts Advanced valuation models

Estimated taxes and deadlines Tax due dates for common returns and filings Potential penalties and interest Information return penalties Penalties applicable to pass-through entities Accuracy-related penalties First-time abatement (FTA) FTA eligible returns Reasonable cause Nexus: sales tax vs. income tax Sales tax nexus with state specific examples Remote work and sales tax nexus Income tax nexus with state-specific examples Remote work and income tax nexus Sales factor: throwback rules

Private company standard setting activities FASB Accounting Standards Updates (ASUs) relevant to smaller businesses Lease accounting implementation guidance ASC 326, Credit Losses Accounting for income taxes Accounting for debt instruments

Recently issued FASB Accounting Standards Updates Implementation issues related to ASC Topic 842, Leases

Relevant updates from One Big Beautiful Bill (OBBBA) legislation incorporated throughout Classifying receipts between “income” and “corpus” under the Uniform Principal and Income Act Calculation of DNI utilizing three different methods, a “forms” method (Schedule B), a “code” method, and a “shortcut” method, utilizing a worksheet of common income and expenses Proper W-2 preparation and procedures in the year of death Taxpayer passes before taking a required minimum distribution; what must be done?  Forgetful fiduciaries of simple trusts Fluctuating trusts – Simple one year, complex the next Dividing income in the year of death Overview of Subchapter J Form preparation issues – Filing requirements and line-by-line explanations of Form 1041 Taxable income of estates and trusts and expense allocation issues Specific deductions and miscellaneous itemized deductions Income in respect of a decedent The income distribution deduction calculation Relation of principal and income law to DNI Understanding how to handle capital gains and losses Allocating tax items to beneficiaries: another K-1 Other considerations: excess deductions on termination Comprehensive DNI case study, with principal (cost and FMV) and income reconciliation Comprehensive trust and estate case studies, with filled-in forms

Recent standard setting and consulting activities at the FASB Proposed updates to income tax accounting and financial statement disclosures Tax basis financial statements Recently issued Statements on Auditing Standards and other audit-related hot topics

Recent standard setting and consulting activities at the FASB Proposed updates to income tax accounting and financial statement disclosures Tax basis financial statements Recently issued Statements on Auditing Standards and other audit-related hot topics

Financial statement disclosures for small and medium-sized businesses Balance sheet, income statement, and statement of cash flows presentation and disclosure issues Disclosure examples from all sized entities which you can use to base your disclosures on Developing disclosure issues, including disclosures related to the adoption of Topic 606

Common Excel errors, including formula errors, reference errors, and logic errors Advanced Excel functions and formulas that are crucial for error detection and data analysis Data validation techniques, including setting up data validation rules and using conditional formatting to highlight potential inaccuracies Error tracing and auditing tools, including Trace Precedents, Trace Dependents, and the Error Checking tool

AICPA’s Enhancing Audit Quality initiative Recent revisions to Quality Management standards Feedback from peer reviews, including areas driving deficiencies in audit Elements of an effective risk assessment and how to link to audit procedures performed Understanding internal controls and making the decision whether or not to test them Issues related to compilations and reviews Issues related to employee benefit plans Issues related to Government Auditing Standards/Single Audits Best practices in documentation

The 50% deduction for meals that are ordinary and necessary in carrying on a trade or business Elimination of the temporary rules that applied for 2021 and 2022 which allowed for 100% deductibility for ordinary and necessary business-related meals When meals are still 100% deductible IRS rules relating to the nondeducibility of activities considered entertainment or amusement What constitutes entertainment/amusement for tax purposes? When employers may deduct food and beverages provided to employees 50% deductibility for occasional employee meals and for overtime meals 50% deductibility for business meals during business meetings Business meals incurred during business travel Invoice meals separately from entertainment

Key provisions of the recent HR 1, One Big Beautiful Bill Act, have been incorpoated throughout the course Review an error-prone "staff-prepared" Form 1040 from client-provided information. Where do you start? Get to know your client and ask the questions Several new reporting issues for the reviewer to consider, including the main credit provisions as enacted under the American Rescue Plan What are common errors preparers make and what are the areas generating malpractice claims? The importance of engagement letters, questionnaires, and §7216 permission statement Initial administrative groundwork Identifying organizing issues in the tax return to be reviewed Avoiding “willful blindness.” Handling ethical and moral dilemmas Efficient review of certain advanced issues for income, adjustments, deductions, and credits Effective procedures for delinquent clients, filing past-due tax returns First-time client issues requiring extra scrutiny Multiple checklists of efficient procedures to identify potential issues on a 1040 return Listing of schedules for staff to prepare to make a review easier, including basis issues for 1040 clients Reconciling time pressure with thoroughness and quality control Professionals acting professionally

Comprehensive coverage of HR 1, One Big Beautiful Bill Act  Gain a thorough understanding of federal income tax laws for partnerships and LLCs, from formation to tax return preparation issues  Filing requirements for Schedules K-2 and K-3  Who files Form 1065, and who does not file Form 1065  Tax Basis Capital Account Reporting Requirements  Trade or Business income and expenses versus Separately Stated Items  The importance of Schedule M-1  Partnership distributions -- current or liquidating, cash or property  How to allocate recourse and nonrecourse debt  Self-employment tax issues; court cases and trends in tax audits of earnings subject to self-employment taxes Complete coverage of any new legislation enacted before presentation  Section 163(j) limitations  Mastering two common tax forms, Depreciation (4562) and Sale of Assets (4797)  Final regulations on Section 168(k)  Partnership reporting oddities  Accurately preparing partnership returns and reconciling book income to taxable income  The Centralized Audit Regime under the Bipartisan Budget Act of 2015   

Reviews of portions of error-prone “staff-prepared” Forms 1120-S and 1065 from client-provided information What are common errors preparers make and what are the areas generating malpractice claims? Initial administrative groundwork The importance of Schedule M-1. Learn how various schedules are related and learn how to self-review Reporting requirements and filing exceptions for Schedules K-2 and K-3 Don’t fall prey to reporting oddities When can seemingly separately stated Schedule K items actually be trade or business items to report on Forms 1120-S or 1065? Form 1120-S – What exactly is terminating S elections today? How do I recognize a second class of stock? Maintaining shareholder basis schedules; beware of final IRS regulations regarding “open debt”; the default method of calculating basis versus the election under §1367; can an S corporation distribute earnings and profits from C corporation years? Form 1065 – New tax reporting requirement for partners’ capital balances Why use §704(b) to maintain capital accounts; §704(c) regulations for preventing the shifting of tax consequences among partners or members; allocating recourse, nonrecourse, and qualified nonrecourse debt; a review of §754 step-up in basis rules Multiple checklists of efficient procedures to identify potential issues on an 1120-S or 1065 tax return Major provisions of HR 1, One Big Beautiful Bill Act (OBBBA), relevant to course material have been included throughout

Tax treatment of partnership distributions to partners of cash and property other than cash Basis of property received in a partnership distribution Executive Order 14219 withdrawing the IRS’s new regulations regarding basis shifting Organization and structure of the new Form 7217 Who must file Form 7203 Determining the S corporation shareholder’s initial basis in his or her stock Basis limitations on partnership losses and deductions Organization and structure of Form 7203 — understanding the three parts of Form 7203 Filing criteria for Form 7203 Calculating an S corporation shareholder’s share of S corporation deductions and credits Understanding stock and debt basis

Financial professionals’ roles in cybersecurity risk management Foundational terminology and principles (e.g., risk management, threat actors) Real-world case studies of cybersecurity strategies in financial settings Integrating cybersecurity into financial reporting and compliance Understanding the dynamic cybersecurity threat environment