CPE + Events Catalog

This course is designed for firm partners and managers to explore ways to incorporate data analytics and related technologies in their audit practices. Participants explore how small and mid-size firms are using these tools to improve engagement efficiency and quality while providing opportunities for value-added services to clients. All of AHI's multi-day courses rely on live participant engagement. For this 2-hr. course, we encourage you to have a working webcam and microphone to take advantage of a live discussion leader and participant interaction.

New features in Excel provide tremendous opportunities to improve Excel-based operational and financial reports. For example, Data Models, Power Query, Data Analysis Expressions, Power Pivot, and many others can help you create more powerful summaries and schedules in less time than ever. Bundle these tools with some of Excel's "legacy" features, and you have significant new opportunities to improve your Excel-based reporting environments. In this fast-paced seminar, you will learn about the importance of using Power Query to link data into Excel data models and how you can manage these data models to facilitate better and more efficient reporting. Additionally, you will learn how to incorporate Key Performance Indicators, Slicers, and Timelines into your reports to enhance the analytics and understandability of the data. Further, you will learn best practices to format your spreadsheets quickly and efficiently to give them a polished and professional appearance. This course should be at the top of your professional development list if you use Excel for any reporting process.

Navigating Washington’s unique Business & Occupation (B&O) Tax and Sales Tax can be complex, especially when it comes to investment income. This session will provide a deep dive into Washington’s tax structure, key compliance considerations, and strategies to manage tax liabilities effectively. Gain insights into taxability of investment income, exemptions, deductions, and audit risks to ensure your clients remain compliant while optimizing tax outcomes. Whether you work with corporations, pass-through entities, or individuals, this session will equip you with the knowledge to tackle Washington’s tax challenges with confidence!

In today's world of everchanging demands and dynamics of the workplace, it is imperative that we use a tool to help us bring balance, strength, and stability in all we do at work and at home. Mindfulness is an easy and effective tool to help us with this. The Mindful-CPA program via this webinar is designed specifically for Finance and Accounting Professionals. You will learn: The fundamental principles of Mindfulness An 8-minute Mindfulness Practice to be done daily Creative and fun ways to apply Mindfulness to work activities Effective overall strategies to bring creativity, balance, and energy to daily activities. Sunish Mehta, CPA has been a practitioner and instructor of Mindfulness for over 20 years and has worked with several Mindfulness Organizations to date. Having studied with some of the top Mindfulness Teachers in the world including His Holiness The Dalai Lama, Sunish has integrated mindfulness into his learning and consulting work with the focused goal to help conscious professionals bring focus, creativity, and balance to their professional and personal lives. You can learn more at www.mindful-cpa.com.

QuickBooks Online's (QBO) market share continues to expand, and the Cloud-based accounting platform now dominates the small business market. Yet, most accounting and financial professionals have not participated in any formal training on the Cloud-based accounting service. Thus, they are unaware of many of the tool's available features and do not work with QuickBooks Online as efficiently and effectively as they should. This course teaches you how to set up QBO and convert QuickBooks Desktop files into a QBO instance. You will learn how to process all types of transactions, including accounts payable, accounts receivable, bank feeds, inventory, and payroll. Further, you will learn how to implement appropriate internal controls and how to capitalize on advanced features such as workflow management and management reports. Join us in this session to learn how to set up QBO properly and take full advantage of all it offers while avoiding common errors and mistakes.

Explore the ethical implications of using generative AI. This course addresses potential risks and dilemmas, providing guidelines to ensure responsible and compliant integration. Learn how to balance innovation with ethical obligations to maintain trust and integrity. This course is one of a four-part series on AI technology for CPAs. We recommend you attend all four presentations to develop a complete understanding of AI and its potential in accounting, tax and finance. This course is one of a four-part series on AI technology for CPAs. We recommend you attend all four presentations to develop a complete understanding of AI and its potential in accounting, tax and finance.

Dive into the essentials of IRAs with this course. We'll go well beyond the basics to cover crucial topics: when to convert traditional IRAs to Roth IRAs, how to minimize tax on conversion, and when clients should recharacterize IRA contributions (and how to recharacterize). We'll also discuss how to get waivers for clients who fail to take required minimum distributions and other traps in the IRA area including prohibited transactions, excess contributions, and impermissible investments.OSCPA has partnered with the Washington Society of CPAs for this event.

Tax advisors often receive questions concerning all facets of Medicare. How does Medicare work? How do I apply? How much does it cost? Is Medicare optional or required? This program provides a basic introduction to the Medicare program and covers many of the areas of the Medicare program that clients are most interested in. If you, or some of your clients, have questions relating to Medicare, this program is a must for you.OSCPA has partnered with the Washington Society of CPAs for this event.

Stay in the know with this monthly tax update series, featuring Ed Zollars, CPA. Each month, Ed breaks down a different federal tax topic so you can stay on top of the changes and provide optimal service to your clients.OSCPA has partnered with the Idaho Society of CPAs for this event.

