CPE + Events Catalog

Business intelligence efforts continue to grow, and Microsoft’s Power BI platform is central to many of these efforts. Participate in this session to learn more about business intelligence and how to create dashboards using Power BI.

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. **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.  

Gain a fundamental understanding of the Mergers and Acquisitions (M&A) process from a buyer's and a seller's perspective.

S corporation taxation has a lot of pieces. There are helpful elections you can make that can potentially save your client money, but there are also rigid rules to adhere to. For example, if there is more than one class of stock, it can terminate the S corporation election. Learning how to successfully navigate these rules can make all the difference. In this course, we will discuss some of the more common specialty areas experienced by practitioners - late filing relief for S corporation elections, disproportionate distributions, and selling S corporation shares. While these items may not come up on every single Form 1120-S, you will be able to add more value to clients when they do.

The course provides general information on proceedings that led to a grand jury indictment of television reality stars, Todd and Julie Chrisley. Participants learn how business decisions can lead to federal charges for conspiracy, bank fraud, wire fraud, and tax evasion. The grand jury also indicted the Chrisley's accountant, Peter Tarantino, on tax-related offenses. Participants learn how to develop resources and tools for effective detection and deterrence of federal crimes, and the learn the consequences that follow white-collar crime, including how responses can influence lengthy prison terms. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

You have used Excel for years and perhaps Lotus 123 before that. And through all that time, you have repeatedly said, “One day, I’ll learn how to write macros.” Finally, that time has arrived because this four-hour program will introduce you to the wide world of Excel macros and Visual Basic for Applications (VBA). This course teaches the fundamentals of creating and working with macros in Excel and is designed specifically for those with little experience working with macros. More specifically, taking this course will teach you how to use Excel’s Macro Recorder to write simple yet effective macros. You will also learn how to secure and share macros with other Excel users and create user-defined functions to solve specific accountant-centric problems in Excel. Further, you will learn how to create macros that run when a user opens a workbook and VBA basics. Don’t miss this unique opportunity to learn how to begin working with macros – one of Excel’s most powerful tools.

If you or your clients are facing that stage of life where careers are passing into the background, and a new "to be determined" life is emerging, then you are entering what is called "retirement". Some people are excited, some are scared, and most are both. There are many issues and questions people face at this time - what to do with time, financial, relationships, health, identity and more. This program summarizes the key research studies, provides stories from those who have made this work, and offers thoughtful, practical exercises from my award winning book NEXT STAGE. It will help you (or your clients) address key issues and develop a Master Plan for the transition. If not now, when? This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

While once thought just to apply to banking and financial institutions, entities now need to apply fair value accounting under ASC 820 across a variety of transitions. From financial instruments to leases, business combination accounting and impairment measurement, GAAP either requires or allows the use of fair value measures in an ever-increasing number of circumstances. Now is the time for you to get up-to-speed on the basics of the fair value approach. In this course, we will review when fair value accounting is required and when an entity can select to use it. Then we will review the basics of the ASC 820 model, including the concept of "exit price," the various approaches which an entity may follow when using a fair value approach and the different levels of inputs which an entity may consider when determining fair value. Lastly, the course will provide examples on when and how to apply this complex accounting guidance.

When an email goes awry, its tone is often the culprit. When we write short, direct emails, our readers might think we are angry, yet when we write long, flowery messages, people don't read them. We need to find the right tone for every email: professional, friendly, and respectful. If you have received feedback that your emails could be more relaxed, or if readers routinely ignore your emails, sign up for this presentation. This webinar will give you practical tips to manage your email tone so that your readers stay open to your message and you continue to develop positive business relationships.

With over 4.3 employees leaving their jobs as of early 2022, The Great Resignation presents a huge challenge for companies as they attract and retain talent. During this course, you'll learn practical strategies you can implement immediately to ensure you have the right tools in your toolbox to win the war on talent. 

Understanding the complexities of estate and gift taxation can be challenging for many financial professionals, especially those who lack direct experience in this area. In this comprehensive course, participants will gain a solid foundation in Federal estate and gift tax law, providing them with the necessary tools to confidently handle tax compliance issues related to Forms 706 and 709. By exploring the details of the Internal Revenue Code sections pertinent to estate and gift taxation, attendees will gain a thorough understanding of key concepts, including deductions, valuations, and tax credits. This practical knowledge will not only enhance their expertise but also empower them to provide effective tax planning strategies for their clients. Throughout the course, participants will investigate essential topics such as the valuation of assets, deductions for funeral and administrative expenses, charitable and marital deductions, and the calculation of tax credits. By mastering these critical areas, financial professionals will be better equipped to navigate the challenges of estate and gift taxation, ultimately enabling them to provide comprehensive and effective tax planning services for their clients. Whether you're looking to expand your expertise or deepen your understanding of tax compliance issues, this course offers invaluable insights and practical knowledge that can immediately be applied in your practice. **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 session explores the nature of analytical procedures, with significant emphasis placed upon professional standards involving the use of analytical procedures in audit and review engagements. Practical examples to illustrate the application process will also be given. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Starting and owning a small business has often been referred to as the "Third Pillar of Wealth," right behind investments and owning real estate. Essentially, all businesses start off as "small businesses." Small businesses, however, require a large amount of preparation in order to successfully launch and grow. Starting a business requires the owners and managers to address a host of issues, including an understanding of applicable laws, appropriate financing, staffing requirements, marketing, liability protection, and many more. This course provides a broad overview of the critical issues business owners, as well as their professional advisors, must consider when starting and growing a small business. There is extensive research regarding best practices in this area, and this webinar is intended to distill down such information and focus on what is critical to get a small business up and running as seamlessly as possible.

This program will explain the new rules for deducting travel, meals and entertainment expenses and the TCJA disallowance of business entertainment expenses.  Documentation requirements and planning opportunities related to travel, entertainment, and automobile expenses will also be addressed.  **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 highlights significant updates that affect financial reporting and related attestation services. We will explore novel FASB pronouncements while examining the enduring impact of lease accounting and revenue recognition standards. This course will provide reminders regarding both GAAP and non-GAAP financial reporting alternatives for closely held entities. We will also explore selected guidance regarding audit, review, and compilation engagements.

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.

This course provides an in-depth exploration of Form 1120S, the tax return form used by S corporations. Students will learn the intricacies of preparing and analyzing this form, including how to determine the taxable income of the S corporation, how to properly report and allocate income, deductions, and credits, and how to calculate the shareholder's basis in the S corporation. **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.

Loans, rental agreements, business combinations – what do these all have in common? They all have the potential of creating a related party transaction.  This program presents a detailed analysis of the financial accounting rules for transactions with related parties, as well as compares and contrasts those rules with the AICPA financial reporting framework for small and medium-sized entities. **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.

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.

How you onboard a new employee is critical in ensuring they understand your company culture and are immersed properly in your organization. On the flipside, in the event you are dealing with an employee termination, this too is critical in handling with care and sensitivity.