CPE Catalog & Events

This course will introduce AI platforms and how they can be used to understand and create Excel formulas, understanding and writing VBA code for Macros, and much more. We'll explore the free ChatGPT service as well as Microsoft's built-in AI Excel features.

Have you ever opened a blank workbook in Excel and just stared at it, wondering where to begin? Or, do you spend most of your time just formatting cells to make your spreadsheet look pretty? Or, do you just wonder if there is a better way to create your spreadsheets? This course is designed to take you from a blank worksheet to a completed report. Our example will be a financial statement but you can use the knowledge gained in the course and apply it to your specific job function. You will learn to import data instead of manually entering it. Learn that you can use functions and formulas to build calculations that will eliminate the need to manually manipulate your data. Our goal is to make sure you have all the information needed to build reports without having to manually enter it every month. You will learn techniques to use your data to build your reports. This will include building formulas that are flexible with your changing data. You will learn techniques to validate your report calculations so you can improve the accuracy of your reports. You will also learn how to quickly format reports and techniques that allow you to efficiently change the format. Lastly, you will learn how PivotTables can provide a more dynamic reporting option instead of using pre-defined report formats. Obviously, we will be covering a lot of ground, so to enhance your learning experience all examples will be provided to each participant along with instructions. This will allow you to follow along and use as you apply your new knowledge to your spreadsheets. 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.

The new field of Positive Psychology offers many methods and ideas for helping people be happier, healthier, and better at what they do.  Nowadays, the ability to be at your best and get clients to enjoy working with you is critical to growing your business or getting ahead.   Studies show that happy people make $750,000 more over the course of their life than unhappy people, have half the number of sick days, and live 9 years longer.  In this fun and fascinating seminar, you’ll learn how to not only be happier, but help your clients be happier in working with you.

Fraud in the workplace is not new. However, statistics show that the number of internally actuated fraud schemes is increasing. Additionally, fraud risk is at an all-time high because of the recent disruption. This course starts by reviewing the many reasons that fraud occurs. Then, it looks at ways to detect internal fraud and explores control measures that can help reduce the risk. Those who take this class will learn just how invasive and damaging internal fraud can be. You'll also know ways to detect and prevent fraudulent activity.

The single greatest breakthrough in 21st-century economics is the comprehensive and creative translation of prices into time-time prices. They calculate hours and minutes needed to earn money to buy goods and services. They are unequivocal and universal. What has happened to the time prices of the commodities we purchase daily? Join Ron and Ed to explore this dynamic new measurement of economic well-being throughout history.

Accounting and finance professionals have used different forms of automation over the years to improve the efficiency and accuracy of their work. So far, technology has not been able to replace the knowledge, experience, and decision-making of seasoned professionals. Times are rapidly changing. Today, systems easily exceed humans in accuracy and consistency. Artificial intelligence (AI) brings opportunities for accountants and finance professionals in the short term to improve efficiency and accuracy, while providing more value for businesses and customers alike. In the long term, AI will offer profound changes to how professionals work and process data. This course is designed to review where we are and where we are headed in the world of AI.

This is a survey course on the intergenerational transfer of property -- focusing on what the CPA should know about trust instruments. It will cover a broad number of topics ranging from the fundamental legal principals necessary for the trust and estate practitioner to understand, to the ability of language in the trust instrument to accomplish a certain tax result.

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.

All organizations are looking for ways to gain an advantage over the competition. This practical and interactive session will present a toolkit of ideas to help CFOs, controllers and finance professionals better position their organizations for the future. We know change is occurring at an exponential rate, and that has proven to be the case in all areas of finance, management, and leadership over the past year. The course deals with these new issues and will continue to be updated as necessary throughout the year. Become the "financial hero" of your organization and make a positive impact on the bottom-line.

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. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Audit Reporting Advanced Concepts - Understanding the Impact of General Audit Procedures on Disclosures and Audit Report Modifications will provide guidance for properly altering financial statements and audit reports for certain complex transactions and events that are often uncovered through general audit procedures, such as subsequent testing, reviewing minutes, and more. Each set of financial statements and auditor's report thereon must properly address the unique circumstances of the specific reporting entity's circumstances. Note: This course is recommended as a part of a 16-hour audit skills curriculum for in-charge or supervisor auditors, while it is also appropriate for anyone who has responsibilities for audit reporting and general audit procedures. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Payroll is among the most common tasks an employer undertakes in the course of running their business. At its most basic level, payroll consists of an agreement between an employer and employee related to compensation for services. Once you look under the hood, there is so much more to payroll, including various kinds of compensation, payroll taxes and required reporting on government forms. This course will provide a general introduction to the workings of the payroll returns an employer is required to file. We will cover the various types of federal and state payroll taxes, what various payroll returns an employer may need to file, how to complete the most common types of payroll returns accurately, and real-life illustrations for reconciling at year end and ensuring your payroll returns are correct. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Owners of S corporations and partnerships are subject to numerous limitations on pass-through losses, each with unique rules, applications, and complexities. With the increase in popularity of pass-through business entities, it is essential for CPAs to understand the complexities and interactions of these pass-through loss limitations.

