CPE & Event Calendar

This intensive 2-hour course is designed specifically for those aiming to master data management skills in the modern business environment. As data becomes increasingly central to accounting and financial analysis, the ability to effectively manage, clean, and transform this data is critical. This course delves into Microsoft Power Query, a potent tool within Excel and Power BI Desktop, known for its robust data processing capabilities. This course is designed to take participants from the basics of Power Query to exploring its more sophisticated features. It is an ideal blend of theoretical knowledge and practical application, centered around diverse data scenarios encountered in multiple industries. The aim is to ensure that the skills and techniques learned are universally applicable and beneficial in any professional context. Structured to be participant-focused, the course encourages active learning through a series of practical exercises, live demonstrations, and illustrative case studies. This approach not only deepens the understanding of Power Query's features but also demonstrates how to turn complex data sets into actionable insights. While the course is broad in its application, it remains detailed in its instruction, catering to both the novice and the seasoned professional. It is particularly beneficial for those who regularly interact with data, such as business analysts, project managers, and financial professionals, providing them with the tools to streamline data processes and enhance data analysis capabilities. Additionally, the course underscores best practices in data management. Participants will learn strategic approaches to data challenges, ensuring that their data processes are efficient, scalable, and sustainable. This is not just a course about mastering a tool; it's about empowering professionals with the skills to transform data into a strategic business resource. By the end of the course, participants will be equipped to leverage Power Query in Excel or Power BI desktop to its full potential, turning data into a powerful driver for business success and innovation. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The Internal Revenue Service has targeted complex partnerships it believes are not in compliance with the tax law for audit. One of the abuses the IRS has attacked is transfers of interests in partnerships which result in an increase in the basis of a partner who is subject to a high marginal income tax rate. This perceived abuse results in lower income tax and/or a higher basis in partnership property for the higher marginal income tax partner. The final regulations basically characterize certain partnership-related basis adjustments as transactions of interest on the part of the IRS. In a practical sense, this means that property transfers in a partnership with related party partners may run the risk of IRS scrutiny if audited. It is common for certain types of partnerships, such as real estate limited partnerships, to have related-partner partnerships. The IRS may decide to scrutinize partnerships with related party transfers. Since these final regulations presume an understanding of the rules for partnership distributions and Section 754 elections, the program begins with coverage of those two topics, with time devoted to adjustments under both Section 743(b) and Section 734(b). It would be hard to understand the IRS's claim of abuse without a working knowledge of these transactions.

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.

This course is a great foundation to introduce new preparers to tax rules related to business returns. The course covers tax areas affecting all business entities, providing a solid basis for staff to handle business entity returns. Such business tax topics include the sale of assets used in a trade or business (Form 4797), depreciation (Form 4562), deductible and nondeductible items, and the basics of uniform capitalization. The objective of this course is to train new staff accountants, data processing employees, paraprofessionals, and bookkeepers to prepare complicated federal corporate income tax returns. It is a hands-on and practical course, with extra emphasis on changes to forms under new tax law.

This course will explore the use of ChatGPT and artificial intelligence chatbot technologies in the accounting profession. Participants will learn how to utilize ChatGPT to automate tasks, improve efficiency and accuracy, and provide real-time support to clients. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

CPAs can be requested to assist attorneys in litigation support in criminal proceedings. For criminal tax cases, the IRS has recommended prosecution. However, the rules and stakes are different than a simple civil audit. This presentation will focus on how to assist defense attorneys in calculating tax loss, asking the right questions, and probe possible weaknesses in criminal tax investigations. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

How do you pull a value from a cell into another cell? Do you use a direct cell reference, like =G10? If so, you are probably missing out on some efficiency gains that could be achieved by using a variety of Excel's lookup functions. Veteran Excel users, who are aware of the VLOOKUP function, are also painfully aware of its limitations--especially that it cannot go left. We will explore how to bypass VLOOKUP's limitations by nesting functions and by moving beyond VLOOKUP altogether.

Part of the technical competence of most experienced tax practitioners is the ability to advise owners of S corporations and partnerships or multiple-member LLCs treated as partnerships regarding the tax rules that apply when these entities liquidate. Entity liquidations do not occur every day; but they do occur, and often at very critical times in the business life of the entity and its owners. All tax practitioners should be able to advise their clients about the tax issues associated with client businesses that go out of existence and liquidate. This program explains the tax consequences associated with liquidating S corporations, partnerships, and multiple-member limited liability companies treated as partnerships.

Today's workforce looks a lot different than it used to. With more people working from home and across state lines, employers must examine withholding and unemployment laws in a new light. In this course, we will examine tried and true rules in this area, but also examine statutes that are still developing. Using real-life examples and discussion, we will examine state laws on reciprocity and residency requirements. We will also look at what to do when state laws are silent or conflict on a particular issue, so that you can keep your clients in compliance and be well-prepared for the questions that will come your way in these ever-changing times.

