CPE Catalog & Events

Join us for an in-depth webcast on Charitable Remainder Trusts (CRTs) and the essential aspects of preparing Form 5227.  This course will provide a comprehensive overview of CRTs, including their purpose, benefits, and practical considerations. Moreover, we will delve into the intricacies of Form 5227, the informational return for charitable remainder trusts, ensuring you have the necessary knowledge to accurately complete and file this crucial document. During this webcast, Art Werner will guide you through the fundamental concepts of Charitable Remainder Trusts, illustrating how they can be utilized as a strategic tool for tax planning. We will explore various types of CRTs, their formation, and the different scenarios in which they are most beneficial.  A significant portion of the webcast will be dedicated to Form 5227, the reporting requirement for charitable remainder trusts. We will provide an in-depth analysis of the form's components, line by line, ensuring you gain a comprehensive understanding of the information it requires. From trust assets and income to distributions and charitable beneficiaries, we will cover each section, discussing common pitfalls and best practices for accurate reporting. Mr. Werner will address the recent updates and changes to Form 5227, enabling you to stay up to date with the latest compliance requirements.   **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.

How do you raise your skills to the next level to master the Controller or CFO role?  Welcome to a course that provides insights that align the CGMA Competency Framework. The course will examine each of the areas: Technical, Business, Leadership and People to increase your competency.  How are your technical skills?  Are you a traditional accountant or have you learned to expand your technical skills to go beyond “what are the financial numbers?” to “why did these financial results occur?”  Are you able to use ratios to understand the business dynamics and the implications to change course or take corrective action?  Are the systems that you implement and operate best practices or merely stop-gap solutions? How are your business skills?  Can you set a vision? Can you develop a strategy?  Do you understand the macroeconomic environment of your organization?   Can you lead a major project to a successful conclusion?  This session will explore the role of business as opposed to tracking the results of the business. How are your people skills?  How good is your ability to influence others? How are successful are your negotiation skills?   How well can you communicate?  Are you a collaborator or a partner?  This section will help accountants understand that it is people skills that drive the overall success of the accounting operations. Finally, how are your Leadership skills?  Do you inspire staff or make them angry?  Do you know why your staff work for your company and you?  Do you understand what employees want from their position?  Do you know how to deal with a difficult staff person?  Can you lead difficult change?  This session will help you recognize what leadership truly is as opposed to what passes for day to day management.

Welcome to a course that makes the process of M&A easy to understand and easy to implement within your organization or your clients' organization. The course will provide an intensive overview of the M&A process. Focus will be on practical techniques to guide you through the M&A jungle and avoid the traps that have befallen many organizations.

Every business will be sold eventually. When you have built a great business and decide to move on – you want the most you can get for that terrific organization! What are the steps to take to maximize the value realized? What do buyers really want? What are the three levers to achieve maximum value? If you want top dollar, preparing to sell takes years of planning. This seminar helps CEOs, entrepreneurs, CFOs, Board members, controllers, and their advisors prepare for a successful sale of the organization to maximize shareholder value. We will outline the process to get the most bang for the buck. Proper exit planning demands planning and time.

What exactly is cryptocurrency and its cousin named blockchain? Are they here to stay? This session will provide a big picture examination of the technologies and currencies by explaining how we got here. We discuss the systems and technical aspects of cryptocurrencies and blockchain. What is the broad view of the technologies that currently do, and will continue to, impact our workplace and lives?

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.

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.

Good managers know how to delegate, but it can be a challenge to manage employees who are more interested in passing the buck than being responsible. Lack of ownership and responsibility can bog down processes and shut down projects. This workshop will help you create a game plan for building a culture of accountability with your team.

We kick off this course with a look at the GASB standards that are effective this year including GASB 100, Accounting Changes and Error Corrections and GASB 101, Compensated Absences. We will then switch to the audit side of the house to examine the impact of the 2024 Compliance Supplement on Single Audits and the changes to the Uniform Guidance. We close with a look at common deficiencies found in Single Audits. 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 provides a high-level overview of the most important accounting, financial reporting, compliance and audit issues facing nonprofit entities and their accountants. The focus is on explaining the basis behind major issues and trends in executive summary (yet practical) form, enabling professionals to understand the most important aspects of relevant standards, and the basis for any potential changes on the horizon. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Don't look now, but ChatGPT is taking the business world, including the accounting profession, by storm. Every CPA, whether in public accounting or working in corporate, should have a fundamental understanding of ChatGPT and generative AI applications more broadly. This course will provide you with a foundation of knowledge about ChatGPT technology that will prepare you to have conversations with clients, customers, colleagues and service providers. More importantly, you will learn how to leverage ChatGPT to increase your personal productivity. If you feel your ChatGPT knowledge is lacking, that will not be the case after you attend this course, taught by John Higgins, one of the leading technology strategists and thought leaders for the accounting profession. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

