CPE Catalog & Events

This course is designed to equip CPAs, EAs, attorneys, and tax professionals with the essential knowledge and strategies needed to navigate the latest developments. Explore innovative approaches to maximize retirement savings, discuss tax- efficient retirement plan options, and align estate planning techniques with current trends. Gain a thorough understanding of altered rules for Required Minimum Distributions (RMDs) and discover how to optimize estate plans in response to changing regulations. This update is tailored for professionals seeking practical insights in the realm of contemporary retirement planning. **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.

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.

This comprehensive training is designed to get the accountant up to speed quickly with S corporation formation and preparation issues as well as a complete understanding of calculating a shareholder’s stock and debt basis. The cornerstone of this course is the in-depth line-by-line analysis of the Form 1120S Schedule K and K-1 and how these items affect the shareholder’s Federal individual income tax return. **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

In the fast moving world where everyone is communicating through email, text and instant messaging we have forgotten the power of face-to-face conversation. Communication and connection is the foundation for building a thriving network and business. During this talk, The Connector’s Advantage author, Michelle Tillis Lederman will inspire you to leverage the power of personal connection in the digital age while still incorporating the efficiency of virtual communication.

In this course, participants will learn about the five principals of COSO's Fraud Risk Management Guide and the linkages each principal has to the use of forensic data analytics to measurably demonstrate effectiveness and ROI.  We will also explore key elements to a successful program that is sustainable as well as pitfalls to avoid. Finally, we will cover several case studies that demonstrate the key concepts discussed. 

Develop financial reporting expertise to conduct an accounting analysis and detect distortions in financial statements. Accounting savvy permits the business analyst to leverage financial information to manage and implement business plans. Gain the tools necessary to become skilled at such analyses. Review the impact of financial and accounting data on the function of capital markets in relation to the changing economic landscape and globalization.

Participants will review how to maintain a heightened awareness of fraud with clients and gain a better understanding of how to detect fraud. This interactive workshop, designed for practitioners in small and medium-sized CPA firms, will include a lecture with generous time for questions and case studies to reinforce the concepts.

Data security is a top-of-mind concern for almost all business professionals, yet most struggle to achieve this objective. Make plans to participate in this session to learn about many practical tools you can use to protect your data and enhance cybersecurity.

We tend to focus on fighting today's fires without spending adequate time on bigger, more important risks inherent in today's inter-connected, competitive world. This seminar drills down into four commonly overlooked business risks, looking at how to anticipate, manage, mitigate or exploit them. We will discuss the professional obligations of the board and executive management to assess risks and the responsibility of internal and external auditors to evaluate the adequacy of these assessments.

Staff accountants often need guidance to learn which features can help them create effective Excel workbooks. This course will teach them about many of Excel's accounting-centric features enabling them to work more efficiently and generate accurate results.

Have you ever found yourself wondering why people won't just listen to you? Or maybe you have found yourself surrounded by people that make your jaw clench...you know the people...the challenging people.  HR Professionals walk a tight rope of being strong, but not aggressive, polite, but not a push over. It is exhausting! In this session, you will uncover the secrets to working with (and overcoming) challenging people derived from the decades of experience Summer brings from her time on the frontlines and as an HR Professional working with companies such as Walt Disney World, H-E-B and even a dude ranch.  

Sampling is an important method for determining the extent of testing controls, testing compliance, and tests of substantive details. It allows the auditor to apply procedures to less than 100% of the population yet extend results to project likely conclusions about the entire population. This module will describe the proper process for both attribute testing and variable sampling in financial statement and compliance audits.

In this course, participants will learn about key trends and innovations impacting the field of forensic data analytics.  From generative AI to ChatGPT, machine learning and transaction review, data sharing consortiums and cryptocurrency trends, this course is for the futurist who wants to be leading edge in compliance and anti-fraud technology innovation. 

