CPE Catalog & Events

Recent legislation in Congress has provided the IRS with substantially increased funding to bolster its human staff and purchase software that will allow the IRS to audit many more taxpayers in a more effective way. The IRS believes it can target the right kinds of taxpayers for audits so that it will not waste its time on audits that produce little, if any, revenue. The purpose of this program is to discuss the current state of IRS audits and the anticipated increases in the IRS's ability to audit wealthier taxpayers in an efficient way. Panelists will discuss the state of the IRS's current audits and where the IRS is headed with audits in the coming years. Tax practitioners should also be aware of the state of the IRS's efforts to target efficiencies so as to produce the most revenue.

This course corresponds to our Controllership series. Within this course, we specifically address the Controllers role and pro-active potentials in organization Strategic and Annual Planning. This series of courses is dedicated to exploring the traditional controller role and stepping out of the box to identify areas where the Controller can add strategic value to their organizations. Controllers are essential to the day-to-day accounting for organizations. Yet, the role is not often readily understood. In today’s world of acronyms such as CFO, CEO, COO, CAO, etc. the Controller function may get lost in the shuffle. However, they are a critical group of professionals who ensure the adequacy and transparency of accounting and financial reporting information. When it comes to the task of strategic planning, many feel this role is primarily the responsibility of the executive team and board. However, in this course, we delve into the various steps of the strategic plan and explore where the Controller can add strategic value through providing functional input and insight. Strategic planning is a process used to identify goals, the strategies necessary to accomplish those goals, and the internal performance management system that will be used to monitor and evaluate progress.  

Network forensics - defined as the investigation of network traffic patterns and data captured in transit between computing devices - can provide insight into the source and extent of an attack. It is used in forensic accounting and with the expansion of information technology it has become a growing field. Network forensics is a relatively new field of forensic science. Computing has become network centric. Data is now available outside of disk-based digital evidence. Network forensics can be performed as a standalone investigation or alongside a computer forensics analysis. When used alongside a computer forensic analysis it is used to reveal links between digital devices or reconstruct how a crime was committed. Network investigations deal with volatile and dynamic information and is a sub-branch of digital forensics. It relates to the monitoring and analysis of computer network traffic for information gathering, legal evidence, or intrusion detection. This course is a complement to our other courses in the series on becoming a forensic accountant.  

This course explores the increasingly complex features of Excel that facilitate efficient data analysis.  We will introduce numerous analytical methods and techniques by using practical examples to illustrate how to unleash the power of Excel when manipulating, analyzing and reporting information.

Imagine being able to see into the future with confidence.  The ability to be a great forecaster is not innate but learned.  By examining great forecasters, we can learn to improve our ability to predict the future.  We will examine best practices and current research to improve our ability to predict events that will affect our business.  

Budget methods are the key to allowing department managers to efficiently prepare their budget in Excel. For example, a budget method may be to spread prior year actuals or match prior year actuals, or match prior year actuals less 10%. In this webinar, we will explore how to allow users to pick a budget method from a drop-down list for each account and then have Excel perform different calculations depending on the budget method selected. We use several features and functions at the same time to pull this off. Even if you are not involved in the budgeting process, the underlying features and functions discussed have a wide range of uses.

You have used Excel for years and perhaps Lotus 123 before that. And through all that time, you have repeatedly said, "One day, I'll learn how to write macros." Finally, that time has arrived because this four-hour program will introduce you to the wide world of Excel macros and Visual Basic for Applications (VBA). This course teaches the fundamentals of creating and working with macros in Excel and is designed specifically for those with little experience working with macros. More specifically, taking this course will teach you how to use Excel's Macro Recorder to write simple yet effective macros. You will also learn how to secure and share macros with other Excel users and create user-defined functions to solve specific accountant-centric problems in Excel. Further, you will learn how to create macros that run when a user opens a workbook and VBA basics. Don't miss this unique opportunity to learn how to begin working with macros - one of Excel's most powerful tools.

