CPE + Events Catalog

Staff accountants have specific needs when working with Excel. Unfortunately, their existing Excel knowledge often does not meet these needs. Chief among these are summarizing data quickly and accurately, generating accurate and aesthetically pleasing reports, and creating accounting-centric calculations for elements such as depreciation, amortization, and interest. By participating in this eight-hour session, staff accountants will gain the essential skills to maximize efficiency and accuracy when working with Excel. This session begins with a quick Update of Excel best practices. It then progresses rapidly into discussions that address PivotTables, sophisticated formulas, Tables, formatting, and working with dates in Excel. Throughout the session, you will learn from accounting-centric examples to reinforce key learning points. In this session, you will learn in a "laptop-friendly" environment, and participants will have access to all the demonstration files. In sum, this seminar is a "must" for all staff accountants seeking to improve their efficiency and accuracy when working with Excel.

This series includes four 2-hour consecutive Friday sessions, airing live beginning August 02, 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.

Adapting to the Engagement - Differentiating the Requirements of Preparations, Compilations, Reviews, and Audits is a critical foundational course. A CPA may perform various attest services under relevant professional standards, including compilations, reviews and audits. Reviews and audits are also considered assurance services, providing either limited or reasonable assurance that financial statements are free of material misstatement. In addition, the CPA may perform non-attest services, such as bookkeeping or preparation of financial statements. CPAs must fully understand the professional responsibilities related to each of these varying levels of services, in order to effectively and efficiently satisfy engagement objectives. Note: This course is recommended as a part of a 16-hour audit skills curriculum for beginning auditors and attest providers, while it is also appropriate for anyone who has assurance responsibilities under the SSARS. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Who investigates tax crimes and how are tax crimes prosecuted? Considered the "World's Finest Financial Investigators", the IRS-Criminal Investigation (IRS-CI) has sole jurisdiction in tax crimes and boasts a greater than 90% conviction rate. This agency was responsible for Al Capone going to federal prison and 90 years later they continue to investigate tax crimes such as tax evasion, filing false tax returns, and unpaid employment taxes. The course discusses how IRS-CI finds tax cases to prosecute, what happens during the course of the investigation, what techniques are used to prove tax crimes, what federal criminal statutes are commonly used, how IRS-CI evaluates an investigation, and the expected consequences of a successful prosecution.

Once an employee decides to report an issue, the risk for retaliation must be minimized. Metrics matter. As such, capturing and reviewing employee data for indicators of possible retaliation are key to protecting those who report. The more subtle forms of retaliation, though, require a focused communication plan to address. This course offers recommendations for implementing specific retaliation monitoring protocols.

Why do for profit organizations exist??? To make money!!!!! What a great concept. But if the organization does not have the proper collections and credit procedures in place, they may not be able to access that money. Hence the importance of the credit and collection process. Credit and collections are critical areas for the financial statement controllers. Customer credit is a form of payment that allows small business customers to purchase a product or service before paying for it in full. The process works similarly to the way a credit card does - you procure something and pay it back later. Collections is a term used by a business when referring to money owed to that business by a customer. When a customer does not pay within the terms specified, the amount of the bill becomes past due and is sometimes submitted to a collection agency. The sales and collection process includes business activities related to selling products and services, maintaining customer records, billing customers, and recording payments from customers. It also includes activities necessary to manage accounts receivable, such as aging accounts and authorizing credit.  This course delves into the topics that impact the sales, credit and collections process for management. We discuss strategic steps management can take to ensure their processes are efficient and that they are able to actually collect their revenue.  

This course is a complement to our series on Becoming a Forensic Accountant and the focus of the course is on steganography techniques. Steganography is the art and science of embedding secret messages in a cover message in such a way that no one, apart from the sender and intended recipient, suspects the existence of the message. The first use of steganography can be traced to 440 BC when ancient Greece, people wrote messages on wood and covered it with wax, that acted as a covering medium Romans used forms of Invisible Inks, to decipher those hidden messages light or heat were used. During World War II the Germans introduced microdots, which were complete documents, pictures, and plans reduced in size to the size of a dot and were attached to normal paperwork. Null Ciphers were also used to hide unencrypted secret messages in an innocent looking message. Given the amount of data being generated and transmitted electronically, it’s no surprise that numerous methods of protecting that data have evolved. There are various types of steganography: Text Steganography - Hiding information inside the text files. This involves changing format of existing text, changing words in a text, generating random character sequences or using context-free grammars to generate readable texts. Image Steganography - Process of hiding text in an image without distorting the picture. Video Steganography - Technique to hide any kind of files into a cover video file. Audio Steganography - The secret message is embedded into an audio signal which alters the binary sequence of the corresponding audio file. Network Steganography - The process of utilizing active network protocols as carriers to transmit a covert message, undetectable by an uninformed party, from a host to its destination. This session will review these methods and also discuss relevant software.  

