Professional Development and Event Catalog

You don’t need an accounting degree to harness the power of Microsoft Excel. This course shows how Excel makes sense beyond dollars and cents. We will focus on fundamental concepts for creating, editing, and utilizing Excel content. Participants will learn how to use Excel’s menus and other functions to craft Excel workbooks. Because this course is designed for newer users, we intentionally offer a broad overview of Excel’s numerous capabilities with in-depth coverage of selected resources tailored for non-accounting applications.

This course will dive into the fundamentals of fiduciary accounting and provide a reporting guide for determining whether receipts and expenditures are assigned to income or principal/corpus. 

Key factors and considerations for organizations seeking to implement a cryptocurrency-based payment system. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

In today's rapidly changing world, finance professionals are required to wear many hats and are often the keys to the success of the organization. On one hand, they need to be abreast of the latest proven financial skills for making the best decisions, and on the other hand they need the best skills to motivate, manage, and lead people. Being pigeon-holed into one area or another is neither good for career building nor good for the organization. This reality has proven to be even more true with the advent of COVID-19. We'll cover the latest issues that all CFOs and controllers need to know about and provide how-to guidance to allow for immediate use in their organizations. The program is focused on organizational success and will concentrate on ways to manage risk and achieve greater productivity.

While ethics training is required by many states, the true value of the CPA license is in understanding how critically important ethical behavior is to our customers, our firms, and the public. This course will explore the basic tenets of ethical behavior and use case studies to explore ethical dilemmas in various companies and organizations with a focus on dilemmas that may face CPAs in the industry.

How does a forensic accountant calculate financial losses? Federal courts have approved various ways to calculate losses ranging from net worth method of proof to the expenditures method. Each method of proof depends on the available facts to the forensic accountant. This presentation will focus on the various court approved methods of proof, when to use them, and how to calculate the total loss. 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 provide an overview of the work and impact of the Treasury Inspector General for Tax Administration (TIGTA) on the US tax system, regulatory ethics, and accounting profession. TIGTA is an independent organization that provides oversight of the Internal Revenue Service (IRS) and conducts audits, investigations, and inspections and evaluations to promote integrity, economy, and efficiency in the administration of the nation's tax system. The course will explore the role of TIGTA in improving the efficiency and effectiveness of the IRS, identifying opportunities to improve the administration of tax laws, and upholding ethical standards in the accounting profession. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Does your organization encourage timely reporting? Does your organization provide substantive protection for those who report? Organizations should be aware of characteristics indicative of a retaliatory culture - one in which bad actors are provided ample opportunity and cover to retaliate.

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.  

Performing engagements in accordance with Generally Accepted Government Auditing Standards (GAGAS or “Yellow Book”) requires additional reporting, ethics, and performance requirements. This course will identify and review the guidance found in the Yellow Book and analyze the relationship between Government Auditing Standards and the AICPA Code of Professional Conduct. We will review the Yellow Book requirements for financial statement audits while also touching upon ethical principles and independence

This course begins with a look at the GASB standards effective this year, including GASB 100, Accounting Changes and Error Corrections and GASB 101, Compensated Absences. We'll include practical application of the topics in the form of case studies. 

Almost 50% of businesses that started five years ago are no longer in operation today. Controllers and CFOs can and must influence the longevity of their organization to improve their success rate.  Jim will help you be aware and understand the answers to these issues: Can you describe the financial health of your company? Can you also explain what the financial health of your industry is? Do you know your Business Cycle compared to the industry business cycle? Do you have an executable plan? Do you know what the competitive, legal and technological landscape is currently, and for the future? Is your organization aligned and incentivize to be successful? Jim has developed his groundbreaking Business Longevity concept as a keynote and a workshop, and would be happy to speak to your organization on this topic. This session will focus on assessment (financial health, competitive environment), determination (effective business planning, including the future landscape), and execution (gettin’ it done!)

The Not-for-Profit Advisory Committee has been busy discussing several projects that the FASB is working on and their impact on nonprofits. In this course, we will review the key issues and discussions from recent NAC meetings. We'll also take a look at ASUs issued by the FASB that may impact nonprofit financial statements. After a break, we then transition from accounting to auditing with a look at the common deficiencies found in nonprofit Yellow Book audits with a focus on CPE, reporting, and independence.

In the "Excel - Formatting Spreadsheets for Beginners" class, you learned basic formatting of a spreadsheet. In this class, we take you to the next level by teaching you how to customize many of the formatting options. Learn to customize cell styles and how to use these styles in other workbooks. Most Excel users know how to select number formats but this class shows how to leverage the Custom Number Formatting option to create special formatting options. Many of the formatting options are applied manually, cell-by-cell or by range. This can be tedious if there is a condition by which you want to apply a format. You will learn to use Conditional Formatting to format based upon a criteria. Have you ever finalized a spreadsheet, only to accidently make changes over the top? This action is something that is very easy to do. This class demonstrates various options to prevent this from happening and will look at various security options within Excel. This session is presented using Excel 2019/Office 365. Regardless of the version you are using, most 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.

Fraud Trends - Applying Real-life Lessons to Small- and Mid-Size Entities will focus on real-life and practical examples of fraud in smaller- and mid-size environments, including nonprofits. Fraud involves an intentional act to deceive, which may result in material misstatement in the financial statements due to fraudulent financial reporting or misappropriation of assets. Management's responsibility is to design, implement, maintain and monitor a system of internal control to prevent, or detect and correct, fraud. Note: This is a part of the suggested 16-hour Audit Skills Level 4 curriculum for experienced in-charges or seniors. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Congress was EXTREMELY busy in late December 2022! During this lame-duck session, Congress was able to pass SECURE 2.0, which is essentially the original SECURE Act that was passed in late 2019.  There are over 50 tax-related provisions within SECURE 2.0 which an advisor needs to be able to master.  This course will provide the participant with everything that that they need to know about SECURE 2.0 so that they will be able to better serve their clients’ retirement planning needs. **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.

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.

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.

Individuals may cite retaliatory concerns when weighing their decision to report an issue; during an investigation; or, after an investigation’s conclusion. No matter the timing, when an individual raises a retaliation concern, their claims should be taken seriously and fully reviewed. Does your organization analyze retaliation allegations and investigate outcomes as part of their cultural assessment?   Most organizations track retaliation matters at a general, non-specific level. The type of retaliation and the perceived cause of the retaliatory act are not delineated. When a retaliation matter requires investigation, an organization should gather key data points for trending purposes and to fine tune future training and policy initiatives. This course offers recommendations for (1) framing responses to retaliation allegations (2) capturing key data points (3) developing specific metrics for retaliation matters

One of the three major forms of occupational fraud, along with corruption and asset misappropriation, is financial statement fraud.  From improper asset valuation to fictitious revenues, this course will review financial statement fraud red flags and examine real-life examples.