CPE + Events Catalog

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!

Unlock the intricacies of Oregon's Pass-Through Entity Elective Tax (PTE-E) and how it fits into the broader landscape of PTE-E programs nationwide. In this insightful session of the SALT Mastery Series, gain a comprehensive overview of PTE-E programs across the country, including essential Federal tax considerations. Delve into the specifics of Oregon's PTE-E program and discover strategies to manage the interaction between state PTE-E taxes for multi-state clients-helping you avoid the pitfalls of double taxation. With expert guidance, you'll walk away with the knowledge needed to optimize tax positions for your clients.

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!

Every year brings new challenges and opportunities for businesses navigating tax compliance and entity structuring. This course focuses on the tax implications of complex transactions and how tax professionals can guide business clients in structuring entities efficiently. Participants will explore tax-advantageous entity structures, related party issues, and loss limitations while ensuring compliance with tax laws. Additionally, the course will cover key considerations such as accounting methods and insolvency guidelines, equipping tax professionals with the knowledge needed to provide strategic tax planning advice.

This course will enable practitioners to understand and apply the AICPA "clarification" auditing standards and the new SAS 145 risk assessment requirements. Further, this course will provide guidance on how to perform an effective, efficient and profitable audit engagement. The course is loaded with practical practice aids to help enable participants to comply with the standards. Troublesome areas as identified in peer reviews and litigation will be covered. Participants who take this course will enjoy a smooth sailing in their peer reviews...guaranteed!

This course will enable practitioners to understand and apply the AICPA "clarification" auditing standards and the new SAS 145 risk assessment requirements. Further, this course will provide guidance on how to perform an effective, efficient and profitable audit engagement. The course is loaded with practical practice aids to help enable participants to comply with the standards. Troublesome areas as identified in peer reviews and litigation will be covered. Participants who take this course will enjoy a smooth sailing in their peer reviews...guaranteed!

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

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.

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.

This course provides an update and review of the financial reporting frameworks commonly used by small- and medium-sized entities (SMEs); namely, the U.S. GAAP Financial Reporting Framework principles that apply to SMEs, the tax and cash special purpose frameworks, and the AICPA Financial Reporting Framework for SMEs. Troublesome areas in these financial reporting frameworks as identified in peer reviews and litigation will be highlighted.

This course provides an update and review of the financial reporting frameworks commonly used by small- and medium-sized entities (SMEs); namely, the U.S. GAAP Financial Reporting Framework principles that apply to SMEs, the tax and cash special purpose frameworks, and the AICPA Financial Reporting Framework for SMEs. Troublesome areas in these financial reporting frameworks as identified in peer reviews and litigation will be highlighted.

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.

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.

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.

Microsoft Teams is one of the most exciting personal and organizational productivity tools ever appearing on the business landscape. With Teams, you can communicate and collaborate easily and securely with others, including colleagues outside your organization. Further, you can extend the already-robust functionality in Teams by incorporating add-in solutions with just a few mouse clicks. Unfortunately, despite Teams' power and relatively simple interface, many organizations struggle to deploy and use Teams. In this session, you will learn how to get up and running quickly in Teams to take full advantage of this powerful tool. More specifically, you will learn how to get started in Teams and critical decisions affecting your deployment. Also, you will learn how to work in Teams, take advantage of the chat, voice, and video call services, and share documents securely with others. Moreover, you will learn how to extend your Teams platform to external organizations for improved communication and collaboration. Additionally, you will identify how to add other applications to Teams and optimize Team's configuration for the best overall efficiency and security. If you are working with Teams or plan to do so, this is one CPE session you can't afford to miss!

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.

The QuickBooks platform - including the desktop and online environments - is one of the leading accounting solutions for small and growing businesses. Further, Intuit has incorporated numerous advanced features and changes into the tools over the past few releases. This seminar will teach you how to use many new and advanced features in the desktop and online environments to help you solve critical issues. For example, you will learn advanced inventory management techniques, including changing the default costing methodology and implementing lot and serial number tracking. You will also learn how to build complete sets of financial statements in Excel that link in real-time to underlying QuickBooks data files and how to create multi-company financial statements. Additionally, you will learn how to use the Client Data Review feature to streamline how to identify and correct errors and close accounting periods in QuickBooks.