CPE Catalog & Events

Wow! So many new Excel features and so little time! Microsoft continues to add tremendous functionality to Excel - the business professional's tool of choice. Yet most Excel users have not discovered these new tools and remain mired in yesterday's practices for working in Excel. In this session, you will learn how to use many of Excel's latest features to work more efficiently and effectively with your spreadsheets. Participate in this session to learn about recently released features such as PIVOTBY, GROUPBY, Office Scripts, integration with Copilot, new ways to share and collaborate in Excel, and data entry and formula improvements. If you work with Excel - and who doesn't - this session is necessary to help you improve your efficiency and effectiveness when using Excel.

Explore the transformative impact of technology on the audit profession in this forward-looking course. Gain practical insights into cutting-edge tools and trends, including data analytics, artificial intelligence (AI), and automation, and discover how these advancements are revolutionizing audit methodologies and improving audit quality. Through engaging demos, case studies, and actionable tips, you'll learn how to navigate the evolving audit landscape with confidence and adaptability. This session is designed to equip CPAs with the knowledge to embrace innovation and stay ahead in a rapidly changing profession.

Financial skills needed in many situations are constantly changing.  It is prudent to routinely look into your toolbox to restock or revise your tool set.  In this course we will examine three tool categories that form the foundation for many analytical processes.

Security is not optional, and yesterday’s security techniques do not minimize today’s security threats. Therefore, now is the time for you to tune up what you know about protecting sensitive data. This program will teach you the latest tools and techniques for securing your data, including encryption, virus protection, safe communications, electronic signatures, secure authentication, and more. You will also learn how to implement a practical, five-step approach to securing your PC and the questions you should ask your staff to ensure server-based information remains protected. Security failures, such as a breach of client or customer data, are costly – they can even drive your company out of business. So, what security tools do you need, and how should you use them to secure your sensitive data and systems? Can you afford to risk attempting to manage today’s threats using yesterday’s techniques? Participate in this program to learn how to identify viable and practical solutions to mitigating today’s security threats.  

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.

Clients are living longer. Not only does that present challenges to the work we do with them to make sure that their money lasts, but it also brings into play additional issues and challenges that we may not have had to tackle in the past. How do we plan for where clients will live (possibly as solo agers)? How do we deal with issues of diminished capacity? How do we plan for long term care and end of life issues? How do we have complicated family conversations? How do we make sure that our clients have their best long lives possible both financially and otherwise?  Find out in this session where we will present tools you can use with clients to engage them in the planning process.

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.  

An operational audit is a method of examining how an organization conducts business. It identifies areas where an entity can improve to be more effective and efficient. This course will focus on how to plan and perform operational audits, as well as delivering value-added recommendations as a result.

Performing engagements in accordance with Generally Accepted Government Auditing Standards (GAGAS), commonly referred to as the "Yellow Book," involves additional reporting, ethics, and performance requirements that go beyond those outlined in AICPA Generally Accepted Auditing Standards (GAAS). This course provides an overview of the guidance found in the Yellow Book and explores its relationship with the AICPA Code of Professional Conduct. Participants will gain an understanding of the unique CPE requirements for GAGAS engagements and review the Yellow Book standards for financial statement audits, with a focus on ethical principles and independence. This course is designed to equip professionals with the foundational knowledge needed to navigate the complexities of Yellow Book engagements effectively.  

A discussion of the latest 2021/222 tax developments impacting business taxpayers, with a focus on important provisions, rules and concepts. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Literally thousands of individual taxpayers may have increased deductions or exclusions from gross income as a result of the Disaster Relief Act of 2024. Casualty provisions of the Act are retroactive to December 19, 2019 through early 2025. Both low and high income taxpayers may benefit from the Act through exclusions of payments received as compensation for wildfire damages - retroactive to 2014! This course will review the provisions of this new act. *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

The new Global Internal Audit Standards were released on January 9, 2024, and will become effective January 9, 2025. The previous version, the International Standards for the Professional Practice of Internal Auditing, released in 2017, remains approved for use during a one-year transition period. The Global Internal Audit Standards guide the worldwide professional practice of internal audit. They serve as a basis for evaluating and elevating the quality of the internal audit function. The Standards use 15 guiding principles with five separate domains that enable effective internal audit implementation and examples of evidence of conformance. The Global Standards are organized into five domains. Domain I: Purpose of Internal Auditing Domain II: Ethics and Professionalism Domain III: Governing the Internal Audit Function Domain IV: Managing the Internal Audit Function Domain V: Performing Internal Audit Service

Managing and auditing employee spending on personal and corporate credit cards is a challenge everywhere. Legacy manual expense reporting preparation and approval processes are tedious and repetitive and are an excellent place to start your company's use of business process automation solutions. This session will cover a variety of expense workflow tools which use technologies and features like bank feeds, mobile receipt capture, OCR data extraction/filling, automated policy enforcement, and artificial intelligence-based validation to automate and eliminate the tedium. Attend this session and learn how to use automation and cure the expense reporting blues for you and your employees.

This Masterclass is a one-hour training to show accountants how they can grow their practice this year through CFO and business advisory services. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Numbers and especially the digits within those numbers can conceal a lot of information.  Benford's Law and other digital analysis techniques can be the keys to unlocking that information.  This session will explain what Benford's Law is, how it works, and how it can be used to reveal bogus information and made-up data.  Accountants and auditors should understand how to use this valuable audit tool as well as other digital analysis techniques.  But, if you attend this session, you must promise not to reveal the secret behind these techniques to any fraud perpetrators.

It is virtually impossible to pick up the daily newspaper and not find an article on some type of fraudulent event. In the wake of the “Era of Fraud, Waste and Excess,” one might suspect that potential fraudsters would think twice before committing illegal acts. However, just the opposite seems to be the case.  Is there really more fraud or is there simply more fraud awareness?  The harsh reality is that it is a little bit of each.  Not only has fraud worldwide reached a level of over $7.0 billion in lost  revenue but savvy C-level executives now realize that it could happen to their companies—very easily. When you put these facts together, it adds up to a completely new era of vigilance.

Enterprise Risk Management for SMEs

Financial statements are a window into what is going on in the day-to-day operations of the company. They help us see what the company's strengths and weaknesses are. However, financial statements can often have different messages depending on the user. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Specifically designed for preparation, compilation, and review practitioners, this course will provide you with a comprehensive review and hands-on application for performing financial statement preparation, compilation, and review engagements. You will learn the ins and outs of applying SSARS No. 21, Clarification and Recodification, as well as the additional guidance related to SSARS engagements through the issuance of SSARS Nos. 22-26 by the ARSC. In addition to SSARS 26, the entire suite of quality management standards is discussed. However, knowing the standards is not enough. You need to be able to effectively apply them. To support this, the course will review recent peer review feedback on SSARS engagements, providing insights on how to successfully apply this guidance. Not only will this course bring you up to date on SSARS requirements and guidance, but more importantly, it will provide you with practical examples and illustrations to help you effectively and efficiently perform these types of engagements. This course is intended to be your go-to reference for training your staff and managing your SSARS No. 21-26 services in compliance with professional, ethical, and technical requirements.

Governmental Accounting 101, is a 2 hour webcast that takes the participant of a whirlwind tour of governmental accounting basics, focusing on wetting the participant’s appetite for more.  This session will be the first of a series of webcasts, with each subsequent webcast delving deeper and deeper into the governmental accounting basics.