CPE Catalog & Events

Learn how to enhance your Excel workflows with AI in this course, "AI-Powered Excel: Leveraging AI and ChatGPT for Supercharged Productivity." Discover the various AI features built into Excel and how to use ChatGPT to create, understand and troubleshoot Excel functions and formulas. Imagine turning two-hour Excel tasks into two minutes of effort! This course will help you streamline your Excel work, research and documentation, saving you time and effort in your day-to-day tasks.

Most organizations have many of the basic controls required to operate in place. However, a notable percentage of these companies do not have important measures that can help enhance security, productivity, and the quality of information available for decision making. In this session, we work to identify areas where important internal control measures are needed. We spend time explaining why these controls should be created, and show in detail some specific controls that would be beneficial if utilized. Those wishing to strengthen an internal control system should strongly consider attending 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.

The IRS has issued final regulations regarding the Tax Cuts and Jobs Act's (TCJA) elimination of the deduction for expenditures related to entertainment, amusement, or recreational activities and provided guidance to determine whether an activity is considered to be entertainment. The final regulations also address the 50% limitation on the deduction of food and beverage expenses and when the 50% limitation does not apply. Due to the pandemic, Congress changed the rules for 2021 and 2022 to allow for 100% deductibility for meals. These temporary rules no longer applied starting in 2023. To effectively advise clients, it is imperative for tax practitioners to understand these rules and be updated on the latest IRS guidance related to meals and entertainment.

Transform your Excel skills with our comprehensive training program, designed for users at all levels seeking to master the full suite of Excel capabilities. From powerful data analysis tools like PivotTables and advanced functions such as XLOOKUP, to the nuances of Data Validations and Conditional Formatting, this course offers a deep dive into Excel's most impactful features. Whether you're streamlining complex data sets, enhancing your reporting skills, or just looking to boost your productivity, this session provides the insights and techniques you need to leverage Excel to its fullest potential, making it an indispensable tool in your professional or personal toolkit. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Seismic changes in tax legislation is currently taking place, and the well-informed tax practitioner will want to attend this two hour monthly program in order to stay abreast of these developments! Approximately one-half of the program is devoted to individual tax issues, and the remaining time is spend on business entity taxation, IRS procedure, tax legislation and other issues. Due to the changing nature of the topic, learning objectives, course descriptions and program content will vary and will be provided in more specificity closer to presentation time. This course provides a concise look at the hottest topics affecting every tax practitioner. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

ChatGPT is the fastest growing application in the history of technology with over 100 million users adopting it in within two months. It is a revolutionary technology that boosts the quality and efficiency of business processes in every industry. As "knowledge workers", CPAs and CFOs are positioned to be prime beneficiaries of this technology. This half day hands-on course will get you well on your way to becoming a ChatGPT expert. John Higgins, a nationally recognized advisor and educator on CPA technology, will guide you through the process of accessing ChatGPT and applying it to a variety of practical accounting, finance and tax scenarios. This course will catapult you to the top of the pyramid of CPAs who are knowledgeable in ChatGPT and you will be ready to put it to use in your day-to-day tasks. 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 accountants with the leading AI insights and strategies drawn from real-world experience, empirical studies, countless CPA case studies, and social media commentary. It goes beyond theory, offering practical lessons learned from the front lines of AI implementation in the business world and accounting industry. Participants will gain actionable knowledge on bridging the theory-application gap, navigating exponential technological changes, and creating secure, adaptive AI policies. By the end of the session, accountants will be equipped to leverage AI responsibly and innovatively in their roles. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

A detailed analysis of the calculations related to determining a shareholder's tax basis for S corporation shares and loans. How to use the Form 1120S, Schedule K-1 information for basis determination. An illustrative example demonstrates how the process works, as well as the many potential pitfalls. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Health savings accounts (HSAs) are an effective way for employers to provide employees with financial help so they can pay their out-of-pocket medical expenses in a tax-efficient manner. Individuals who are not participating in an employer-funded HSA may set up their own HSA to achieve the same ends. Clients often ask tax practitioners about the mechanics of HSAs and whether they are beneficial. This program is a two-hour discussion of the topic led by Roy Ramthun, who will take you through the many rules and complexities of this challenging subject.

When real property is sold for a gain, we always try to find ways to defer recognizing income so that it won't be necessary to send a check to Uncle Sam. There is a provision within the Internal Revenue Code that allows the taxpayer to defer recognition of immediate taxable gain in the year of sale known as an "installment sale." Knowing how and when to utilize this provision makes the Accounting and Finance Professionals very valuable to either their client or the entity they work for. We will also discuss recent proposals that could impact the future of this provision.

When putting together a financial plan, it is important to remember that the tax situation of the business and the individual are often intertwined. Therefore, decisions about entity type are vitally important. Practitioners need to understand not only how different entities are taxed, but also which taxes will have the greatest impact on the individual owner. In this course, we will explore when self-employment taxes apply to business income, as well as some of the lesser-known taxes that apply to flow-through entities. We will even explore when a PTE election could be helpful to a small business owner.

