CPE + Events Catalog

Budget methods are the key to allowing department managers to efficiently prepare their budget in Excel. For example, a budget method may be to spread prior year actuals or match prior year actuals, or match prior year actuals less 10%. In this webinar, we will explore how to allow users to pick a budget method from a drop-down list for each account and then have Excel perform different calculations depending on the budget method selected. We use several features and functions at the same time to pull this off. Even if you are not involved in the budgeting process, the underlying features and functions discussed have a wide range of uses.

Get ready to elevate your tax game with the 2025 Business Tax Update, designed exclusively for tax practitioners looking to sharpen their skills in business income taxation. This course doesn't just scratch the surface – it thoroughly explores the complexities of the tax code, ensuring you're equipped to navigate the ever-evolving tax landscape with confidence. From recent legislative updates to complex tax considerations like COVID-19-related subsidies, this course covers it all. Gain practical strategies and insights that you can immediately apply to assist your clients in optimizing their business income tax planning. Don't miss this opportunity to stay ahead in business taxation and enhance your expertise in a rapidly changing regulatory environment. With a focus on real-world application and comprehensive exploration of essential topics, the 2025 Business Tax Update promises to be a game-changer for your tax practice. Whether you're dealing with partnership, corporation, or LLC taxation issues, this course provides precise guidance tailored to diverse business clients. Plus, you'll gain invaluable insights into recent legislative changes, including their implications on tax code sections like Section 199A. Stay at the forefront of business taxation and ensure you're delivering top-notch advice to your clients by enrolling in this essential course today. **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 course has significantly changed for the better the lives of a significant number of practitioners and their clients. Participants will learn a step-by-step process for performing an annual personal financial health checkup for themselves, family members, employers, and, if in the practice of accounting, their clients. This course is loaded with practical aids to enable CPAs to help individuals get a "great" financial health checkup result! This course will enable practitioners to add a huge value to their tax preparation services. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

ESG, environmental, social, and governance, is a buzzword that is not only gaining traction but will be mandatory for a company's continued success. So what is ESG? What does it mean? Why is ESG important? What is the ROI of adopting ESG? Who should lead our ESG initiatives? How do we get started? These questions and more will be answered in this fast-paced session that will explain the ABCs of ESG. We will also outline a framework to begin your ESG journey. 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. 

The SSTS are tax standards that apply to all members who provide tax services and provide the framework for the AICPA ethical guidance for tax practitioners.  This program explores the revised AICPA Statements on Standards for Tax Services, effective January 1, 2024.   **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.

The role of financial professionals has and continues to change in organizations. The stereotype of collecting and reporting data has been replaced by a broader vision, which focuses on improving an organization's results today and preparing it for the future. This brief program offers specific actions that can be implemented by financial personnel to expand their role through improving their organization. The actions and techniques provided build upon and improve activities that exist in many organizations (measuring, budgeting, hiring, risk management, etc.), as well as providing insights into capital allocation, cash management, valuation techniques, variables that influence capacity levels, M&A activity and actions to increase efficiency and innovation. Updated to include the impact of regulations, additional examples of M&A, alliances and strategic spin-offs/splits, methods to improve efficiency from existing activities, the impact of COVID-19, as well as current organizational changes employed to manage and accelerate growth.

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, as well an overview of K-2 and K-3 reporting requirements and effective dates. **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.

We have all heard the statement that it is the people that work at a company that gives it value. It is, sometimes and unfortunately, also the people that provide fraudsters with an entry point into an organization that can lead to hardship. This is even more true now because cyber-attacks on both organization and individuals have increased notably. Many highly publicized corporate hacking events are successful, at least in part, because an individual was targeted. In this session, we look the types of fraud that take aim at individuals with a special focus on the growth of cyber-attacks. We then discuss measures that can be put forth to help employees protect both themselves and the organization. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

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.

