CPE & Event Calendar

Do you ever import data into Excel, and then spend a bunch of time manually preparing it for use? Perhaps you delete extra columns or rows. Maybe you need to split a single column into multiple columns, or, combine multiple columns into a single column. The good news is that many of these transformations can be fully automated with Excel! The Get & Transform tools built-in to Excel 2016 for Windows, formerly available as the Power Query add-in, are incredibly powerful. At a high level, they enable us to retrieve data from a variety of sources and prepare it for use as needed. In this session, we'll use Get & Transform queries to help with several common tasks, including flattening data, splitting and combining columns, formatting data, unpivoting summarized data, and combining several csv exports. If you frequently export/import data from one system to another, you will want to understand how to use a Get & Transform query to streamline your work.

Managerial accounting provides economic and financial information for managers and other internal users. Managerial and Financial Accounting have similarities and differences. Each field of accounting deals with the economic events of a business. Both managerial and financial accounting require that a company’s economic events be quantified and communicated to interested parties. This another course in our series on the controller’s role. The controller’s role encompasses many traditional functions. Within this segment of our controllership series, we discuss the area of managerial accounting and the basic concepts that surround this discipline as it primarily relates to cost accounting issues.  

There is a lot of buzz and rules of thumb about Roth strategies, but very little discussion on what the fiduciary-level analysis methodology should be. This course will provide insights on creating and evaluating an analysis and recommendations with targeted vetting questions. Rules of thumb can sometimes be detrimental, causing families to pay much more in taxes over their lifetimes than necessary. A very significant portion of the population is prevented from executing a straight-forward Roth Contribution due to the income restrictions. What was once a risky way to thwart that rule has now become accepted, and many clients can benefit. These contributions should typically take precedence to saving to a brokerage/taxable account, but there are some steps that need to be addressed to prevent unwanted taxation. In addition, you'll learn about the mega-backdoor Roth. SECURE 2.0 includes many new rules, and some of them address Roth IRA/401k. We'll cover these and how they can help your clients.

If there is a potential error, the IRS will assess a tax and add a hefty penalty, without even knowing the facts. As a tax professional, you will be exposed to the IRS and their methods of penalizing taxpayers for the smallest of violations. This presentation will focus on the rules and regulations that create the penalty, and the reasons that exist that the IRS will consider to remove those penalties. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Managing expenses is a key for business success, and overhead costs play a pivotal role in realizing favorable profit margins. Almost all companies have some form of overhead consisting of specific categories of indirect expenses. The better organizations are able to manage overhead costs, the more competitive they are in the marketplace. It is incumbent in the Controller’s role to effectively manage, monitor and perform ongoing assessment of overhead costs, allocations and rates. Overhead refers to the ongoing business expenses not directly attributed to creating a product or service. A company must pay overhead on an ongoing basis, regardless of how much or how little the company sells. It is important for budgeting purposes but also for determining how much a company must charge for its products or services to make a profit. Overhead can be fixed, variable, or a hybrid of both. There are different categories of overhead, such as administrative overhead, which includes costs related to managing a business. In short, overhead is any expense incurred to support the business while not being directly related to a specific product or service.      

Stay current on the latest accounting developments affecting not-for-profit organizations with this timely GAAP update. This course reviews recently issued Financial Accounting Standards Board Accounting Standards Updates (ASUs) impacting NFP financial reporting, along with standard-setting projects currently in the FASB pipeline. The course also introduces the International Non-Profit Accounting Standard (INPAS)-the first comprehensive global accounting framework designed specifically for non-profit organizations, launched in October 2025. Participants will gain perspective on the purpose and structure of INPAS and how it compares conceptually to U.S. GAAP requirements for NFPs. This course is designed to help practitioners, financial leaders, and auditors of not-for-profit organizations understand both current GAAP requirements and emerging global developments shaping the future of nonprofit financial reporting. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Every month, a new international tax topic. Join the Hodgen Law team live'fresh insights, straight from the source. Check back for specific topics, as they're updated monthly. 2026 Dates: May 29, June 26, July 31, August 28, September 25, October 30, November 20, December 18 2027 Dates: February 26, March 26, April 30

