CPE Catalog & Events

You have used Excel for years and perhaps Lotus 123 before that. And through all that time, you have repeatedly said, “One day, I’ll learn how to write macros.” Finally, that time has arrived because this four-hour program will introduce you to the wide world of Excel macros and Visual Basic for Applications (VBA). This course teaches the fundamentals of creating and working with macros in Excel and is designed specifically for those with little experience working with macros. More specifically, taking this course will teach you how to use Excel’s Macro Recorder to write simple yet effective macros. You will also learn how to secure and share macros with other Excel users and create user-defined functions to solve specific accountant-centric problems in Excel. Further, you will learn how to create macros that run when a user opens a workbook and VBA basics. Don’t miss this unique opportunity to learn how to begin working with macros – one of Excel’s most powerful tools.

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 need for a forensic accountant has grown in the last two decades, with more expected in the future. From oil well spills to divorces - from stealing trust funds to partnership disputes - forensic accountants are needed to find and calculate losses. They are financial detectives that are needed to explain the money story to attorneys, judges, and juries. If you are interested in starting a forensic accounting practice or adding on this service to your existing firm, this course is for you. In this presentation, you will know what service to provide possible clients, how to find those clients, and the cost-effective ways to start the forensic accounting practice. Your instructor has over 20 years of experience as a special agent with IRS-Criminal Investigation where he conducted investigations into tax and money laundering crimes across the globe. After his successful investigative career, he started a CPA firm from scratch that focused on forensic accounting. He shares the successes and failures in starting a forensic accounting practice, including getting the right credentials, various ways of marketing to potential clients, closing the deal with engagement letters, and delivering the service to the client. 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 will cover all pronouncements of the FASB relevant to nonpublic entities. It will be presented in two distinct sections: First, we will identify all Accounting Standards Updates (ASUs) issued by the FASB in 2023 and 2024, as well as those ASUs issued in prior years that become effective in 2024. For each pronouncement, we will identify the topic or topics affected, the most significant provisions, how the provisions affect financial reporting and disclosure, and, when possible, the reasons for the change. This will enable those associated with the GAAP financial statements of nonpublic entities to determine which pronouncements affect them or their clients, requiring further research. In the second segment, we will look at the most common financial statement elements that have changed in recent years. It will include an in-depth analysis that will demonstrate how these elements have traditionally been accounted for and how they have evolved, concluding with the current requirements for reporting and disclosing.

Would you like to find important documents in 10 seconds or less? Would you like to ensure your digital information is safe and secure? Would you like to improve workflow efficiency? Of course, you would, and with some planning and guidance, you will realize these and other benefits of a paperless office. Naturally, no one expects a fully "paperless" office, but reducing the amount of paper we shuffle can offer tremendous rewards. This course will teach you the best practices and proven processes for effective document management. Participating in this program will teach you how to implement simple, inexpensive document management systems at an individual, workgroup, or small business level. You will also learn about sophisticated and comprehensive document management systems appropriate for larger offices and organizations, including systems with automated workflow processing. Your instructor will guide you through issues such as digitizing paper files, exporting and importing data from specialized applications into a document management system, essential hardware and software considerations, and the policies necessary to facilitate a successful office. Upon completing this course, you will have a comprehensive understanding of your options and a clear direction for implementing your version of the Paperless Office.

Though many clients see Social Security as a government benefit, it is a covered worker's investment asset to be managed like any other asset. Examine issues like how Social Security benefits are calculated, identifying benefit-claiming strategies, and what spouses can do now to maximize benefits at retirement. You'll learn how Social Security works and explore common planning situations-including workers with and without spouses, sandwich-generation families with dependent parents and minor children, and surviving and/or divorced spouses-and techniques to maximize your clients' benefits.

This session revisits managerial accounting techniques that you may not have considered for many years, even though they could be invaluable for CPAs in both business and public accounting. You will appreciate a fresh perspective of concepts you may not have considered since your college days. We will illustrate concepts with practical examples that you can immediately bring back to the office! This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Designed for accounting and attestation practitioners at all levels in both public accounting and business and industry, this course provides a comprehensive review of recent standard-setting activities of the FASB and AICPA. In addition to providing a detailed review of SAS No. 145, this course will bring you up to date on FASB and AICPA standards issued over the past few years. The course also provides many hands-on examples and illustrations to help you apply the guidance in practice. In addition to a financial accounting update, the course will discuss what you will need to do differently as you adopt new audit standards 142-149 over the next few years, including a detailed review of the new audit requirements under SAS 142. The course will also cover the key changes related to SSARS No. 25. Finally, the course reviews the AICPA's quality management project. In summary, the course is your go-to source for all things A&A and will prepare you for your upcoming engagements throughout the rest of the year.

