CPE & Event Calendar

Over the years, Excel has added MANY new features and functionality, yet most people still use it the same way they first learned it. Many of the features were added to Excel to enhance your ability to create spreadsheets more efficiently and with more accuracy. However, if you aren't aware of these new features, how can you use them? This class will focus on walking through each ribbon (menu) to explain the capability of various features in Excel. It is a great overview for both new and advanced Excel users to make sure you know all the capabilities of Excel. You may have seen many of the features but had no idea what they could do for you. This class will help you to understand these features and determine how you might take advantage of their capabilities. This session is presented using Excel 2019/Office 365. Regardless of the version you are using, most concepts covered in this course apply to all versions of Excel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Conflict is inevitable whenever you have more than one person working together. But conflict doesn't have to be a bad thing. In fact, it's through conflict that some of the most productive conversations, changes, and innovations can occur in organizations...when they're navigated through effective communication. This workshop is designed to help you more strategically approach difficult conversations in the workplace and will arm you with both an understanding of how our minds approach these tough conversations and tools that you can use to approach these conversations more impactfully.

Common Audit and Financial Reporting Deficiencies in State and Local Governments, is a 2 hour webcast detailing many of the more common mistakes that auditors and accountants are making in either the preparation of their annual financial statements or the audits of such financial statements. Deficiencies in audit standards (AICPA, GAO, Single Audit) and preparation standards (GASB) noted in this webcast are driven by the most recent results found in audit organization peer reviews, workpaper or desk reviews, and various organizations checklists for oversight. 

In today's data-driven world, Microsoft Excel has become an essential tool for professionals in any organization. To harness the full potential of Excel, it is crucial to understand and master its lookup functions. This course is designed to equip participants with the knowledge and skills needed to effectively utilize Excel's lookup functions and enhance their data analysis capabilities. Throughout this comprehensive course, participants will dive deep into the world of lookup functions and gain experience through practical exercises and real-world scenarios. Whether you're a seasoned Excel user looking to fine-tune your skills or a beginner eager to unlock Excel's full potential, this course is tailored to meet your learning needs. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This program addresses the Section 199A deduction for flow-through entity income, including a review of the major provisions, forms reporting, and recent developments. 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.  

This course provides a concise overview of the Dark Web, a part of the internet that isn't indexed by search engines, and is often associated with anonymous transactions and nefarious activities. Discover the leading threats and risks that the Dark Web poses to accounting firms. Explore how practitioners can effectively mitigate the risk of data breaches, ransomware attacks, financial fraud and other risks connected to the Dark Web. You'll walk away with a foundational understanding of leading cybersecurity strategies that can help you maintain client trust and protect your firm's sensitive data in this complex and ever-changing threat landscape. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This program addresses the critical issues and special opportunities facing S-corporations, with a focus on reporting shareholder basis and distributions. **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.

The insurance industry has unique accounting and regulatory requirements. This course provides an introduction to those unique requirements, including the multiple layers of regulation, statutory vs. GAAP accounting, non-admitted assets, special treatment of taxes, and more! This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The budgeting process can be a time consuming and frustrating process for accountants.  The constraints and pressures can lead to poor decisions in both the technical and human components.  This session will cover: Building Flexible Budgeting Models: Walking Through and Crunching The Numbers •    We can all learn from others and improve our budgeting process by listening to our colleagues’ wisdom and experience.  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 planning. 

Communication is the glue that connects people, but it doesn’t come easy for many of us. If you want to quickly and effectively handle problems with co-workers or clients, and you want people to do what you want without a lot of hassle, this seminar is for you. The bottom line will be better client and co-worker relationships, leading to increased enjoyment and productivity at work.

With new accounting standards, the economic landscape and evolving technology, accounting, financial reporting and finance continue to grow in complexity. FASB has tried to address the growing complexity, by working towards making GAAP less convoluted.  The struggle to stay on top of accounting financial reporting requirements and finance changes due to the economy continues for several reasons. Lack of in-house SMEs, managing high volumes of transactions, and data and evolving information technology systems. In the future, executives must consider the challenges they will face in future years that will bring their own nuances and complexities. Budgeting is certainly one of those processes that must be evaluated and re-evaluated for efficiency. This session delves into the corporate budgeting process and discusses methods used and which methods may or may not allow for the organization’s to properly plan for a volatile future.

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.   

Almost 50% of businesses that started five years ago are no longer in operation today. Controllers and CFOs can and must influence the longevity of their organization to improve their success rate.  Jim will help you be aware and understand the answers to these issues: Can you describe the financial health of your company? Can you also explain what the financial health of your industry is? Do you know your Business Cycle compared to the industry business cycle? Do you have an executable plan? Do you know what the competitive, legal and technological landscape is currently, and for the future? Is your organization aligned and incentivize to be successful? Jim has developed his groundbreaking Business Longevity concept as a keynote and a workshop, and would be happy to speak to your organization on this topic. This session will focus on assessment (financial health, competitive environment), determination (effective business planning, including the future landscape), and execution (gettin’ it done!)

The mad scramble to remote work and utilize apps like Teams has been trying for most organizations over the past couple of years. With a rush to install and no time to plan, most team members did their best, prioritizing remote meetings as the primary concern. Therefore, as a result, Teams is vastly misunderstood and underutilized in most organizations. Join us in this session to go beyond the remote meetings aspect of Teams and to learn how to optimize efficiency, communication, and workflow with Teams.

This session explores the importance of internal controls with an emphasis on best practices for small- and medium-sized entities.  We will examine the roles of both preventive and detective controls and practical, cost-effective suggestions for implementing effective internal controls will be addressed.

You are likely familiar with and/or have experience with IRS summonses. BUT - Did you know there's a lot of procedure and decorum that goes into issuing a summons that you can leverage to help your client? This program will focus on the basics of an administrative summons, what the IRS can summons for, how you should comply with a summons, summons referral criteria, and common errors and misnomers the IRS can make in generating/serving a summons. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This program will examine the key provisions of the Inflation Reduction Act of 2022 that was enacted to not only curb inflation, but reduce the deficit, promote clean energy solutions, and much more.  Learn how this new legislation can provide tax savings for both your individual and business 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.

Have you ever considered a tax audit from the perspective of an IRS examiner? This session explains how you can use IRS Audit Technique Guides (ATGs) to enhance tax compliance. You will obtain a glimpse of the audit process from the viewpoint of an IRS agent as we explore insights that the IRS provides to its own examiners. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Since its inception nearly 30 years ago, many have continued to struggle with applying the current model for accounting for income taxes, ASC 740. But this does not have to be you. This course will provide you with the basic knowledge necessary to understand the complexities of this challenging topic. Through discussions and use of exercises, this course will analyze the authoritative literature to provide a thorough understanding of such topics as deferred taxes, income tax expense, uncertain tax positions and other classification and disclosure requirements related to income taxes. We will also explore some specialized areas of income tax accounting, such as intra-period allocations of income tax expense and accounting for changes in tax laws and rates, and we will review proposed updates to ASC 740 disclosures on which the FASB is contemplating. In summary, this course is the place to be to enhance your accounting for income taxes IQ.