CPE + Events Catalog

Virtually all accounting and financial professionals use Excel but, unfortunately, most don't use it as efficiently and effectively as they could or should. If you're ready to elevate your Excel skills, plan today to participate in this special 8-hour conference designed to help you work better with Excel.

The Tax Cuts and Jobs Act of 2017 has had a tremendous impact on commercial real estate, including liberalizing the depreciation provisions. The Coronavirus Aid, Relief, and Economic Security Act (CARES Act) included several provisions that allow taxpayers to revisit projects completed in earlier, more profitable years, and generate even more value. In this course, we will explore the impact of these important laws on commercial real estate owners and delve into what Accounting and Financial Professionals need to know. We'll also examine these opportunities to "turn back the clock," including the retroactive correction of QIP's recovery period and the option to revoke electing-out of the business interest limitation. Finally, we will review other strategies that are crucial parts of a comprehensive tax plan this year and will discuss a strategic hierarchy for employing those strategies most successfully. Relevant Rev. Procs. and multiple real-life case studies will be reviewed.OSCPA has partnered with the Washington Society of CPAs for this event.

The sheer mass of Internal Revenue Code provisions affecting individual taxpayers presents a considerable challenge for CPAs and tax professionals. The review stage of preparing a return serves as a critical backstop to prevent errors in clients' returns. This case study-based course addresses common mistakes practitioners make when preparing individual tax returns that are often missed by review staff. Learners will review four sample returns and identify both errors and areas of opportunity. They'll also discover issues that may warrant additional client information and about areas of tax law that require deeper analysis.OSCPA has partnered with the Washington Society of CPAs for this event.

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

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 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.

Trusts are not cookie-cutter documents. In fact, they can be rather unwieldy, especially in explaining the functions to a client and then having the client comply with the trust terms. This course delves into best practices. Given common scenarios, what are the best trusts to use? And how can the client be best protected?

Multistate taxation has never been more relevant. This course helps you skillfully navigate the maze of corporate tax codes across jurisdictions, focusing on interstate activity and nexus, allocation and apportionment, and key court cases. By spotlighting updates on the latest state tax reforms, this course will help you develop a working knowledge of both multistate tax compliance and related planning opportunities.OSCPA has partnered with the Washington Society of CPAs for this event.

More Dates

Staff accountants have specific needs when working with Excel. Unfortunately, their existing Excel knowledge often does not meet these needs. Chief among these are summarizing data quickly and accurately, generating accurate and aesthetically pleasing reports, and creating accounting-centric calculations for elements such as depreciation, amortization, and interest. By participating in this eight-hour session, staff accountants will gain the essential skills to maximize efficiency and accuracy when working with Excel. This session begins with a quick overview of Excel best practices. It then progresses rapidly into discussions that address PivotTables, sophisticated formulas, Tables, formatting, and working with dates in Excel. Throughout the session, you will learn from accounting centric examples to reinforce key learning points. In this session, you will learn in a "laptop-friendly" environment, and participants will have access to all the demonstration files. In sum, this seminar is a "must" for all staff accountants seeking to improve their efficiency and accuracy when working with Excel.

More Dates

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 employer-employee relationship strains both sides in uncertain times, and businesses need CPAs, controllers, and other advisors to provide understanding of the complex legal, tax, and health care issues associated with all aspects of employment. This course provides in-depth coverage of this critical area.OSCPA has partnered with the Washington Society of CPAs for this event.

More Dates

Award winning discussion leader Mark Hugh helps you meet the ethics requirements of two states, while learning about recent changes at the national and state level. This four-hour class satisfies the Oregon general ethics requirement and is approved by the Washington Board of Accountancy as meeting its four-hour ethics requirement.

More Dates

Maximize deductions and minimize confusion with the Oregon Pass-Through Entity Elective Tax (PTE-E). This essential session of the SALT Mastery Series provides an overview to properly reporting on PTE-E forms and delivering accurate information to PTE owners. Dive into the interaction between PTE-E and individual returns, as well as key Federal considerations, ensuring your clients don't miss out on valuable tax savings. Led by seasoned tax experts, this session will equip you with the knowledge and strategies to optimize PTE-E reporting and compliance.

With the increasing complexity and ever-changing nature of tax laws and issues, today's accountant needs a one-day update course focusing on individual income tax issues with an emphasis of newly enacted income tax legislation. This comprehensive class will not only review the current Federal individual income tax laws but will also update tax return preparers of new tax forms, changes to existing tax forms, as well as tax planning opportunities and pitfalls. This is a "must-attend" course for all tax practitioners who want to be up to speed quickly and have a successful Federal individual income tax filing season. *IRS CE-U (Tax Update): Pending Approval *Need IRS CE credit? You must register with the exact name the IRS has on file. You must also have a valid PTIN & LTC/LTP number on file with OSCPA. Click Here to check your account and update your information.

With the increasing complexity and ever-changing nature of tax laws and issues, today's accountant needs a one-day update course focusing on business income tax issues with an emphasis of newly enacted income tax legislation. This comprehensive class will not only review the current Federal business income tax laws but will also update tax return preparers of new tax forms, changes to existing tax forms, as well as tax planning opportunities and pitfalls. This is a "must-attend" course for all tax practitioners who want to be up to speed quickly and have a successful Federal business income tax filing season. *IRS CE-U (Tax Update): Pending Approval *Need IRS CE credit? You must register with the exact name the IRS has on file. You must also have a valid PTIN & LTC/LTP number on file with OSCPA. Click Here to check your account and update your information.

Clients want help with present and future business services. Which tax planning strategies will you provide for your corporate and small business clients? Updated with the latest legislation and IRS guidance on tax reform, this course answers the tough questions and shows you what strategies are best for your clients. We use a case-study approach to explore opportunities for businesses and how the tax practitioner can continue to add value for their clients. Discussions will include traditional and new planning opportunities due to the latest tax legislation, including SECURE 2.0 and related regulations, as well as IRS guidance.

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

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.

More Dates

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.

More Dates

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