CPE + Events Catalog

Do you love PivotTables? Of course, we all do! Traditional PivotTables are incredible, but they do have limitations. If you have ever encountered one of these limitations, you'll be excited to learn that by using the Data Model as the source for PivotTables, you'll be able to bypass many of the restrictions that exist with traditional PivotTables. The data model (also referred to as Power Pivot) is included in Excel 2016+ for Windows and available as a free download for previous versions (excluding Excel for Mac). Using the data model enables you to build PivotTables that were previously not practical. If you frequently build PivotTables and would like to do more with them, you'll want to understand how to use the data model (Power Pivot) to enhance your reports. Note about Excel versions: Power Pivot is not available in all versions of Excel, including Excel for Mac. If you would like to see if Power Pivot is available in your version of Excel, visit the Microsoft site.

Fraud is constantly in the news. Whether its employee retention credit mills, FTX, the City of Dixon, it appears like fraud is everywhere. We'll start this session with a review of the common fraud schemes as identified in the 2024 Report to the Nations. We'll also review the commonalities of fraudsters. We'll then look at methods of prevention. We'll close with a look at the auditor's responsibility for the consideration of fraud in AU-C 240.

This comprehensive case-driven training is designed to get the accountant up to speed quickly in the area of basis calculations and distribution planning for the owners of pass-thru entities (i.e., S corporations, partnerships, and limited liability companies (LLCs)). The cornerstone of this course is the line-by-line analysis of the Schedule K-1s and how it affects the basis calculations.  **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

One of the most significant challenges facing auditors is the prevalence of fraud that exists in today's business environment. All auditors should have a working knowledge of the requirements in professional literature regarding fraud. We will cover the issues that all auditors need to know about fraud and the people who commit fraud. This course will provide horror stories about frauds that have occurred and how they were detected. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Small businesses have better options now than ever before in the market of accounting solutions. Participate in this session to learn more about these options and which might be best for you or your clients.

This course will examine certain qualities a leader must exhibit to set an ethical tone from the top.

Join us for an in-depth webcast on Charitable Remainder Trusts (CRTs) and the essential aspects of preparing Form 5227.  This course will provide a comprehensive overview of CRTs, including their purpose, benefits, and practical considerations. Moreover, we will delve into the intricacies of Form 5227, the informational return for charitable remainder trusts, ensuring you have the necessary knowledge to accurately complete and file this crucial document. During this webcast, Art Werner will guide you through the fundamental concepts of Charitable Remainder Trusts, illustrating how they can be utilized as a strategic tool for tax planning. We will explore various types of CRTs, their formation, and the different scenarios in which they are most beneficial.  A significant portion of the webcast will be dedicated to Form 5227, the reporting requirement for charitable remainder trusts. We will provide an in-depth analysis of the form's components, line by line, ensuring you gain a comprehensive understanding of the information it requires. From trust assets and income to distributions and charitable beneficiaries, we will cover each section, discussing common pitfalls and best practices for accurate reporting. Mr. Werner will address the recent updates and changes to Form 5227, enabling you to stay up to date with the latest compliance requirements.

Adapting to the Engagement - Differentiating the Requirements of Preparations, Compilations, Reviews, and Audits is a critical foundational course. A CPA may perform various attest services under relevant professional standards, including compilations, reviews and audits. Reviews and audits are also considered assurance services, providing either limited or reasonable assurance that financial statements are free of material misstatement. In addition, the CPA may perform non-attest services, such as bookkeeping or preparation of financial statements. CPAs must fully understand the professional responsibilities related to each of these varying levels of services, in order to effectively and efficiently satisfy engagement objectives. Note: This course is recommended as a part of a 16-hour audit skills curriculum for beginning auditors and attest providers, while it is also appropriate for anyone who has assurance responsibilities under the SSARS. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Today, financial planning is very different from the profession and advice of the past. To put it into perspective from a prior TV commercial, "This is not your father's Oldsmobile!". Our world is changing rapidly. Employment shifts, everyday living and priorities in the post-COVID era are now part of the new norm. Our clients need to adjust to an ever-changing environment! Add to those other unanticipated events that we need to figure out "the secrets" of how to maintain our edge in the future on the advice we render, and this process becomes a game-changer. This is no small task or straight shot for ourselves or our clients. As a result, immediate changes must be made to our practice and involvement with our clients to manage the new norm. You'll learn the "Rattiner's Secrets of Financial Planning," as discussed in Jeff's latest book from Wiley, in which he will cover what you need to know to reach your ultimate success! The focus will capture the running of your planning practice to optimize your client's experiences to dispense appropriate financial planning advice.

