CPE Catalog & Events

Charts and graphs are nothing new. However, many professionals struggle with building compelling visualizations. If that statement describes you, participate in this session to improve your skills in creating Excel charts and other visualizations. As a result, you will create visualizations to enhance your communication skills. This session is much more than just a seminar on fundamental charts. Instead, in this session, you will learn how to create advanced charts that are interactive, dynamic, and aesthetically pleasing – three qualities that will help to ensure that your readers and audience will understand the data you are presenting. This seminar is a must if you want to improve your communication skills.

Valuation techniques and cash management activities are two other tool categories that can round out your analytical toolbox. In this course we will initially discuss how to turn your financial plan into a powerful valuation engine.  We then will discuss the formation of an efficient cash management program based on solid banker relationships.  Finally, we will review Ten Steps for keeping your financial toolbox full.

Debt is a real problem for many clients, business owners, and the general public.  It can be ever increasing and causes financial, emotional and physical challenges that seem to spiral out of control. What if you could help your clients “do debt differently”? This strategy turns the game upside down and presents solutions from the inside out.  As a CPA, you are already a trusted advisor for your clients.  What if you could help your clients be free of this burden?  This is a tremendous resource you can offer to your clients, expanding the value of what you offer them by adding these processes to your packages.  Clients will be happy to pay for this kind of relief as you support them in doing debt differently.   If you are one of the many people who are personally burdened by this situation, these strategies, tools, mindsets and actions will personally help you get better results…so you can go back to the task of expanding and growing your business, sleeping better at night and gaining access to the creativity that will take you to your next level of financial fulfillment.  Paying off debt is an inside/outside job.  Successful strategies include the internal shifts to mindset and enhancing the inner qualities that are most helpful in paying off debt, and practical tools to help make the transition from thinking about paying off debt to actually doing it. This program combines both -- emotional support and dozens of tools and action steps to Do Debt Differently, including: An inventory process to objectively assess the situation and face it head on Guided mind/body processes to alleviate anxiety about the situation Creative exploration (writing and drawing) to gain clarity and specificity Stories and discussion to strengthen your access to the qualities that will be most helpful to your success Using a menu of options to create a personal action plan and an ongoing support team The techniques in this program are creative and easy, but immensely practical.   We will combine practical, nuts-and-bolts action steps with powerful tools for mindset-shifting. There is no reason to continue to suffer the burden and overwhelm of debt. Relief is here! Through discussion, interactive exercises, skill building, mindset shifting and powerful actions, you and your clients could be on your way to a debt free life. Please join me for this empowering approach to changing your financial situation.

This session explores tools and techniques that can enhance the efficiency and effectiveness of client engagements and business processes using data analysis tools. We will introduce some of today's popular and software tools and examine the AICPA's Five-step approach to incorporating data analytics into public accounting engagements. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Small businesses have better options now than ever before in the market of accounting solutions. Participate in this session to learn more about these options and which might be best for you or your clients.

This comprehensive session is a must-attend event for any professional accountant who prepares financial statements for either a private enterprise or a firm client. We illustrate best practices for presentation and disclosure by revisiting fundamentals of financial reporting for various industries. This workshop explores best practices for United States GAAP in addition to considerations for special purpose frameworks. Experienced accountants will benefit from a refresher whereas other accountants will appreciate formative skill-building insights.

This course will address recent tax legislation, rules, and developments related to capitalization and depreciation; Section 179 and 168(k) 100 % bonus deduction; Depreciation of automobiles, including new luxury auto limits; ADS depreciation for electing farm and real estate business. **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.

Staff accountants have specific needs when working with Excel – needs that are often not met by their existing Excel knowledge. Chief among these are the needs to quickly summarize data, prepare accurate and aesthetically pleasing reports, and create accounting-centric calculations for elements such as depreciation, amortization, and interest. By participating in this eight-hour session, staff accountants will gain the essential skills they need to maximize their efficiency and accuracy when working with Excel. This session begins with a quick overview of Excel best practices. It then progresses rapidly into discussions that address PivotTables, sophisticated formulas, Tables, formatting, and working with dates in Excel. Throughout the session, you will learn from accounting-centric examples to reinforce key learning points. In this session, you will learn in a “laptop-friendly” environment, and participants will have access to all the demonstration files used in the session. In sum, this seminar is a “must” for all staff accountants seeking to improve their efficiency and accuracy when working with Excel.  

