CPE Catalog & Events

How to pay for the cost of long-term care remains a primary concern for most clients over the age of 50. Explore clients' motivations, misconceptions and objections to purchasing long-term care insurance, and a look at the latest long-term care solutions, including hybrids. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This session will address the complex rules of retirement distributions, review key provisions of the SECURE Act 2.0, and provide practical strategies of maximizing tax benefits for your client. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Practical hands-on Excel learning exercises taught by a highly engaging expert in the field You'll develop your expertise with real-world Excel workbooks. Despite the popularity of VLOOKUP, it has its drawbacks. This session will address these drawbacks while offering alternatives. You'll walk through the VLOOKUP and IFERROR functions, and explore the following topics: Improving the use of VLOOKUP with VALUE/TEXT Improving the use of VLOOKUP with MATCH. Moving beyond VLOOKUP with INDEX Trapping errors with IFERROR Moving beyond basic Excel functions Grasping the limitations and possible enhancements for the VLOOKUP feature, along with methods to handle errors can elevate your proficiency in Excel. You'll also partake in hands-on Excel activities that showcase the integration of functions and their use in crafting spreadsheets, encompassing: Combining functions to enhance flexibility Utilizing functions for atypical data categories Perfecting sophisticated lookup functions *Session 5 is one of eight sessions that is available as an individual session. Each session builds on the prior sessions, so you'll want to consider watching [Session 6: List Comparisons and Indenting] (https://www.aicpa-cima.com/cpe-learning/webcast/excel-for-accounting-professionals-session-6--list-comparisons-and-indenting) to further prepare to tackle real-world issues and build powerful workbooks.*

Implementing ASU No. 2016-02, Leases (Topic 842) is sure to have a major impact on your balance sheet and potentially on your business as well. This course is a one-stop shop for what you need to know about the now-effective changes to the lease accounting guidance. In this course, we will review how to measure the lease liability and right-of-use asset that will now be recorded on the balance sheet for all leases. We will also tackle the tricky issues of accounting for lease modifications and other lease remeasurement events as well as address the other major provisions of ASC 842, such as disclosures and transition. We will also review the income statement treatment of lease expense for all leases for both lessees and lessors and discuss recent FASB implementation guidance. Lastly, the course will cover all recent updates to the originally issued guidance in Topic 842, including that related to discount rates. With Topic 842's effective date here, now is the time to get up to speed on this complex new standard.

Despite the fact that a client's tax matter may be taken directly to court, utilizing the IRS Independent Office of Appeals usually results in saving your client both time and money. Join us as we discuss the misunderstood process of navigating the complex IRS Appeals.

Unlock the full potential of your data with our cutting-edge course, "Create Visuals in Power BI to Successfully Analyze Data." Designed to span a focused, four-hour session, this course is your gateway to mastering the art of data visualization using the powerful tools of Microsoft Power BI Desktop and PowerBI.com. Whether you're a business professional, a budding data analyst, or simply someone interested in the world of data science, this course is tailored to enhance your skills in transforming raw data into visually stunning and insightful reports. Dive into the intuitive interfaces of Power BI Desktop and PowerBI.com, and learn to navigate these platforms with ease and confidence. The course is meticulously structured to provide you with demonstrations and practical knowledge. Starting with a comprehensive tour of the Power BI Desktop and PowerBI.com interfaces, you'll quickly move to the core of creating impactful visuals. Explore a wide array of available visuals and learn how to select the most effective ones for your data stories. Through detailed sessions on building interactivity into your visuals, you will discover how to create dynamic reports that not only captivate but also communicate effectively. This course will also guide you through the process of publishing your reports on PowerBI.com, ensuring that your insights reach their intended audience with the right impact. By the end of this transformative journey, you will be adept at leveraging the full capabilities of Power BI. Your newfound ability to create interactive, engaging, and informative visual reports will make you an indispensable asset in any data-driven decision-making process. Embrace this opportunity to elevate your professional profile, enhance your analytical capabilities, and become a sought-after expert in the field of data visualization. Join us for "Create Visuals in Power BI to Successfully Analyze Data" and step into the future of data analysis with confidence and skill. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

We kick off this course with a look at the GASB standards that are effective this year including GASB 100, Accounting Changes and Error Corrections and GASB 101, Compensated Absences. We then move to the NFP side of the house with a look at the Accounting Standard Updates issued by the FASB that impacts nonprofit entities. Following that, we review the work of the Not-for-Profit Advisory Committee (NAC) and the projects they advise the FASB on. After the break, we will conduct a deeper dive into Yellow Book and Single Audit engagements. The course closes with a look at the significant changes in the 2024 Compliance Supplement, the changes to the Uniform Guidance and the common deficiencies identified by the federal agencies and peer reviewers. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This highly informative course comprehensively covers all the latest tax law developments. The focus is on individual taxation and discussion of the planning opportunities practitioners need to understand to help clients respond effectively. You will come away from the course with the up-to-date knowledge to educate your individual tax clients and implement tax-saving ideas that will serve their ever-evolving needs. This course is continually updated to reflect enacted legislation. Please Note: Due to content overlap, it is recommended that this course NOT be taken together with BFTU.

