Professional Development and Event Catalog

In today's rapidly evolving business landscape, accounting professionals are expected to be more than just number crunchers, they are expected to be insightful interpreters of data. In an era where data is king, this course is your gateway to becoming a savvy data analyst, giving you a competitive edge in your field. We will guide you through the intricacies of making complex data analysis approachable and engaging. You will learn the all important Data Analysis Process Flow that will take you from collecting data all the way to making insightful decisions based upon your data. We will explore the basics of data modeling that will allow you to access data from multiple sources and use sophisticated calculations to create our data metrics. You will learn how to create interactive dashboards, perform sophisticated reporting, and uncover deep insights from your data. Whether you're looking to streamline your reporting process, enhance your data visualization skills, or make more data-driven decisions, this course is tailored to meet those needs. It's not just about learning a tool; it's about enhancing your professional identity as a forward-thinking accounting professional. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This program addresses the critical issues and special opportunities facing S-corporations, with a focus on reporting shareholder basis and distributions.  **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.

Ethics is complicated, and conflicts of interest are more complicated. What are the various issues involved with conflicts of interest?  What does the AICPA Code of Professional Conduct say? We will discuss several seemingly ordinary, everyday conflicts of interest and how we should be more aware that conflicts of interest are common. We will discuss the ethical priorities of a CPA and how to apply them. What should you do when facing a conflict of interest?  What is the ‘secret weapon’ to help mitigate conflicts of interest?  The key to our profession remaining relevant is to maintain trust. Come and learn more about conflicts of interest and how we all can be even more trustworthy.     

Good people believe everyone else is just like them. They cannot imagine someone could con them or their company and have no guilt or remorse about what they have done. Lack of guilt and empathy are key traits of a psychopath. Most of us envision psychopaths to be cold-blooded serial killers who are locked away in prison. However, experts estimate that 4% of corporate executives are psychopaths who may initially appear to be more normal than the rest of us. Psychopaths may present a convincing picture of virtue while helping themselves to money, status and sex while leaving a path of shattered expectations, empty wallets, and broken hearts in their wake. Learn how to recognize and deal with others who have no conscience. 

Want to automatically update the date and time on your spreadsheet? Or pick text strings from other cells to automatically copy and update to a different cell? You will learn how to incorporate text, date and time functions in your spreadsheet that will make data entry a breeze. In this webinar, we will focus on Text functions and Date & Time functions. In the Text function section, you will learn how to use the various Text functions to join and separate text entries as well as formatting the results. In the Date & Time function section, you will learn how to perform various date and time calculations. This session is presented using Excel 2013. Regardless of the version you are using, ALL concepts covered in this course apply to ALL versions of Excel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

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.

When auditors detect findings in Yellow Book and single audits, they do not just communicate them in some shabby little letter to management; they get reported! In this course, we will examine what types of findings get reported, how they get reported, and where they get reported! This course will take you from just checking a box and fulfilling a requirement to developing and delivering findings that make a meaningful difference to your clients.

Stop struggling with PDFs! Adobe Acrobat and other PDF tools provide access to features that make working with PDF files a breeze. In this course, you will learn how to use tools and features such as PDF forms, redaction, converting PDFs to Word and Excel files, and electronic signatures. You will also learn how to create and apply tick marks, build indices, catalogs, and portfolios, and secure PDF documents to their fullest. The popularity and usefulness of PDFs increase daily, but most PDF users have not learned how to manipulate PDF documents effectively. Accordingly, they struggle and strain with these standard files. You do not need to let this be the case. Join us in this very timely session where you will learn the top features necessary to optimize your work with PDF documents.

This comprehensive four-hour course takes CPAs beyond the basics, diving deep into the ethical quandaries that professionals face. Beyond just the rules of Circular 230, you'll explore a variety of ethical issues, discovering the best ways to handle them with integrity and wisdom. The course provides a dual focus: understanding your obligations under Circular 230 and tackling wider ethical challenges that can arise in your day-to-day work. With real-world scenarios and interactive discussions, you'll come away with practical solutions and the confidence to make the right decisions, keeping your practice ethical and your professional standing secure. **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.

The Accounting and Auditing Update is designed to provide its participants with a comprehensive, in-depth review of what’s happening at the FASB, AICPA, and other professional bodies who may impact accounting and auditing this year, including FASB Statements and Interpretations, Statements on Auditing Standards, Statements of Position, Statements on Standards for Accounting and Review Services, Ethics Interpretations, exposure drafts and projects in progress, with emphasis on the practical application and impact on practitioners in small to medium sized firms and members in industry. Special attention this year will be focused on the emerging use of data analytics related to audit evidence. **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 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. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

According to a 2020 AICPA survey, advisory and consulting services were considered the greatest unmet needs of clients. The recent growth in Client Advisory Services (CAS) has led many to ask what is included in this broad category as well as how to develop the services for clients. With so much focus on the recent success of CAS offerings, now is the time to learn how the services differ from what you currently offer, which of your clients would benefit most, and what you need in place to add a quality CAS program to your firm's menu of services.

This webinar will show you how to use Excel's charting and formatting features to present financial data to a non-financial audience. As the saying goes, "A picture is worth a thousand words." People tend to better understand your point when visuals are used. We will explore the many capabilities of presenting your data without showing rows and rows or columns and columns of data. Help your audience visualize the meaning of the data, whether it is a trend, an exception, a distribution or a good vs. bad relationship. This session is presented using Excel 2013. Regardless of the version you are using, ALL concepts covered in this course apply to ALL versions of Excel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The Professional Ethics Executive Committee (PEEC) of the AICPA has been very busy issuing new and updating existing ethics rules. This course will provide an overview of recently issued and soon to be effective ethics rules that CPAs in both industry and public accounting need to know to be compliant.

Many finance departments spend considerable time managing cash, particularly if the organization is highly leveraged or cash rich.  Many opportunities exist to reduce your financing costs or increase short-term cash returns if you manage cash effectively.  This session will cover a wide variety of day-to-day cash management tools.  

Team development and performance are critical to leadership success. In this session, participants will examine team formation, learn about the balance between team performance and team health, develop team agreements, and understand the latest tips from Google's Perfect Team research to strengthen team experience. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Welcome to a management course that helps CFOs and Controllers lead the Accounting Department. It is essential that the Accounting Department have a Vision which is aligned with the Business goals. Controllers must also be comfortable with wearing multiple 'hats' in the business. The head of the Accounting Department must be skilled in a variety of leadership skills, technical skills, managerial skills and current management techniquest.

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. 

A detailed analysis of the calculations related to determining a shareholder's tax basis for S corporation shares and loans. How to use the Form 1120S, Schedule K-1 information for basis determination, as well as an update on Schedules K-2 and K-3. An illustrative example demonstrates how the process works, as well as the many 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.

The QuickBooks platform is a robust environment with features and capabilities that many users are unaware of or do not know how to utilize effectively.  This course helps you get more out of QuickBooks Desktop and QuickBooks Online and resolve the issues that even experienced QuickBooks users struggle with, such as locking down prior periods.  This program starts fast with a chapter covering the top issues accountants face with QuickBooks.  The day continues with practical guidance and solutions designed to help accountants get the most out of QuickBooks for themselves or their clients. You will learn about issues, such as setting up a new company, configuring and customizing QuickBooks preferences, and enabling system security and password protection features.  Also, you will learn how to lock down transactions in prior periods, the audit trail, customizing reports, exporting reports to Excel, and extending QuickBooks’ usefulness with tools such as the Fixed Asset Manager and Loan Manager.