CPE & Event Calendar

Excel has over 500 functions that are built-in and ready to use. You just have to figure out which one to use and when. Integrating functions into each and every one of your spreadsheets not only improves efficiency, it also makes your task easier to execute. In this webinar, we will focus on Logical, Information and Lookup & Reference functions. In the Logical function section, you will learn to perform logical test using the IF function along with AND, OR and NOT. In the Information function section, you will learn various ERROR checking functions that can be combined with the Logical functions. In the Lookup & Reference section, you will learn to use the various LOOKUP functions and INDIRECT function. 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.

This program addresses the most recent developments impacting partnerships operating as LLCs, with a focus on legislative, administrative, and tax form changes.  Emphasis will be placed on partners “tax basis” capital accounts – now required for tax form reporting, as well an overview of K-2 and K-3 reporting requirements and effective dates. **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.

A multitude of tax changes have are currently taking place, challenging tax practitioner to stay well-informed. This 4 hour program will cover tax developments specific to business, including new court decisions, recent IRS publications, and the latest tax legislation that will impact individuals.  The remaining time will be spent on IRS procedure and other issues. This course will provide a concise look at the hottest topics affecting every tax practitioner.  **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.  

During this presentation, the most common mistakes made by employee benefit plan auditors, as well as plan sponsors will be identified. Best practices for handling specific issues that arise during the course of the engagement will also be explored. This discussion will help auditors recognize potential pitfalls in audit procedures/documentation and assist plan sponsors with compliance issues. 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 corresponds to our Controllership series. Within this course, we specifically address the Controllers role and pro-active potentials in organization Strategic and Annual Planning. This series of courses is dedicated to exploring the traditional controller role and stepping out of the box to identify areas where the Controller can add strategic value to their organizations. Controllers are essential to the day-to-day accounting for organizations. Yet, the role is not often readily understood. In today’s world of acronyms such as CFO, CEO, COO, CAO, etc. the Controller function may get lost in the shuffle. However, they are a critical group of professionals who ensure the adequacy and transparency of accounting and financial reporting information. When it comes to the task of strategic planning, many feel this role is primarily the responsibility of the executive team and board. However, in this course, we delve into the various steps of the strategic plan and explore where the Controller can add strategic value through providing functional input and insight. Strategic planning is a process used to identify goals, the strategies necessary to accomplish those goals, and the internal performance management system that will be used to monitor and evaluate progress.  

This session will focus on the most common types of fraud in the procurement and contracting arena, with a focus on fraud in construction.  The session will examine fraud vulnerabilities in the four key phases of the procurement process: Presolicitation. Negotiation. Performance. Closeout and Claims.  Within each phase, “red flags” will be discussed.  These are the indicia of possible fraud that managers should be alert for.  Also, within each phase, the most common fraud schemes will be highlighted and discussed.  Finally, the session will describe the generally accepted safeguards or controls that should be established to prevent the various fraud schemes that can occur.  This part of the program will make extensive use of actual fraud case studies designed to demonstrate fraud risks and fraud detection strategies.

This session explores the nature of analytical procedures, with significant emphasis placed upon professional standards involving the use of analytical procedures in audit and review engagements. Practical examples to illustrate the application process will also be given.

We all make predictions in our personal and professional lives.  We base our decisions to marry, buy a house, launch a new product or hire staff on expectations about the future.  In the past few years, research into improving predictions has advanced. We will look at this research and current best practices in forecasting to help us prepare better budgets and projections. 

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.

Microsoft Teams is one of the most widely used applications for communications, collaboration and knowledge sharing in business today. Most users are unaware of many time saving features available to help you manage your conversations, files and related content on a daily basis. John Higgins, a strategic advisor to the profession on Microsoft 365, will teach you how to leverage all the functionality Teams has to offer to compose, organize and retrieve your conversations, files and related content for 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.

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.

This course corresponds to our Controllership series. This course is dedicated to exploring the traditional controller role and stepping out of the box to identify areas where the controller can continue to add strategic value to their organizations. Within this segment of our controllership series, we discuss the area of cash and investments and explore how the controller can move these responsibilities into more of a strategic role. In today’s world, the role of cash management is often a pivotal role in the organization. In economically difficult times, controllers may find that they spend a great deal of their time on understanding and managing the organizations' cash position. This is certainly important and, in some areas, can be seen as a staple of the lifeblood of the organization’s ongoing viability. This course takes a look at some of the typical objectives involved in cash management and then evaluates how those objectives can be further stretched into strategic pillars of the organization.  

