Professional Development and Event Catalog

In the world of “Big Data,” virtually all business professionals have become data analysts, at least to some extent. However, that is particularly true in the field of auditing, where internal and external auditors are increasingly turning to data analytics to identify situations requiring follow-up and investigation. Those who understand how to take advantage of various tools to assist in these efforts benefit by conducting more thorough analyses and achieving superior results in less time. In this session, you will learn about various tools and techniques you can use for more thorough data analyzes. The discussion includes Excel as a data analysis tool, multiple Excel add-ins, and Microsoft’s Power BI application. If you're seeking to improve your skills in the field of data analytics, this session is the one for you! 

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.

With the rapid pace of change, change now happens daily in business and our personal lives. It can be difficult to navigate change when right and wrong get a bit fuzzy. New processes, new technology, new circumstances and new impacts to people must be measured and decisions made as the change evolves. Change always becomes something different than what was originally planned or imagined. In this session, learn how to measure your ethics through change. You will learn how to filter everything you do during change through a simple litmus test. Through the power of story, you will learn from the lessons of other organizations and their ethical mistakes. Lastly, you will take away what is required to manage yourself so that when ethical decisions arise, you have the mental capacity to manage through it well. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Unhealthy behavior in the workplace can create a drama-laden, hostile work environment, negatively impact productivity and increase turnover. When team members are focused on how they can one-up their counterparts or are fearful of their co-workers/leaders actions towards them – they are NOT focused on reaching your company’s goals.   

What can we learn from one of the largest municipal frauds in U.S. history? Rita Crundwell stole nearly $54 million from the citizens of Dixon, Illinois over the course of two decades. This course examines circumstances that allowed this landmark fraud to occur. We will explore internal control deficiencies and other circumstances that hindered prevention or timely detection of Rita's scheme.

The TCJA made turning business losses into tax refunds far more difficult.  The CARES Act suspended and modified many of these changes.  This course will address the revised rules for deducting business losses and discuss planning ideas and 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.  

This course explores the tests used to determine whether a worker is properly characterized as an employee or an independent contractor for tax purposes, with a focus on the cost of getting it wrong and possible Section 530 relief.  The game changing impact of the Dynamex case and AB5 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.  

Conflict is as natural as breathing air. For many, the thought of dealing with conflict is difficult and horrifying, and yet unresolved conflict can damage relationships, cause pain and suffering as well as hinder workplace productivity. When addressed, however, conflict has the power to be transformative in strengthening workplace relationships, shared understanding, and increased productivity. This workshop will provide an intimate understanding of how to deal with conflict in collaborative and constructive ways. Using ethical values and principles, we will explore how to move conflict from an obstacle to an opportunity. This workshop is geared toward individuals who are wanting to improve their conflict management skills and create more harmonious and positive working environments. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Microsoft Teams is one of the most popular tools for communication, collaboration, and knowledge sharing. If you use Microsoft Teams in your practice or business, this is a "must attend" course. You will learn everything you need to know to optimize the features of Teams and maximize your productivity. We will cover everything from how to effectively design your teams and channels configuration. How to utilize all the Teams features for posting conversations and working with your Office documents, PDF files and more. You will leave this course with the skills to master all the features of Teams! 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 will explore significant elements of the FASB's technical agenda, focusing on recent updates to revenue recognition and lease accounting standards. A Special Purpose Framework overview will be provided, which may reveal salient alternatives to U.S. GAAP for certain entities. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Preparing Form 1041 is essential for tax professionals working with estates and trusts. This course provides a practical, step- by-step approach to completing the U.S. Income Tax Return for Estates and Trusts, covering key issues such as distributable net income (DNI), income in respect of a decedent (IRD), and tax compliance for fiduciary entities. Participants will gain a clear understanding of Subchapter J of the Internal Revenue Code and learn how to apply tax rules to real world situations. Through case studies and line-by-line instruction, this course equips professionals with the skills needed to prepare Form 1041 accurately and efficiently. Additionally, it will include updates on any new legislation or IRS guidance introduced by the current administration and its impact on fiduciary taxation. *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

