Everyone knows that Excel is the most widely used spreadsheet application in the world today. However, because it is ever-changing, many users are unable to keep up with the latest features and capabilities of this ubiquitous application. In this session, we look at some of the most helpful new features and tools that have been added to both the Desktop version of Excel and the Web version. Content like this is valuable to anyone that regularly works with Excel - We hope you will attend! 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:

• New features and tools in Excel
• Updates to the Excel Function Library

Who will benefit:

Accounting and other business professionals that work in Excel regularly.

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

What can we learn from one of the largest municipal frauds in U.S. history? Rita Crundwell stole nearly $54 million from the citizens of Dixon, Illinois over the course of two decades. This course examines circumstances that allowed this landmark fraud to occur. We will explore internal control deficiencies and other circumstances that hindered prevention or timely detection of Rita's scheme. 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:

• Key aspects of Rita Crundwell’s theft
• Internal controls that could have prevented the theft
• Internal controls that could have detected the theft in a timely manner
• Independence in both fact and appearance
• Lessons for CPA firms
• Lessons for government agencies

Who will benefit:

CPAs in public practice, members in industry, and other professionals who want to enhance their fraud awareness and detection skills.

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

Most U.S. businesses are formed as a pass-through entity, which includes partnerships. If you are new to the subject, or if you have worked in this area for years but need a quick review, this course will provide a firm grasp of the fundamental concepts, help you to build a strong foundation of knowledge, and freshen up your analytical skills. Talking about tax can sometimes sound like you're speaking a foreign language in front of your clients. You can leverage the tone of the course materials to explain complex issues with accuracy and confidence.

Learning Objectives:

· Identify the effects of investor contributions and distributions on their basis in a partnership or LLC interest.

· Calculate the tax basis of assets transferred to a partnership or LLC at formation.

· Recognize the tax consequences of a transfer of liabilities to a partnership or LLC in connection with property transfers at formation.

· Calculate the partner’s or member’s remaining basis in their interest following a distribution of cash or property from the partnership or LLC.

· Calculate the amount of the guaranteed payment when the partner is to receive the lesser of a fixed dollar amount or a fixed percentage of partnership income.

· Distinguish between “book” allocations required under Section 704(b) and “tax” allocations required under Section 704(c).

· Identify the potential economic consequences of a special allocation to a partner or LLC member.

Who will benefit:

· Public accounting staff and seniors

· Tax professionals in company finance or tax departments

THIS IS AN AICPA HOSTED WEBCAST. YOU WILL LAUNCH THE COURSE FROM YOUR OSCPA LEARNING 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.

Unless you expect your organization to be stable in the short, medium and long term, you need to understand how to create long-term balance sheet and cash flow projections. Growing organizations must know whether they will have the resources to execute their business plan. Struggling organizations need to know if they will have the cash to survive. This session will increase your organization's ability to see its future and increase the confidence that your CEO, Board and bank have in you. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Create a Projected Balance Sheet:

• Accounts Receivable
• Inventory
• Capital Budget
• Depreciation
• Accounts Payable
• Accrued Liabilities
• Working Capital Loans
• Debt
• Project interest expense more accurately
• Solving for Cash
• Projecting Covenant Calculations
• Create a Projected Statement of Cash Flow
• Choose your format
• How to make your Statement of Cash Flow maintenance free
• Debugging a statement of Cash Flow
  

Who will benefit:

CFOs, Controllers, Treasurers, and Budget Managers

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.

Seismic changes in tax legislation is currently taking place, and the well-informed tax practitioner will want to attend this two hour monthly program in order to stay abreast of these developments! Approximately one-half of the program is devoted to individual tax issues, and the remaining time is spend on business entity taxation, IRS procedure, tax legislation and other issues. Due to the changing nature of the topic, learning objectives, course descriptions and program content will vary and will be provided in more specificity closer to presentation time. This course provides a concise look at the hottest topics affecting every tax practitioner. 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:

• Current individual tax issues
• Current business entity tax issues
• Any current tax legislation occurring during the period
• Other issues affecting the profession, including IRS procedure, current cases, payroll, and other federal tax issues

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 that have tax implications.

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

