CPE Catalog & Events

Do you love PivotTables? Of course, we all do! Traditional PivotTables are incredible, but they do have limitations. If you have ever encountered one of these limitations, you'll be excited to learn that by using the Data Model as the source for PivotTables, you'll be able to bypass many of the restrictions that exist with traditional PivotTables. The data model (also referred to as Power Pivot) is included in Excel 2016+ for Windows and available as a free download for previous versions (excluding Excel for Mac). Using the data model enables you to build PivotTables that were previously not practical. If you frequently build PivotTables and would like to do more with them, you'll want to understand how to use the data model (Power Pivot) to enhance your reports. Note about Excel versions: Power Pivot is not available in all versions of Excel, including Excel for Mac. If you would like to see if Power Pivot is available in your version of Excel, visit the Microsoft site.

Accounting and finance professionals routinely encounter a broad range of legal issues while advising clients or performing routine job functions. Contract law tops the list as the most frequent issue that intersects with the accounting and finance professions. As trusted advisors, it is wise to understand the fundamentals of contract law for both personal and professional benefit. This course provides a broad overview of contract law basics geared specifically toward the accounting and finance professions. From contract formation to enforceability, this course offers an interesting look at how contract law intersects with accounting and finance. Participants should walk away with a better understanding of common issues that arise when reviewing contracts.

To many clients, CPA firms all look the same. While services and specialties may vary significantly from one firm to another, it is hard for the average person to see this by simply looking at the sign outside our office door. Is there any way to make us stand out more to the outside world? Through surveys, statistics, and examples, this course looks at how CPA firms can develop a marketing plan beyond just relying on referrals. We look at the pluses and minuses of various marketing channels, regulatory constraints, and how to measure success in the competitive financial services space.

Pass-throughs (S corporations and Partnerships) are the most popular choice of newly formed business entities. However, for years, taxpayers and their preparers have struggled to calculate, update, and maintain the pass-through entity owners" tax basis information in each investment correctly. Calculating and accounting for tax basis and adequately reporting the impact of operating and liquidating distributions for these entities are among the most frequently cited audit deficiencies. Taxpayers have also misapplied the tax rules when calculating the gain or loss from the sale of the interest. Recently, the IRS initiated enforcement initiatives designed to audit owners of pass-through entities regarding their calculations of tax basis and their tax treatment of distributions. This course will teach you how to properly account for both items for your clients who own an interest in a partnership or an S-corporation. Learn to identify the most common mistakes and errors and report these items correctly before your client is audited.

Examine significant real estate tax issues and concepts, including planning and compliance topics emphasizing tax elimination or deferral. Discuss the qualified business income deduction (Sec. 199A) as it relates to real estate investments; limited discussion of opportunity zones (Sec. 1400Z-2) relating to real estate; 1031 exchanges; home sale exclusion (IRC Sec. 121); passive activities loss rules; estate planning and gifting with real estate; and California property tax issues, updated for passage of Proposition 19 affecting parent-child transfers and transfer of assessments to a new principal residence.

The objective of this course is to train new, rusty, or returning-to-practice staff with a hands-on, pencil-pushing gold standard for preparing Form 1065. Common to advanced issues of partnerships are explored in the current course that can double as a quick and practical reference guide for tax treatment and tax preparation guidelines. Within each chapter, we illustrate various parts and areas of interest when preparing a 1065, including examples and corresponding tax forms. We bring it all together in the final two chapters with a comprehensive example that integrates and links all previous chapters. The course and instruction delivery are geared toward a basic understanding and progress to more complex issues via Surgent's "Step-by-Step" preparation guide.

In today's fast-paced environment, keeping up with the latest accounting and auditing requirements for governments and nonprofits can be challenging, but this course makes it easier! Designed to save you time and effort, this comprehensive update provides clear explanations of the most important developments affecting governments and nonprofits. Using a highly illustrative and innovative format, the course features over 25 focused exercises to strengthen your working knowledge and ensure you leave prepared to apply the latest accounting and auditing standards with confidence.

This year practitioners need to keep abreast of tax changes affecting pass-through entities used by their business clients and employers, and this enlightening course delivers that information. You will learn invaluable strategies, techniques, innovative tax-planning concepts, income-generating ideas, and other planning opportunities available to S corporations, partnerships, LLCs, and LLPs. In addition, this course will discuss current trends and emerging issues, helping practitioners stay informed about relevant and significant topics that may impact their clients. Continually updated to reflect enacted legislation.

Many of our clients are moving to one of the seven states with no personal income tax, particularly Florida and Texas. Others may maintain multiple homes with an eye toward eventually establishing residency in a state with no income tax. This course will give you practical tips for your clients seeking to establish residency in a new jurisdiction. Cash-strapped states are increasingly attempting to assess taxpayers who have declared domicile and residency elsewhere, for example in Florida, to maintain their diminishing tax base. Arm your clients with the tools needed to save money by successfully establishing domicile and residency. As a practitioner, you can't afford to be unaware of the latest issues affecting so many relocating baby boomers and others. Avoid that state audit with the information provided in this entertaining webinar.

