CPE Catalog & Events

Understanding what the metaverse is and what it is not How to access the metaverse Why accounting and other professionals should use the metaverse Where accountants can find their space in the metaverse How the metaverse is changing the way we work Ownership opportunities in the metaverse Work and taxation in the metaverse

Reporting requirements for Schedules K-2 and K-3 Capital account reporting requirements Schedule K-1 reporting for §743 adjustments Schedule K-1 reporting for §704 gains and losses Comprehensive case on partnership/partner application of the business interest deduction When to use “704(b) basis” for capital accounts versus “tax basis” Detailed rules of §704 for preventing the shifting of tax consequences among partners or members Unreasonable uses of the traditional & curative allocation methods Multiple layers of §704(c) allocations Treatment of recourse versus nonrecourse debt basis How to calculate basis limitations and its implication on each partner’s own tax return How §179 limitations affect partnership/LLC basis Regulations for handling basis step-ups under §754 elections, and mandatory adjustments under §743 and §734 for partnerships who have NOT made the §754 election Subsequent contributions of property with §754 adjusted basis to another partnership or corporation Capital account adjustments in connection with admission of new member Special allocations require "substantial economic effect"; what are the requirements? LLCs and self-employment tax to the members Distributions -- current or liquidating, cash or property including the substituted basis rule Termination/liquidation of an LLC

Reporting requirements for Schedules K-2 and K-3 Capital account reporting requirements Schedule K-1 reporting for §743 adjustments Schedule K-1 reporting for §704 gains and losses Comprehensive case on partnership/partner application of the business interest deduction When to use “704(b) basis” for capital accounts versus “tax basis” Detailed rules of §704 for preventing the shifting of tax consequences among partners or members Unreasonable uses of the traditional & curative allocation methods Multiple layers of §704(c) allocations Treatment of recourse versus nonrecourse debt basis How to calculate basis limitations and its implication on each partner’s own tax return How §179 limitations affect partnership/LLC basis Regulations for handling basis step-ups under §754 elections, and mandatory adjustments under §743 and §734 for partnerships who have NOT made the §754 election Subsequent contributions of property with §754 adjusted basis to another partnership or corporation Capital account adjustments in connection with admission of new member Special allocations require "substantial economic effect"; what are the requirements? LLCs and self-employment tax to the members Distributions -- current or liquidating, cash or property including the substituted basis rule Termination/liquidation of an LLC

Principles and concepts which form the foundation of ethical behavior The core principles of professional conduct -- integrity, objectivity, and independence The AICPA Code of Professional Conduct, including new interpretations and proposed changes Pennsylvania professional standards and responsibilities for the practice of public accounting

Structure of the ASC codification Content included and not included in the ASC Other information contained in the codification Best practices for performing effective and efficient accounting research

Inventory observation procedures When attendance at the inventory observation is impractical Inventory under the control of a third party Consideration of the risk of fraud in inventory counts Sampling related to inventory observations Considerations related to retail inventories, multiple locations Considerations for inventory observations

Relevant sections of SSARS No. 21, Clarification and Recodification Updates to SSARS No. 21 guidance due to issuance of SSARS Nos. 22-25 Review of AR-C Section 60 requirements for all SSARS engagements Detailed guidance on performing preparation engagements under AR-C Section 70

Differences between planning and budgeting Building change into the planning process The business model Strategic plan Marketing plan Financial forecasting Financial risk analysis Five-year operating plan

Demonstration in Power BI Desktop of the following data tools: Power Query, Power Pivot, and Power View Skills demonstrated: DAX, data visualizations including AI visuals, and data storytelling Demonstration of DAX function types: Aggregation, Iterator, CALCULATE, CALCULATE Modifiers, Time Intelligence, Ranking, and Percentages Demonstration of how to curate a visual in PBI Desktop with a variety of formatting tools; visuals for exploratory analysis; and AI visuals for exploratory analysis

Create a new column from existing columns Adding columns is determined by the data type of the column Adding new columns Hands-on examples: column from examples, merging columns, duplicate columns, custom columns, conditional column, index column

What is an append query? What are the data requirements for an append query? Hands-on examples: combining worksheets in the same workbook, listing all objects in a workbook, combining files in a folder

What is Power Query? Why should I learn Power Query? What are the benefits of using Power Query? Power Query is not just for Excel Power Query versions are not the same What version of Power Query do I have? How to get Power Query Making your first connection in Power Query Hands-on examples: connection query, editing a query, duplicating a query

Workflow of making a connection Get data Navigator dialog box Query options Global and current workbook Data load options Queries and connections Data source settings Hands-on examples: importing files and databases

Relevant sections of SSARS No. 21, Clarification and Recodification SSARS No. 21, Clarification and Recodification, and updates to SSARS No. 21 due to the issuance of SSARS No. 23, Omnibus Statement on Standards for Accounting and Review Services SSARS No. 22, Compilation of Pro Forma Financial Information SSARS No. 24, Omnibus Statement on Standards for Accounting and Review Services – 2018 SSARS No. 26, Quality Management for an Engagement Conducted in Accordance With Statements on Standards for Accounting and Review Services Proposed changes to the SSARS guidance Comprehensive sample engagement work programs for preparation and compilation engagements Prescribed form, specified line item, pro forma, and other engagement variations Complete illustrations of relevant engagement letters, reporting and other required communications for preparation and compilation engagements

