CPE + Events Catalog

Transform your Excel skills with our comprehensive training program, designed for users at all levels seeking to master the full suite of Excel capabilities. From powerful data analysis tools like PivotTables and advanced functions such as XLOOKUP, to the nuances of Data Validations and Conditional Formatting, this course offers a deep dive into Excel's most impactful features. Whether you're streamlining complex data sets, enhancing your reporting skills, or just looking to boost your productivity, this session provides the insights and techniques you need to leverage Excel to its fullest potential, making it an indispensable tool in your professional or personal toolkit. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

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-25 by the ARSC. The course will also 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 SSARSs requirements and guidance, but more importantly, it will provide you with practical examples and illustrations to help you effectively and efficiently perform compilation, preparation, and review engagements.

This program addresses the most recent developments impacting taxpayers incurring research and experimentation costs.  Emphasis will be placed on compliance with the 2022 change in Section 174 Amortization of research and experimental expenditures. **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 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.

Accountants have increasingly become the primary advisors for businesses of all sizes. Clients are seeking assistance with all aspects of business planning. Are you prepared to support your clients on aspects such as business expansion, sources of capital, and determining growth strategies? This course introduces accountants to the essential elements of finance for business with an emphasis on the interrelationship with the traditional functions of accounting, explaining sources and costs of capital, and making educated capital decisions about growing business. Bringing a new appreciation of the vital role accountants play in business development, this dynamic and fast-moving session will explore key finance concepts and tools, including some of the best methodologies for making capital business decisions.

As the population of the United States ages, tax practitioners will be asked to advise their individual clients with respect to when they should begin to take Social Security benefits. This program will provide you with the background to knowledgeably discuss the benefit options available to Social Security beneficiaries and the alternative payment options available to married couples, dependents, a surviving spouse, and a divorced individual.

In the world of "Big Data," virtually all business professionals have become data analysts, at least to some extent. However, that is particularly true in auditing, where internal and external auditors increasingly turn to data analytics to identify situations requiring follow-up and investigation. Those who understand how to use various tools to assist in these efforts benefit by conducting more thorough analyses and achieving superior results in less time. In this session, you will learn about various tools and techniques you can use for more thorough data analyses. The discussion includes Excel as a data analysis tool, multiple Excel add-ins, and Microsoft's Power BI application. If you're seeking to improve your skills in the field of data analytics, this session is the one for you!

Both businesses and individual clients face major changes as a result of new legislation, and tax professionals face the considerable challenge of delivering effective planning advice and services to address this myriad of recent developments. This course addresses this challenge and also encompasses the latest cases and rulings applicable to individual and business clients. Continually updated to reflect enacted legislation. Please Note: Due to content overlap, it is recommended that this course NOT be taken together with BIT4.

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.  

One of the most significant challenges facing auditors is the prevalence of fraud that exists in today's business environment. All auditors should have a working knowledge of the requirements in professional literature regarding fraud. We will cover the issues that all auditors need to know about fraud and the people who commit fraud. This course will provide horror stories about frauds that have occurred and how they were detected. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Payroll is among the most common tasks an employer undertakes in the course of running their business. At its most basic level, payroll consists of an agreement between an employer and employee related to compensation for services. Once you pull back the curtain, there is so much more to payroll, including various kinds of compensation, payroll taxes and required reporting on various government forms. This course will provide a general introduction to the payroll cycle of life, including real life examples of how to process payroll, the withholding and payroll tax deposit regime, common payroll forms, and tips and tricks for tying it all together. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

In April 2016, the American Institute of Certified Public Accountants (AICPA) Auditing Standards Board (ASB) issued the Statement on Standards for Attestation Engagements (SSAE) No. 18, Attestation Standards: Clarification and Recodification, to supersede the former standard SSAE 16 This course will help you if your organization has the need to obtain or provide a SOC (Systems Organization Control) report or if you wonder what changes the new SSAE 18 standard will bring to the process. SSAE 18 is effective for SOC report opinions dated on or after May 1, 2017, and early adoption was permitted. This course focuses on the specific requirements of SSAE18 and highlights changes from SSAE16 In today’s economic environment, many companies utilize outsourced services to perform varied functions. These functions can span from payroll and accounts payable to information technology processes or even call center functions. The list can be endless however these services are often a critical component to the internal control environment of the organization A service organization should implement a robust third-party vendor management policy if one is not already in place. Often, initial vetting occurs of the subservice organization however that same diligence is not maintained as the service continues. It is just as important to ensure that subservice organizations are monitored on an ongoing basis using the methods outlined in SSAE 18.

