CPE Catalog & Events

Our session will include a discussion regarding indirect rate strategies for cost recovery.  We will cover negotiating indirect rates with pass-through entities and alternative indirect cost recovery methods. A look at applying the PPP Loan Forgiveness credit.  Understanding the definition of sub-awards and the MTDC allocation base, and where best  to allocate bonus expense.  Included in this session will be a selected review of the Uniform Guidance FAQs regarding indirect rates for States and Municipalities, as well as recently issued FAQs that impact indirect rates and cost recovery.  

With approximately 500 functions now available in Excel, some newer and more powerful tools are easy to overlook. But, if you do that, your productivity will suffer. In this session, you will learn how to take advantage of many of Excel’s more advanced features – some new and some legacy – to elevate your productivity to higher levels. In this session, you will learn about many of Excel’s newer tools, including XLOOKUP, SUMIFS, SWITCH, and STOCKHISTORY. Also included in this session are discussions of advanced financial functions, such as IPMT and PPMT, and how to retrieve summarized data easily using GETPIVOTDATA and CUBEVALUE. Additionally, you will learn how to make sophisticated calculations easier with Dynamic Array formulas, harness the AGGREGATE function's power, and create more accurate forecasts with Excel’s FORECAST.ETS function. No matter your experience working with Excel, participating in this course will help you work more efficiently and effectively in Excel.

*** This subscription includes eight individual sessions for a total of 16 CPE. You receive significant savings when purchasing these webinars as a subscription. Each of the eight courses runs live once a month beginning May 1, 2024 through April 30, 2025. Register for these scheduled courses as your schedule allows - at no extra cost to you. Once registered for this subscription, log in instructions will be emailed to you separately for each individual course. *** This subscription consists of a 16-hour audit skills curriculum for beginning auditors and attest providers, while it is also appropriate for anyone who has assurance responsibilities under the SSARS. This series covers the fundamentals of auditing, including internal controls, auditing cash, and discovering fraud.

*** This subscription includes eight individual sessions for a total of 16 CPE. You receive significant savings when purchasing these webinars as a subscription. Each of the eight courses runs live once a month beginning May 1, 2024 through April 30, 2025. Register for these scheduled courses as your schedule allows - at no extra cost to you. Once registered for this subscription, log in instructions will be emailed to you separately for each individual course. *** This subscription consists of a 16-hour audit skills curriculum for in-charge or supervisor auditors, while it is also appropriate for anyone who has audit or attest engagement responsibilities. This series covers intermediate audit skills, internal controls, and analytical procedures.

*** This subscription includes eight individual sessions for a total of 16 CPE. You receive significant savings when purchasing these webinars as a subscription. Each of the eight courses runs live once a month beginning May 1, 2024 through April 30, 2025. Register for these scheduled courses as your schedule allows - at no extra cost to you. Once registered for this subscription, log in instructions will be emailed to you separately for each individual course. *** This subscription consists of a 16-hour audit skills curriculum for supervisory and managerial auditors, while it is also appropriate for anyone who has responsibilities by finding creative audit solutions. This series covers critical audit skills including fraud trends, designing internal controls, as well as management skills for coaching staff on conducting thorough audits.

*** This subscription includes eight individual sessions for a total of 16 CPE. You receive significant savings when purchasing these webinars as a subscription. Each of the eight courses runs live once a month beginning May 1, 2024 through April 30, 2025. Register for these scheduled courses as your schedule allows - at no extra cost to you. Once registered for this subscription, log in instructions will be emailed to you separately for each individual course. *** This subscription consists of a 16-hour audit skills curriculum for experienced staff, while it is also appropriate for anyone who has the need to better understand how to link risk assessments to the detailed audit plan. This series covers common risks, as well as analytical procedures, sampling, and proper reporting methods during an audit.

How to pay for the cost of long-term care remains a primary concern for most clients over the age of 50. Explore clients' motivations, misconceptions and objections to purchasing long-term care insurance, and a look at the latest long-term care solutions, including hybrids. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Yellow Book and Single Audit engagements are considered must select engagements for Peer Review. This course will cover the Yellow Book independence requirements which are required any time an auditor is performing a Yellow Book or Single Audit even when the engagement is for a for-profit entity.  We'll take a look at the major changes in the 2024 Compliance Supplement as well as the changes to the Uniform Guidance. We'll close with major deficiencies identified by the federal agencies and peer reviewers. 

