CPE + Events Catalog

Did you know Excel has 400-500 functions depending on your version? Did you know there are 12 different function categories? Did you know you could create your own functions? After you attend this class, you will be in the know! In this webinar, we will focus on proofing and auditing your spreadsheets. You will learn how to build spreadsheets that validate the accuracy of your calculations and techniques to use the Data Validation feature to validate data entry. You will also learn techniques to cross-foot your data to ensure accuracy as well as how to use the various Excel Auditing Tools. 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.

Based on an AICPA Enhancing Audit Quality study, 23% of all single audits subject to enhanced oversight were materially non-conforming with professional standards due to failure to properly test controls over compliance.  This course will provide an overview of internal controls over compliance specifically related to Single Audits. We will discuss how to apply the concept of internal controls to various compliance requirements. Additionally, a common finding in the audits of governmental entities receiving federal grants is misidentifying controls and mistaking compliance for a control. That's why this course will also focus on identifying compliance versus controls over compliance.

Ethics and professional skepticism are a cornerstone of public accounting. This course will review the Code of Ethics for Professional Accountants that practitioners must adhere to. This course will outline the pressures, opportunities, and rationalizations that lead to instances of fraud. In addition, this class will walk through some interactive examples to illustrate various scenarios of noncompliance during engagements. 

Office Scripts are an exciting new development for Excel and other applications. Although they are like macros in some respects, most users will likely find them easier to work with. Learn how to put this powerful automation tool to use!

Workpapers are the primary support for findings, conclusions and opinions on any audit or other attest engagement.  This course will provide the essential tips and techniques for ensuring workpaper documentation is of a high quality, yet efficient, nature.

This course is an updated overview of the single audit of state and local governments and not-for-profit organizations under the OMB Unified Circular, as well as the applicable AICPA standards for compliance audits. 

A comprehensive review of the newest version of the U.S. Government Accountability Office’s Government Auditing Standards, otherwise known as “the Yellow Book.”  The standard will affect all auditors who perform audits of government and nonprofit organizations who receive federal funds, or where application of GAO standards is required by law, regulation or contract.  It does not address the standards applicable to performance audits.

The work for clients is not as linear as it used to be with the inclusion of more advisory services, more cross functional teams, and due dates moving. Quality client engagements are not just about a solid workflow, we need project management skills. In this session we will discuss how to apply project management techniques to designing a one firm, team approach to serving clients. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Recently issued accounting standard updates provide important clarifications for determining whether a not-for-profit (NFP) organization's transactions are an exchange transaction or a contribution. This course will provide those responsible for preparing financial statements for NFPs examples of the proper accounting for exchange transactions covered by ASU No. 2014-09 versus contributions covered by ASU No. 2018-08. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Most professionals routinely use Word, Outlook, and PowerPoint, but many are self-taught and, as a result, have not been exposed to the best features of these three applications. Consequently, they often use “brute force,” inefficient means when working with these three components of Microsoft Office. If that describes you, ensure you carve time out of your schedule to participate in this fourhour session. In it, you will learn how to work much more efficiently when using these tools to get better results in less time.  

Seismic changes in tax legislation is currently taking place, and the well-informed tax practitioner will want to attend this four hour program in order to stay abreast of these developments.  This program will cover 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.

Retaining Talent in a Competitive Marketplace -Creating a Benefits Program Employees Care About In today's competitive marketplace, retaining talented employees is becoming increasingly difficult. A solid benefits program can make a difference in the fight for talent - but only if those benefits matter to the employees you are trying to hire! Through statistics and case studies, this course will explore what benefits are most valuable to employees. We will also explore the basic types of retirement and health insurance plans and discuss what financial leaders should consider before adopting a benefits package. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

From understanding fraud requirements to improving risk assessment procedures, and from testing to meeting auditing standards, discover ways to audit more effectively and efficiently. Engage in discussions that cover reducing risk and effective planning, research and documentation. Review various case studies, real-life examples and sample documentation will reinforce ideas. This course meets the specific California Board of Accountancy requirements that CPAs are required to meet for re-issuance of their license. This course is one of two parts of Auditing Standards: A Comprehensive Review 2024. Please be sure to also register for Part 2.

Tax developments have been in the forefront of the news, and tax practitioner can find it challenging to remain up-to-date with these changes.  This 8 hour program will cover tax issues relating to individuals, including new court decisions, recent IRS publications, and the latest tax legislation.  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.

From understanding fraud requirements to improving risk assessment procedures and from testing to meeting auditing standards, discover ways to audit more effectively and efficiently. Engage in discussions that cover reducing risk and effective planning, research and documentation. Review various case studies, real-life examples and sample documentation will reinforce ideas. This course meets the specific California Board of Accountancy requirements that CPAs are required to meet for re-issuance of their license.

You are likely familiar with strategies for removing the Trust Fund Recovery Penalty (TFRP) or brokering an installment agreement with a Revenue Officer or ACS Representative, but what should you do and when? What happens when things break down? Who should you contact and when? This topic will help guide practitioners on getting around certain obstacles or roadblocks while working cases with the IRS. This includes best practices for contesting the TFRP, who to contact and how to prepare when negotiating installment agreements, and steps to elevate cases that are seemingly going nowhere. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Auditing Liabilities, Including Long-Term Debt - Addressing the Risks of Completeness, Classification, and Disclosure will discuss tips and techniques for auditing accounts payable, accrued expenses, and common long-term financing arrangements and related debt covenants. The completeness and proper classification of liabilities are the typical higher audit risks. The complexity of the debt financing arrangements may create a significant risk requiring more persuasive audit evidence. 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 an in-depth exploration of Form 1120S, the tax return form used by S corporations. Students will learn the intricacies of preparing and analyzing this form, including how to determine the taxable income of the S corporation, how to properly report and allocate income, deductions, and credits, and how to calculate the shareholder's basis in the S corporation. **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.

More and more entities need Yellow Book engagements, including a growing number of for-profit entities. In this course, we will review the unique independence requirements in GAGAS. We'll also review the recent changes to quality management in Yellow Book. We'll close with a reminder of common deficiencies found in Yellow Book engagements.

Ethics are of central importance to the CPA profession. But what do we mean by ethics? Is it just appropriate behavior, compliance with laws, or is it more than that? In this course, we'll discover what sets ethics apart and, therefore, sets the profession apart as well. We'll explore the tools available, the role of bias, and dive into real life case studies. We'll apply the AICPA's ethical framework and detect where bias was involved in the case studies. We'll even discover that one person set the price tag on their ethics at $53.7 million, only to lose it all in the end. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.