CPE Catalog & Events

* This course is #3 in the Microsoft Power BI series of webinars. Click button in Program Content section below to see suggested viewing order. * Excel is a popular tool for data analysis, yet most users have never learned the basics of data analysis using Excel or the tools that Excel offers to help with data analysis. This session is designed to teach participants the importance of PivotTables for analyzing data. We will demonstrate how PivotTables can make data analyzation an easy task for all accountants. Participants will learn the step-by-step process to create PivotTables and PivotCharts. We will also cover all the setup options and features. This session is presented using Excel 2019/Office 365. Regardless of the version you are using, most concepts covered in this course apply to all versions of Excel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Business leaders often view an internal control system as a security measure. However, a well-designed system can also drive entity objectives. Learn to design a robust and well-supported system, leveraging years of experience and key concepts from authoritative pronouncements and frameworks. Explore strategies to address new business challenges, including evolving markets, rapid changes in business, and increasing governmental and industry-based regulation. This course is for anyone working with internal controls.

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.

Auditing Cash - Applying Basic Skills to the Starting Point of Any Audit demonstrates how the approach to auditing different cash accounts may vary and how to strengthen inquiry which is an important audit procedure in this area. Cash tends to be one of the first areas assigned to new auditors, as there is typically little complexity and subjectivity involved. In addition, persuasive audit evidence from a third-party is generally available. However, research shows that around 80% of asset misappropriation relates to cash. Therefore, the audit of accounts and classes of disclosures related to cash and cash equivalents does tend to carry some level of risk of material misstatement. Note: This course is recommended as a part of a 16-hour audit skills curriculum for beginning auditors, while it is also appropriate for anyone who has responsibilities for auditing cash and cash equivalents. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Cybercrime is on the rise and CPAs that handle sensitive client data are often the target of cybercrimes.  By attending this session you'll learn what the eight biggest threats are to your business and uncover the three pillars of cybersecurity that you can build your firm's defense around.

One of the three major forms of occupational fraud, along with corruption and asset misappropriation, is financial statement fraud.  From improper asset valuation to fictitious revenues, this course will review financial statement fraud red flags and examine real-life examples.   

Excel remains a staple tool for virtually all accounting and financial professionals. In this session learn about many of the newer features in Excel, along with some you may have overlooked in the past…truly “must-see CPE!”

This CPE course provides an overview and changes with respect to ASU 2016-14 Presentation of Financial Statements and ASU 2016-18 Restricted Cash and Cash Equivalents in Statement of Cash Flows for Not-for-Profit Entities. This course provides common pitfalls and tips on functional expense reporting and, how to manage liquid resources, common peer review findings related to ASU 2016-14, and tips and suggestions on a successful audit. This course also reviews items to consider, given COVID-19, when preparing for an audit and reviewing financial statements. The instructor will explain the key facts and impacts of ASU 2018-08 Clarifying the Scope and Accounting Guidance for Contributions Received and Contributions Made, ASU 2019-03: Updating the Definition of Collections, ASU 2019-06: Extending the Private Company Accounting Alternatives on Goodwill and Certain Identifiable Intangibles to NFP Entities, and ASU 2020-07 Presentation and Disclosures by NFP Entities for Contributed Nonfinancial Assets. Lastly, this course will cover Cybersecurity Issues. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Understanding the dynamics of family interaction is one of the most important skills in helping a family business succeed. This course takes a candid look inside the family business, and will help the participant navigate delicate issues while learning to provide counsel that will grow - or protect - the family business and non-family staff.

Stay at the forefront of business income taxation with this essential course tailored for tax practitioners seeking to enhance their expertise. This course offers an in-depth review of the intricacies surrounding business income taxation, focusing on the latest developments for the current tax year. Dive into recent changes and updates within the tax code, providing you with a comprehensive understanding of the evolving tax landscape. Equip yourself to effectively navigate new regulations, guidelines, and strategies while assisting clients in optimizing their business income tax planning. 

How to properly account for and audit digital records is increasingly gathering importance as more entities have cryptocurrency and other digital assets on their financial statements. This course will address common questions, risks, and challenges evolving in this area. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Gain a fundamental understanding of the Mergers and Acquisitions (M&A) process from a buyer's and a seller's perspective.

This course, the first in a three-course series, concentrates on the five-step approach covered in ASC Topic 606, Revenue from Contracts with Customers. Since ASC Topic 606, Revenue from Contracts with Customers has been adopted by most entities, it is time to review the topic, including any recent updates. The course also includes pertinent note disclosures from several publicly traded companies across several industries. Be sure to register for all three parts of this series: Revenue: The Five Steps-Topic 606-10 Revenue: Special Implementation Guide-Topic 606-10-55 Revenue: Miscellaneous Topics

Specifically designed for preparation, compilation, and review practitioners, this course will provide you with a comprehensive review and hands-on application for performing financial statement preparation, compilation, and review engagements. You will learn the ins and outs of applying SSARS No. 21, Clarification and Recodification, as well as the additional guidance related to SSARS engagements through the issuance of SSARS Nos. 22-25 by the ARSC. The course will also review recent peer review feedback on SSARS engagements, providing insights on how to successfully apply this guidance. Not only will this course bring you up to date on SSARSs requirements and guidance, but more importantly, it will provide you with practical examples and illustrations to help you effectively and efficiently perform compilation, preparation, and review engagements.

Most professionals routinely use Word, Outlook, and PowerPoint, but many are self-taught and, as a result, have not been exposed to 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, ensure you carve time out of your schedule to participate in this fourhour session. In it, you will learn how to work much more efficiently when using these tools to get better results in less time.  

Learn the basics of employment law and how they affect best practices to help control the interview and discover hidden talents of applicants.

Are you  looking to fortify your practice against the ever-growing threats in the digital landscape? Join us for the second installment of our exclusive webinar series, "Mastering Cybersecurity," brought to you by Practice Protect. In today's digitally connected world, the need for comprehensive cybersecurity is paramount. With cyberattacks becoming more sophisticated, it's crucial to stay ahead of the curve in protecting your sensitive client data.  This webinar series is designed to equip CPAs with the knowledge and tools needed to secure their practices and client information effectively.

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.

Prior to the COVID-19 pandemic, telework in state and local government was not often embraced as a form of employment. As the pandemic continues, governments are beginning to experience the benefits of remote work and are reevaluating hiring practices to offer more telework and hybrid work options, not simply as a result of an emergency.  This course will review various telework options and best practices for success. 

The Enhancing Audit Quality Initiative has identified inadequate or nonexistent audit documentation as one of the most significant issues facing the profession. Over half of the engagements reviewed by the AICPA did not meet the requirements of AU-C 230. This course will look at common misconceptions related to audit documentation and help attendees address these deficiencies with efficient and effective best practices.