CPE + Events 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.  

Increasingly, automating business processes is a necessity. In this session, you will learn about real-world examples of automating business processes. Remember, the survival of your business might depend upon successful automation!

This session explores managerial accounting techniques with an emphasis on internal decision-making tools. You will appreciate a reminder regarding concepts you may not have considered since your college days. We will revisit managerial accounting concepts by illustrating practical examples that you can immediately bring back to the office!

Fraud continues to plague businesses at epidemic levels, and technology control failures are a big reason fraud occurs. Using a case study approach, in this session, you will learn about the pervasiveness of fraud, the control failures that contribute to fraud, and what you can do to mitigate fraud risk. A specific focus of this course is the application of information technology general controls and information technology application controls. In this course, you will examine numerous reported fraud cases and identify the general control and application control failures that contributed to each of these frauds. By learning through these real-world case studies, you will be better positioned to reduce fraud risk.  

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.

What can we learn from one of the largest municipal frauds in U.S. history? Rita Crundwell stole nearly $54 million from the citizens of Dixon, Illinois over the course of two decades. This course examines circumstances that allowed this landmark fraud to occur. We will explore internal control deficiencies and other circumstances that hindered prevention or timely detection of Rita's scheme. 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 is a case study designed to provide a comprehensive overview of U.S. taxation of a foreign corporation. Using a specific example, the course will walk through step-by-step mechanics on how to calculate the income inclusions and foreign tax credits under GILTI (Global Intangible Low-Taxed Income), Subpart F, and PFIC (Passive Foreign Investment Company) regimes. The case study will further evaluate tax impact of subsequent distributions from the foreign corporation and sales of its stock. A compare-and-contrast approach will highlight the different outcomes of these regimes for individuals and for C corporations, empowering participants to advise their clients on the most tax efficient way to structure their international investments.

Specifically designed for preparation, compilation, and review practitioners, this course will provide you with a comprehensive review and hands-on application for performing financial statement preparation, compilation, and review engagements. You will learn the ins and outs of applying SSARS No. 21, Clarification and Recodification, as well as the additional guidance related to SSARS engagements through the issuance of SSARS Nos. 22-26 by the ARSC. In addition to SSARS 26, the entire suite of quality management standards is discussed. However, knowing the standards is not enough. You need to be able to effectively apply them. To support this, the course will review recent peer review feedback on SSARS engagements, providing insights on how to successfully apply this guidance. Not only will this course bring you up to date on SSARS requirements and guidance, but more importantly, it will provide you with practical examples and illustrations to help you effectively and efficiently perform these types of engagements. This course is intended to be your go-to reference for training your staff and managing your SSARS No. 21-26 services in compliance with professional, ethical, and technical requirements.

This course will serve as an introduction to conducting effective walkthroughs to gain an understanding of the client's transaction processes as well as identify internal controls within each process. This course will review the procedures, questions to ask, and documentation requirements of walkthroughs. It will also include real-world examples of the red flags that may arise while executing a walkthrough. 

AICPAs Code of Professional Conduct - Exploring the Foundational Principles Underlying the CPA Profession as a whole will provide an overview of the basic principles of the AICPA's Code of Professional Conduct with practical implementation examples. CPAs must seamlessly transition to a profession that relies heavily on conformance with technical and ethical standards. It is critical for CPAs to seek to serve the public interest with a strong sense of character, integrity, competence, and due professional care. In addition, CPAs must appropriately safeguard any threats to independence and objectivity. Note: This course is recommended as a part of a 16-hour audit skills curriculum for beginning auditors, while it is also appropriate for anyone who has public accounting responsibilities. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Women finance leaders face challenges that traditional corporate training and mentoring rarely prepare them to overcome. For example, you've demonstrated yourself as an excellent tactician, you know how to get the job done, and do it very well on your own. Yet, what got you to your current level of success won't get you to the next level. It's time to change the way you think and operate in your role. You need to move from doer to leader. You're familiar with the saying that if you want to go fast, go alone, if you want to go far, go together. In this workshop, you'll learn key strategies that are unique and critical to women to be successful in their careers. These strategies will help you grow, expand and elevate yourself professionally. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

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.

This course explores actual fraud circumstances through the lens of potential prevention. We will examine how selected frauds were accomplished and consider what internal controls may have prevented fraudsters from achieving their nefarious acts. Then we will switch gears to an interactive, case-based discussion that asks participants to reach their own conclusions by analyzing facts in concert with the AICPA Code of Professional Conduct and other sources of ethical guidance. This course provides practical, action-oriented insight that can be implemented by accounting professionals in both public practice and industry.

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.

When do they exist and how to report them? This program will provide a detailed analysis of the real estate professional passive activity rules, including forms reporting examples, and integrates those rules with when real estate is considered a "business" under the Section 199A flow-through entity deduction.  **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.

Blockchain technology offers the promise of digital truth. When appropriately implemented, it provides a transparent, permanent, immutable, and high-speed record-keeping system. The possibilities are endless, from managing the logistics of supply chain networks to facilitating international commerce. The adoption of this technology is growing, with millions of new users every year. Organizations adopt this technology daily to help improve their existing operations through its ledger capabilities or by executing smart contracts. Cryptocurrency is one example of blockchain technology, and its growth and value have exploded to over $2 trillion in the last few years. This growth has helped fuel the adoption of Wall Street traders and traditional investors. While more popular than ever, few business professionals understand these technologies and their capabilities, risks, and potential impacts on business operations and processes, such as contract execution, recording and maintaining real estate ownership records, and supply chains. Unfortunately, this incredible technology is a mystery for most accounting professionals. This course will provide an in-depth look at this technology, including a detailed Update of the underlying technology, the benefits, the risks, the major players, and many practical applications. By participating in this session, you will gain a deeper understanding of the inner workings of this technology and recommendations for getting started.

This course examines the critical issues and special opportunities facing partnerships and their partners, as well as the relationship between limited liability companies and partnerships, with a focus on reporting tax basis capital accounts. **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.

This 2-hour mini course is from our Level V course, which highlights leadership skills and situations that are common for managers and senior managers in CPA firms. Participants will be encouraged to examine and challenge their beliefs and approaches to managing and leading people.Leading Others - Coaching & Developing Staff - prioritizing the coaching and development of staff in a post-pandemic work environment, including delegation for development, effective feedback, and managing virtual employees.Building Leadership Communication Skills - strategies to influence and lead others through effective communication in both individual and group settings.Helping the Firm Grow - the three levels of helping the firm grow and how to involve the entire team in expanding services to existing clients and generating referrals to new clients.All of AHI's courses rely heavily on participant interaction and these virtual programs have co-opted many of Zoom's features to preserve the same strengths of the in-person training: visual interaction between the instructor and all participants (plan to be "on screen" throughout the program) breakout rooms to ensure small group engagement and instructor interaction screen share for small group presentations easy delivery of video presentations fillable PDF for online note-taking in the course material.

This course will serve as an introduction to conducting effective walkthroughs to gain an understanding of the client's transaction processes as well as identify internal controls within each process. This course will review the procedures, questions to ask, and documentation requirements of walkthroughs. It will also include real-world examples of the red flags that may arise while executing a walkthrough.