Professional Development and Event Catalog

Making Rain - Improving Success with Retaining Clients and Attracting Prospects provides tips and techniques for ensuring that your firm has the capacity to grow and expand its book of business in a healthy way. It costs more money to develop a new client than to simply retain an existing one. While a CPA firm with longevity needs to continuously develop new business to replace departing clients, a proper balance of marketing efforts should be divided between existing clients and prospects. Note: This course is recommended as a part of a 8-hour audit skills curriculum for managers, while it is also appropriate for anyone who has client relationship or prospecting responsibilities. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

How well do you accept criticism? How might it enrich your business - and you - if you did a better job of it? This distinctive webinar will show you why it is in your best interest to accept criticism with gratitude. It's even better to welcome criticism. It's also a good idea to learn how to give criticism the right way. A related topic is the art of giving and receiving apologies, and we'll do a deep dive into this area as well. You'll leave with clear guidelines for how to criticize others, accept criticism from them, give meaningful apologies, and accept apologies with grace and ethical intelligence. The result will be a stronger CPA practice and a better you. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Working with a small business, you know that keeping the company's finances in order is critical to success. While numerous software programs and tools are available to help you do this, they vary substantially in many significant aspects. In addition to conventional options like QuickBooks and Sage 50, you can choose from Cloud-based tools such as Zoho Books, QuickBooks Online, Spire Systems, Xero, Accounting Suite, Accounting Power, and many more. In this session, we'll look at the best accounting tools for small businesses and discuss the benefits of each one. This session covers accounting solutions that should work for startups and companies with up to $10 million in annual revenue. We also cover various add-on solutions that can enhance the overall functionality of your accounting platform. Join us to learn your options for achieving your small business management financial goals.

Are you looking to take your PivotTables to the next level? Many experts consider PivotTables to be Excel’s most powerful feature. Yet, most who create and work with them barely scratch the surface of all that PivotTables can do. In this session, you’ll learn eight powerful features you may have missed. From user-defined calculations to consolidating reports and adding KPIs, we’ll show you how to get the most out of your PivotTables. These are just some examples of the great things you can do with PivotTables, and in this session, you will learn these and other techniques to make your PivotTables even more powerful.

This course is an extension of the Power BI series of courses that specifically explores using OLAP formulas and advanced time intelligent functions. OLAP formulas provide the ability to create a calculation in a cell that is based upon the measure in the data model. This powerful tool provides the ability to create calculations in an Excel worksheet without using a PivotTable to perform the calculation. Gone are the days of creating a PivotTable, then using those values in the PivotTable for additional calculations. When using Power BI to build a data model that connects to data files, you may want to know the date of these files. This class teaches you how to create a measure based upon the refresh date of your data. In the class "Power BI - Use Advanced Calculations with DAX Formulas," you learned the basics of time intelligent functions, the ability to calculate measures based upon dates. In THIS course, we will take it to the next step and teach you how to perform many more date-based calculations. 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.

If you are familiar with the Office 365 Teams app, you know it is an extremely powerful tool to transform the way you communicate, collaborate and share knowledge. What you may not know is how to configure Teams to optimize your ROI and how effectively your team members use it. This course takes you on a tour of the important setup and configuration settings you need to be familiar with to ensure the best Teams experience for your organization. Whether you are already using Teams, in the process of deploying it, or are contemplating whether or not to bring it into your organization, this course will prove to be invaluable. The information shared in this course is sure to help you avoid costly mistakes in your Teams app deployment. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Government leases are getting an overhaul. GASB Statement 87 was issued in 2017 and provides an update on the proper accounting for leases from both the lessee and lessor points-of-view.  This course will help attendees understand the nuances of the updated definition of a lease as well as other significant changes to terminology. Attendees will discuss the impact of the changes to financial reporting as well as the key challenges that governments and auditors will need to consider to properly implement the new standard. This interactive course includes the preparation of journal entries to assist in understanding impact.

As popular as the VLOOKUP function is, it has limitations. This session walks through the limitations and suggests how to improve the VLOOKUP function. We then discuss how to move beyond VLOOKUP altogether. We spend some time trapping errors with the IFERROR function, which was first rolled out with Excel 2007. The webcast is designed with time for you to work along. This hands-on workshop is an effective way to learn Excel since you'll be completing the same exercises demonstrated by the instructor. A link will be provided, so you can download the necessary Excel files. During the webcast, the instructor will provide time for you to complete the exercises using your Microsoft Excel for Windows. For each topic presented, the instructor explains the topic and demonstrates it with Excel exercises. Then, the instructor provides time for you to complete many of the same exercises. Finally, the instructor demonstrates the solutions for all the exercises in the practice workbook and then moves to the next topic. This format allows you to work along rather than just watch passively, enabling you to immediately practice the skills demonstrated.

