Professional Development and Event Catalog

CPA's are responsible for understanding (1) the presence of fraudulent activity, (2) that financial reports are complete and accurate, and (3) applying the going concern principle to a business. Appropriate cybersecurity controls, processes and oversight directly impact these three areas. Fraud Bad actors can exploit systems with weak security controls to perform fraud. The increasing prevalence of hacked systems reflect this. Bad actors are stealing data, intellectual property, financial assets, and other information. Digital fraud is becoming more prevalent and can be substantially more damaging than historical types of fraud. Not only can digital fraud result in financial loss, but it can subject companies to expensive lawsuits, damage reputations and can even put a company out of business. Complete & Accurate Financial Reports Having cybersecurity controls on systems and networks is critical to ensure information reported in financial statements is complete and accurate. Data residing in financial reports is processed, stored and transmitted using IT Systems. It is important for CPA's to understand the required cybersecurity controls to prevent or detect inaccurate data in financial reports. Going Concern With an increasing volume of system hacks (e.g. Target, Experian, Sony, and most recently the US Government), it is no longer "if" you're going to get hacked, it is "When." If organizations do not have appropriate cybersecurity controls in place to protect against an attack, then a malicious hack can put them out of business. An organization's cybersecurity posture should be a factor in evaluating the Principle of Going Concern. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

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.

This course focuses on how to integrate integrity and objectivity in situations accounting professionals face daily. The participant will be able to know not just what is the right thing to do according to the AICPA Code of Professional Conduct, but how to put values into action! As part of this course, we will also walk through real world examples of individuals and companies faced with these dilemmas. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Is teamwork the ultimate competitive advantage? Every manager's primary purpose is to lead a team. This seminar will help you get every member of your team on the same page, improve performance and realize the potential of the talent you have.

You are likely familiar with the Trust Fund Recovery Penalty or TFRP, BUT - aside from appealing the proposed assessment, did you know that you can make a request to remove the TFRP by making an administrative request on Form 843 (Claim for Refund and Request for Abatement)? This program will provide an overview of the Trust Fund Recovery Penalty with an emphasis on evidence gathering and using Form 843 to prevail on the IRS as to why they should accept your request for refund, effectively undoing the TFRP. This will include what to request in a FOIA, what criteria need to be met for refund, analyzing the IRS' TFRP file, and reconciling requirements in the IRM. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

As our business environment shifts, so do trends with fraud schemes and perpetrators. This course will give you the absolutely latest information with how to identify and mitigate shifting fraud risks in any entity. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

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.