NOTE – This ethics course has not been approved by the Accountancy Board of Ohio therefore does not count towards your mandatory 3 Hours of Professional Standards & Responsibilities credit per renewal period. This course does count towards your 120 CPE Hours.

Do you find yourself challenged to achieve the results you want? While leading employees can be one of the most challenging activities, it is also one of the most impactful leadership skills few seem to master. Inspirational leadership looks like lifelong employees reaching their full potential AND impactful business results that are repeated year after year. Striking the balance between these two critical aspects does not have to be rocket science. In this power-packed course, the formula to be an Inspirational leader has been masterfully developed and covers the soft skills of Inspirational leadership and the Results Model:
Goal Setting + Coaching + Follow Up with proven results from dozens of both large and small companies. These cornerstones are simple but can be hard to execute because it is HOW you do it first, then WHAT you do second. This exciting course is designed to ignite your leadership skills by putting theory into practice; drilling into real live examples and experiencing first-hand what excellence sounds like through role-playing and building your action plan. Get ready to become an inspirational leader and learn the steps required to get the results you really want. 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:

• How Inspirational leadership is the foundation that ethically drives results.
• Simplify the complex:
  Walk through the Results Model and discover practical how-to examples of execution.
• Hacks for getting great results with specific examples you can leverage in your business:
  
  • The How:
    Empower your people to feel like an owner, managing difficult conversations well, leading with empathy and what that looks like, how it should feel, motivational coaching techniques to get your employee relationships back on track, and unleashing the power of appreciation and gratitude.
  • The What:
    Powerful score-carding, transformational goal-setting conversations, and positive accountable follow- up.

Who will benefit:

CFO, CEO, leaders, and aspiring leaders.

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

This session provides a refresher regarding the fundamentals of activity-based costing (ABC). We will examine theoretical concepts before exploring practical possibilities for implementing ABC. A major focus of the course will be factors to consider when determining whether this managerial accounting tool is an appropriate resource for an organization. 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:

• ABC versus traditional costing
• First-stage allocation
• Determining predetermined overhead rates
• Second-stage allocation
• Activity-based reporting
• Activity-based management

Who will benefit:

Accountants who have not recently considered ABC but want to revisit the cost-benefit prospects of ABC for potential utilization for their clients or their employing organization.

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

The course provides a concise overview of how accountants can use ChatGPT to assist with communications involving intricate and often sensitive topics that require a deep understanding of both financial principles and human resource policies. These conversations can range from budgeting and compensation to ethical considerations and regulatory compliance. The course also explores the use of ChatGPT in crafting clear, accurate, and empathetic responses to complex queries related to financial audits, tax planning, and employee benefits. It emphasizes the importance of balancing technical financial knowledge with effective communication skills to address diverse stakeholders' needs in various scenarios, from internal team discussions to client consultations. 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:

• Complex and nuanced communications related to:
  
• Budget Allocation and Negotiation Techniques
• Compensation and Benefits Structuring
• Managing Financial Performance and Layoffs
• Financial and HR Aspects of Mergers and Acquisitions
• Regulatory Compliance and Ethical Financial Practices
• Strategies for Financial Crisis Management
• Effective Performance Management Systems

Who will benefit:

Accountants and financial professionals who regularly engage in intricate conversations encompassing both financial expertise and human resource insights will find this course immensely valuable.

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

Discuss trends and changes impacting the American workforce. Discover "why" culture matters, the "benefits" of great cultures, and the workforce challenges created both before and after the pandemic. Once the audience has clarity on these items, the presentation shifts to "how" to create a great culture in our post-pandemic environment. Jim provides practical tools that can be implemented at any organization. Some of the tools are directly related to the new challenges resulting from the COVID-driven pandemic. 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:

• Why Culture Matters
• Workforce Challenges
• Creating a High Performance Culture
• Practical Tools

Who will benefit:

CPAs, CFOs, Business owners and leaders, business service professionals, HR leaders and professional

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