Working as a financial professional is an accomplishment that offers the potential for a good salary with long-term growth. Despite being a sought-after career, studies show that being overworked is the greatest source of anxiety and dissatisfaction among financial professionals. Left unchecked, a life centered exclusively around the demands of work can be both physically and emotionally detrimental. Establishing a work-life balance is difficult in any profession, yet financial professionals confront unique challenges that make this goal seem even more elusive. Technology results in being "always on," with no true time to disconnect and genuinely enjoy family, exercise, or hobbies. Lack of balance comes with costs, including poor health and lower productivity. Why are some professionals able to establish a successful balance between career demands and family while others are not? How are some firms able to achieve both high employee satisfaction and strong productivity? This webinar looks at research, surveys, and simple anecdotal information to provide a better understanding of how to achieve a realistic work-life balance in the modern world. We also discuss the tax consequences that arise when professionals seek balance by working from home in one state while their employer is located in a different state.

Many leaders in business organizations of all sizes view the system of Internal Control almost purely as a protective security measure. A well-designed internal control system can and will drive all entity objectives which includes successful operations. This session uses information gathered from years of creating internal control systems as well as concepts from well-respected authoritative pronouncements and frameworks to illustrate the power of a strong and well supported control system as well as actions that can help establish such a system. Those that work with internal controls who are tasked with developing ways to improve operation level capabilities should strongly consider 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.

Strategies to help return reviewers quickly identify common errors that practitioners make on individual tax returns.

This session is designed as a primer to introduce artificial intelligence (AI) and to discuss how it will impact accountants as they work. The material will briefly explain what AI is and then focus on ways that it is already serving those in the accounting realm. It will close with a look at future AI-centric developments that will have great potential to positively impact the accounting profession. Those wishing to gain an understanding of what artificial intelligence is and how it will be used by accountants should consider attending 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.

Cryptocurrency is heading mainstream. According to a recent study conducted by New York Digital Investment Group, there are 46 million bitcoin holders in the US, and institutions have also shown increased interest in this space. The rising popularity of cryptocurrency and the inclusion of the virtual currency question on the front and center of Form 1040 have made cryptocurrency a subject that tax practitioners cannot afford to ignore anymore. This course is designed to walk you through tax implications of common cryptocurrency-related transactions (trading, mining, spending, staking, etc.) and how to successfully service clients affiliated with cryptocurrency by using a tool like CoinTracker. This session also covers current developments surrounding this topic and some of the unique tax planning opportunities in the crypto space such as tax loss harvesting without being subject to wash sale rules, tax lot ID optimization (FIFO, LIFO, and HIFO), self-directed IRAs, etc.

Unlock the full potential of Microsoft Excel PivotTables with this comprehensive course. This training is designed to equip participants with the skills to effectively analyze and summarize data, transforming raw numbers into actionable insights. Whether you're a seasoned professional or new to data analysis, this course provides an in-depth understanding of PivotTables and their capabilities, helping you uncover patterns, compare data, and make informed decisions. The program includes a step-by-step approach to creating and customizing PivotTables, focusing on how to use them to analyze data efficiently. Participants will learn how to group and filter data, identify trends, and apply advanced features to solve real-world business challenges. Beyond technical knowledge, this course introduces data visualization through PivotCharts, teaching participants how to present their analysis effectively to stakeholders. By the end of the course, you'll not only master PivotTable fundamentals but also gain advanced techniques to streamline data analysis and support strategic decision-making in any context. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Freelance work and other non-permanent employment arrangements are becoming increasingly popular ways for people to earn a living. Although these non-traditional activities offer novel, flexible ways to earn income from diverse sources, they also introduce nuanced recordkeeping, reporting, and attestation issues. We investigate characteristics of the gig economy, employee-versus-contractor considerations, bookkeeping, regulatory compliance, and external reporting considerations. We also explore best practices for CPAs who fulfill the role of trusted advisor for gig economy clients. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

For each digital asset sale that a broker has affected for a customer in 2025, the broker must complete Form 1099-DA. A broker includes any person who, in the ordinary course of a trade or business, stands ready to affect sales of digital assets to be made by others. This program covers the required rules for reporting digital asset transactions on Form 1099-DA.

An advanced guide to prompting techniques that maximize AI efficiency and precision in everyday business research, operational due diligence and accounting tasks. Designed for accountants with no prior AI knowledge, the session explores how simple language and strategic prompting can unlock powerful, layered responses from large language models (LLMs). Participants will learn to overcome the "lazy" defaults of AI, using specific techniques to enhance detail, accuracy, and contextual understanding in their queries. By understanding prompt engineering's role, attendees will discover how to guide AI to provide practical, relevant, and analytical insights suited to complex financial scenarios, without needing extensive technical expertise. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.