Enter the complex world of elder planning with this comprehensive course tailored for financial professionals. Gain invaluable insights into estate and financial strategies designed specifically for older clients, equipping you with the knowledge and skills to address their unique needs and challenges. Throughout the course, participants will explore a wide range of topics, from understanding the complexities of Medicare and various life insurance types to navigating Social Security considerations and exploring Medicaid planning details. With a focus on practical application, attendees will learn to customize estate planning strategies, explore housing and care alternatives, and address gifting complexities relevant to older clients. By the end of the program, you'll develop expertise in executing specialized planning requirements for mature clients, ensuring you're well-prepared to provide informed counsel and support in this important aspect of financial practice. Join us and enhance your knowledge in estate and financial planning for the older client today. *Please Note:  If you need credit reported to the IRS for this IRS approved program, please download the IRS CE request form on the Handouts Tab and submit to kori.herrera@acpen.com

How well do you accept criticism? How might it enrich your business - and you - if you did a better job of it? This distinctive webinar will show you why it is in your best interest to accept criticism with gratitude. It's even better to welcome criticism. It's also a good idea to learn how to give criticism the right way. A related topic is the art of giving and receiving apologies, and we'll do a deep dive into this area as well. You'll leave with clear guidelines for how to criticize others, accept criticism from them, give meaningful apologies, and accept apologies with grace and ethical intelligence. The result will be a stronger CPA practice and a better you. 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 highlights when to use Form 433-A or 433-B, along with documents needed to effectively submit an Offer in Compromise (OIC) or Installments Agreement. Settling tax debts is an important part of the IRS collection process, this course helps guide taxpayer representatives through the process so they may efficiently complete these necessary forms. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The AICPA revised the Statements on Standards for Tax Services, which provide the framework for the AICPA ethical guidance for tax practitioners. This program will review the new standards that apply to all members who provide tax services, effective January 1, 2024. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

In May 2023, the IIA released a draft of the new Global Internal Audit Standards. The intent was to provide more effective standards for Internal Audit globally. The new Global Internal Audit Standards were released on January 9, 2024, and will become effective January 9, 2025. The previous version, the International Standards for the Professional Practice of Internal Auditing, released in 2017, remains approved for use during a one-year transition period. The Global Internal Audit Standards guide the worldwide professional practice of internal audit. They serve as a basis for evaluating and elevating the quality of the internal audit function. The Standards use 15 guiding principles with five separate domains that enable effective internal audit implementation and examples of evidence of conformance. The Global Standards are organized into five domains. Domain I: Purpose of Internal Auditing Domain II: Ethics and Professionalism Domain III: Governing the Internal Audit Function Domain IV: Managing the Internal Audit Function Domain V: Performing Internal Audit Service

The well-informed tax practitioner will want to attend this two hour program in order to stay current on recent updates on partnership tax! Content includes recent court decisions on partnership tax issues as well as current IRS procedural updates for passthroughs. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Internal controls are more important than ever, and their importance increases daily. However, internal controls present a challenge for many smaller organizations. This program will teach you how to evaluate, develop, and implement an effective internal control structure in a small business environment. You will identify how to assess risk in smaller organizations and implement preventive, detective, deterrent, and compensating controls to mitigate these risks, even without proper segregation of duties. Additionally, participating in this program will teach you technology-focused techniques for preventing and detecting fraud and securing information systems and sensitive data. For small organizations, maintaining an effective system of internal controls presents a significant challenge. Realistically, implementing many theoretical concepts surrounding internal controls may not be possible in some cases. Consequently, many internal control structures foster an environment where too much risk exists. This factor and uncontrolled information systems can often lead to disastrous results. Participate in this program to learn the necessary insights and tools to design, implement, and monitor effective internal controls, security, and anti-fraud measures in small organizations.

Most leadership development focuses on a single direction within the organizational hierarchy: downstream to subordinates. While it is important to be a good boss, leadership is much more than that. The best leaders learn to lead well in all directions. They lead upward to superiors and across among peers throughout the organization. And it all starts with self-leadership. This often overlooked or misunderstood leadership principle is essential to build a thriving and productive culture. This topic is based on Jon’s book, Mission-Critical Leadership: How Smart Managers Lead Well in All Directions. 

The role of financial professionals has and continues to change in organizations. The stereotype of collecting and reporting data has been replaced by a broader vision, which focuses on improving an organization's results today and preparing it for the future. This brief program offers specific actions that can be implemented by financial personnel to expand their role through improving their organization. The actions and techniques provided build upon and improve activities that exist in many organizations (measuring, budgeting, hiring, risk management, etc.), as well as providing insights into capital allocation, cash management, valuation techniques, variables that influence capacity levels, M&A activity and actions to increase efficiency and innovation. Updated to include the impact of regulations, additional examples of M&A, alliances and strategic spin-offs/splits, methods to improve efficiency from existing activities, the impact of COVID-19, as well as current organizational changes employed to manage and accelerate growth.

In this webinar we will explore the powerful concept of splitting data from reports and dig into the mechanics that enable this technique. The key feature discussed is the Tables feature, and the key function discussed is the multiple-condition summing function. We will illustrate these items in a variety of ways, including building crosstab style reports and mapping tables.

Tax planning for 2025 is largely based upon legislation contained within the Inflation Reduction Act and the SECURE Act 2.0, that offer new planning options and challenges for businesses in 2025. There are, however, other business tax changes in 2025 that result from different pieces of tax legislation, IRS pronouncements, and court cases that need to be taken into account from a planning perspective. This program analyzes the new opportunities and challenges that these tax changes offer to businesses and their owners that impact 2025 and sometimes later years.