CPE Catalog & Events

This session provides a comprehensive analysis of meals and entertainment regulations under IRC 274 as amended by the Tax Cuts and Jobs Act. Participants will learn how to identify deductible vs. nondeductible expenditures, interpret the regulatory definitions surrounding "entertainment," "business associate," and reimbursement arrangements, and apply the numerous exceptions under IRC 274(e), including compensation, recreational activities, public availability, and goods or services sold to customers. Using examples from the final regulations, we will dissect key distinctions such as separately stated food and beverage costs, employer-provided meals, and the treatment of per diem reimbursements. This course equips practitioners with the technical precision required for compliance, documentation, and audit defense. 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 examines actual fraud circumstances through the lens of potential prevention. We will examine how selected frauds were accomplished and consider what internal controls may have prevented fraudsters' ability to accomplish their nefarious acts. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

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.

In today's rapidly changing world, finance professionals are required to wear many hats and are often the keys to the success of the organization. On one hand, they need to be abreast of the latest proven financial skills for making the best decisions, and on the other hand, they need the best skills to motivate, manage, and lead people. Being pigeonholed into one area or another is neither good for career building nor good for the organization. We'll cover the latest issues that all CFOs and controllers need to know about and provide how-to guidance to allow for immediate use in their organizations.

Overcoming the challenges of auditing contracts Construction makes up a large portion of the economy. As such, a growing number of accounting and finance professionals may need to be aware of the accounting and auditing guidance for the construction industry. You'll delve into the audit considerations related to construction contracts, covering various topics, including: Audit planning and substantive auditing procedures The core knowledge necessary to succeed Key issues affecting construction auditing, including auditing under the new revenue recognition and leases guidance Audit risks and risk assessment

New personal financial planning strategies are emerging due to passage of the One Big Beautiful Bill and evolving personal goals in difficult economic and legal environments. Drawn from recent publications and government directives, this course reviews the latest financial strategies and planning changes from the past year in insurance, investments, tax, estate and retirement, including Social Security and Medicare. Additionally, Randy covers estate and tax planning strategies that enable practitioners to better serve clients by allowing them to take advantage of new opportunities.

If you're ready to move beyond Excel's fundamental features, participate in K2's Advanced Excel. This course will teach you about collaboration options, security techniques, tables, data models, PivotTables, and advanced formulas.

An in-depth coverage of ASC Topic 842, Leases . Leasing is popular among corporations for needs including office space and equipment. Since ASC Topic 842, Leases has been adopted by most entities, it is time to review the topic, including any recently issued updates. Excerpts from publicly traded companies' recent disclosures on Leases are also examined.

This course provides a concise overview of Claude and its growing role as an AI-powered productivity, analysis, and workflow platform for accounting professionals. Participants will learn how Claude differs from traditional search engines, spreadsheets, and chatbots, and how it can be used to accelerate drafting, research, document review, data analysis, and client communications while maintaining professional skepticism and accountability. The course explores practical prompting techniques, document and spreadsheet analysis, projects, artifacts, connectors, Microsoft 365 integrations, automation capabilities, and emerging AI workflows. Special emphasis is placed on confidentiality, privacy, ethics, verification, and professional judgment. By the end of the course, participants will understand how to integrate Claude into their daily accounting workflows to improve efficiency, strengthen decision-making, and support higher-value advisory services. The course is based on the Claude platform ecosystem, including Chat, Projects, Artifacts, Connectors, Microsoft Office integrations, Voice Mode, Design, Code, and Cowork capabilities. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

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.

What makes a business valuable? Who determines value? What are the key factors that make businesses valuable? In this course, we explore the different ways to value a business. We will apply foundational valuation and corporate finance concepts to real world examples in an effort to see what makes up an investment's price.

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.

As financial leaders, CPAs are often tasked with managing organizational risk. In this respect, the supplier relationship can be a tricky one. It is often one of the more familiar and comfortable business relationships we have, yet it may also be the one that presents the most significant risk to our company. In this course, we will explore how to manage the supplier relationship from onboarding to termination. Through case studies and best practices, we will discuss how to continue being a good partner to our suppliers while also understanding where potential risks exist. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Realistic Excel training for skill development Shifting from manual inputs to automated formulas in Excel can help enhance data efficiency. Understanding that Excel can handle date and text values broadens the potential to improve efficiency when managing data in Excel. This webcast will focus on the following essential functions: EOMONTH MONTH and YEAR DATE CONCAT SUMIFS with CONCAT Practical hands-on Excel learning exercises taught by a highly engaging expert In this webcast, you'll develop your skills and implement Excel techniques that will boost the effectiveness of conditional summing functions using comparison operators. Additionally, you'll gain in-depth knowledge of the following: Adding helper columns Distinguishing key function differences Combining values *Session 7 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 8: Dynamic headers, mapping tables and error check] (https://www.aicpa-cima.com/cpe-learning/webcast/excel-for-accounting-professionals-session-8--dynamic-headers-mapping-tables-and-error-check) to further prepare to tackle real-world issues and build powerful workbooks.*

Is that business jet, RV, yacht or luxury automobile really deductible? This course tackles the tricky terrain of listed property depreciation, helping tax professionals navigate IRC 280F with confidence and clarity. Whether your client is flying high, cruising the coast, or hitting the highway, this session will help you determine what qualifies, what doesn't, and how to keep the IRS at bay. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

AI is already being used in so many ways to aid business organizations in a wide array of ways. However, artificial intelligence is also being used by those seeking to steal or commit fraud to circumvent controls and mislead both people and systems working to keep fraud at bay. The use of AI for ill-intent is pervasive and difficult to detect which makes fighting defalcation attempts an even greater struggle. In this session we will look at some of the methods that are AI-centric which are being used to deceive and defraud. We will then dive deeper and explore ways to identify instances when AI is being used. Finally, we will look at control measures that can aid those working to fight AI driven fraud. If it is evident that artificial intelligence could be used as a weapon to harm you or your organization, you should strongly consider enrolling in this session. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

New personal financial planning strategies are emerging due to passage of the One Big Beautiful Bill and evolving personal goals in difficult economic and legal environments. Drawn from recent publications and government directives, this course reviews the latest financial strategies and planning changes from the past year in insurance, investments, tax, estate and retirement, including Social Security and Medicare. Additionally, Randy covers estate and tax planning strategies that enable practitioners to better serve clients by allowing them to take advantage of new opportunities.

If you're ready to move beyond Excel's fundamental features, participate in K2's Advanced Excel. This course will teach you about collaboration options, security techniques, tables, data models, PivotTables, and advanced formulas.

An in-depth coverage of ASC Topic 842, Leases . Leasing is popular among corporations for needs including office space and equipment. Since ASC Topic 842, Leases has been adopted by most entities, it is time to review the topic, including any recently issued updates. Excerpts from publicly traded companies' recent disclosures on Leases are also examined.

This course provides a concise overview of agentic artificial intelligence and its emerging role in audit and assurance. Participants will examine how AI agents differ from traditional generative AI by planning tasks, using software tools, taking actions, and completing multi-step workflows with limited human intervention. The course explores current audit applications, including substantive procedures, confirmations, risk assessment, disclosure testing, and continuous monitoring, while addressing new risks involving autonomy, permissions, prompt injection, multi-agent systems, and accountability. Participants will also examine regulatory developments, professional standards, controls, evidence requirements, ethics, liability, and the strategic implications of agentic AI for audit firms. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.