CPE Catalog & Events

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.

The Inflation Reduction Act increased the IRS budget. As a result, the IRS continues to replenish its audit workforce. The IRS trains its audit workforce by examining the tax returns of individuals and small businesses. Now, more than ever, Accounting, Tax and Financial Professionals need clients to understand the need for documentation and procedures to substantiate what IRS examiners are pursuing. Learn the high audit risk areas and ways to help clients survive an IRS audit with little or no change. It is critical for Accounting, Tax, and Financial Professionals in public accounting to understand the risk to clients and to themselves in tax return preparation and planning since the IRS continues to increase its audit coverage and is examining more taxpayers than it has in the recent past.

This course goes beyond the basics and addresses important practical issues that an experienced practitioner must know about S corporations.

The AICPA has identified risk assessment as an area of focus for its Enhancing Audit Quality Initiative as deficiencies in auditor's risk assessment procedures continue to be a common issue identified in peer review. SAS No. 145, Understanding the Entity and Its Environment and Assessing the Risks of Material Misstatement, was written to improve the quality of risk-based audits. While key concepts do not fundamentally change, the standard works to clarify and enhance certain aspects of the identification and assessment of the risks of material misstatement to drive better risk assessments and hopefully overall enhance audit quality. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

For roughly 90% of American retirees, Social Security income will be the foundation of their retirement income. Yet, many are ill-prepared and lack understanding of the critical aspects of making an informed claiming decision. Further challenged to separate fact from fiction, consumers crave accurate information from knowledgeable professionals to make the most out of these coveted monthly benefits. This course dispels common myths about Social Security that lead to confusion and replaces them with the truth to an empowered retirement. Help your clients navigate their claiming age decisions with greater confidence, equipped with the essential truths they should consider before pushing the Social Security "on" button.

Retaining Talent in a Competitive Marketplace -Creating a Benefits Program Employees Care About In today's competitive marketplace, retaining talented employees is becoming increasingly difficult. A solid benefits program can make a difference in the fight for talent - but only if those benefits matter to the employees you are trying to hire! Through statistics and case studies, this course will explore what benefits are most valuable to employees. We will also explore the basic types of retirement and health insurance plans and discuss what financial leaders should consider before adopting a benefits package. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.