This course covers recently issued accounting and financial statement reporting standards from the Financial Accounting Standards Board. Key implementation challenges and experiences from public company filings will be identified. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This two-part interactive workshop reviews the hottest accounting topics and recent changes in areas such as private company accounting, revenue recognition, going concern and other specialized subjects. Refresh research skills and practice using codification. Case studies and real-life examples will help attendees readily apply the information covered. This course is one of two parts of Financial Accounting Standards: A Comprehensive Review. Please be sure to also register for Part 2.

Retirement accounts may be the largest financial asset your client has. Learn to provide valuable retirement planning input rather than mere RMD calculations. Congress has been changing things: witness Secure and Secure 2.0. Beneficiary rules changed in 2019. Improper choices and faulty distribution calculations can result in penalties or unnecessary taxes. Retirement benefits will be paid to beneficiaries much earlier than was required for pre-2020 deaths. Plans may require an overhaul based on recent legislative changes and IRS interpretations. Course materials contain regulations governing plan distributions and copies of appropriate IRS forms and rulings, updated with the latest cases, rulings, regulations and legislation.

Taxation specific to the real estate industry is awash with special tax laws that are complex and associated with the real estate industry. The current tax laws and regulations may determine profitability when acquiring and disposing of real property. Special tax laws have been promulgated to mitigate the tax burdens, which in turn may determine returns on investment in real property. Historically, the partnership and, more recently, the limited liability company entities are the most commonly used forms of ownership when acquiring or constructing real property. The seminar explores how partnership taxation using either type of entity applies in many areas of the real estate industry.

Disclosure has never been more critical. This course covers the most commonly encountered U.S. GAAP disclosure requirements. The course is an Update of the structure of the FASB Accounting Standards Codification and its more significant disclosure requirements applicable to non-public entities. In addition to U.S. GAAP, the course includes discussion of disclosure requirements for financial statements prepared using a special purpose framework, e.g., tax basis.

Leading change now ranks in the top three leader skills of the future. As audit, risk management, and governance are relied on more and more in organizational decision-making, the need to lead change is paramount. Leaders and practitioners at all levels must oversee or manage change in today's environment. Whether you are a CEO, small business owner, or individual practitioner, you lead change in your environment. In this session, learn how to lead change BETTER because everyone is a leader of someone. Build alignment with those you lead and work with, motivate and inspire, and model the behaviors that drive change. This session breaks down strategies into manageable steps that anyone can cultivate. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This seminar reviews situations in which a CPA or accounting professional may be in danger of being sued. We cover common law causes of action, such as negligence, and the relevant standards and case law defining what constitutes reasonable practitioner behavior. This course is ideal for lawyers, CPAs, EAs, tax preparers, accountants and insurance personnel. 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 provides an in-depth exploration of Form 1120S, the tax return form used by S corporations. Students will learn the intricacies of preparing and analyzing this form, including how to determine the taxable income of the S corporation, how to properly report and allocate income, deductions, and credits, and how to calculate the shareholder's basis in the S corporation. **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.

Join us for a discussion on what has changed in 2024 for the CTA. This course covers the latest on the Corporate Transparency Act (CTA). We will discuss the new filing timelines, including the recent extension, and will make sense of the broadened definition of "beneficial owner". We will also discuss the ruling in Alabama that has changed things. By the end of this, you’ll have the know-how to craft solid compliance plans that don't just check boxes but work seamlessly in the real world. Expect to leave armed with concrete tips for keeping your clients while staying away from any fines. Make sure you are up to date with the newest financial regulations. **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.

This course explores the FASB codification provisions and AICPA financial reporting framework for transaction with related parties, including business owners and special purpose entities. Real-life examples are used to illustrate the various authoritative standards and discuss the consequences of failing to comply. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This updated course offers an in-depth look at the FASB leases standard (ASC 842), which requires organizations to recognize lease assets and liabilities on the balance sheet. This comprehensive course will cover recognition, measurement, presentation, and disclosure requirements, while also focusing on a critical area of change which is the proper identification of a lease using a principles-based approach. We will discuss implementation requirements from both the lessee and lessor accounting models.  In addition, we explore a variety of scenarios, including short-term leases, purchase options, variable lease payments, and remeasurement. This course offers practical journal entry examples, lessons learned from implementation, and explores recently issued amendments to the lease accounting guidance.