CPE Catalog & Events

How do you pull a value from a cell into another cell? Do you use a direct cell reference, like =G10? If so, you are probably missing out on some efficiency gains that could be achieved by using a variety of Excel's lookup functions. Veteran Excel users, who are aware of the VLOOKUP function, are also painfully aware of its limitations--especially that it cannot go left. We will explore how to bypass VLOOKUP's limitations by nesting functions and by moving beyond VLOOKUP altogether.

How debt is allocated to the partners in a partnership is important. It dictates how much money may be taken tax-free as a distribution, the losses that flow down to the partners, and the gain or loss on the sale of a partnership interest. However, the allocation of debt can differ depending on the type of debt it is and the type of partner we are talking about. Furthermore, 704(c) can complicate things. And what in the world is a constructive liquidation scenario? In this course, we will tackle the concept of debt allocations - how you do it, what it means, and why you do it.

This course offers a comprehensive analysis of the evolving rules surrounding depreciation, amortization, and property transactions, incorporating the latest inflation adjustments and technical corrections. It offers practical guidance through real-world examples and case studies to clarify complex rules and help professionals stay compliant and informed amid ongoing change.

Not-for-profit organizations always need volunteers as treasurers or members of the financial oversight committee! CPAs are often asked to fulfill these roles. This course highlights the financial accounting needs of such organizations. Along with covering the status of the not-for-profit organizations, an update on recent ASC updates affecting nonprofit entities is covered. This course is geared toward hands-on, or future hands-on, treasurers of service clubs and similar not-for-profit organizations.

Statements on Standards for Accounting and Review Services (SSARS) No. 21 was a game-changer for practitioners. Effective for periods ending on or after December 15, 2015, it codified and clarified all prior SSARS guidance into one streamlined standard. It overhauled the framework for engagements and introduced a new non-attest service: the Preparation of Financial Statements. This standard redefined the boundaries between attest and non-attest services, set clear expectations around engagement letters, required procedures and documentation, and updated reporting requirements for each service level—Compilation, Review, and now, Preparation. It also resolved several long-standing practice gaps from earlier SSARS and aligned with evolving client needs and firm workflows. Updates to SAS No. 21 were also included to maintain consistency across standards. For CPAs, SSARS No. 21 isn't just compliance'it's clarity. It's a practical framework that reflects how we work today.

Despite the country's polarized politics and troubled economy, the interest in stock investing remains high as younger investors accumulate for retirement and retirees seek to outpace inflation. We'll explore the most popular stock investment strategies and their taxation, including dividend and capital appreciation strategies, while avoiding the net investment income tax and restrictions on losses and straddles. Companion course: Income Tax Planning For Bond Investments

New to AI" Start here. This beginner-friendly course explains how generative AI works, what terms like "LLM" and "agentic AI" really mean, and how CPAs can safely put these tools to use. You'll leave with a solid understanding of AI fundamentals and how they apply to accounting, tax, and finance.

This quarterly update keeps CPAs current on new topics and issues with LLMs, chatbots, AI research and writing, rules and regulations, and AI agents. The course covers recent changes in the AI field, focusing on applications for CPAs in business and accounting firms. Handouts are designed as takeaways for discussions about AI with clients or in business firms. Join us for all five live updates: 2026 - June, August, & November 2027 - January & March

If you're ready to move past Power BI's fundamentals, participate in this session to learn how to create user-defined calculations, manage security options, publish reports and dashboards to apps, and add Key Performance Indicators, among other items.

In this webinar we will explore the powerful concept of splitting data from reports and dig into the mechanics that enable this technique. The key feature discussed is the Tables feature, and the key function discussed is the multiple-condition summing function. We will illustrate these items in a variety of ways, including building crosstab style reports and mapping tables.

Many of our clients are pass-through entities for which many of the general business strategies are subject to additional limitations. To provide the tax planning strategies for closely held business clients that will bring more revenue, this course focuses on the special concerns and techniques the practitioner needs to thrive in this market.

Part of the technical competence of most experienced accounting and finance professionals is the ability to advise owners of S corporations and partnerships or multiple-member LLCs treated as partnerships regarding the tax rules that apply when these entities liquidate. Entity liquidations do not occur every day; but they do occur, and often at very critical times in the business life of the entity and its owners. All accounting and finance professionals should be able to advise their clients about the tax issues associated with client businesses that go out of existence and liquidate. This program explains the tax consequences associated with liquidating S corporations, partnerships, and multiple-member limited liability companies treated as partnerships.

