CPE Catalog & Events

This course provides an update of the recent changes that have occurred in the financial reporting frameworks commonly used by small and medium-sized entities (SMEs). Troublesome areas in these financial reporting frameworks as identified in peer reviews and litigation will be highlighted. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Are you aware there are 470+ formula functions in Excel? Do you realize that they add new functions in every major version of Excel? Did you know that Microsoft adds new functions throughout the year in the Office 365 version of Excel? Are you stuck using old or simple functions like SUM or ROUND? Do you want to expand your knowledge of the extensive function library in Excel? If these questions peak your interest in becoming an Excel function expert, this course is right up your alley. This past-paced course digs into some of the most powerful functions in Excel. Although we cannot cover 470 functions, we will look at over 20 functions that will allow you to create advanced calculations in your spreadsheets. Some examples are: VLOOKUP, IF, IFS, FORECAST, RAND, SWITCH, TEXTJOIN, UNIQUE, SUBTOTAL, IS, TEXT and more! We will also provide example files that will include all the functions used during the class. It's time to take your Excel spreadsheets to the next level. This session is presented using Excel 2019/Office 365. 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.

Professional Codes of Conduct make Ethics seem easy and clear cut. However, this is not so in real life. This session discusses five cases where the ethics is not so clear cut.  What should be considered?  We will explain how you can be more diligent and maintain awareness of ethical issues to become more effective and enhance the reputation of the profession.    

When you're working with clients, it's not always smooth sailing (though we wish it was). Often we need to have difficult conversations. Whether it's to overcome objections, negotiate a new contract, or manage a conflict, these conversations can be navigated successfully with the right tools. This workshop gives you those tools and an understanding how how the human mind works when it comes to processing communication in difficult situations.

Sustainability Accounting is now a recognized professional skill of increasing importance in larger organizations. It is the process of finding, measuring and managing the material metrics for sustainable performance and risk management. The goal is to bring these metrics into regular financial statements so leaders can act on them.  This course teaches Sustainability Accounting basics with example from the restaurant industry.   It is suitable for any professional or student who wants to learn fast about sustainability issues in specific industry sectors and how to integrate sustainability metrics into financial accounting and reporting.

If sales increase, so should profits.  Yet, the opposite result often leaves executives scratching their heads.  When organizations work with inferior cost information, they make mistakes in four specific situations.  Bad information causes sellers to overprice easy, high-volume work and underprice difficult, low-volume work.  This session discusses how to use activity-based costing data to build accurate costing models that consider far more than just the labor and materials necessary to provide goods and services.  

Companies often offer stock options as an additional form of compensation to attract and retain the best talent. Used appropriately, stock options can generate significant wealth. Yet many employees are unfamiliar with how stock options work and why options serve as a valuable opportunity for employees to establish and grow their wealth. Unfortunately, employees who receive stock options are often unaware of their inherent risks. Research has shown that over 75% of employees have never exercised their stock options. Almost half of these individuals (48%), say they held off on selling their options due to fear of making a mistake. This course provides accounting and financial professionals with a broad overview of employee stock options. The webinar is designed to help participants better understand the fundamentals behind these investments and in turn, better advise their clients.

Today's workforce looks a lot different than it used to. With more people working from home and across state lines, employers must examine withholding and unemployment laws in a new light. In this course, we will examine tried and true rules in this area, but also examine statutes that are still developing. Using real-life examples and discussion, we will examine state laws on reciprocity and residency requirements. We will also look at what to do when state laws are silent or conflict on a particular issue, so that you can keep your clients in compliance and be well-prepared for the questions that will come your way in these ever-changing times.

You only have one chance to make a good first impression.  In the fast paced world we live in, being able to create immediate rapport and a sense of trust with people is more important than ever.  Fortunately, this is an easily learnable skill that can serve you in both business and in life.  People who can master the one minute relationship end up making more money, being better liked, and enjoying their clients more.  

Running or advising a small business? KPI Bootcamp can help you quickly find and deploy the right KPIs to achieve your, or your client's, goals. Delivered by Bernie Smith, KPI specialist and overloaded small business owner, this course will help you quickly select a handful of powerful measures that apply to your business. The step-by-step approach helps you sharpen your objectives and select the right KPIs to drive growth and profit. Every one of the 412 included KPIs (as free PDF download for every participant) includes a full plain-English definition and also covers business benefits, case-study examples and practical tips.

