Professional Development and Event Catalog

*** This subscription includes five individual sessions for a total of 14 CPE. You receive significant savings when purchasing these webinars as a subscription. Each of the five courses runs live once a month beginning May 1, 2024 through April 30, 2025. Register for these scheduled courses as your schedule allows - at no extra cost to you. Once registered for this subscription, log in instructions will be emailed to you separately for each individual course. *** This advanced Power BI series is designed specifically for those aiming to master data analysis 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. These five courses delve into Microsoft Power BI, a tool known for its robust data processing capabilities. After learning how to build a data model in the previous series, this series will take you through using advanced calculations to create, manage and effectively use your data analysis. This is an advanced subscription and if you are new to Power BI or not confident using the tool, consider taking the basic series, "Getting Started With Microsoft Power BI".

Transform your Excel skills with our comprehensive training program, designed for users at all levels seeking to master the full suite of Excel capabilities. From powerful data analysis tools like PivotTables and advanced functions such as XLOOKUP, to the nuances of Data Validations and Conditional Formatting, this course offers a deep dive into Excel's most impactful features. Whether you're streamlining complex data sets, enhancing your reporting skills, or just looking to boost your productivity, this session provides the insights and techniques you need to leverage Excel to its fullest potential, making it an indispensable tool in your professional or personal toolkit. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Years of growth in a retirement account can be wiped out by one mistake. As such, retirement account owners and their advisors should take care to ensure that IRAs are operated in compliance with the governing regulations. This includes ensuring that distributions are handled properly, and that movement of retirement assets, including between IRAs and employer plans, does not violate the limitations that apply.

This course provides a comprehensive analysis of the SECURE 2.0 Act. The principal focus of the Act is to expand retirement coverage and increase retirement savings. As such, the Act has many important changes relating to IRAs and qualified plans. This legislation alters the landscape of retirement planning for taxpayers of all ages. Make sure you are up to date with the latest information available in order to effectively advise your clients on these important changes.

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.

For many small businesses, the standards issued by the FASB may have little to no effect as they impact topics that do not reflect the type of transactions that these entities most frequently experience. This class will focus on the Accounting Standards Updates (ASUs) that are most likely to impact small businesses with a focus on ASUs initiated by the Private Company Council (PCC). We'll then look at alternative reporting options to GAAP including FRF for SMEs and IFRS for SMEs for entities who don't necessarily need to prepare GAAP financial statements but want to use accrual accounting. Finally, we will transition to audit standards that small business auditors will need to implement. 

With the increasing complexity and ever-changing nature of tax laws and issues, today’s accountant needs a one-day fast-paced update course focusing on the hottest Federal income tax topics affecting individuals, businesses and their owners with an emphasis of newly enacted income tax legislation. **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

Job titles for individuals can vary in different organizations even though the work is the same. This webinar is designed for the individual whose role is to oversee the work of others. This webinar includes an overview of Aristotle's virtue ethics and its application to the responsibility and privilege of developing employees to be their best and for the success of the organization. We will also address issues such as going from "buddy to boss", how to manage if you are newly assigned to an existing employee that was previously supervised by someone else, and critical skill sets necessary for supervisory/managerial positions. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Over the next decade, the area of “Advisory Services” has the greatest potential for growth in your practice.  Complexities within your clients’ financial, estate, and asset protection plans coupled with the ever-changing Internal Revenue Code has created an opportunity for the CPA, the EA, and other advisors to expand their client offerings. This course provides the practitioner with the framework for practice expansion as well as an understanding of a variety of necessary issues and techniques.  

Practitioners need to exercise caution to ensure they maintain independence as they assist their clients with reviews, audits, and compilation engagements. This course provides a roadmap to best practices and guidance provided by the AICPA's Code of Professional Conduct and analyzes and applies it to actual scenario-based case studies, providing accounting professionals with ethical standards to integrate into their practices. This event may be a rebroadcast of a live event and the instructor will be available for questions during the event.

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.

This course focuses on how to integrate independence and avoid conflicts of interest in situations accounting professionals face daily. Participants will be able to know not just what is the right thing to do according to the AICPA Code of Professional Conduct, but how to put values into action. As part of this course, we also walk through real-world examples of individuals and companies faced with these dilemmas. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

AICPAs Code of Professional Conduct - Exploring the Foundational Principles Underlying the CPA Profession as a whole will provide an overview of the basic principles of the AICPA's Code of Professional Conduct with practical implementation examples. CPAs must seamlessly transition to a profession that relies heavily on conformance with technical and ethical standards. It is critical for CPAs to seek to serve the public interest with a strong sense of character, integrity, competence, and due professional care. In addition, CPAs must appropriately safeguard any threats to independence and objectivity. Note: This course is recommended as a part of a 16-hour audit skills curriculum for beginning auditors, while it is also appropriate for anyone who has public accounting responsibilities. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The walking dead aren't the only threat to your business. So are several dangerous, even terrifying myths about what ethical leadership is and is not. This fun and distinctive webinar will present what Forbes contributor Bruce Weinstein, The Ethics Guy, calls "zombie ethics"-myths about accounting that hinder your ability to serve your clients and enjoy a thriving business. Taking a page from Nobel laureate Paul Krugman's recent work, zombie ethics are ideas about ethical leadership that deserve to remain buried but keep resurfacing from time to time. They walk the earth and wreak havoc. In this engaging webinar, The Ethics Guy will show you how to send them back to the cemetery for good. You can then fearlessly bring in new business--and watch your practice soar! This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Fraud is constantly in the news. Whether its employee retention credit mills, FTX, the City of Dixon, it appears like fraud is everywhere. We'll start this session with a review of the common fraud schemes as identified in the 2024 Report to the Nations. We'll also review the commonalities of fraudsters. We'll then look at methods of prevention. We'll close with a look at the auditor's responsibility for the consideration of fraud in AU-C 240.

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.

Governmental entities are the second largest victims of embezzlement.  This seminar examines recent events involving the theft of public money and the circumstances that allowed the fraud to occur.  We will be looking at a variety of case studies to illustrate these points.  

The Tax Division, United States Department of Justice, is responsible for enforcing the nation's tax laws fully, fairly, and consistently, through both criminal and civil litigation. This course will explore the role of the Tax Division in ensuring fair and uniform enforcement of tax laws, protecting the public, encouraging voluntary compliance with tax laws, and how their operations impact regulatory ethics. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The purpose of this program is to discuss the ethical mandates that govern the conduct of tax practitioners. The program focuses on the ethical pronouncements of the IRS in Circular 230, as well as the preparer penalty provisions set forth in the Internal Revenue Code. Please note: This ethics course does not cover state-specific issues and so is not applicable in states that require ethics courses to include specific state laws and regulations. Please check with your state board prior to registering for this program if you are in doubt about whether this program satisfies your state's ethics requirements.

Karen L. Hawkins, the former Director of the IRS Office of Professional Responsibility, will discuss key Circular 230 provisions and how some have been changed through litigation. Since the current version of Circular 230 has not been rewritten to incorporate the results of IRS litigation losses since 2014, this is the only seminar where you will hear what the current law says (and does not say) about tax professionals' ethical obligations in federal tax practice. The presentation will draw not only on the six years Ms. Hawkins spent as Director, OPR but her more than 30 years practicing as a nationally recognized tax controversy lawyer in California.