CPE Catalog & Events

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.

As Americans live longer and increasingly move away from traditional pensions, Social Security has become the main source of retirement income for many clients. Meanwhile, concerns about solvency and a lack of understanding of key rules have led to confusion and sometimes misguided decisions. This program offers tax practitioners the knowledge they need to help clients make informed choices about Social Security and retirement income.

Artificial intelligence is revolutionizing forensic accounting, giving professionals powerful new ways to trace funds, uncover fraud, and analyze massive volumes of financial data in minutes instead of weeks. In this engaging course, you'll discover how AI can enhance financial investigations, strengthen expert witness reports, and support litigation and discovery efforts. Learn where AI can create strategic advantages in the courtroom, as well as the disclosure, reliability, and admissibility challenges that every expert must understand. Through practical examples and real-world applications, you'll see how AI can uncover hidden patterns, identify critical evidence, and generate actionable insights. Whether you investigate fraud, support litigation, or serve as an expert witness, this course will help you harness AI with confidence, credibility, and defensible results. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The newest evolution of AI technology is Agentic AI. This technology enables you to deploy AI agents to take action on your behalf and execute tasks. Agentic AI is the key enabler to using AI technology to automate your workflows. Learning how to take advantage of AI agents provides a substantial competitive advantage. This course will teach you the fundamentals of agentic AI and how you can put them to work in your firm or business.

Boosting productivity with Excel For those unfamiliar with conditional summing, you're in for a revelation —it's an impactful technique that improves productivity in creating reports. You'll learn how to optimize Excel efficiency by managing duplicates, selecting appropriate shortcuts, and performing lookups. Practical hands-on Excel learning exercises taught by highly engaging expert in the field You'll also deepen your skills and tackle real-world Excel workbooks that address the following: Benefits of using lookup functions over direct cell referencing A comprehensive exploration of the popular VLOOKUP function Techniques for removing duplicates to create a distinct set of report labels *Session 4 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 5: Error Trapping and Improving Lookups] (https://www.aicpa-cima.com/cpe-learning/webcast/excel-for-accounting-professionals-session-5--error-trapping-and-improving-lookups) to further prepare to tackle real-world issues and build powerful workbooks.*

Each year, more states legalize cannabis (i.e., marijuana) for medical or recreational purposes. As legalization grows, so too does the cannabis industry. While some financial professionals have stayed away from this growing sector of the economy, others have embraced the opportunities the cannabis industry has to offer. The legalization of cannabis brings with it a complex regulatory landscape, which includes strict compliance with federal and state regulations. However, the complexity of this emerging market provides opportunities for accountants and other financial professionals. Behind the cannabis dispensaries are scores of related business sectors including food production, retail, farming, and chemical production, as well as facilities, design, and construction. Simply stated, the commercialization of marijuana offers financial professionals an opportunity to participate in an industry expected to reach $73 billion worldwide within six years.

If you or your clients are facing that stage of life where careers are passing into the background, and a new "to be determined" life is emerging, then you are entering what is called "retirement". Some people are excited, some are scared, and most are both. There are many issues and questions people face at this time - what to do with time, financial, relationships, health, identity and more. This program summarizes the key research studies, provides stories from those who have made this work, and offers thoughtful, practical exercises from my award winning book NEXT STAGE. It will help you (or your clients) address key issues and develop a Master Plan for the transition. If not now, when? This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Do you ever import data into Excel, and then spend a bunch of time manually preparing it for use? Perhaps you delete extra columns or rows. Maybe you need to split a single column into multiple columns, or, combine multiple columns into a single column. The good news is that many of these transformations can be fully automated with Excel! The Get & Transform tools built-in to Excel 2016 for Windows, formerly available as the Power Query add-in, are incredibly powerful. At a high level, they enable us to retrieve data from a variety of sources and prepare it for use as needed. In this session, we'll use Get & Transform queries to help with several common tasks, including flattening data, splitting and combining columns, formatting data, unpivoting summarized data, and combining several csv exports. If you frequently export/import data from one system to another, you will want to understand how to use a Get & Transform query to streamline your work.