Excel has over 500 functions that are built-in and ready to use. You just have to figure out which one to use and when. Integrating functions into each and every one of your spreadsheets not only improves efficiency, it also makes your task easier to execute. In this webinar, we will focus on Logical, Information and Lookup & Reference functions. In the Logical function section, you will learn to perform logical test using the IF function along with AND, OR and NOT. In the Information function section, you will learn various ERROR checking functions that can be combined with the Logical functions. In the Lookup & Reference section, you will learn to use the various LOOKUP functions and INDIRECT function. This session is presented using Excel 2013. Regardless of the version you are using, ALL concepts covered in this course apply to ALL versions of Excel. 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 addresses the role of client internal controls for balancing efficiency and effectiveness in a risk-based audit. Practical insights regarding an auditor's assessment of the risk of material misstatement when auditing financial statements of non-issuers will be explored, with particular emphasis on internal controls of small-to-medium clients. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event. This event may be a rebroadcast of a live event and the instructor will be available for your questions during the event.

This course will cover updates on GASB-related pronouncements, exposure drafts and future agenda items. Participants will learn to master GASB 34 and study the new GASB Pension and OPEB Standards in exercises using actuarial accounting valuations and the resulting note disclosures. Concepts will be reviewed using a California City's Annual Comprehensive Financial Report, including basic financial statement formats, reconciliation of government-wide financial statements to the fund's financial statements, note disclosures and infrastructure capital assets.

Basis is a fundamentally important issue when dealing with pass-through entities, as it impacts the equity holder's ability to deduct losses and/or receive distributions without a negative tax impact. As well, distributions from the different types of pass-through entities are subject to differences in treatment that can have a major impact on the tax liability of the client. This course will look at the rules on calculating basis, limitations on loss deductions (including at-risk rules), and the treatment of distributions.

Auditing Cash - Applying Basic Skills to the Starting Point of Any Audit demonstrates how the approach to auditing different cash accounts may vary and how to strengthen inquiry which is an important audit procedure in this area. Cash tends to be one of the first areas assigned to new auditors, as there is typically little complexity and subjectivity involved. In addition, persuasive audit evidence from a third-party is generally available. However, research shows that around 80% of asset misappropriation relates to cash. Therefore, the audit of accounts and classes of disclosures related to cash and cash equivalents does tend to carry some level of risk of material misstatement. Note: This course is recommended as a part of a 16-hour audit skills curriculum for beginning auditors, while it is also appropriate for anyone who has responsibilities for auditing cash and cash equivalents. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

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.

Clients are living longer. Not only does that present challenges to the work we do with them to make sure that their money lasts, but it also brings into play additional issues and challenges that we may not have had to tackle in the past. How do we plan for where clients will live (possibly as solo agers)? How do we deal with issues of diminished capacity? How do we plan for long term care and end of life issues? How do we have complicated family conversations? How do we make sure that our clients have their best long lives possible both financially and otherwise?  Find out in this session where we will present tools you can use with clients to engage them in the planning process.

The course helps the forensic accountant prepare to perform a fraud investigation. We discuss occupational fraud schemes and their characteristics, and how to spot a fraud in progress. You will learn the skills a fraud investigator needs for successful investigations, as well as how to plan and prepare for a fraud investigation. This is the most practical fraud investigation course you will ever take. Rather than learning only the theory of fraud, you will learn how a forensic accountant actually investigates fraud from the beginning to the end. We focus on forensic accounting techniques used in the field to prove what happened, who was involved, how much money was stolen, and where the money went. Becoming a Fraud investigator is Part 1 of a series of four courses on fraud investigations. Each course is a stand-alone class that may be taken individually. For comprehensive instruction on completing a fraud investigation from start to finish, take all four. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Working from home presents both benefits and challenges for professionals. For employees, working from home provides opportunities to be more productive and gain time that would otherwise be spent commuting to and from the office. Employers who utilize remote work enjoy fewer fixed costs, more efficiency, and greater employee satisfaction. Without proper planning, professionals who work remotely may experience increased anxiety and disorganization. They may also jeopardize data privacy. However, when executed properly, working remotely can help organizations become more efficient and profitable, while at the same time improving employee morale. This course looks at how firms and companies have successfully implemented work from home programs and discusses mistakes that can be avoided through proper planning.