CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Understanding Internal Control Constructs
-
Online
4.00 Credits
Organizations of all sizes often fail to successfully install needed foundational components of an internal control system. Whether large or small, entities must view policies, procedures, and all controls in a wholistic manner in order to develop a system of controls that will keep the entity on its intended course. Moreover, those that design policies and procedures benefit by knowing why control measures are necessary. This session sets forth internal control concepts and explains the importance of strong internal control policies. It provides an understanding of the interrelated nature of all controls created by any organization. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Using Microsoft Teams to Host Virtual Meetings-Updated
-
Online
1.00 Credits
One of the most important aspect of transforming your practice or business to a digital model is to know how to prioritize the applications and initiatives that you focus on and invest in. There is an abundance of "low hanging fruit" initiatives that can provide useful benefits quickly and economically. Using Microsoft Teams meeting app is a perfect example. Chances are pretty good that you are already investing in Microsoft 365 subscriptions for your office. This course will show you how to use the Microsoft 365 subscription ROI by fully utilizing the meeting app and eliminate the unnecessary cost of a separate third-party meeting app. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
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.
Building Your Own Library of Anti-fraud & Continuous Monitoring Tests
-
Online
1.00 Credits
In this course, participants will gain a broad understanding of the various anti-fraud preventive and detective tests available to practitioners and take initial steps in building their own library of tests unique to their business or industry risks. Specific discussions and examples will include vendor analysis to look for potentially improper payments around conflicts of interests, fake vendor schemes, bribery & corruption, sanctions and trade compliance, anomalous payments, segregation of duties, among other risk categories. Participants will also explore tests around customers or distributors that include margin analysis, free goods, discounts and revenue recognition. Further, we will explore employee related test to mitigate travel & entertainment expense abuses. We will also point out various online and public resources for participants to start building their own library of tests to support both reactive investigations as well as proactive prevention and detection.
Governmental Accounting 101
-
Online
2.00 Credits
Governmental Accounting 101, is a 2 hour webcast that takes the participant of a whirlwind tour of governmental accounting basics, focusing on wetting the participant’s appetite for more. This session will be the first of a series of webcasts, with each subsequent webcast delving deeper and deeper into the governmental accounting basics.
Ethics in the Real World - Living Values for Today
-
Online
2.00 Credits
Business ethics is not something “nice to do” but can mean the difference between success, failure and survival in today’s competitive environment. Being trustworthy, having consistent business principles and an outstanding reputation may provide an organization’s only long-term competitive advantage. This updated webcast outlines eight steps to create an ethical business environment including specific ways for financial professionals to make better ethical decisions moving forward.
Keys to Building an Inclusive and Culturally Competent Workplace: A Guide for HR Professionals and Business Owners
-
Online
1.80 Credits
HR Professionals are business leaders who, regardless of their level of experience, are responsible for maintaining a high level of interpersonal proficiency in their job function. The willingness to gain a genuine understanding and respect for diversity and the incorporation of a safe and inclusive environment of employees in the workplace, is a strong measure of the HR Professionals’ efficacy in this area. This training is geared towards improving and/ or elevating the HR Professionals’ knowledge of cultural competence in the workplace and what it means to truly adopt a culture of diversity and inclusivity. When HR professionals take responsibility for teaching others about the differences and benefits that multiple cultures and diverse backgrounds bring to the organization, research shows that companies are more likely to win top talent and yield improvement in customer orientation, employee satisfaction and decision making, as well as a cycle of increasing returns.
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.
Big Four Reasons Why CPAs and Consultants Are Fired
-
Online
2.00 Credits
Whether you are in public practice, a consultant, or in industry – no one wants to lose their clients or their job. But why do so many CPAs treat their clients badly? Result - the client fires that CPA. What are the four (4) leading reasons why clients fire their CPA or consultant? Why do these actions alienate clients? Agreed, some of these actions may be unintentional, but the result is the same, the client moves on. Frustrating because it takes a long time to cultivate good clients. The discussion focuses on over forty (40) recommendations to strengthen the relationship with the client, to hopefully prevent the client from moving on. You may not practice the Big Four Reasons Why CPAS are Fired, but you probably know others who do. What are the lessons learned? We will discuss proven techniques to effectively retain existing clients, keep you employed and help you gain new clients!
K2's 2024 Excel Best Practices And Features
-
Online
2.00 Credits
Excel remains a staple tool for virtually all accounting and financial professionals. In this session learn about many of the newer features in Excel, along with some you may have overlooked in the past…truly “must-see CPE!”
Personal Leadership Skills
-
Online
4.00 Credits
People skills are the most significant skills that Professionals need to develop and yet are often the last skills perfected. This course will help participants understand personality types and the successful interactions with clients, peers and family. In addition, participants will learn Neuro-linguistic programming and develop the ability to better understand nonverbal language which is key in communication. Participants will also learn techniques to enhance memory and to improve the ability to recall key facts.
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.
Excel for Staff Level 1 - What You Never Learned
-
Online
2.00 Credits
Most Staff Accountants learned Excel in college and many others learned Excel on their own, however most users never learned the important productivity tips that help them build spreadsheets more efficiently. This course will teach new and experienced users how to leverage the many productivity tools built within Excel in order to build spreadsheets with maximum effectiveness. 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 Using OneNote More And Email Less
-
Online
2.00 Credits
OneNote is a fantastic application included in your Microsoft 365 subscription. Yet, it is underutilized and misunderstood most of the time. If you genuinely want to change how you work, embrace OneNote. Stop using Outlook as a filing cabinet for essential emails and move them to OneNote instead. If you share a OneNote notebook with others, you can stop emailing altogether within your group and use OneNote as your collaboration and reference platform.
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.
Documentation Methods for Internal Control Processes
-
Online
2.00 Credits
Internal controls (IC) are critical to the effective functioning of all processes. The importance of proper and relevant documentation can be viewed as a burden. Strong, relevant documentation is critical to ensure organizations can adequately monitor, manage, and adjust their processes in line with business objectives. This requirement extends far beyond internal controls over financial reporting. Management must first establish appropriate responsibilities for IC. Personnel must have a strong understanding of the types and methods of IC and how they relate to their jobs. Controls should be well documented. Documentation methods must meet organizational needs and be sufficient for personnel to understand. This course will further evaluate the responsibilities of employees, management, and auditors in understanding their role in internal control as well as evaluating documentation methods.
Fraud & Embezzlement: Case Studies from the Trenches
-
Online
2.00 Credits
Governmental entities are the second largest victims of embezzlement. This seminar examines recent events involving theft of public money and circumstances that allowed the fraud to occur. Case studies we examine include the 2012 $54 million embezzlement from the City of Dixon by Rita Crundwell. The events that impacted the small Illinois town of 16,000 residents was the largest governmental fraud case to date, and spanned an astonishing 20 years. This remarkable story inspired an award-winning documentary, "All the Queen's Horses." We will also examine factors that led to scandals involving the Baptist Foundation of Arizona, World Com, Collin Street Bakery and the Ohio American Cancer Society, among others. This course is ideal for CPAs, government finance personnel, all Internal Auditors, lawyers, governance professionals, accountants and human resource personnel. 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 A Complete Guide to Offers in Compromise
-
Online
2.00 Credits
This course is designed to assist practitioners in preparing Offers in Compromise (OIC). After this course, you should have an understanding of how proper planning can make a significant difference in the amount eventually paid to the IRS and the resulting financial well-being of your client. This program covers the basics, from choosing the proper forms to utilize through the filing of an appeal if necessary. We will also explain how to increase your chances of having your OIC approved by the IRS by going over the complexities involved.This course qualifies for IRS credit.
Surgent's A Guide to Gig Economy Tax Issues
-
Online
2.00 Credits
The IRS defines the "gig economy" as people earning income providing on-demand work, services, or goods on either a part-time or full-time basis. The economic times we live in are changing and tax practitioners must learn how the rules apply in this new gig economy. The tax rules that apply to gig workers challenge traditional ideas of who is an employee and who is an independent contractor, and tax practitioners must have the knowledge to make this determination. This program addresses federal and state tax issues tax practitioners must address with clients and their own workers.This course qualifies for IRS credit.
Surgent's The Essential Multistate Tax Update
-
Online
4.00 Credits
With the largest overhaul of the federal income tax code in 30 years and the repeal of the physical presence nexus standards for sales tax in the Wayfair case, the states are working fast and furious to overhaul their tax laws. As some states scramble to fund their budgets, they continue to look for additional forms of revenue. Plan to attend this fast-paced class that covers developing topics in state taxation, ranging from individuals to pass-through entities to corporate taxpayers. This class will focus on issues of small and middle-market companies and offer guidance for minimizing tax liability and negotiating the treacherous waters of compliance.