CPE Catalog & Events

Our clients' personal financial planning issues are quickly developing and keep us challenged in a new operating environment! Many new approaches are needed in working through, understanding, diagnosing and then adopting innovative and proven strategies. Additional ways of experiencing these client situations are entering the picture. With information overload, part of the CPA's challenge is to help clients stay focused on goals while managing expectations in a rapidly changing environment. This course will update you on the newest personal financial planning changes related to insurance, investments, education, retirement, estate, cash flow management, divorce, closely held businesses and other relevant topics. We'll discuss critical issues, including planning for education, divorce, charitable, exceptional circumstances, business owners and highly compensated executives. Be sure to register for all of our PFP updates: PFP Update: Income Tax, Retirement, and Estate Planning PFP Update: Issues, Exposures, and Developing Client Strategy PFP Update: Investment Planning in This New Era

This webinar presents a variety of time-saving ideas, shortcuts, and tips that are sure to boost personal productivity. We discuss better summing, address one of the biggest pitfalls that Excel users have faced over the past 25 years, present the most important keyboard shortcuts, demonstrate a better alternative to hiding rows or columns, illustrate how to quickly navigate to other workbooks and files, and demonstrate using Excel with styles.

This program discusses, in a practical way, how an S corporation shareholder calculates their stock and loan basis on Form 7203. Form 7203 is the IRS Form on which a shareholder is sometimes required to calculate their stock and loan basis. This topic is particularly important when an S corporation has a loss and the shareholders wish to know whether they are entitled to fully utilize the loss that has been allocated to them against their other income.

Calculating partnership basis is one of the most important things that we do as practitioners. However, it is also one of the most confusing. When we use the term "basis," we really could be referring to one of three different things. This course will explore the differences between inside basis, outside basis, and 704(b) basis. Through several examples and practice problems, we will show you how to easily distinguish among these terms. We will also explore the tax implications of initial contributions of property to a partnership as well as the different types of partnership distributions.

Conflict is often avoided, or dealt with in a passive manner. When ignored, conflict often escalates and can become polarizing. In this session, participants will gain insights for enhancing their natural responses to conflict, learn healthy communication styles, and build constructive behaviors to manage conflict. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Despite the fact that a client's tax matter may be taken directly to court, utilizing the IRS Independent Office of Appeals usually results in saving your client both time and money. Join us as we discuss the misunderstood process of navigating the complex IRS Appeals.

Clients think that estate planning only applies to the very rich. In truth, there are many issues of critical concern for which the middle-income client needs to plan. This course is a must-attend for all Accounting and Financial Professionals who work with middle-income clients and are looking for ways to provide additional quality services. Updated for developments relative to estate tax changes.

Organizations of all sizes often fail to successfully install needed foundational components of an internal control system. Whether large or small, entities must view policies, procedures, and all controls in a wholistic manner in order to develop a system of controls that will keep the entity on its intended course. Moreover, those that design policies and procedures benefit by knowing why control measures are necessary. This session sets forth internal control concepts and explains the importance of strong internal control policies. It provides an understanding of the interrelated nature of all controls created by any organization. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Organizations must be intentional in cultivating environments where diverse team members can thrive, feel empowered to make recommendations and take chances. Initiatives to help leaders, both men and women, identify unconscious bias will benefit the morale and increase the retention and advancement of diverse leaders. The instructor will use various scenarios and their own lessons learned as a STEM leader as well as a finance leader.

Cash flow management is often the most important task of any CFO or financial leader. Regardless of whether one works in start-ups or established companies, non-profit or for-profit entities, cash flow makes our organizations run. Have you ever wondered whether you are optimizing your company's cash flow? In this course, we will explore how to improve your company's cash flow using analysis and financial theories in the context of real-world situations. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Many public accountants desire to have a quick overview of only the most current changes to professional and ethical requirements. This course will provide an executive summary of the major changes in audit and other attest requirements. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

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.

Stay current with this deep dive into accounting for and auditing nonprofit revenue streams. During this session, we?ll review recent new standards. The case studies will include familiar and complex situations and audit techniques to identify potential misstatements.

This program addresses the most recent developments impacting partnerships operating as LLCs, with a focus on legislative, administrative, and tax form changes. Emphasis will be placed on partners "tax basis" capital accounts, now required for tax form reporting. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Until recently, a percentage of organizations discounted the risk related to external fraud attempts. Most were only concerned with protecting physical assets such as inventory or fixed assets. However, because of the many highly publicized corporate hacking events, such as the ones that affected the Colonial Pipeline and JBS Meats, more attention is being paid to external fraud risk of all types. In this session, we look at what is included in a definition of external fraud and then delve into specific control issues that can give rise to increased risk. We then discuss measures that organizations can employ to help reduce exposure to external attacks. 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 will explore key aspects of getting more satisfaction out of the work you choose to do and how to find greater balance between the demands of work and other lifestyle choices in an ever more complex and changing world. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Sometimes the vernacular of accounting seems more challenging than technical aspects. This session offers suggestions for translating the foreign language of taxation into tangible terms for non-accountants. We explore techniques for simplifying the complexity of taxation terminology. This course will equip you with tools for demystifying tax technicalities so you can help clients and other non-tax professionals grasp fundamental concepts. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Transforming how you use Excel with engaging and expert-led instruction Designed for you to work alongside an expert and complete the same exercises, you'll dig deeper into topics, including: Benefits of using named references for faster navigation Increased versatility and efficiency withing your Excel workbooks Excel Tables special properties and Error reduction for greater productivity. Mastering Excel functions Excel mastery involves understanding how to create functional and efficient workbooks. The instructor will guide you through Tables, named references, and more as you build on basic Excel skills and use critical functions, such as: Excel conventions Critical shortcuts Efficient navigation techniques Automatic formula updating *Session 1 is one of eight sessions that is available as an individual session. Each session builds on the prior sessions, so you'll want to consider watching [Session 2: Data Validation and Conditional Formatting] (https:// https://www.aicpa-cima.com/cpe-learning/webcast/excel-for-accounting-professionals-session-2--data-validation-and-conditional-formatting) to further prepare to tackle real-world issues and build powerful workbooks.*

This intensive two-hour course addresses the critical need for accuracy and efficiency when developing spreadsheets using Microsoft Excel. Recognizing that even minor errors can have significant implications, this course delves deep into strategies and skills required to detect and correct errors in Excel. By the end of this course, participants will have a comprehensive understanding of how to efficiently identify and correct errors in Excel spreadsheets, enhancing their overall productivity and accuracy in their professional roles. 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 is a case study designed to provide a comprehensive overview of U.S. taxation of a foreign corporation. Using a specific example, the course will walk through step-by-step mechanics on how to calculate the income inclusions and foreign tax credits under GILTI (Global Intangible Low-Taxed Income), Subpart F, and PFIC (Passive Foreign Investment Company) regimes. The case study will further evaluate tax impact of subsequent distributions from the foreign corporation and sales of its stock. A compare-and-contrast approach will highlight the different outcomes of these regimes for individuals and for C corporations, empowering participants to advise their clients on the most tax efficient way to structure their international investments.