CPE Catalog & Events

Unlock the full potential of Microsoft Excel PivotTables with this comprehensive course. This training is designed to equip participants with the skills to effectively analyze and summarize data, transforming raw numbers into actionable insights. Whether you're a seasoned professional or new to data analysis, this course provides an in-depth understanding of PivotTables and their capabilities, helping you uncover patterns, compare data, and make informed decisions. The program includes a step-by-step approach to creating and customizing PivotTables, focusing on how to use them to analyze data efficiently. Participants will learn how to group and filter data, identify trends, and apply advanced features to solve real-world business challenges. Beyond technical knowledge, this course introduces data visualization through PivotCharts, teaching participants how to present their analysis effectively to stakeholders. By the end of the course, you'll not only master PivotTable fundamentals but also gain advanced techniques to streamline data analysis and support strategic decision-making in any context. 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 focuses on the most common aspects and tax implications of Limited Liability Companies and S Corporations. It will further compare forms of entities, along with corporate formalities compliance issues of each entity type. Electing Subchapter S status as well as reviewing the mechanics of electing Subchapter S status will be discussed. Highlights of entity specific tax forms will be discussed, as well as accountable plans, taxable fringe benefits, officer reasonable compensation, estate planning, business continuation planning and audit strategies. Schedules K-1, K-2, K-3, and effectively connected income will be reviewed in this course as well. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Specifically designed for preparation, compilation, and review practitioners, this course will provide you with a comprehensive review and hands-on application for performing financial statement preparation, compilation, and review engagements. You will learn the ins and outs of applying SSARS No. 21, Clarification and Recodification, as well as the additional guidance related to SSARS engagements through the issuance of SSARS Nos. 22-26 by the ARSC. In addition to SSARS 26, the entire suite of quality management standards is discussed. However, knowing the standards is not enough. You need to be able to effectively apply them. To support this, the course will review recent peer review feedback on SSARS engagements, providing insights on how to successfully apply this guidance. Not only will this course bring you up to date on SSARS requirements and guidance, but more importantly, it will provide you with practical examples and illustrations to help you effectively and efficiently perform these types of engagements. This course is intended to be your go-to reference for training your staff and managing your SSARS No. 21-26 services in compliance with professional, ethical, and technical requirements.

This intensive two-hour course addresses the critical need for accuracy and efficiency when developing spreadsheets using Microsoft Excel. Recognizing that even minor errors can have significant implications, this course delves deep into strategies and skills required to detect and correct errors in Excel. By the end of this course, participants will have a comprehensive understanding of how to efficiently identify and correct errors in Excel spreadsheets, enhancing their overall productivity and accuracy in their professional roles. 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 explores the transformative role of artificial intelligence (AI) in accounting and auditing, highlighting its vast potential while addressing the associated risks and ethical considerations. Participants will discover how to harness AI tools to enhance efficiency and innovation, while mitigating challenges such as overreliance, data security vulnerabilities, and ethical dilemmas. Through case studies and interactive discussions, you'll gain practical skills to navigate AI complexities, ensure trustworthy outputs, and uphold ethical standards in today's fast-paced digital environment. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

During part 3, of this 4-part series, we'll focus on the accounting and taxation of Complex Trusts. Using a series of calculations, determine whether the fiduciary or the beneficiary bears the burden of taxation and if the trust or estate is treated as a taxpaying entity or a conduit. The requirements and use of a charitable contribution deduction are also reviewed and its relationship with and difference from fiduciary accounting. Be sure to register for all courses in this series: Fiduciary Taxation Part 1: Introduction to Form 1041 Fiduciary Taxation Part 2: Fiduciary Accounting & Simple Trusts Fiduciary Taxation Part 3: Complex Trusts & Charitable Deduction Fiduciary Taxation Part 4: Miscellaneous Topics & AMT

Transfer taxes, such as the estate, gift, and generation-skipping transfer tax, create a drag on the accumulation of wealth over a family's generations. However, with the One Big Beautiful Bill's continuation of the high gift and estate tax exclusion amounts for the foreseeable future, advisers have the opportunity to create trusts that extend through the grandchildren's generation. This course examines the generation-skipping transfer (GST) tax and how it is designed to discourage avoidance of the estate and gift tax by families. Randy Gardner explores: GST tax terminology, how the GST tax is calculated, ways to avoid the GST tax, and how to design a dynasty trust to pass property from generation to generation. 

This course is designed for the accounting and auditing professional who provides attestation services to closely held businesses. The course reviews recent standard-setting activities of the Financial Accounting Standards Board (FASB) and the AICPA, specifically focusing on those standards having the most significant impact on closely held non-public business entities. The course also discusses adopting the latest audit standards, including the new audit risk assessment requirements.

Clients believe that estate planning is only for the wealthy who will owe Federal estate tax. This isn't the case. Perhaps as a result of the 2020 pandemic, estate planning has a renewed focus. All practitioners should be familiar with the vernacular, acronyms and techniques. Estate planning involves personal issues that affect everyone, whether or not the estate tax will apply. Learn strategies to pass assets to future generations; provide education benefits; distribute retirement benefits, and provide a charitable legacy.

