CPE Catalog & Events

This Masterclass is a one-hour training exclusively for CPAs and accountants. Rely less on tax season and use your expertise to help business owners have a better future! Designed for CPAs, but also applicable to enrolled agents and accountants, this webinar covers the steps necessary to effectively transform a tax or accounting practice into an advisory service. We explore what it means to be a CFO/advisor to small-to-medium sizes businesses and what qualifications are necessary to offer such a service. We will also cover how to find and convert leads and how to price and package services, including combining advisory services with the firm's current offerings. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Building on Part 1, this course will review the application of sampling in financial statement audits with a focus on sampling for tests of controls. We'll also review the requirements for sampling in Single Audits with a focus on tests of controls and tests of compliance. 

Data security and privacy issues continue to plague businesses of all sizes. No matter where you look, the numbers are bad – really bad! But that doesn't mean you can't take steps to reduce these risks. In this session, you will learn about the key security and privacy risks facing businesses today and the steps you can take to mitigate these risks. This session starts with a review of how cybercriminals attack businesses of all sizes and the related costs of these attacks. From there, you will progress into discussions of practical tools, policies, and other solutions you can use to mitigate cybersecurity risks to prudently acceptable levels. This is a "must-see"session for all concerned about data security and how to mitigate threats to sensitive and confidential data.

When exit planning, it is important to weigh various issues, including tax implications, to achieve an effective management and/or ownership change. Many envision tax-free reorganizations being the most preferable structure to avoid capital gains tax, but the opportunities come at a cost to the seller. This course will provide a well-rounded discussion of the various strategies to consider when advising on exiting a business.

With approximately 500 functions now available in Excel, some newer and more powerful tools are easy to overlook. But, if you do that, your productivity will suffer. In this session, you will learn how to take advantage of many of Excel’s more advanced features – some new and some legacy – to elevate your productivity to higher levels. In this session, you will learn about many of Excel’s newer tools, including XLOOKUP, SUMIFS, SWITCH, and STOCKHISTORY. Also included in this session are discussions of advanced financial functions, such as IPMT and PPMT, and how to retrieve summarized data easily using GETPIVOTDATA and CUBEVALUE. Additionally, you will learn how to make sophisticated calculations easier with Dynamic Array formulas, harness the AGGREGATE function's power, and create more accurate forecasts with Excel’s FORECAST.ETS function. No matter your experience working with Excel, participating in this course will help you work more efficiently and effectively in Excel.

Debt is typically a critical component of the financial statements, impacting the economic decisions of financial statement users. This course will address common issues that may impact the proper presentation and disclosure of debt, including debt covenant compliance and other issues that impact classification of the liability between current vs. noncurrent. 

Do you get bored with similar rubrics’ cube COSO risk model courses?  They are important and great, but this course is intended to offer a fresh approach on the view of risk using the dynamic landscape of modern business; CFOs are charged with navigating an array of external and internal risks that can impact organizational performance and sustainability. This seminar will empower finance professionals with the foresight and practical tools needed to understand, anticipate, and mitigate both external and internal risks. We must be aware and anticipate. If we do not adequately prepare, we will be exposed to avoidable and onerous risk. Essential for leaders and organizations that want to survive and thrive. This seminar stands on its own but is also part of the Common Sense CFO series.

This course examines the critical issues and special opportunities facing partnerships and their partners, as well as the relationship between limited liability companies and partnerships, with a focus on reporting tax basis capital accounts. **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.

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.

Prior to the COVID-19 pandemic, telework in state and local government was not often embraced as a form of employment. As the pandemic continues, governments are beginning to experience the benefits of remote work and are reevaluating hiring practices to offer more telework and hybrid work options, not simply as a result of an emergency. This course will review various telework options and best practices for success. 

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.

Sometimes the vernacular of accounting seems more challenging than technical aspects. This session offers suggestions for translating the foreign language of taxation into tangible terms for non-accountants. We explore techniques for simplifying the complexity of taxation terminology. This course will equip you with tools for demystifying tax technicalities so you can help clients and other non-tax professionals grasp fundamental concepts. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Today’s economy and all of the digital enhancements have impacted the way companies engage with their customers as well as how the company manages their internal practices. The business control function needs to keep pace. The rising importance of analytical capability is critical when defining the role of the modern controller. Execution of analytics can vary but there are still key questions that must be asked. What are the options and what we need to understand to decide the best way forward? This course focuses on the value that can be brought by the Controller when becoming involved with data analytics powered by technology and also Big Data. The digitized world we live in has made it important for the Controller function to evolve and take on this advanced task.  

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. 

SAS 145, Understanding the Entity and Its Environment and Assessing the Risks of Material Misstatement, was issued in October 2021. The audit standard amends AU-C 315, including many changes to address common audit deficiencies. This course will provide an overview of SAS 145 and its changes to AU-C 315. Attendees will have an opportunity to evaluate the impact on audit methodology and documentation.

In today's rapidly changing world, finance professionals are required to wear many hats and are often the keys to the success of the organization. On one hand, they need to be abreast of the latest proven financial skills for making the best decisions, and on the other hand they need the best skills to motivate, manage, and lead people. Being pigeon-holed into one area or another is neither good for career building nor good for the organization. We'll cover the latest issues that all CFOs and controllers need to know about and provide how-to guidance to allow for immediate use in their organizations.

This program will provide a detailed analysis of the real estate professional passive activity rules, including forms reporting examples, and integrates those rules with when real estate is considered a "business" under the Section 199A flow-through entity deduction. A detailed analysis of the self-rental passive activity rules will be given, including forms reporting examples and integrates them with the flow-through entity rules related to self-rental. *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

Retaining Talent in a Competitive Marketplace -Creating a Benefits Program Employees Care About In today's competitive marketplace, retaining talented employees is becoming increasingly difficult. A solid benefits program can make a difference in the fight for talent - but only if those benefits matter to the employees you are trying to hire! Through statistics and case studies, this course will explore what benefits are most valuable to employees. We will also explore the basic types of retirement and health insurance plans and discuss what financial leaders should consider before adopting a benefits package. 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 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 event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Tax professionals can enhance their practice by studying tax-saving strategies for individual clients.