This session comprises one of four Form 990 Master Classes available to those wanting intermediate-to-advanced training on topics that comprise the 990's most difficulty arenas. The two public support tests have been utilized since the finalization of Regulations to the 1969 statutory changes that subdivided the 501(c)(3) world into "private foundations" and "public charities." The tests' application remains murky to most preparers (even though they have been in existence, virtually unchanged, for decades). This session has two key goals: first, ensuring that participants understand the design, reach, and purpose of each test; and second, making practitioners conversant (with the materials as back-up) h of each test's line-by-line inputs. While it is impossible "to have fun" with these tests, participants will walk away knowing where pressure points exist and how those vary depending on an organization's specific successes or gaps in achieving diversity of so-called "public support." What is possible and achievable from this session is that these tests can be mastered! Although this course is categorized as "Basic", the content is also suitable for those seeking advanced-level training. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Social media - it's a buzzword, but is it beneficial for your firm's brand? And more importantly, your bottom line? This course focuses on the latter and takes a deep dive into which social media platforms are best for accounting firm lead generation, recruitment, client retention and more. Attendees will take away a practical framework and actionable tactics for integrating social media into your firm's overall marketing and communications strategy to help you grow your revenue without having to spend hours on social media or even be on it personally if you don't wish to! This event may be a rebroadcast of a live event and the instructor will be available for questions during the event.

Most organizations have many of the basic controls required to operate in place. However, a notable percentage of these companies do not have important measures that can help enhance security, productivity, and the quality of information available for decision making. In this session, we work to identify areas where important internal control measures are needed. We spend time explaining why these controls should be created, and show in detail some specific controls that would be beneficial if utilized. Those wishing to strengthen an internal control system should strongly consider attending this session. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Demands for an excellent user experience are at an all-time high. But how do you solve for easy collaboration, compliance, and workflow? What features do you need to be effective? How do you integrate payments, eSignatures, and other technologies to make interaction convenient? This session will explain the necessary features, provide an overview of the best technologies for collaboration, and help you think through how to solve your business problems. You'll learn about the options available from client portals, workflow management, payments, eSignatures, and more. Attend this session and arm yourself with the tools you need to succeed!

A significant challenge facing many auditors is determining and documenting their independence under generally accepted government auditing standards (GAGAS). All professional involved in audits performed in accordance with GAGAS should have a working knowledge of the independence requirements imposed by the 2018 Yellow Book. We will cover the issues that all auditors need to know about the GAGAS independence requirements, by providing example about how to comply with these requirements. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

For many small businesses, the standards issued by the FASB may have little to no effect as they impact topics that do not reflect the type of transactions that these entities most frequently experience. This class will focus on the Accounting Standards Updates (ASUs) that are most likely to impact small businesses with a focus on ASUs initiated by the Private Company Council (PCC). We'll then look at alternative reporting options to GAAP including FRF for SMEs and IFRS for SMEs for entities who don't necessarily need to prepare GAAP financial statements but want to use accrual accounting. Finally, we will transition to audit standards that small business auditors will need to implement this year, including changes to auditing accounting estimates and risk assessment. 

In this cutting-edge course, participants will gain a deep understanding of how to leverage ChatGPT, OpenAI's powerful language model, to innovate and enhance business advisory services in the accounting sector. The course integrates theory and practice, demonstrating how various enterprise evaluation methodologies can be applied in conjunction with ChatGPT for increased business analysis efficiency, profitability, and growth. It also provides hands-on training for implementing these techniques in real-world scenarios. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Individuals who work in a governmental environment have many rules of ethics that must be followed. The Government Accountability Office (GAO) issues Yellow Book providing rules related to ethics and independence, which received a significant update in 2018. We'll review some of the key elements of ethics relevant to governmental entities and auditors to prevent independence noncompliance.

Financial statement disclosures are important to provide the information necessary for financial statement users to make economic decisions. Disclosures further explain and clarify information provided in the basic financial statements, but also provide critical information about subsequent events, litigation risk, and other concerns. This course focuses on the most common financial statement disclosures for small- or medium-sized nonpublic entities. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

You are likely familiar with strategies for removing the Trust Fund Recovery Penalty (TFRP) or brokering an installment agreement with a Revenue Officer or ACS Representative, but what should you do and when? What happens when things break down? Who should you contact and when? This topic will help guide practitioners on getting around certain obstacles or roadblocks while working cases with the IRS. This includes best practices for contesting the TFRP, who to contact and how to prepare when negotiating installment agreements, and steps to elevate cases that are seemingly going nowhere. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

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.   

Properly designed and effectively operating internal control over financial reporting is critical for preventing, or detecting and correcting, material misstatement. This course describes how to satisfy the audit requirements related to taking a control reliance strategy by testing the operating effectiveness of internal controls, while promoting an effective and efficient financial statement audit. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.