Presently, over seven million businesses use QuickBooks Online. However, these businesses often struggle to get the reports they need. In some cases, they are limited because of their chosen subscription. However, necessary reports are available in other cases, yet users do not know how to access them. Join us in this session to learn about better reporting options in QuickBooks Online. In this session, you will learn how to create and customize your reports in QuickBooks Online. You will learn about Standard, Custom, and Management reports. You will also learn about the new Spreadsheet Sync tool that allows you to create customized reports, including multi-company reports in Excel. If you use QuickBooks Online and want to improve reporting, this session is for you!

Do you love PivotTables? Of course, we all do! Traditional PivotTables are incredible, but they do have limitations. If you have ever encountered one of these limitations, you'll be excited to learn that by using the Data Model as the source for PivotTables, you'll be able to bypass many of the restrictions that exist with traditional PivotTables. The data model (also referred to as Power Pivot) is included in Excel 2016+ for Windows and available as a free download for previous versions (excluding Excel for Mac). Using the data model enables you to build PivotTables that were previously not practical. If you frequently build PivotTables and would like to do more with them, you'll want to understand how to use the data model (Power Pivot) to enhance your reports. Note about Excel versions: Power Pivot is not available in all versions of Excel, including Excel for Mac. If you would like to see if Power Pivot is available in your version of Excel, visit the Microsoft site.

Schedules K-2 and K-3 are promulgated by the IRS in order to standardize the reporting of foreign-related tax information for pass-through entities. Even pass-through entities that have no foreign activities, investments, or partners may have a reporting requirement. Schedules K-2 and K-3 for reporting partners' income, deductions, and credits from foreign activity are now required for passthrough returns (Form 1065, 1120-S and 8858). This requirement starts with returns with a tax year that ends in 2021. This course discusses each part of these schedules and explain these new reporting obligations in detail. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Since 1919, the Internal Revenue Service had a civil and criminal function in the United States tax system. Little do people know, the IRS has an elite criminal function that started with five United States Postal Inspectors. From its early days in taking down Al Capone to now solving cybercrimes, the IRS special agents are tasked with investigating tax fraud, money laundering, and other white collar crimes. This presentation will show you the importance of this law enforcement function, the training, techniques, expertise, and actions that cause them to be known as the "world's finest financial investigators." This presentation has been prepared by a 20 year veteran with the IRS-Criminal Investigation. The presenter investigated crimes, and trained and mentored other special agents. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Conflict is often avoided, or dealt with in a passive manner. When ignored, conflict often escalates and can become polarizing. In this session, participants will gain insights for enhancing their natural responses to conflict, learn healthy communication styles, and build constructive behaviors to manage conflict. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This session will explore the ethical considerations CPAs and CPA firms should be cognizant of when considering services to the state legal, regulated cannabis industry. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The IRS has recently issued proposed regulations to update the Circular 230 rules for all tax practitioners, amending these rules in various ways to reflect changes in the law.  This session will review these new rules and discuss their impact on your tax practice.  The course also covers in detail major provisions of Circular 230 and analyses them using factual situations. *Please Note:  If you need credit reported to the IRS for this IRS approved program, please download the IRS CE request form on the Handouts Tab and submit to kori.herrera@acpen.com

This course examines actual fraud circumstances through the lens of potential prevention. We will examine how selected frauds were accomplished and consider what internal controls may have prevented fraudsters' ability to accomplish their nefarious acts.

Discover how artificial intelligence is transforming the accounting, tax and finance landscape. This course offers CPAs a comprehensive overview of AI technologies, with a special emphasis on generative AI tools such as ChatGPT and Google Gemini. Learn how these advancements are reshaping business operations and what they mean for your professional role. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.