Stay current on recent changes in accounting and auditing. Review Financial Accounting Standards Board (FASB), U.S. Securities and Exchange Commission (SEC), Private Company Council (PCC), Public Company Accounting Oversight Board (PCAOB) and American Institute of Certified Public Accountants (AICPA) standard-setting activity in the current year. Implementation dates will be provided so you can plan for changes, and the course will highlight the changes that will be implemented in the current year. Also, we'll discuss the difference between public and private company requirements.

This course is a comprehensive overview of critical Federal tax law updates resulting from changes to current laws, regulations and court cases impacting all business entity types, including S corporations, Partnerships, C corporations and Sole Proprietorships. We will also review recent modifications to tax forms, small business tax law and administrative updates, retirement plan changes and tax practice and procedures.

Designed as an all-you-need-to-know update for accounting, auditing, and attestation practitioners at all levels in public accounting and industry, this course provides a comprehensive review of recent standard-setting and rulemaking activities of the Financial Accounting Standards Board (FASB), American Institute of Certified Public Accountants (AICPA), Public Company Accounting Oversight Board (PCAOB), and Securities and Exchange Commission (SEC). On the financial accounting front, we will cover the FASB's Post-Implementation Review (PIR) report released in late 2025 for lease accounting under ASC 842 and discuss the best practices in applying the standard and identifying any ongoing issues practitioners are experiencing with applying the standard. We will also discuss the more than a dozen ASUs the FASB has issued since the beginning of 2024 and into 2026 covering government grants, derivatives and financial instruments, practical expedients for credit losses under ASC 326, and expense disaggregation on the income statement. Our focus on AICPA standards includes a detailed discussion of revamped AICPA quality management standards. The AICPA updated and modernized the standards by issuing Statement on Quality Management Standards 1, 2, and 3 (SQMS 1, SQMS 2, and SQMS 3, respectively), SSARS No. 26, and SAS 146, Quality Management for an Engagement Conducted in Accordance with Generally Accepted Auditing Standards (SAS 146). These standards, now effective as of December 15, 2025, modernize quality management standards to reflect an increased focus on risk assessment, technology use, and the presence of outside experts on engagements. We will also discuss AICPA's proposed SAS, The Auditor's Responsibilities Relating to Fraud in an Audit of Financial Statements, intended to supersede AU-C section 240. We will also cover new rules impacting public company audits and present case studies on recent fraudulent accounting stories and best practices for detecting and preventing such frauds. In summary, the course is your go-to source for all things A&A and will prepare you for your upcoming engagements throughout the rest of the year.

Our financial and economic series is designed to take key topics for financial executives and explore them in detail such that the CFO/controller/financial executive can take away useful and practical recommendations dealing with the topic at hand. The program explores the current economic trends and analyze their impact on you as the financial executive in areas professional skepticism, medical care costs, social security viability, the dollar as a world currency, the national infrastructure and the "fate of the states" as well as the AICPA's top 10 trends and technologies. Specific recommendations and insights will be offered to you to deal with the challenges.

The most recent recession and its fallout, weather (look at 2017), process and product failures, and unethical behavior have again highlighted failures by numerous organizations in identifying and managing risk. The size and reputation of organizations proved not to be the key to success. Again, we saw that failures can result in areas/industries thought to be "under control" through their policies, practices and/or regulations. A core activity of financial management is to effectively protect the assets of their organizations, without significantly reducing new ideas and growth. This brief program provides insights and approaches to identify risk and manage the above noted trade-off. The course is designed for financial managers looking to quickly build upon their existing knowledge and experience, as well as to help to start the less experienced individual. It offers ideas that can be used immediately, as well as longer term approaches. Updated to include new information particularly in the areas of disaster planning, business continuity, and ethics, as well as a sample group exercise to test your current risk management systems.

This course emphasizes the practical application of incident response frameworks through case studies of AI-related cyber incidents. It focuses on preparing financial professionals to effectively manage and learn from cybersecurity crises.

Schedule 1-A is a new tax form designed to consolidate four key OBBBA deductions that can be taken for the first time in 2025. Ultimately these four deductions: the tip deduction, the overtime deduction, the deduction for interest paid on a new car loan, and the senior deduction, appear as a single entry on line 13b of Form 1040. These deductions are phased out at higher income levels, the calculation of which takes place on Schedule 1-A. Accounting and finance professionals who wish to understand the mechanics of the four deductions and how they are expressed on Schedule 1-A and consolidated on Form 1040 would benefit from taking this program.

As experienced staff members master the preparation intricacies of an 1120-S tax return, they are expected to understand and apply the underlying concepts, principles and laws governing S corporation status. This course is designed to illustrate in both theory and practice overarching principles that govern S corporations from formation to revocation, termination and liquidation. Experienced, client-facing staff should be aware of the pitfalls that may inadvertently cause an S-status termination or may generate unintended tax consequences to shareholders.