The amount of electronic content that business organizations contend with is growing at incredible rates. Terms like "Big Data" and "Information Overload", are being used by overwhelmed information workers on a daily basis. Additionally, because of the move to a much larger telecommuter footprint, electronic data is now even more prevalently utilized. This session discusses the places that businesses keep digital information and addresses the importance of securing corporate electronic data. The material effectively shows ways to achieve high security standards for content stored in fixed locations, on mobile devices and in the cloud. Participants in this session will gain an understanding of the concepts needed to improve the way they, and their companies secure digital information. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

*** This subscription includes two individual sessions for a total of 4 CPE. You receive significant savings when purchasing these webinars as a subscription. Each of the courses runs live once a month beginning May 1, 2024 through April 30, 2025. Register for these scheduled courses as your schedule allows - at no extra cost to you. Once registered for this subscription, log in instructions will be emailed to you separately for each individual course. *** Managing projects happens every day in accounting firms, but few people are educated on the principles from the field of project management. Take advantage of this project management subscription to learn best practices and then apply the lessons to enhancing ongoing client engagements. Sign up for both webinars and save 20% while having the flexibility to choose the date and time that works best for you! Leverage tips that lead project managers to achieving higher project success rates.

This course begins with a look at the GASB standards effective this year, including GASB 100, Accounting Changes and Error Corrections and GASB 101, Compensated Absences. We'll include practical application of the topics in the form of case studies. We'll then switch gears to review the GASB standards coming down the pike, including major projects of the GASB. When considering the audit side of the house, Yellow Book and Single Audit engagements are considered must-select engagements for Peer Review. This course will cover the Yellow Book independence requirements which are required any time an auditor performs a Yellow Book or Single Audit even when the engagement is for a for-profit entity. The session will also cover the changes to the Uniform Guidance. We'll close with a look at the key changes in the 2024 Compliance Supplement and the common deficiencies identified by the federal agencies and peer reviewers. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The tax landscape is constantly changing, challenging tax practitioner to stay abreast of these developments.  This eight hour program will cover issues unique to business entities, including new court decisions, recent IRS publications, and the latest tax legislation that will impact businesses and individuals.  The remaining time will be spent on IRS procedure and other issues. This course will provide a concise look at the hottest topics affecting every tax practitioner.  **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 subscription includes four individual sessions for a total of 8 CPE. You receive significant savings when purchasing these webinars as a subscription. Each of the four courses runs live once a month beginning May 1, 2024 through April 30, 2025. Register for these scheduled courses as your schedule allows - at no extra cost to you. Once registered for this subscription, log in instructions will be emailed to you separately for each individual course. *** This series is comprised of the most practical fraud investigation courses 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. Each course is a stand-alone class that may be taken individually, but for comprehensive instruction on completing a fraud investigation from start to finish, take all four.

Specifically designed for preparation, compilation, and review practitioners, this course will provide you with a comprehensive review and hands-on application for performing financial statement preparation, compilation, and review engagements. You will learn the ins and outs of applying SSARS No. 21, Clarification and Recodification, as well as the additional guidance related to SSARS engagements through the issuance of SSARS Nos. 22-26 by the ARSC. In addition to SSARS 26, the entire suite of quality management standards is discussed. However, knowing the standards is not enough. You need to be able to effectively apply them. To support this, the course will review recent peer review feedback on SSARS engagements, providing insights on how to successfully apply this guidance. Not only will this course bring you up to date on SSARS requirements and guidance, but more importantly, it will provide you with practical examples and illustrations to help you effectively and efficiently perform these types of engagements. This course is intended to be your go-to reference for training your staff and managing your SSARS No. 21-26 services in compliance with professional, ethical, and technical requirements.

*** This subscription includes four individual sessions for a total of 9 CPE. You receive significant savings when purchasing these webinars as a subscription. Each of the four courses runs live once a month beginning May 1, 2024 through April 30, 2025. Register for these scheduled courses as your schedule allows - at no extra cost to you. Once registered for this subscription, log in instructions will be emailed to you separately for each individual course. *** Join us for a 4-course subscription featuring John Higgins, a renowned technology advisor to the CPA profession, who has assisted many firms with Microsoft 365 deployment. Discover how to leverage the M365 suite of apps to unlock new efficiencies and opportunities within your firm. Don't miss this chance to supercharge your practice with cutting-edge tools! Whether you are a solo practitioner or larger firm, this series will provide you with an ROI many times greater than your investment to attend.

