CPE Catalog & Events

Business leaders often view an internal control system as a security measure. However, a well-designed system can also drive entity objectives. Learn to design a robust and well-supported system, leveraging years of experience and key concepts from authoritative pronouncements and frameworks. Explore strategies to address new business challenges, including evolving markets, rapid changes in business, and increasing governmental and industry-based regulation. This course is for anyone working with internal controls.

A well-designed internal controls system can and will drive all entity objectives. Too many times control creators focus too much on security. It is important to properly balance protection-based measures with those designed to enhance efficiency. This session works to illustrate the power of a strong and well supported control system. It also discusses steps to take in order to establish such a system. This material is becoming more and more beneficial as companies strive to address many new business challenges such as evolving markets, the rapid rate of change in the business world and the notable increase in governmental and industry-based regulation. Those that desire a balanced and workplace enhancing control system should strongly consider this session. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

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.

In this innovative course, participants will learn to combine the power of artificial intelligence with the functionality of Microsoft Excel. You will learn how to leverage ChatGPT, OpenAI's powerful language model, to improve your Excel skills and decrease the time it takes to build spreadsheets. The course will include a quick introduction to ChatGPT but the majority of the time will be spent using ChatGPT to create an Excel spreadsheet. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Globalization continues to make it easier for taxpayers to live abroad, do business in other countries, or invest in foreign enterprises. This creates significant complications and tax planning opportunities when it comes to filing U.S. tax returns. This course provides an overview of the unique tax challenges and solutions presented to U.S. expats or investors living or investing abroad. It examines how foreign-source income is taxed in the U.S. and how the tax consequences could be mitigated by applying the tax treaties, claiming credit for foreign taxes paid, or excluding foreign-earned income. Additionally, the course discusses the numerous foreign informational form reporting requirements and the significant penalties that could be imposed by the IRS. Examples from real-life client scenarios are included.

Recent new auditing standards are designed to improve overall audit quality. The course will address the most common misapplied audit concepts in planning and performing effective and efficient financial statement audits. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The course will start with the Accounting Standard Updates effective in 2024 for public entities, private entities, and nonprofits. We will also review year 2 implications of the leases standard including modification accounting. We will then switch our attention to the items coming down the pike, including a look at the projects identified by the FASB's Invitation to Comment: Agenda Consultation. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Boosting productivity with Excel For those unfamiliar with conditional summing, you're in for a revelation -it's an impactful technique that improves productivity in creating reports. You'll learn how to optimize Excel efficiency by managing duplicates, selecting appropriate shortcuts, and performing lookups. Practical hands-on Excel learning exercises taught by highly engaging expert in the field You'll also deepen your skills and tackle real-world Excel workbooks that address the following: Benefits of using lookup functions over direct cell referencing A comprehensive exploration of the popular VLOOKUP function Techniques for removing duplicates to create a distinct set of report labels *Session 4 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 5: Error Trapping and Improving Lookups] (https://www.aicpa-cima.com/cpe-learning/webcast/excel-for-accounting-professionals-session-5--error-trapping-and-improving-lookups) to further prepare to tackle real-world issues and build powerful workbooks.*

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.

Many professionals, including corporate management, loan officers, investors, suppliers, customers and auditors, use financial statement analysis to perform their daily responsibilities. This program focuses on financial statements and the analysis of financial statements utilizing cases to assess profitability, liquidity, and resource management efficiency. We conclude with discussions of non-GAAP performance measurements, forecasting, and valuation.

This course is a comprehensive overview of critical Federal tax law updates resulting from changes to current laws, regulations and court cases impacting individual taxation. We will also review recent modifications to tax forms, small business tax law and administrative updates, retirement plan changes and tax practice and procedures. We will also explore the impacts of the Consolidated Appropriations Act of 2021 (CAA), the American Rescue Plan of 2021 (ARPA) and other legislative changes.

Business leaders often view an internal control system as a security measure. However, a well-designed system can also drive entity objectives. Learn to design a robust and well-supported system, leveraging years of experience and key concepts from authoritative pronouncements and frameworks. Explore strategies to address new business challenges, including evolving markets, rapid changes in business, and increasing governmental and industry-based regulation. This course is for anyone working with internal controls.

If there is a potential error, the IRS will assess a tax and add a hefty penalty, without even knowing the facts. As a tax professional, you will be exposed to the IRS and their methods of penalizing taxpayers for the smallest of violations. This presentation will focus on the rules and regulations that create the penalty, and the reasons that exist that the IRS will consider to remove those penalties. 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 allows you to get reacquainted with the statement of cash flows. We will refresh your skills regarding both the preparation and utilization of the statement of cash flows. Significant emphasis will be placed on the informational role of the statement of cash flows and insights that can be obtained using the statement of cash flows in concert with the other elements of a company's accrual-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.

This course investigates actual real-world fraud schemes and discusses what controls could have prevented the fraud from occurring, and what controls could detect and curtail the fraud scheme. The instructor speaks from experience, finding multiple frauds very early in her career leading to a career-long focus on fraud prevention and detection. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Power BI - Bringing It All Together for Data Analysis is an advanced-level course designed for professionals looking to integrate and optimize their use of Microsoft Power Pivot and Power BI. Building on the foundational knowledge from previous courses, this session focuses on the crucial next steps after creating data models and measures, guiding participants on how to fully utilize the potential of these tools to uncover insights and create impactful, actionable visualizations. This course takes a deep dive into the critical aspects of using Power BI to its fullest potential, emphasizing a holistic approach to data analytics. You'll learn how to build a streamlined workflow, ensuring every step in your data journey contributes to actionable insights. The course also focuses on optimizing performance for data models, utilizing advanced features of Power BI Services, and moving beyond basic data models to create advanced solutions tailored to real-world business needs. By the end of the course, you'll be able to synthesize all your Power BI skills to design and deliver powerful analytics solutions tailored to any audience. Whether you're presenting to stakeholders, sharing insights across teams, or managing enterprise-level reporting, this course will equip you with the tools and strategies to succeed. Perfect for Power BI users looking to tie all the pieces together into a comprehensive, efficient workflow. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Accounting and finance professionals have used different forms of automation over the years to improve the efficiency and accuracy of their work. So far, technology has not been able to replace the knowledge, experience, and decision-making of seasoned professionals. Times are rapidly changing. Today, systems easily exceed humans in accuracy and consistency. Artificial intelligence (AI) brings opportunities for accountants and finance professionals in the short term to improve efficiency and accuracy, while providing more value for businesses and customers alike. In the long term, AI will offer profound changes to how professionals work and process data. This course is designed to review where we are and where we are headed in the world of AI.

Even though they have been around for several years, the tax laws pertaining to S corporations remain some of the more difficult areas of the Internal Revenue Code. Given the rising popularity of S corporations, understanding how shareholder basis and the equity section of the balance sheet work together for tax purposes is imperative for nearly any tax practitioner. In this course, we will discuss this relationship. Using examples and illustrations, we will show how contributions, operating transactions, and distributions affect shareholder basis as well as equity.

If you work for or with not-for-profit entities and have questions about the IRS Form 990, Return of Organization Exempt From Income Tax, and the related schedules, this is the course for you! The program focuses on common issues that professionals will likely encounter when they prepare the Form 990 and additional tax rules applicable to not-for-profits.

This CPE course explains Yellow Book independence including the general requirements, requirements for auditors providing non-audit services and documentation requirements. This course also explains the basic elements of a Uniform Guidance compliance audit, including an overview of requirements, major program determination with examples, an understanding of compliance requirements and related internal control over compliance, sampling, and single audit reporting. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.