CPE & Event Calendar

According to the FBI, “white-collar crime is … synonymous with the full range of frauds committed by business and government professionals … characterized by deceit, concealment, or violation of trust …. The motivation behind these crimes is financial—to obtain or avoid losing money, property, or services or to secure a personal or business advantage.”  CPAs can and should play a crucial role in preventing and detecting white-collar crime, as well as in prosecuting the perpetrators.  This session will explore whether we are up to this challenge, heighten awareness regarding the CPA’s role as a front-line defender of the public interest, and assess whether we are deserving of the public trust we enjoy.

This course dives into the powerful, but potentially under-utilized, capabilities of Microsoft Excel.  Designed for sophisticated users willing to approach spreadsheets from a unique perspective, this program encourages users to challenge the status quo by considering opportunities to take acceptable spreadsheets to a new level.

We all make predictions in our personal and professional lives.  We base our decisions to marry, buy a house, launch a new product or hire staff on expectations about the future.  In the past few years, research into improving predictions has advanced. We will look at this research and current best practices in forecasting to help us prepare better budgets and projections. 

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.

What can we learn from one of the largest municipal frauds in U.S. history? Rita Crundwell stole nearly $54 million from the citizens of Dixon, Illinois over the course of two decades. This course examines circumstances that allowed this landmark fraud to occur. We will explore internal control deficiencies and other circumstances that hindered prevention or timely detection of Rita's scheme. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Embark on a journey to master Power BI, a powerful tool for data analysis and business intelligence, in our comprehensive course, "Get Started with Power BI." This course is meticulously designed for professionals who seek to understand the full spectrum of Power BI capabilities, including its integration with Excel's Power BI features like Power Pivot and Power Query, and its comparison with standalone Power BI tools such as Power BI Desktop, Power BI Service, and Power BI Report Server. In the first part of the course, participants will be introduced to the fundamentals of Power BI. This includes an overview of Power BI's interface, key features, and its seamless integration with Excel. The course will cover Excel's Power BI tools - Power Pivot, for advanced data modeling, and Power Query, for efficient data transformation and preparation. This segment is essential for understanding how Power BI extends and enhances the data processing and analytical capabilities of Excel. The second section of the course delves into the standalone Power BI tools. Here, participants will explore Power BI Desktop for creating complex data models and sophisticated reports, Power BI Service for cloud-based collaboration and sharing, and Power BI Report Server for on-premises report deployment. This part of the course will focus on the unique features and strengths of these standalone tools, providing attendees with the skills to leverage Power BI in a variety of business contexts. 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 focuses on the power of pivot tables within Microsoft Excel. We initially discuss the creation of pivot tables and various ways to summarize information. Then we explore ways to utilize summarized pivot table data. The course uses several practical examples that should inspire participants to find their own creative uses for pivot tables. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Governmental entities are the second largest victims of embezzlement.  This seminar examines recent events involving the theft of public money and the circumstances that allowed the fraud to occur.  We will be looking at a variety of case studies to illustrate these points.  

Tax Season can be a daunting time for tax preparers, but it doesn’t have to be with the help of tax automation software tools and other innovative technology. This session will provide an overview of the latest technologies and tools that can help automate your workflow and make the entire tax return preparation process smoother and more efficient. From client portals, workflow management, and e-signatures to robotic process automation, you’ll learn about all the options available to help streamline your tax preparation process. So don’t dread Tax Season - attend this session and arm yourself with the tools you need to succeed!

When asked the question, “What would you like to improve about your leadership and communication style?” more than 65% of leaders say they want to be more confident and assertive in their communication. Confidence and clarity communicates leadership. If you are responsible for growing a profitable company or a productive team, you want team members who have the ability to reach goals, make sales, finish projects, and serve customers. Being a confident compelling leader helps to inspire better relationships, promotes trust and reduces stress in the workplace.

How do you keep your team connected with the limitations of virtual meetings? Suddenly, it’s more important than ever for each member to understand and appreciate their differences; to see beyond the screen and see each other’s human-side to maintain trust. In this session, Tina Hallis, Ph.D., will explore the neuroscience of trust and why it’s critical for optimum teamwork. But more importantly, you will leave with specific strategies and tools that you can choose from to use with your people. 

Do you often hear people complaining about coworkers or other departments? Do you have talented people with the right skills who struggle to collaborate and cooperate as a team? You’re not alone. This can be a common situation when people’s values, beliefs and their approach to solving problems differ. The key is to help everyone understand that our differences aren't bad – they’re interesting and extremely valuable.  In this course, Tina guides you through tools and activities you can use to help your people (and yourself) broaden their perspective so they can more easily cooperate, collaborate, and communicate with the people around them. This program explores ways to help them connect, from personality assessments to team building activities. When coworkers or team-members understand each other better, it's easier to appreciate their differences.  

