CPE Catalog & Events

Tax practitioners are responsible for presenting partner capital accounts on the tax basis. But what does this mean and how have rules changed in recent years regarding partner capital accounts? This course covers exactly that. For tax practitioners preparing partnership 1065 forms, this course explains these complex rules in practical and understandable terms.

In February 2016, FASB issued ASU 2016-02, Leases, which provides new guidelines that change the accounting for leasing arrangements. To be able to properly account for leases, financial professionals must understand ASU 2016-02 (also referred to as Topic 842). This guidance covers information on how leases should be accounted for. The previous leasing standard (ASC 840) had been in existence for almost 40 years. Under ASC Topic 842, lessors continue to classify leases as operating, direct financing, or sales-type. While lessees now classify leases as operating or financing leases. Previous guidance only required capital leases to be reflected on the BS. The new guidance requires all leases to be reflected on the BS. This is a major change for organizations and will cause their balance sheets to swell as leases must now be disclosed on the balance sheet. The standards original effective dates were prior to 2019. In April 2020, due to COVID-19, FASB voted to defer the effective date for ASC 842 for private companies and certain not-for-profit's for one year. For private companies and private not-for-profits, the leasing standard will be effective for fiscal years beginning after December 15, 2021, and interim periods within fiscal years beginning after December 15, 2022. For public companies the leasing standard is effective for fiscal years beginning after December 15, 2019, including interim periods within those fiscal years. The course covers elements of lease classification for both lessees and lessors. Also, numerous examples are incorporated as reference.  

Owners of S corporations and partnerships are subject to numerous limitations on pass-through losses, each with unique rules, applications, and complexities. With the increase in popularity of pass-through business entities, it is essential for CPAs to understand the complexities and interactions of these pass-through loss limitations.

The majority of peer review deficiencies and malpractice claims result from nonaudit services. This course will provide best practices for avoiding legal liability and quality control concerns.

With approximately 500 functions now available in Excel, some newer and more powerful tools are easy to overlook. But, if you do that, your productivity will suffer. In this session, you will learn how to take advantage of many of Excel’s more advanced features – some new and some legacy – to elevate your productivity to higher levels. In this session, you will learn about many of Excel’s newer tools, including XLOOKUP, SUMIFS, SWITCH, and STOCKHISTORY. Also included in this session are discussions of advanced financial functions, such as IPMT and PPMT, and how to retrieve summarized data easily using GETPIVOTDATA and CUBEVALUE. Additionally, you will learn how to make sophisticated calculations easier with Dynamic Array formulas, harness the AGGREGATE function's power, and create more accurate forecasts with Excel’s FORECAST.ETS function. No matter your experience working with Excel, participating in this course will help you work more efficiently and effectively in Excel.

In the ever-evolving world of data analytics and business intelligence, Microsoft Excel continues to be an indispensable tool for professionals across industries. With the introduction of Copilot, Microsoft has integrated the power of artificial intelligence directly into Excel, revolutionizing how users work with data. This 2-hour interactive course, Unlock the Power of AI with Copilot in Excel, provides a comprehensive overview of how Copilot transforms traditional Excel workflows into dynamic, AI-driven processes, enabling users to accomplish tasks faster, more accurately, and with less manual effort. During this course, you'll discover how Copilot leverages AI to enhance productivity and streamline operations. Whether you're a seasoned Excel user or just beginning your journey, this course will guide you through practical applications and best practices to make the most of Copilot's capabilities. Through hands-on demonstrations and real-world examples, you'll see how Copilot can save time, improve decision-making, and elevate your analytical skills to new heights. This course not only focuses on the technical aspects of Copilot but also highlights its potential to transform your day-to-day work, from automating repetitive tasks to uncovering trends and insights you might otherwise overlook. By the end of the session, you'll be equipped with the knowledge and confidence to integrate Copilot into your workflows and unlock its full potential in Microsoft Excel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This presentation will review what sex harassment is under the law, company compliance obligations, and describe how promoting a positive company culture can prevent sexual harassment in the workplace.   

Understanding how to effectively audit prepaid expenses is a key skill for audit staff. This course provides a comprehensive overview of the fundamentals, including the applicable audit assertions and common risks and threats associated with the prepaid expense balance. Participants will learn how to perform substantive auditing procedures to ensure accuracy and reliability, with guidance on applying these techniques to real-world scenarios. Designed to enhance practical knowledge, this session equips auditors with the tools and confidence needed to navigate prepaid expense audits with proficiency.

In today's world, AI hype bombards us from every direction. Every system seems to boast magical AI capabilities, leading to confusion and overwhelming information. This course cuts through the noise to reveal the true, practical applications of AI for your business today. Our goal is to give you real world examples of using AI on a day-to-day basis, with a clear understanding of its particular strengths and limitations.

