CPE + Events Catalog

A Deep Dive into State and Local Tax TopicsUnlock the secrets of effective state and local tax strategies with our comprehensive SALT Mastery Series! Elevate your expertise, stay ahead of legislative changes, and gain practical insights tailored for tax professionals. Join us for an in-depth exploration of advanced techniques, guided by industry-leading experts. Don’t miss this opportunity to master the complexities of SALT and transform your tax practices. Sign up today and take the first step towards becoming a SALT expert! There are 10 courses in the bundle. Each course is a stand-alone topic. If you miss one in the series, no worries! Purchase individual courses or purchase the SALT Mastery Series bundle and save up to $140!

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.

More Dates

All the ethics you need to know! Award winning and entertaining discussion leader Mark Hugh will review the AICPA Code of Professional Conduct and key Oregon differences; discuss new developments at the national and state level in ethics in the last two years; best practices for CPAs in public accounting and industry; highlight emerging issues; and discuss Oregon administration and enforcement, including examples of recent disciplinary actions.NOTE: This course meets the Oregon Board of Accountancy's biennial four-hour ethics requirement.For the most current Oregon Administrative Rules (OARs), refer to the BOA website: https://tinyurl.com/OR-BOA-Rules.

More Dates

Required minimum distributions (RMDs) from employer retirement plans and IRAs must be made or steep penalties will be incurred. Planning opportunities exist in certain situations to minimize distributions. Also, special rules exist for inherited retirement funds. Your clients depend on you to help them navigate the rules regarding required minimum distributions and the taxation of distributions. This course addresses compliance issues and planning opportunities regarding required minimum distributions.

More Dates

Artificial Intelligence (AI) and automation tools offer incredible opportunities for all business professionals to improve productivity and accuracy. For example, generative AI tools such as ChatGPT and Bard can be beneficial when conducting research or drafting reports and correspondence. Likewise, Microsoft's Power Automate platform and similar tools such as Zapier can help you elevate efficiency to levels you may have thought unattainable. If this sounds appealing, plan to participate in this session to modernize your workflows and take advantage of these tools. This session will teach you practical applications of today's AI and automation tools. Moving beyond fundamental discussions, you will learn how to use AI and automation to streamline workflows, improve internal control, maximize productivity, and even improve team member morale. In addition, you will learn about some potential pitfalls associated with these technologies and how to avoid making mistakes when using these tools. In sum, this session is "must-see CPE," and you should plan to participate in this class today.

More Dates

This intermediate half-day Oregon and State & Local Taxation program is authored and instructed by Kimberly Lohr, Principal, Delap LLP, Lake Oswego, who is recognized for her extensive national expertise and instruction skills in this arena. You will obtain a brief overview of the basics followed by an intermediate dive into a variety of pertinent topics. Learn about economic nexus issues, nexus study/voluntary disclosure as well as pass-through ownership & nexus. The U.S. Supreme Court nexus decision in Wayfair will also be addressed. Additionally, you will learn about Public Law 86-272, cloud computing, reporting an RAR, IRS & state communications, unclaimed property, state updates, City of Portland, Multnomah County & Metro and Oregon, California, and Washington.

Learn about a variety of current issues that are impacting the forest products industry.

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.

More Dates

The QuickBooks platform is robust with features and capabilities that many users are unaware of or do not know how to utilize effectively. This course helps you get more out of QuickBooks Desktop and QuickBooks Online and resolve the issues even experienced QuickBooks users struggle with, such as locking down prior periods. This program starts fast with a chapter covering the top issues accountants face with QuickBooks. Then, the day continues with practical guidance and solutions designed to help accountants get the most out of QuickBooks for themselves or their clients. You will learn about issues like setting up a new company, configuring and customizing QuickBooks preferences, and enabling system security and password protection features. Also, you will learn how to lock down transactions in prior periods, use the audit trail, customize reports, export reports to Excel, and extend QuickBooks' usefulness with tools such as the Fixed Asset Manager and Loan Manager.

More Dates

This course includes an analysis of all the relevant authoritative pronouncements that a CPA must understand in order to properly perform preparation, compilation and review engagements. Troublesome areas as identified in peer reviews and litigation will be addressed. Participants who take this course will enjoy a smooth sailing in their peer reviews guaranteed! The new Quality Management Standards that replace the Quality Control Standards will be discussed! Don't miss this chance to elevate your skills and stay ahead of the curve. Walter Haig's Preparation, Compilation, and Review Standards Update is not just an event; it's an investment in your professional success!

In the world of "Big Data," virtually all business professionals have become data analysts, at least to some extent. However, that is particularly true in auditing, where internal and external auditors increasingly turn to data analytics to identify situations requiring follow-up and investigation. Those who understand how to use various tools to assist in these efforts benefit by conducting more thorough analyses and achieving superior results in less time. In this session, you will learn about various tools and techniques you can use for more thorough data analyses. The discussion includes Excel as a data analysis tool, multiple Excel add-ins, and Microsoft's Power BI application. If you're seeking to improve your skills in the field of data analytics, this session is the one for you!