One of the most significant challenges facing auditors is the prevalence of fraud that exists in today's business environment. All auditors should have a working knowledge of the requirements in professional literature regarding fraud. We will cover the issues that all auditors need to know about fraud and the people who commit fraud. This course will provide horror stories about frauds that have occurred and how they were detected. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

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.

This comprehensive four-hour course takes CPAs beyond the basics, diving deep into the ethical quandaries that professionals face. Beyond just the rules of Circular 230, you'll explore a variety of ethical issues, discovering the best ways to handle them with integrity and wisdom. The course provides a dual focus: understanding your obligations under Circular 230 and tackling wider ethical challenges that can arise in your day-to-day work. With real-world scenarios and interactive discussions, you'll come away with practical solutions and the confidence to make the right decisions, keeping your practice ethical and your professional standing secure. **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.

Recall lessons learned and practical implementation challenges and complexities with the FASB's Accounting Standard Update for Leases (ASC Topic 842). Identify key differences between ASC Topic 842 and ASC Topic 840, Practical Expedients, remeasurement-triggering events. Session will go beyond the basics and will apply to specific examples. 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 it's most basic level, payroll consists of an agreement between an employer and employee related to compensation for services. However, 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. Ethics in payroll is present in every step in the payroll process, from handling employee confidential information and dealing with pay, compensation and fringe benefits, to acting as an intermediary on behalf of federal, state, and local governments in the collection and remittance of payroll taxes. All levels of payroll staff- from payroll processor to payroll manager to CEO - encounter ethical considerations in their conduct when dealing with payroll matters. This course will discuss ethics as it pertains to payroll. Attendees will leave with a comprehensive framework for ethical decision making in the payroll function, as well as some real-life examples of what happens when stakeholders in the payroll process make the decision to decouple ethics from payroll. 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 a general understanding of the new reporting and disclosure requirements for employee benefit plans under the now effective SAS 136, the AICPA's new employee benefit plan auditing standard. Participants will be provided with an insight into the common errors and mistakes made by auditors and plan administrators, as well as the new requirements of both groups under the new SAS. The course will discuss the results from the Department of Labor's ("DOL") Criminal Enforcement initiative and audit quality study, and focus on the causes of the recent increase in the number of deficient engagements identified by the peer review process. This course will provide auditors and plan administrators with up-to-date information regarding defined contribution plans auditing, reporting and disclosure requirements, including those related to the new ERISA Section 103(A)(3)(c) audits under SAS 136.

When a purchaser buys an existing partner's partnership interest or the interest of a member of a limited liability corporation (LLC) taxed as a partnership, the amount paid becomes the basis for the purchaser's partnership interest (outside basis). If the partnership's assets have appreciated sufficiently, the difference between the new partner's inside and outside basis can be substantial. This disparity can deprive the new partner of depreciation deductions and inflate his or her share of the gain from subsequent property dispositions unless a Section 754 election is in effect. The Section 754 election can also apply when a partnership makes a distribution of property and the basis of the distributed property to the partnership and the basis the partner/distributee will take in the distributed property are not equal. In this case, a partnership can recover basis it would otherwise lose if the 754 election were not in effect.

Valuation techniques and cash management activities are two other tool categories that can round out your analytical toolbox. In this course we will initially discuss how to turn your financial plan into a powerful valuation engine.  We then will discuss the formation of an efficient cash management program based on solid banker relationships.  Finally, we will review Ten Steps for keeping your financial toolbox full.

This course will explore significant elements of the FASB's technical agenda, focusing on recent updates to revenue recognition and lease accounting standards. A Special Purpose Framework overview will be provided, which may reveal salient alternatives to U.S. GAAP for certain entities. 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 provides a concise overview and non-technical explanation of the Omniverse and Metaverse - a shared virtual space that integrates various virtual, augmented, and actual realities. While futurists have been predicting and describing this concept for decades, interest and investment in this platform have recently exploded. Facebook has changed its very name to Meta - as in Metaverse - to reflect its pivot from a social media company to a virtual space company. Other tech companies, big and small, have announced ambitious plans to enable people to access digital environments and experiences through different devices. While sometimes perceived as science fiction, the metaverse is no entertainment gimmick. A growing consensus is that it will be the successor to the mobile Internet, and fundamentally transform the Internet, and perhaps even reality itself. You'll walk away with a foundational understanding of how the metaverse is transforming the modern business world, and how accountants can position themselves for success in this emerging economic digital dimension. 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.