CPE Catalog & Events

“How will I EVER get this all done?"  It’s a question I often hear from clients and on a particularly stressful day, I can hear myself saying these words!  Instead of helping us focus, it's a question that leads to stress, anxiety and overwhelm! Regardless of where we are in business and in life, we will run into challenges and problems as we navigate business growth, leadership, work life balance and our quest for success and happiness. This workshop will explore the 7 HIGH QUALITY questions that lead to relief, enthusiasm and success.  It will be an interactive exploration that will leave you with a game plan to use right away, as well as an opportunity to practice the mindset that the most successful and happiest people use daily.    This program is for both the entrepreneur who wants to be more effective in their day as well as team leaders who want to stand out in their organization.  For the business owner or staff member you can expect a new way to work with your day so that it's profitable, productive and happier.  For leaders, you will learn new up- leveled skills to increase your efficiency, communication and productivity.  You and your team will shine.  Your staff will feel appreciated and connected to their value as well as the company's goals. Albert Einstein said 'we can't solve our problems with the same thinking we used when we created them'.  The quality of your question will impact the quality of your solution.  Learn the 7 questions that take you from confused and frustrated to creative and focused. 

Excel is the #1 data analysis tool for accountants, yet many accountants 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 analyzing data 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 2013. Regardless of the version you are using, ALL 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.

As spreadsheets evolve, so must your practices for creating, editing, and auditing them. In this program, you will gain an in-depth understanding of the best ways to work with Excel by learning best practices associated with Excel spreadsheets in each of the following areas: creating and editing Excel workbooks, securing Excel workbooks, collaborating with others in Excel, and reporting on data contained in Excel. Today’s best practices for Excel differ significantly from those used in the past, and you will learn the best ways to work with Excel spreadsheets in this “must-see” CPE program. Course materials include relevant examples to enhance your learning experience. Join us for this program to help you utilize Excel to its fullest potential.  

Payroll is among the most common tasks an employer undertakes in the course of running their business. At it's most basic level, payroll consists of an agreement between an employer and employee related to compensation for services. However, once you look under the hood, there is so much more to payroll, including various kinds of compensation, payroll taxes and required reporting on government forms. Ethics in payroll is present in every step in the payroll process, from handling employee confidential information and dealing with pay, compensation and fringe benefits, to acting as an intermediary on behalf of federal, state, and local governments in the collection and remittance of payroll taxes. All levels of payroll staff- from payroll processor to payroll manager to CEO - encounter ethical considerations in their conduct when dealing with payroll matters. This course will discuss ethics as it pertains to payroll. Attendees will leave with a comprehensive framework for ethical decision making in the payroll function, as well as some real-life examples of what happens when stakeholders in the payroll process make the decision to decouple ethics from payroll. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The AICPA has determined than 1 in 10 firms are not compliant with the risk assessment standards. This course will discuss how to properly identify risks and assess risks under AU-C 315. We will then review how to respond to identified risks under AU-C 330. The course will focus on the inherent risk model. We will also review common deficiencies and how a proper risk assessment can drive a more efficient and effective audit.

This course will provide overview of key cybersecurity security domains that CPA's should evaluate in an audit. It will provide an overview of each security domain, and an overview of how to evaluate and assess the sufficiency of the cybersecurity control. Examples of security domains that will be covered include: Change management Access management Data integrity This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

There is no shortage of data, but relatively few organizations have an environment and process to isolate, capture, analyze, and convert data into actionable information. Too often, we collect as much data as possible, continue to use historic measurements, and communicate data using traditional vehicles. Good decisions are not the result of the amount of data gathered, but of the quality and understanding of the information. The goal of this program is to explore a number of analytical tools and techniques and identify applications for them within an organization. Analytical techniques will be introduced throughout the discussion, and a significant amount of time will be spent addressing the steps needed to establish a data-driven environment and identifying and discussing potential/specific applications. In this way, participants get experience they can begin to use in their organizations. An expanded list of reference books and next level software is also provided.

This hands-on workshop offers an analytical approach for designing, executing, and communicating results of a comprehensive financial statement analysis. We will explore numerous techniques and approaches that facilitate in-depth financial statement analysis. Accountants in public practice will obtain insight regarding analytical procedures, additional client services, and enhanced compliance with professional standards. Accountants in private enterprises will develop more robust techniques for understanding their organization’s financial statements to facilitate forward-thinking decisions and communication to internal and external stakeholders.

Fraud continues to plague businesses at epidemic levels, and technology control failures are a significant reason fraud occurs. Using a case study approach, in this session, you will learn about the pervasiveness of fraud, the control failures that contribute to fraud, and what you can do to mitigate fraud risk. A specific focus of this course is the application of information technology general controls and information technology application controls. In this course, you will examine numerous reported fraud cases and identify the general control and application control failures that contributed to each of these frauds. By learning through these real-world case studies, you will be positioned better to reduce fraud risk.  

