We kick off this course with a look at the GASB standards that are effective this year including GASB 100, Accounting Changes and Error Corrections and GASB 101, Compensated Absences. We then move to the NFP side of the house with a look at the Accounting Standard Updates issued by the FASB that impacts nonprofit entities. Following that, we review the work of the Not-for-Profit Advisory Committee (NAC) and the projects they advise the FASB on. After the break, we will conduct a deeper dive into Yellow Book and Single Audit engagements. The course closes with a look at the significant changes in the 2024 Compliance Supplement, the changes to the Uniform Guidance and the common deficiencies identified by the federal agencies and peer reviewers.

This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The major topics that will be covered in this course include:

• New GASB standards
  • GASB 100, Accounting Changes and Error Corrections
  • GASB 101, Compensated Absences.
• Accounting Standard Updates issued by the FASB
• Not-for-Profit Advisory Committee (NAC) and the projects they advise the FASB on.
• Yellow Book and Single Audit engagements.
• Changes in the 2024 Compliance Supplement
• Changes to the Uniform Guidance
• Common deficiencies identified by the federal agencies and peer reviewers.

Who will benefit:

Practitioners and members in industry responsible for accounting & financial reporting for nonprofit or governmental entities.

This webcast is hosted on CPA Crossing platform. Attendees will receive instructions on how to attend the webcast via e-mail.

Unlock the full potential of your data with our cutting-edge course, "Create Visuals in Power BI to Successfully Analyze Data." Designed to span a focused, four-hour session, this course is your gateway to mastering the art of data visualization using the powerful tools of Microsoft Power BI Desktop and PowerBI.com. Whether you're a business professional, a budding data analyst, or simply someone interested in the world of data science, this course is tailored to enhance your skills in transforming raw data into visually stunning and insightful reports. Dive into the intuitive interfaces of Power BI Desktop and PowerBI.com, and learn to navigate these platforms with ease and confidence.

The course is meticulously structured to provide you with demonstrations and practical knowledge. Starting with a comprehensive tour of the Power BI Desktop and PowerBI.com interfaces, you'll quickly move to the core of creating impactful visuals. Explore a wide array of available visuals and learn how to select the most effective ones for your data stories. Through detailed sessions on building interactivity into your visuals, you will discover how to create dynamic reports that not only captivate but also communicate effectively. This course will also guide you through the process of publishing your reports on PowerBI.com, ensuring that your insights reach their intended audience with the right impact.

By the end of this transformative journey, you will be adept at leveraging the full capabilities of Power BI. Your newfound ability to create interactive, engaging, and informative visual reports will make you an indispensable asset in any data-driven decision-making process. Embrace this opportunity to elevate your professional profile, enhance your analytical capabilities, and become a sought-after expert in the field of data visualization. Join us for "Create Visuals in Power BI to Successfully Analyze Data" and step into the future of data analysis with confidence and skill.

This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The major topics that will be covered in this class include:

• Tour of the Power BI Desktop Interface: Understand the layout, tools, and features of Power BI Desktop.
• Tour of PowerBI.com Interface: Familiarize with the online environment of Power BI for report creation.
• Importing Power Pivot Data Model: Understand how to integrate Power Pivot models into Power BI for more complex data analysis.
• Building Visuals: Learn the step-by-step process to create compelling visuals and understand the importance of visual context in data storytelling.
• Review of Available Visuals: Explore the variety of visuals available in Power BI and their appropriate applications.
• Power BI Desktop Features: Delve into the advanced features of Power BI Desktop, enhancing data manipulation and visualization capabilities.
• Building Interactivity into Visuals: Learn to create dynamic and interactive reports that engage and inform.
• Publishing Reports to PowerBI.com: Gain skills in uploading and managing reports on PowerBI.com for wider access and collaboration.

Who will benefit:

This course is ideal for business analysts, data analysts, project managers, and any professionals keen on enhancing their data visualization and analysis skills using Microsoft Power BI. It is suitable for beginners as well as those with some experience in data analytics tools.

This webcast is hosted on CPA Crossing platform. Attendees will receive instructions on how to attend the webcast via e-mail.

This session will address the complex rules of retirement distributions, review key provisions of the SECURE Act 2.0, and provide practical strategies of maximizing tax benefits for your client.