As talent advance into supervisory roles they have to transition from being individual contributors to organizing a team to produce the results. However, most were never taught how to do the planning and scheduling to run projects because many of their leaders learned on the job as well. In this session we will borrow project management skills to teach a new supervisors and managers how to start making longer term plans to optimize the team. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Transforming your practice or business to a digital model is a journey, not a destination. There are some digital initiatives that require a great deal of time and money to deploy. There are also many "low hanging fruit" initiatives that are relatively easy and inexpensive to deploy. E-signature software is a perfect example of the latter. John Higgins, a nationally recognized leader in accounting technology, will guide you through the process of evaluating, selecting and implementing e-signature software to streamline a solution, and secure your document signing processes. You will be surprised to discover how easy it is to take your engagement letter and contract signing workflow digital. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Just about every company, no matter its size or the types of activities it undertakes, is at greater risk because of all the types of fraud that can be be carried out electronically. Potential perpetrators can be operating internally or externally and the scope of the damage that occurs is almost never limited to cyber-assets. While threat awareness is improving, there are still too many owners or top level executives that underestimate the scale of the issue. In this session, we delve into the types and the nature of many electronic defalcation schemes. The material then explores measures that organizations can implement to help stop these activities and add additional layers of security. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Internal Control Deficiencies and Other Matters - Adding Value Through Required Auditor Communications will help the auditor with understanding how to improve required internal control communications to be more value-added from the perspective of the client. Professional and regulatory audit standards require communication of internal control matters noted in a financial statement audit. This assists management and those charged with governance with satisfying responsibilities for designing, implementing, maintaining, and monitoring internal controls. In addition, in order to retain existing clients, lower fee pressures and gain invaluable referral sources, financial statement auditors must place a priority on being a value-added business advisor. Note: This course is recommended as a part of a 16-hour audit skills curriculum for in-charge or supervisor auditors, while it is also appropriate for anyone who has responsibilities for communicating internal control related matters to the client. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The process of closing out the books every month can make year-end accounting a breeze! But isn't this time consuming? Not when you know the steps to take monthly. We'll show you what to do in your QuickBooks Pro, Premier, or Enterprise as well as learn what you can do monthly to ensure a tax return that will stand up again an IRS audit. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Ethics are of central importance to the CPA profession. But what do we mean by ethics? Is it just appropriate behavior, compliance with laws, or is it more than that? In this course, we'll discover what sets ethics apart and, therefore, sets the profession apart as well. We'll explore the tools available, the role of bias, and dive into real life case studies. We'll apply the AICPA's ethical framework and detect where bias was involved in the case studies. We'll even discover that one person set the price tag on their ethics at $53.7 million, only to lose it all in the end. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Joshua, a CFO from Chicago, did not go to prison for stealing the $2 million in liquid cash he had access to on a daily basis. Instead, Joshua ended up in prison by rationalizing that he was entitled to a few small perks of the profession. This course explores Joshua's story and covers how and why executives with high annual incomes make short-sighted decisions that can cost them their job and freedom. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Auditing Investments - Understanding Risks and Procedures for the Most Common Investments will provide an overview for evaluating the proper recognition, measurement and disclosure of the most common investments types. Many small- and mid-size entities hold less-complex investments, including mutual funds, 'plain vanilla' derivatives (such as interest rate swaps), and permanent life insurance policies. Note: This course is recommended as a part of a 16-hour audit skills curriculum for in-charge or supervisor auditors, while it is also appropriate for anyone who has responsibilities for auditing common investments. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

PowerPoint is a widely available resource that is potentially underutilized by accountants because many accountants do not stray beyond Excel and Word in the Microsoft Office suite. You will learn how to create and edit a professional PowerPoint slide deck. This session places particular emphasis on efficiency tips and tricks that will allow you to develop creative, professional visual aids while minimizing time and effort. The course's author will share personal insights he has cultivated throughout more than two decades of public speaking. Although the session will focus on creating and editing slides, we will illustrate best practices for presentation delivery. We also will explain how PowerPoint can be used for purposes other than delivering presentations. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Have you ever opened a blank workbook in Excel and just stared at it, wondering where to begin? Or, do you spend most of your time just formatting cells to make your spreadsheet look pretty? Or, do you just wonder if there is a better way to create your spreadsheets? This course is designed to take you from a blank worksheet to a completed report. Our example will be a financial statement but you can use the knowledge gained in the course and apply it to your specific job function. You will learn to import data instead of manually entering it. Learn that you can use functions and formulas to build calculations that will eliminate the need to manually manipulate your data. Our goal is to make sure you have all the information needed to build reports without having to manually enter it every month. You will learn techniques to use your data to build your reports. This will include building formulas that are flexible with your changing data. You will learn techniques to validate your report calculations so you can improve the accuracy of your reports. You will also learn how to quickly format reports and techniques that allow you to efficiently change the format. Lastly, you will learn how PivotTables can provide a more dynamic reporting option instead of using pre-defined report formats. Obviously, we will be covering a lot of ground, so to enhance your learning experience all examples will be provided to each participant along with instructions. This will allow you to follow along and use as you apply your new knowledge to your spreadsheets. 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.

Key factors and considerations for organizations seeking to implement a cryptocurrency-based payment system. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Join us for this opportunity to gather with CTCPA Executive Director and CEO Bonnie Stewart to discuss issues affecting the profession.

Explore the ethical principles included in the Code of Professional Conduct that address the emerging practice issues created by new technologies. Consider how technologies may impact audit quality and the integrity of the financial systems, and whether they create a need for CPAs to adjust their skill sets to address those challenges. Look at the potential ethical challenges created by the data related to privacy, security, and its application. Discuss the changes being proposed to address emerging ethics challenges. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.