Relevant sections of SSARS No. 21, Clarification and Recodification SSARS No. 21, Clarification and Recodification, and updates to SSARS No. 21 due to the issuance of SSARS No. 23, Omnibus Statement on Standards for Accounting and Review Services SSARS No. 22, Compilation of Pro Forma Financial Information SSARS No. 24, Omnibus Statement on Standards for Accounting and Review Services – 2018 SSARS No. 26, Quality Management for an Engagement Conducted in Accordance With Statements on Standards for Accounting and Review Services Proposed changes to the SSARS guidance Comprehensive sample engagement work programs for preparation and compilation engagements Prescribed form, specified line item, pro forma, and other engagement variations Complete illustrations of relevant engagement letters, reporting and other required communications for preparation and compilation engagements

Preparation by hand of a reasonably complicated Form 1120 U.S. corporate income tax return from trial balance to completed return The importance of Schedule M-1, including many adjustments in reconciling book income to tax income, and items preparation staff may look for on all business returns. Learn to self-review New tax-planning strategies for depreciation deductions, including changes to §179 and first-year depreciation (Section 168(k)) as a result of recent tax legislation Methods of accounting -- Application and choices In-depth analysis of Form 4797 dealing with depreciation recapture Deductible expenses -- including rules on meals and entertainment Section 163(j) Computation of tax liability Overview of many common business deductions; which are deductible and which are M-1 items? How to practically handle uniform capitalization and inventory accounting for a small manufacturing concern And much more

Preparation by hand of a reasonably complicated Form 1120 U.S. corporate income tax return from trial balance to completed return The importance of Schedule M-1, including many adjustments in reconciling book income to tax income, and items preparation staff may look for on all business returns. Learn to self-review New tax-planning strategies for depreciation deductions, including changes to §179 and first-year depreciation (Section 168(k)) as a result of recent tax legislation Methods of accounting -- Application and choices In-depth analysis of Form 4797 dealing with depreciation recapture Deductible expenses -- including rules on meals and entertainment Section 163(j) Computation of tax liability Overview of many common business deductions; which are deductible and which are M-1 items? How to practically handle uniform capitalization and inventory accounting for a small manufacturing concern And much more

New and expanded energy credits under the Inflation Reduction Act (IRA) Preparation of various Form 1040 individual tax returns and schedules; provided answers include “filled-in” forms  Coverage of Form 7203  Coverage of §199A qualified business income, its calculation, limitations, and examples  Dividends and interest – Ordinary, return of capital, and capital gain distribution dividends; tax-exempt interest, original issue discount, etc.  Security transactions – From Form 1099-B to Form 8949 to Schedule D, plus mutual fund sales and related basis issues  Self-employed person issues  Schedule C deductions including depreciation  Sale and exchange of property – Understanding Form 4797 and depreciation recapture; capital gains  A working understanding of passive losses – How to handle rental property and how the passive loss rules flow to the tax forms  Itemized deductions – A thorough understanding of what’s deductible and what’s not  Interest deductions – Limitations and timing problems  Charitable contributions substituting for taxes, IRS says – No!  Retirement contributions and education credits and deductions  Tax computations – The Kiddie Tax, AMT, regular tax, tax credits  Individual problems illustrated by form preparation for various items, with numerous “practice tips”  Impact of recent legislation and forms changes on the 1040 

New and expanded energy credits under the Inflation Reduction Act (IRA) Preparation of various Form 1040 individual tax returns and schedules; provided answers include “filled-in” forms  Coverage of Form 7203  Coverage of §199A qualified business income, its calculation, limitations, and examples  Dividends and interest – Ordinary, return of capital, and capital gain distribution dividends; tax-exempt interest, original issue discount, etc.  Security transactions – From Form 1099-B to Form 8949 to Schedule D, plus mutual fund sales and related basis issues  Self-employed person issues  Schedule C deductions including depreciation  Sale and exchange of property – Understanding Form 4797 and depreciation recapture; capital gains  A working understanding of passive losses – How to handle rental property and how the passive loss rules flow to the tax forms  Itemized deductions – A thorough understanding of what’s deductible and what’s not  Interest deductions – Limitations and timing problems  Charitable contributions substituting for taxes, IRS says – No!  Retirement contributions and education credits and deductions  Tax computations – The Kiddie Tax, AMT, regular tax, tax credits  Individual problems illustrated by form preparation for various items, with numerous “practice tips”  Impact of recent legislation and forms changes on the 1040 

The key requirements, options, and disclosures related to each of the basic financial statements How the reporting of functional and natural expense information has changed The new requirements related to providing liquidity and availability of financial assets information The implementation of ASU No. 2018-08 and its effect on the accounting for grants and contracts as well as contributions in general How the new lease requirements (ASU No. 2016-02, Leases) impact not-for-profits Core not-for-profit accounting requirements related to contributions, promises to give, contributed services, net assets, special events, the classification of expenses, and more