This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The major topics that will be covered in this course include:

• Required minimum distributions for a deceased’s heirs
• 2025 retirement plan contribution limits
• Required minimum distributions and contributions to charity
• Key provisions of Secure Act 2.0

Who will benefit:

CPAs and members in industry seeking an in-depth review of required minimum distribution rules.

This webcast is hosted on CPA Crossing platform. Attendees will receive instructions on how to attend the webcast via e-mail.

Practical hands-on Excel learning exercises taught by a highly engaging expert in the field

You’ll develop your expertise with real-world Excel workbooks. Despite the popularity of VLOOKUP, it has its drawbacks. This session will address these drawbacks while offering alternatives.

You’ll walk through the VLOOKUP and IFERROR functions, and explore the following topics:

- Improving the use of VLOOKUP with VALUE/TEXT

- Improving the use of VLOOKUP with MATCH.

- Moving beyond VLOOKUP with INDEX

- Trapping errors with IFERROR

Moving beyond basic Excel functions

Grasping the limitations and possible enhancements for the VLOOKUP feature, along with methods to handle errors can elevate your proficiency in Excel.

You’ll also partake in hands-on Excel activities that showcase the integration of functions and their use in crafting spreadsheets, encompassing:

- Combining functions to enhance flexibility

- Utilizing functions for atypical data categories

- Perfecting sophisticated lookup functions

