CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Surgent's Use the Data Model to Build More Powerful PivotTables
-
Online
2.00 Credits
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.
Surgent's Excel for Accountants: Using Excel to Cleanse and Prepare Data
-
Online
2.00 Credits
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.
Surgent's Time Management for Professionals
-
Online
2.00 Credits
The phrase "time management" is misleading. No one manages time. Instead, we manage events in our lives which consume time. Like money, time is both finite and valuable; it should be budgeted and used wisely. Those individuals who "manage" or budget their time wisely often are more productive, less stressed, and able to achieve their goals more effectively than others. Professionals by nature place a high value on their time. Still, successful time management strategies vary based upon the personality, motivation, and discipline of each individual. This course provides simple, practical, and powerful techniques that help professionals work efficiently and achieve better balance in their lives. Successful time management skills also reduce the risk of burnout, which in turn improves the likelihood of achieving success in any endeavor.
Surgent's Gaining a Competitive Advantage: Critical Skills for CFOs and Controllers
-
Online
4.00 Credits
All organizations are looking for ways to gain an advantage over the competition. This practical and interactive session will present a toolkit of ideas to help CFOs, controllers and finance professionals better position their organizations for the future. We know change is occurring at an exponential rate, and that has proven to be the case in all areas of finance, management, and leadership over the past year. The course deals with these new issues and will continue to be updated as necessary throughout the year. Become the "financial hero" of your organization and make a positive impact on the bottom-line.
Surgent's Audits of 401(k) Plans: New Developments and Critical Issues
-
Online
8.00 Credits
One of the most favored employee benefit plans, the 401(k) plan, provides unique challenges for auditors. Also, as many 401(k) plan administrators opt for ERISA Section 103(a)(3)(C) audits, audits of 401(k) plans will be significantly impacted by the now-effective SAS 136, the AICPA's new employee benefit plan auditing standard. Through this course, auditors will obtain an understanding of the rules and regulations unique to employee benefit plans and obtain practical guidance on applying them. Auditors will enhance their knowledge of the performance and reporting requirements of SAS 136 through real-world examples, best practices, and efficient audit techniques that can be utilized in various audit engagements. Make sure your audits don't trigger a DOL inspection by conforming to all applicable rules and regulations.
Surgent's Fiduciary Income Tax Returns - Form 1041 Workshop with Filled-in Forms
-
Online
8.00 Credits
This course is designed as a comprehensive guide to the core concepts of trust and estate income tax preparation. The course explains the common terminology and complicated income tax rules of estates and trusts, fiduciary accounting, and an introduction to or refresher on preparing Form 1041. This practical, over 300-page manual is an excellent reference source for your practice, which begins with quite simple cases. Building upon that base throughout the manual, the course ends with two complicated preparation cases, one trust and one estate, each with filled-in forms.This course qualifies for CFP credit.This course qualifies for IRS credit.
Surgent's Individual and Financial-Planning Tax Camp
-
Online
8.00 Credits
Each year brings its own set of tax planning challenges, and this year is no exception. This course aims to arm tax planners with planning strategies and ideas that all clients, but in particular, wealthy clients, middle-income clients, and closely held business owners need to consider right now to take advantage of present opportunities and plan for future tax advantages. Learn strategies that can really have an impact on client lives, while also bringing value to you and your firm. This material is continuously updated for recent legislation impacting individual taxpayers.This course qualifies for CFP credit.This course qualifies for IRS credit.
Surgent's Securing a Comfortable Retirement in the Age of Spending
-
Online
8.00 Credits
This course gives CPAs the knowledge to help their clients plan for retirement by evaluating how much retirement income they will require and planning for how to reach their retirement goals.This course qualifies for CFP credit.
Surgent's Successful Communication
-
Online
4.00 Credits
Technology has created numerous ways for us to communicate with each other - but it's also increased the number of ways in which the message can get garbled. Effective communications skills are crucial to successful management. Learn how to control your message with clear communications strategies. You'll learn to recognize communication barriers, assess styles and behaviors, and learn how to listen more effectively as well.
Surgent's Weekly Expert Hour
-
Online
1.00 Credits
As financial and tax professionals well know, information overload is a constant struggle we face because things change quickly, and the sheer number of changes being made on a daily basis is enormous. Of great importance to small and medium tax and advisory firms is differentiating between changes that are relevant to our practice and our clients and changes that are new but totally irrelevant. Distinguishing between the two is difficult and time-consuming. Mike Tucker and a team of experts are pleased to present a weekly series designed to eliminate the clutter and get you what you need to stay up-to-date and perform for your clients. Mike and his co-presenters will dispense news on current events impacting taxes, finance, and industry. The subject matter will differ each week and intermittently include topics such as Social Security and Medicare. The panelists will discuss personal and corporate tax matters as well as other late-breaking news related to practitioners' personal finances and those of their clients. Every financial professional will benefit from this series. This is a cost-effective way for accountants to fulfill their compulsory continuing education because this weekly series will include almost 40 one-hour presentations. Sign up today - your clients and your bottom line will thank you.
Surgent's Ethics for Tax Professionals
-
Online
2.00 Credits
The purpose of this program is to discuss the ethical mandates that govern the conduct of tax practitioners. The program focuses on the ethical pronouncements of the IRS in Circular 230, as well as the preparer penalty provisions set forth in the Internal Revenue Code. Please note: This ethics course does not cover state-specific issues and so is not applicable in states that require ethics courses to include specific state laws and regulations. Please check with your state board prior to registering for this program if you are in doubt about whether this program satisfies your state's ethics requirements.This course qualifies for IRS credit.
Surgent's IRS Tax Examinations and Hot Issues
-
Online
4.00 Credits
Due to IRS issue focused examinations, Accounting and Finance Professionals need to understand what types of returns are selected for examination and ways to help clients survive an IRS audit with little or no change. As a result of issue focused examinations, Accounting and Finance Professionals must understand what the high audit risk area issues are and what the IRS is focusing on when a return is examined. In addition, because tax-related identity theft is a common issue for many taxpayers, it is critical for Accounting and Finance Professionals to understand the procedures necessary to resolve this matter for their clients.This course qualifies for IRS credit.
Surgent's Annual Accounting and Auditing Update
-
Online
8.00 Credits
Designed for accounting and attestation practitioners at all levels in both public accounting and business and industry, this course provides a comprehensive review of recent standard-setting activities of the FASB and AICPA. In addition to providing a detailed review of SAS No. 145, this course will bring you up to date on FASB and AICPA standards issued over the past few years. The course also provides many hands-on examples and illustrations to help you apply the guidance in practice. In addition to a financial accounting update, the course will discuss what you will need to do differently as you adopt new audit standards 142-149 over the next few years, including a detailed review of the new audit requirements under SAS 142. The course will also cover the key changes related to SSARS No. 25. Finally, the course reviews the AICPA's quality management project. In summary, the course is your go-to source for all things A&A and will prepare you for your upcoming engagements throughout the rest of the year.
The Best Federal Tax Update Course by Surgent
-
Online
8.00 Credits
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 course qualifies for CFP credit.This course qualifies for IRS credit.
Surgent's Comparing and Contrasting Retirement Plans for Small- and Medium-Sized Businesses
-
Online
2.00 Credits
Clients often ask their tax advisors whether they have the "best" pension plan and whether they are using it to its maximum advantage. This program explains how various pension plans work and analyzes why a small or medium-sized business owner would choose one plan over another.
Surgent's Depreciation Rules for Bonus and Section 179 Expensing
-
Online
2.00 Credits
The Tax Cuts and Jobs Act of 2017 has had a tremendous impact on commercial real estate, including liberalizing the depreciation provisions. The Coronavirus Aid, Relief, and Economic Security Act (CARES Act) included several provisions that allow taxpayers to revisit projects completed in earlier, more profitable years, and generate even more value. In this course, we will explore the impact of these important laws on commercial real estate owners and delve into what Accounting and Financial Professionals need to know. We'll also examine these opportunities to "turn back the clock," including the retroactive correction of QIP's recovery period and the option to revoke electing-out of the business interest limitation. Finally, we will review other strategies that are crucial parts of a comprehensive tax plan this year and will discuss a strategic hierarchy for employing those strategies most successfully. Relevant Rev. Procs. and multiple real-life case studies will be reviewed.This course qualifies for IRS credit.
The Best Individual Income Tax Update Course by Surgent
-
Online
8.00 Credits
This highly informative course comprehensively covers all the latest tax law developments. The focus is on individual taxation and discussion of the planning opportunities practitioners need to understand to help clients respond effectively. You will come away from the course with the up-to-date knowledge to educate your individual tax clients and implement tax-saving ideas that will serve their ever-evolving needs. This course is continually updated to reflect enacted legislation. Please Note: Due to content overlap, it is recommended that this course NOT be taken together with BFTU.This course qualifies for CFP credit.This course qualifies for IRS credit.
Surgent's Examining ASC 842, Leases: More Than Meets the Eye
-
Online
4.00 Credits
Implementing ASU No. 2016-02, Leases (Topic 842) is sure to have a major impact on your balance sheet and potentially on your business as well. This course is a one-stop shop for what you need to know about the now-effective changes to the lease accounting guidance. In this course, we will review how to measure the lease liability and right-of-use asset that will now be recorded on the balance sheet for all leases. We will also tackle the tricky issues of accounting for lease modifications and other lease remeasurement events as well as address the other major provisions of ASC 842, such as disclosures and transition. We will also review the income statement treatment of lease expense for all leases for both lessees and lessors and discuss recent FASB implementation guidance. Lastly, the course will cover all recent updates to the originally issued guidance in Topic 842, including that related to discount rates. With Topic 842's effective date here, now is the time to get up to speed on this complex new standard.
Surgent's Applying ASC 820: The Basics of Fair Value Accounting
-
Online
4.00 Credits
While once thought just to apply to banking and financial institutions, entities now need to apply fair value accounting under ASC 820 across a variety of transitions. From financial instruments to leases, business combination accounting and impairment measurement, GAAP either requires or allows the use of fair value measures in an ever-increasing number of circumstances. Now is the time for you to get up-to-speed on the basics of the fair value approach. In this course, we will review when fair value accounting is required and when an entity can select to use it. Then we will review the basics of the ASC 820 model, including the concept of "exit price," the various approaches which an entity may follow when using a fair value approach and the different levels of inputs which an entity may consider when determining fair value. Lastly, the course will provide examples on when and how to apply this complex accounting guidance.
Surgent's Auditing 401(k) Plans: Critical Issues and Annual Update
-
Online
4.00 Credits
Due to increasing scrutiny in the employee benefit plan area, it is imperative for auditors of 401(k) plans to remain up to date on the rules and regulations that may impact the audit engagement. With SAS 136, the AICPA's new employee benefit plan auditing standard, now effective, this knowledge is even more critical. In this course, auditors will enhance their knowledge by understanding the changes affecting audit procedures and reporting under SAS 136, identifying best practices, and performing efficient audit engagements.