CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Surgent's Excel: Mastering PivotTables
-
Online
2.00 Credits
PivotTable is a fancy term for an Excel report that summarizes data. If you have not yet had the good fortune of exploring PivotTables, it is about time. In this session, we'll dig into PivotTables, understand the report layout options, and examine PivotTable formulas.
2024 AICPA Regulatory Ethics Update
-
Online
2.00 Credits
The Professional Ethics Executive Committee (PEEC) of the AICPA has been very busy issuing new and updating existing ethics rules. This course will provide an overview of recently issued and soon to be effective ethics rules that CPAs in both industry and public accounting need to know to be compliant. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Audit 306: Reviewing Workpapers - A Role in Quality Control
-
Online
2.00 Credits
Reviewing Workpapers - Embracing Responsibilities for Quality Control will provide the tips and tools for satisfying important workpaper reviewer responsibilities. Audit documentation provides the principal support for an auditor's report. Therefore, it is critical for workpaper reviewers to perform quality control procedures to ensure that technical, professional, and regulatory standards are met. In addition, the workpaper review process should be used as a tool for professional development and promoting efficient audits. Note: This course is recommended as a part of a 16-hour audit skills curriculum for in-charge or supervisor auditors, while it is also appropriate for anyone who has workpaper review responsibilities. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Living to 100: The Challenges that Longevity Presents to Financial Planning for Clients
-
Online
1.00 Credits
Clients are living longer. Not only does that present challenges to the work we do with them to make sure that their money lasts, but it also brings into play additional issues and challenges that we may not have had to tackle in the past. How do we plan for where clients will live (possibly as solo agers)? How do we deal with issues of diminished capacity? How do we plan for long term care and end of life issues? How do we have complicated family conversations? How do we make sure that our clients have their best long lives possible both financially and otherwise? Find out in this session where we will present tools you can use with clients to engage them in the planning process.
Enact Retaliation Abatement and Monitoring Measures
-
Online
1.00 Credits
Once an employee decides to report an issue, the risk for retaliation must be minimized. Metrics matter. As such, capturing and reviewing employee data for indicators of possible retaliation are key to protecting those who report. The more subtle forms of retaliation, though, require a focused communication plan to address. This course offers recommendations for implementing specific retaliation monitoring protocols.
2024 Design Flexible Work Options To Attract & Retain Your Workforce
-
Online
1.00 Credits
With increasing competition for finding the best qualified candidates and retaining today’s workforce, it’s more important than ever to consider flexible work options in the workplace. We will review the most popular flexible work options your company could consider implementing: telecommuting, compressed work weeks, flexible hours, phased return from leave of absence, job sharing, early release days, and more! We’ll discuss the benefits of this talent management strategy, including increased productivity, decreased costs, better work-life “integration”, and increased employee engagement and satisfaction. You’ll learn how to propose flexible scheduling to your executive team, including how to logistically roll out this program. Whether you’re in a manufacturing plant, corporate headquarters, or retail industry, you can apply any of these flexible work options to your organization.
Online Fraud Aimed at Individuals That Can Affect a Company
-
Online
2.00 Credits
We have all heard the statement that it is the people that work at a company that gives it value. It is, sometimes and unfortunately, also the people that provide fraudsters with an entry point into an organization that can lead to hardship. This is even more true now because cyber-attacks on both organization and individuals have increased notably. Many highly publicized corporate hacking events are successful, at least in part, because an individual was targeted. In this session, we look the types of fraud that take aim at individuals with a special focus on the growth of cyber-attacks. We then discuss measures that can be put forth to help employees protect both themselves and the organization. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Power BI - Share Your Data Analysis using PowerBI.com
-
Online
2.00 Credits
This webcast is part of the 2020 Power BI Series. Please see below for the suggested viewing order. What good is data analysis if you can't share it? This webcast focuses on using Microsoft's cloud-based sharing/publishing platform, PowerBI.com. You will learn the interface as well as the benefits of using PowerBI.com. You will also learn how to use PowerBI.com to leverage the work performed in Power Pivot or Power BI Desktop. Using PowerBI.com to create visuals is very similar to Power BI Desktop, so we will only review this feature. If you want detailed instructions on creating visualizations, please attend the Power BI Desktop webcast. This class can be taken with no Excel or Power BI Desktop knowledge, but some concepts will be a repeat from those classes and will serve as a knowledge reinforcement for experienced users. Many data analysts may create models in Power Pivot or Power BI Desktop, so we will spend time focused on how to share that data with PowerBI.com. This will ensure that everyone is looking at the same data, no matter the toolset. PowerBI.com adds the ability to create and share dashboards, so we will also demonstrate how to create visualizations that can be turned into dashboards that allow users to customize their PowerBI.com with dashboards that are meaningful to them. This series is presented using Excel 2019/Office 365. Regardless of the version you are using, most concepts covered in this webcast series apply to all versions of Excel. (bold) *In order to follow along and apply concepts being taught during this session, you need to sign-up for a free PowerBI.com account at www.powerbi.com. (bold) Explore the other webcasts in the 2020 Power BI Series: Power BI - Introduction to MS Power BI Tools Power BI - Prepare Your Data Efficiently for Excel Analysis Power BI - Analyze Your Data With Excel Pivot Tables Power BI - Create Excel Dashboards for Maximum Impact Power BI - Use Power Query to Transform Your Data Power BI - Go Beyond PivotTables with Power Pivot Power BI - Use Advanced Calculations with DAX Formulas Power BI - Use PBI Desktop to Create Reports and Dashboards
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 Tax Loss Limitations Imposed on Individuals and Pass-through Entities
-
Online
3.00 Credits
Tax practitioners advising their business clients must be fully informed regarding the multiple loss limitation provisions that apply to individuals conducting businesses and pass-through entities. This program covers the loss limitation rules that tax practitioners must know in order to advise their individual and pass-through entity clients fully and adequately as to when and if a loss limitation applies. The loss limitations discussed in this program start with an introductory discussion of hobby loss rules and graduate to a more substantive discussion of the remaining loss limitations: basis limits, at-risk rules, passive loss limits, excess business loss limits, net operating losses, and the Section 163(j) interest limitation. Knowing when loss limits apply is essential for any tax practitioner. This program will put you in a position to advise clients fully and intelligently regarding each of the loss limits.This course qualifies for IRS credit.
2024 Guide to Preparing Form 1041 for Estates and Trusts
-
Online
4.00 Credits
This program examines the critical issues, rules, and special opportunities when preparing your clients' Form 1041 US Income Tax Return for Estates and Trusts. Learn what is considered taxable income; filing requirements and deadlines; impact of the 3.8 percent Medicare surtax on net investment income; and the 10 principles of tax accounting for trust income. **Please Note: If you need credit reported to the IRS for this IRS approved program, please download the IRS CE request form on the Course Materials Tab and submit to kori.herrera@acpen.com.
2024 Partnerships and S Corporations: How to Calculate Basis
-
Online
4.00 Credits
The IRS has recently increased the pressure on how to calculate and report partner and shareholder basis. Changes in the forms reflect these developments. This program provides a detailed analysis of the calculations related to determining tax basis for a partnership interest and S corporation shareholder shares and loans. How to use the Form 1065, Schedule K-1 and Form 1120S, Schedule K-1 information for basis determination. Illustrated examples with filled in forms will demonstrate how the processes works and their many potential pitfalls. **Please Note: If you need credit reported to the IRS for this IRS approved program, please download the IRS CE request form on the Course Materials Tab and submit to kori.herrera@acpen.com.
Vexing Issues Facing Not-for-Profit Accountants
-
Online
2.00 Credits
Accounting standards affecting not-for-profit (NPF) organizations have become increasingly complex, and, as a result, a great deal of confusing exists as to how to properly account for certain transactions unique to these organizations. This course will clarify proper accounting and reporting for these troubling areas. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Consulting Services Secrets
-
Online
1.00 Credits
Award winning discussion leader Mark Hugh discusses how to create and capture value with consulting services. Whether you want to consult a little or full time, this valuable course reviews identifying a specialty, growing a practice, capturing value, creating deliverables, and effective marketplace marketing strategies.
Benford's Law and Other Digital Analysis Techniques
-
Online
1.80 Credits
Numbers and especially the digits within those numbers can conceal a lot of information. Benford's Law and other digital analysis techniques can be the keys to unlocking that information. This session will explain what Benford's Law is, how it works, and how it can be used to reveal bogus information and made-up data. Accountants and auditors should understand how to use this valuable audit tool as well as other digital analysis techniques. But, if you attend this session, you must promise not to reveal the secret behind these techniques to any fraud perpetrators.
Predictive Accounting: Driver-Based Budgeting & Rolling Financial Forecasts
-
Online
2.00 Credits
The annual budgeting process is often criticized as an accounting exercise that is obsolete soon after it is published, prone to gamesmanship, cumbersome, not volume sensitive, and disconnected from the organization's strategy and risk management processes. You can resolve these deficiencies using capacity-sensitive driver-based projections. Driver-based budgeting allows for quick scenario planning and far easier analysis of a growing organization whose future may look nothing like today. The driver-based budgets can be periodically refreshed to create rolling financial forecasts extending well beyond the fiscal year end. Learn how managerial accounting can become managerial economics.
Understanding and Preventing Budget Calamities
-
Online
2.00 Credits
The budgeting process can be a time consuming and frustrating process for accountants. The constraints and pressures can lead to poor decisions in both the technical and human components. This session will cover: Understanding and Preventing Budget Calamities • Most of us lead or participate in the budget process at least annually. Inherent flaws exist in the standard budget building process that you can solved by recognizing them and committing to solutions.
Integrate ChatGPT into Your Client Advisory Services-Updated
-
Online
2.00 Credits
Two of the hottest topics in the CPA profession today are CAS (client advisory services) and ChatGPT. This course will explain how to bring these two worlds together by integrating ChatGPT and other generative AI applications into your client advisory services. John Higgins, a leading advisor to the profession on ChatGPT and a seasoned client advisor on technology based solutions, will show you how you can position your firm and yourself as a "go to" advisor on how to embrace this technology in virtually any type of business. John will address how to use this technology as a research and writing assistant in your client services and how to advise your clients on this revolutionary technology and all benefits and "gotchas" that come with it. If you want to step up your advisory game, this course is a "must take." This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
New Quality Management Standards: A Practical Approach to Risk Assessment and Response
-
Online
2.00 Credits
Create a robust QM system based upon your firm's needs (bold) Statement on Quality Management Standards (SQMS) No. 1, A Firm's System of Quality Management (ital), changes how quality management is approached, with emphasis on creating processes and policies tailored to your firm's circumstances. The new risk assessment process is a key component to identifying and evaluating the likelihood and potential impact of various risks to your firm. This webcast will offer a practical approach to risk assessment, and to determining the responses - policies and procedures - to the quality risks facing the firm.
Profitability Pricing: Boost your Bottom Line
-
Online
2.00 Credits
Two seemingly similar products can have very different costs, yet many companies are completely oblivious to these differences causing them to lose money or competitive bids. When companies compete, those with good information win the “gravy” contracts and those with bad information lose money on “dog” jobs. Attend this session to gain insights on how to win bids for the best opportunities and give the money-losers to your competitors. Achieve your target profitability in the process.