CPE Catalog
Chronological events are listed below the Featured events.
We are pleased to offer live CPE seminars throughout the year. These are virtual presentations with a live instructor allowing for live interaction. These seminars are listed in the Seminars tab below.
Excel Lookups: Moving Beyond VLOOKUP Limitations
-
Online
2.00 Credits
Member Price: $99
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.
Exploring Business Valuation Fundamentals
-
Online
2.00 Credits
Member Price: $119
What makes a business valuable? Who determines value? What are the key factors that make businesses valuable? In this course, we explore the different ways to value a business. We will apply foundational valuation and corporate finance concepts to real world examples in an effort to see what makes up an investment's price.
Forms 7217 and 7203
-
Online
2.00 Credits
Member Price: $119
IRS Form 7217 is an IRS tax form required for partners receiving distributions of property from partnerships. Starting for tax years beginning in 2024, a partner who receives property from a partnership must file Form 7217 with his or her annual income tax return. Form 7217 is filed by any partner receiving a distribution of property from a partnership to report the basis of the distributed property, including any basis adjustment to such property as required by Section 732(a)(2) or (b). This new IRS form is part of the IRS's general concern regarding basis shifting in favor of high marginal tax rate related partners. Form 7217 is now required and details the types of property distributed, the aggregate basis, and the allocation of basis to the distributed property. Form 7203 is designed to assist in tracking an S corporation shareholder's stock and debt basis. Form 7203 is a significant improvement from the worksheets the IRS provided formerly and over time will serve to help partners and partnerships keep track of their stock and debt basis. The course covers the structure and organization of Form 7203 as well as how an S corporation shareholder's stock and debt basis are calculated.
Excel Tables and Conditional Summing
-
Online
2.00 Credits
Member Price: $99
In this webinar we will explore the powerful concept of splitting data from reports and dig into the mechanics that enable this technique. The key feature discussed is the Tables feature, and the key function discussed is the multiple-condition summing function. We will illustrate these items in a variety of ways, including building crosstab style reports and mapping tables.
Mastering Client Management for Accounting and Finance Professionals
-
Online
2.00 Credits
Member Price: $99
Do you want to build stronger relationships with your clients, improve client retention, and drive growth in your practice? This course delves into the essential strategies for effective client management in today's competitive landscape. Client relationships, like any relationship, can be challenging to manage. Miscommunication, differing work styles, and unrealistic expectations are some of the challenges accounting and finance professionals routinely encounter. However, when accounting clients and members of your team are on the same page, client loyalty and profitability improve while conflict is minimized. This webinar explores proven strategies to improve relationships between accounting and finance professionals and their clients.
Preparation and Compilation Engagements Under the SSARS
-
Online
4.00 Credits
Member Price: $159
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.
Taxation of Tips and Overtime Under OBBBA
-
Online
2.00 Credits
Member Price: $119
Arguably the most discussed topics to come out of the One Big Beautiful Bill Act (OBBBA) are the taxation of tips and overtime. Practitioners need to understand these provisions now, as they are effective for 2025 tax returns. This program provides practitioners with the background currently available to advise clients regarding these two important tax developments. Both employers and employees need to understand these timely changes to taxation.
Guide and Update to Compilations, Reviews, and Preparations
-
Online
4.00 Credits
Member Price: $159
Specifically designed for preparation, compilation, and review practitioners, this course provides a comprehensive review and hands-on application for performing financial statement preparation, compilation, and review engagements. You will learn the ins and outs of applying SSARS No. 21, Clarification and Recodification, as well as additional guidance related to SSARS engagements through the issuance of SSARS Nos. 22-27 by the AICPA's Accounting and Review Services Committee (ARSC). The course also reviews recent peer review feedback on SSARS engagements, providing insights on how to successfully apply this guidance. Not only will this course bring you up to date on SSARSs requirements and guidance, but more importantly, it will provide you with practical examples and illustrations to help you effectively and efficiently perform compilation, preparation, and review engagements.
A Guide to Gig Economy Tax Issues
-
Online
2.00 Credits
Member Price: $99
The IRS defines the "gig economy" as people earning income providing on-demand work, services, or goods on either a part-time or full-time basis. The economic times we live in are changing, and accounting and finance professionals must learn how the rules apply in this new gig economy. The tax rules that apply to gig workers challenge traditional ideas of who is an employee and who is an independent contractor, and accounting and finance professionals must have the knowledge to make this determination. This program addresses federal and state tax issues accounting and finance professionals must address with clients and their own workers.
Business Writing: Professional & Effective Emails
-
Online
2.00 Credits
Member Price: $99
Good writing is good business. Studies show that the average business worker receives 121 emails per day. That's a lot of emails. Are your emails effective? Are they being read? Are they professional and tone-smart? In this course, you will learn techniques and skills to get your emails to stand out and improve their effectiveness and professionalism.
Unique Tax Attributes of Different Entity Types
-
Online
2.00 Credits
Member Price: $99
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.
Employer's Handbook: Health Care, Retirement, and Fringe Benefit Tax Issues
-
Online
4.00 Credits
Member Price: $159
The employer-employee relationship strains both sides in uncertain times, and businesses need CPAs, controllers, and other advisors to provide understanding of the complex legal, tax, and health care issues associated with all aspects of employment. This course provides in-depth coverage of this critical area.
Enterprise Risk Management Concepts and Strategy for Small and Medium-Sized Companies
-
Online
4.00 Credits
Member Price: $159
The past few years have taught us that major risks can come at us from any direction and with barely a warning. All organizations operate in a risk environment, but all too often, they either don't realize it or they don't develop a strategy to deal with the risks. In this session, we will explore how risks work in both for-profit and not-for-profit organizations and how they can develop a strategy to identify, evaluate, and mitigate those risks. This program will not teach how to eliminate risks, but how to strategize how to reduce their total effect. We will liberally use case studies of both for-profit and not-for-profit companies to bridge the gap between concept and actual implementation. In each area we will explore what our experiences of the pandemic have taught us about this part of risk management.
Excel for Accountants: Using Excel to Cleanse and Prepare Data
-
Online
2.00 Credits
Member Price: $99
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.
Client Advisory Services (CAS): A Guide to the Variety of Offerings Professionals Can Provide
-
Online
2.00 Credits
Member Price: $99
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.
Preparation and Compilation Engagements Under the SSARS
-
Online
4.00 Credits
Member Price: $159
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.
Excel Budgeting Ideas
-
Online
2.00 Credits
Member Price: $99
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.
Lessons Learned From Recent Accounting Malpractice Actions
-
Online
2.00 Credits
Member Price: $119
Recent economic volatility has created added stress on accounting and finance professionals and their clients. When individuals or businesses lose money, they often blame others for their misfortune. Business disputes can sometimes lead to accounting malpractice claims. Understanding the most common types of accounting malpractice claims provides a roadmap of what not to do. This course provides a current overview of accounting malpractice litigation throughout the United States. The goal is to learn about the types of claims asserted against CPA firms and strategies to employ to avoid such claims. Reviewing malpractice claims allows us to identify patterns of behavior that may reduce litigation risk.
A Complete Guide to the Yellow Book
-
Online
8.00 Credits
Member Price: $279
A thorough understanding of the Yellow Book is essential for anyone working with governments and not-for-profits. This course provides comprehensive coverage of Yellow Book requirements while building confidence and proficiency in performing Yellow Book audits. The course uses a highly illustrative and engaging format, featuring more than 25 focused exercises designed to strengthen practical application and enhance working knowledge.
Understanding How the IRS Rewards Whistleblowers
-
Online
2.00 Credits
Member Price: $99
In 2006, Congress passed the Tax Relief and Health Care Act. Prior to the Act's passage, rewards to individuals who provided information to the IRS regarding tax fraud were capped at $10 million. The Tax Relief and Health Care Act authorized the IRS to create a Whistleblower Office dedicated to investigating, processing and recovering claims concerning the underpayment of taxes. Under the IRS' new program, whistleblowers may recover 15 to 30 percent of the amount collected provided the taxes and amounts in dispute exceed $2 million. If the whistleblower's claim does not meet these criteria, the IRS may still consider granting an award under its pre-2006 Tax Relief Act discretionary authority. Given the rapid growth of this program, practitioners should have a basic understanding of the procedure and content for IRS Whistleblower claims, both from the perspective of a claimant's potential to recover and a taxpayer's exposure to liability.