If you have been a practitioner for any length of time, you know that there is often a difference between what clients should do and what they actually do. Have you ever wondered why that is? In this course, we will explore how we make decisions with less-than-perfect information. Through real-life examples and case studies, we will examine common behavioral biases and how to deal with them. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This program addresses the most recent developments impacting partnerships operating as LLCs, with a focus on legislative, administrative, and tax form changes. Emphasis will be placed on partners "tax basis" capital accounts, now required for tax form reporting. 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 will explore the use of ChatGPT and artificial intelligence chatbot technologies in the accounting profession. Participants will learn how to utilize ChatGPT to automate tasks, improve efficiency and accuracy, and provide real-time support to clients. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The path from CPA to CFO has evolved dramatically in recent years, with only 43% of S&P 1000 CFOs holding CPA licenses in 2022, down from 55% a decade earlier. This comprehensive course, based on groundbreaking research from the Pennsylvania Institute of CPAs surveying over 320 CEOs and hiring executives, reveals what today's leaders truly seek in CFO candidates and provides a roadmap for CPAs to secure their seat at the executive table. Participants will discover the five critical competencies that distinguish successful CFO candidates: forward-looking financial acumen that goes beyond traditional reporting, strategic leadership skills including critical thinking and strategy creation, the evolving role of emotional intelligence, industry-specific expertise requirements, and the balance between technical proficiency and visionary leadership. Through practical frameworks, real-world examples, and actionable strategies, attendees will learn how to transform their CPA foundation into a comprehensive skill set that meets the dynamic demands of modern CFO roles, whether in high-growth companies, nonprofits, or traditional corporations. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Financial statement disclosures are important to provide the information necessary for financial statement users to make economic decisions. Disclosures further explain and clarify information provided in the basic financial statements, but also provide critical information about subsequent events, litigation risk, and other concerns. This course focuses on the most common financial statement disclosures for small- or medium-sized nonpublic entities. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The final webcast in this series focuses on the special rules that apply when a fiduciary entity invests in real estate or other passive activity assets, elects the 65-day rule, makes specific bequests to beneficiaries or incurs alternative minimum tax (AMT). The underlying statute for AMT is written for individual taxpayers and the fiduciary or adviser must apply the statute to the special rules and calculations that determine fiduciary taxation. Be sure to register for all courses in this series: Fiduciary Taxation Part 1: Introduction to Form 1041 Fiduciary Taxation Part 2: Fiduciary Accounting & Simple Trusts Fiduciary Taxation Part 3: Complex Trusts & Charitable Deduction Fiduciary Taxation Part 4: Miscellaneous Topics & AMT

This seminar offers a practical and in-depth exploration of IRS Schedule K-1, a critical reporting document issued to taxpayers with interests in pass-through entities such as Partnerships, S Corporations, and Estates or Trusts. Participants will gain a clear understanding of how to interpret and accurately report Schedule K-1 data on Form 1040, with emphasis on common income, deduction, and credit items. The course also demystifies the Qualified Business Income (QBI) Deduction, including eligibility criteria, reporting mechanics, and integration with K-1 data. Key compliance topics-such as basis and loss limitations, material participation rules, and passive activity considerations-will be addressed through practical examples. In addition, attendees will be briefed on recent developments affecting Schedules K-2 and K-3, ensuring they are equipped to navigate evolving international reporting requirements. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

IRS Form 7217 is an IRS tax form required for partners receiving distributions of property from partnerships. Starting for tax years beginning in 2024, a partner who receives property from a partnership must file Form 7217 with his or her annual income tax return. Form 7217 is filed by any partner receiving a distribution of property from a partnership to report the basis of the distributed property, including any basis adjustment to such property as required by Section 732(a)(2) or (b). This new IRS form is part of the IRS's general concern regarding basis shifting in favor of high marginal tax rate related partners. Form 7217 is now required and details the types of property distributed, the aggregate basis, and the allocation of basis to the distributed property. Form 7203 is designed to assist in tracking an S corporation shareholder's stock and debt basis. Form 7203 is a significant improvement from the worksheets the IRS provided formerly and over time will serve to help partners and partnerships keep track of their stock and debt basis. The course covers the structure and organization of Form 7203 as well as how an S corporation shareholder's stock and debt basis are calculated.

Our country and our accounting methods have undergone huge changes in the previous few years, most of it challenging. Individuals and entire businesses have been left reeling by new tax regulations, doing more with less, and employment restructuring. Organizations must adjust quickly; notwithstanding how painful these changes have been. This course instructs accounting managers on how to deal with change and stress in the workplace. Before it affects them in a negative way, the accounting professional will learn how to best manage the changing work environment and the stress that comes with it. "The first wealth is health," remarked Ralph Waldo Emerson, but for many of us, stressful jobs are putting our health at jeopardy.

Since 1919, the Internal Revenue Service had a civil and criminal function in the United States tax system. Little do people know, the IRS has an elite criminal function that started with five United States Postal Inspectors. From its early days in taking down Al Capone to now solving cybercrimes, the IRS special agents are tasked with investigating tax fraud, money laundering, and other white collar crimes. This presentation will show you the importance of this law enforcement function, the training, techniques, expertise, and actions that cause them to be known as the "world's finest financial investigators." This presentation has been prepared by a 20 year veteran with the IRS-Criminal Investigation. The presenter investigated crimes, and trained and mentored other special agents. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

While many financial services professionals advise their clients on tax, investment, and life insurance issues, far fewer venture to help in the area of property and casualty insurance. Auto and homeowners policies are mandatory products that everyone generally needs - yet they are also complex products. This complexity raises questions in clients' minds: Are all my belongings covered under my policy? Do I have to adjust my policy if I want to let my neighbor borrow my car? Do I need an additional policy if I want to work as a rideshare driver? And will my premium go up when I move? In this course, we will cover the fundamentals of auto and homeowners' policies. We will touch on these questions, explore basic coverages, and offer some guidance on what practitioners should cover with their clients in this area, so you can offer guidance and give them the peace of mind they need. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.