CPE + Events Catalog

Analytical procedures (APs) are utilized for different purposes and can be the most cost efficient of accounting procedures. Interestingly, they are the least utilized and efficiencies are lost. Understanding the types, uses, and purposes is misunderstood by many accountants as evidenced by continual peer review deficiencies. This course is a must for anyone needing to understand the use and application and benefits of analytical procedures. This course will provide participants with hands-on techniques on how to perform analytical procedures as required by the standards in an engagement.

Join us for an insightful presentation featuring John Higgins, a renowned technology advisor to the CPA profession, who has assisted many firms with Microsoft 365 (M365) 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 "bootcamp" will provide you with an ROI many times greater than your investment to attend. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

You've probably been there. You have a client in your office with excess baggage. That's right, they're in field collection with a Revenue Officer. Now what are you going to do? How are you going to get where you want to be? This program will provide an overview of field collection, how to effectively work with Revenue Officers, general case processing, and important IRM deadlines. This will include taking a deep dive into the "RO Mindset" along with structuring your casework to flow with IRS case processing actions so you can get to the outcome you want. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Substantive Analytic Procedures - Strengthening Evidence to Satisfy Audit Objectives will provide the tips and best practice techniques for strengthening substantive analytic procedures in order to reduce over-reliance on tests of details. One of the ways to perform a more effective and efficient audit is to maximize the use of substantive analytic procedures in the detailed audit plan. Note: This course is recommended as a part of a 16-hour audit skills curriculum for in-charge or supervisor auditors, while it is also appropriate for anyone who has responsibilities for analytical procedures. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Building on Part 1, this course will review the application of sampling in financial statement audits with a focus on sampling for tests of controls. We'll also review the requirements for sampling in Single Audits with a focus on tests of controls and tests of compliance. 

This presentation will provide a detailed analysis of the Circular 230 rules for conduct of a tax practice, with a review of the political, legislative and regulatory rules impacting every accounting and tax professional. Best practices and guidance provided by the AICPA’s Code of Professional Conduct will be discussed. **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.

A project doesn't just happen, it takes a dedicated person to help a team create something from nothing. The best project managers incorporate the art of people management and science of execution to guide an initiative from an idea to reality. Not everyone can hire a project manager, so the great news is these skills and techniques can be learned. This class will show how a project manager breaks down a concept and applies techniques needed to effectively lead a team through the visioning, scoping, testing and rolling out of an initiative. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Stop struggling with PDFs! Adobe Acrobat and other PDF tools provide access to features that make working with PDF files a breeze. In this course, you will learn how to use tools and features such as PDF forms, redaction, converting PDFs to Word and Excel files, and electronic signatures. You will also learn how to create and apply tick marks, build indices, catalogs, and portfolios, and secure PDF documents to their fullest. The popularity and usefulness of PDFs increase daily, but most PDF users have not learned how to manipulate PDF documents effectively. Accordingly, they struggle and strain with these standard files. You do not need to let this be the case. Join us in this very timely session where you will learn the top features necessary to optimize your work with PDF documents.

The Not-for-Profit Advisory Committee (NAC) has been meeting with FASB to discuss the impact of various standards on the nonprofit community. In this course, we will explore the work of the NAC and the impact they've had. We then transition to the Accounting Standards Updates (ASUs) issued by the FASB that are impacting nonprofit entities, including a review of year 2 issues with respect to the leases standard including modification accounting. We will close with a look at common deficiencies found in nonprofit financials.

New features in Excel provide tremendous opportunities to improve Excel-based operational and financial reports. For example, Data Models, Power Query, Data Analysis Expressions, Power Pivot, and many others can help you create more powerful summaries and schedules in less time than ever. Bundle these tools with some of Excel’s “legacy” features, and you have significant new opportunities to improve your Excel-based reporting environments. In this fast-paced seminar, you will learn about the importance of using Power Query to link data into Excel data models and how you can manage these data models to facilitate better and more efficient reporting. Additionally, you will learn how to incorporate Key Performance Indicators, Slicers, and Timelines into your reports to enhance the analytics and understandability of the data. Further, you will learn best practices to quickly and easily format your spreadsheets to give them a polished and professional appearance. This course should be at the top of your professional development list if you use Excel for any reporting process.

You don’t need an accounting degree to harness the power of Microsoft Excel. This course shows how Excel makes sense beyond dollars and cents. We will focus on fundamental concepts for creating, editing, and utilizing Excel content. Participants will learn how to use Excel’s menus and other functions to craft Excel workbooks. Because this course is designed for newer users, we intentionally offer a broad overview of Excel’s numerous capabilities with in-depth coverage of selected resources tailored for non-accounting applications.

This course provides tools and insights into financial statement analysis - both quantitative and qualitative. We'll look not only at the three main financial statements but also dive into the MD&A and footnotes. We'll also discuss the affect of industry nuances on comparability of different analysis tools. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The final webcast in this series focuses on the special rules that apply when a fiduciary entity invests in real estate or other passive activity assets, elects the 65-day rule, makes specific bequests to beneficiaries or incurs alternative minimum tax (AMT). The underlying statute for AMT is written for individual taxpayers and the fiduciary or adviser must apply the statute to the special rules and calculations that determine fiduciary taxation.

Karen L. Hawkins, the former Director of the IRS Office of Professional Responsibility, will discuss key Circular 230 provisions and how some have been changed through litigation. Since the current version of Circular 230 has not been rewritten to incorporate the results of IRS litigation losses since 2014, this is the only seminar where you will hear what the current law says (and does not say) about tax professionals' ethical obligations in federal tax practice. The presentation will draw not only on the six years Ms. Hawkins spent as Director, OPR but her more than 30 years practicing as a nationally recognized tax controversy lawyer in California.

When real property is sold for a gain, we always try to find ways to defer recognizing income so it won't be necessary to send a check to Uncle Sam. There are two provisions within the Internal Revenue Code that allow the taxpayer to defer recognition of immediate taxable gain in the year of sale: installment sales and like-kind exchanges. Knowing how and when to utilize these provisions makes the Accounting and Finance Professionals very valuable to either their client or the entity they work for. We will also discuss recent proposals which could impact the future of these two provisions.

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 session will identify the progress of the AICPA Enhancing Audit Quality Initiative and evaluate whether audit quality is improving. Analyze the trends that are contributing to audit quality and recall the major issues identified and the related resources issued by the AICPA to improve practice quality. This session will also analyze the AICPA's new Statements on Quality Management Standards (SQMS). It will identify the related implementation challenges and timing and evaluate the potential impact on peer review. Learn about AICPA resources for SQMS implementation. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Payroll is among the most common tasks an employer undertakes in the course of 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 pull back the curtain, there is so much more to payroll, including various kinds of compensation, payroll taxes and required reporting on various government forms. This course will provide a general introduction to the payroll cycle of life, including real life examples of how to process payroll, the withholding and payroll tax deposit regime, common payroll forms, and tips and tricks for tying it all together. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The Professional Ethics Executive Committee (PEEC) of the AICPA has been very busy issuing new and updating existing ethics rules. This course will provide an overview of recently issued and soon to be effective ethics rules that CPAs in both industry and public accounting need to know to be compliant.

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.