CPE + Events Catalog

Staff accountants have specific needs when working with Excel – needs that are often not met by their existing Excel knowledge. Chief among these are the needs to quickly summarize data, prepare accurate and aesthetically pleasing reports, and create accounting-centric calculations for elements such as depreciation, amortization, and interest. By participating in this eight-hour session, staff accountants will gain the essential skills they need to maximize their efficiency and accuracy when working with Excel. This session begins with a quick overview of Excel best practices. It then progresses rapidly into discussions that address PivotTables, sophisticated formulas, Tables, formatting, and working with dates in Excel. Throughout the session, you will learn from accounting-centric examples to reinforce key learning points. In this session, you will learn in a “laptop-friendly” environment, and participants will have access to all the demonstration files used in the session. In sum, this seminar is a “must” for all staff accountants seeking to improve their efficiency and accuracy when working with Excel.  

Don't let the title frighten you. Experienced staff can get bogged down in busy season with advanced practice and reporting issues. With major legislation enacted over the past few years, we bring you the distilled version of what you need to know for the current year and significant current proposals that may impact the tax landscape in future years or even retroactively. This course discusses the topics that experienced staff, managers, and partners should understand in depth while also assisting experienced staff in avoiding costly mistakes when facing complicated 1040 issues. The manual includes advanced examples and several advanced cases with "filled-in" forms provided with the complete answers.

The Uniform Guidance present unique challenges to auditors of governmental organizations and not-for profit organizations receiving federal financial assistance. This Guidance requires auditors to take a risk-based approach to the audit, including a methodology of determining which federal programs are considered major and therefore subject to Single Audit compliance requirements. A significant challenge facing many auditors is determining the Uniform Guidance requirements in a Single Audit. All professional involved in Single Audits must have a working knowledge of the requirements imposed by the Uniform Guidance. We will cover the issues that all auditors need to know about the Uniform Guidance requirements, including how to determine major federal programs. This course will provide 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.

Fraud continues to plague businesses at epidemic levels, and technology control failures are a big 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 better positioned to reduce fraud risk.  

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.  

During part 2, of this 4-part series, we'll focus on the concept of fiduciary accounting and its relationship to fiduciary taxation. It also addresses the identification of a "simple trust" for purposes of taxation. Problem examples will cover both the calculation of fiduciary accounting and the taxation of simple trusts through the use of an excel spreadsheet that translates to a completed Form 1041.

This past year has shown us the need for numerous projects and the need to manage those projects in a unique way. Project management is a way of thinking highly recognized and practiced by large organizations, but often neglected by the smallest companies and entrepreneurs. This course quickly discusses the basics of project management thought and practice and then spends the majority of the time exploring some of the greatest mistakes that can be made, the ways to avoid them, and some of the tricks that have been introduced into the discipline. In the program we will explore some of the specific types of project management as well as some of the available software programs to make the task of project management easier. In an effort to avoid talking theory without concrete examples, we will often use examples born from projects needed as a result of our experiences with COVID-19.

Team development and performance are critical to leadership success. In this session, participants will examine team formation, learn about the balance between team performance and team health, develop team agreements, and understand the latest tips from Google's Perfect Team research to strengthen team experience. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The effective date for private companies of ASC 326, Credit Losses, is rapidly approaching. Staring in 2023, all entities will be recording credit losses using the current estimate of credit loss (CECL) model, which will accelerate the recognition of such losses for all companies, including non-lending institutions and companies with trade accounts and leases receivable. This new guidance truly impacts all entities. In this course, we'll focus on applying the ASC 326 guidance to non-lending institutions. We'll review the CECL model and discuss how to apply it to trade accounts receivables and lease receivables, as well as the other financial assets which are in the scope of the new guidance. We'll also examine how to transition to the CECL guidance as well as review the new and voluminous disclosures required by ASC 326. 2023 is right around the corner and now is the time to get up to speed on the impact of this new guidance.

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.  

Increasingly, automating business processes is a necessity. In this session, you will learn about real-world examples of automating business processes. Remember, the survival of your business might depend upon successful automation!

