CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
K2's Accountant's Guide To QuickBooks Online
-
Online
8.00 Credits
QuickBooks Online’s (QBO) market share continues to expand, and the Cloud-based accounting platform now dominates the small business market. Yet, most accounting and financial professionals have not participated in any formal training on the Cloud-based accounting service. Thus, they are unaware of many of the tool’s available features and do not work with QuickBooks Online as efficiently and effectively as they should. This course teaches you how to set up QBO and convert QuickBooks Desktop files into a QBO instance. You will learn how to process all types of transactions, including accounts payable, accounts receivable, bank feeds, inventory, and payroll. Further, you will learn how to implement appropriate internal controls and how to capitalize on advanced features such as workflow management and management reports. Join us in this session to learn how to set up QBO properly and take full advantage of all it offers while avoiding common errors and mistakes.
K2's 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.
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.
Assessing the Real Ethics of an Organization?, featuring Joe Oringel, MBA, CPA, CIA and Don Minges, MBA
-
Online
1.00 Credits
Every organization claims to be ethical, but words and deeds do not always jibe. How do you assess the real Ethics of an organization? What are the key factors and behaviors to be aware of? Many organizations lack prescriptive policies, but is that an excuse to deviate from the spirit of doing the right thing? How can professionals abuse ‘what is right’ and circumvent policies for their personal benefit. What are some egregious examples of violating policies? How allowing exceptions invites abuse. This seminar outlines steps to gauge the ethics of an organization.
Accounting & Auditing for Cryptocurrency
-
Online
1.00 Credits
Bitcoin and crypto have been in the news recently for a variety of reasons. This course will cover the basics of accounting and auditing for cryptocurrency, including recent standard setting by the FASB as well as a look at the AICPA's Accounting for and Auditing of Digital Assets practice aid.
Financial Acumen for Today's HR Leader
-
Online
1.20 Credits
Financial Acumen for the HR Professional is a part of the series "The HR Professional's Guide to Evolving Business Strategy, Finance and Development." This course identifies how HR Professionals can increase their financial understanding to participate more effectively with management as well as understand the financial results and implications for the business.
Partnership/LLC Taxation: Understanding 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. *Please Note: If you need credit reported to the IRS for this IRS approved program, please download the IRS CE request form on the Coursw Materials Tab and submit to kori.herrera@acpen.com
Noble Leadership: An Ethical Approach
-
Online
2.00 Credits
Research tells us that leaders, supervisors and managers have more impact on an employee than does a therapist and/or life partner. Being a leader is a huge opportunity and privilege and requires introspection and personal growth. This webinar is infused with values of fairness, compassion, respect and more and will be of most value to individuals who believe that everyone, regardless of circumstance, deserve "certain general conditions that are ...equally to everyone's advantage" (John Rawls). The Noble leader believes in people. The Noble leader is curious and humble and invites challenge and feedback into his/her/ world. The Noble leader is a true believer in seeing the good in others, helping them to be their best which in turn helps the Leader grow as well. The Noble leader does not shy away from confronting bad behavior/performance in a respectful and clear way while believing in the inherent dignity of each individual This workshop based on ethical principles offers a glimpse into what it takes to become a Noble Leader and how one can journey through for increased self awareness and skill development. 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 Depreciation Rules for Bonus and Section 179 Expensing
-
Online
2.00 Credits
The Tax Cuts and Jobs Act of 2017 (TCJA) has had a tremendous impact on commercial real estate, including liberalizing the depreciation provisions. Bonus depreciation was expanded and increased from 50 to 100 percent for qualifying assets placed in service beginning after September 27, 2017, through December 31, 2022. After December 31, 2022, the deduction percentage began decreasing by 20 percent per year, fully phasing out after 2026. Bonus depreciation is now available on new and used assets. President Trump favors a permanent extension of the 2017 tax provisions, and we anticipate legislative changes in 2025 that may make the changes in depreciation permanent or extend them beyond 2025. We will be watching legislative developments closely in 2025 to determine how 2025 legislative changes impact the tax depreciation rules.This course qualifies for IRS credit.
Surgent's Succession Planning for the Small Business Owner: Finding the Exit Ramp
-
Online
4.00 Credits
The life cycle of the small business can be summed up in three segments: 1) starting the business; 2) operating the business; and 3) getting out of the business. This course focuses on getting out of the business. The most elusive element of owning a small business can be finding the proper exit strategy. This course is designed to provide the business consulting practitioner with tools and concepts to advise the small business owner and assist them in developing the right exit strategy. The course covers exit strategies related to third-party sales and succession planning within a family.This course qualifies for IRS credit.
Public Speaking Secrets That Wow Audiences
-
Online
4.00 Credits
In this course, you'll learn why being able to do public speaking well is a major advantage in becoming successful in your career. You'll learn how to write a good talk, how to present it well, and how to use your new found ability to get more clients and/or a promotion. In addition, you'll learn how to overcome your nervousness, and how to overcome stress in less than a minute.
How AI Is Automating Internal Control
-
Online
4.00 Credits
The term "artificial intelligence" (AI) has become mainstream and while most have a layperson's understanding of AI, few know the depth and breadth of this technology's capability. AI is affecting just about everything in business and in people's personal lives. The operation of an internal control system is also changing because of this incredible advancement. This session explains what AI is and how it works and then goes into detail about how it can be applied to a system of internal control. The material speaks about changes occurring in today's world as well as what's coming in the not-too-distant future. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Mastering Microsoft 365 Copilot for CPAs
-
Online
2.00 Credits
Discover how Microsoft 365 Copilot can revolutionize your daily tasks as a CPA. Dive into the specific features and functionalities of this AI-powered assistant. Learn how to leverage Copilot to enhance productivity, automate routine tasks, and improve collaboration within your team. 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 Ethical Considerations for the CPA
-
Online
4.00 Credits
CPAs today face greater challenges than ever to maintain the high ethical standards of their profession. It is vitally important that all CPAs understand their professional responsibilities related to all aspects of their job. This course, which focuses on key components of the AICPA Code of Professional Conduct, reviews a history of the CPA profession and focuses on ethical requirements that CPAs must adhere to in their everyday practice, including practical examples of potential ethical dilemmas that practitioners may encounter, particularly those related to objectivity and independence. PLEASE NOTE: THIS COURSE COVERS GENERAL ETHICS AND IS APPLICABLE IN STATES IN WHICH STATE-SPECIFIC ETHICS IS NOT REQUIRED. This course does not qualify for IRS credit.
Current Fraud Trends - Nonprofit and Government Entities
-
Online
2.00 Credits
Nonprofit entities and governmental entities have a high degree of public accountability. This course will examine the most common fraud schemes and provide multiple examples of how to prevent or detect these schemes.
2025 Single Audit Update
-
Online
2.00 Credits
This course will start with a review of the impact of the 2024 Compliance Supplement on Single Audits, as well as, the changes to the Uniform Guidance. We will also review common audit deficiencies found in Single Audits. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.This course qualifies for yellow book credit.
How Recent Auditing Standards Improve Risk-Based Audits
-
Online
4.00 Credits
Recent generally accepted auditing standards were written to improve the quality of risk-based financial statement audits, audit reporting, and required by-product communications. This course will discuss the important clarifications and enhancements intended to improve audit quality to ensure better compliance with requirements contained in the SASs. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.This course qualifies for yellow book credit.
Coaching Leaders to Handle Sensitive Employee Relations Situations
-
Online
1.20 Credits
This session provides HR Professionals with scripts for and tactics for coaching leaders in handling an array of employee relations situations with sensitivity, good judgment, and high confidence. Topics include employee complaints, personality & attitude problems, performance counseling, personal hygiene problems, disability-related performance issues, misconduct due to mental conditions. You will learn how to use a unique process, “Reset the Clock,” that prevents attorneys from taking something leaders did wrong or did not do in the past and using it to support legal challenges in the future. Liability is replaced with credibility. Lawsuits are then avoided rather than won. Financial assets are protected, morale stays high, and bad publicity is averted. HR Professionals avoid hearing from senior leaders: “You should have anticipated this” after an avoidable legal claim.
White-Collar Crime: What Every CPA Should Know
-
Online
2.00 Credits
According to the FBI, “white-collar crime is … synonymous with the full range of frauds committed by business and government professionals … characterized by deceit, concealment, or violation of trust …. The motivation behind these crimes is financial—to obtain or avoid losing money, property, or services or to secure a personal or business advantage.” CPAs can and should play a crucial role in preventing and detecting white-collar crime, as well as in prosecuting the perpetrators. This session will explore whether we are up to this challenge, heighten awareness regarding the CPA’s role as a front-line defender of the public interest, and assess whether we are deserving of the public trust we enjoy.
Using AI to Instantly Transform Ideas into Revenue Streams
-
Online
2.00 Credits
Learn practical strategies to increase revenue generation using AI-driven ideation methods. This course provides a concise overview of cutting-edge artificial intelligence tools and methodologies that enable professionals to transform innovative ideas into sustainable revenue streams. Through a practical, hands-on approach, participants will explore various AI platforms and workflows that streamline the process of creating digital assets, content, and products. The course emphasizes real-world applications and demonstrates how to leverage AI technology to diversify service offerings and generate new income sources. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.