In this continually revised course, tax advisors will be fully updated on the most recent enacted legislation and IRS guidance, as well as major trends on the horizon with a view toward planning considerations. This update course is designed for all practitioners, both those working in public accounting as well as those in private industry, who need the latest information on tax changes. Please Note: Due to content overlap, it is recommended that this course NOT be taken together with BITU.

Unlike a traditional financial audit objective (Are the financial statements materially misstated), performance auditing can address a wide variety of objectives.  Is this program working? Can it be improved? Where can we save money? How can we operate more efficiently and effectively? Are management’s assertions supported? And so forth.  This session will explain what a performance audit is, describe the applicable standards, and provide examples that indicate the value of a performance audit.  Performance audits can add value to any entity and practitioners can profit from adding these assurance services to their practices.

External auditors understand concepts like materiality, reasonableness, and risk of material misstatement.  This course will explain how to think like an auditor when preparing and fairly presenting your financial statements and related disclosures.

Nonprofits face unique accounting challenges. This course will introduce attendees to the financial statements and unique accounting principles applicable to not-for-profit organizations. Specifically, we will focus on the typical transactions and account balances unique to NFPs, including net assets, agency transactions, contributions, endowments, and programmatic investments.

Every business has risks, but some myths seem to damage or kill more enterprises than others do. This session will review ten of the most problematic myths that may doom a business and discuss action steps to prevent these myths from holding your business back. This session discusses the common myths, mistakes, risks, and hidden landmines inherent in every business. We will learn from the mistakes of others who often paid a steep price so that we may learn valuable lessons. If you are a leader who wants your business to become even more successful, this session is for you.

Transforming your practice or business to a digital model is a journey, not a destination. There are some digital initiatives that require a great deal of time and money to deploy. There are also many "low hanging fruit" initiatives that are relatively easy and inexpensive to deploy. E-signature software is a perfect example of the latter. John Higgins, a nationally recognized leader in accounting technology, will guide you through the process of evaluating, selecting and implementing e-signature software to streamline a solution, and secure your document signing processes. You will be surprised to discover how easy it is to take your engagement letter and contract signing workflow digital. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Does your firm have interest in expanding its’ services beyond traditional CPA services?  Do you have staff with the expertise to compete against non-CPA firms? Welcome to a course that will lead you through the maze of creating a successful Consulting Business Practice for your CPA firm. The course will help you understand: where consulting business opportunities exist, what are the firm’s professional responsibilities and most importantly how to recognize the needs of the client.

Welcome to a course that makes the process of M&A easy to understand and easy to implement within your organization or your clients' organization. The course will provide an intensive overview of the M&A process. Focus will be on practical techniques to guide you through the M&A jungle and avoid the traps that have befallen many organizations.

This program examines the critical issues, rules, and special opportunities when preparing your clients' Form 1041 US Income Tax Return for Estates and Trusts. Learn what is considered taxable income; filing requirements and deadlines; impact of the 3.8 percent Medicare surtax on net investment income; and the 10 principles of tax accounting for trust income. **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 IRS has recently increased the pressure on how to calculate and report partner and shareholder basis.  Changes in the forms reflect these developments.  This program provides a detailed analysis of the calculations related to determining tax basis for a partnership interest and S corporation shareholder shares and loans. How to use the Form 1065, Schedule K-1  and Form 1120S, Schedule K-1 information for basis determination.  Illustrated examples with filled in forms will demonstrate how the processes works and their many potential pitfalls.  **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 business accounting solutions have never been better, with many fantastic options. In this session, you will learn about the relative strengths of these platforms so you can make the right choice when selecting and implementing a solution.

If you supervise preparation, compilation, and review engagements, this course is designed to assist you in adhering to professional standards, informing you of the latest developments and pertinent issues relevant to these engagements. Gain insights into the U.S. business economy, peer review practices, FASB updates, and various aspects that influence preparation, compilation, and review engagements.