CPE Catalog & Events

Wow! So many new Excel features and so little time! Microsoft continues to add tremendous functionality to Excel - the business professional's tool of choice. Yet most Excel users have not discovered these new tools and remain mired in yesterday's practices for working in Excel. In this session, you will learn how to use many of Excel's latest features to work more efficiently and effectively with your spreadsheets. Participate in this session to learn about recently released features such as PIVOTBY, GROUPBY, Office Scripts, integration with Copilot, new ways to share and collaborate in Excel, and data entry and formula improvements. If you work with Excel - and who doesn't - this session is necessary to help you improve your efficiency and effectiveness when using Excel.

Leaders were once chosen for their character, but today we live in an age where loudmouthed extroverts seem to take center stage in everything, including business, politics and entertainment.  While the talkative, charismatic leader makes the front page of business magazines, recent research shows that successful business leaders tend to be more reserved, pensive and sometimes outright shy.  Learn why your desire to spend significant time inside your own head may be your greatest asset. Whether you are introverted or not, you likely work with, manage or are a related to an introvert.  We will discuss proven methods to better understand introverts, how to manage them, and how to get the most out of their amazing talents.  If you want to enhance your leadership skills, this seminar is for you. 

Two conmen used lies and falsified documents to convince the State of Tennessee to give them a $3,000,000 economic development grant to create 1,000 jobs by purchasing and rehabilitating a vacant factory in rural Tennessee. Instead, they spent most of the money on an extravagant lifestyle and invested over $1M in a scheme to defraud the U.S. Federal Emergency Management Agency (FEMA) out of over $30,000,000 pursuant to a contract to provide the tarps for areas such as Puerto Rico, affected by hurricanes. This session provides a detailed case study of how the investigators accumulated, organized, and analyzed hundreds of documents, identified the falsifications and misrepresentations, conducted multiple interviews, and ultimately convicted the conmen. This case study provides multiple takeaways for detecting and investigating grant fraud, which is especially relevant in light of the numerous federal stimulus programs in recent years.

The cash flow statement is one of the most confusing financial reports—yet it has the potential to deliver the essential keys to understand business performance. After all, cash is still both king and queen! This session explores how to present, interpret, and communicate cash flows effectively to help CEOs, boards, and decision makers drive smarter results. By using the Sources and Uses format, professionals can make the statement more intuitive and actionable. Learn how to simplify cash flow information and focus discussions on what matters most: how cash is generated and deployed? We will demonstrate how to confidently present this powerful financial statement to non-financial leaders. The cash flow statement is misunderstood, and we will show you how to fix that, and include some amusing videos to drive the points home. We will use the Apple Corporation as an example company in presenting.

Effective risk assessment is foundational to designing an appropriate audit response. This course introduces the audit risk model and provides an overview of the risk assessment procedures performed during engagements. Participants will review the components of the audit risk model and examine common risk assessment procedures, including inquiries, analytical procedures, and observation and inspection techniques. Emphasis is placed on understanding how risk assessment drives engagement planning and supports the development of appropriate audit responses. Designed for auditors seeking a structured introduction or refresher, this course builds foundational knowledge necessary for effective engagement planning and execution. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

We see multiple stories about the rapid growth of artificial intelligence (AI) and its entry into our lives in the form of AI tools, including ChatGPT. They seem to be everywhere. It is difficult to overstate how much things will change with the rise of these new technologies, or how important it is that companies embrace the opportunity to execute them correctly. Having conversations regarding the proper adoption of these technologies and tools is a crucial first step, including drafting policies to assist companies with their beneficial and thoughtful implementation and use. This course will define the state of AI tools, what benefits and risks exist, and which steps to take to begin adopting these technologies with appropriate guardrails, policies, and training. It is less likely that AI will destroy industries, and more likely that companies that embrace AI will overtake those companies that do not.

This course provides an overview of the Quality Management standards and the requirements under SQMS 1. The AICPA requires CPA firms with accounting and auditing practices to implement a system of quality management, including firms performing preparation and compilation engagements. While the objective is to improve quality within the profession, implementation may seem overwhelming. To assist, the AICPA has developed practice aids to guide firms through the development and documentation process. In this webcast, Jeff walks through where to find the practice aids, how to use them, required documentation, use of the risk assessment template, and development of final documentation. Practical guidance is provided throughout to simplify implementation.

Tax planning is more than an estimated tax calculation, it's a process.  Where are we now and what can we change?  This timely program will highlight significant 2022-23 tax developments and discuss key tax planning ideas for your clients as you prepare for the upcoming tax season. Don’t wait until late December to start planning for your clients! **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.

Although they are the most common entities for small and mid-sized business, financial (book) accounting for partnerships and LLCs are rarely discussed.  This course examines the proper financial accounting for these tax-driven entities.

This business coaching course is designed to enhance your coaching effectiveness by integrating innovative tools like ChatGPT (Generative AI) to support and elevate your coaching practice. You'll explore the key differences and similarities between coaching and managing, uncover the most important skill every coach should master, and learn how to get to the root cause of any problem. With hands-on coaching strategies, including neuro-linguistic programming (NLP) techniques, you'll enhance your ability to drive results. Additionally, you’ll discover how to use performance gap analysis to identify and bridge gaps, ensuring the success and growth of the individuals you coach.