When you need to create a simple survey or form to capture data online, the Microsoft 365 Forms app can be just the right solution. You can use it for simple forms such as a client information form or client service evaluation form. You can create more sophisticated forms, such as a client tax organizer. All responses can remain confidential and can be viewed in Excel format for further analysis or to prepare the form data for import into another application. This course will take you through the step-by-step process for creating, distributing, compiling and analyzing digital forms and surveys. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Signed by President Biden on December 29, 2022, as part of the Consolidation Appropriations Act, this program provides an explanation of the Secure Act 2.0 provisions impacting individuals and business taxpayers.  Learn what you need to know for this filing season and how to plan for future years for your clients. **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.

Tax Season can be a daunting time for tax preparers, but it doesn’t have to be with the help of tax automation software tools and other innovative technology. This session will provide an overview of the latest technologies and tools that can help automate your workflow and make the entire tax return preparation process smoother and more efficient. From client portals, workflow management, and e-signatures to robotic process automation, you’ll learn about all the options available to help streamline your tax preparation process. So don’t dread Tax Season - attend this session and arm yourself with the tools you need to succeed!

In this innovative course, participants will learn to combine the power of artificial intelligence with the functionality of Microsoft Excel. You will learn how to leverage ChatGPT, OpenAI's powerful language model, to improve your Excel skills and decrease the time it takes to build spreadsheets. The course will include a quick introduction to ChatGPT but the majority of the time will be spent using ChatGPT to create an Excel spreadsheet. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The amount of electronic content that business organizations contend with is growing at incredible rates. Terms like "Big Data" and "Information Overload", are being used by overwhelmed information workers on a daily basis. Additionally, because of the move to a much larger telecommuter footprint, electronic data is now even more prevalently utilized. This session discusses the places that businesses keep digital information and addresses the importance of securing corporate electronic data. The material effectively shows ways to achieve high security standards for content stored in fixed locations, on mobile devices and in the cloud. Participants in this session will gain an understanding of the concepts needed to improve the way they, and their companies secure digital information. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

A detailed analysis of the calculations related to determining a shareholder's tax basis for S corporation shares and loans. How to use the Form 1120S, Schedule K-1 information for basis determination. An illustrative example demonstrates how the process works, as well as the many potential pitfalls. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This session will provide a basic overview of Employee Stock Ownership Plans (“ESOPs”). It will specifically address what companies are well suited for establishing an ESOP, how ESOPs are implemented, and how employees and departing owners alike can benefit from them. The session is intended to provide business and tax advisors with talking points about how an ESOP may be used as a succession planning strategy.

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.

The objective of corrective action is to change conduct through teaching.  Corrective action may be sequential, out of order, repetitive, or not appropriate to take at all.  The action selected should reflect the type, frequency, and severity of the misconduct.  Changing conduct through teaching requires effective employee relations skills. This course provides practical knowledge and scripts for handling a wide array of sensitive misconduct situations with good judgment, such that personal and employer liability is avoided.

More and more entities need Yellow Book engagements, including a growing number of for-profit entities. In this course, we will review the unique independence requirements in GAGAS. We'll also review the recent changes to quality management in Yellow Book. We'll close with a reminder of common deficiencies found in Yellow Book engagements.

The QuickBooks ecosystem of accounting tools remains the most widely-used set of accounting applications used by small businesses. Yet, many of these organizations struggle because of inadequate internal controls. In this seminar, you will learn options for improving internal controls in small businesses running QuickBooks Pro, Premier, Enterprise, or Online. Participate in this program to understand how you can create a robust system of internal controls in a small business environment, including businesses using QuickBooks accounting solutions. In this session, you will also learn about the four common types of internal controls and how to assess the relative condition of the internal control structure of a small business. With this background in place, the focus then shifts to discovering the opportunities to enhance internal controls in QuickBooks-based environments using features found in the application. In addition, you will learn about additional internal control procedures for situations where you cannot establish adequate controls in QuickBooks. In sum, while many believe that QuickBooks-based organizations will forever face weak internal control structures, by participating in this session, you will learn how QuickBooks-based businesses can benefit from strong internal controls.

Understanding the dynamics of family interaction is one of the most important skills in helping a family business succeed. This course takes a candid look inside the family business, and will help the participant navigate delicate issues while learning to provide counsel that will grow - or protect - the family business and non-family staff.