"C the B A D D O G" is a handy phrase used to remember the SIX most common 990 Schedules - A, B, C, D and G, along with the key governance and policy asks (with required narrations) appearing upon the always-mandatory Schedule O. This class covers the big three of these six - Schedule A (required of all 501(c)(3) organizations); Schedule B (required for many (c)(3)s as well as certain non-(c)(3)s); and the key and most troublesome lines of Schedule O. The approach to all three is designed to: (1) demystify the Schedule A overall and then demystify the application of the two public support tests); (2) address common misconceptions concerning the Schedule B's reporting of donors; and (3) highlight the reach and underlying disclosure obligations behind Schedule O's most sensitive lines. OSCPA has partnered with the Minnesota Society of CPAs for this event.

More Dates

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.

More Dates

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.

How good are you with the technology you use daily? Are new technology tools available to save time and make you more effective? Technology continues to accelerate rapidly, and keeping pace is essential. This course is for you if you are not an information technology (IT) expert but need a technology update to maintain and improve your skills to serve your companies or clients more efficiently and effectively! In this fast-paced, update-style course, you will survey today's IT environment, learning about computer hardware, software (including Microsoft Office), operating systems (including Windows 11), peripheral devices, and what they mean for you. You will also learn about significant trends in information technology and how to take advantage of the opportunities presented by these trends. Examples include the latest Excel features, best practices for working with PDF files, and security and privacy issues. Additionally, you will learn how to improve the overall performance of your IT investment, thereby increasing your return on investment. Throughout this program, you will learn from real-time demonstrations of practical applications of the latest tools, which can provide you with the knowledge you need to harness the power of technology, both now and in the future. So register now for this "don't miss" opportunity to get the skills required to enhance the value of your IT investment.

More Dates

The Tax Cuts and Jobs act extension passed in the House and has moved to the Senate. It’s been 8 years since we’ve seen tax legislation this important. Join Greg and George as they move through the Act and likely changes in the Senate. They will cover both its provisions and planning strategies, including:  The state and local tax itemized deduction has been increased.  There are a couple of twists, we’ll cover them. Who will benefit and who won’t.  Section 199A QBID deductions. What changed and how to plan for it.  Bonus depreciation. The Act makes a retroactive change to bonus depreciation.  We’ll discuss the effective date and planning ideas.  Excess business losses. Restrictions on deducting the pass-through-entity tax (“PTET”). Permanent extensions of individual tax rates. Increases to the standard deduction and a new phase-out for itemized deductions. Changes to the deductibility of employer-provided meals.  Estate tax changes and gifting opportunities. Repeal of the clean vehicle credit. And how to get it before it’s gone. 

Microsoft 365/Office 365 continues to grow and evolve, yet most utilize only a fraction of the tools available in their subscription. For example, powerful resources such as SharePoint Online and audio and video conferencing can change how your organization communicates and collaborates. In contrast, more personal apps such as Teams, Planner, Flow, and Sway allow individuals to work more efficiently and effectively in virtually all facets of their jobs. Further, security enhancements to Office 365 mean that your organization can take advantage of all these features in a highly secure environment. Isn't it time you learned how to move beyond the traditional Microsoft 365/Office 365 applications such as Excel, Word, and Outlook and unleash all your subscription offers? Join us in this fast-paced and highly interactive seminar where you will learn what you need to know to succeed with Microsoft 365/Office 365.

More Dates

Internal controls are more important than ever, and their importance increases daily. However, internal controls present a challenge for many smaller organizations. This program will teach you how to evaluate, develop, and implement an effective internal control structure in a small business environment. You will identify how to assess risk in smaller organizations and implement preventive, detective, deterrent, and compensating controls to mitigate these risks, even without proper segregation of duties. Additionally, participating in this program will teach you technology-focused techniques for preventing and detecting fraud and securing information systems and sensitive data. For small organizations, maintaining an effective system of internal controls presents a significant challenge. Realistically, implementing many theoretical concepts surrounding internal controls may sometimes be impossible. Consequently, many internal control structures foster an environment where too much risk exists. This factor and uncontrolled information systems can often lead to disastrous results. Participate in this program to learn the necessary insights and tools to design, implement, and monitor small organizations' internal controls, security, and anti-fraud measures.

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.

Most professionals routinely use Word, Outlook, and PowerPoint, but many are self-taught and, as a result, have not used many of the best features of these three applications. Consequently, they often use "brute force," inefficient means when working with these three components of Microsoft Office. If that describes you, carve time out of your schedule to participate in this four-hour session. In it, you will learn how to work much more efficiently when using these tools to get better results in less time.