The course provides a concise overview of how to use ChatGPT to more effectively and efficiently research IRS taxation law. It delves into techniques for extracting precise information from complex tax legislation, interpreting IRS guidelines with AI assistance, and utilizing ChatGPT's advanced language models for nuanced legal analysis. Participants will learn how to streamline their research process, identify relevant tax law precedents, and apply AI insights to real-world tax scenarios, enhancing their professional proficiency in navigating the intricate world of IRS taxation. 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.

This program discusses, in a practical way, how an S corporation shareholder calculates their stock and loan basis on Form 7203. Form 7203 is the IRS Form on which a shareholder is sometimes required to calculate their stock and loan basis. This topic is particularly important when an S corporation has a loss and the shareholders wish to know whether they are entitled to fully utilize the loss that has been allocated to them against their other income.

Many partnerships and S corporations are now required to complete the voluminous Schedules K-2 and K-3 to report foreign-related tax information. Updated for the 2024 tax year, this course is an essential guide for tax preparers on how to tackle the preparation of these forms. Understanding and preparing these forms requires a basic knowledge of various international tax topics, including sourcing of income, foreign tax credit income categories, effectively connected income, and fixed, determinable, annual, or periodical (FDAP). The course includes a brief discussion of key international tax concepts, a detailed walk-through of what information is required to be reported in different parts of the schedules, and practical advice from the field. The course also includes three comprehensive case studies on how the form should be completed for operating, real estate rental, and investment partnerships. Please note: Surgent also offers a companion course, "Schedules K-2 and K-3: Filing Requirements" (KFR2).

This course uses the lives of the rich and famous as a template to better understand the realm of estate planning. With stories ripped from the headlines, we will examine pitfalls and best practices. Did you know that Prince died without a will, opening the door for 45 people claiming to be his beneficiaries? Or that Michael Jackson was not careful in properly funding his trust, leading to delays and legal battles in the administration of his estate? Even Abraham Lincoln, it turns out, did not have a will. In discussing an array of celebrities, from Jackie Kennedy, Joan Rivers, Jimi Hendrix, and Whitney Houston to Aretha Franklin, Barry White, Leona Helmsley, and Florence Griffith Joyner, the course is designed as an enjoyable learning experience with tips for all levels of expertise. We may not have their fame or fortune, but we can certainly walk the red carpet when it comes to estate planning.

As long as LLCs, partnerships, and S corporations form the backbone of many CPAs' practices, in-depth knowledge of all tax aspects of these entities will be essential. The purpose of this practical course is to focus on planning issues in creating, operating, and liquidating S corporations, partnerships, and LLCs. This course is essential for CPAs in public accounting and industry who advise these entities or their investors.

This course dives into the powerful, but potentially under-utilized, capabilities of Microsoft Excel. Designed for sophisticated users willing to approach spreadsheets from a unique perspective, this program encourages users to challenge the status quo by considering opportunities to take acceptable spreadsheets to a new level. 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 reviews the statutory and regulatory guidance as they relate to fringe benefits. There will be an emphasis on entertainment, meals and business transportation expenses, including qualified employer-provided parking, with a focus on planning opportunities. Recent federal tax legislation, cases and rulings will also be addressed. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Major benefits of detailed Excel workbooks Understanding list comparisons in Excel is vital for improved workbook efficiency. In this webcast, the facilitator will walk you through comprehensive learning exercises that provide an overview of the following topics: Performing list comparisons Building multicolumn list comparisons Using lookups Indenting commands In-depth training for Excel upskilling This webcast is crafted to enable active participation as you follow the demonstrations. It will navigate you through the intricacies associated with working Excel columns, helping you to apply key functions effectively for significant improvements through the following: ISERROR COUNTIFS SUMIFS *Session 6 is one of eight sessions that is available as an individual session. Each session builds on the prior sessions, so you'll want to consider watching [Session 7: Data- Driven Workbooks and Concatenation] (https://www.aicpa-cima.com/cpe-learning/webcast/excel-for-accounting-professionals-session-7--date-driven-workbooks-and-concatenation) to further prepare to tackle real-world issues and build powerful workbooks.*

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.

Financial statements tell a story. Ratios reveal the plot. Desegregate key ratios that show effective management of a company. Learn a compact, efficient approach to financial statement analysis. Be introduced to a set of basic-to-intermediate analytic techniques and tools that provide insightful outputs to a broad spectrum of users with varied analytical objectives. Evaluate management performance, address the changing economic landscape, and the need for a new way of thinking.

Recent generally accepted auditing standards were written to improve the quality of risk-based financial statement audits, audit reporting, and required by-product communications. This course will discuss the important clarifications and enhancements intended to improve audit quality to ensure better compliance with requirements contained in the SASs. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.