CPE Catalog & Events

Power Query and Power BI offer great opportunities for accessing your data and making it more useful in reporting scenarios. Learn how to benefit from these tools in this session.

Preparation, compilation and review engagements continue to be a hot topic for peer review despite SSARS 21 having been around for nearly a decade. This course will concentrate on the most common peer review findings with a focus on how to comply in an efficient but practical perspective. This course will discuss the root cause of noncompliance so that overall engagement quality increases.

Most organizations manage their income statement, but many virtually ignore the balance sheet until balance sheet problems create seemingly insurmountable emergencies. This session discusses how to analyze and manage your financial statements more holistically, allowing you to identify and correct balance sheet issues early. How do you choose whether to raise debt or equity? What are the key considerations and the advantages of each? What is the cost of capital? What are the ‘hidden’ balance sheet risks? We will also examine several crucial ideas you can incorporate into your analyses to enhance performance and reduce risk. If you want to enhance your corporate finance skills, this session is for you.

Navigate the intricate world of tax compliance for fiduciary entities with confidence through this comprehensive course tailored for financial professionals. Gain practical insights and expertise in preparing the U.S. Income Tax Return for Estates and Trusts (Form 1041), addressing specific issues surrounding decedents' estates and trusts. Delve into the fundamentals of Subchapter J of the Internal Revenue Code and master the art of compliance while decoding complex tax regulations. With engaging case studies and line-by-line instruction, participants will acquire the skills necessary to recognize and address key components of Form 1041, ensuring accuracy and efficiency in tax preparation. Don't miss this opportunity to enhance your proficiency and advance your career in fiduciary taxation. **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 course will start with the Accounting Standard Updates effective in 2024 for public entities, private entities, and nonprofits. We'll then switch our attention to the items coming down the pike, including a look at the projects identified by the FASB's Invitation to Comment: Agenda Consultation. We'll also review year 2 considerations for leases including modification accounting. Then we will switch gears, switching to the audit side of the house. We'll review the impact of the changes to auditing  group audits as well as the status of the AICPA's quality management project management. This course will keep auditors up to date on the work of the ASB.

This is a two-part series that discuss new trends and concepts the financial controller should begin to execute in order to truly become a valued member of the senior leadership team. The rapid pace of the evolving technological landscape has promoted changes in how accountants and financial professionals focus attention on strategy and modernize their roles to leverage digital technology. There is increased demand for enhancing flexibility into finance cycles and initiating real-time reporting and insights. These are the core attributes that will assist in transforming the work that controllership function performs. Is the financial controllership prepared to meet future business demands? The IMA® (Institute of Management Accountants) and Deloitte’s Center for Controllership aimed to better understand the current state of controllership and expectations of future demands for controllers and accounting professionals. They conducted a survey in late 2022 and identified several trends. The survey takes a look at how prepared controllership is to meet future business demands. It also highlights some insights for leaders to consider that may increase their preparedness. It also identified areas of additional insight and questions to answer on the controllership transformation journey. In this segment one, we go through numerous concepts in detail and the remaining concepts will be covered in segment two.

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.

Learn to manage difficult colleagues with gloves - kid gloves, not boxing gloves. Having even one difficult person in your department can tax your restraint and deplete the time and energy you need to supervise your team. "Handling Difficult People" teaches you how to manage challenging colleagues without sacrificing everyone else to the process. This workshop is designed to help you learn to recognize difficult behavior before it gets out of hand and to understand why difficult people behave the way they do. You'll work with a three-part problem-solving model and study a five-step process for initiating the dialogue through to planned resolution. And you'll leave with an action plan to address specific situations in your workplace.

Enterprise Risk Management for SMEs

