CPE Catalog & Events

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 introduction to governmental budgeting course is an overview of the typical timeline and process a government uses when creating their annual budget. Topics covered include, the basics of governmental budgeting, establishing priorities for the budget, the common steps and timeline of the budget process, what, when and how we should be monitoring the budget throughout the year, and how long-term budgets fit in with the annual budget process.

If you or your clients are facing that stage of life where careers are passing into the background, and a new "to be determined" life is emerging, then you are entering what is called "retirement". Some people are excited, some are scared, and most are both. There are many issues and questions people face at this time - what to do with time, financial, relationships, health, identity and more. This program summarizes the key research studies, provides stories from those who have made this work, and offers thoughtful, practical exercises from my award winning book NEXT STAGE. It will help you (or your clients) address key issues and develop a Master Plan for the transition. If not now, when? 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 is designed to present the most significant types of financial statement fraud and embezzlement, illustrated through case situations. We'll distinguish financial reporting fraud from misappropriation of assets and highlight common schemes involving one or both types of fraud. We'll also review high-profile cases and other real-world situations to emphasize the CPA's role and responsibility. Get ready to examine the methods used to perpetrate and disguise schemes, how the fraud was detected, and the consequences, and explore the CPA's role in preventing and detecting both types of fraud.

Just about every company, no matter its size or the types of activities it undertakes, is at greater risk because of all the types of fraud that can be be carried out electronically. Potential perpetrators can be operating internally or externally and the scope of the damage that occurs is almost never limited to cyber-assets. While threat awareness is improving, there are still too many owners or top level executives that underestimate the scale of the issue. In this session, we delve into the types and the nature of many electronic defalcation schemes. The material then explores measures that organizations can implement to help stop these activities and add additional layers of security. 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 critical issues and special opportunities facing S-corporations, with a focus on reporting shareholder basis and distributions. **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.

Quality management is important.  Every CPA firm that provides audit and other attest services must undergo a third-party quality control review.  This session will provide you with the tips on how to avoid common quality control deficiencies in all services that are subject to peer review.

This 8-credit boot camp is perfect for accountants in public practice or industry who work with nonprofit and governmental entities. The course starts by exploring key financial reporting differences for these organizations, providing a solid foundation for understanding what makes their accounting and auditing unique. Participants will then dive into the essentials of Yellow Book and Uniform Guidance audits, gaining practical insights to confidently navigate these specialized areas. Whether you're new to the nonprofit and governmental arena or seeking a refresher, this course equips you with the knowledge and tools to succeed.  

Learn how to enhance your Excel workflows with AI in this course, "AI-Powered Excel: Leveraging AI and ChatGPT for Supercharged Productivity." Discover the various AI features built into Excel and how to use ChatGPT to create, understand and troubleshoot Excel functions and formulas. Imagine turning two-hour Excel tasks into two minutes of effort! This course will help you streamline your Excel work, research and documentation, saving you time and effort in your day-to-day tasks.

This advanced course is designed to complement the 4-part 706 Preparation Series and will discuss various aspects of the Generation-Skipping Transfer Tax.

Elevate your data analysis capabilities with our focused course on Power Query. Tailored for financial professionals, this training will show you how to get started using Power Query and teach you some of the ways to take advantage of its ability to handle messy data and automate repetitive tasks. Harness the efficiency of Power Query to revolutionize the way you work with data. Learn how to "program" your tasks once and set them on repeat, eliminating the need for repetitive, robotic work. This automation not only saves time but also ensures consistency and accuracy in your data processes. Whether you're dealing with complex datasets or simply looking to streamline your reporting processes, this course will equip you with the tools and knowledge to make Excel work for you like never before.

Many finance departments spend considerable time managing cash, particularly if the organization is highly leveraged or cash rich.  Many opportunities exist to reduce your financing costs or increase short-term cash returns if you manage cash effectively.  This session will cover a wide variety of day-to-day cash management tools.  

Discover critical insights from the latest Department of Labor studies on employee benefit plan audits and tackle the pressing issue of audit deficiencies head-on. This course dives deep into the most common errors undermining audit quality and explores the underlying causes of these issues. Through practical strategies, engaging case studies, and regulatory guidance, participants will learn how to close gaps in compliance, enhance audit execution, and protect plan participants and beneficiaries. Whether you're an experienced auditor or new to benefit plan audits, this course will equip you with the tools needed to elevate audit quality and ensure regulatory compliance.  

This course is designed for financial professionals looking to understand Form 1120S. It covers the essential aspects of S corporation taxation, including the preparation of Form 1120S, determining taxable income, and accurately reporting and allocating income, deductions, and credits. Participants will also learn how to calculate shareholder basis and understand the strategic advantages and limitations of an S corporation.

Human Resources professionals are often tasked with investigating allegations of employee misconduct, discrimination, and others. Investigation training is traditionally presented from the position of an outsider looking in, such as a governmental agency, law firm, or private investigator. HR investigations require similar skills, but the environment and the approach are quite different. This session provides best practices for interviewing to gather accurate information, such as creating and asking open ended questions, effective listening, and understanding verbal and non-verbal communication. Attendees will end the session with takeaways to immediately implement in future HR investigations. Two of three Episodes in the series.

As litigation becomes more complex, attorneys are relying more on accountants to serve as consulting experts or expert witnesses at trial. Serving as an expert witness is not as difficult as you might expect. Accounting experts educate lawyers and jurors on issues such as valuation, tax liability, and forensics. Learn how accountants become expert witnesses, the role they play during pre-litigation through to trial, and the techniques experts employ to avoid challenges from opposing counsel.

In order not to perform an excessive number of audit procedures (over audit) auditors must perform procedures in order to determine in what areas are there weak internal controls that could result in a risk that the financial statements would be materially misstated and not be detected.  SAS No. 122, AU 300 – 499, Measuring Audit Risk provides guidance as well as required procedures that must be performed in every audit in order to determine the risk of material misstatement.  No longer can the auditor state that they assess the risk of material misstatement at maximum without having a basis for making such assessment.  As a result, the standards now require that the auditor make such an assessment of a material misstatement of the financial statement on every audit in order to have a basis for such assessment.  This program is an overview of the statement documentation requirements in assessing such a risk.

Unlock the full potential of Microsoft Excel PivotTables with this comprehensive course. This training is designed to equip participants with the skills to effectively analyze and summarize data, transforming raw numbers into actionable insights. Whether you're a seasoned professional or new to data analysis, this course provides an in-depth understanding of PivotTables and their capabilities, helping you uncover patterns, compare data, and make informed decisions. The program includes a step-by-step approach to creating and customizing PivotTables, focusing on how to use them to analyze data efficiently. Participants will learn how to group and filter data, identify trends, and apply advanced features to solve real-world business challenges. Beyond technical knowledge, this course introduces data visualization through PivotCharts, teaching participants how to present their analysis effectively to stakeholders. By the end of the course, you'll not only master PivotTable fundamentals but also gain advanced techniques to streamline data analysis and support strategic decision-making in any context. 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 equips practitioners with the knowledge to help clients navigate complex tax and financial challenges. Covering a range of difficult situations—such as divorce, bankruptcy, and other personal and business matters—this course provides key tax insights and strategic planning considerations. Participants will gain practical strategies to support clients in making informed decisions while understanding the tax implications of these situations.

Properly designed and effectively operating internal control over financial reporting is critical for preventing, or detecting and correcting, material misstatement. This course describes how to satisfy the audit requirements related to taking a control reliance strategy by testing the operating effectiveness of internal controls, while promoting an effective and efficient financial statement audit. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.