Many business professionals consider PivotTables the most powerful feature in Excel, yet most accounting and financial professionals do not use them in their day-to-day activities. If you are ready to learn how to take advantage of PivotTables or extend your existing knowledge of PivotTables, then plan to participate in this course. You will learn how to build PivotTables, group data inside PivotTables - including grouping options for fiscal periods - and create user-defined calculations in your PivotTables. You will also learn advanced PivotTable techniques, including building PivotTables that consolidate data from multiple data ranges and PivotTables that connect dynamically to external databases and financial accounting systems. Additionally, you will learn to take advantage of other Excel features associated with PivotTables, including Slicers, Power Query, and Power Pivot. You will be a master of Excel PivotTables at the end of the day! This course is for you if you have been leery of working with PivotTables or have struggled to realize their many benefits. With some information, guidance, and coaching from your K2 instructor, you will be ready to use PivotTables to analyze and report on extensive data sets in a fraction of the time you spend completing such tasks.

Discover the real-world power of Artificial Intelligence (AI) and equip yourself with the skills to conquer modern challenges in accounting and finance. In this engaging course, we demystify AI and unveil its practical applications, transforming it from theory into a hands-on tool. Learn the essential AI fundamentals and unlock its remarkable potential to boost your productivity and effectiveness alongside your team. Explore the specific problem-solving capabilities of AI, tailored to address the unique challenges faced by accounting and financial professionals. Gain expertise in leveraging AI features integrated into everyday applications, including the ubiquitous Excel. Uncover how these features enable you to effortlessly detect fraud, identify potential transaction errors, and elevate your financial operations to new heights. Witness firsthand how AI is reshaping the present and future of your profession, positioning you at the forefront of this revolutionary wave.

With the explosion of technology over the past thirty years, one fair question is, "what are the ethical considerations and impacts related to this technology?" Of course, practical technology issues such as data privacy and security undoubtedly carry ethical considerations. However, technology also affects the ethics associated with work-life balance, the digital divide, training needs, copyrights, and fraud, to name a few. This course will teach you about "techno ethics" and its implications for individuals and organizations. To that end, you will explore many current and emerging issues associated with ethics and technology, such as copyrights, cybercrimes, privacy versus security, and geo-tracking technologies. Given the profound implications of ethics and technology, this could be the most impactful session in which you will ever participate.

Part one of a five-course series, address common issues new staff members face. Focus on strategies to improve efficiency and quality control, build technical skills, and make valuable contributions to a company. Dive into the fundamentals: workpaper techniques, analytical procedures, compilation and review services, tax recognition and research techniques, understanding audit objectives, and auditing and reviewing selected accounts. Per NASBA's rules effective January 1, 2024, participants are required to be on camera and participate in the full and small group discussions to earn CPE credits for this Group Live - Virtual course. As such, please make sure you are set up properly with reliable internet (hard wired is best), a working camera, and a working microphone.

As tax laws continue to evolve, CPAs need to stay informed and proactive. The OSCPA's State & Local Tax Conference delivers the latest on legislative updates, case law, and compliance strategies for accounting professionals. Gain actionable insights from leading tax experts and build a network of peers facing similar challenges. Ensure your clients' success by mastering the complexities of state and local taxes. CLE-OR: Pending ApprovalCFP: Pending Approval A special thanks to the members of the State & Local Taxation Project Committee for developing the 2026 State & Local Tax Conference.

As tax laws continue to evolve, CPAs need to stay informed and proactive. The OSCPA's State & Local Tax Conference delivers the latest on legislative updates, case law, and compliance strategies for accounting professionals. Gain actionable insights from leading tax experts and build a network of peers facing similar challenges. Ensure your clients' success by mastering the complexities of state and local taxes. CLE-OR: Pending ApprovalCFP: Pending Approval A special thanks to the members of the State & Local Taxation Project Committee for developing the 2026 State & Local Tax Conference.

This 2-hour mini course highlights leadership skills and situations that are common for managers. Participants will be encouraged to examine and challenge their beliefs and approaches to managing and leading people. Leading Others - Coaching & Developing Staff - prioritizing the coaching and development of staff in a post-pandemic work environment, including delegation for development, effective feedback, and managing virtual employees. Building Leadership Communication Skills - strategies to influence and lead others through effective communication in both individual and group settings. All of AHI's multi-day courses rely on live participant engagement. For this 2-hr. course, we encourage you to have a working webcam and microphone to take advantage of a live discussion leader and participant interaction.

Most review techniques developed by professionals are self-taught and fine-tuned via experience. Yet how does one start? The purpose of this course is to give both new and seasoned reviewers additional and advanced procedures via a multitude of checklists to more thoroughly review S corporation and partnership tax returns. Its emphasis is not planning; rather, it is to develop a strategy to properly review a return effectively and thoroughly. The course includes dozens of "practice tips for new reviewers" and is updated for impacts of newly 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.

There have been several changes in Oregon law, as well as changes in the federal law that impact estate planning in Oregon. The speakers will unwind the complicated changes in the law and address the nuances that affect proper planning for Oregon clients and their families.

Completion of this course is required for admission to the Oregon Municipal Roster. This program is offered twice a year. Plan early to meet your requirement! This course may be appropriate to meet the biennial CPE requirements to continue on the Municipal Roster. YELLOW BOOK: Qualifies for Yellow Book CPE based on your unique audited entity.

This course introduces how data analytics can be used to improve engagement quality and efficiency. Participants explore the use of data analytics to assess risk, support financial statement assertions, assess internal controls and uncover fraud. Apply the ADA IDEASc approach to using data analytics on engagements to ensure compliance with audit and review standards and to provide value-added services to clients. All of AHI's multi-day courses rely on live participant engagement. For this 2-hr. course, we encourage you to have a working webcam and microphone to take advantage of a live discussion leader and participant interaction.