We kick off this course with a look at the GASB standards that are effective this year including GASB 100, Accounting Changes and Error Corrections and GASB 101, Compensated Absences.  We then move to the NFP side of the house with a look at the Accounting Standard Updates issued by the FASB that impacts nonprofit entities. Following that, we review the work of the Not-for-Profit Advisory Committee (NAC) and the projects they advise the FASB on. After the break, we will conduct a deeper dive into Yellow Book and Single Audit engagements. The course closes with a look at the significant changes in the 2024 Compliance Supplement, the changes to the Uniform Guidance and the common deficiencies identified by the federal agencies and peer reviewers. 

The Paperless Office is not a myth! With today’s technology, you have many fantastic options for “going paperless,” In this session, you will learn how to leverage these technologies for better document management and storage practices.

In this course we will look at the highlights of what valuation is doing, how to go about it and what to look for in business valuation reports.  Areas such as types of reports, the standards by which they are prepared and process that is used to go from data to report.  We will also discuss the purposes of reports and how that purpose may impact the value.  Finally, we discuss how to determine the value of minority interests.

Loans, rental agreements, business combinations – what do these all have in common? They all have the potential of creating a related party transaction.  This program presents a detailed analysis of the financial accounting rules for transactions with related parties, as well as compares and contrasts those rules with the AICPA financial reporting framework for small and medium-sized entities.

Are you aware there are 470+ formula functions in Excel? Do you realize that they add new functions in every major version of Excel? Did you know that Microsoft adds new functions throughout the year in the Office 365 version of Excel? Are you stuck using old or simple functions like SUM or ROUND? Do you want to expand your knowledge of the extensive function library in Excel? If these questions peak your interest in becoming an Excel function expert, this course is right up your alley. This past-paced course digs into some of the most powerful functions in Excel. Although we cannot cover 470 functions, we will look at over 20 functions that will allow you to create advanced calculations in your spreadsheets. Some examples are: VLOOKUP, IF, IFS, FORECAST, RAND, SWITCH, TEXTJOIN, UNIQUE, SUBTOTAL, IS, TEXT and more! We will also provide example files that will include all the functions used during the class. It's time to take your Excel spreadsheets to the next level. This session is presented using Excel 2019/Office 365. 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.

Effective teamwork pays its own way by creating greater productivity and profitability in any accounting organization. A team of people working cooperatively can produce more than the sum of individual members working alone. One good idea stimulates another - but only if the team members are engaged and motivated to do so. Teamwork is inhibited in today's high-stress and changing accounting regulatory environment. Integrated into this informative yet pragmatic seminar are tried-and-true motivational principles for the realities of today's changing accounting workplace. It's not easy, but it can be done. You will learn how to form, motivate, steer, and get greater results from all team members by understanding what makes them tick and strategizing approaches to engage all team members.

Do you want to build stronger relationships with your clients, improve client retention, and drive growth in your practice? This course delves into the essential strategies for effective client management in today's competitive landscape. Client relationships, like any relationship, can be challenging to manage. Miscommunication, differing work styles, and unrealistic expectations are some of the challenges accounting and finance professionals routinely encounter. However, when accounting clients and members of your team are on the same page, client loyalty and profitability improve while conflict is minimized. This webinar explores proven strategies to improve relationships between accounting and finance professionals and their clients.

"Did you know that fraud is like a parasite, feeding on the lifeblood of the industry and causing billions in losses each year? Join Chuck Gallagher, a renowned expert in fraud prevention, for 'The Many Faces of Fraud: Shedding Light on the Tactics of Modern-Day Swindlers,' a captivating two-hour course that will empower you to thwart these financial predators. Chuck will guide you through the most common forms of fraud, revealing the psychology and motivations of swindlers. Through real-life case studies and hands-on exercises, you'll learn practical strategies for identifying red flags and responding effectively to safeguard your organization. Enroll now to gain invaluable insights and join the fight against these cunning adversaries!"

Analytical Procedures - Comprehending Financial Statement Audit Fundamentals will provide the tips and techniques necessary to gather sufficient appropriate audit evidence to support conclusions using analytic procedures common to financial statement audits. Properly designing, documenting and evaluating results of analytic review procedures is critical for performing an effective and efficient audit engagement. Note: This course is recommended as a part of a 16-hour audit skills curriculum for experienced staff auditors, while it is also appropriate for anyone who has responsibilities for performing financial statement audit analytics. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Based on an AICPA Enhancing Audit Quality study, 23% of all single audits subject to enhanced oversight were materially non-conforming with professional standards due to failure to properly test controls over compliance.  This course will provide an overview of internal controls over compliance specifically related to Single Audits. We will discuss how to apply the concept of internal controls to various compliance requirements. Additionally, a common finding in the audits of governmental entities receiving federal grants is misidentifying controls and mistaking compliance for a control. That's why this course will also focus on identifying compliance versus controls over compliance.

The AICPA has determined that one in ten audit firms are not compliant with the risk assessment standards. This course will discuss how to properly identify risks and assess risk under AU-C 315. We will then review how to respond to identified risks under AU-C 330. The course will focus on the audit risk model and cover both inherent risk and internal controls. We review common deficiencies and how a proper risk assessment drives a more efficient and effective audit.