What would you do if you only had one workday to complete a financial statement audit? How would you optimize just a handful of hours? What would you test? More importantly, what would you minimize or eliminate? Although one day is unrealistically short, it illustrates how risk-based auditing can help auditors optimize professional effort. This course emphasizes the importance of risk assessment for enhancing both the effectiveness and efficiency of audit procedures.

Employees, now more than ever, are experiencing stress, anxiety and other mental health challenges and all of those come with them each day to the workplace. In order to ensure the safety and security of their workplace, employers need to address these issues and support their employees. Join us to discuss the challenges to providing mental health support to employees, the potential risks of deprioritizing mental health, and tangible actions employers can take to support the mental health of their work group. The cost of providing mental health resources and support pales in comparison to the cost of NOT providing it. Make a plan. Be ProActive.

This course explores the best practices for hiring remotely while leveraging personality assessments to make more informed decisions. Learn how to effectively integrate personality testing into your recruitment process to identify candidates who are the right fit for your team, even from a distance.

This course concisely explains the latest "see, hear, speak" multi-modal updates to ChatGPT and how they can be used in an accounting context. New features include vision processing, voice conversation, image generation, real-time Internet access, advanced data analysis, plugins and more. Discover how this technology can be used in mind-blowing ways to analyze financial data, optimize processes, and solve problems in the accounting domain. Through the lens of ChatGPT, practitioners can explore innovative solutions, automate routine tasks, and generate deeper insights and value to their clients and organizations in previously unimaginable workflows. You'll walk away with scores of advanced ChatGPT strategies and tips that can be immediately applied and deliver instant results to elevate the efficiency and effectiveness of your accounting projects and tasks. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Some estimates indicate that business professionals spend almost half their time in Excel applying formats. If you want better formatting results in less time, participate in this session to learn the best practices for formatting your Excel spreadsheets. In this session, you will learn best practices for applying formats in your workbooks. More specifically, you will learn about features such as Custom Format Codes, Templates, Styles, the Accounting Format, Precision as Displayed, date formats, and many others, all of which can save you substantial time when working in Excel.

Do you ever import data into Excel, and then spend a bunch of time manually preparing it for use? Perhaps you delete extra columns or rows. Maybe you need to split a single column into multiple columns, or, combine multiple columns into a single column. The good news is that many of these transformations can be fully automated with Excel! The Get & Transform tools built-in to Excel 2016 for Windows, formerly available as the Power Query add-in, are incredibly powerful. At a high level, they enable us to retrieve data from a variety of sources and prepare it for use as needed. In this session, we'll use Get & Transform queries to help with several common tasks, including flattening data, splitting and combining columns, formatting data, unpivoting summarized data, and combining several csv exports. If you frequently export/import data from one system to another, you will want to understand how to use a Get & Transform query to streamline your work.

“How will I EVER get this all done?"  It’s a question I often hear from clients and on a particularly stressful day, I can hear myself saying these words!  Instead of helping us focus, it's a question that leads to stress, anxiety and overwhelm! Regardless of where we are in business and in life, we will run into challenges and problems as we navigate business growth, leadership, work life balance and our quest for success and happiness. This workshop will explore the 7 HIGH QUALITY questions that lead to relief, enthusiasm and success.  It will be an interactive exploration that will leave you with a game plan to use right away, as well as an opportunity to practice the mindset that the most successful and happiest people use daily.    This program is for both the entrepreneur who wants to be more effective in their day as well as team leaders who want to stand out in their organization.  For the business owner or staff member you can expect a new way to work with your day so that it's profitable, productive and happier.  For leaders, you will learn new up- leveled skills to increase your efficiency, communication and productivity.  You and your team will shine.  Your staff will feel appreciated and connected to their value as well as the company's goals. Albert Einstein said 'we can't solve our problems with the same thinking we used when we created them'.  The quality of your question will impact the quality of your solution.  Learn the 7 questions that take you from confused and frustrated to creative and focused. 

This course will look at the various rules related to Independence and compare and contrast the requirements. This overview course will help auditors understand the nuances of independence and ensure they meet the requirements to perform attest services for their clients. We will review the requirements for the AICPA, GAO, DOL, and PCAOB.

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.