CPE Catalog & Events

If you use Outlook on a daily basis to process your email, chances are pretty good that you are missing out on a lot of opportunities to improve your efficiency in composing, processing and organizing your messages. There are many different features in Outlook that often get overlooked, even though we are working in the app all day, every day. John Higgins, a strategic advisor to the profession on Microsoft 365 deployment, will review numerous tips and features to improve your productivity in Outlook. You will learn many time-saving, practical ways to improve the quality of your email message. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The business structure a client chooses influences virtually every tax and financial issue associated with the business, including the business's day-to-day operations, its tax liability, how much of the owners' personal assets are at risk, and much more. For this and many other reasons, it is critical that a client choose a business structure that gives the right balance of legal protections and tax benefits. From a tax perspective, in terms of selecting an entity to do business in, the universe shifted with the Tax Cuts and Jobs Act enacted at the end of 2017. The tax rate for C corporations was lowered to 21% and the 199A deduction offered pass-through entities the chance to significantly lower the rate at which they are taxed. But how do all these options work and which option is best for which business? Those questions are at the heart of this webinar. In this program, we discuss whether there is a "best entity" for our clients. Tax practitioners know that re-examining choice of entity determination is at the top of the agenda for client meetings because clients continue to want reassurance that they have the most tax-efficient entity structure. This program will equip you with the knowledge and insights you need to lead those discussions.

Do you love PivotTables? Of course, we all do! Traditional PivotTables are incredible, but they do have limitations. If you have ever encountered one of these limitations, you'll be excited to learn that by using the Data Model as the source for PivotTables, you'll be able to bypass many of the restrictions that exist with traditional PivotTables. The data model (also referred to as Power Pivot) is included in Excel 2016+ for Windows and available as a free download for previous versions (excluding Excel for Mac). Using the data model enables you to build PivotTables that were previously not practical. If you frequently build PivotTables and would like to do more with them, you'll want to understand how to use the data model (Power Pivot) to enhance your reports. Note about Excel versions: Power Pivot is not available in all versions of Excel, including Excel for Mac. If you would like to see if Power Pivot is available in your version of Excel, visit the Microsoft site.

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.  

Most financial leaders would agree that budgeting is easy when business and the economy are stable. When revenues and expenses are expected to remain the same, the process becomes merely an exercise in carrying over what was done before to the current year. However, what happens when we are not sure about how the market will react to our product? What happens when the competitive landscape changes? In this course, we will discuss budgeting techniques and considerations when business lacks stability. Through a combination of theory and real-world examples, we will explore how to build flexibility into our budget - so that it can inform and drive decision-making when we don't quite know what is ahead. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

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 case-driven training is designed to get the inexperienced accountant up to speed quickly in the most common areas of S-corporation taxation. The cornerstone of this course is the preparation of the Form 1120S using a fairly complex trial balance common to most S corporation income tax returns. **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

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

This course will provide a detailed analysis of how to determine a partner's tax basis for a partnership interest, with an explanation of the use of both "inside" and "outside" basis determination. An illustrated example with filled in forms will demonstrate how the process works and the 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.

Are you running around with a fire extinguisher permanently strapped to your back? Do everyday crises run your life, both at work and at home? Do you find yourself consistently taking care of everyone else with no time left to take care of you? In this session, we dive into controlling your chaos and managing your energy. Make no mistake, this isn't your father's time management class. It’s an energy management class developed on behalf of and with tired, frustrated, and burned out HR professionals like yourselves! If you find yourself drained and drinking far too much coffee, this is the session for you!

This course is a continuation of discussion over Step One in the revenue recognition process of Identify the Contract. Specifically, this session delves further into the considerations surrounding contract modifications, change orders, unpriced change orders, cancelations, non-finalized changes and accounting treatment when a contract does not exist.

This program explores the role of client internal controls for balancing efficiency and effectiveness in a risk-based audit. We offer practical insights regarding an auditor's assessment of the risk of material misstatement when auditing financial statements of non-issuers, with particular emphasis on internal controls of small-to-medium clients.

Join us for an insightful presentation featuring John Higgins, a renowned technology advisor to the CPA profession, who has assisted many firms with Microsoft 365 deployment. Discover how to leverage the Microsoft 365 suite of applications to unlock new efficiencies and opportunities within your business organization or CPA firm. Don't miss this chance to supercharge your operations with cutting-edge tools! Whether you are working in public practice or business and industry, this event will provide you with a return on investment many times greater than your investment to attend. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Not-for-profit organizations are one of the fastest-growing sectors of our economy, making it increasingly important that auditors, attorneys, CFOs and other advisers understand the unique accounting principles and challenges that apply. Examine the core principles and practices of not-for-profit accounting; review the general characteristics and operational environment of not-for-profit organizations; and discuss how to apply generally accepted standards and principles. Also, learn risk management best practices and common accounting errors.

With the increasing complexity and ever-changing nature of tax laws and issues, today?s accountant needs a partnership/LLC course focusing on the birth, growth, maturity, and death of a closely held partnership/LLC. This case driven course will deal with partnership/LLC income tax laws from formation to liquidation. This class will review the partnership tax law by looking at case studies addressing issues and problems at both the partnership and partner level. Each attendee will receive the most comprehensive reference manual with numerous practice aids and real-world examples and case studies.

Elevate your data reporting skills to new heights with our cutting-edge course, "Create Paginated Reports with Power BI Report Builder." This two-hour, expertly crafted training is designed to transform the way you visualize and present data, leveraging the powerful capabilities of Microsoft Power BI Report Builder. Ideal for professionals who aspire to turn complex data into compelling, print-ready reports, this course is a game-changer in the realm of data visualization and business intelligence. Delve into the world of paginated reporting with a curriculum that balances theoretical knowledge with practical examples and demonstrations. You'll learn how to navigate the Power BI Report Builder interface with ease, design intricate report layouts, and connect to diverse data sources for comprehensive reporting. The course covers a spectrum of skills, from creating eye-catching visualizations to utilizing advanced features like sub-reports and drill-through capabilities. By the end of this session, you'll be adept at publishing and sharing professional-grade, paginated reports that can inform and persuade your audience. Enroll now and take the first step towards mastering the art of paginated reporting with Power BI Report Builder. 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 introduces a structured approach to government budgeting using the four W’s: Who, What, When, and Which. Participants will explore WHO should be involved in the budgeting process, including internal teams and external stakeholders, while learning effective communication strategies to foster collaboration. The session examines WHAT the budgeting process entails, covering essential phases, components, legal requirements, and common challenges. Attendees will also learn WHEN to engage the public through strategic planning, workshops, and outreach initiatives. Finally, the session highlights WHICH departments play key roles, from financial planning to managing capital projects. By the end of this session, participants will have a comprehensive understanding of government budgeting and how to align financial planning with community priorities.

Many for-profit entities receive government assistance or are required to have financial statement or compliance audits due to law or regulation. This course will discuss the requirements under Generally Accepted Auditing Standards relevant to for-profit entity audits.

The repercussions from a natural disaster can be devastating. Properly accounting and reporting for the impact of those disasters can be confusing. This course will focus on some of the most FAQ related to the proper treatment of accounting for disasters in GAAP basis financial statements. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

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.