CPE + Events Catalog

Staying current on significant changes in Government Audit Standards can be difficult. This course covers the most important issues and changes relevant to Yellow Book financial statement audits. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

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.

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. 

The Microsoft 365 ecosystem of apps offers tremendous value for any business organization. The key to maximizing the ROI of your monthly subscription fees is to understand how all the apps work together. John Higgins, a strategic advisor to the profession on Microsoft 365 deployment, will share a number of "best practices" for deploying Microsoft 365. This course will help you discover the hidden gems in the Microsoft ecosystem to increase productivity across your organization and help you avoid making costly mistakes in your deployment. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Review the availability and application of three special rules that allow exclusion or deferral of gain from the sale of the stock of a corporation not making the S corporation election. IRC 1202 provides that all or part of the gain from the sale of "qualified small business stock" can be excluded from gross income. IRC 1045 describes situations when the gain from the sale of "qualified small business stock" can be deferred. To understand the application of these two favorable provisions, the meaning of "qualified small business stock" and other requirements and limitations must be understood. IRC 1042 allows the deferral of gain from the sale of corporate stock to an employee ownership plan ( ESOP). This deferral requires a qualified reinvestment in an adequate amount at the right time. Study how these three provisions apply in the context of tax planning for corporate businesses.

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.

Ethics is simple: Do no harm, just tell the truth, keep your word, and when in Rome do as the Romans do. For most people in most circumstances, these "bumper sticker" sayings provide helpful ethical guidelines. For accountants, however, ethics -- and especially, professional ethics -- can quickly turn into a tangle of ethical conflicts and competing rules. This workshop untangles some of these situations by working from ethical theory and practice. 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 analyzes and applies the AICPA Code of Professional Conduct and other sources of ethical guidance 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 to answer your questions during the event.

This session provides a refresher regarding the fundamentals of activity-based costing (ABC). We will examine theoretical concepts before exploring practical possibilities for implementing ABC. A major focus of the course will be factors to consider when determining whether this managerial accounting tool is an appropriate resource for an organization.

This course provides a concise overview of how to utilize ChatGPT for advanced financial analysis in accounting. The session reveals how to combine sophisticated evaluation and interpretation of financial data with the cutting-edge AI capabilities of ChatGPT. Aimed at enhancing the understanding of an entity's performance, predicting future financial health, and aiding in informed business decision-making, this course goes beyond basic financial statement analysis to include a wide array of techniques and tools. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Probably one of the greatest conflicts in an organization is determining which is more important: compliance or customer service. This program digs deeply into the issue and prepares the finance professional to achieve high levels of compliance and customer service in the department and in the entire organization. We will examine both disciplines from an analytical standpoint, proving why they are necessary for both for-profit and nonprofit businesses to achieve success.

The AICPA's Auditing Standards Board has several large projects that will be impacting entities in the near future. We'll take a deep dive into the changes related quality management as well as group audits. We'll also review common audit deficiencies. This course will keep auditors up to date on the work of the ASB. 

Most financial leaders would agree that budgeting is easy when business and the economy are stable. When revenues and expenses are expected to remain the same, the process becomes merely an exercise in carrying over what was done before to the current year. However, what happens when we are not sure about how the market will react to our product? What happens when the competitive landscape changes? In this course, we will discuss budgeting techniques and considerations when business lacks stability. Through a combination of theory and real-world examples, we will explore how to build flexibility into our budget - so that it can inform and drive decision-making when we don't quite know what is ahead. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

New Technology, the move toward telecommuting, the widespread adoption of electronic documentation, and a wide range of other factors have significantly and forever changed the way business is conducted. It should go without saying that changes in tools and methods lead to upheaval in any organizations internal control system. In this session, we look at all the changes that are occurring and discuss what's coming in the not too distant future. The material then looks at how internal controls have been affected and what other updates are on the horizon. Anyone trying to use controls to keep their organization efficient and secure should consider this session because the rate of change to both operational methods and control processes has been and will continue to be incredible. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Depending on your version, Excel has over 500 functions already built in and ready to use. How many of those do you incorporate into your spreadsheets? After this course, you will learn some powerful functions that will take your calculating power to the next level. In this webinar, we will focus on Financial, Statistical and Math functions. In the Financial functions section, you will learn how to use the financial functions to build better amortization schedules. In the Statistical and Math functions sections, you will learn how to use various statistical functions to analyze your data. 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.

A significant amount of information is electronically initiated, recorded, processed, or reported, and information to be used as audit evidence may be available only in electronic form. During this session we will look at different types of information commonly presented to an auditor during the audit of an employee benefit plan, and identify considerations for auditors when evaluating information to be used as audit evidence.

Based on an AICPA Enhancing Audit Quality study, 23% of all single audits subject to enhanced oversight were materially non-conforming with professional standards due to failure to properly test controls over compliance.  This course will provide an overview of internal controls over compliance specifically related to Single Audits. We will discuss how to apply the concept of internal controls to various compliance requirements. Additionally, a common finding in the audits of governmental entities receiving federal grants is misidentifying controls and mistaking compliance for a control. That's why this course will also focus on identifying compliance versus controls over compliance.

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.

This webcast, part of the 2020 Power BI series, focuses on using Power Query (Get and Transform) to clean, shape and transform your messy data while still allowing you a one-click refresh.

Globalization continues to make it easier for taxpayers to live abroad, do business in other countries, or invest in foreign enterprises. This creates significant complications and tax planning opportunities when it comes to filing U.S. tax returns. This course provides an overview of the unique tax challenges and solutions presented to U.S. expats or investors living or investing abroad. It examines how foreign-source income is taxed in the U.S. and how the tax consequences could be mitigated by applying the tax treaties, claiming credit for foreign taxes paid, or excluding foreign-earned income. Additionally, the course discusses the numerous foreign informational form reporting requirements and the significant penalties that could be imposed by the IRS. Examples from real-life client scenarios are included.