CPE Catalog & Events

Each year, more states legalize cannabis (i.e., marijuana) for medical or recreational purposes. As legalization grows, so too does the cannabis industry. While some financial professionals have stayed away from this growing sector of the economy, others have embraced the opportunities the cannabis industry has to offer. The legalization of cannabis brings with it a complex regulatory landscape, which includes strict compliance with federal and state regulations. However, the complexity of this emerging market provides opportunities for accountants and other financial professionals. Behind the cannabis dispensaries are scores of related business sectors including food production, retail, farming, and chemical production, as well as facilities, design, and construction. Simply stated, the commercialization of marijuana offers financial professionals an opportunity to participate in an industry expected to reach $73 billion worldwide within six years.

Recognize the impact of emerging issues, including the increasing divergence of private company accounting standards, the pace and complexity of new standards being issued, and the usefulness of non-GAAP reporting. We'll discuss current issues, including accounting for crypto assets, the controversy over ESG reporting, going concern disclosures and impairment testing, and accounting for internally developed intangibles, including research and development. The course also includes an update on the FASB and PCC agendas.

Manage distractions, decrease stress and improve productivity. This training is designed to help business professionals improve their productivity and work performance by learning how to prioritize time, decrease distractions and lower stress. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Excel has long been included in the accountant's toolbox. Even though Microsoft Power BI and other big data tools such as Qlik and Tableau are becoming more important, Excel is still a "must have" tool. We cover what the accountants of today should know about Excel to improve their efficiency, access data, and gain insights into the company, industry, and economy.

CPAs can be requested to assist attorneys in litigation support in criminal proceedings. For criminal tax cases, the IRS has recommended prosecution. However, the rules and stakes are different than a simple civil audit. This presentation will focus on how to assist defense attorneys in calculating tax loss, asking the right questions, and probe possible weaknesses in criminal tax investigations. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Unlock the potential of generative AI to streamline accounting, auditing, tax , and advisory services. This course focuses on practical applications that can save you time and enhance profitability. Learn how to integrate AI tools into your workflows to automate tasks, improve accuracy, and deliver higher-value services. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Do you ever import data into Excel, and then spend a bunch of time manually preparing it for use? Perhaps you delete extra columns or rows. Maybe you need to split a single column into multiple columns, or, combine multiple columns into a single column. The good news is that many of these transformations can be fully automated with Excel! The Get & Transform tools built-in to Excel 2016 for Windows, formerly available as the Power Query add-in, are incredibly powerful. At a high level, they enable us to retrieve data from a variety of sources and prepare it for use as needed. In this session, we'll use Get & Transform queries to help with several common tasks, including flattening data, splitting and combining columns, formatting data, unpivoting summarized data, and combining several csv exports. If you frequently export/import data from one system to another, you will want to understand how to use a Get & Transform query to streamline your work.

We are bombarded with information continually. So how do we determine what is valid and what isn't? This course points out common pitfalls inherent in data interpretation and gives practical tips to overcome those pitfalls by using real life examples. The course incorporates information from key thought leaders including Adam Grant, Alex Edmans, and Hans Rosling. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This course will review common deficiencies identified by the AICPA and state boards of accountancy. It features discussion on a variety of topics, including analytical procedures, sampling, group audits and risk assessment. We will review the areas of concern and how you can overcome them by employing best practices. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This program addresses the role of client internal controls for balancing efficiency and effectiveness in a risk-based audit. Practical insights regarding an auditor's assessment of the risk of material misstatement when auditing financial statements of non-issuers will be explored, with particular emphasis on internal controls of small-to-medium clients. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event. This event may be a rebroadcast of a live event and the instructor will be available for your questions during the event.

This course allows you to get reacquainted with the statement of cash flows. We will refresh your skills regarding both the preparation and utilization of the statement of cash flows. Significant emphasis will be placed on the informational role of the statement of cash flows and insights that can be obtained using the statement of cash flows in concert with the other elements of a company's accrual-basis financial statements. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This course provides a concise overview of Gemini AI, Google's advanced multimodal artificial intelligence model. It explains how Gemini is integrated into different Google products, including Gmail, Docs, Sheets, Slides, and as a stand-alone chatbot. Participants will learn how Gemini enhances productivity by summarizing email threads, suggesting responses, drafting emails, generating formulas, creating tables, and more. By the end of the course, students will have a solid foundation in understanding Gemini AI's role in the evolving landscape of artificial intelligence. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The well-informed tax practitioner will want to attend this two hour program in order to stay current on recent updates on partnership tax! Content includes recent court decisions on partnership tax issues as well as current IRS procedural updates for passthroughs. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

