Professional Development and Event Catalog

This 2-hour mini course introduces how data analytics can be used to improve engagement quality and efficiency. Participants explore the use of data analytics to assess risk, support financial statement assertions, assess internal controls and uncover fraud. Apply the ADA IDEASc approach to using data analytics on engagements to ensure compliance with audit and review standards and to provide value-added services to clients. All of AHI's courses rely heavily on participant interaction and these virtual programs have co-opted many of Zoom's features to preserve the same strengths of the in-person training: visual interaction between the instructor and all participants (plan to be "on screen" throughout the program); breakout rooms to ensure small group engagement; and instructor interaction screen share for small group presentations, easy delivery of video presentations, and fillable PDF for online note-taking in the course materials.

The course provides a concise overview of how to use ChatGPT to more effectively and efficiently research IRS taxation law. It delves into techniques for extracting precise information from complex tax legislation, interpreting IRS guidelines with AI assistance, and utilizing ChatGPT's advanced language models for nuanced legal analysis. Participants will learn how to streamline their research process, identify relevant tax law precedents, and apply AI insights to real-world tax scenarios, enhancing their professional proficiency in navigating the intricate world of IRS taxation. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Excel remains a staple tool for virtually all accounting and financial professionals. In this session learn about many of the newer features in Excel, along with some you may have overlooked in the past…truly “must-see CPE!”

Conflict is as natural as breathing air. For many, the thought of dealing with conflict is difficult and horrifying, and yet unresolved conflict can damage relationships, cause pain and suffering as well as hinder workplace productivity. When addressed, however, conflict has the power to be transformative in strengthening workplace relationships, shared understanding, and increased productivity. This workshop will provide an intimate understanding of how to deal with conflict in collaborative and constructive ways. Using ethical values and principles, we will explore how to move conflict from an obstacle to an opportunity. This workshop is geared toward individuals who are wanting to improve their conflict management skills and create more harmonious and positive working environments. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The "permanent" changes from the TCJA may stand like a lion in the pathway of change, but Washington has its own definition of permanent. Inflation adjustments and technical corrections are included within this deep analysis of the complex maze of rules dealing with depreciation, amortization, and sale of property. This course contains many examples and cases to illustrate the most important points of which CPAs need to be aware.

If you thought applying one set of audit standards is tough enough, how about applying three different sets of audit standards in one “single” audit?  That’s exactly what happens when the auditor applies GAAS, the Yellow Book and the OMB requirements in a Single Audit.  This session will start with a single audit “nuts and bolts” overview before delving into unique aspects and audit issues of the era of pandemic-related funding, and of course the new funding related to the Infrastructure and Investment in Jobs Act, or IIJA.  Join our expert panel of federal, state and local auditors and practitioners, along with a representative of a large Federal Agency to learn what you need to know if you are performing audits under these audit standards and the Uniform Guidance for Federal Awards.   **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.

This intensive two-hour course addresses the critical need for accuracy and efficiency when developing spreadsheets using Microsoft Excel. Recognizing that even minor errors can have significant implications, this course delves deep into strategies and skills required to detect and correct errors in Excel. By the end of this course, participants will have a comprehensive understanding of how to efficiently identify and correct errors in Excel spreadsheets, enhancing their overall productivity and accuracy in their professional roles. 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 describes a state agency's quality review of a not-for-profit organization's A-133 Single Audit.  The case study describes the organization audited, its federally- and state-funded programs, and the CPA firm retained to do the audit.  Various anomalies in the financial statements alerted state officials to potential problems, and a detailed quality review followed.  Find out how the entity turned hundreds of thousands of dollars in bank overdrafts into hundreds of thousands of dollars of cash on its balance sheet.  Explore other “creative” ways to deal with fixed assets, accounts receivable, and related-party transactions.  Were the auditors just sloppy, ignorant, negligent?  Or were they active participants in producing fraudulent financial statements?  You be the judge.

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.

Reading the AICPA Code of Professional Conduct can be a daunting experience. This course unpacks the AICPA Code of Professional Conduct by exploring practical considerations for accounting professionals. We will examine selected provisions that are relevant to CPAs in both public accounting and industry. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

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.   

Regardless of size, most public accounting firms are mandated to have a written security plan in place. Failing to have such a plan in place can lead to substantial fines. Join us in this session to learn what your security plan should include and how to implement it.

Payroll is among the most common tasks an employer undertakes in the course of running their business. At its most basic level, payroll consists of an agreement between an employer and employee related to compensation for services. 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. This course will provide a general introduction to the inner workings of payroll and payroll taxes. We will introduce you to the various types of payroll statutory and withholding taxes, under what conditions and which employees these various types of taxes apply, how to calculate, withhold and deposit those taxes and the related due dates requirements that apply to payroll taxes. This course will include real-life examples of how to process payroll, the withholding and payroll tax deposit regime, familiar payroll forms, and tips and tricks for tying it all together. 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 explore the ethical considerations CPAs and CPA firms should be cognizant of when considering services to the state legal, regulated cannabis industry. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

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.

For many business professionals, accessing and managing data in Excel is one of the biggest stumbling blocks when creating reports and analyses. Common practices include far too many manual processes and formulas, including never-ending manual processes needed to update your data and related reports. Make plans now to join us in this session to learn best practices for accessing and managing data using Excel. In this session, you will learn how you can use Power Query and other Excel tools to quickly access and manipulate your data and generate reports in record time! This is a “must-see” session for any business professional working with Excel!    

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!

Many organizations unconsciously fail to exhibit diversity, inclusion and belonging.  This session provides an opportunity for leaders to  understand diversity language and definitions, build awareness of biases and stereotypes, recognize how our own actions protect our awareness gaps, and find a level of understanding concerning where we are and where we want to be in the future. 

Unlike a traditional financial audit objective (Are the financial statements materially misstated), performance auditing can address a wide variety of objectives.  Is this program working? Can it be improved? Where can we save money? How can we operate more efficiently and effectively? Are management’s assertions supported? And so forth.  This session will explain what a performance audit is, describe the applicable standards, and provide examples that indicate the value of a performance audit.  Performance audits can add value to any entity and practitioners can profit from adding these assurance services to their practices.

OneNote is a fantastic application included in your Microsoft 365 subscription. Yet, it is underutilized and misunderstood most of the time. If you genuinely want to change how you work, embrace OneNote. Stop using Outlook as a filing cabinet for essential emails and move them to OneNote instead. If you share a OneNote notebook with others, you can stop emailing altogether within your group and use OneNote as your collaboration and reference platform.