CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Excel - Advanced Spreadsheet Troubleshooting Techniques
-
Online
2.00 Credits
Do you dread that annoying ERROR! message popping up on your spreadsheets? Tired of using the same long, elaborate formulas when you could be using the ones that are already built into Excel? Then this class is for you! In this webinar, we will focus on Debugging and Troubleshooting complex formulas. You will learn various techniques that will assist you in creating complex compound formulas. You will also learn techniques to resolve issues when you receive errors. This session will also discuss the 9 built-in error checking options and demonstrate resolution techniques. We will also review techniques to resolve rounding errors. 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.
S Corporations: Calculating Shareholder Basis
-
Online
2.00 Credits
A detailed analysis of the calculations related to determining a shareholder's tax basis for S corporation shares and loans. How to use the Form 1120S, Schedule K-1 information for basis determination. An illustrative example demonstrates how the process works, as well as the many potential pitfalls. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Microsoft Outlook "Must Know" Email Tips
-
Online
2.00 Credits
If you use Outlook on a daily basis to process your email, chances are pretty good that you are missing out on a lot of opportunities to improve your efficiency in composing, processing and organizing your messages. There are many different features in Outlook that often get overlooked, even though we are working in the app all day, every day. John Higgins, a strategic advisor to the profession on Microsoft 365 deployment, will review numerous tips and features to improve your productivity in Outlook. You will learn many time-saving, practical ways to improve the quality of your email message. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Bounded Ethicality: Exploring the Limits of Ethical Behavior
-
Online
1.00 Credits
Bounded ethicality explores the edges of ethical decision-making and the invisible borders that exist in our ethical judgment. In an entertaining and enlightening session, we will unveil surprising judgment errors we make when we face ethical dilemmas and search for the reasons behind them. We will explore areas of ethical decision-making where people consistently predict they will do the right thing but rarely do so. We will find out why people repeat stubborn errors of ethical judgment, and review steps that behavioral researchers have identified that can help us stop making these errors once and for all. We will identify ways to recognize our own errors and steps we can take to improve our ethical thinking. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Critical Thinking for Financial Professionals
-
Online
1.00 Credits
What were they thinking? Why do business leaders sometimes make horrible decisions that severely damage themselves and their organizations? It is tempting to assume that poor choices must be due to someone's incompetence, inexperience, bad character, or low intelligence. Yet, when we make a mistake ourselves, we someone rationalize it as a choice other people would make under the same circumstances. This session will discuss the common decision-making errors people make and to help you avoid making these blunders yourself. 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.
You Don't Know What You Don't Know About Microsoft Excel
-
Online
8.00 Credits
Many Excel users have received little or no formal training to help them use the ubiquitous productivity application. This session can help users that wish to improve their Excel skills to increase their productivity. The material starts by covering basic topics such as time saving tips and keyboard shortcuts and then moves to more advanced areas like conditional formatting and complex formula building. Users that find themselves looking at the spreadsheets that others design and wishing they could do as much with Excel will benefit greatly by taking this course. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Partnership/LLC Taxation: Tax Basis Capital Accounts
-
Online
2.00 Credits
This program addresses the most recent developments impacting partnerships operating as LLCs, with a focus on legislative, administrative, and tax form changes. Emphasis will be placed on partners "tax basis" capital accounts, now required for tax form reporting. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Will Your Ethics Be Burned by Burnout?
-
Online
2.00 Credits
Ethical behavior is not a destination it is a journey with twists, turns, and bumps in the road. We are faced with ethical dilemmas every day. Do I speed to make it to a meeting? Do I call in sick because I need a break? When does "helping my child with their homework" become "doing it for them"? CPAs are ethical most of the time, but staying ethical is hard. It gets harder when we are under stress. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Audit 207: Sampling - Avoiding Common Mistakes on Audits
-
Online
2.00 Credits
Sampling - Avoiding Common Mistakes on Financial Statement and Compliance Audits will describe the proper process for both attribute testing and variable sampling in financial statement and compliance audits. Sampling is an important method for determining the extent of testing controls, testing compliance, and tests of substantive details. It allows the auditor to apply procedures to less than 100% of the population yet extend results to project likely conclusions about the entire population. Note: This course is recommended as a part of a 16-hour audit skills curriculum for experienced staff auditors, while it is also appropriate for anyone who has sampling responsibilities. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Start a Forensic Accounting Practice with Confidence
-
Online
4.00 Credits
The need for a forensic accountant has grown in the last two decades, with more expected in the future. From oil well spills to divorces - from stealing trust funds to partnership disputes - forensic accountants are needed to find and calculate losses. They are financial detectives that are needed to explain the money story to attorneys, judges, and juries. If you are interested in starting a forensic accounting practice or adding on this service to your existing firm, this course is for you. In this presentation, you will know what service to provide possible clients, how to find those clients, and the cost-effective ways to start the forensic accounting practice. Your instructor has over 20 years of experience as a special agent with IRS-Criminal Investigation where he conducted investigations into tax and money laundering crimes across the globe. After his successful investigative career, he started a CPA firm from scratch that focused on forensic accounting. He shares the successes and failures in starting a forensic accounting practice, including getting the right credentials, various ways of marketing to potential clients, closing the deal with engagement letters, and delivering the service to the client. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Forgotten Managerial Accounting Tools for CPAs
-
Online
2.00 Credits
This session revisits managerial accounting techniques that you may not have considered for many years, even though they could be invaluable for CPAs in both business and public accounting. You will appreciate a fresh perspective of concepts you may not have considered since your college days. We will illustrate concepts with practical examples that you can immediately bring back to the office! This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Using e-Signature Software to Process Agreements-Updated
-
Online
2.00 Credits
Transforming your practice or business to a digital model is a journey, not a destination. There are some digital initiatives that require a great deal of time and money to deploy. There are also many "low hanging fruit" initiatives that are relatively easy and inexpensive to deploy. E-signature software is a perfect example of the latter. John Higgins, a nationally recognized leader in accounting technology, will guide you through the process of evaluating, selecting and implementing e-signature software to streamline a solution, and secure your document signing processes. You will be surprised to discover how easy it is to take your engagement letter and contract signing workflow digital. 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.
Tax Implications of Cryptocurrency
-
Online
2.00 Credits
This course presents an overview of blockchain and the tax implication of cryptocurrency transactions. The IRS has provided some recent guidance, but potentially conflicting pronouncements by other regulatory agencies have created uncertainty on reporting issues. The practitioner will be helped to understand when a taxable transaction has occurred and what reports to file to satisfy IRS requirements. We will also identify tax traps for the unwary. This information is suitable for Corporate tax and finance executives, directors, managers and staff, CPAs, Enrolled Agents, accountants, attorneys and business/financial advisors who work with and advise individuals or businesses that use or invest in cryptocurrency. All in-house and public practice professionals involved with tax compliance and planning will benefit from this timely and insightful seminar. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Deep Dive Into Common Auditing Deficiencies
-
Online
4.00 Credits
This course will review common deficiencies identified by the AICPA and state boards of accountancy. It features discussion on a variety of topics, including analytical procedures, sampling, group audits and risk assessment. We will review the areas of concern and how you can overcome them by employing best practices. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Audit 208: Audit Reporting Basics - Report Issuance Process
-
Online
2.00 Credits
Audit Reporting Fundamentals - Introducing Core Concepts in the Audited Financial Statement Drafting and Issuance Process will provide tips and techniques necessary for issuing and reporting on high-quality financial statements prepared under any applicable financial reporting framework. The ultimate objective of a financial statement audit is to issue an auditor's report. Note: This course is recommended as a part of a 16-hour audit skills curriculum for experienced staff auditors, while it is also appropriate for anyone who has responsibilities for drafting and issuing audit reports. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Common Financial Statement Disclosures
-
Online
2.00 Credits
Financial statement disclosures are important to provide the information necessary for financial statement users to make economic decisions. Disclosures further explain and clarify information provided in the basic financial statements, but also provide critical information about subsequent events, litigation risk, and other concerns. This course focuses on the most common financial statement disclosures for small- or medium-sized nonpublic entities. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Excel - Auditing Your Spreadsheets for Maximum Accuracy
-
Online
2.00 Credits
Did you know Excel has 400-500 functions depending on your version? Did you know there are 12 different function categories? Did you know you could create your own functions? After you attend this class, you will be in the know! In this webinar, we will focus on proofing and auditing your spreadsheets. You will learn how to build spreadsheets that validate the accuracy of your calculations and techniques to use the Data Validation feature to validate data entry. You will also learn techniques to cross-foot your data to ensure accuracy as well as how to use the various Excel Auditing Tools. 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.
Ethics of AI: A CPA's Guide
-
Online
2.00 Credits
The practical application of artificial intelligence (AI) in the accounting profession is spreading like wildfire with the release of powerful applications such as ChatGPT. A byproduct of this evolution is the origination of new ethical dilemmas for CPAs on how to address the use of this technology in the delivery of their services. This course, presented by John Higgins, CPA, a nationally recognized technology advisor to the profession, will provide CPAs with a practical framework for addressing the various ethical issues that can arise with the application of AI in their work. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.