Today’s economy and all of the digital enhancements have impacted the way companies engage with their customers as well as how the company manages their internal practices. The business control function needs to keep pace. The rising importance of analytical capability is critical when defining the role of the modern controller. Execution of analytics can vary but there are still key questions that must be asked. What are the options and what we need to understand to decide the best way forward? This course focuses on the value that can be brought by the Controller when becoming involved with data analytics powered by technology and also Big Data. The digitized world we live in has made it important for the Controller function to evolve and take on this advanced task.  

Sarbanes-Oxley legislation. Although there have not been any changes in the legislative concepts of the law since its release in 2002, some aspects of executing the work have evolved. Sarbanes-Oxley was passed in 2002 and year one of attestation for publicly traded companies was 2004. Years later the legislation continues to challenge companies, auditors and compliance professionals when evaluating a company's control structure. SOX 404, although the most prominent, is only one of the many requirements covered under the legislation. In addition, the impetus of COSO 2013 has re-focused companies' efforts on evaluating their key controls. Companies must continually evaluate whether they have designed and identified the proper controls and have adequate tests in place to determine control efficiency. With the evolution of technology solutions, the impact of information systems changes must be continually evaluated to ensure controls are adequately addressed. 

In today's challenging talent market, accounting firms face unprecedented pressure to retain their best performers. This course provides actionable, research-backed strategies to help firms keep their top talent from leaving. Based on comprehensive surveys of both current accounting professionals and those who have recently left the profession, participants will learn the real reasons employees stay or go-and what firms can do about it. The course goes beyond simple solutions like "pay more, expect less" to explore comprehensive retention strategies including whole-person compensation, work-life balance improvements, career development pathways, and necessary business model transformations. Participants will discover why 73% of surveyed professionals want to stay with their current firm, yet many still leave-and how to bridge that gap. Key topics include understanding the true cost of turnover versus retention, implementing flexible work arrangements that actually work, creating meaningful career paths for non-partner track professionals, and transforming firm operations to support both profitability and employee satisfaction. Special attention is given to retaining diverse talent and adapting to the expectations of younger professionals who will comprise 27% of the workforce by 2025. Whether you're a firm leader, HR professional, or manager responsible for team retention, this course provides the insights and tools needed to build a sustainable talent strategy in an evolving profession. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Artificial Intelligence (AI) is rapidly transforming industries and redefining how organizations operate. While the benefits of AI-efficiency, automation, data-driven insights, and innovation-are significant, the risks are equally profound and demand careful consideration. AI introduces a range of technical risks, such as bias, lack of transparency, data dependency, and vulnerability to manipulation. Ethical risks arise in the form of workforce disruption, diminished accountability, potential misuse, and the erosion of human autonomy. On a broader societal scale, AI threatens to widen inequalities, accelerate disinformation, and erode trust in institutions, while raising concerns of cultural homogenization and disproportionate power concentration among a few entities. Governance challenges further complicate the landscape, as regulation struggles to keep pace with technological advances, and questions emerge about the long-term safety and alignment of advanced AI systems. Leaders and organizations must recognize that AI is not only a technological innovation but also a strategic risk management issue. Responsible adoption requires robust governance, transparent and ethical frameworks, ongoing monitoring, and human oversight. By proactively addressing these risks, organizations can balance innovation with accountability, safeguard trust, and position themselves for sustainable success in an AI-driven future. Note:  This is Part 1 in a two-part series on the risks of AI

An operational audit is a method of examining how an organization conducts business. It identifies areas where an entity can improve to be more effective and efficient. This course will focus on how to plan and perform operational audits, as well as delivering value-added recommendations as a result.

