CPE Catalog & Events

Many people that use Microsoft Excel know a great deal about the functionality of the application. There are, however, a tremendous number of hidden tools that a high percentage of users overlook. Additionally, there are newer features that some have not had the opportunity to explore. This session shows some of the numerous time-saving tools and features that often go unused by spreadsheet creators. People that wish to become more efficient when using Excel should take 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.

Manage distractions, decrease stress and improve productivity. This training is designed to help business professionals improve their productivity and work performance by learning how to prioritize time, decrease distractions and lower stress. 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.

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.

Thsi course provides a comprehensive overview of Written Information Security Plans (WISP), focusing on their purpose, requirements, and implentation. All PTIN holders must certify they have a WISP prior to renewal, along with certifying the training of employees, staff and contractors as necessary. Participants will explore the history and legal foundation of WISP under the Gramm-Leach-Bliley Act, and how compliances is enforsed through IRS Circular 230, AICPA Statments of Standards, The American Bar Associations and the Federal Trade Commission (FTC). This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Forensic accounting encompasses fraud investigation and prevention, as well as a wide variety of functions in litigation. Forensic accountants provide services ranging from serving as an expert witness, to litigation consultant and bankruptcy trustee. As our economy grows more complex, the need for forensic accountants grows as well. One critical role of the forensic accountant is exposing and examining financial fraud. Technology expands the way companies conduct business; however, technology also provides greater opportunities for those willing to commit fraud. Forensic accountants rely on their skills in accounting, coupled with their investigative skills, to explain to clients, courts, and jurors how fraudulent schemes occur and the effect caused by fraud. Forensic accountants also provide expert opinions in calculating damages in litigation and administering bankruptcy estates, as well as a host of other services.

In high demand - forensic accounting knowledge and skills (bold) Forensic accounting has been a rapidly growing part of the accounting profession for some time. The rapid expansion in technology and growth in various sectors of business and industry, and the increase in complexity of white-collar crimes, all contribute to this growth. A diverse range of clients, as well as cases involving all types of fraud, make this an attractive profession, and one that is always in high demand. Enhance your knowledge and skills with our Forensic Accounting: Fraud Investigations webcast. Whether you're a forensic accountant, or an aspiring one, this webcast will provide you with the foundational knowledge to successfully identify, investigate, and communicate your findings. You will also receive a copy of the AICPA's Forensic & Litigation Service's Forensic Accounting — Fraud Investigations practice aid for future reference.

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.

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

When we leave our jobs, we also leave the protection our employer provides us with regards to internet and Wi-Fi security. Hired people may be able to help with the newest applications, but they may not understand the security risks posed. This session will cover some basic information about cybersecurity weaknesses and some of the scams that target older, retired people. Many times, the perpetrator is someone close and someone who we think we can trust. In this course, you will learn some basic tools to protect against those who wish to perpetrate fraud.

This course explores provisions of Statements on Standards for Accounting and Review Engagements (SSARS) that govern review, compilation, and preparation engagements. Participants will recall foundational concepts, examine recent updates, understand practitioner responsibilities, and apply best practices for engagement performance. Attendees will learn how to efficiently perform SSARS engagements while complying with professional requirements. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

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.

This course examines how agentic AI is revolutionizing tax compliance, planning, and advisory services. Participants will explore real-world deployments by leading firms such as EY, which has developed agents that handle millions of global tax transactions. The course also delves into cross-border compliance issues, transfer pricing automation, and emerging advisory models powered by agent-led simulations. Risks related to bias, unauthorized practice, and data privacy will be addressed, with guidance on aligning autonomous operations with professional and regulatory standards. CPAs must understand these advancements to ensure tax compliance, manage client expectations, and mitigate professional liability risks when providing agent-assisted advisory services.

This course provides a focused update on major recent pronouncements issued by the Governmental Accounting Standards Board (GASB). Coverage includes GASB Statement No. 103 (financial reporting model), GASB Statement No. 104 (disclosures for capital assets), and GASB Statement No. 105 (subsequent events). Participants will also receive a high-level overview of active GASB exposure drafts and ongoing projects. The course is designed to help auditors, preparers, and financial leaders understand how these developments affect audits, financial statement preparation, and board reporting. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The enforceability of non-compete agreements in the U.S. is in flux. While the FTC's proposed ban is on hold pending legal proceedings, existing state laws continue to govern the validity of non-compete clauses. Some states, like California, Oklahoma, and North Dakota, prohibit non-compete agreements, while others enforce them under certain conditions. Although state laws vary, non-competes are often used to protect the creation and development of corporate goodwill, customer relationships, and specialized training, among others. Today, employees are more likely to be asked to sign non-compete agreements as a condition of employment. Non-compete agreements are also a common component of a business sale agreement. This program surveys non-compete agreements from all angles, including the current state of play regarding the usefulness and enforceability of agreements going forward. Whether you advise individual clients or work for an employer, this course provides an understanding of common issues that arise in the negotiation and enforcement of non-competes.

The Quality Management Suite of Standards was required to be implemented by December 15, 2025. The standards modernize the firm's approach to quality to reflect an increased focus on risk assessment, technology use, and the presence of outside experts on many engagements. Beginning with performing a risk-based approach, the standards provide accounting firms with the ability to enhance their quality control by shifting their focus to a proactive approach (management) from a reactive approach (control). The results of the firm's risk assessment will form the basis of its new Quality Management document. This is not just a tweak of the old document but a more robust document that adds new requirements from the new standards. We will cover how to perform a risk assessment, including the key provisions of the standards, and how to effectively implement a monitoring plan. We will also review how the firm will evaluate its System of Quality Management beginning in 2026.

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 course provides a comprehensive exploration of cost segregation studies from both technical and compliance perspectives, emphasizing what truly distinguishes a high-quality, IRS-defensible report. Drawing from the IRS Cost Segregation Audit Techniques Guide (ATG) and the instructor's experience as a former IRS engineer and Cost Segregation subject matter expert. Participants will gain practical understanding of how to evaluate, perform, and document cost segregation studies. Topics include the fundamentals of cost segregation and depreciation methods, the differences between Section 1245 and 1250 property, and the importance of accurate cost allocations, engineering documentation, and supportable estimates. The course also covers the principal elements of a well-prepared report, common pitfalls that trigger IRS scrutiny, and practical remedies to strengthen study credibility and audit resilience. By the end of this session, tax professionals, engineers, and financial advisors will be equipped to recognize the hallmarks of a quality cost segregation study and avoid costly mistakes in the process. 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 now built into software that CPA firms already use, and the pressure to have a position on it keeps rising. For most small and midsize firms the question is not whether these tools matter, but how to engage with them on terms that fit a practice built on trust, confidentiality, and professional judgment. This course makes an evidence-based case that professional skepticism is an asset in technology decisions, provided it is aimed at the right target. Drawing on research in trust calibration, human and AI decision making, cognitive offloading, and professional identity, it examines why experienced professionals discount sound algorithmic advice, what that discounting costs in accuracy, and where reasonable caution turns into accidental delay. Participants locate their firm on the AI Trust and Usage Quadrant, apply five trust questions to vendor claims, and review bounded first steps designed to protect independent judgment during a pilot. The course is vendor neutral and recommends no product. 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.