This session takes a unique review of the fundamental budget issues faced by all and walks through a detailed modeling process intended to generate discussion and best practices to improve your organization’s financial modeling.  From the beginning of the accounting process – ‘the chart of accounts’ to the end of the process – ‘the valuation of the company’, the budgeting cycle via a live case model to learn best practices common to successful companies.   This course stands on its own but is part two of a four part budget mastery series.

Learn the basic skills new staff need to hit the ground running and efficiently complete assigned tasks, including what new auditors are expected to know and do, including the nature, timing, and extent of common audit procedures. Focus on why certain procedures are performed and perform typical procedures.

This comprehensive course provides the essential updates for professionals working with governments and not-for-profit organizations. We'll begin with an in-depth review of recent GASB standards, including compensated absences, certain asset disclosures, risk and uncertainty disclosures, and financial reporting model improvements. For each standard, we'll cover its background, potential impact, and practical strategies for implementation to ensure you're fully prepared. Next, we'll shift focus to the FASB and its implications for nonprofit organizations. While there haven't been recent nonprofit-specific standards, several Accounting Standard Updates (ASUs) significantly impact NFPs. We'll explore these ASUs, evaluate changes to programmatic investments, and discuss their interplay with the CECL standard. Additionally, we'll highlight the movement in IFR4NPO, a global initiative to develop universal financial reporting standards for nonprofits, offering insights into its potential worldwide impact. In the second half, we'll turn to governmental auditing. Key topics include the 2024 Yellow Book updates, the transition from quality control to quality management, and the implementation timelines. For Single Audits, we'll cover the 2024 Uniform Guidance changes, the 2025 Compliance Supplement, GAO reports on improper payments and fraud, the Financial Data Transparency Act (FDTA), and recent Department of Education guidance on related parties.  

Microsoft Office Excel is one of the most widely used applications by accounting and financial professionals. Yet, many remain unaware of new and improved features in Excel and, therefore, fail to reach the level of productivity and accuracy they desire. Further, with new features appearing in Excel provided through Microsoft 365 subscriptions and Excel 2024, it is more important now than ever to get up-to-speed on the world’s most popular spreadsheet! Make plans now to elevate your Excel skills by participating in this session. You will learn about the newer features available to improve efficiency and accuracy in it. You will also learn about the importance of numerous legacy features in Excel and how you can – and should – continue to use these tools to improve productivity.

Whether you're heading across town or across the globe, traveling with electronic devices carries real risks to the sensitive client and firm data stored on them. In this session, we'll explore the ethical obligations CPAs have to protect confidential information, including guidance from the AICPA Code of Professional Conduct and applicable laws. We'll examine how data can be accessed — legitimately or maliciously — by third parties during travel, and offer practical strategies to minimize risk, from using loaner devices and mobile device management to coordinating with IT before departure. The session includes current border search rules, international considerations, and actionable tips for staying secure in transit.

The enforceability of non-compete agreements in the U.S. is in flux. While the FTC's proposed ban is on hold pending legal proceedings, existing state laws continue to govern the validity of non-compete clauses. Some states, like California, Oklahoma, and North Dakota, prohibit non-compete agreements, while others enforce them under certain conditions. Although state laws vary, non-competes are often used to protect the creation and development of corporate goodwill, customer relationships, and specialized training, among others. Today, employees are more likely to be asked to sign non-compete agreements as a condition of employment. Non-compete agreements are also a common component of a business sale agreement. This program surveys non-compete agreements from all angles, including the current state of play regarding the usefulness and enforceability of agreements going forward. Whether you advise individual clients or work for an employer, this course provides an understanding of common issues that arise in the negotiation and enforcement of non-competes.

When putting together a financial plan, it is important to remember that the tax situation of the business and the individual are often intertwined. Therefore, decisions about entity type are vitally important. Practitioners need to understand not only how different entities are taxed, but also which taxes will have the greatest impact on the individual owner. In this course, we will explore when self-employment taxes apply to business income, as well as some of the lesser-known taxes that apply to flow-through entities. We will even explore when a PTE election could be helpful to a small business owner.