Embezzlement happens often to many small businesses. Unfortunately, the lack of internal controls allow the embezzlement to remain undetected for years. But when it is discovered, the small business owner will most likely contact their CPA for advice. What should you do when your client contacts you about their employee embezzling money from their business? What options should you present to your client? How can your client protect themselves, while investigating the embezzlement? What steps need to be taken about preserving any documents, emails, texts, or phone calls? This course teaches how to engage the client, properly identify the evidence needed to prove the crime, how to write the report for civil and criminal trial, and best practices in preserving electronic and paper evidence. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Best Practices for Identifying and Evaluating Audit Risk - Linking Risk to the Detailed Audit Plan will emphasize the key concepts and best practices that drive a thoughtful risk-based approach to forming an opinion on the financial statements. Properly identifying, assessing, and responding to risk through a detailed audit plan is critical to an effective and efficient financial statement audit. Note: This course is recommended as a part of a 16-hour audit skills curriculum for experienced staff, while it is also appropriate for anyone who has the need to better understand how to link risk assessments to the detailed audit plan. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This is a continuing part of our series on forensic accounting. Within this segment we discuss the concepts that are part of computer forensics known as cryptology. The term cryptography is from Ancient Greek and means “hidden secret”. It is the practice and study of techniques for secure communications in the presence of adversarial behavior. Cryptography is about constructing and analyzing protocols that prevent third parties or the public from reading private messages. Cryptography starts with secrets. Various aspects in information security such as data confidentiality, data integrity, authentication and non-repudiation (where a statement’s author cannot successfully dispute its authorship) are central to modern cryptography.

The Department of Justice updated guidance regarding their evaluations of Corporate Compliance Programs in March 2023: “Prosecutors should assess whether the company’s complaint-handling process includes proactive measures to create a workplace atmosphere without fear of retaliation, appropriate processes for the submission of complaints, and processes to protect whistleblowers.” This course offers recommendations for employers to consider when developing or augmenting an internal complaint handling process. Organizations benefit when whistleblowers trust the process and choose to promptly report their concerns internally. The measures offered promote a strong speak up culture and align with the Department of Justice's guidance. 

Pro forma statements are used by businesses to make decisions on planning and control, as well as for external reporting to owners, investors, and creditors. For example, giving financial estimates for a given period in a standardized manner is known as “presenting pro forma,” a Latin phrase that means “as a matter of form.” Pro forma statements can be helpful tools for business owners, investors, creditors, or decision-makers to analyze various scenarios of future events based on certain financial assumptions. It might aid in making predictions performance of the company. A pro forma income statement displays a firm’s anticipated sales and revenue. It also highlights anticipated fixed or variable operational expenses and, in the end, displays the potential profits and retained earnings for a future financial quarter. There are various types of pro-forma statements and methods to develop them. The responsibilities/competencies of the Financial Controller position (FC) has changed in recent years. However, the creation of pro forma financial statements is still a core part of their responsibility.  

Quality management will have a big impact on CPA firms. This course will cover both SQMS 1 and 2 as well as the related engagement level standards (SAS 146 and SSARS 26). The new standards will require a risk-based approach to quality management as well as the documentation of an information & communication process. This two hour class will provide a deep dive into what you need to know to start your implementation process!

This course will start with a review of the impact of the 2024 Compliance Supplement on Single Audits as well as the changes to the Uniform Guidance. We will also review common audit deficiencies found in Single Audits.

The course provides a concise overview of cognitive biases - thinking errors and "brain bugs" that may distort perceptions, compromise ethics, trigger inaccurate judgments, and spark illogical interpretations in your accounting work. Discover the most common types of cognitive biases in the profession, and how to recognize and address these flaws and blindspots in your "mental firmware". This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Every business needs capital, and capital has a cost. Providers of debt and equity demand a return and the combination is the cost of capital for the business. This session discusses how to calculate the cost of capital, how to use it to make superior business decisions every day and some common ways organizations misuse this number. Who should understand your organization’s cost of capital? Even if you are not yet the CFO, you need to thoroughly understand the cost of capital and its use. The cost of capital allows managers to, “Get the biggest bang for the buck.” If you want to enhance your corporate finance skills, this session is for you.

Collaboration is more important now than ever. In this session, you will learn how to take advantage of today’s collaboration tools to improve accuracy, customer/client service, and organizational efficiency.

Companies often offer stock options as an additional form of compensation to attract and retain the best talent. Used appropriately, stock options can generate significant wealth. Yet many employees are unfamiliar with how stock options work and why options serve as a valuable opportunity for employees to establish and grow their wealth. Unfortunately, employees who receive stock options are often unaware of their inherent risks. Research has shown that over 75% of employees have never exercised their stock options. Almost half of these individuals (48%), say they held off on selling their options due to fear of making a mistake. This course provides accounting and financial professionals with a broad overview of employee stock options. The webinar is designed to help participants better understand the fundamentals behind these investments and in turn, better advise their clients.