CPE + Events Catalog

Unlock the full potential of Microsoft Excel PivotTables with this comprehensive course. This training is designed to equip participants with the skills to effectively analyze and summarize data, transforming raw numbers into actionable insights. Whether you're a seasoned professional or new to data analysis, this course provides an in-depth understanding of PivotTables and their capabilities, helping you uncover patterns, compare data, and make informed decisions. The program includes a step-by-step approach to creating and customizing PivotTables, focusing on how to use them to analyze data efficiently. Participants will learn how to group and filter data, identify trends, and apply advanced features to solve real-world business challenges. Beyond technical knowledge, this course introduces data visualization through PivotCharts, teaching participants how to present their analysis effectively to stakeholders. By the end of the course, you'll not only master PivotTable fundamentals but also gain advanced techniques to streamline data analysis and support strategic decision-making in any context. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This program addresses the critical issues and special opportunities facing S-corporations, with a focus on reporting shareholder basis and distributions. **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 comprehensive 8-hour course explores the pervasive issue of fraud in State and Local governments. Our panel of experts from inside and outside government will provide participants with the tools and knowledge necessary to identify, prevent, and respond to fraudulent activities in State and local governments. The course begins by examining the types of fraud commonly encountered in governmental settings, including financial fraud, procurement fraud, and abuse of power. With our experienced panelists, participants will delve into real-world case studies to understand the tactics used by fraudsters and the impact on public trust, resources, and governance. Special emphasis will be placed on understanding regulatory frameworks and compliance measures designed to mitigate fraud risks.    

Explore the ethical principles included in the Code of Professional Conduct that address the emerging practice issues created by new technologies. Consider how technologies may impact audit quality and the integrity of the financial systems, and whether they create a need for CPAs to adjust their skill sets to address those challenges. Look at the potential ethical challenges created by the data related to privacy, security, and its application. Discuss the changes being proposed to address emerging ethics challenges. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

When do they exist and how to report them? This program will provide a detailed analysis of the real estate professional passive activity rules, including forms reporting examples, and integrates those rules with when real estate is considered a "business" under the Section 199A flow-through entity deduction.  *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

New pronouncements from ASB are covered so you can be up to date on ASB activities and understand how to apply the guidance.

Discover how Microsoft 365 Copilot can revolutionize your daily tasks as a CPA. Dive into the specific features and functionalities of this AI-powered assistant. Learn how to leverage Copilot to enhance productivity, automate routine tasks, and improve collaboration within your team. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Transitioning from quality control (QC) standards to quality management (QM) standards. This webcast will focus on peer reviews, covering the changes from QC to QM standards and how to implement them. Peer reviews are critical to QM compliance, allowing for independent evaluation and improvement of QM systems. You can gain insights on: Preparing for peer review Understanding expectations Responding to feedback The subject matter expert will address common peer review findings and offer strategies for continuously improving QM practices based on the peer review results. You will gain the confidence and resources needed to conduct and respond to peer reviews effectively, reinforcing the firm's commitment to quality.

The Professional Ethics Executive Committee (PEEC) of the AICPA has been very busy issuing new and updating existing ethics rules. This course will provide an overview of recently issued and soon to be effective ethics rules that CPAs in both industry and public accounting need to know to be compliant. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

What is a digital asset and how does US GAAP apply? This webcast will provide you with an understanding of how to account for investments in, or transactions involving, crypto assets (for example, bitcoin) and other digital assets under US GA Note: FASB issued ASU No. 2023-08, Intangibles-Goodwill and Other-Crypto Assets (Subtopic 350-60): Accounting for and Disclosure of Crypto Assets, which is effective for all entities for fiscal years beginning after December 15, 2024. This ASU is not yet reflected in this webcast.

Organizations and individuals enticed by the siren song of artificial intelligence cannot ignore ethical considerations. Professionals must consider accuracy of information, data privacy, independence, source citations, organizational policies, security, data retention, and other ethical matters. This course discusses ethical issues associated with the utilization of AI in a professional setting and provides suggested best practices. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Since the early 2000s, the estate tax burden on taxpayers has gradually decreased along with the number of practitioners specializing in the field. Nevertheless, some of your most wealthy clients will owe estate tax and this issue will eventually be thrust upon you. Finding an affordable, competent specialist who you trust to work with you and your client may be difficult. Learning the basics of the tax and how to complete the form will give you confidence to help your clients navigate that difficult time. NOTE: This course qualifies for IRS CE (PTIN) credit. To receive IRS CE credit, please email your PTIN to profdev@orcpa.org at the end of the course. Surgent will report credit at the end of each quarter.If you have questions, you can contact Professional Development at 503-641-7200, ext. 3 or email profdev@orcpa.org.

This course will provide an overview of 6 key areas of automation that accounting firms can leverage to effectively increase their lead generation and client retention efforts while reducing the burden on their time and budget. These areas include: 1. Social media 2. Content development. 3. Email marketing. 4. Text (SMS) marketing. 5. Chatbots and other interactive AI tools. 6. Drip marketing campaigns. Attendees will receive a practical guide to the technologies and tactics needed to improve marketing efforts with efficiency and ease! 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 focuses on the key federal tax issues affecting businesses from the internal accountant's point of view, with a focus on recent tax legislation and developments.  Planning alternatives and the potential risks associated with those strategies will also be discussed.  **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 statement audits often involve audits of components of a larger entity. This course will focus on the responsibilities for both the group auditor and component auditor, including implementation of SAS No. 149 relate to group audits.

Whether a financial statement preparer or user is more familiar with IFRS or U.S. GAAP, it is important to be familiar with the important differences between the two financial reporting frameworks. This course will highlight some of the more significant differences between the standards.

A detailed analysis of the calculations related to determining a shareholder's tax basis for S corporation shares and loans, with a focus on how to use Form 1120S, Schedule K-1 information for basis determination. An illustrative example demonstrates how the process works, as well as the many potential pitfalls. *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 is a dynamic course tailored for seasoned accountants who are looking to elevate their skills in navigating and leading through organizational change. This advanced program focuses on enhancing agility by providing the tools and techniques necessary to manage and adapt to rapid shifts in the accounting landscape. Participants will explore theoretical frameworks alongside practical strategies that support effective change management for diverse business environments.

The practical application of artificial intelligence (AI) in the accounting profession is spreading like wildfire with the release of powerful applications such as ChatGPT. A byproduct of this evolution is the origination of new ethical dilemmas for CPAs on how to address the use of this technology in the delivery of their services. This course, presented by John Higgins, CPA, a nationally recognized technology advisor to the profession, will provide CPAs with a practical framework for addressing the various ethical issues that can arise with the application of AI in their work. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Explore the transformative impact of technology on the audit profession in this forward-looking course. Gain practical insights into cutting-edge tools and trends, including data analytics, artificial intelligence (AI), and automation, and discover how these advancements are revolutionizing audit methodologies and improving audit quality. Through engaging demos, case studies, and actionable tips, you'll learn how to navigate the evolving audit landscape with confidence and adaptability. This session is designed to equip CPAs with the knowledge to embrace innovation and stay ahead in a rapidly changing profession.