CPE Catalog & Events

PivotTable is a fancy term for an Excel report that summarizes data. If you have not yet had the good fortune of exploring PivotTables, it is about time. In this session, we'll dig into PivotTables, understand the report layout options, and examine PivotTable formulas.

Fraud is prevalent - especially since COVID-19 relief packages passed by legislatures around the world opened the till. The overwhelming majority of fraud cases are never publicized. In this course we will build on our knowledge of why people commit fraud to dissect the schemes and discuss transactional controls to help stop fraud faster.

As financial and tax professionals well know, information overload is a constant struggle we face because things change quickly, and the sheer number of changes being made on a daily basis is enormous. Of great importance to small and medium tax and advisory firms is differentiating between changes that are relevant to our practice and our clients and changes that are new but totally irrelevant. Distinguishing between the two is difficult and time-consuming. Mike Tucker and a team of experts are pleased to present a weekly series designed to eliminate the clutter and get you what you need to stay up-to-date and perform for your clients. Mike and his co-presenters will dispense news on current events impacting taxes, finance, and industry. The subject matter will differ each week and intermittently include topics such as Social Security and Medicare. The panelists will discuss personal and corporate tax matters as well as other late-breaking news related to practitioners' personal finances and those of their clients. Every financial professional will benefit from this series. This is a cost-effective way for accountants to fulfill their compulsory continuing education because this weekly series will include almost 40 one-hour presentations. Sign up today - your clients and your bottom line will thank you.

Providing a practical overview of the IRS Power of Attorney, Form 2848, and IRS Tax Information Authorization, Form 8821. Participants will explore the differences between these forms, understand when each is required, and how to comply with IRS requirements for representing clients and accessing their tax information. The course will cover practical issues, ethical considerations, and best practices for managing client authorizations through the IRS Centralized Authorization File (CAF) system. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Today's workforce looks a lot different than it used to. With more people working from home and across state lines, employers must examine withholding and unemployment laws in a new light. In this course, we will examine tried and true rules in this area, but also examine statutes that are still developing. Using real-life examples and discussion, we will examine state laws on reciprocity and residency requirements. We will also look at what to do when state laws are silent or conflict on a particular issue, so that you can keep your clients in compliance and be well-prepared for the questions that will come your way in these ever-changing times.

ChatGPT is the fastest growing application in the history of technology with over 100 million users adopting it in within two months. It is a revolutionary technology that boosts the quality and efficiency of business processes in every industry. As "knowledge workers", CPAs and CFOs are positioned to be prime beneficiaries of this technology. This half day hands-on course will get you well on your way to becoming a ChatGPT expert. John Higgins, a nationally recognized advisor and educator on CPA technology, will guide you through the process of accessing ChatGPT and applying it to a variety of practical accounting, finance and tax scenarios. This course will catapult you to the top of the pyramid of CPAs who are knowledgeable in ChatGPT and you will be ready to put it to use in your day-to-day tasks. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Difficult conversations tend to be avoided because professionals shy away from the uncomfortable, and the fear of polarizing their relationships. Participants will learn strategies and tactics to engage in productive conversations which address challenges and deepen relationships. They will understand where and why they are avoiding having difficult conversations. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Advanced Excel for Staff - Build Reports and Analyze Data is a comprehensive, 2-hour course tailored for professionals looking to enhance their Microsoft Excel skills in creating reports and performing data analysis. This course bridges the gap between basic Excel functionality and the advanced techniques required for effective data-driven reports. Participants will learn to efficiently gather, organize, and structure data, apply calculations to derive key metrics, and create professional-grade reports that are both visually appealing and actionable. The course emphasizes practical application, providing participants with guidance on Excel's advanced tools and functions. By mastering workflows and best practices, learners will gain the confidence to tackle complex data challenges and streamline reporting processes. Additionally, participants will explore methods to validate and share their work, ensuring that reports are accurate, insightful, and easily communicated across teams. Whether you are tasked with preparing financial summaries, tracking performance metrics, or generating operational insights, this course will equip you with the tools to maximize Excel's potential, saving time and improving the quality of your outputs. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The Internal Revenue Code (IRC) requires entities making certain types of payments, including business payments to contractors, to file information returns with the IRS. Information returns are intended to improve voluntary compliance with tax law by providing information about potentially taxable transactions to the IRS and taxpayers. A payment settlement entity (PSE) must file Form 1099-K for payments made in settlement of reportable payment transactions for each calendar year.

The course provides a concise overview of how accountants can use ChatGPT to assist with communications involving intricate and often sensitive topics that require a deep understanding of both financial principles and human resource policies. These conversations can range from budgeting and compensation to ethical considerations and regulatory compliance. The course also explores the use of ChatGPT in crafting clear, accurate, and empathetic responses to complex queries related to financial audits, tax planning, and employee benefits. It emphasizes the importance of balancing technical financial knowledge with effective communication skills to address diverse stakeholders' needs in various scenarios, from internal team discussions to client consultations. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This session will address the complex rules of retirement distributions, review key provisions of the SECURE Act 2.0, and provide practical strategies of maximizing tax benefits for your client. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

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.

The employer-employee relationship strains both sides in uncertain times, and businesses need CPAs, controllers, and other advisors to provide understanding of the complex legal, tax, and health care issues associated with all aspects of employment. This course provides in-depth coverage of this critical area.

Recent economic, societal, and political changes have 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.

If you perform Yellow Book audits and/or single audits, it is a given that a peer reviewer will be looking at your work on those engagements! Why fret and sweat about what peer reviewers are going to be looking for? In this course, we will explore the key audit requirements that peer reviewers focus on, how the auditor complies with those requirements, and common pitfalls seen in Yellow Book and single audits. This course will help you proceed and succeed in your Yellow Book and single audits!

A deeper dive into Cybersecurity topics specific to CPAs and Fintech Organizations, expanding on the fundamentals from Cybersecurity 101 This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Looking to improve the quality of your 401(k) benefit plan audits? This is the course for you. Based on recent data from the U.S. Department of Labor and peer reviews on employee benefit plan audits, we know auditors need to up their game to meet stakeholder demands and provide the best possible audit services. In this advanced course, we will discuss the audit and reporting requirements in accordance with SAS 136 and other recently issued SASs. We will also discuss laws and regulations (such as ERISA) that are unique to employee benefit plans and provide practical guidance on their application. Course topics will focus on the most common compliance issues identified in 401(k) audits by the Department of Labor and peer reviews, as well as recommended corrections. Auditors will identify best practices for auditing areas such as payroll and compensation, participant loans, hardship distributions, investments, and plan mergers and acquisitions.

As long as LLCs, partnerships, and S corporations form the backbone of many CPAs' practices, in-depth knowledge of all tax aspects of these entities will be essential. The purpose of this practical course is to focus on planning issues in creating, operating, and liquidating S corporations, partnerships, and LLCs. This course is essential for CPAs in public accounting and industry who advise these entities or their investors.

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.

This course provides an update of the recent changes that have occurred in the financial reporting frameworks commonly used by small and medium-sized entities (SMEs). Troublesome areas in these financial reporting frameworks as identified in peer reviews and litigation will be highlighted. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.