As discussed in the Association of Certified Fraud Examiners’ Occupational Fraud 2022: A Report to the Nations, 86% of all frauds are misappropriation of assets.  Why is the misappropriation of assets so large?  Because there as so many of them it creates many, many opportunities.  And the asset which is stolen the most?  CASH!  Because it’s easy to conceal and you don’t have to convert it.  During this presentation, the many, many different ways to misappropriate (steal) assets and which assets (besides cash) are most subject to misappropriation are discussed as well as how to recognize such and more importantly, how easy it is to prevent it!

Running or advising a small business? KPI Bootcamp can help you quickly find and deploy the right KPIs to achieve your, or your client's, goals. Delivered by Bernie Smith, KPI specialist and overloaded small business owner, this course will help you quickly select a handful of powerful measures that apply to your business. The step-by-step approach helps you sharpen your objectives and select the right KPIs to drive growth and profit. Every one of the 412 included KPIs (as free PDF download for every participant) includes a full plain-English definition and also covers business benefits, case-study examples and practical tips.

Unhealthy behavior in the workplace can create a drama-laden, hostile work environment, negatively impact productivity and increase turnover. When team members are focused on how they can one-up their counterparts or are fearful of their co-workers/leaders actions towards them – they are NOT focused on reaching your company’s goals.   

Auditors are required by Generally Accepted Auditing Standards to perform audit procedures to determine if the financial statements are materially misstated due to error OR FRAUD.  Unfortunately, in the past the profession has focused on misstatements due to errors and largely ignored to possibility of misstatements due to fraud.  While SAS No. 122, AU 240, Consideration of Fraud in a Financial Statement Audit sets forth the procedures that auditors are required to perform in each audit to determine if the financial statements are materially misstated due to fraud, this program presents a practical approach to making such a determination.  It’s not a substitute for the requirements in SAS 122, AU 240, but rather an informal supplement to the standard with some common-sense procedures which are designed from my over 30 plus years of directing fraud investigations.  After attending this session, you will more than likely never look at a financial statement audit the same way.

Inventory is a wonderful place to both hide fraud and commit fraud.  The reasons that inventory is subject to so much fraud is the it is often very large, spread out over a large area, and many people have access to it.  When there are little or no internal controls related to inventory control, you are begging employees to steal it.  No with so many ways to dispose of stolen inventory via the internet, i.e., EBAY, inventory fraud is much more appealing to a lot of individuals. The more common ways to commit expense fraud and how to cover it up will also be discussed.  Travel and entertainment are some of the favorite areas of committing expense fraud.  In addition, payroll fraud will be discussed.  Although there are many ways to commit payroll fraud, it is very easy to prevent. This presentation is designed to familiarize the participants with the many ways to commit inventory, expense and payroll fraud, how to detect it, and more importantly, how to prevent it.

When performing a financial statement audit, auditors have always been responsible for the detection of anything that would cause a material misstatement of the financial statements whether caused by error of fraud.  However, in the past the audit profession focused on material misstatements due to errors and more or less ignored the possibility of misstatements due to fraud.  Now, SAS No. 122, AU 240 requires significant documentation as to what the auditor did in order to determine if there any material risk of a misstatement of the financial statements.  This presentation is an overview of what the auditor is to document in there working papers on every financial audit as to the procedures they performed in order to determine the risk of a material misstatement.  If a material risk is discovered, they are then required to document what they did in order to determine if the financial statements were misstated.

Are you looking to fortify your practice against the ever-growing threats in the digital landscape? Join us for the third installment of our exclusive webinar series, "Mastering Cybersecurity," brought to you by Practice Protect.  In today's digitally connected world, the need for comprehensive cybersecurity is paramount. With cyberattacks becoming more sophisticated, it's crucial to stay ahead of the curve in protecting your sensitive client data. This webinar series is designed to equip CPAs with the knowledge and tools needed to secure their practices and client information effectively.

The Secure Act 2.0 was passed in a flurry of year-end legislation. This one hour program will cover the important changes that employers need to know about company retirement plans. Employers will also need to consider how Secure Act 2.0 will the administration of existing plans or the creation of new ones.  This course will provide a concise look at these hot topics.   **Please Note:  If you need credit reported to the IRS for this IRS approved program, please download the IRS CE request form on the Course Materials Tab and submit to kori.herrera@acpen.com.