One of the biggest challenges, if not the most critical challenge in business, is attracting and keeping an engaged and productive workforce. Navigating the world of engagement and retention requires an understanding of human needs as well as deliberate and intentional actions to strengthen an employee's investment and connection to their place of work. For all the HGTV lovers out there, this session mirrors a television show where an individual/family must decide if they want to stay in their current home (after renovations and home improvements) or move to a new space. This webinar title seems apt in describing the current issues around engagement and retention. When an employee chooses to "love it" or stay with their current employer, it typically means they are engaged in their work and they feel seen, heard and valued- they are content. Conversely, the notion of "leaving it" typically symbolizes an employee who cannot wait to get out of their current job. These employees often have negative attitudes and/or behaviors at work. The purpose of this webinar is to recognize the significance of attracting and retaining employees, building your brand as an employer of choice and developing a culture where individual employees feel valued, cared for and ultimately engaged, all though an ethical lens. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

As accounting firm's non-attest offerings to their attest clients become more diversified, such engagements increase firms' exposure to independence violations. In order to thread the needle of providing value-added services and upholding their independence obligations, firms need to have a strong foundational understanding of the applicable ethical and independence rules which govern these engagements. In this course, we'll review the relevant sections of the AICPA Code of Professional Conduct regarding independence, objectivity, and conflicts of interest. The course will focus on the Code's Independence Rule and common threats to auditor's independence. In particular, the course will focus on those unique considerations related to non-attest services, both from the perspective of AICPA interpretations and other applicable rules and regulations. PLEASE NOTE: THIS COURSE COVERS GENERAL ETHICS AND IS APPLICABLE IN STATES IN WHICH STATE-SPECIFIC ETHICS IS NOT REQUIRED.

This hands-on workshop offers an analytical approach for designing, executing, and communicating results of a comprehensive financial statement analysis. We will explore numerous techniques and approaches that facilitate in-depth financial statement analysis. Accountants in public practice will obtain insight regarding analytical procedures, additional client services, and enhanced compliance with professional standards. Accountants in private enterprises will develop more robust techniques for understanding their organization’s financial statements to facilitate forward-thinking decisions and communication to internal and external stakeholders.

Tax planning is more than an estimated tax calculation, it's a process.  Where are we now and what can we change?  This timely program will highlight significant 2022-23 tax developments and discuss key tax planning ideas for your clients as you prepare for the upcoming tax season. Don’t wait until late December to start planning for your clients! **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.

For practitioners, it’s a challenge to stay current or ahead of the curve! Change in the tax law is a virtual certainty and keeping up to date is always difficult. The 2024 elections may have an impact on the Congress, the Presidency and, probably the IRS. This ACPEN course will include a panel of national tax practitioners and experts reviewing the latest judicial, legislative and regulatory developments affecting individuals, corporations and other business entities. They will also try to project future developments! Even if Congress cannot muster enough votes to pass new legislation before the next elections, the IRS is instituting a variety of new audit programs directed at non-filers and high net worth individuals and passthrough entities. More are announced regularly! Various tax provisions will expire or benefits will be reduced if Congress fails to act. The courts and the IRS continue to churn out rulings and decisions that affect your clients. **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 course is designed to assist CPAs who perform financial statement preparation, compilation, or review engagements. Our panelists will provide an in-depth analysis of the SSARS and will provide practice tips that will assist you in performing profitable standard compliant engagements. **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.

In today's data-driven world, spreadsheets serve as the backbone of business and personal productivity. However, creating complex and error-prone spreadsheets can lead to critical mistakes and inefficiencies. This course aims to equip you with the knowledge and tools to build robust spreadsheets, implementing a range of controls and safeguards to ensure data integrity, streamline processes, and maximize accuracy. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This program addresses the many issues impacting CPA practice with a world in crisis.  The unique challenges facing practitioners are related through actual practice situations – and then analyzed for their ethical implications. Based on real life experiences. **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.