With the constant churning of governmental accounting standards, now is the time to know more than just what the standards say; we need to know what they mean and how they will affect governmental entities. This course is designed to do just that! The course materials utilize a highly illustrative and innovative format. Over 15 focused exercises are included to provide an enhanced working knowledge of the most critical challenges in governmental accounting today.

Boost quality management through improved processes (bold) With an emphasis on more proactive and continual improvement, the monitoring and enforcement of quality management (QM) systems for audit and accounting practices have changed. The revised QM standards take a proactive approach to quality management, with an increased emphasis on monitoring, remediation and improvement. Firms are now required to evaluate their system and annually conclude on its effectiveness. Third in a four-part webcast series (bold) This is the third webcast in a four-part series on the Auditing Standard Board's (ASB) new quality management standards. In this webcast, you'll take a deep dive into the monitoring and remediation component of the ASB's Statement on Quality Management Standards (SQMS) No. 1, A Firm's System of Quality Management (ital). Attendance in each webcast in this four-part series will earn you one CPE credit. You can participate in one or all based on your interest in the topics. A rebroadcast of this webcast is scheduled for Dec. 13, 2022, at 2:00pm ET.

Every professional faces situations and scenarios where they feel their independence and objectivity related to an issue is impaired. They may feel pressured by management to minimize their report findings or, in some cases, look the other way. When these situations occur, professionals are faced with the dilemma of "what do I do?" or "how do I handle this situation?". These are the types of scenarios for which our university programs and business schools do not adequately prepare us. Experience can often be a good teacher. However, all individuals should be armed with some basic concepts that will prepare them to choose the right path when such difficult situations occur. This course is designed to prepare professionals for those difficult situations by sharing key concepts to maintaining objectivity. After completing this course, you should understand how to ensure your work can be represented as independent and objective, and ultimately provide the greatest risk mitigation to your company.

This course will explore the use of ChatGPT and artificial intelligence chatbot technologies in the accounting profession. Participants will learn how to utilize ChatGPT to automate tasks, improve efficiency and accuracy, and provide real-time support to clients. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Fraud continues to be a pervasive problem for organizations of all sizes and in all industries. And it can happen to your organization. Accountability professionals are the first line of defense against fraud. Accordingly, accountants, internal auditors, external auditors, and risk management professionals need to develop the skills needed to prevent, detect, and deter fraud. According to the Association of Certified Fraud Examiners’ (ACFE) 2022 Report to the Nations: Certified Fraud Examiners estimate that the typical organization loses about 5% of its revenues each year due to fraud.  The median loss per fraud case is $117,000; the average loss per fraud case is $1,783,000. 42% of frauds are discovered by tips, usually from employees. Asset misappropriation schemes are the most common (86%) but least costly ($100,000 median loss). Financial statement fraud schemes are the least common (9%) but most costly ($593,000 median loss). Corruption is the most common scheme in all global regions. These statistics are alarming and should be a wake-up call for all business and government professionals. The impact of fraud is almost always devastating and can be catastrophic. The 2023 Business Fraud Update is another fast-moving seminar that will provide a comprehensive look at the latest developments about fraud from the technical, legal, and operational perspectives and update participants on the most recent legal and regulatory developments in this important area of professional responsibility.   In addition, attendees will watch a unique and specially designed simulated case of fraud in a corporate setting and watch as the panelists, in their roles as characters in the simulation, respond to the emerging situation and deal with it as a corporate and legal matter to determine the fraud, identify the perpetrators, respond as an organization and deal with criminal and corporate fallout. Following each stage of the fact situation the entire panel will discuss the developments and consider how damage to the company could have been avoided and how it can be mitigated! **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.

Over the years, Excel has added MANY new features and functionality, yet most people still use it the same way they first learned it. Many of the features were added to Excel to enhance your ability to create spreadsheets more efficiently and with more accuracy. However, if you aren't aware of these new features, how can you use them? This class will focus on walking through each ribbon (menu) to explain the capability of various features in Excel. It is a great overview for both new and advanced Excel users to make sure you know all the capabilities of Excel. You may have seen many of the features but had no idea what they could do for you. This class will help you to understand these features and determine how you might take advantage of their capabilities. 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.

Pull together all components for an effective and tailored QM system (bold) For a quality management (QM) system to be successful, it needs achievable objectives and tailored processes in place to enable the performance of quality engagements. It also needs clearly articulated roles and responsibilities and the ability to identify, evaluate, and correct deficiencies. The revised QM standards are designed to emphasize firm leadership's responsibility for proactively managing quality, strengthening a firm's monitoring and remediation processes, and advancing the ability of the firm to tailor its system of quality management to the nature and circumstances of the firm. To succeed under these new standards, you'll need to know how to set up a functioning QM system that will help your firm identify and address risks for its audit and assurance practice. Fourth in a four-part webcast series (bold) This is the fourth webcast in a four-part series on the Auditing Standard Board's (ASB) new Quality Management Standards and looks at how to create an effective QM system. You'll take a deep dive into aspects of the ASB's Statement on Quality Management Standards (SQMS) No. 1, A Firm's System of Quality Management (ital). Attendance in each webcast in this four-part series will earn you one CPE credit. You can participate in one or all based on your interest in the topics. A rebroadcast of this webcast is scheduled for Dec.15, 2022, at 2:00pm ET.