CPE Catalog & Events

Budget methods are the key to allowing department managers to efficiently prepare their budget in Excel. For example, a budget method may be to spread prior year actuals or match prior year actuals, or match prior year actuals less 10%. In this webinar, we will explore how to allow users to pick a budget method from a drop-down list for each account and then have Excel perform different calculations depending on the budget method selected. We use several features and functions at the same time to pull this off. Even if you are not involved in the budgeting process, the underlying features and functions discussed have a wide range of uses.

This advanced course examines the federal tax consequences of business dissolutions, ownership changes, and related restructuring transactions involving partnerships, S corporations, and closely held businesses. Using a cradle-to-grave framework, the program addresses planning, execution, valuation, reporting, and post-transaction compliance issues arising in sales, redemptions, liquidations, divorces, deaths, and internal restructurings. Participants will analyze inside and outside basis, debt basis, Section 754 adjustments, Section 302 redemption tests, Section 1041 transfers, F reorganizations, Section 751 hot assets, and the treatment of goodwill and other Section 197 intangibles. The course also incorporates practical guidance on NIIT, potential Section 1202 considerations, final-year return procedures, and selected state tax issues that commonly affect business exits and ownership transitions. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Artificial Intelligence (AI) is mainstream, and most people have a basic understanding of it, but few know the depth and breadth of its capabilities. AI is making an impact in just about everything in business and our lives. The operation of an internal control system is also changing because of this incredible advancement. This course explains what AI is and how it works and goes into detail about how it can be applied to an internal control system. This course explores changes occurring in today's world as well as what's coming.

Clients concerned about market volatility often prefer more conservative fixed-income investment strategies. There are many choices to consider: taxable or tax-exempt bonds; Treasury Bills or inflation-indexed bonds; and direct purchases, exchange-traded funds, or mutual funds. This course will explore the current economic environment, various fixed-income strategies, and their taxation. Companion course: Tax Aspects of Stock Investing

GAAP has become too complex for many small and private entities. As an alternative, many entities have adopted special purpose frameworks (formerly called OCBOA). This program guides entities through the acceptable methods of non-GAAP financial statements, the advantages and disadvantages of each, and presentation of the statements and disclosures.

This course explores provisions of Statements on Standards for Accounting and Review Engagements (SSARS) that govern review, compilation, and preparation engagements. Participants will recall foundational concepts, examine recent updates, understand practitioner responsibilities, and apply best practices for engagement performance. Attendees will learn how to efficiently perform SSARS engagements while complying with professional requirements. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This comprehensive annual update brings together key accounting and auditing developments affecting accountants and auditors across industries. The course combines recent standard-setting activity issued by the Financial Accounting Standards Board with major audit and attestation updates from the AICPA, providing a well-rounded view of changes impacting financial reporting and engagement performance. Participants will begin with an overview of recently issued and upcoming Accounting Standards Updates (ASUs), including standards effective for December 31, 2026 year-ends for public companies, private entities, and not-for-profit organizations. The course also highlights issued ASUs with future effective dates and provides high-level insight into recent exposure drafts to support implementation planning. The course then shifts to auditing and attestation developments, including the next phase of quality management with a focus on monitoring and remediation requirements. Participants will also review recent and proposed standards affecting audit, attestation, and consulting engagements, including SSAE No. 24, SSARS No. 26, exposure drafts related to confirmations and fraud, and SAS No. 149 addressing group audits. Designed for preparers, auditors, and firm professionals, this course helps participants understand how recent accounting and auditing changes intersect-and what to watch for as standards and expectations continue to evolve. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This webinar presents a variety of time-saving ideas, shortcuts, and tips that are sure to boost personal productivity. We discuss better summing, address one of the biggest pitfalls that Excel users have faced over the past 25 years, present the most important keyboard shortcuts, demonstrate a better alternative to hiding rows or columns, illustrate how to quickly navigate to other workbooks and files, and demonstrate using Excel with styles.

Since 2017, employees have not been eligible to take an itemized deduction for a home office. The Tax Cuts and Jobs Act suspended all miscellaneous itemized deductions for tax years 2018 through 2025. That deduction is scheduled to go into effect in 2026. Self-employed individuals can deduct office expenses on Schedule C, Form 1040. The home office deduction includes typical office-connected expenditures such as supplies, postage, computers, printers, and all the other ordinary and necessary expenses a person would have in connection with running a home office. The home office tax deduction for the self-employed would cover expenses for the business use of a home, which includes mortgage interest, rent, insurance, utilities, repairs, and depreciation. This program discusses many of the most important issues relating to the deductibility of home office-related expenses.

Training your reviewer's eye The complexity of S corporation tax law presents a formidable challenge to tax practitioners for accurate compliance and reporting of S corporation activities. The course identifies the common errors practitioners make on S corporation tax returns that review staff should spot. Four returns for you to review Learners can fine-tune their reviewing skills by examining case studies of sample tax returns that may warrant additional information from the client and areas of tax law where proper treatment requires additional analysis and information. Issues discussed include: Income and deductions Schedule K-1 reporting requirements Schedule K-2 and K-3 reporting requirements and the domestic filing exception The tax return in each case study contains errors or inaccuracies, giving learners the opportunity to apply their reviewing skills. Developed with H.R. 1, commonly referred to as OBBBA, in mind, these case studies reflect the realities of reviewing S corporation returns today.

