CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
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.
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.
How Prevalent Is Retaliation Within Your Culture?
-
Online
1.00 Credits
Does your organization encourage timely reporting? Does your organization provide substantive protection for those who report? Organizations should be aware of characteristics indicative of a retaliatory culture - one in which bad actors are provided ample opportunity and cover to retaliate.
The Controller Function - Cash and Investments
-
Online
1.40 Credits
This course corresponds to our Controllership series. This course is dedicated to exploring the traditional controller role and stepping out of the box to identify areas where the controller can continue to add strategic value to their organizations. Within this segment of our controllership series, we discuss the area of cash and investments and explore how the controller can move these responsibilities into more of a strategic role. In today’s world, the role of cash management is often a pivotal role in the organization. In economically difficult times, controllers may find that they spend a great deal of their time on understanding and managing the organizations' cash position. This is certainly important and, in some areas, can be seen as a staple of the lifeblood of the organization’s ongoing viability. This course takes a look at some of the typical objectives involved in cash management and then evaluates how those objectives can be further stretched into strategic pillars of the organization.
2024 Business Tax Update for Industry
-
Online
2.00 Credits
This course focuses on the key federal tax issues affecting businesses from the internal accountant's point of view, with a focus on recent tax legislation and developments. Planning alternatives and the potential risks associated with those strategies will also be discussed. **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 2024 Office Scripts - The New Macros
-
Online
2.00 Credits
Office Scripts are an exciting new development for Excel and other applications. Although they are like macros in some respects, most users will likely find them easier to work with. Learn how to put this powerful automation tool to use!
Taxation of Business Entities
-
Online
2.00 Credits
This course will introduce you the different types of business entities and the tax implications of contributions, distributions and earnings, among other topics. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Creating a High Performance Culture - Post Pandemic
-
Online
1.00 Credits
Discuss trends and changes impacting the American workforce. Discover "why" culture matters, the "benefits" of great cultures, and the workforce challenges created both before and after the pandemic. Once the audience has clarity on these items, the presentation shifts to "how" to create a great culture in our post-pandemic environment. Jim provides practical tools that can be implemented at any organization. Some of the tools are directly related to the new challenges resulting from the COVID-driven pandemic. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Preparing to be a Forensic Accountant - Cloud Forensics
-
Online
1.50 Credits
Cloud computing has become a source of cyber-crime. “Cloud forensics is the application of digital forensics in cloud computing as a subset of network forensics to gather and preserve evidence in a way that is suitable for presentation in a court of law.” Cloud forensics is a combination of the varied types of accounting forensics including: • Digital forensics • Network forensics. • Hardware forensics In cloud crime, the cloud is considered the object when the target of the crime is the cloud service provider they are directly affected by the act. It is considered the subject of the crime when the criminal act is committed within the cloud environment. It is considered the tool when it is used to plan or conduct a crime. This course will delve into the many concepts involved in cloud forensics. The course complements other courses in the series of Becoming a Forensic Accountant.
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.
K2's 2023 Best Word, Outlook, And PowerPoint Features
-
Online
4.00 Credits
Most professionals routinely use Word, Outlook, and PowerPoint, but many are self-taught and, as a result, have not been exposed to the best features of these three applications. Consequently, they often use “brute force,” inefficient means when working with these three components of Microsoft Office. If that describes you, ensure you carve time out of your schedule to participate in this fourhour session. In it, you will learn how to work much more efficiently when using these tools to get better results in less time.
2024 Electronic Audit Evidence in Employee Benefit Plans
-
Online
2.00 Credits
A significant amount of information is electronically initiated, recorded, processed, or reported, and information to be used as audit evidence may be available only in electronic form. During this session we will look at different types of information commonly presented to an auditor during the audit of an employee benefit plan, and identify considerations for auditors when evaluating information to be used as audit evidence.
When Leadership Fails
-
Online
2.00 Credits
When the leadership in any organizations carries out their responsibilities of establishing, maintaining and monitoring internal controls, it significantly reduces the possibility of fraud occurring. When and if it does occur, a good system of internal controls will often detect it early on. This presentation is an illustration of what can happen when top management fails to carry out their responsibility of protecting an entity’s assets through a good system of internal controls.
Let's End Business Ethics
-
Online
2.00 Credits
Most ethics courses focus on unethical individuals and their terrible misdeeds. We don’t need another course on lessons from Enron or individuals committing fraud. Most unethical failures result from unethical individuals. Instead, this session will focus on how good people can do better, why there is no such thing as business ethics and why we only need one rule to lead ethical lives.
2024 Real Estate Tax Issues: Passive Activity, Self-Rental & Section 199A
-
Online
4.00 Credits
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. A detailed analysis of the self-rental passive activity rules will be given, including forms reporting examples and integrates them with the flow-through entity rules related to self-rental. **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 Advanced Excel
-
Online
8.00 Credits
If you are an experienced Excel user seeking to elevate your skills, join the K2 team for K2’s Advanced Excel. In this laptop-friendly program, you will learn critical advanced Excel skills in six key areas: 1) collaborating with other users and securing workbooks, 2) using tables to analyze and report data, 3) integrating and manipulating data from external sources, 4) creating and auditing complex formulas, 5) advanced data analysis tools, and 6) visualization techniques to analyze and communicate information. The course draws from over twenty-five years of experience delivering Excel training to accountants and other business professionals. Throughout the program, relevant, real-world examples reinforce the topics presented. Take advantage of this opportunity to become more efficient and proficient in Microsoft Office Excel, the tool of choice for accounting and financial professionals. This course covers advanced Excel topics found in Excel 2019 and newer.
2024 Public Procurement Basics: Protecting the People's Money
-
Online
2.00 Credits
Based on an AICPA Enhancing Audit Quality study, 23% of all single audits subject to enhanced oversight were materially non-conforming with professional standards due to failure to properly test controls over compliance. This course will provide an overview of internal controls over compliance specifically related to Single Audits. We will discuss how to apply the concept of internal controls to various compliance requirements. Additionally, a common finding in the audits of governmental entities receiving federal grants is misidentifying controls and mistaking compliance for a control. That's why this course will also focus on identifying compliance versus controls over compliance.
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.
What Does Fraud Look Like?
-
Online
2.00 Credits
The audit standards state that one of the reasons auditors fail to detect fraud is that they don’t know what it looks like. Prior to the original SAS No. 82, Consideration of Fraud In A Financial Statement Audit, nowhere in any SAS was there a description of what fraud looked like. So, as they say, if you don’t know what you are looking for, you can often look right at it and not recognize it! This presentation illustrates some of the more common indicators of fraud they most individuals would overlook unless they 1) knew what they were looking for and were 2) actually looking for it. Contrary to what the standards say about fraud being concealed, I have found that fraud is often laying on the table right in front of you; but no one has discovered it because they have no idea what the indicators of fraud are.
Introduction to Not-for-Profit Accounting
-
Online
2.00 Credits
Nonprofits face unique accounting challenges. This course will introduce attendees to the financial statements and unique accounting principles applicable to not-for-profit organizations. Specifically, we will focus on the typical transactions and account balances unique to NFPs, including net assets, agency transactions, contributions, endowments, and programmatic investments.