This course equips tax professionals with the knowledge and strategies needed to handle the most common IRS letters, including general notices, audit requests, collections, return inquiries, and error notices. Participants will learn how to interpret IRS correspondence, adhere to response deadlines, and effectively communicate with the IRS to resolve issues and minimize risks. The session also highlights best practices for ensuring compliance and avoiding penalties or escalation, empowering attendees to navigate IRS correspondence with confidence. *Please Note:  If you need credit reported to the IRS for this IRS approved program, please download the IRS CE request form on the Course Materials Tab and submit to kori.herrera@acpen.com

An audit is an investment in reliable financial reporting and compliance, and an increased return on those dollars can be achieved by hiring the right auditors. This course will provide key factors for you to consider when evaluating whether you are getting the most quality and insight from your auditors, to enable them to perform the most value-added audit possible in the given circumstances - while retaining the trust of a CPA. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Charts and graphs are nothing new. However, many professionals struggle with building compelling visualizations. If that statement describes you, participate in this session to improve your skills in creating Excel charts and other visualizations. As a result, you will create visualizations to enhance your communication skills. This session is much more than just a seminar on fundamental charts. Instead, in this session, you will learn how to create advanced charts that are interactive, dynamic, and aesthetically pleasing – three qualities that will help to ensure that your readers and audience will understand the data you are presenting. This seminar is a must if you want to improve your communication skills.

Accounting and finance managers and executives must demonstrate sound soft skills necessary for personal growth and organizational success.  This course will provide insights into the most crtical  personal skills critical for CFOs and Controllers - or those that want to be!

The Accountant role is evolving from data aggregation to knowledge extraction, with a significant emphasis on understanding and leveraging technological advancements. In this era of rapid digital transformation, it is crucial for accountants to grasp the shift towards more analytical roles, learn the tools, and integrate Business Intelligence (BI) and Data Analytics (DA) in their organization and daily practices. This course will focus on raising the accountant's awareness of BI and DA practices, the impact of AI technologies like ChatGPT, and how these can benefit their organization. By embracing these technologies, accountants can enhance their value proposition by transitioning from traditional accounting roles to becoming strategic advisors and decision-makers.

This course examines the critical issues and special opportunities facing partnerships and their partners, as well as the relationship between limited liability companies and partnerships, with a focus on reporting tax basis capital accounts. **Please Note:  If you need credit reported to the IRS for this IRS approved program, please download the IRS CE request form on the Course Materials Tab and submit to kori.herrera@acpen.com.

Financial statements are a window into what is going on in the day-to-day operations of the company. They help us see what the company's strengths and weaknesses are. However, financial statements can often have different messages depending on the user. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

As the digital asset market continues to mature, more taxpayers may be contemplating blessing their favorite charitable organizations with gifts of cryptocurrency. Beneficiaries unfamiliar with digital assets may find it challenging to properly report any of these types of donations. Likewise, taxpayers will need to ensure that they properly value and substantiate any contributions or potentially risk their charitable deductions being denied. This course will provide a brief overview of digital assets. This will be followed by a discussion of the rules regarding the documentation required when claiming a charitable contribution of digital assets. This course will also cover recent IRS publications and cases discussing taxpayers whose deductions of digital assets charitable gifts was scrutinized. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This is a two-part series that discuss new trends and concepts the financial controller should begin to execute in order to truly become a valued member of the senior leadership team. The rapid pace of the evolving technological landscape has promoted changes in how accountants and financial professionals focus attention on strategy and modernize their roles to leverage digital technology. There is increased demand for enhancing flexibility into finance cycles and initiating real-time reporting and insights. These are the core attributes that will assist in transforming the work that controllership function performs. Is the financial controllership prepared to meet future business demands? The IMA® (Institute of Management Accountants) and Deloitte’s Center for Controllership aimed to better understand the current state of controllership and expectations of future demands for controllers and accounting professionals. They conducted a survey in late 2022 and identified several trends. The survey takes a look at how prepared controllership is to meet future business demands. It also highlights some insights for leaders to consider that may increase their preparedness. It also identified areas of additional insight and questions to answer on the controllership transformation journey. In this segment one, we go through numerous concepts in detail and the remaining concepts will be covered in segment two.

This course explores the increasingly complex features of Excel that facilitate efficient data analysis.  We will introduce numerous analytical methods and techniques by using practical examples to illustrate how to unleash the power of Excel when manipulating, analyzing and reporting information.

Overview of the most important labor and employment policies and practices that every business should have. The review will go over confidentiality agreements, arbitration agreements, restrictive covenants, training, and severance agreements, as well as compliance issues related to each of them.