CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
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.
ESOPs as a Succession Strategy
-
Online
1.00 Credits
This session will provide a basic overview of Employee Stock Ownership Plans (“ESOPs”). It will specifically address what companies are well suited for establishing an ESOP, how ESOPs are implemented, and how employees and departing owners alike can benefit from them. The session is intended to provide business and tax advisors with talking points about how an ESOP may be used as a succession planning strategy.
2024 Not-for-Profit GAAP Update
-
Online
2.00 Credits
This course will review the Accounting Standard Updates issued by the FASB that impact nonprofit entities. We will also look at the work of the Not-for-Profit Advisory Committee (NAC) and the projects they are advising the FASB on.
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.
2024 Let's Meet at the Intersection of Fraud and Ethics
-
Online
4.00 Credits
This course explores actual fraud circumstances through the lens of potential prevention. We will examine how selected frauds were accomplished and consider what internal controls may have prevented fraudsters from achieving their nefarious acts. Then we will switch gears to an interactive, case-based discussion that asks participants to reach their own conclusions by analyzing facts in concert with the AICPA Code of Professional Conduct and other sources of ethical guidance. This course provides practical, action-oriented insight that can be implemented by accounting professionals in both public practice and industry.
2024 Common Deficiencies in SSARS Engagements
-
Online
4.00 Credits
Preparation, compilation and review engagements continue to be a hot topic for peer review despite SSARS 21 having been around for nearly a decade. This course will concentrate on the most common peer review findings with a focus on how to comply in an efficient but practical perspective. This course will discuss the root cause of noncompliance so that overall engagement quality increases.
Business Longevity - Is Your Business Wobbling?
-
Online
4.00 Credits
Almost 50% of businesses that started five years ago are no longer in operation today. Controllers and CFOs can and must influence the longevity of their organization to improve their success rate. Jim will help you be aware and understand the answers to these issues: Can you describe the financial health of your company? Can you also explain what the financial health of your industry is? Do you know your Business Cycle compared to the industry business cycle? Do you have an executable plan? Do you know what the competitive, legal and technological landscape is currently, and for the future? Is your organization aligned and incentivize to be successful? Jim has developed his groundbreaking Business Longevity concept as a keynote and a workshop, and would be happy to speak to your organization on this topic. This session will focus on assessment (financial health, competitive environment), determination (effective business planning, including the future landscape), and execution (gettin’ it done!)
2024 Spring Tax Review with Doug Van Der Aa
-
Online
4.00 Credits
This course will address the most recent tax legislation, rulings and developments occurring in 2023-24 that will impact both the business and individual taxpaying client. The course is designed to prepare the practitioner for the upcoming filing season and provide useful strategies to assist in the tax preparation process. **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 Annual Update for Accountants & Auditors
-
Online
8.00 Credits
This course will start with the Accounting Standard Updates effective in 2024 for public entities, private entities, and nonprofits. We'll then switch our attention to the items coming down the pike, including a look at the projects identified by the FASB's Invitation to Comment: Agenda Consultation. We'll also review year 2 considerations for leases including modification accounting. Then we will switch gears, switching to the audit side of the house. We'll review the impact of the changes to auditing group audits as well as the status of the AICPA's quality management project management. This course will keep auditors up to date on the work of the ASB.
What's New: DOL's Proposed Changes to the Salary Exemption and Best Practices
-
Online
1.00 Credits
With proposed changes to the Fair Labor Standards Act (FLSA) salary exemption pending, knowledge of employee classification becomes crucial, especially for practitioners working with small businesses. This session will provide updates and best practices to stay compliant with laws regarding exempt employees for both your practice and for your clients.
Minimizing Workplace Warfare
-
Online
1.20 Credits
This course is designed to equip HR leaders, managers and business owners with the knowledge and skills needed to effectively minimize conflicts in the workplace. Participants will learn about the various sources of workplace conflict, how to identify and address conflicts before they escalate, and how to implement effective conflict resolution strategies. The course will also cover topics such as communication skills, active listening, and conflict management techniques. By the end of the course, leaders will be able to create a more positive and productive work environment, reduce turnover, and promote employee satisfaction.
The Controllership Series - Sales, Collections and Customer Credit
-
Online
1.50 Credits
Why do for profit organizations exist??? To make money!!!!! What a great concept. But if the organization does not have the proper collections and credit procedures in place, they may not be able to access that money. Hence the importance of the credit and collection process.Credit and collections are critical areas for the financial statement controllers. Customer credit is a form of payment that allows small business customers to purchase a product or service before paying for it in full. The process works similarly to the way a credit card does - you procure something and pay it back later. Collections is a term used by a business when referring to money owed to that business by a customer. When a customer does not pay within the terms specified, the amount of the bill becomes past due and is sometimes submitted to a collection agency. The sales and collection process includes business activities related to selling products and services, maintaining customer records, billing customers, and recording payments from customers. It also includes activities necessary to manage accounts receivable, such as aging accounts and authorizing credit. This course delves into the topics that impact the sales, credit and collections process for management. We discuss strategic steps management can take to ensure their processes are efficient and that they are able to actually collect their revenue.
2024 Real Estate Professionals: Passive Activity Rules
-
Online
2.00 Credits
When do they exist and how to report them? This program will provide a detailed analysis of the real estate professional passive activity rules, including forms reporting examples, and integrates those rules with when real estate is considered a "business" under the Section 199A flow-through entity deduction. **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.
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.
Surgent's Working Remotely: Best Practices, Challenges, and Opportunities
-
Online
2.00 Credits
Working from home presents both benefits and challenges for professionals. For employees, working from home provides opportunities to be more productive and gain time that would otherwise be spent commuting to and from the office. Employers who utilize remote work enjoy fewer fixed costs, more efficiency, and greater employee satisfaction. Without proper planning, professionals who work remotely may experience increased anxiety and disorganization. They may also jeopardize data privacy. However, when executed properly, working remotely can help organizations become more efficient and profitable, while at the same time improving employee morale. This course looks at how firms and companies have successfully implemented work from home programs and discusses mistakes that can be avoided through proper planning.
Auditing For Fraud
-
Online
2.00 Credits
Auditors are required by Generally Accepted Auditing Standards to perform audit procedures to determine if the financial statements are materially misstated due to error OR FRAUD. Unfortunately, in the past the profession has focused on misstatements due to errors and largely ignored to possibility of misstatements due to fraud. While SAS No. 122, AU 240, Consideration of Fraud in a Financial Statement Audit sets forth the procedures that auditors are required to perform in each audit to determine if the financial statements are materially misstated due to fraud, this program presents a practical approach to making such a determination. It’s not a substitute for the requirements in SAS 122, AU 240, but rather an informal supplement to the standard with some common-sense procedures which are designed from my over 30 plus years of directing fraud investigations. After attending this session, you will more than likely never look at a financial statement audit the same way.
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.
Reviewing Partnership Tax Returns: What Are You Missing?
-
Online
4.00 Credits
The partnership section of the Internal Revenue Code is arguably one of the most complicated. That complexity, and the reliability of tax software to properly handle it, can create many issues for you and your staff when processing your client's LLC and partnership tax returns. Join us as we discuss the common errors practitioners make on partnership tax returns that are often missed by review staff. The intent is to sharpen skills for reviewers by examining case studies and discussing issues where additional information from the client may be warranted and areas of tax law where proper treatment requires additional analysis and information. Multiple issues will be discussed, including income, deductions, K-1 reporting, and K-2 and K-3 reporting. This course follows a highly illustrative case study format to increase participant comprehension and retention.
Clean, Transform & Load Data in Power BI
-
Online
2.00 Credits
This intensive 2-hour course is designed specifically for those aiming to master data management skills in the modern business environment. As data becomes increasingly central to accounting and financial analysis, the ability to effectively manage, clean, and transform this data is critical. This course delves into Microsoft Power Query, a potent tool within Excel and Power BI Desktop, known for its robust data processing capabilities. This course is designed to take participants from the basics of Power Query to exploring its more sophisticated features. It is an ideal blend of theoretical knowledge and practical application, centered around diverse data scenarios encountered in multiple industries. The aim is to ensure that the skills and techniques learned are universally applicable and beneficial in any professional context. Structured to be participant-focused, the course encourages active learning through a series of practical exercises, live demonstrations, and illustrative case studies. This approach not only deepens the understanding of Power Query's features but also demonstrates how to turn complex data sets into actionable insights. While the course is broad in its application, it remains detailed in its instruction, catering to both the novice and the seasoned professional. It is particularly beneficial for those who regularly interact with data, such as business analysts, project managers, and financial professionals, providing them with the tools to streamline data processes and enhance data analysis capabilities. Additionally, the course underscores best practices in data management. Participants will learn strategic approaches to data challenges, ensuring that their data processes are efficient, scalable, and sustainable. This is not just a course about mastering a tool; it's about empowering professionals with the skills to transform data into a strategic business resource. By the end of the course, participants will be equipped to leverage Power Query in Excel or Power BI desktop to its full potential, turning data into a powerful driver for business success and innovation. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Surgent's Getting Ready for Busy Season: Key Changes Every Tax Practitioner Should Know
-
Online
4.00 Credits
Getting ready for busy season involves not only knowing what's new for the current year, but also understanding how the changing limits, phaseouts and other rules apply to current-year returns. With major legislation enacted over the past few years, the present course will constitute a one-stop "shop" that brings you the essential individual tax information. In addition, this course provides an up-to-date review of important tax form changes, new tax forms, new limitations, key developments as they are reflected in the IRS forms, and IRS filing issues and deadlines that will be invaluable to attendees who prepare tax returns during busy season.This course qualifies for IRS credit.