The Uniform Guidance present unique challenges to auditors of governmental organizations and not-for profit organizations receiving federal financial assistance. This Guidance requires auditors to take a risk-based approach to the audit, including a methodology of determining which federal programs are considered major and therefore subject to Single Audit compliance requirements. A significant challenge facing many auditors is determining the Uniform Guidance requirements in a Single Audit. All professional involved in Single Audits must have a working knowledge of the requirements imposed by the Uniform Guidance. We will cover the issues that all auditors need to know about the Uniform Guidance requirements, including how to determine major federal programs. This course will provide example about how to comply with these requirements. 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 compares and contrasts the financial accounting for partnerships and LLCs, as well as discusses the tax accounting for these entities. It includes a thorough discussion of the important differences between financial accounting for partnership capital accounts and the tax accounting for partnership capital accounts. Financial accounting for operations of a partnership will also be addressed.

This Masterclass is a one-hour training to show accountants how they can grow their practice this year through CFO and business advisory services. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This series includes four 2-hour consecutive Friday sessions, airing live beginning February 7, for a total of 8 CPE. Once registered for this bundle, log in instructions will be emailed to you separately for each individual course. You receive significant savings when purchasing these webinars as a bundle. The CFO Series provides a convenient, one-stop way for senior level financial managers and executives, CFOs and those who aspire to be CFOs, to attend multiple webinars of CPE with a single decision. The CFO Series features high-quality presentations and an interactive, executive level colleague-to-colleague approach with case studies, group discussions, and team exercises.

Customers demand quality. We expect quality in what we do and in what we consume. In 1985, Philip Crosby told us that quality is free. We will examine Crosby's statement and look at the four aspects of the cost of quality - prevention, appraisal, internal failure, and external failure. What are the true costs associated with each of these elements? How can we determine how each aspect can be measured? We will test the adage that an ounce of prevention is worth a pound of cure to see if this 16:1 relationship holds true. Quality matters, and we need to know how to evaluate the true cost of quality and what the value is.

These are uncertain times. With constant economic fluctuation, geopolitical uncertainty and inflation pressures, corporations and their professionals are facing challenges at every turn. The Controllership function is accustomed to dealing with changing variables but when the change is constant and every evolving, even the simplest of tasks like cash flow and cash forecasting can become difficult.  This webinar is to focus on what methods the controller can elicit to attempt to address the current uncertainty when working with their cash flow issues and forecasting. Of course, there are basic measures that can be employed such as: Proactively managing receivables and payables Automate your accounts payable and receivables process Keep business expenses at a minimum Work with digital methods of payment from vendors Use credit wisely However, this webinar will explore methods used to create and manage your cash flow and forecasting processes. These methods go one-step past your typical forecasting to enable management to explore various alternatives and scenarios for the business.

In forensic accounting, interviewing is used to obtain important information from witnesses and suspects. An important aspect is the ability of investigators to obtain accurate and reliable information from victims, witnesses and the suspects or any interviewee. The interview process is an essential part of information gathering for any investigation. The importance of improving the quality of the interviewing with the potential for visual recording of all interviews should be placed high on the agenda of all organizations across the globe. A properly conducted forensic interview can result in an extreme benefit regarding collection of information. The interviewer’s role is to develop a full understanding of the facts. There is a distinct difference between a forensic interview and a criminal interrogation. Typically, forensic auditors will not be involved in interrogations. The Canadian or U.S. forensic accounting profession does not have a standardized interview model to truly equip its professionals with the interview tools required to elicit confessions ethically. Majority of their skills are developed through experience, and not through a standardized model of training.  This session focuses on various interview concepts and methods.  

How well do you understand your organization’s cash flow? Good cash management techniques can provide a competitive advantage! This session shows you how to effectively measure and manage your cash conversion cycle. With a more complete understanding of how cash flows through your organization, you can eliminate impediments. Better cash management lowers your borrowing costs, reduces financing needs, and creates financial flexibility in your organization.