Unlock the full potential of your Microsoft 365 subscription with our exclusive session on Microsoft's Power Tools! Discover the incredible capabilities of Power BI, Power Query, Power Pivot, and Power Automate, and learn how these tools can revolutionize your productivity and efficiency. Many professionals are unaware that they already have access to these powerful tools, leading to missed opportunities and suboptimal performance. Don't let this be you! Participate in this session to explore the practical applications of these tools and elevate your productivity and internal control structure to new heights

According to a 2020 AICPA survey, advisory and consulting services were considered the greatest unmet needs of clients. The recent growth in Client Advisory Services (CAS) has led many to ask what is included in this broad category as well as how to develop the services for clients. With so much focus on the recent success of CAS offerings, now is the time to learn how the services differ from what you currently offer, which of your clients would benefit most, and what you need in place to add a quality CAS program to your firm's menu of services.

Be the go-to person on financial statement compilation and preparation engagements. Specifically designed for those performing preparation and compilation engagements, this course will provide you with a hands-on application for performing preparation and compilation engagements under AR-C Section 70 and 80, respectively. You will learn the ins and outs of relevant sections of the SSARS related to preparation and compilation engagements with a focus on how recently issued updates to SSARS No. 21 impact these engagements. More importantly, you will be provided practical examples and illustrations to help you effectively and efficiently perform those engagements, including a detailed discussion of the reporting requirements under AR-C 80 related to compilation engagement. Lastly, the course will review recent peer review feedback on these types of engagements, highlighting areas where you can improve engagement quality.

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.

The term "artificial intelligence" (AI) has become mainstream and while most have a layperson's understanding of AI, few know the depth and breadth of this technology's capability. AI is affecting just about everything in business and in people's personal lives. The operation of an internal control system is also changing because of this incredible advancement. This session explains what AI is and how it works and then goes into detail about how it can be applied to a system of internal control. The material speaks about changes occurring in today's world as well as what's coming in the not-too-distant future. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

It's been 20 years and counting since the Sarbanes-Oxley legislation was passed. In theory the legislative requirements outlined are still in place. Although the requirements haven't changed, time has changed and as a result, execution of the processes has most likely changed.

What does fraud look like? It depends. What may appear to be an indicator of fraud in one client’s operation could be normal in another, making it critical to understand your client and the transactions you expect to see. Look for what should be present but isn’t—and for what is present but shouldn’t be. This course emphasizes the importance of professional skepticism, which has no on/off switch—it must be applied continuously. As auditors, our role is to independently verify, yet too often we rely on client representations without sufficient validation, increasing the risk of missing fraud. Many auditors recognize, in hindsight, that they have encountered fraud indicators but failed to identify them at the time. This session will provide you with the tools to recognize those indicators and strengthen your ability to detect fraud—so you are better prepared for what you may find.

One of the important roles of any member of the financial team. Including the controller, may be involvement in the preparation of the company’s financial statements. Even if that responsibility falls within the office of the CFO, the controller and other finance personnel must understand how their transitions recorded impact the financial statements. Financial statements (or financial reports) are formal records of the financial activities and position of a business, person, or other entity. Relevant financial information is presented in a structured manner and in a form which is easy to understand. They typically include four basic financial statements accompanied by a management discussion and analysis: A balance sheet or statement of financial position reports on a company's assets, liabilities and owners’ equity at a given point in time. An income statement may have varying names including profit and loss report (P&L report), statement of comprehensive income, or statement of revenue & expenses. These report on a company's income, expenses, and profits over a stated period. A profit and loss statement provides information on the operation of the enterprise. These include sales and the various expenses incurred during the stated period. A statement of changes in equity or “statement of equity” also called “statement of retained earnings” reports on the changes in equity of the company over a stated period. A cash flow statement reports on a company's cash flow, particularly its operating, investing and financing activities over a stated period. A balance sheet represents a single point in time, where the income statement, the statement of changes in equity, and the cash flow statement each represent activities over a stated period. For large corporations, these statements may be complex and may include an extensive set of footnotes to the financial statements, management discussion and analysis and supplementary information. The notes typically describe each item on the balance sheet, income statement and cash flow statement in further detail. Notes to financial statements are considered an integral part of the financial statements.