CPE + Events Catalog

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 section of the 4-part series will cover fundamentals of Form 706 with numerous examples of how to properly report deductions on the estate tax return, including the marital and charitable deductions.

Fringe benefits are just another way of paying your employees. Do you know how to correctly track fringe benefits, as well as apply and report the various withholding tax rules for those fringe benefits? The IRS says fringe benefits must be included in and reported as a part of employee pay, but with any good tax law, there are always exclusions to that rule. Knowing how to handle fringe benefits can be complicated, especially in an area that changes on an annual basis. Attendees will leave with an understanding of what the requirements are around fringe benefits, what constitutes a fringe benefit, and whether it is taxable or not. We will also explore the evergreen areas of reporting S-Corp Shareholder Health, HSA, and when cash is not taxable compensation. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Making the S-election avoids double taxation for corporate operations after the election is effective. Consider the special rules related to adjusting the stock-adjusted basis, distributions and loss limitations. Rules surrounding the S corporation election are necessary to accomplish the single level of tax at the shareholder level. Evaluate the details of the adjustments to the stock basis. Cover descriptions and illustrations regarding calculating the "accumulated adjustment account" (AAA) and determining whether a distribution is from AAA. Loss limitation rules will be explained and illustrated, focusing on complications arising when distributions and losses occur in the same taxable year. Also, take into account the tax considerations of losses, reducing the adjusted basis in shareholder loans. Identify and evaluate tax planning opportunities and strategies.

Our country and our accounting methods have undergone huge changes in the previous few years, most of it challenging. Individuals and entire businesses have been left reeling by new tax regulations, doing more with less, and employment restructuring. Organizations must adjust quickly; notwithstanding how painful these changes have been. This course instructs accounting managers on how to deal with change and stress in the workplace. Before it affects them in a negative way, the accounting professional will learn how to best manage the changing work environment and the stress that comes with it. "The first wealth is health," remarked Ralph Waldo Emerson, but for many of us, stressful jobs are putting our health at jeopardy.

Calculating partnership basis is one of the most important things that we do as practitioners. However, it is also one of the most confusing. When we use the term "basis," we really could be referring to one of three different things. This course will explore the differences between inside basis, outside basis, and 704(b) basis. Through several examples and practice problems, we will show you how to easily distinguish among these terms. We will also explore the tax implications of initial contributions of property to a partnership as well as the different types of partnership distributions.

Attracting and retaining staff is critical to an organization's success, especially in the age of the millennial worker who will change jobs multiple times in the course of a career. This course will focus on best practices for nurturing the human element of your organization, especially millennial workers who comprise a growing percentage or the workforce. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

In the "Excel - Formatting Spreadsheets for Beginners" class, you learned basic formatting of a spreadsheet. In this class, we take you to the next level by teaching you how to customize many of the formatting options. Learn to customize cell styles and how to use these styles in other workbooks. Most Excel users know how to select number formats but this class shows how to leverage the Custom Number Formatting option to create special formatting options. Many of the formatting options are applied manually, cell-by-cell or by range. This can be tedious if there is a condition by which you want to apply a format. You will learn to use Conditional Formatting to format based upon a criteria. Have you ever finalized a spreadsheet, only to accidently make changes over the top? This action is something that is very easy to do. This class demonstrates various options to prevent this from happening and will look at various security options within Excel. This session is presented using Excel 2019/Office 365. Regardless of the version you are using, most 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 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.

Accountants with good writing skills are more likely to get promoted. What makes good writing good? Short, concise sentences with powerful, energetic verbs and lean word choices. This fast-paced, interactive course teaches you five principles for writing strong sentences. The principles include writing with verbs, using an active voice, simplifying sentences, and focusing on the reader. You will also explore three essential editing principles that provide quick and accurate correction. By taking this course, you will upgrade your capabilities in writing clearly and concisely.

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.

The Accounting and Auditing Update is designed to provide its participants with a comprehensive, in-depth review of what’s happening at the FASB, AICPA, and other professional bodies who may impact accounting and auditing this year, including FASB Statements and Interpretations, Statements on Auditing Standards, Statements of Position, Statements on Standards for Accounting and Review Services, Ethics Interpretations, exposure drafts and projects in progress, with emphasis on the practical application and impact on practitioners in small to medium sized firms and members in industry. Special attention this year will be focused on the emerging use of data analytics related to audit evidence. **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.

Introductory Session of Borenstein's Form 990 Foundational Series: This "initiation and introduction to" the Form 990's mechanics and importance will prevent you from drowning in the Form 990's force-field! More than 80% of the Form's inputs and relevant definitions are NOT found in the statutes and Regulations that apply to the exempt sector, a reality that can be overwhelming for both novices and more advanced preparers. This session provides an easy-to-digest synopsis of the entirety of the Form's key definitions as well as the mechanics that preparers need embrace from the moment they first approach preparing a 990. Packed with practical tips and perspectives on data gathering, this class is a "must" gateway for beginning (and even more experienced) preparers to learn "how to befriend Form 990 preparation." This webinar will vault preparers past all the initially confounding problems of the Form 990, providing baseline info on the critical nuances the form uses. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Our goal is to keep you current with the changing tax environment by focusing on recent legislative, administrative, and judicial decisions and examining topics addressed in the media, publications, journals and conferences. Our belief is that the better informed we are, the better we can serve the profession and our clients. Check in monthly to see the current topic and objectives.

PowerPoint is a widely available resource that is potentially underutilized by accountants because many accountants do not stray beyond Excel and Word in the Microsoft Office suite. You will learn how to create and edit a professional PowerPoint slide deck. This session places particular emphasis on efficiency tips and tricks that will allow you to develop creative, professional visual aids while minimizing time and effort. The course’s author will share personal insights he has cultivated throughout more than two decades of public speaking. Although the session will focus on creating and editing slides, we will illustrate best practices for presentation delivery. We will also explain how PowerPoint can be used for purposes other than delivering presentations.

This intensive two-hour course addresses the critical need for accuracy and efficiency when developing spreadsheets using Microsoft Excel. Recognizing that even minor errors can have significant implications, this course delves deep into strategies and skills required to detect and correct errors in Excel. By the end of this course, participants will have a comprehensive understanding of how to efficiently identify and correct errors in Excel spreadsheets, enhancing their overall productivity and accuracy in their professional roles. 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 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. 

The course provides a concise overview of Environmental, Social and Governance (ESG) reporting -- an emerging system of non-financial record-keeping and governance. Around the world, organizations of all sizes and kinds are under increasing pressure from regulators, consumers, employees, and other stakeholders to provide a fuller and more integrated picture of the way in which entities operate, invest, and create value. This includes taking into account how their operations impact financial, manufactured, intellectual, human, social, relationship, and natural capital. Participants will walk away with an increased situational awareness of ESG reporting, and an ESG starter strategy. This can be used immediately to position themselves for ESG success in an era of growing expectations for conscious capitalism, ethical investing, and moral leadership. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Governmental entities are the second largest victims of embezzlement.  This seminar examines recent events involving the theft of public money and the circumstances that allowed the fraud to occur.  We will be looking at a variety of case studies to illustrate these points.  

Have you ever met an accountant who exhibits solid technical prowess but possesses lackluster communication skills? It is not unusual to meet a savvy accountant who is a technical expert, but could enhance the delivery of written and spoken words. This course is designed to help CPAs improve their written and verbal communication skills. Participants will learn how to tailor communication to their audience, with particular emphasis on techniques for crafting a message that effectively conveys technical information in an engaging manner. The course’s author will share personal success tips gleaned from more than two decades of experience communicating myriad topics to a variety of audiences.