CPE Catalog & Events

Accounting and finance professionals advising their business clients must be fully informed regarding the multiple loss limitation provisions that apply to individuals conducting businesses and pass-through entities. This program covers the loss limitation rules that accounting and finance professionals must know in order to advise their individual and pass-through entity clients fully and adequately as to when and if a loss limitation applies. The loss limitations discussed in this program start with an introductory discussion of hobby loss rules and graduate to more substantive discussion of the remaining loss limitations: basis limits, at-risk rules, passive loss limits, excess business loss limits, net operating losses, and the Section 163(j) interest limitation. Knowing when loss limits apply is essential for any accounting and finance professional. This program will put you in a position to advise clients fully and intelligently regarding each of the loss limits. This program discusses new OBBBA changes that impact tax loss limitations impacting individuals and pass-through entities.

Use QuickBooks Online more effectively! You'll learn how to avoid (and fix) common mistakes in QBO bank feeds, how to properly classify transactions, and best practices for recordkeeping. After working with hundreds of business owners and bookkeeping professionals, Alicia has seen all kinds of crazy bookkeeping. She's managed to distill those bad habits down into the top 10 mistakes people make in QuickBooks Online. She wants to make sure you don't make them, too! This hour and a half long course highlights the Top 10 best practices that you'll want to get right, saving yourself wasted time and money. We'll start with words of wisdom about setting up your account, and dialing in your chart of accounts and products & services. Then we'll look at recordkeeping, from receipts to understanding what qualifies as a tax-deductible expense. We'll finish up by taking a look at some of QBO's "quirks" so you know proper use of the software. It's important to implement these best practices right at the beginning of your QuickBooks file. It's a lot more expensive and time consuming to fix a file than it is to get trained to do it right in the first place! 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.

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.

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 investigates actual real-world fraud schemes and discusses what controls could have prevented the fraud from occurring, and what controls could detect and curtail the fraud scheme. The instructor speaks from experience, finding multiple frauds very early in her career leading to a career-long focus on fraud prevention and detection. 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 how artificial intelligence, particularly ChatGPT and other AI tools, is transforming accounting research methodologies and practices. Students will explore the shift from traditional search engine-based research to AI-driven insights, learning how to leverage various AI platforms for enhanced financial analysis, regulatory compliance, and strategic decision-making. The course emphasizes practical applications of AI in accounting contexts while addressing critical considerations such as data verification, ethical usage, and professional judgment. 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 technical overview of IRC 1031 like-kind exchanges, focusing on the application of current law and regulations following the Tax Cuts and Jobs Act. Presented by a former IRS subject matter expert, the course is designed for practitioners who advise on, prepare, or review transactions involving real property exchanges. Participants will examine qualification requirements, definitions of real property, and the determination of like-kind versus non-like-kind property under Treasury Regulations. The course covers key concepts including relinquished and replacement property, boot, realized and recognized gain, and basis calculations. Additional topics include the interaction of 1031 with cost segregation studies, depreciation treatment under 1245 and 1250, replacement property basis allocation, depreciation of carryover and excess basis, and multi-property exchange rules. Practical compliance considerations relevant to tax return preparation and review are emphasized throughout. 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 profiles Brenda, a financial executive from the state of Washington. Despite earning her college degree, Brenda did not find employment in her area of study. Instead, she landed a series of dead-end jobs. Business reversals frequently led to the loss of employment. When a company that she knew to be unethical offered her an executive position that included bookkeeping tasks, including overseeing all finances, she accepted. While on the job, Brenda saw owners of the company misappropriating funds. Rather than reporting the fraud, she created an elaborate scheme to benefit herself - without the owner's knowledge. Her bad decisions led to a guilty plea for wire fraud, after authorities accused her of absconding with more than $600,000 in corporate funds. A prison term of 20 months followed. Listen and learn from Brenda's experience. 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 use Microsoft (Office) 365? Are you satisfied that you are getting the most that you can from it? If you answered yes then no, this course will provide a really high return on your investment of time and money in this application suite. John Higgins, one of the profession's leading experts on the integration of Microsoft 365 into business, will explain and demonstrate the depth and breadth of the Microsoft 365 ecosystem. The course is designed to raise your awareness of all that you can do with Microsoft 365 and substantially increase your monthly subscription ROI. 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.

Good managers know how to delegate, but it can be a challenge to manage employees who are more interested in passing the buck than being responsible. Lack of ownership and responsibility can bog down processes and shut down projects. This workshop will help you create a game plan for building a culture of accountability with your team.

Change is inevitable and at times overwhelming if you are unprepared. You'll ensure that you understand the recent developments in governmental and not-for-profit accounting and auditing with this update course. This course is designed to prepare you for the latest accounting and auditing developments affecting governments and not-for-profits and give you the tools and knowledge to implement the new standards. Understanding new standards that affect governmental and not-for-profit accounting Recent updates to accounting and auditing standards will change how governmental and not-for-profit accounting and auditing is performed. You'll learn how to implement and understand recent additions, including: GASB Statements FASB Accounting Standards Updates Auditing Standards Board Updates Changes to *Government Auditing Standards* Detailed scenarios to increase your comprehension Real-world examples help increase your comprehension of how to implement the changes in your work. You'll be empowered to properly identify when new standards should be applied.

Are you a new advisor handling S Corp clients, or perhaps a seasoned professional facing this common scenario: "My S Corp client didn't take reasonable compensation last year. Now what?" Knowing that reasonable compensation isn't just a tax obligation, but a strategic financial decision, you need to be armed with expert knowledge to help your client navigate this situation. Join us to discuss IRS regulations, understand preventive measures, and address challenges within the year. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Leaders in CPA firms often spend time on work that sits below their highest and best use: meetings they do not need to attend, work delegated upward by their teams, client scope creep, administrative tasks, and avoided accountability conversations. Survey data cited in the course indicates that most leaders say yes to commitments they know they should decline, at a cost of hundreds of hours per year. This course introduces the distinction between hard work (time-bound), smart work (skills-based and intellectual), and uncomfortable work (emotional), and shows why avoided "Uncomfortable Work" is the common root of these low-value commitments. Participants complete a structured 32-item self-inventory across five categories: meetings and events, unrealistic expectations, strategies and opportunities, tasks and projects, and suboptimal performance. They then quantify the estimated annual hours lost to the commitments they identified, select one commitment to decline over the next month, and name the higher-value leadership activity (such as delegation, business development, project oversight, or performance management) that the reclaimed time will support. With the self-awareness and clarity gained through this program, you will know exactly which gaps need closing before work ramps back up. 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.

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.*

In this cutting-edge course, participants will gain a deep understanding of how to leverage ChatGPT, OpenAI's powerful language model, to innovate and enhance business advisory services in the accounting sector. The course integrates theory and practice, demonstrating how various enterprise evaluation methodologies can be applied in conjunction with ChatGPT for increased business analysis efficiency, profitability, and growth. It also provides hands-on training for implementing these techniques in real-world scenarios. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Many clients end up selling one or more residences during their lifetimes. Accounting and finance professionals must be aware of the tax rules that relate to such sales in order to assist their clients regarding these sales. This program provides accounting and finance professionals with the tax rules they need to know to help their clients when they sell a personal residence. This program is a comprehensive survey of the various tax issues associated with the sale of a residence.

This comprehensive tax update is designed to prepare the practitioner for the upcoming filing season by providing an in-depth analysis and update of the business tax provisions enacted under OBBBA and other recent business tax developments. Participants will examine statutory changes affecting corporate, pass-through, and individual business taxation, including modifications to depreciation, credits, deductions, compliance requirements, and planning strategies. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.