Professional Development and Event Catalog

Staff accountants have specific needs when working with Excel – needs that are often not met by their existing Excel knowledge. Chief among these are the needs to quickly summarize data, prepare accurate and aesthetically pleasing reports, and create accounting-centric calculations for elements such as depreciation, amortization, and interest. By participating in this eight-hour session, staff accountants will gain the essential skills they need to maximize their efficiency and accuracy when working with Excel. This session begins with a quick overview of Excel best practices. It then progresses rapidly into discussions that address PivotTables, sophisticated formulas, Tables, formatting, and working with dates in Excel. Throughout the session, you will learn from accounting-centric examples to reinforce key learning points. In this session, you will learn in a “laptop-friendly” environment, and participants will have access to all the demonstration files used in the session. In sum, this seminar is a “must” for all staff accountants seeking to improve their efficiency and accuracy when working with Excel.  

This course fills an important need for both financial managers and accountants in the practice of public accounting by offering the tools to help ensure the future success of a business. Practical guidance for the effective use of benchmarking and analytical procedure is also provided. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The process of closing out the books every month can make year-end accounting a breeze! But isn't this time consuming? Not when you know the steps to take monthly. We'll show you what to do in your QuickBooks Pro, Premier, or Enterprise as well as learn what you can do monthly to ensure a tax return that will stand up again an IRS audit. 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 highlights the latest legislative changes affecting depreciation and capitalization rules, including inflation increases and Section 179 and 168(k) deductions.  Planning and potential pitfalls will also be presented.  **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.

AU-C Section 315 requires the auditor to gain an understanding of the entity and its environment and the entity's internal controls in order to design appropriate audit procedures. This course will review  the key requirements of COSO which is one of the most widely used internal control frameworks. We'll also review the limitations of internal controls. Additionally, this course will introduce the risk assessment process and the various audit procedures to evaluate controls and to determine whether to test the operating effectiveness of controls. 

This course investigates actual real-world fraud schemes and discusses what controls could have prevented the fraud from occurring, and what controls could detect and curtail the fraud scheme. The instructor speaks from experience, finding multiple frauds very early in her career leading to a career-long focus on fraud prevention and detection. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Technology continues to revolutionize our professional and personal lives. Stay up to date on key technologies that may affect you in the very near future so that you may position you and your organization for success.

Microsoft’s Power Platform – incorporated into many Microsoft 365 subscriptions – offers tools to automate common business processes. Learn how to take advantage of the Power Platform in this session.

The purpose of this program is to discuss the ethical mandates that govern the conduct of tax practitioners. The program focuses on the ethical pronouncements of the IRS in Circular 230, as well as the preparer penalty provisions set forth in the Internal Revenue Code. Please note: This ethics course does not cover state-specific issues and so is not applicable in states that require ethics courses to include specific state laws and regulations. Please check with your state board prior to registering for this program if you are in doubt about whether this program satisfies your state's ethics requirements.

In this webinar we will explore the powerful concept of splitting data from reports and dig into the mechanics that enable this technique. The key feature discussed is the Tables feature, and the key function discussed is the multiple-condition summing function. We will illustrate these items in a variety of ways, including building crosstab style reports and mapping tables.

When we verbally communicate with an individual, we must make a conscious decision as to whether we believe what we have heard.  Little do we realize that we are not making a decision based on what we have heard; rather we make a subconscious decision based primarily on what we have seen, or how the body was behaving when the subject was speaking.  We often walk away from a conversation with a gut feeling that the person was not telling the truth.  That gut feeling is your subconscious.  Yet we often have no idea as to why we have that feeling. This presentation is designed to provide the participant with the tools to identify those both verbal and nonverbal indicators that we all give off when we are under stress.  Normally, telling the truth does not create stress.  When we lie, we know that we are not supposed to and that creates stress, and it will manifest itself in some manner, and that is what a trained interviewer is looking to observe. When we observe indicators of deception, how do we deal with it?  How do we get the subject to admit to a wrong-doing when it is not in their best interest to do so?  That is one of the many things that will be addressed in this presentation.  Whether you are a parent dealing with you kids; an employer dealing with employees or and investigation interviewing a suspect, this presentation will provide you with the tools to assist you in finding the truth.