One of the most favored employee benefit plans, the 401(k) plan, provides unique challenges for auditors. Also, as many 401(k) plan administrators opt for ERISA Section 103(a)(3)(C) audits, audits of 401(k) plans will be significantly impacted by the now-effective SAS 136, the AICPA's new employee benefit plan auditing standard. Through this course, auditors will obtain an understanding of the rules and regulations unique to employee benefit plans and obtain practical guidance on applying them. Auditors will enhance their knowledge of the performance and reporting requirements of SAS 136 through real-world examples, best practices, and efficient audit techniques that can be utilized in various audit engagements. Make sure your audits don't trigger a DOL inspection by conforming to all applicable rules and regulations.

Knowing the basics of advanced estate planning strategies is essential in advising clients with significant wealth seeking assistance in developing succession plans to address individual needs. However, running the numbers under various scenarios and assumptions is critical to the success of a plan. This webinar focuses on modeling the numbers for the different strategies and building flexibility into a plan. Such modeling in a live demonstration of financial planning software, running modeling exercises and reviewing examples of sophisticated estate and business planning scenarios is critical to understanding the concepts.

Ethics and professional skepticism are a cornerstone of public accounting. This course will review the Code of Ethics for Professional Accountants that practitioners must adhere to. This course will outline the pressures, opportunities, and rationalizations that lead to instances of fraud. In addition, this class will walk through some interactive examples to illustrate various scenarios of noncompliance during engagements. 

Manufacturing overhead costs - how to identify, classify, and trace products. How to handle Phantom sub-assembly costing issues. How to account for costs when manufacturing deviates from normal operations - outside temporary contractors. Applying costing principles to a process cost system and a project cost system. Example of a best-in-class chart of accounts for management reporting.

Forensic accounting encompasses fraud investigation and prevention, as well as a wide variety of functions in litigation. Forensic accountants provide services ranging from serving as an expert witness, to litigation consultant and bankruptcy trustee. As our economy grows more complex, the need for forensic accountants grows as well. One critical role of the forensic accountant is exposing and examining financial fraud. Technology expands the way companies conduct business; however, technology also provides greater opportunities for those willing to commit fraud. Forensic accountants rely on their skills in accounting, coupled with their investigative skills, to explain to clients, courts, and jurors how fraudulent schemes occur and the effect caused by fraud. Forensic accountants also provide expert opinions in calculating damages in litigation and administering bankruptcy estates, as well as a host of other services.

Financial skills needed in many situations are constantly changing.  It is prudent to routinely look into your toolbox to restock or revise your tool set.  In this course we will examine three tool categories that form the foundation for many analytical processes.

Governmental entities are the second largest victims of embezzlement. This seminar examines recent events involving theft of public money and circumstances that allowed the fraud to occur. Case studies we examine include the 2012 $54 million embezzlement from the City of Dixon by Rita Crundwell. The events that impacted the small Illinois town of 16,000 residents was the largest governmental fraud case to date, and spanned an astonishing 20 years. This remarkable story inspired an award-winning documentary, "All the Queen's Horses." We will also examine factors that led to scandals involving the Baptist Foundation of Arizona, World Com, Collin Street Bakery and the Ohio American Cancer Society, among others. This course is ideal for CPAs, government finance personnel, all Internal Auditors, lawyers, governance professionals, accountants and human resource personnel. 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 presents a detailed analysis of the self-rental passive activity rules, including forms reporting examples and integrates them with the flow-through entity rules related to self-rental. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

While once thought just to apply to banking and financial institutions, entities now need to apply fair value accounting under ASC 820 across a variety of transitions. From financial instruments to leases, business combination accounting and impairment measurement, GAAP either requires or allows the use of fair value measures in an ever-increasing number of circumstances. Now is the time for you to get up-to-speed on the basics of the fair value approach. In this course, we will review when fair value accounting is required and when an entity can select to use it. Then we will review the basics of the ASC 820 model, including the concept of "exit price," the various approaches which an entity may follow when using a fair value approach and the different levels of inputs which an entity may consider when determining fair value. Lastly, the course will provide examples on when and how to apply this complex accounting guidance.