CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Excel - Create KPI Dashboards for Maximum Impact
-
Online
2.00 Credits
Most accountants use Excel to help them make decisions about their data. However, as the amount of data grows, it becomes difficult to make strategic decisions based on rows and rows and columns and columns of data. In this course, you will learn how to build robust dashboards for analyzing key metrics in Excel. We will begin with some dashboard design guidelines, such as understanding your audience and identifying necessary metrics. Then, we will work through importing data, setting up calculated fields and columns, and creating key performance indicators (KPIs) for the dashboards. You will learn how you can add charts and eye-catching visuals with Power View, in order to make your dashboards easily understood. This session is presented using Excel 2013. Regardless of the version you are using, ALL concepts covered in this course apply to ALL versions of Excel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
ChatGPT: What Every CPA Should Know-Updated
-
Online
2.00 Credits
Don't look now, but ChatGPT is taking the business world, including the accounting profession, by storm. Every CPA, whether in public accounting or working in corporate, should have a fundamental understanding of ChatGPT and generative AI applications more broadly. This course will provide you with a foundation of knowledge about ChatGPT technology that will prepare you to have conversations with clients, customers, colleagues and service providers. More importantly, you will learn how to leverage ChatGPT to increase your personal productivity. If you feel your ChatGPT knowledge is lacking, that will not be the case after you attend this course, taught by John Higgins, one of the leading technology strategists and thought leaders for the accounting profession. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Top 10 Payroll Questions You Didn't Even Know You Had
-
Online
1.00 Credits
Payroll is everywhere. It is one of the most common tasks an employer can perform and can be found embedded in nearly every facet of the business and individual tax realm. For many, it is something they encounter regularly, but without any knowledge of how it really works, so it remains a black box. Join us as we un-box the Top 10 most commonly asked questions about payroll from an employer perspective. We'll cover the answers to questions you didn't even know you had and build on the fundamentals of payroll that will help make that black box a bit more transparent. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Trust Fund Recovery Penalty And Request For Refund
-
Online
1.00 Credits
You are likely familiar with the Trust Fund Recovery Penalty or TFRP, BUT - aside from appealing the proposed assessment, did you know that you can make a request to remove the TFRP by making an administrative request on Form 843 (Claim for Refund and Request for Abatement)? This program will provide an overview of the Trust Fund Recovery Penalty with an emphasis on evidence gathering and using Form 843 to prevail on the IRS as to why they should accept your request for refund, effectively undoing the TFRP. This will include what to request in a FOIA, what criteria need to be met for refund, analyzing the IRS' TFRP file, and reconciling requirements in the IRM. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Defining Where and Why Internal Controls are Needed
-
Online
2.00 Credits
Most organizations have many of the basic controls required to operate in place. However, a notable percentage of these companies do not have important measures that can help enhance security, productivity, and the quality of information available for decision making. In this session, we work to identify areas where important internal control measures are needed. We spend time explaining why these controls should be created, and show in detail some specific controls that would be beneficial if utilized. Those wishing to strengthen an internal control system should strongly consider attending this session. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
2024 Revision to Government Auditing Standards Impact
-
Online
4.00 Credits
This course will provide an update of Government Auditing Standards as a result of the GAO's issuance of the 2024 Revision to Government Auditing Standards. The course will focus on the Revisions impact on financial statement audits. The course will also focus on the impact of Quality Management Standards as well as clarify as to when the concept of reporting key audit matters might apply for financial audits. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
2024 Annual Update for Not-for-Profit Accountants & Auditors
-
Online
8.00 Credits
The Not-for-Profit Advisory Committee (NAC) has been meeting with FASB to discuss the impact of various standards on the nonprofit community. We'll look at the work of the NAC and the impact they've had. We'll then transition to the Accounting Standards Updates (ASUs) issued by the FASB that impact nonprofit entities. We'll review year 2 considerations of the leases standard. We'll also review common nonprofit deficiencies identified in peer review. Once we've wrapped up the accounting update, the course shifts to the audit side of the house with a look at what's going on at the AICPA. We'll review the impact of the changes to group audits as the changes coming down the pike for quality management. This course will keep auditors up to date on the work of the ASB. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Excel - Functions and Formula Shootout
-
Online
2.00 Credits
Are you aware there are 470+ formula functions in Excel? Do you realize that they add new functions in every major version of Excel? Did you know that Microsoft adds new functions throughout the year in the Office 365 version of Excel? Are you stuck using old or simple functions like SUM or ROUND? Do you want to expand your knowledge of the extensive function library in Excel? If these questions peak your interest in becoming an Excel function expert, this course is right up your alley. This past-paced course digs into some of the most powerful functions in Excel. Although we cannot cover 470 functions, we will look at over 20 functions that will allow you to create advanced calculations in your spreadsheets. Some examples are: VLOOKUP, IF, IFS, FORECAST, RAND, SWITCH, TEXTJOIN, UNIQUE, SUBTOTAL, IS, TEXT and more! We will also provide example files that will include all the functions used during the class. It's time to take your Excel spreadsheets to the next level. This session is presented using Excel 2019/Office 365. Most concepts covered in this course apply to all versions of Excel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Income Tax Analysis: Exploring In-Depth Concepts
-
Online
2.00 Credits
Financial statements prepared for stockholders and external users follow Generally Accepted Accounting Principles (GAAP), while tax returns adhere to the Internal Revenue Code (IRC). These frameworks differ in recognizing profitability, influencing reported income significantly. Companies often aim to minimize taxable income within legal bounds, while maintaining compliance with both financial reporting and tax regulations. - Timing Differences: Variations in income recognition and deductible expenses between GAAP and IRC create timing differences, impacting reported profitability and tax liabilities. - Deferred Tax Assets: Companies accrue deferred tax assets from overpaid taxes or carried-forward credits, which can offset future taxable income, reducing tax liabilities. - Deferred Tax Liabilities: When taxable income is less than reported income, deferred tax liabilities arise, necessitating future tax payments when temporary differences reverse. Join us to delve into these concepts, exploring how financial reporting choices and tax strategies shape a company's financial performance and compliance obligations. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Ethics Based Leadership for Women
-
Online
2.00 Credits
Glantz and Associates is pleased to offer "Ethics Based Leadership for Women," a webinar designed to empower any woman who wishes to consider the privileges, responsibilities and challenges of holding leadership positions. We believe that leadership and ethics are intrinsically connected and will explore women in leadership through an ethics-based lens. The reality is, despite women representing approximately half of our world's population, they are significantly underrepresented in the workforce and most notably in leadership positions. In fact, not only do women have to cross more hurdles to advance into leadership positions, but when they do, they are burning out at a much faster rate than their male counterparts. In this course, we will discuss both the external societal barriers as well as the internal barriers that sabotage women from moving into leadership positions. We will examine common believes ("I should be nice," "I am an imposter", etc.) as well as behaviors that can hold women back and then offer suggestions for moving forward. We will provide tools to enhance one's self-awareness, create openings for self-reflection as well as provide opportunities to take on new perspectives. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Audit 307: Client and Profitable Engagement Management
-
Online
2.00 Credits
Client and Engagement Management - Managing the Black Holes That Erode Profitability will provide guidance on how to maximize return on time spent with critical areas, such as budgeting, scheduling, client assistance, and delegation. Sound client and engagement management can influence both the effectiveness and efficiency of an audit engagement. 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 responsibilities for client and audit engagement management. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Forensic Accounting: Court Approved Methods of Proof
-
Online
4.00 Credits
How does a forensic accountant calculate financial losses? Federal courts have approved various ways to calculate losses ranging from net worth method of proof to the expenditures method. Each method of proof depends on the available facts to the forensic accountant. This presentation will focus on the various court approved methods of proof, when to use them, and how to calculate the total loss. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
IRS Highly Effective Penalty Relief Strategies
-
Online
1.00 Credits
You are likely familiar with the various forms of penalty relief (reasonable cause, administrative remedies, and first-time penalty relief), BUT can you apply this and consistently expect a favorable outcome? This program will focus on crafting a well-executed request for penalty relief, along with exploring a lesser-known option which can be employed as an effective case resolution tool. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Analyzing Financial Statements
-
Online
2.00 Credits
This course provides tools and insights into financial statement analysis - both quantitative and qualitative. We'll look not only at the three main financial statements but also dive into the MD&A and footnotes. We'll also discuss the affect of industry nuances on comparability of different analysis tools. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Excel - From a Blank Sheet to a Finished Workbook
-
Online
2.00 Credits
Have you ever opened a blank workbook in Excel and just stared at it, wondering where to begin? Or, do you spend most of your time just formatting cells to make your spreadsheet look pretty? Or, do you just wonder if there is a better way to create your spreadsheets? This course is designed to take you from a blank worksheet to a completed report. Our example will be a financial statement but you can use the knowledge gained in the course and apply it to your specific job function. You will learn to import data instead of manually entering it. Learn that you can use functions and formulas to build calculations that will eliminate the need to manually manipulate your data. Our goal is to make sure you have all the information needed to build reports without having to manually enter it every month. You will learn techniques to use your data to build your reports. This will include building formulas that are flexible with your changing data. You will learn techniques to validate your report calculations so you can improve the accuracy of your reports. You will also learn how to quickly format reports and techniques that allow you to efficiently change the format. Lastly, you will learn how PivotTables can provide a more dynamic reporting option instead of using pre-defined report formats. Obviously, we will be covering a lot of ground, so to enhance your learning experience all examples will be provided to each participant along with instructions. This will allow you to follow along and use as you apply your new knowledge to your spreadsheets. This session is presented using Excel 2019/Office 365. Regardless of the version you are using, most concepts covered in this course apply to all versions of Excel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Taking Advantage of Array Formulas in Excel
-
Online
2.00 Credits
This intensive 2-hour course is designed to unlock the potential of array formulas in Microsoft Excel. Array formulas are a vital tool in Excel for their unique ability to perform multiple calculations on one or more items within an array, making them indispensable for complex data analysis and calculations. They enable users to write fewer, more powerful formulas, leading to cleaner and more efficient spreadsheets. This course is tailored to enhance your data analysis and spreadsheet management skills by delving into the advanced aspects of array functions. Through a combination of theoretical knowledge and practical exercises, you will learn to streamline your work and improve efficiency in Excel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Understanding the New Forms K-2 and K-3
-
Online
2.00 Credits
Schedules K-2 and K-3 are promulgated by the IRS in order to standardize the reporting of foreign-related tax information for pass-through entities. Even pass-through entities that have no foreign activities, investments, or partners may have a reporting requirement. Schedules K-2 and K-3 for reporting partners' income, deductions, and credits from foreign activity are now required for passthrough returns (Form 1065, 1120-S and 8858). This requirement starts with returns with a tax year that ends in 2021. This course discusses each part of these schedules and explain these new reporting obligations in detail. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
2024 Accounting & Auditing Update for Small Businesses
-
Online
4.00 Credits
For many small businesses, the standards issued by the FASB may have little to no effect as they impact topics that do not reflect the type of transactions that these entities most frequently experience. This class will focus on the Accounting Standards Updates (ASUs) that are most likely to impact small businesses with a focus on ASUs initiated by the Private Company Council (PCC). We'll then look at alternative reporting options to GAAP including FRF for SMEs and IFRS for SMEs for entities who don't necessarily need to prepare GAAP financial statements but want to use accrual accounting. Finally, we will transition to audit standards that small business auditors will need to implement. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Audit 308: Audit Reporting and General Audit Procedures
-
Online
2.00 Credits
Audit Reporting Advanced Concepts - Understanding the Impact of General Audit Procedures on Disclosures and Audit Report Modifications will provide guidance for properly altering financial statements and audit reports for certain complex transactions and events that are often uncovered through general audit procedures, such as subsequent testing, reviewing minutes, and more. Each set of financial statements and auditor's report thereon must properly address the unique circumstances of the specific reporting entity's circumstances. 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 responsibilities for audit reporting and general audit procedures. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Payroll Essentials: Payroll Returns Done Right
-
Online
2.00 Credits
Payroll is among the most common tasks an employer undertakes in the course of running their business. At its most basic level, payroll consists of an agreement between an employer and employee related to compensation for services. Once you look under the hood, there is so much more to payroll, including various kinds of compensation, payroll taxes and required reporting on government forms. This course will provide a general introduction to the workings of the payroll returns an employer is required to file. We will cover the various types of federal and state payroll taxes, what various payroll returns an employer may need to file, how to complete the most common types of payroll returns accurately, and real-life illustrations for reconciling at year end and ensuring your payroll returns are correct. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.