CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
K2's 2023 Next Generation Excel Reporting
-
Online
8.00 Credits
New features in Excel provide tremendous opportunities to improve Excel-based operational and financial reports. For example, Data Models, Power Query, Data Analysis Expressions, Power Pivot, and many others can help you create more powerful summaries and schedules in less time than ever. Bundle these tools with some of Excel’s “legacy” features, and you have significant new opportunities to improve your Excel-based reporting environments. In this fast-paced seminar, you will learn about the importance of using Power Query to link data into Excel data models and how you can manage these data models to facilitate better and more efficient reporting. Additionally, you will learn how to incorporate Key Performance Indicators, Slicers, and Timelines into your reports to enhance the analytics and understandability of the data. Further, you will learn best practices to quickly and easily format your spreadsheets to give them a polished and professional appearance. This course should be at the top of your professional development list if you use Excel for any reporting process.
The Art of Engaging in Difficult Conversations
-
Online
2.00 Credits
Difficult conversations tend to be avoided because professionals shy away from the uncomfortable, and the fear of polarizing their relationships. Participants will learn strategies and tactics to engage in productive conversations which address challenges and deepen relationships. They will understand where and why they are avoiding having difficult conversations. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
K2's 2023 Kicking It Up A Notch With KPIs
-
Online
1.00 Credits
The adage, “what gets measured, gets managed,” has never been more true than it is today. Organizations of all kinds and sizes are creating systems and processes to categorize, track, and report on many of their operations by creating reports featuring key performance indicators (KPIs). This session will teach you about many different kinds of KPIs. Further, you will learn how to find data and use tools like Microsoft Excel and Power BI to measure performance. You will also identify the benefits and drawbacks of using KPIs in management philosophies like holacracy to make it easier for employees to know in real time where they stand.
2024 Data Analytics: Practical Insights for Today's Accountant
-
Online
2.00 Credits
This session explores tools and techniques that can enhance the efficiency and effectiveness of client engagements and business processes using data analysis tools. We will introduce some of today’s popular and software tools and examine the AICPA’s Five-step approach to incorporating data analytics into public accounting engagements.
Inventory, Expense and Payroll Fraud
-
Online
2.00 Credits
Inventory is a wonderful place to both hide fraud and commit fraud. The reasons that inventory is subject to so much fraud is the it is often very large, spread out over a large area, and many people have access to it. When there are little or no internal controls related to inventory control, you are begging employees to steal it. No with so many ways to dispose of stolen inventory via the internet, i.e., EBAY, inventory fraud is much more appealing to a lot of individuals. The more common ways to commit expense fraud and how to cover it up will also be discussed. Travel and entertainment are some of the favorite areas of committing expense fraud. In addition, payroll fraud will be discussed. Although there are many ways to commit payroll fraud, it is very easy to prevent. This presentation is designed to familiarize the participants with the many ways to commit inventory, expense and payroll fraud, how to detect it, and more importantly, how to prevent it.
Project Management: Employ Best Practices & Mindset
-
Online
2.00 Credits
Project Management is not the same as workflow management, and a project manager is more than a task master. Driving change, leading a team and managing client engagements requires a great deal of organization and planning. Successfully launching a new technology, onboarding clients, developing a new service line ... all takes more than a checklist of to-do items. You need to monitor risks and opportunities. You need to gain buy-in to drive adoption. Proper scoping and projections help keep projects on course, and not become a costly experiment that gets shoved to the back burner. Project managers are trained in analyzing the data while also managing people. In this session explore basic project management best practices and mindset to more effectively managing change in your firm.
Planning for Small Business Success
-
Online
4.00 Credits
Strategic Planning for SMEs
ChatGPT Bootcamp for CPAs with John Higgins
-
Online
4.00 Credits
ChatGPT is the fastest growing application in the history of technology with over 100 million users adopting it in within two months. It is a revolutionary technology that boosts the quality and efficiency of business processes in every industry. As "knowledge workers", CPAs and CFOs are positioned to be prime beneficiaries of this technology. This half day hands-on course will get you well on your way to becoming a ChatGPT expert. John Higgins, a nationally recognized advisor and educator on CPA technology, will guide you through the process of accessing ChatGPT and applying it to a variety of practical accounting, finance and tax scenarios. This course will catapult you to the top of the pyramid of CPAs who are knowledgeable in ChatGPT and you will be ready to put it to use in your day-to-day tasks. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Audit 201: Fraud Risk - Minimum Audit Requirements
-
Online
2.00 Credits
Fraud Risk - Complying with Minimum Audit Requirements will highlight the audit procedures most effective in identifying, assessing and responding to fraud risk. The financial statement auditor's overall responsibility is to obtain sufficient appropriate audit evidence to provide reasonable assurance as to whether the financial statements are materially misstated due to fraud or error. The difficulty is that there are inherent limitations related to detecting fraud due to deliberate schemes to conceal the intent to deceive, such as collusion. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Diversity, Inclusion, Equity & Belonging
-
Online
1.00 Credits
Many organizations unconsciously fail to exhibit diversity, inclusion and belonging. This session provides an opportunity for leaders to understand diversity language and definitions, build awareness of biases and stereotypes, recognize how our own actions protect our awareness gaps, and find a level of understanding concerning where we are and where we want to be in the future.
Contract and Procurement Fraud
-
Online
2.00 Credits
This session will focus on the most common types of fraud in the procurement and contracting arena, with a focus on fraud in construction. The session will examine fraud vulnerabilities in the four key phases of the procurement process: Presolicitation. Negotiation. Performance. Closeout and Claims. Within each phase, “red flags” will be discussed. These are the indicia of possible fraud that managers should be alert for. Also, within each phase, the most common fraud schemes will be highlighted and discussed. Finally, the session will describe the generally accepted safeguards or controls that should be established to prevent the various fraud schemes that can occur. This part of the program will make extensive use of actual fraud case studies designed to demonstrate fraud risks and fraud detection strategies.
2024 Depreciation: Guide to Capitalizing Tangible Property
-
Online
2.00 Credits
This presentation highlights the latest legislative changes affecting depreciation and capitalization rules, including inflation increases and Section 179 and 168(k) deductions. Planning and potential pitfalls will also be presented. **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.
Payroll Essentials: De-mystifying Form W-4
-
Online
2.00 Credits
With the roll out of a new Form W-4 in late 2019, the IRS made significant changes to employers' withholding and payroll reporting requirements. In addition to the myriad of changes brought about by COVID-19 legislation, carried out through the payroll function, the IRS fundamentally revamped Form W-4 for employee reporting, doing away with the concept of allowances and requiring changes to payroll administration and employee communications. Now more than ever, employers need to know that the W-4 they are working with is working to withhold income taxes correctly for their employees. In addition, it is the employer's responsibility to ensure Form W-4 is filled out correctly and accurately. Employers need to understand the nuances and requirements that come with this obligation. This course will review the Form W-4 in all its glory, including all the changes that were made to the format and substance of the form, understanding what an employer can and cannot do, and how to actually fill out the Form W-4. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
K2's 2023 Implementing Internal Controls In Quickbooks Environments
-
Online
4.00 Credits
The QuickBooks ecosystem of accounting tools remains the most widely-used set of accounting applications used by small businesses. Yet, many of these organizations struggle because of inadequate internal controls. In this seminar, you will learn options for improving internal controls in small businesses running QuickBooks Pro, Premier, Enterprise, or Online. Participate in this program to understand how you can create a robust system of internal controls in a small business environment, including businesses using QuickBooks accounting solutions. In this session, you will also learn about the four common types of internal controls and how to assess the relative condition of the internal control structure of a small business. With this background in place, the focus then shifts to discovering the opportunities to enhance internal controls in QuickBooks-based environments using features found in the application. In addition, you will learn about additional internal control procedures for situations where you cannot establish adequate controls in QuickBooks. In sum, while many believe that QuickBooks-based organizations will forever face weak internal control structures, by participating in this session, you will learn how QuickBooks-based businesses can benefit from strong internal controls.
2024 S Corporation Checkup: Key Tax Issues & Forms Reporting
-
Online
4.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, as well as an update on Schedules K-2 and K-3. An illustrative example demonstrates how the process works, as well as the 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.
K2's 2023 QuickBooks for Accountants
-
Online
8.00 Credits
The QuickBooks platform is a robust environment with features and capabilities that many users are unaware of or do not know how to utilize effectively. This course helps you get more out of QuickBooks Desktop and QuickBooks Online and resolve the issues that even experienced QuickBooks users struggle with, such as locking down prior periods. This program starts fast with a chapter covering the top issues accountants face with QuickBooks. The day continues with practical guidance and solutions designed to help accountants get the most out of QuickBooks for themselves or their clients. You will learn about issues, such as setting up a new company, configuring and customizing QuickBooks preferences, and enabling system security and password protection features. Also, you will learn how to lock down transactions in prior periods, the audit trail, customizing reports, exporting reports to Excel, and extending QuickBooks’ usefulness with tools such as the Fixed Asset Manager and Loan Manager.
Professional Skepticism
-
Online
2.00 Credits
To believe or disbelieve ... that is the question often faced by CPAs in public accounting and by accountants and financial professionals in business and industry. This workshop addresses the mindset of professional skepticism that is often required in a variety of settings. 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 Mastering the Basics of Inventory Accounting
-
Online
4.00 Credits
While many entities maintain inventory, they are often challenged when applying the complexities of inventory accounting. The goal of this course is to provide a detailed overview of inventory accounting concepts that can be applied to a variety of inventory types. The course will cover the basics of inventory capitalization, for both book and tax, as well as the basic inventory valuation methods, LIFO, FIFO, weighted average, and specific identification. Then the course will give a more detailed review of the LIFO and retail methodologies. It will cover the topics of inventory obsolescence reserves and other issues related to inventory accounting, including a discussion of how COVID-19 has impacted these accounting considerations. This course will be the one-shop stop to get you up-to-speed on the accounting for this critical, revenue-producing asset.
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.
2024 Is Activity-Based Costing the Right Tool for Your Organization?
-
Online
2.00 Credits
This session provides a refresher regarding the fundamentals of activity-based costing (ABC). We will examine theoretical concepts before exploring practical possibilities for implementing ABC. A major focus of the course will be factors to consider when determining whether this managerial accounting tool is an appropriate resource for an organization.