CPE Catalog & Events

This course will enable practitioners to understand and apply the AICPA "clarification" auditing standards to audits of Small- and Medium-Sized Entities (SMEs). Further, this course will provide guidance on how to perform an effective, efficient and profitable audit engagement. The course is loaded with practical practice aids to help enable participants to comply with the standards. Troublesome areas as identified in peer reviews and litigation will be covered. Participants who take this course will enjoy smooth sailing in their peer reviews, guaranteed! 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 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.

How you communicate with your internal and external customer can make or break your career! We all know how to talk, but how do we make sure we are really connecting with others? This course will discuss different personality styles and demonstrate the different ways to communicate information to them. See how recognizing their personality style(s) can turn communication breakdowns into breakthroughs.

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.

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.

When auditors detect findings in Yellow Book and single audits, they do not just communicate them in some shabby little letter to management; they get reported! In this course, we will examine what types of findings get reported, how they get reported, and where they get reported! This course will take you from just checking a box and fulfilling a requirement to developing and delivering findings that make a meaningful difference to your clients.

The Inflation Reduction Act (IRA) and SECURE Act 2.0 both contained tax law changes that impact many individuals in 2025 and in later years. This program covers many of these changes as well as other tax topics that continue to impact individual income taxpayers.

Whether you are an experienced veteran or new to the industry, one of the toughest parts of being a tax practitioner is keeping up with all of the changes in tax legislation. This course takes a look at recent changes to tax law from a practitioner perspective. In this session, we will explore the nuances of virtual currency and the new Form 8300 reporting requirements.

Almost every business and individual has to file tax returns, which can be a great treasure trove of information for forensic accountants. Whether in a divorce, partnership dispute, recreating books and records, or bankruptcy proceeding, analyzing tax return information should be an initial step in uncovering income and assets. The IRS retains a large amount of information, both from taxpayers and 3rd parties who report financial transactions. This course will be your guide in gathering, analyzing, and evaluating tax return information, so that you have a full picture of the financial investigation. Your presenter is a 20 year veteran with IRS-Criminal Investigation, who used this information as a basis for his federal criminal investigations. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Attracting and retaining staff is critical to an organization's success, especially in the age of the millennial worker who will change jobs multiple times in the course of a career. This course will focus on best practices for nurturing the human element of your organization, especially millennial workers who comprise a growing percentage or the workforce. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The current economic environment has changed how organizations view their accounting operations. Your business faces challenges that could lead to valuable opportunities for streamlining through automation, outsourcing and technology. In this webcast, accounting professionals will share insights from their experiences, including 10 key tips to keep financial reporting and accounting running smoothly during times of change and turnover. This webcast is a rebroadcast from the 2024 AICPA & CIMA Not-For-Profit Industry Conference.

Cybersecurity protection is one of the most important responsibilities of every CPA professional to protect the confidentiality of sensitive client information. While there are many aspects of cybersecurity that need to be addressed, the biggest vulnerability to protect against is unauthorized access to your application login credentials. Once your login credentials are breached, the cybercriminal essentially has the keys to your data kingdom. John Higgins, a national leader in the CPA technology, will demonstrate the ease with which you can protect all of your login credentials with maximum security with minimal expense. You will leave this course prepared to deploy this state of the art security tool in your organization. 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 is designed to refresh your understanding of the critical importance of risk assessment in the audit practice. We'll briefly discuss the impact of AICPA's Clarity Project for audits and the need to update firm processes to incorporate the risk assessment standards. Participants may alternatively need to fine-tune an implementation of the risk assessment standards. These standards are designed to eliminate the connect-the-dots methodology of checklist auditing and add critical thinking back into the audit process. They remain a problem area for many firms, resulting in engagement and peer review deficiencies. This course has been updated to include a more in-depth discussion of SAS No. 145, Understanding the Entity and Its Environment and Assessing the Risks of Material Misstatement. We will break down this complex and misunderstood subject with an easy-to-understand approach.

It's essential to stay current on Form 5500 filing rules and requirements. Get a practical review of Form 5500, including 5500SF and 5500EZ. We'll discuss the changes for 2025 and how different government agencies use the form to target enforcement efforts. We'll review the related schedules, how to report late contributions, and what to do if your clients miss a filing deadline.

Participants will review how to maintain a heightened awareness of fraud with clients and gain a better understanding of how to detect fraud. This interactive workshop, designed for practitioners in small and medium-sized CPA firms, will include a lecture with generous time for questions and case studies to reinforce the concepts.

The Financial Accounting Standards Board (FASB) has issued a new accounting standard for leases. This new standard?ASC Topic 842?replaces the existing ASC Topic 840, changes the accounting for operating leases (requiring capitalization in the financial statements), and upgrades many other lease accounting and reporting aspects.

Seniors face issues that complicate return preparation and planning. For example, when should they apply for social security? How is it taxed? What if they continue to work? Will an increased standard deduction affect charitable planning? What about downsizing? How can they help children or grandchildren pay for a home or a college education? This course will help you advise your clients on these topics and more.

Transfer taxes, such as the estate and gift tax, create a drag on the accumulation of wealth over a family's generations. The government promulgated the generation-skipping transfer (GST) tax to discourage avoidance of the estate and gift tax by families. Randy Gardner explores: GST tax terminology, how the GST tax is calculated, ways to avoid the GST tax, and how to design a dynasty trust to pass property from generation to generation.

This intensive 4-hour course offers a deep dive into data modeling in Power BI, with a focus on Microsoft Excel's Power Pivot but applicable to Power BI Desktop. Designed for professionals looking to enhance their data analysis skills, the course covers the essential aspects of building robust, efficient data models. Participants will learn how to integrate different data sources, create meaningful relationships, and develop insightful metrics to drive business decisions. Participants will explore various aspects of data modeling such as establishing relationships, creating calculated columns, and understanding the intricacies of basic DAX (Data Analysis Expressions) measures. These skills are vital for anyone looking to extract meaningful insights from large and complex datasets. Attendees will be introduced to advanced concepts such as the strategic use of calculated columns versus measures, and the differentiation between explicit and implicit measures. This knowledge is crucial for developing sophisticated data models that not only provide accurate results but are also efficient in terms of performance. The course will also cover the creation and use of hierarchies and Key Performance Indicators (KPIs), essential for any robust data analysis framework. To ensure that the learning is well-rounded and applicable, the course includes practical exercises in using pivot tables within Power BI. This helps in validating and enhancing the measures and models created, ensuring they are robust and reliable for real-world application. "Build a Data Model for Analysis in Power BI" is an essential course for professionals aiming to leverage the full potential of Power BI 's data model. Whether you're looking to streamline your data analysis process, enhance your reporting capabilities, or drive insightful business decisions, this course will equip you with the necessary skills and knowledge. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Successful organizations understand the importance of effective internal controls and develop a system to stay on the intended course. Those who design policies and procedures benefit by knowing why control measures are necessary. First, we'll examine critical concepts and the importance of strong internal control policies. Then, we'll look at why standards are needed and control creation methods. Finally, discuss strategies to implement policies and procedures.