In trying to achieve life balance, various internal and external obstacles arise.  In this course we will look at these obstacles and provide specific ways to overcome them.  In addition, we will look at how to excel in every area of your life including your relationships, finances, sense of purpose, level of  happiness, and your physical health and leisure time pursuits.  You will leave this course with powerful methods and a specific plan to move forward in your life in a balanced, healthy, and productive manner.  Don't forget to take Part 1 of this amazing course.

A detailed analysis of the calculations related to determining a shareholder's tax basis for S corporation shares and loans. How to use the Form 1120S, Schedule K-1 information for basis determination, as well as an update on Schedules K-2 and K-3. An illustrative example demonstrates how the process works, as well as the 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.

The effective date of FASB ASC 606, Revenue from Contracts with Customers is upon us (bold) Do you know which contracts are within the scope of the standard and when revenue should be recognized? This webcast addresses the requirements of FASB ASC 606's five-step process for recognizing revenue: 1) Identifying a contract with a customer 2) Determining the performance obligations 3) Determining a transaction price 4) Allocating a transaction price 5) Recognizing revenue

As reported in the Association of Certified Fraud Examiners Occupational Fraud 2022:  A Report to the Nations, on average, small businesses lose 5% of their revenue due to fraud.  Can the average small business owner afford to lose 5% of their revenue due to fraud?  I think not.  This presentation is designed to illustrate the numerous ways employees commit fraud in small businesses, how to detect it, and most importantly, how to prevent it.  Both auditors and small business owners would both benefit from this presentation.

The Paperless Office is not a myth! With today’s technology, you have many fantastic options for “going paperless,” In this session, you will learn how to leverage these technologies for better document management and storage practices.

This session explores tools and techniques that can enhance the efficiency and effectiveness of client engagements and business processes using data analysis tools. We will introduce some of today's popular and software tools and examine the AICPA's Five-step approach to incorporating data analytics into public accounting engagements. 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 provides a refresher regarding the fundamentals of activity-based costing (ABC). We will examine theoretical concepts before exploring practical possibilities for implementing ABC. A major focus of the course will be factors to consider when determining whether this managerial accounting tool is an appropriate resource for an organization.

Fraud Trends - Applying Real-life Lessons to Small- and Mid-Size Entities will focus on real-life and practical examples of fraud in smaller- and mid-size environments, including nonprofits. Fraud involves an intentional act to deceive, which may result in material misstatement in the financial statements due to fraudulent financial reporting or misappropriation of assets. Management's responsibility is to design, implement, maintain and monitor a system of internal control to prevent, or detect and correct, fraud. Note: This is a part of the suggested 16-hour Audit Skills Level 4 curriculum for experienced in-charges or seniors. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

In this session, participants will delve into a comprehensive exploration of what Diversity, Equity, and Inclusion (DEI) truly entails. Often met with resistance due to its perceived condemnatory nature, this session aims to provide a more nuanced definition of DEI, fostering a better understanding among attendees. By demystifying the language surrounding DEI, participants will be equipped with straightforward approaches to seamlessly integrate these principles into their perspectives. This session will spotlight the distinctive features of our DEI model in comparison to other systems. Attendees will gain valuable insights into the model, understanding its unique perspective on achieving DEI success. At its core, our approach is grounded in the simple premise that we are all human beings sharing the common human experience. The goal is to convey to participants the importance of embracing DEI through this paradigm, effectively humanizing the DEI experience. One of the most remarkable DEI experiences unfolded during my son's 18th birthday celebration in our backyard. The event brought together individuals from diverse backgrounds, spanning various walks of life and races, who interacted in a profoundly humanistic manner— an encounter unlike any I had witnessed before. In this session, we will deconstruct this experience and draw parallels to its relevance in workplace dynamics.