In this innovative course, participants will learn to combine the power of artificial intelligence with the functionality of Microsoft Excel. You will learn how to leverage ChatGPT, OpenAI's powerful language model, to improve your Excel skills and decrease the time it takes to build spreadsheets. The course will include a quick introduction to ChatGPT but the majority of the time will be spent using ChatGPT to create an Excel spreadsheet. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Unlock the power of artificial intelligence to transform your firm's marketing strategy. This course will explore how AI can revolutionize your marketing efforts, helping you to reach your target audience more effectively and boost your firm's growth. In this session, Gaynor Meilke will guide you through the steps to implement an AI-enabled marketing strategy tailored to your firm's needs. Key Takeaways: Understand the fundamental principles of AI and its applications in marketing. Learn how to leverage AI tools and technologies to enhance your marketing campaigns. Discover practical strategies for integrating AI into your firm's marketing workflow. Gain insights into measuring the effectiveness of your AI-driven marketing efforts. Explore real-life case studies and success stories of firms that have successfully implemented AI in their marketing strategies. By the end of this course, you will be equipped with the knowledge and tools to harness the power of AI, streamline your marketing processes, and achieve remarkable results for your firm. Don't miss this opportunity to stay ahead of the competition and lead your firm to new heights with AI-enabled marketing This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

In this webinar, accountants will discover how to double their firm's revenue through CFO and advisory services. Many accounting firm owners are stuck in what we call The Accountant's Trap. It's where the firm owner is trapped working for low fees, dealing with high-demanding clients, all the while being burnt out on compliance and transactional work. To make matters worse, these firm owners can't raise their fees because there is always another accountant or bookkeeper willing to do the work for less -- not to mention all the tech companies trying to get into our space. Does this sound familiar? If so, this webinar is for you. This course is for any practice owner looking to transform their practice - and double their revenue - by offering a productized CFO/Advisory service. We'll cover the systems you need to transform your practice and the services you should offer to double your firm's revenue. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This intensive two-hour course addresses the critical need for accuracy and efficiency when developing spreadsheets using Microsoft Excel. Recognizing that even minor errors can have significant implications, this course delves deep into strategies and skills required to detect and correct errors in Excel. By the end of this course, participants will have a comprehensive understanding of how to efficiently identify and correct errors in Excel spreadsheets, enhancing their overall productivity and accuracy in their professional roles. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The Association of Certified Fraud Examiners says that there is fraud lurking in all businesses, including not-for-profit organizations. It often goes undetected for years and when uncovered, management and the board may question why an auditor did not identify it. The auditor's responsibility in a financial statement audit is to assess risk and perform sufficient procedures to obtain reasonable assurance that the financial statements are free from material misstatement due to fraud or error. However, failure to perform an adequate fraud risk assessment and report deficiencies in internal control, such as a lack of segregation of duties, can leave a firm vulnerable. This course will discuss the audit procedures that should be performed in accordance with AU-C 240 as recently amended, best practices in performing fraud risk assessment procedures, when and how to report control deficiencies noted in an audit, and the most frequent types of fraud found in small to mid-sized entities along with internal controls that could be implemented to help prevent and detect them. We will look at various cyber fraud schemes and how they might be prevented or detected, the use of analytics as fraud risk procedures, and assessments of fraud risk in a Single Audit. This course features case studies.

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-26 by the ARSC. In addition to SSARS 26, the entire suite of quality management standards is discussed. However, knowing the standards is not enough. You need to be able to effectively apply them. To support this, the course will 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 SSARS requirements and guidance, but more importantly, it will provide you with practical examples and illustrations to help you effectively and efficiently perform these types of engagements. This course is intended to be your go-to reference for training your staff and managing your SSARS No. 21-26 services in compliance with professional, ethical, and technical requirements.

Recent generally accepted auditing standards were written to improve the quality of risk-based financial statement audits, audit reporting, and required by-product communications. This course will discuss the important clarifications and enhancements intended to improve audit quality to ensure better compliance with requirements contained in SAS Nos. 134-145. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.