CPE Catalog & Events

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.

There is a lot of buzz and rules of thumb about Roth strategies, but very little discussion on what the fiduciary-level analysis methodology should be. This course will provide insights on creating and evaluating an analysis and recommendations with targeted vetting questions. Rules of thumb can sometimes be detrimental, causing families to pay much more in taxes over their lifetimes than necessary. A very significant portion of the population is prevented from executing a straight-forward Roth Contribution due to the income restrictions. What was once a risky way to thwart that rule has now become accepted, and many clients can benefit. These contributions should typically take precedence to saving to a brokerage/taxable account, but there are some steps that need to be addressed to prevent unwanted taxation. In addition, you'll learn about the mega-backdoor Roth. SECURE 2.0 includes many new rules, and some of them address Roth IRA/401k. We'll cover these and how they can help your clients.

Every month, a new international tax topic. Join the Hodgen Law team live with fresh insights, straight from the source. May 2026 - Planning for an Expatriation Year Tax Return; July 2026 - The Prboblem of Section 2801; September 2026 - Foreign Grantor Trusts: Taxation, Tax Compliance, and Use Cases, November 2026 - Foreign Nongrantor Trusts: Taxation, Tax Compliance, and Use Cases; January 2027 - Form 5471: Reinstatement of Sections 958(b)(4) and 951(b); March 2027 - Form 5471: Net CFC Tested Income, Section 951(A)

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.

According to a 2020 AICPA survey, advisory and consulting services were considered the greatest unmet needs of clients. The recent growth in Client Advisory Services (CAS) has led many to ask what is included in this broad category as well as how to develop the services for clients. With so much focus on the recent success of CAS offerings, now is the time to learn how the services differ from what you currently offer, which of your clients would benefit most, and what you need in place to add a quality CAS program to your firm's menu of services.

Be the go-to person on financial statement compilation and preparation engagements. Specifically designed for those performing preparation and compilation engagements, this course will provide you with a hands-on application for performing preparation and compilation engagements under AR-C Section 70 and 80, respectively. You will learn the ins and outs of relevant sections of the SSARS related to preparation and compilation engagements with a focus on how recently issued updates to SSARS No. 21 impact these engagements. More importantly, you will be provided practical examples and illustrations to help you effectively and efficiently perform those engagements, including a detailed discussion of the reporting requirements under AR-C 80 related to compilation engagement. Lastly, the course will review recent peer review feedback on these types of engagements, highlighting areas where you can improve engagement quality.

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.

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.

Budget methods are the key to allowing department managers to efficiently prepare their budget in Excel. For example, a budget method may be to spread prior year actuals or match prior year actuals, or match prior year actuals less 10%. In this webinar, we will explore how to allow users to pick a budget method from a drop-down list for each account and then have Excel perform different calculations depending on the budget method selected. We use several features and functions at the same time to pull this off. Even if you are not involved in the budgeting process, the underlying features and functions discussed have a wide range of uses.

The course provides general information on proceedings that led to a grand jury indictment of television reality stars, Todd and Julie Chrisley. Participants learn how business decisions can lead to federal charges for conspiracy, bank fraud, wire fraud, and tax evasion. The grand jury also indicted the Chrisley's accountant, Peter Tarantino, on tax-related offenses. Participants learn how to develop resources and tools for effective detection and deterrence of federal crimes, and the learn the consequences that follow white-collar crime, including how responses can influence lengthy prison terms. 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.

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.

This course explores recurring PCAOB inspection themes related to Information Technology General Controls and explains why certain ITGC audit approaches consistently raise concerns. Rather than focusing on individual deficiencies, the course examines inspection patterns tied to evidence quality, professional skepticism, control clarity, scoping decisions, SOC reliance, and reviewer judgment. Participants will gain insight into how inspectors evaluate ITGC workpapers and how recurring signals of weak documentation or unsupported assumptions increase inspection risk. Understanding these themes strengthens audit defensibility and improves overall ITGC execution. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Properly designed and effectively operating internal control over financial reporting is critical for preventing, or detecting and correcting, material misstatement. This course describes how to satisfy the audit requirements related to taking a control reliance strategy by testing the operating effectiveness of internal controls, while promoting an effective and efficient financial statement audit. 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 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.

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

Overview: Ethical challenges in finance and accounting can be complex and far-reaching, impacting not only individual careers but also entire organizations and the public trust. This webinar will provide a practical exploration of the ethical considerations professionals face in today's financial landscape. Through real-world case studies, participants will examine common ethical issues, learn to navigate conflicts between financial performance and ethical integrity, and gain tools for making sound decisions under pressure. 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.