CPE Catalog & Events

Yellow Book and Single Audit engagements are considered must-select engagements for peer review. This course will review the common deficiencies noted by peer reviewers and federal agencies. We'll focus on the requirements of Yellow Book independence, CPE, and reporting. We will also review deficiencies related to internal controls over compliance, compliance testing, and major program determination for Single Audits. We'll close the course with a look at the deficiencies often identified in COVID-related funds.

Unlock the full potential of Microsoft Excel PivotTables with this comprehensive course. This training is designed to equip participants with the skills to effectively analyze and summarize data, transforming raw numbers into actionable insights. Whether you're a seasoned professional or new to data analysis, this course provides an in-depth understanding of PivotTables and their capabilities, helping you uncover patterns, compare data, and make informed decisions. The program includes a step-by-step approach to creating and customizing PivotTables, focusing on how to use them to analyze data efficiently. Participants will learn how to group and filter data, identify trends, and apply advanced features to solve real-world business challenges. Beyond technical knowledge, this course introduces data visualization through PivotCharts, teaching participants how to present their analysis effectively to stakeholders. By the end of the course, you'll not only master PivotTable fundamentals but also gain advanced techniques to streamline data analysis and support strategic decision-making in any context. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Look beneath the surface of S corporation taxation in this discussion of special topics concerning S corporations.

This program compares and contrasts the financial and tax accounting differences of partnerships, LLCs, and S corporations, as well as discuss the tax accounting for these entities. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Yellow Book and Single Audit reporting entities have complex and unique financial statement audit, compliance and reporting issues. Deficiencies in these types of audit engagements are common. This course will reduce the likelihood of noncompliance with relevant professional and regulatory auditing and reporting standards.

Don't let the title frighten you. Experienced staff can get bogged down in busy season with advanced practice and reporting issues. With major legislation enacted over the past few years, we bring you the distilled version of what you need to know for the current year and significant current proposals that may impact the tax landscape in future years or even retroactively. This course discusses the topics that experienced staff, managers, and partners should understand in depth while also assisting experienced staff in avoiding costly mistakes when facing complicated 1040 issues. The manual includes advanced examples and several advanced cases with "filled-in" forms provided with the complete answers.

Employment taxes are often overlooked as an area where more planning may be effective. Payroll taxes have become an increasing burden for the average business, and IRS penalties for noncompliance have risen dramatically in recent years. They have also been subject to employer incentives. The Service has announced that uncovering noncompliance by employers ranks high on its audit list. This course presents a comprehensive overview of federal payroll taxes, Form 1099, and related compliance issues.

Many accountants desire to have a quick overview of only the most current issues in accounting and financial reporting. This course will provide an executive summary of the most important changes in U.S. GAAP. 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 world of work today, nothing is more critical than Culture.  If people are your competitive advantage, then culture is the best way to help your people realize a great destination. While many leaders and companies talk a lot about culture, few take the time to really plan, build, and invest in a great culture. Today, the world of work could not be more challenging, and the changes that we are seeing in the workforce, such as the rise of remote workers and increasing turnover, are adding to the complexity. Now more than ever, Culture must become your competitive advantage. In this course, you will learn about the key macro changes in the workforce and what some leading companies and leaders are doing to create amazing cultures and high-performing organizations. From LinkedIn to Patagonia to Eventbrite, you will learn from some top organizations ow they have successfully leveraged culture. You will learn what Culture is and can be, and you will learn what culture is not. As you set sail in 2024 and beyond as a leader, you will benefit from this class and learn how to make culture your competitive advantage. Your teacher for the class is Steve Cadigan, whom many credit for being the architect of LinkedIn's world-class and groundbreaking culture. 

This webinar will explore embracing and supporting neurodiversity in the workplace, promoting inclusivity, and creating a more diverse and dynamic environment.

Financial statement audits often involve audits of components of a larger entity. This course will focus on the responsibilities for both the group auditor and component auditor, including implementation of SAS No. 149 relate to group audits.

ProActive Response Group's Active Shooter Response Training course educates participants in current trends of active shooter incidents, how to recognize early warning signs of violence, appropriate actions to increase chances of survival in an active shooter event, and how to use basic medical equipment to save the lives of victims.   *****(Warning: This video contains simulated graphic scenes that some viewers may find disturbing)*****

Office Scripts is a new feature that allows you to automate tasks in Excel and other Office applications. Unlike VBA, a legacy language that runs only on Windows, Office Scripts can run on any platform and device that supports Office on the web. Further, Office Scripts has a modern and intuitive interface that lets you easily create, edit, and share your scripts. Office Scripts are stored in the Cloud, and they work with Office Online apps and integrate with Power Automate for process automation. Save time and improve productivity using Office Scripts in Excel and other Office applications.

The TCJA made turning business losses into tax refunds far more difficult.  The CARES Act suspended and modified many of these changes.  This course will address the revised rules for deducting business losses and discuss planning ideas and 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.  

Cybersecurity protection is one of the most important responsibilities of every CPA professional to protect the confidentiality of sensitive client information. While there are many aspects of cybersecurity that need to be addressed, the biggest vulnerability to protect against is unauthorized access to your application login credentials. Once your login credentials are breached, the cybercriminal essentially has the keys to your data kingdom. John Higgins, a national leader in the CPA technology, will demonstrate the ease with which you can protect all of your login credentials with maximum security with minimal expense. You will leave this course prepared to deploy this state of the art security tool in your organization. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Good writing is good business. Studies show that the average business worker receives 121 emails per day. That's a lot of emails. Are your emails effective? Are they being read? Are they professional and tone-smart? In this course, you will learn techniques and skills to get your emails to stand out and improve their effectiveness and professionalism.

This course provides a comprehensive analysis of the SECURE 2.0 Act. The principal focus of the Act is to expand retirement coverage and increase retirement savings. As such, the Act has many important changes relating to IRAs and qualified plans. This legislation alters the landscape of retirement planning for taxpayers of all ages. Make sure you are up to date with the latest information available in order to effectively advise your clients on these important changes.

The GASB has been working on some big projects lately. This course starts with a look at the GASB standards effective this year, including GASB 94, Public Private Partnerships and GASB 96, Subscription Based IT Arrangements. We will include practical applications in the form of case studies to apply the topics. We will then switch gears to the GASB standards coming down the pike, including the major projects of the GASB.

*** CPE SAVINGS CODES DO NOT APPLY TO STAFF TRAININGS ***Develop your soft skills in training courses that benefit both the person attending and their organization. This course is applicable for various accounting departments (i.e. audit, tax, consulting, and accounting services) but because these are universal leadership concepts, they are equally applicable to other professional business leaders. AHI soft skills training will help improve efficiency, make managers more effective with others, and increase the organization's bottom line. Also, as these courses often include other industries besides accounting, there is an opportunity to work and network with leadership professionals from other industries. Per NASBA's rules effective January 1, 2024, participants are required to be on camera and participate in the full and small group discussions to earn CPE credits for this Group Live - Virtual course. As such, please make sure you are set up properly with reliable internet (hard wired is best), a working camera, and a working microphone.

This course dives into the powerful, but potentially under-utilized, capabilities of Microsoft Excel. Designed for sophisticated users willing to approach spreadsheets from a unique perspective, this program encourages users to challenge the status quo by considering opportunities to take acceptable spreadsheets to a new level. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.