This course will provide an update of Government Auditing Standards as a result of the GAO's issuance of the 2024 Revision to Government Auditing Standards. The course will focus on the Revisions impact on financial statement audits. The course will also focus on the impact of Quality Management Standards as well as clarify as to when the concept of reporting key audit matters might apply for financial audits. 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 reviews the legal, fiduciary, and federal tax responsibilities of an executor or personal representative during the administration of a decedent’s estate. Participants will examine the executor’s duties from initial appointment through final distribution, including identifying and managing estate assets, settling creditor claims, and administering distributions to beneficiaries. The course also reviews filing requirements for the decedent’s final Form 1040, the estate’s Form 1041, and the federal estate tax return, Form 706, along with the treatment of income in respect of a decedent (IRD) and basis adjustments. Participants will also examine IRS procedural requirements, including obtaining an EIN for the estate, responding to IRS notices, and recognizing potential audit risks. Emphasis is placed on practical estate administration procedures, executor liability considerations, and maintaining proper estate accounting records and documentation to support compliance with federal tax requirements. *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 terri.storer@acpen.com    

The QuickBooks Online (QBO) ecosystem is rapidly expanding, with millions of small businesses now relying on it for their accounting and business management needs. However, many QBO implementations lack adequate internal control infrastructures, which can lead to potential risks and inefficiencies. This is often due to a lack of understanding of the internal control options available in the cloud-based version of QuickBooks and how to implement them effectively. Join our session to learn about the four common types of internal controls and how to assess the internal control structure of a small business. We'll guide you through the opportunities to enhance internal controls in QBO environments using features found within the application. Additionally, you'll discover additional internal control procedures for situations where adequate controls cannot be established in QBO. Contrary to popular belief, QBO-based organizations can indeed benefit from strong internal controls, and this session will show you how. Don't miss this opportunity to strengthen your QuickBooks Online implementation and ensure your business is safeguarded against risks. Sign up now and take the first step towards a more secure and efficient QBO environment!

Risk-based factors are becoming exponentially important considerations for accountants in both public practice and industry. We examine the nature of risks for today's enterprises while exploring the role of internal controls for mitigating business risks. We also explore SAS 145 and other guidance aimed at risk considerations for professional engagements. Public and private accountants will enhance their capabilities for assessing and addressing risks faced by today's organizations. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

U.S. Department of Treasury’s Financial Crimes Enforcement Network (FinCEN) imposed a new reporting requirement that went into effect on January 1, 2024.  Millions of businesses may have to file a Beneficial Ownership Information (BOI) Report. In a surprise turn of events, the Federal District Court from the Northern District of Alabama ruled on March 1, 2024 in National Small Business United v. Yellen (“NSB”) that the CTA is unconstitutional.  This course will discuss the CTA’s provisions and the court’s decision in NSB.  Also covered will be future implications for business entities and steps to consider given the recent ruling. We will also discuss recent proposed rulemaking by FinCen with respect to nonfinanced purchases of residential real estate and gratuitous transfers so that businesses can prepare for any additional reporting burdens that might arise. **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.

In a competitive economy, CPA's  and their firms need a way to stand out. The best way to do this is to give outstanding service to your clients. In this experiential workshop, you’ll learn skills that lead to dramatic client satisfaction. In addition, you'll learn several specific ways to guarantee you'll get a lot of word of mouth referrals that will lead to a dramatic increase in your number of clients.

This is a specialized course designed for experienced accounting professionals who are looking to strengthen their interpersonal and professional skills in maintaining appropriate boundaries within and beyond the workplace. This course delves deep into the complexities of workplace relationships, personal practices, & ethical dilemmas, providing participants with advanced strategies to effectively manage professional distances and avoid problematic conflicts of all kinds. Through interactive sessions, case studies, and expert guidance, attendees will learn how to navigate sensitive situations with tact and integrity, ensuring that their professional conduct remains impeccable, and their careers continue to thrive in an increasingly complex business environment.

This course explores the transformative role of artificial intelligence (AI) in accounting and auditing, highlighting its vast potential while addressing the associated risks and ethical considerations. Participants will discover how to harness AI tools to enhance efficiency and innovation, while mitigating challenges such as overreliance, data security vulnerabilities, and ethical dilemmas. Through case studies and interactive discussions, you'll gain practical skills to navigate AI complexities, ensure trustworthy outputs, and uphold ethical standards in today's fast-paced digital environment. 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 provides a concise overview of how artificial intelligence, particularly ChatGPT and other AI tools, is transforming accounting research methodologies and practices. Students will explore the shift from traditional search engine-based research to AI-driven insights, learning how to leverage various AI platforms for enhanced financial analysis, regulatory compliance, and strategic decision-making. The course emphasizes practical applications of AI in accounting contexts while addressing critical considerations such as data verification, ethical usage, and professional judgment. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Advisors often ask clarifying questions as they increasingly gain an understanding of new and existing tax laws that govern IRAs. Some provisions see more questions than others due to their complexity, popularity, and level of impact on tax benefits. This course focuses on the top 20 of these questions and on SECURE Act 1.0, SECURE Act 2.0, and other hot topics. This course aims to help the advisor provide clients with the correct responses based on their IRA profiles.