*Session 5 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 6: List Comparisons and Indenting] (https://www.aicpa-cima.com/cpe-learning/webcast/excel-for-accounting-professionals-session-6--list-comparisons-and-indenting) to further prepare to tackle real-world issues and build powerful workbooks.*

Learning Objectives:

- apply the use of VLOOKUP with MATCH to search Information effectively in Excel.

- apply the use of VLOOKUP with value/TEXT to increase VLOOKUP functionality.

- Determine When to move beyond VLOOKUP with the INDEX function.

- Identify ways to trap errors with IFERROR.

- use the if function.

Who will benefit:

Accounting and finance professionals who'd like to improve their mastery of Microsoft Excel

This is an AICPA hosted webcast. You will launch the course from your OSCPA learning center portal. AICPA will issue and maintain your credits. Please make sure to download your CPE certificate from AICPA webcast portal at the conclusion of the webcast.

The course provides a concise overview of how to use ChatGPT to more effectively and efficiently research IRS taxation law. It delves into techniques for extracting precise information from complex tax legislation, interpreting IRS guidelines with AI assistance, and utilizing ChatGPT's advanced language models for nuanced legal analysis. Participants will learn how to streamline their research process, identify relevant tax law precedents, and apply AI insights to real-world tax scenarios, enhancing their professional proficiency in navigating the intricate world of IRS taxation.

This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The major topics that will be covered in this course include:

• Utilizing ChatGPT for IRS Tax Law Research: Principles and Practices
• Navigating IRS Databases Using Advanced AI Techniques
• Using IRS Prompt Templates: In-depth Analysis and Application
• ChatGPT in Action: Case Studies and Real-World Scenarios
• Exploring IRS Tax Laws: Strategies, Loopholes, and Compliance
• Error Prevention and Correction in Tax Law Research
• Future Trends: AI's Evolving Role in Taxation and Accounting

Who will benefit:

This course is ideal for accountants seeking to integrate AI technology into their tax research methods. It is particularly beneficial for professionals aiming to enhance their analytical skills, improve data interpretation, and stay ahead in the rapidly evolving field of taxation.

This webcast is hosted on CPA Crossing platform. Attendees will receive instructions on how to attend the webcast via e-mail.

Financial statement disclosures are important to provide the information necessary for financial statement users to make economic decisions. Disclosures further explain and clarify information provided in the basic financial statements, but also provide critical information about subsequent events, litigation risk, and other concerns. This course focuses on the most common financial statement disclosures for small- or medium-sized nonpublic entities.

This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The major topics covered in this class include:

• General disclosures about the entity and its environment
• Common critical information useful to financial statement readers for making economic decisions
• Explain results of operations through information that supplements the face financial statements

Who will benefit:

Accountants at all levels interested in remaining current with accounting and financial reporting requirements

This webcast is hosted on CPA Crossing platform. Attendees will receive instructions on how to attend the webcast via e-mail.

This program reviews the statutory and regulatory guidance as they relate to fringe benefits. There will be an emphasis on entertainment, meals and business transportation expenses, including qualified employer-provided parking, with a focus on planning opportunities. Recent federal tax legislation, cases and rulings will also be addressed.

This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The major topics that will be covered in this class include:

• Definition of what qualifies as an entertainment expense
• Strategies to deduct business entertainment expenses
• Deductibility of meals
• Situations not subject to the 50% meals and entertainment reduction
• How to handle automobile issues related to employer-provided parking
• Proper accounting for deductible vs. non-deductible expenditures
• The four steps to analyze business expenses
• The latest federal legislation, cases and rulings

Who will benefit:

CPAs in public practice and industry seeking the latest developments on reporting entertainment and business transportation expenses.

This webcast is hosted on CPA Crossing platform. Attendees will receive instructions on how to attend the webcast via e-mail.

Recent generally accepted auditing standards were written to improve the quality of risk-based financial statement audits, audit reporting, and required by-product communications. This course will discuss the important clarifications and enhancements intended to improve audit quality to ensure better compliance with requirements contained in the SASs.

This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The major topics that will be covered in this course include:

• Key changes to audit report elements intended to improve the understandability of the nature and results of financial statement audits
• Enhanced required by-product communications with management and those charged with governance to promote more reliable financial statements
• Clarifications related to obtaining sufficient and appropriate audit evidence, including significant unusual transactions, related parties, going concern uncertainty, and accounting estimates
• New definitions and requirements related to identifying and evaluating risks of material misstatement
• Other important matters contained in recent SASs 

Who will benefit:

Anyone who provides attest services on financial statements

This webcast is hosted on CPA Crossing platform. Attendees will receive instructions on how to attend the webcast via e-mail.

Major benefits of detailed Excel workbooks

Understanding list comparisons in Excel is vital for improved workbook efficiency. In this webcast, the facilitator will walk you through comprehensive learning exercises that provide an overview of the following topics:

- Performing list comparisons

- Building multicolumn list comparisons

- Using lookups

- Indenting commands

In-depth training for Excel upskilling

This webcast is crafted to enable active participation as you follow the demonstrations. It will navigate you through the intricacies associated with working Excel columns, helping you to apply key functions effectively for significant improvements through the following:

- ISERROR

- COUNTIFS

- SUMIFS

*Session 6 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 7: Data- Driven Workbooks and Concatenation] (https://www.aicpa-cima.com/cpe-learning/webcast/excel-for-accounting-professionals-session-7--date-driven-workbooks-and-concatenation) to further prepare to tackle real-world issues and build powerful workbooks.*

Learning Objectives:

- Apply Excel’s LOOKUP function to perform list comparisons.

- Use the ISERROR function to detect errors.

- Use the COUNTIFS function to perform multicolumn list comparisons.

- Determine appropriate application of indentation for efficiency gains.

- Compare traditional LOOKUP functions to multiple condition summing function.

Who will benefit:

Accounting and finance professionals who'd like to improve their mastery of Microsoft Excel

This is an AICPA hosted webcast. You will launch the course from your OSCPA learning center portal. AICPA will issue and maintain your credits. Please make sure to download your CPE certificate from AICPA webcast portal at the conclusion of the webcast.

In an era defined by rapid change and uncertainty, effective leadership requires more than just managing teams; it demands the courage to disrupt and innovate. This course is your blueprint for transforming potential chaos into a strategic advantage and is designed for leaders at all levels-whether you're a seasoned CEO, an ambitious small business owner, or an individual contributor aspiring to influence greater change. You'll gain the insights and tools needed to not only adapt to change but to lead it effectively and confidently.

This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The major topics that will be covered in this course include:

• The urgency of leading change now & the steps in leading change
• The power of crafting a vision that encourages buy-in
• The art and science of building strong partnerships
• Accelerating change through relationship networks
• Communication strategies for change
• Establishing a feedback culture for successful change
• Managing self in times of change
• Case studies and real-world scenarios

Who will benefit:

CFOs, CPAs, solo practitioners, staff, policy makers, executives, legal representatives, and others interested in leading change better.

This webcast is hosted on CPA Crossing platform. Attendees will receive instructions on how to attend the webcast via e-mail.