This comprehensive training is designed to get the accountant up to speed quickly with partnership and limited liability company (LLC) formation and preparation issues as well as a complete understanding of calculating a partner and LLC member’s basis. The cornerstone of this course is the in-depth line-by-line analysis of the Form 1065 Schedule K and K-1 and how these items affect the partner/member’s 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

If you thought applying one set of audit standards is tough enough, how about applying three different sets of audit standards in one “single” audit?  That’s exactly what happens when the auditor applies GAAS, the Yellow Book and the OMB requirements in a Single Audit.  This session will start with a single audit “nuts and bolts” overview before delving into unique aspects and audit issues of the era of pandemic-related funding, and of course the new funding related to the Infrastructure and Investment in Jobs Act, or IIJA.  Join our expert panel of federal, state and local auditors and practitioners, along with a representative of a large Federal Agency to learn what you need to know if you are performing audits under these audit standards and the Uniform Guidance for Federal Awards.   **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.

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.

This discussion outlines situations where ‘legal’ and ‘ethical’ are not necessarily in alignment.  How should you handle these issues?  We will detail a better thought process to help you avoid ‘crossing the line.’   

Following the ever-changing tax deprecation rules is not a game for the faint hearted!  This course analyzes the current landscape of depreciating, capitalizing and disposing of business assets, with examples and illustrated case studies to enhance the CPAs understanding of the most current tax depreciation provisions.  **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.

We see change every day, but we ignore it as a key risk. Even though change is natural, it is also natural for humans to fight it. Why do humans think we can control everything? What are the steps we can take to adapt to change? Learn more about how we can become better at recognizing change and how we can embrace and adapt to the many changes we see every day. Change is inevitable. We can adapt to it or be replaced. We will discuss practical insights that will help you be even more successful in the office and in life. Effective leaders should not miss this course. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Electing S corporations may find it desirable or necessary to terminate this election and convert to a C corporation. Alternatively, qualifying C corporations may determine the S status as the preferred tax status. With significant current and future tax considerations, terminating or electing S corporation status can be desirable. We'll consider situations when such conversions are desirable-identifying and discussing tax planning opportunities and complications at conversion.

As practitioners, we must devote lots of time to the technical understanding of the tax law. We may be puzzled about why they have so many details and why some special rules are so limited. Appreciation of the design of a tax system (also known as tax policy) can help deepen our understanding of technical rules and where improvements are needed in our tax system. Understanding the principles of sound tax policy is necessary to objectively evaluate legislative proposals and critique them to clients and lawmakers. This course covers the basics of tax policy, principles of good tax policy, how to use this information for improved practice, and advocacy ideas to help improve our tax laws. Examples and practice analysis are included.

Unlock the full potential of your data with our specialized course, "Create Measures in Power BI that Define Your Metrics". Designed for professionals who aspire to excel in the dynamic world of data analysis, this 4-hour intensive training delves deep into the advanced functionalities of Microsoft Power BI. You'll embark on a journey to master the art of Data Analysis Expressions (DAX), a powerful tool in the Power BI suite to create metrics. This course is meticulously crafted to transform you into a proficient user, capable of harnessing complex DAX calculations to bring your data to life. The course content is thoughtfully structured to ensure a comprehensive learning experience. Starting with the foundational elements of DAX, you'll rapidly progress to tackle advanced formulas and time-intelligent functions, essential for nuanced data analysis. The highlight of the course is the emphasis on the DAX calculation process, a crucial aspect for validating measures in Power BI. Additionally, the practical application of PivotTables for measure validation will equip you with the skills to confirm the accuracy and effectiveness of your data measures. These advanced techniques are not just theoretical concepts but are presented through engaging, real-world scenarios, enabling you to apply your learning immediately to your daily tasks. This course is an invaluable step towards mastering Power BI and making data-driven decisions with confidence. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Pass-throughs (S corporations and Partnerships) are the most popular choice of newly formed business entities. However, for years, taxpayers and their preparers have struggled to calculate, update, and maintain the pass-through entity owners' tax basis information in each investment correctly. Calculating and accounting for tax basis and adequately reporting the impact of operating and liquidating distributions for these entities are among the most frequently cited audit deficiencies. Taxpayers have also misapplied the tax rules when calculating the gain or loss from the sale of the interest. Recently, the IRS initiated enforcement initiatives designed to audit owners of pass-through entities regarding their calculations of tax basis and their tax treatment of distributions. This course will teach you how to properly account for both items for your clients who own an interest in a partnership or an S-corporation. Learn to identify the most common mistakes and errors and report these items correctly before your client is audited.