*** This subscription includes six individual sessions for a total of 12 CPE. You receive significant savings when purchasing these webinars as a subscription. Each of the six courses runs live once a month beginning May 1, 2024 through April 30, 2025. Register for these scheduled courses as your schedule allows - at no extra cost to you. Once registered for this subscription, log in instructions will be emailed to you separately for each individual course. *** Payroll is among the most common tasks an employer undertakes while 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. Strengthen your expertise in providing client payroll services with one of the nation's foremost authorities, and a practitioner herself, Elizabeth Bystrom.

*** This subscription includes five individual sessions for a total of 14 CPE. You receive significant savings when purchasing these webinars as a subscription. Each of the five courses runs live once a month beginning May 1, 2024 through April 30, 2025. Register for these scheduled courses as your schedule allows - at no extra cost to you. Once registered for this subscription, log in instructions will be emailed to you separately for each individual course. *** This Power BI intensive series is designed specifically for those aiming to master data management skills in the modern business environment. As data becomes increasingly central to accounting and financial analysis, the ability to effectively manage, clean, and transform this data is critical. These five courses delve into Microsoft Power BI, a tool known for its robust data processing capabilities. This series will take you from an entry-level overview of Power BI and lead you through building an actual data model for analysis. Once you have completed the courses in this series, consider taking the advanced subscription, "Taking Power BI to the Next Level".

*** This subscription includes five individual sessions for a total of 14 CPE. You receive significant savings when purchasing these webinars as a subscription. Each of the five courses runs live once a month beginning May 1, 2024 through April 30, 2025. Register for these scheduled courses as your schedule allows - at no extra cost to you. Once registered for this subscription, log in instructions will be emailed to you separately for each individual course. *** This advanced Power BI series is designed specifically for those aiming to master data analysis skills in the modern business environment. As data becomes increasingly central to accounting and financial analysis, the ability to effectively manage, clean, and transform this data is critical. These five courses delve into Microsoft Power BI, a tool known for its robust data processing capabilities. After learning how to build a data model in the previous series, this series will take you through using advanced calculations to create, manage and effectively use your data analysis. This is an advanced subscription and if you are new to Power BI or not confident using the tool, consider taking the basic series, "Getting Started With Microsoft Power BI".

Unlock the full potential of data analytics with our specialized course, "Leverage PowerBI.com to Create Data Analysis for Others". This two-hour, intensive training is specifically designed to empower professionals in harnessing the powerful features of Microsoft PowerBI.com. Whether you're a data analyst, business intelligence professional, or someone keen on mastering data visualization and report creation, this course is your gateway to becoming a proficient Power BI user. Dive into the dynamic world of data analytics and learn to transform raw data into visually compelling stories that drive decision-making. Our expertly crafted program offers a deep dive into the essentials of PowerBI.com, starting with a comprehensive tour of its interface and core concepts. You'll gain experience in connecting to diverse data sources, creating stunning visualizations, and building interactive dashboards that communicate insights effectively. The course also covers the innovative Q&A feature of PowerBI.com, allowing you to explore data with natural language queries. By mastering the art of sharing datasets, reports, and dashboards, and creating comprehensive apps, you'll be equipped to deliver top-tier data analysis solutions to colleagues and clients alike. Through this course, attendees will gain a deep understanding of how to leverage the PowerBI.com platform to disseminate datasets, reports, and dashboards, catering to the specific needs of their audience. Our course is tailored for those who aspire to lead in the data-driven landscape, offering not just theoretical knowledge but real-world applications. Upon completion, participants will not only have a thorough understanding of PowerBI.com but also the confidence to apply this tool in creating impactful data analysis for diverse audiences. Join us to elevate your professional skillset, make data-driven decisions with ease, and add a valuable credential to your portfolio. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Pro forma statements are used by businesses to make decisions on planning and control, as well as for external reporting to owners, investors, and creditors. For example, giving financial estimates for a given period in a standardized manner is known as “presenting pro forma,” a Latin phrase that means “as a matter of form.” Pro forma statements can be helpful tools for business owners, investors, creditors, or decision-makers to analyze various scenarios of future events based on certain financial assumptions. It might aid in making predictions performance of the company. A pro forma income statement displays a firm’s anticipated sales and revenue. It also highlights anticipated fixed or variable operational expenses and, in the end, displays the potential profits and retained earnings for a future financial quarter. There are various types of pro-forma statements and methods to develop them. The responsibilities/competencies of the Financial Controller position (FC) has changed in recent years. However, the creation of pro forma financial statements is still a core part of their responsibility.