In today's rapidly evolving business landscape, accounting professionals are expected to be more than just number crunchers, they are expected to be insightful interpreters of data. In an era where data is king, this course is your gateway to becoming a savvy data analyst, giving you a competitive edge in your field. We will guide you through the intricacies of making complex data analysis approachable and engaging.

You will learn the all important Data Analysis Process Flow that will take you from collecting data all the way to making insightful decisions based upon your data. We will explore the basics of data modeling that will allow you to access data from multiple sources and use sophisticated calculations to create our data metrics. You will learn how to create interactive dashboards, perform sophisticated reporting, and uncover deep insights from your data.

Whether you're looking to streamline your reporting process, enhance your data visualization skills, or make more data-driven decisions, this course is tailored to meet those needs. It's not just about learning a tool; it's about enhancing your professional identity as a forward-thinking accounting professional.

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

• Data Analysis Process Flow: An introduction to the Data Analysis Process Flow and how it is your pathway to becoming a Data Analysis Expert.
• Data Modeling: A comprehensive discussion of building a data model and calculating metrics.
• Data Visualizations: An understanding how visualizations can present data in a more insightful and impactful manner.

Who will benefit:

This course is ideal for anyone who is looking to become a data analysis expert.

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

Bitcoin, the original cryptocurrency, was released in 2009. After 15 years the cryptocurrency market consists of over 5,000 unique coins/tokens with a market capitalization of over 1.5 trillion as of 1/1/24. This course will provide an update on the cryptocurrency market and the blockchain technology that supports it.

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:

• Update on the cryptocurrency marketplace
• Cryptocurrency exchanges - the good, the bad and the ugly
• Overview of cryptocurrency taxation regulations
• The technology behind cryptocurrency - Proof of stake, Layer 2, wallets and more
• Blockchain technology update

Who will benefit:

Anyone who is interested in getting up to speed on the current state of the cryptocurrency marketplace.

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

This course explores actual fraud circumstances through the lens of potential prevention. We will examine how selected frauds were accomplished and consider what internal controls may have prevented fraudsters from achieving their nefarious acts. Then we will switch gears to an interactive, case-based discussion that asks participants to reach their own conclusions by analyzing facts in concert with the AICPA Code of Professional Conduct and other sources of ethical guidance. This course ultimately provides practical, action-oriented insight that can be implemented by accounting professionals in both public practice and industry.

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

The major topics covered in this course include:

• Examination of actual frauds
• Discussion of internal controls that could have prevented frauds
• Contemplation of epiphanies for your own professional scenarios.
• The AICPA Code of Professional Conduct
• Other elements of professional conduct and compliance with professional standards

Who will benefit:

CPAs in public accounting, members in industry, and other business professionals who seek practical insight regarding fraud prevention and ethical behavior.

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

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.

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:

• Discuss the calculation of basis when the entity is formed including the impact of contributed property
• Explain the importance of shareholder loans to the entity
• Uses a comprehensive example to illustrate the mechanics of the basis determination process
• Schedule K-1 Basis and Form 7203
• Discuss how basis is impacted by distributions of corporation property
• Explain how basis is impacted by sale/or liquidation of the S corporation interest
• Discuss how S corporation losses impact Form 1040 Schedule E reporting
• Show how to get from the Schedule K-1 information to the basis calculations

Who will benefit:

CPAs working in public accounting firms and/or working for S corporations.

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

Just about every company, no matter its size or the types of activities it undertakes, is at greater risk because of all the types of fraud that can be be carried out electronically. Potential perpetrators can be operating internally or externally and the scope of the damage that occurs is almost never limited to cyber-assets. While threat awareness is improving, there are still too many owners or top level executives that underestimate the scale of the issue. In this session, we delve into the types and the nature of many electronic defalcation schemes. The material then explores measures that organizations can implement to help stop these activities and add additional layers of security.

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 course include:

• The actuation of online and other cyber frauds
• Fraudulent acts that are initiated electronically
• Automated and employee driven methods that can reduce cyber-fraud risk

Who will benefit:

Accounting and other business professionals with a need to understand online fraud.

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

After a false start in 2022 when it failed to pass through Congress, the Secure Act 2.0 was passed in a flurry of year-end legislation. This two hour program will cover the important changes in savings and distributions of retirement plans that impact individuals. Employers will also need to consider how Secure Act 2.0 will the administration of existing plans or the creation of new ones. This course will provide a concise look at these hot topics.

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:

• Implications for individuals
• Changes to the Saver’s Credit
• Changing the required minimum distribution rules for Roth 401(k)s
• Changes to required beginning dates for required minimum distributions of retirement plans. 
• Penalty-Free Withdrawals for Certain Emergency Expenses
• Special provisions for firefighters and military personnel spouses 
• Increases in catch-up contributions 
• Impact on 529 plans
• Opportunities for student loan payment matching
• Implications for Employers
• Starter § 401(k) plans for small employers
• Requiring automatic 401(k) enrollment
• Improving worker access to emergency savings
• Increasing part-time workers’ access to retirement accounts
• Statute of Limitations on excise taxes imposed on overcontributions to retirement plans
• Multiple employer §403(b) plans
• Automatic portability provisions
• Other changes in the administration of company retirement plans

Who will benefit:

This course is suitable for Corporate tax and finance executives, directors, managers and staff, CPAs, CAs Enrolled Agents, accountants, attorneys and business/financial advisors who work with and advise businesses and individuals that have these tax implications.

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

This Masterclass is a one-hour training exclusively for CPAs and accountants. Rely less on tax season and use your expertise to help business owners have a better future!

Designed for CPAs, but also applicable to enrolled agents and accountants, this webinar covers the steps necessary to effectively transform a tax or accounting practice into an advisory service. We explore what it means to be a CFO/advisor to small-to-medium sizes businesses and what qualifications are necessary to offer such a service. We will also cover how to find and convert leads and how to price and package services, including combining advisory services with the firm's current offerings.

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 steps necessary to effectively transform a tax or accounting practice into an advisory service.
• What it means to be a CFO/advisor to small-to-medium sizes businesses.
• What qualifications are necessary to offer an advisory service.
• How to find and convert leads and how to price and package services, including combining advisory services with the firm’s current offerings.

Who will benefit:

Accountants, CPAs, bookkeepers, and enrolled agents.

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

This course provides a complete framework for transforming the culture in your organization. Key topics covered include:

- What is organizational culture

- A self assessment

- Why culture matters

- How to change your culture

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:

• What is culture
• Why culture matters
• A process to change your organization’s culture

Who will benefit:

Anyone in business management or human resources.

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

This course focuses on the most common aspects and tax implications of Limited Liability Companies and S Corporations. It will further compare forms of entities, along with corporate formalities compliance issues of each entity type. Electing Subchapter S status as well as reviewing the mechanics of electing Subchapter S status will be discussed. Highlights of entity specific tax forms will be discussed, as well as accountable plans, taxable fringe benefits, officer reasonable compensation, estate planning, business continuation planning and audit strategies. Schedules K-1, K-2, K-3, and effectively connected income will be reviewed in this course as well.

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:

• Comparative analysis of LLCs and S Corporations
• Entity formation, compliance, and operational structures
• Self-employment tax and its implications for LLCs and S Corporations
• Form 2553 preparation and relief for late filings
• Rev. Proc. 2022-19 and Rev. Proc. 2023-3: analysis and application
• S Corporation eligibility errors and corrective measures
• Corporate governance and formalities for both entity types
• Shareholder stock and debt basis for S Corporations
• Forms 1120S, 1065, and related schedules (K-1, K-2, K-3)
• Officer reasonable compensation and general partner guaranteed payments
• Audit strategies, estate planning, and business continuation planning

Who will benefit:

CPAs, EAs, Tax Professionals, Financial Planners, Investment Advisors, Attorneys, Professionals advising or working with LLCs and/or S Corporations

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

Enhancing Excel workbook productivity

This workshop covers organizing and managing worksheet information, offering hands-on participation alongside the instructor. Through the practical tasks, you will gain a comprehensive grasp of commonly utilized Excel functions such as:

- Hiding worksheets

- Inputting cells styles for users

- Organizing workbooks

Mastering Excel capabilities

Becoming proficient in Excel entails developing workbooks that are efficient and well-organized. The facilitator will guide you through mastering complex functions, selecting cells and objects, and organizing principles of workbook design. You'll enhance your basic understanding of Excel with topics including:

- Creating complex formulas with nested functions

- Applying techniques for group selection

*Session 3 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 4: Conditional Summing and Lookups] (https://www.aicpa-cima.com/cpe-learning/webcast/excel-for-accounting-professionals-session-4--conditional-summing-and-lookups) to further prepare to tackle real-world issues and build powerful workbooks.*

Learning Objectives:

- Determine when to hide worksheets to organize and control worksheet information from other users.

- Apply cell styles for efficient formatting.

- Apply workbook and worksheet organization techniques.

- Use nested functions to build formulas.

- Use selection group techniques on Excel cells and objects.

- Analyze design principles for organized and efficient Excel workbooks.

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.