Many business owner clients wish to minimize their Social Security and self-employment tax liabilities. This course provides accounting and finance professionals with the background to understand what kinds of income constitute self-employment income and earned income. It covers strategies that can be used to reduce clients' exposure to the self-employment tax and Social Security tax.

*** CPE SAVINGS CODES DO NOT APPLY TO STAFF TRAININGS ***Develop your soft skills in training courses that benefit both the person attending and their organization. This course is applicable for various accounting departments (i.e. audit, tax, consulting, and accounting services) but because these are universal leadership concepts, they are equally applicable to other professional business leaders. AHI soft skills training will help improve efficiency, make managers more effective with others, and increase the organization's bottom line. Also, as these courses often include other industries besides accounting, there is an opportunity to work and network with leadership professionals from other industries. Per NASBA's rules effective January 1, 2024, participants are required to be on camera and participate in the full and small group discussions to earn CPE credits for this Group Live - Virtual course. As such, please make sure you are set up properly with reliable internet (hard wired is best), a working camera, and a working microphone.

The course provides a comprehensive, hands-on, pencil pushing understanding of the preparation of both S corporation and partnership/LLC tax returns, along with the underlying laws, regulations, etc. The course uses the basic concepts underlying the two main types of business returns: 1120S and 1065 as building blocks for more complex concepts tax preparers should be aware of. The theoretical concepts get illustrated in comprehensive examples that incorporate the most up-to-date law changes and provisions.

In this continually revised course, tax advisors will be fully updated on the most recent enacted legislation and IRS guidance, as well as major trends on the horizon with a view toward planning considerations. This update course is designed for all practitioners, both those working in public accounting as well as those in private industry, who need the latest information on tax changes. Please Note: Due to content overlap, it is recommended that this course NOT be taken together with BITU.

This 4-hour program addresses the latest promulgations of FASB ASU impacting privately-held entities, AICPA SAS and selected AICPA ethics interpretations.  

Every two years, the Association of Certified Fraud Examiners releases a study that details fraud cases internationally. This comprehensive study can serve as an important tool in investigating fraud, establishing internal controls, and identifying red-flags in an audit.

This course is designed for the accounting and auditing professional who provides attestation services to closely held businesses. The course reviews recent standard-setting activities of the Financial Accounting Standards Board (FASB) and the AICPA, specifically focusing on those standards having the most significant impact on closely held non-public business entities. The course also discusses adopting the latest audit standards, including the new audit risk assessment requirements.

Pass-throughs (S corporations and Partnerships) are the most popular choice of newly formed business entities. However, for years, taxpayers and their preparers have struggled to calculate, update, and maintain the pass-through entity owners" tax basis information in each investment correctly. Calculating and accounting for tax basis and adequately reporting the impact of operating and liquidating distributions for these entities are among the most frequently cited audit deficiencies. Taxpayers have also misapplied the tax rules when calculating the gain or loss from the sale of the interest. Recently, the IRS initiated enforcement initiatives designed to audit owners of pass-through entities regarding their calculations of tax basis and their tax treatment of distributions. This course will teach you how to properly account for both items for your clients who own an interest in a partnership or an S-corporation. Learn to identify the most common mistakes and errors and report these items correctly before your client is audited.

Examine significant real estate tax issues and concepts, including planning and compliance topics emphasizing tax elimination or deferral. Discuss the qualified business income deduction (Sec. 199A) as it relates to real estate investments; limited discussion of opportunity zones (Sec. 1400Z-2) relating to real estate; 1031 exchanges; home sale exclusion (IRC Sec. 121); passive activities loss rules; estate planning and gifting with real estate; and California property tax issues, updated for passage of Proposition 19 affecting parent-child transfers and transfer of assessments to a new principal residence.

This course provides a thorough examination of qualified tuition programs (Section 529 plans), focusing on their tax treatment, planning applications, and recent legislative changes. Participants will learn how 529 plans operate, what qualifies as education expenses, and how contributions, distributions, and beneficiary changes are treated under federal law. The course explores practical planning strategies, including 529-to-Roth IRA rollovers, multigenerational "dynasty" 529 planning, grandparent-owned account considerations, and interplay with financial aid. It also addresses state-level variations, compliance issues, and common pitfalls. Using real-world scenarios, the course evaluates when 529 plans are advantageous, the limitations families may encounter, and alternative approaches to education and long-term savings. Participants will gain a clear understanding of tax benefits, penalties, strategic funding approaches, and planning opportunities for high-net-worth families as well as typical households.

With the largest overhaul of the federal income tax code in 30 years and the repeal of the physical presence nexus standards for sales tax in the Wayfair case, the states are working fast and furious to overhaul their tax laws. As some states scramble to fund their budgets, they continue to look for additional forms of revenue. Plan to attend this fast-paced class that covers developing topics in state taxation, ranging from individuals to pass-through entities to corporate taxpayers. This class will focus on issues of small and middle-market companies and offer guidance for minimizing tax liability and negotiating the treacherous waters of compliance.