This course presents an overview of blockchain and the tax implication of cryptocurrency transactions. The IRS has provided some recent guidance, but potentially conflicting pronouncements by other regulatory agencies have created uncertainty on reporting issues. The practitioner will be helped to understand when a taxable transaction has occurred and what reports to file to satisfy IRS requirements. We will also identify tax traps for the unwary. This information is suitable for Corporate tax and finance executives, directors, managers and staff, CPAs, Enrolled Agents, accountants, attorneys and business/financial advisors who work with and advise individuals or businesses that use or invest in cryptocurrency. All in-house and public practice professionals involved with tax compliance and planning will benefit from this timely and insightful seminar. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Does your organization encourage timely reporting? Does your organization provide substantive protection for those who report? Organizations should be aware of characteristics indicative of a retaliatory culture - one in which bad actors are provided ample opportunity and cover to retaliate.

This course corresponds to our Controllership series. This course is dedicated to exploring the traditional controller role and stepping out of the box to identify areas where the controller can continue to add strategic value to their organizations. Within this segment of our controllership series, we discuss the area of cash and investments and explore how the controller can move these responsibilities into more of a strategic role. In today’s world, the role of cash management is often a pivotal role in the organization. In economically difficult times, controllers may find that they spend a great deal of their time on understanding and managing the organizations' cash position. This is certainly important and, in some areas, can be seen as a staple of the lifeblood of the organization’s ongoing viability. This course takes a look at some of the typical objectives involved in cash management and then evaluates how those objectives can be further stretched into strategic pillars of the organization.  

This course focuses on the key federal tax issues affecting businesses from the internal accountant's point of view, with a focus on recent tax legislation and developments.  Planning alternatives and the potential risks associated with those strategies will also 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.

Office Scripts are an exciting new development for Excel and other applications. Although they are like macros in some respects, most users will likely find them easier to work with. Learn how to put this powerful automation tool to use!

This course will introduce you the different types of business entities and the tax implications of contributions, distributions and earnings, among other topics. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Discuss trends and changes impacting the American workforce. Discover "why" culture matters, the "benefits" of great cultures, and the workforce challenges created both before and after the pandemic. Once the audience has clarity on these items, the presentation shifts to "how" to create a great culture in our post-pandemic environment. Jim provides practical tools that can be implemented at any organization. Some of the tools are directly related to the new challenges resulting from the COVID-driven pandemic. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Cloud computing has become a source of cyber-crime. “Cloud forensics is the application of digital forensics in cloud computing as a subset of network forensics to gather and preserve evidence in a way that is suitable for presentation in a court of law.” Cloud forensics is a combination of the varied types of accounting forensics including: •    Digital forensics •    Network forensics. •    Hardware forensics In cloud crime, the cloud is considered the object when the target of the crime is the cloud service provider they are directly affected by the act. It is considered the subject of the crime when the criminal act is committed within the cloud environment. It is considered the tool when it is used to plan or conduct a crime. This course will delve into the many concepts involved in cloud forensics. The course complements other courses in the series of Becoming a Forensic Accountant.  

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.

Most professionals routinely use Word, Outlook, and PowerPoint, but many are self-taught and, as a result, have not been exposed to the best features of these three applications. Consequently, they often use “brute force,” inefficient means when working with these three components of Microsoft Office. If that describes you, ensure you carve time out of your schedule to participate in this fourhour session. In it, you will learn how to work much more efficiently when using these tools to get better results in less time.  

A significant amount of information is electronically initiated, recorded, processed, or reported, and information to be used as audit evidence may be available only in electronic form. During this session we will look at different types of information commonly presented to an auditor during the audit of an employee benefit plan, and identify considerations for auditors when evaluating information to be used as audit evidence.

When the leadership in any organizations carries out their responsibilities of establishing, maintaining and monitoring internal controls, it significantly reduces the possibility of fraud occurring.  When and if it does occur, a good system of internal controls will often detect it early on.  This presentation is an illustration of what can happen when top management fails to carry out their responsibility of protecting an entity’s assets through a good system of internal controls.

Most ethics courses focus on unethical individuals and their terrible misdeeds. We don’t need another course on lessons from Enron or individuals committing fraud.  Most unethical failures result from unethical individuals.  Instead, this session will focus on how good people can do better, why there is no such thing as business ethics and why we only need one rule to lead ethical lives.