CPE + Events Catalog

As spreadsheets evolve, so must your practices for creating, editing, and auditing them. In this program, you will gain an in-depth understanding of the best ways to work with Excel by learning best practices associated with Excel spreadsheets in each of the following areas: creating and editing Excel workbooks, securing Excel workbooks, collaborating with others in Excel, and reporting on data contained in Excel. Today’s best practices for Excel differ significantly from those used in the past, and you will learn the best ways to work with Excel spreadsheets in this “must-see” CPE program. Course materials include relevant examples to enhance your learning experience. Join us for this program to help you utilize Excel to its fullest potential.  

This program addresses the most recent developments impacting partnerships operating as LLCs, with a focus on legislative, administrative, and tax form changes. Emphasis will be placed on partners "tax basis" capital accounts, now required for tax form reporting. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Sampling is often identified as a common audit deficiency in peer review. This course will review when is sampling applicable and basics of planning a sample. We'll then focus on the application of sampling in financial statement audits with a look at sampling for substantive procedures. We'll look at the use of monetary unit sampling and tools that can be leveraged to reduce bias in sampling.

This course will serve as an introduction to conducting effective walkthroughs to gain an understanding of the client's transaction processes as well as identify internal controls within each process. This course will review the procedures, questions to ask, and documentation requirements of walkthroughs. It will also include real-world examples of the red flags that may arise while executing a walkthrough. 

This program addresses the critical issues and special opportunities facing S-corporations, with a focus on reporting shareholder basis and distributions.  **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.

Small businesses have better options now than ever before in the market of accounting solutions. Participate in this session to learn more about these options and which might be best for you or your clients.

Cover the basic requirements of a peer review performed in accordance with AICPA's Peer Review Standards for firms that perform preparation, compilation, and review engagements. Topics include the documents reviewed by peer reviewers, the evaluation of the engagements, types of matters and peer review reports, the administrative process, peer review committee involvement, and requirements of the state boards of accountancy. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This program provides an update to the latest tax developments, rules and regulations affecting business taxpayers, including a review and integration of 2023-24 legislation.   **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.

Payroll is everywhere. It is one of the most common tasks an employer can perform and can be found embedded in nearly every facet of the business and individual tax realm. For many, it is something they encounter regularly, but without any knowledge of how it really works, so it remains a black box. Join us as we un-box the Top 10 most commonly asked questions about payroll from an employer perspective. We'll cover the answers to questions you didn't even know you had and build on the fundamentals of payroll that will help make that black box a bit more transparent. 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 explores the increasingly complex features of Excel that facilitate efficient data analysis.  We will introduce numerous analytical methods and techniques by using practical examples to illustrate how to unleash the power of Excel when manipulating, analyzing and reporting information.

Charts and graphs are nothing new. However, many professionals struggle with building compelling visualizations. If that statement describes you, participate in this session to improve your skills in creating Excel charts and other visualizations. As a result, you will create visualizations to enhance your communication skills. This session is much more than just a seminar on fundamental charts. Instead, in this session, you will learn how to create advanced charts that are interactive, dynamic, and aesthetically pleasing – three qualities that will help to ensure that your readers and audience will understand the data you are presenting. This seminar is a must if you want to improve your communication skills.

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.

AI is an extremely popular topic these days, and for good reason! However, does AI present yet another threat to your privacy? Get answers to this question and more in this session.

During this presentation, the most common mistakes made by employee benefit plan auditors, as well as, plan sponsors will be identified. Best practices for handling specific issues that arise during the course of the engagement will also be explored. This discussion will help auditors recognize potential pitfalls in audit procedures/documentation and assist plan sponsors with compliance issues.

This course will dive into the fundamentals of fiduciary accounting and provide a reporting guide for determining whether receipts and expenditures are assigned to income or principal/corpus. 

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.  

Understanding the dynamics of family interaction is one of the most important skills in helping a family business succeed. This course takes a candid look inside the family business, and will help the participant navigate delicate issues while learning to provide counsel that will grow - or protect - the family business and non-family staff.

Gear up for tax season with Steve Dilley's annual update!  This program provides an update to the latest tax developments, rules and regulations affecting both business and individual taxpayers, including a review and integration of 2023-2024 legislation.    **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.

AI is an extremely popular topic these days, and for good reason! However, does AI present yet another threat to your privacy? Get answers to this question and more in this session.

In this course, we will share tips and tricks for working remotely.  You will learn what to do/what not to do in a virtual working environment, strategies for leading teams remotely, employee engagement ideas, and techniques and tools for teleworking.