CPE Catalog & Events

Are you looking to take your PivotTables to the next level? Many experts consider PivotTables to be Excel’s most powerful feature. Yet, most who create and work with them barely scratch the surface of all that PivotTables can do. In this session, you’ll learn eight powerful features you may have missed. From user-defined calculations to consolidating reports and adding KPIs, we’ll show you how to get the most out of your PivotTables. These are just some examples of the great things you can do with PivotTables, and in this session, you will learn these and other techniques to make your PivotTables even more powerful.

Discover the real-world power of Artificial Intelligence (AI) and equip yourself with the skills to conquer modern challenges in accounting and finance. In this engaging course, we demystify AI and unveil its practical applications, transforming it from theory into a hands-on tool. Learn the essential AI fundamentals and unlock its remarkable potential to boost your productivity and effectiveness alongside your team. Explore the specific problem-solving capabilities of AI, tailored to address the unique challenges faced by accounting and financial professionals. Gain expertise in leveraging AI features integrated into everyday applications, including the ubiquitous Excel. Uncover how these features enable you to effortlessly detect fraud, identify potential transaction errors, and elevate your financial operations to new heights. Witness firsthand how AI is reshaping the present and future of your profession, positioning you at the forefront of this revolutionary wave.  

This course will provide an overview of 6 key areas of automation that accounting firms can leverage to effectively increase their lead generation and client retention efforts while reducing the burden on their time and budget. These areas include: 1. Social media 2. Content development. 3. Email marketing. 4. Text (SMS) marketing. 5. Chatbots and other interactive AI tools. 6. Drip marketing campaigns. Attendees will receive a practical guide to the technologies and tactics needed to improve marketing efforts with efficiency and ease! 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 focuses on the key federal tax issues affecting businesses from the internal accountant's point of view, with a focus on recent tax legislation and developments.  Planning alternatives and the potential risks associated with those strategies will also be discussed.  **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.

Whether you are responsible for managing 1 employee or 20, your leadership can make or break your team. Learn practical leadership strategies that you can implement when you return to your office. In today’s competitive market, it’s more imperative than ever that as leaders we are inspiring and motivating our teams to success.  

This course corresponds to our Controllership series. This course is dedicated to exploring the traditional controller role and stepping out of the box to identify areas where the controller can continue to add strategic value to their organizations. Within this segment of our controllership series, we discuss the area of cash and investments and explore how the controller can move these responsibilities into more of a strategic role. In today’s world, the role of cash management is often a pivotal role in the organization. In economically difficult times, controllers may find that they spend a great deal of their time on understanding and managing the organizations' cash position. This is certainly important and, in some areas, can be seen as a staple of the lifeblood of the organization’s ongoing viability. This course takes a look at some of the typical objectives involved in cash management and then evaluates how those objectives can be further stretched into strategic pillars of the organization.  

Financial statement audits often involve audits of components of a larger entity. This course will focus on the responsibilities for both the group auditor and component auditor, including implementation of SAS No. 149 relate to group audits.

Many organizations have a process documented for their employment life cycle but do not look at it wholistically. Having a longer view of the employee life cycle can provide more value to your company that you might think. Join us for an interactive discussion around the entire life cycle of employees with best practices discussed on continuous improvement for your organization. This session will provide an overview of each of the steps in the timeline from multiple perspectives, to provide keen insights on actionable ideas to take back to your workplace and implement today.

Whether a financial statement preparer or user is more familiar with IFRS or U.S. GAAP, it is important to be familiar with the important differences between the two financial reporting frameworks. This course will highlight some of the more significant differences between the standards.

A detailed analysis of the calculations related to determining a shareholder's tax basis for S corporation shares and loans, with a focus on how to use Form 1120S, Schedule K-1 information for basis determination. An illustrative example demonstrates how the process works, as well as the many potential pitfalls. *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

Generative AI is seemingly everywhere, and business professionals are embracing the technology. And for a good reason - generative AI provides opportunities for enormous gains in efficiency and productivity. However, those gains can be even greater if you understand best practices for issuing AI prompts. In this session, you will learn the best ways to ask questions of your AI platforms so that you get the information you seek quickly and easily. Stop wasting time with inefficient and ineffective prompts! Learn the best ways to get the information you seek!

*** Save 15% on this event when you use the code SAVE15 at checkout *** This course helps accounting professionals transition from reactive, one-off client solutions to structured, scalable business advisory services. Attendees will learn how to identify what clients truly want, how to position and price advisory work, and how to leverage their existing client relationships to create recurring revenue opportunities. The session also covers common implementation barriers — like lack of time — and how to overcome them using systems and client conversation frameworks. Participants will leave equipped to stop doing “random acts of consulting” and start delivering impactful, profitable advisory services.

This is a dynamic course tailored for seasoned accountants who are looking to elevate their skills in navigating and leading through organizational change. This advanced program focuses on enhancing agility by providing the tools and techniques necessary to manage and adapt to rapid shifts in the accounting landscape. Participants will explore theoretical frameworks alongside practical strategies that support effective change management for diverse business environments.

This program provides in-depth coverage of SAS 145, a major standard that helps auditors enhance risk assessment procedures through improved techniques for identifying and assessing risks of material misstatement. This session is essential for CPAs that perform audits. The discussion will also be insightful for auditees and other professionals who want to maintain awareness of current auditing guidance.

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.  

This course provides an in-depth exploration of Customer Relationship Management (CRM) systems as a critical tool for business automation. Designed for accounting professionals, it emphasizes CRM's role in streamlining workflows, organizing communications, enhancing client relationships, and improving efficiency. Participants will learn about key CRM features, integration with accounting software, and best practices for successful implementation. We will highlight practical applications with actionable insights to help attendees optimize their processes. This two-hour session ensures you walk away with a basic understanding of CRM's transformative potential for business and financial management.

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.

Almost every business and individual has to file tax returns, which can be a great treasure trove of information for forensic accountants. Whether in a divorce, partnership dispute, recreating books and records, or bankruptcy proceeding, analyzing tax return information should be an initial step in uncovering income and assets. The IRS retains a large amount of information, both from taxpayers and 3rd parties who report financial transactions. This course will be your guide in gathering, analyzing, and evaluating tax return information, so that you have a full picture of the financial investigation. Your presenter is a 20 year veteran with IRS-Criminal Investigation, who used this information as a basis for his federal criminal investigations. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This comprehensive training is designed to get the accountant up to speed quickly with the complex passive activity loss (PAL) rules that apply to certain investments in trades or businesses and rental activities. The cornerstone of the course is the in-depth coverage of the detailed tax law and regulations applicable to passive activities under IRC 469 and how and when the 3.8% net investment income tax under 1411 applies. Each attendee will receive the most comprehensive passive activity reference manual with numerous practice aids and real-world examples.

The QuickBooks platform is a robust environment with features and capabilities that many users are unaware of or do not know how to utilize effectively.  This course helps you get more out of QuickBooks Desktop and QuickBooks Online and resolve the issues that even experienced QuickBooks users struggle with, such as locking down prior periods.  This program starts fast with a chapter covering the top issues accountants face with QuickBooks.  The day continues with practical guidance and solutions designed to help accountants get the most out of QuickBooks for themselves or their clients. You will learn about issues, such as setting up a new company, configuring and customizing QuickBooks preferences, and enabling system security and password protection features.  Also, you will learn how to lock down transactions in prior periods, the audit trail, customizing reports, exporting reports to Excel, and extending QuickBooks’ usefulness with tools such as the Fixed Asset Manager and Loan Manager.