CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
2024 Governmental GAAP Update
-
Online
2.00 Credits
This course begins with a look at the GASB standards effective this year, including GASB 100, Accounting Changes and Error Corrections and GASB 101, Compensated Absences. We'll include practical application of the topics in the form of case studies.
Surgent's Excel Budgeting Ideas
-
Online
2.00 Credits
Budget methods are the key to allowing department managers to efficiently prepare their budget in Excel. For example, a budget method may be to spread prior year actuals or match prior year actuals, or match prior year actuals less 10%. In this webinar, we will explore how to allow users to pick a budget method from a drop-down list for each account and then have Excel perform different calculations depending on the budget method selected. We use several features and functions at the same time to pull this off. Even if you are not involved in the budgeting process, the underlying features and functions discussed have a wide range of uses.
Surgent's Food, Beverage, and Entertainment Expensing
-
Online
2.00 Credits
The IRS has issued final regulations regarding the Tax Cuts and Jobs Act's (TCJA) elimination of the deduction for expenditures related to entertainment, amusement, or recreational activities and provided guidance to determine whether an activity is considered to be entertainment. The final regulations also address the 50% limitation on the deduction of food and beverage expenses and when the 50% limitation does not apply. Due to the pandemic, Congress changed the rules for 2021 and 2022 to allow for 100% deductibility for meals. These temporary rules no longer applied starting in 2023. To effectively advise clients, it is imperative for tax practitioners to understand these rules and be updated on the latest IRS guidance related to meals and entertainment. This course qualifies for IRS credit.
Using ChatGPT with Excel
-
Online
2.00 Credits
In this innovative course, participants will learn to combine the power of artificial intelligence with the functionality of Microsoft Excel. You will learn how to leverage ChatGPT, OpenAI's powerful language model, to improve your Excel skills and decrease the time it takes to build spreadsheets. The course will include a quick introduction to ChatGPT but the majority of the time will be spent using ChatGPT to create an Excel spreadsheet. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
How to Get a Better Return on Financial Statement Audits - Avoiding the Most Misapplied Risk-Based Audit Concepts
-
Online
8.00 Credits
By far, the biggest contributing factor that leads to a profitable, yet high quality, financial statement audit is the proper identification, evaluation, and response to assessed risk of material misstatement. When designing your detailed audit plan, how and where you decide to spend your time is largely a matter of professional judgment. The proven tips and techniques for critically rethinking how you plan and design your audit taught in this course will help auditors enhance audit quality and manage profitability in all engagements.
Audit & Attest Quality Matters that Should be on Your Radar - Avoiding Common Deficiencies in SAS, SSARS and SSAE Engagements
-
Online
8.00 Credits
Quality management is important. Every CPA firm that provides audit and other attest services must undergo a third-party quality control review. This session will provide you with the tips on how to avoid common quality control deficiencies in all services that are subject to peer review.
Business Communication Essentials (Dynamic Communication in the Workplace)
-
Online
1.00 Credits
We know that effective communication is essential to growing a career and a business. But we often don't take time to think through, concsiously, about how we communicate and how small changes could change the trajectory of our messages. This workshop is designed to give you a survey of multiple communication strategies and mistakes to avoid. We start by discussing how people make decisions--which is important to understand in the context of business communication and communication in the workplace. We then transition into common communication mistakes and actionable tools and tactics that you can use to overcome and avoid these mishaps.
Audit 501: Personality Styles - Improving Your Interactions
-
Online
2.00 Credits
Personality Styles - Adapting to Different Types of Personalities for Improved Relationships and Interactions provides guidance for effectively adapting to various personality styles. Every individual has a dominant personality style, which includes relevant strengths and weaknesses. Effective interactions require individuals to adapt behaviors to complement, balance or counteract the traits of others. Note: This course is recommended as a part of a 8-hour audit skills curriculum for managers, while it is also appropriate for anyone who has responsibilities for interacting with others. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Coping With the Growth of Online Fraud
-
Online
4.00 Credits
Just about every company, no matter its size or the types of activities it undertakes, is at greater risk because of all the types of fraud that can be be carried out electronically. Potential perpetrators can be operating internally or externally and the scope of the damage that occurs is almost never limited to cyber-assets. While threat awareness is improving, there are still too many owners or top level executives that underestimate the scale of the issue. In this session, we delve into the types and the nature of many electronic defalcation schemes. The material then explores measures that organizations can implement to help stop these activities and add additional layers of security. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
How To Use Microsoft 365 Forms to Create Online Surveys
-
Online
1.00 Credits
When you need to create a simple survey or form to capture data online, the Microsoft 365 Forms app can be just the right solution. You can use it for simple forms such as a client information form or client service evaluation form. You can create more sophisticated forms, such as a client tax organizer. All responses can remain confidential and can be viewed in Excel format for further analysis or to prepare the form data for import into another application. This course will take you through the step-by-step process for creating, distributing, compiling and analyzing digital forms and surveys. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Talk This Way - Communication Skills for the CPA
-
Online
2.00 Credits
Have you ever met an accountant who exhibits solid technical prowess but possesses lackluster communication skills? It is not unusual to meet a savvy accountant who is a technical expert but could enhance the delivery of written and spoken words. This course is designed to help CPAs improve their written and verbal communication skills. Participants will learn how to tailor communication to their audience, with particular emphasis on techniques for crafting a message that effectively conveys technical information in an engaging manner. The course's author will share personal success tips gleaned from more than two decades of experience communicating myriad topics to a variety of audiences. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
The Controllership Series - The Financial Close Process
-
Online
1.50 Credits
A common challenge for the controller role is in closing the month-end and period-end books in preparation to issue financial statements. This duty requires precision, timing and efficiency. In today’s digital world, many organizations have access to financial accounting software that will assist with the steps in the financial close. However, even with this aid it is critical the accountant understand the various steps for the close process and how they inter-relate to other accounting processes. This course gives you an insight into the inter-relationships between many processes that impact the financial close. The closing process has traditionally been a slow one with many companies taking two weeks to close its subsidiary’s books and another two to three weeks to roll up and consolidated the results. With the introduction of technology much has been done to help accelerate that process with integrated enterprise resource planning systems and general ledger and consolidate software. Within this segment we will discuss the elements of the financial close and also important concepts to assist the controller in accelerating their close timeline. This includes addressing all functional areas of the close including payroll, invoicing, payables, inventory, cash, and the general ledger. We will also discuss important concepts of ensuring your financial close is accurate by discussing bank reconciliations, overhead allocations, bad debt reserves, unpaid wages and accruals for vacation time, account reconciliations, deprecation and overall financial statement review. Note: This course does not address utilizing technology in the financial close. Its focus is to understand the varied procedures involved in the financial close whether or not technology is utilized.
Preparing to be a Forensic Accountant - Focus on Digital Forensics
-
Online
1.80 Credits
Forensic accounting, forensic accountancy or financial forensics is the specialty practice area of accounting that investigates whether firms engage in financial reporting misconduct. Forensic accountants apply a range of skills and methods to determine whether there has been financial reporting misconduct. Financial forensic engagements may fall into several categories. For example: Economic damages calculations, whether suffered through tort or breach of contract. Post-acquisition disputes such as earnouts or breaches of warranties Bankruptcy, insolvency and reorganization Securities and tax fraud Money laundering Business valuation Computer forensics/e-discovery This session is designed to delve into further investigative procedures used including digital forensics. Future sessions will focus on computer forensics, network forensics and mobile forensics.
Streamlined Excel Reporting Series Session 4: External Data and PivotCharts
-
Online
2.00 Credits
This is part 4 of a 4 part series. This session continues the discussion about external data and digs into the details for retrieving data from other sources. We'll pull data from an Access data base using Microsoft Query. You'll learn how to retrieve data from simple text files as well, and how to prepare data for use with Excel. This webcast concludes by examining several data visualization tools in Excel, including PivotCharts.
The Leadership Skills of Tomorrow: Delegate and Listen
-
Online
2.00 Credits
Mastering two leadership skills will decrease your stress, and give you room to enjoy your career. Delegating and listening are key essential skills to hone to elevate your career. You were born with two ears and one mouth. And yet, good listeners aren't born. World-class listeners deliberately practice this skill, even when their audience is challenging. This is a skill which can be learned. Participants will gain awareness into their blind spots to listening, strategies to regain focus, how to stop interrupting, and demonstrate to their audience they are listening. How often have you said, "It would just be easier if I did this myself?" or "Nobody can do this task as well as I can, so I'll just do it myself." If this sounds like you, then it's time to start working on your delegation skills. Delegation is not only important as a means to save you time, but it is also about developing the next generation of leaders. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Business Consulting for CPAs
-
Online
4.00 Credits
Does your firm have interest in expanding its’ services beyond traditional CPA services? Do you have staff with the expertise to compete against non-CPA firms? Welcome to a course that will lead you through the maze of creating a successful Consulting Business Practice for your CPA firm. The course will help you understand: where consulting business opportunities exist, what are the firm’s professional responsibilities and most importantly how to recognize the needs of the client.
2024 Retirement Planning Issues: Where We Stand Now
-
Online
4.00 Credits
This course is designed to equip CPAs, EAs, attorneys, and tax professionals with the essential knowledge and strategies needed to navigate the latest developments. Explore innovative approaches to maximize retirement savings, discuss tax- efficient retirement plan options, and align estate planning techniques with current trends. Gain a thorough understanding of altered rules for Required Minimum Distributions (RMDs) and discover how to optimize estate plans in response to changing regulations. This update is tailored for professionals seeking practical insights in the realm of contemporary retirement planning. **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.
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.
Public Speaking and Confident Communication in Business
-
Online
1.00 Credits
No matter what role you play in your professional life, being able to command an audience--whether of one or of thousands--is an important skill. Public speaking, no matter how you slice it, is a practice that is worthy of attention. This workshop teaches you approachable strategies to improve your public speaking and presentation skills, recognizing that everyone comes with different comfort levels and experiences. There is no one-size-fits-all speaking style, and trying to force yourself into a specific presentation persona can be more harmful than helpful. Learn actionable tips to help you be more confident next time you need to take the proverbial (or literal) stage.
Surgent's Excel Shortcuts for Accountants
-
Online
2.00 Credits
This webinar presents a variety of time-saving ideas, shortcuts, and tips that are sure to boost personal productivity. We discuss better summing, address one of the biggest pitfalls that Excel users have faced over the past 25 years, present the most important keyboard shortcuts, demonstrate a better alternative to hiding rows or columns, illustrate how to quickly navigate to other workbooks and files, and demonstrate using Excel with styles.