CPE + Events Catalog

This course dives into the powerful, but potentially under-utilized, capabilities of Microsoft Excel. Designed for sophisticated users willing to approach spreadsheets from a unique perspective, this program encourages users to challenge the status quo by considering opportunities to take acceptable spreadsheets to a new level. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

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.

Do you ever get blank looks when you present your company's financial statements?  Does your board nod knowingly, during your presentation, but never seem to have any meaningful questions?  It could be that they have no idea what you are talking about and are just pretending to understand!  Learn how to connect with your CEO, board, fellow managers, and ordinary employees so they understand your message.

This course will address the most recent tax legislation, IRS guidance and developments occurring in 2024-25 that will impact business taxpayers. Designed to prepare the practitioner for the upcoming filing season, this course will provide useful strategies to assist in the tax preparation process. **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.  

Mergers, acquisitions and alliances have been and continue to be major avenues to organizational growth and increased competitive advantage. Despite the great initial promise of many mergers and alliances, few seem to yield the anticipated results. Numerous studies indicate that between 55% and 77% of mergers fail to accomplish their intended purpose. This course helps financial professionals, and their advisors identify, execute, and consummate mergers and acquisitions that create shareholder value while avoiding the many traps that can cause post-acquisition failure.

Clients often ask their tax advisors whether they have the "best" pension plan and whether they are using it to its maximum advantage. This program explains how various pension plans work and analyzes why a small or medium-sized business owner would choose one plan over another. 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.

How debt is allocated to the partners in a partnership is important. It dictates how much money may be taken tax-free as a distribution, the losses that flow down to the partners, and the gain or loss on the sale of a partnership interest. However, the allocation of debt can differ depending on the type of debt it is and the type of partner we are talking about. Furthermore, 704(c) can complicate things. And what in the world is a constructive liquidation scenario? In this course, we will tackle the concept of debt allocations - how you do it, what it means, and why you do it. 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.

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!

When forensic accountants are hired to conduct an analysis and investigations, they are commonly expected to write a report. This report can be short or long, depending on the circumstances. This presentation is how to write an effective expert report that will withstand scrutiny of both parties of litigation and the court. The presentation will also include best practices, ethics, and components of an effective report. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Fraud has not been conquered.  Although most organizations like to think, “it can’t happen to us,” the fact of the matter is that fraud can happen to any organization and its impact can be catastrophic.  Accountability professionals are the first line of defense against fraud. When fraud happens, management always turns to the accountability professional and either says (a) “this must be your fault,” or (b) “you were right; you warned us; help us make sure this cannot happen again.” Consequently, accountants, internal auditors, external auditors, fraud examiners, and risk management professionals need to develop the skills needed to prevent, detect, and deter fraud and need to be proactive in promoting and effecting organizational change. According to the Association of Certified Fraud Examiners’ (ACFE) 2024 Report to the Nations: The median loss per fraud case is $145,000; the average loss per fraud case is $1.7 million. 43% of frauds are discovered by tips, usually from employees. Asset misappropriation schemes are the most common (89%) but least costly ($120,000 median loss). Financial statement fraud schemes are the least common (5%) but most costly ($766,000 median loss). Corruption is the most common scheme in all global regions. Median losses for frauds by owners/executives ($459,000) were more than 7X GREATER than those carried out by employees ($60,000). 84% of fraudsters exhibited at least one behavioral red flag. Organizations that have implemented anti-fraud measures suffer significantly lower losses and find fraud much more quickly. These conclusions are alarming and should be a wake-up call for all business and government professionals. The impact of fraud is always devastating and can be catastrophic.  The 2025 Business Fraud Update is another fast-moving seminar that will provide a comprehensive look at the latest developments about fraud from the technical, legal, and operational perspectives and update participants on the most recent legal and regulatory developments in this important area of professional responsibility.   In addition, our panel of legal, accountability, and forensic experts will explain key steps and methods in conducting a successful fraud investigation: Establishing predicate for an investigation Gathering and preserving evidence Conducting interviews and obtaining confessions When to involve law enforcement professionals and regulators The CPA's Role Preparing an expert report Providing expert testimony Implementing corrective action plans

This comprehensive course covers the most common aspects and tax implications of S Corporations, providing a deep dive into their structure, tax treatment, and compliance requirements. Participants will learn the mechanics of electing Subchapter S status, with discussions on Form 2553 and relief options for late filings. The course also explores the application of Rev. Proc. 2022-19 and Rev. Proc. 2023-3, analyzing their differences and implications under I.R.C. §1361 and §1362. Key topics include corporate formalities, shareholder stock and debt basis, and highlights of Form 1120S and its schedules (K-1, K-2, and K-3). Additionally, participants will gain insights into officer reasonable compensation requirements, audit strategies, and corrective measures for eligibility errors. *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 year practitioners need to keep abreast of tax changes affecting pass-through entities used by their business clients and employers, and this enlightening course delivers that information. You will learn invaluable strategies, techniques, innovative tax-planning concepts, income-generating ideas, and other planning opportunities available to S corporations, partnerships, LLCs, and LLPs. In addition, this course will discuss current trends and emerging issues, helping practitioners stay informed about relevant and significant topics that may impact their clients. Continually updated to reflect enacted legislation. 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.

The Secure Act 2.0 was passed in a flurry of year-end legislation. This one hour program will cover the important changes that individuals need to know about contributions to accounts and new ways of accessing these funds.  This course will provide a concise look at these hot topics.   **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.

It is imperative for public companies to produce quality financial reporting. This course will share insights into the latest SEC and PCAOB areas of emphasis and concern. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Bitcoin and crypto have been in the news recently for a variety of reasons. This course will cover the basics of accounting and auditing for cryptocurrency, including recent standard setting by the FASB as well as a look at the AICPA's Accounting for and Auditing of Digital Assets practice aid.

In this course, participants will learn about key trends and innovations impacting the field of forensic data analytics.  From generative AI to ChatGPT, machine learning and transaction review, data sharing consortiums and cryptocurrency trends, this course is for the futurist who wants to be leading edge in compliance and anti-fraud technology innovation. 

This course addresses the most recent legislative developments impacting individual taxpayers, with a focus on important provisions, rules and concepts to apply when preparing client returns.  **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.  

Manage distractions, decrease stress and improve productivity. This training is designed to help business professionals improve their productivity and work performance by learning how to prioritize time, decrease distractions and lower stress. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Financial accounting for trusts and estates is one of the least understood branches of accounting. It is not particularly concerned with recording income and expenses but is obsessed with determining whether receipts and expenditures are assigned to income or principal/corpus. This course will dive into this tricky area and provide a reporting guide for fiduciary accounting.

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