Accounting and finance professionals routinely encounter a broad range of legal issues while advising clients or performing routine job functions. Contract law tops the list as the most frequent issue that intersects with the accounting and finance professions. As trusted advisors, it is wise to understand the fundamentals of contract law for both personal and professional benefit. This course provides a broad overview of contract law basics geared specifically toward the accounting and finance professions. From contract formation to enforceability, this course offers an interesting look at how contract law intersects with accounting and finance. Participants should walk away with a better understanding of common issues that arise when reviewing contracts.

Arguably the most discussed topics to come out of the One Big Beautiful Bill Act (OBBBA) are the taxation of tips and overtime. Practitioners need to understand these provisions now, as they are effective for 2025 tax returns. This program provides practitioners with the background currently available to advise clients regarding these two important tax developments. Both employers and employees need to understand these timely changes to taxation.

Mastering two leadership skills will decrease your stress, and give you room to enjoy your career. Delegating and listening are key essential skills to hone to elevate your career. You were born with two ears and one mouth. And yet, good listeners aren't born. World-class listeners deliberately practice this skill, even when their audience is challenging. This is a skill which can be learned. Participants will gain awareness into their blind spots to listening, strategies to regain focus, how to stop interrupting, and demonstrate to their audience they are listening. How often have you said, "It would just be easier if I did this myself?" or "Nobody can do this task as well as I can, so I'll just do it myself." If this sounds like you, then it's time to start working on your delegation skills. Delegation is not only important as a means to save you time, but it is also about developing the next generation of leaders. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This course provides a concise overview of the emerging liability, malpractice, regulatory, insurance, and professional-conduct risks associated with CPAs' use of artificial intelligence. Participants will examine how traditional duties of care, competence, confidentiality, verification, and professional accountability apply when AI is used in accounting, tax, audit, and advisory work. Drawing on developments in the United States, Canada, and the United Kingdom, the course explores documented AI failures, regulatory expectations, insurance coverage gaps, data exposure, and practical controls CPAs can implement to make AI-assisted work more defensible This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Answering clients' tax questions accurately and on time is a key challenge for tax practitioners. Through simple, plain language explanations and examples, this course will help practitioners perform tax research more efficiently by describing the structure of the primary sources, highlighting the differences between primary and secondary sources, and detailing the steps in the tax research process.

This interactive professional development course explores the concept of unconscious bias and its impact on workplace dynamics, decision-making, and organizational culture. Through engaging exercises, real-world case studies, and reflective activities, participants will gain a deeper understanding of how implicit attitudes shape perceptions and behaviors — often without conscious awareness. The course empowers learners to recognize their own biases, understand their origins, and develop strategies to mitigate their effects in professional settings. Participants will leave with actionable tools to foster a more inclusive, equitable, and respectful workplace.

In this innovative course, participants will learn to combine the power of artificial intelligence with the functionality of Microsoft Excel. You will learn how to leverage ChatGPT, OpenAI's powerful language model, to improve your Excel skills and decrease the time it takes to build spreadsheets. The course will include a quick introduction to ChatGPT but the majority of the time will be spent using ChatGPT to create an Excel spreadsheet. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This course provides a concise overview of critical thinking and professional skepticism in AI-augmented CPA work. As artificial intelligence increasingly performs drafting, analysis, calculation, research, and other preparation tasks, CPAs are shifting toward higher-value roles involving review, verification, challenge, and professional judgment. Participants will examine professional standards, human cognitive biases, AI failure modes, evidence requirements, questioning techniques, vendor claims, documentation practices, and firm-level controls. The course emphasizes a central principle: AI output should be treated as an unverified claim requiring appropriate human challenge before professional reliance. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This course provides a thorough examination of qualified tuition programs (Section 529 plans), focusing on their tax treatment, planning applications, and recent legislative changes. Participants will learn how 529 plans operate, what qualifies as education expenses, and how contributions, distributions, and beneficiary changes are treated under federal law. The course explores practical planning strategies, including 529-to-Roth IRA rollovers, multigenerational "dynasty" 529 planning, grandparent-owned account considerations, and interplay with financial aid. It also addresses state-level variations, compliance issues, and common pitfalls. Using real-world scenarios, the course evaluates when 529 plans are advantageous, the limitations families may encounter, and alternative approaches to education and long-term savings. Participants will gain a clear understanding of tax benefits, penalties, strategic funding approaches, and planning opportunities for high-net-worth families as well as typical households.

When a purchaser buys an existing partner's partnership interest or the interest of a member of a limited liability corporation (LLC) taxed as a partnership, the amount paid becomes the basis for the purchaser's partnership interest (outside basis). If the partnership's assets have appreciated sufficiently, the difference between the new partner's inside and outside basis can be substantial. This disparity can deprive the new partner of depreciation deductions and inflate his or her share of the gain from subsequent property dispositions unless a Section 754 election is in effect. The Section 754 election can also apply when a partnership makes a distribution of property and the basis of the distributed property to the partnership and the basis the partner/distributee will take in the distributed property are not equal. In this case, a partnership can recover basis it would otherwise lose if the 754 election were not in effect.