CPE Catalog & Events

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

Legislative history American Jobs Creation Act of 2004 and changes to IRC Section 6159 Comprehensive coverage of the three main types of OIC Doubts as to collectability (DATC) Doubts as to liability (DATL) Effective tax administration (ETA) Hybrid of DATC Detailed walk-through of the process and key terms Practical solutions and success rates Various scams

Rental income and expense calculation and reporting Deciphering Schedule E (Form 1040) Nuances of vacation home rules Passive activity loss rules: foundations and implications Active vs. material participation in rental activities Tax reporting: how to group passive activities Limitations on passive losses: at-risk rules and deductions Classifying rental real estate activities Navigating exceptions in rental real estate taxation

Residency status for U.S. federal income tax purposes Key provisions of U.S. income tax treaties Overview of the taxation of income from foreign entities Understanding Foreign Tax Credit Identifying foreign-source and U.S.-source income Foreign earned income and housing exclusion Foreign informational form filing requirements

Substantially increased IRS funding provided by the Inflation Reduction Act IRS test program in 2024 to determine if it should prepare tax returns Using improved data and analytics to tailor timely collections contacts Auditing large corporations and partnerships Audits of high income and high net worth individuals Information Document Requests What happens when a client agrees or disagrees with the IRS's audit findings The Dirty Dozen: roadmap to IRS audit issues

Powerful new functions and features in Excel, such as XLOOKUP and Dynamic Arrays How to use "legacy" features and functions such as AGGREGATE Creating effective forecasts in Excel

When is a person eligible to take Social Security benefits? Factors to consider when selecting an option for taking Social Security benefits Is there a best age to start taking Social Security benefits? How to maximize Social Security benefit payments for surviving spouses How can a divorced spouse collect Social Security benefits based on the work record of a former spouse? How minor children can collect Social Security benefits based on the work record of an older parent

-Review of ethics standards, both extant and proposed, for Arizona CPAs including the AICPA Code of Professional Conduct and the Arizona Accountancy Statutes and Administrative Code. - Review recent updates to the AICPA Code of Professional Conduct and Arizona Accountancy laws. - Provide practical examples of best practices in applying the laws pertaining to Professional Ethics. - Identify the latest ethics guidance to illustrate "hot topics" in professional ethics.

An objective look at retirement plan selection Pros and cons of different plan types Make you an even more valuable resource to your clients

The essential internal control concepts applied in a single audit How the auditor obtains an understanding of controls over compliance and then tests the effectiveness of those controls in a single audit How the auditor plans and performs tests of compliance in a single audit The identification and reporting of control and compliance findings

Proper planning of benefit plan audit engagements and developing audit strategy while improving overall efficiency Common pitfalls in planning and detailed audit procedures Changes affecting 401(k) plans, including SAS 136 implementation Common mistakes as noted in peer reviews and DOL inspections

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 Effects of the CARES and Tax Relief Acts on trusts: 461(l) Excess Business Loss Limitation, NOL, 163(j) modifications, new employer credits Comprehensive DNI case study, with principal (cost and FMV) and income reconciliation Comprehensive trust and estate case studies, with filled-in forms

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 the SECURE Act 2.0 Understanding the environment: what's new, what's expired or expiring and what's likely to change Reading a tax return for developing client-specific tax strategies Will there be more changes in the individual tax laws? Changes to the lifetime estate tax exemption in light of proposed regulations The net investment income tax: planning for compliance Family income-splitting strategies that need to be considered Income tax issues: impact on timing of other income Selling a principal residence Two principal residences at the same time Use of life insurance to protect families Using Roth IRAs and Roth contribution programs to best advantage Conversions: do they still make sense? Taking distributions: matching timing to client requirements Qualified plan contributions to reduce current income and Social Security tax: implications for business owners and self-employed Social Security solvency issues Incentive Stock Options and Employee Stock Purchase Plan considerations What to do about itemized deductions Trans-generational planning: conversions, income and gain-splitting Tax benefits of HSAs and other tax-advantaged accounts Recent case law, as applicable Identifying tax opportunities: reviewing the prior-year return to develop a plan for the future Planning for middle-income taxpayers: financial planning for the young, the working and those approaching or in retirement

Tax rules governing liquidation of a partnership or S corporation Tax treatment of the shareholder/partner/member receiving a liquidating distribution in an S corporation liquidation/partnership liquidation Tax impact on the pass-through entity when the entity is liquidated Receipt of corporate liabilities in an S corporation distribution Proportionate, liquidating partnership distributions to partners and gains and losses to a partner on a liquidating partnership distribution Tax issues associated with a partnership distribution of noncash properties in a liquidation Compliance requirements on the occasion of a liquidation of a corporation or a partnership

Modeling cash flow and capacity Adaptive Capacity Model Segall's Law

Primary and secondary sources of authority Research methodologies Online tax research sources Evaluating and communicating tax research results

Accounting standard updates (ASUs) FASB projects Audit service issues ARSC initiatives, preparation, compilation and review updates and initiatives AICPA activities and profession update

Special and Targeted allocations Proper calculation of outside and inside tax basis Tax consequences of distributions including the impact of "hot assets" Transfer of partnership interests Issuance of partnership interests to service partners