Professional Development and Event Catalog

If you use Outlook to process your email, you are likely spending a substantial part of your day processing incoming email messages. This course is designed to show you a multitude of tips and tricks to reduce time spent processing emails. We will cover every feature available in Outlook to streamline and automate your email processing. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Nonprofits face unique accounting challenges. This course will introduce attendees to the financial statements and unique accounting principles applicable to not-for-profit organizations. Specifically, we will focus on the typical transactions and account balances unique to NFPs, including net assets, agency transactions, contributions, endowments, and programmatic investments.

Governmental entities are the second largest victims of embezzlement. This seminar examines recent events involving theft of public money and circumstances that allowed the fraud to occur. Case studies we examine include the 2012 $54 million embezzlement from the City of Dixon by Rita Crundwell. The events that impacted the small Illinois town of 16,000 residents was the largest governmental fraud case to date, and spanned an astonishing 20 years. This remarkable story inspired an award-winning documentary, "All the Queen's Horses." We will also examine factors that led to scandals involving the Baptist Foundation of Arizona, World Com, Collin Street Bakery and the Ohio American Cancer Society, among others. This course is ideal for CPAs, government finance personnel, all Internal Auditors, lawyers, governance professionals, accountants and human resource personnel. 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 provides a concise overview of the Dark Web, a part of the internet that isn't indexed by search engines, and is often associated with anonymous transactions and nefarious activities. Discover the leading threats and risks that the Dark Web poses to accounting firms. Explore how practitioners can effectively mitigate the risk of data breaches, ransomware attacks, financial fraud and other risks connected to the Dark Web. You'll walk away with a foundational understanding of leading cybersecurity strategies that can help you maintain client trust and protect your firm's sensitive data in this complex and ever-changing threat landscape. 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 will provide an overview of the work and impact of the Treasury Inspector General for Tax Administration (TIGTA) on the US tax system, regulatory ethics, and accounting profession. TIGTA is an independent organization that provides oversight of the Internal Revenue Service (IRS) and conducts audits, investigations, and inspections and evaluations to promote integrity, economy, and efficiency in the administration of the nation's tax system. The course will explore the role of TIGTA in improving the efficiency and effectiveness of the IRS, identifying opportunities to improve the administration of tax laws, and upholding ethical standards in the accounting profession. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Practitioners need to exercise caution to ensure they maintain independence as they assist their clients with reviews, audits, and compilation engagements. This course provides a roadmap to best practices and guidance provided by the AICPA's Code of Professional Conduct and analyzes and applies it to actual scenario-based case studies, providing accounting professionals with ethical standards to integrate into their practices. This event may be a rebroadcast of a live event and the instructor will be available for questions during the event.

For many business professionals, accessing and managing data in Excel is one of the biggest stumbling blocks when creating reports and analyses. Common practices include far too many manual processes and formulas, including never-ending manual processes needed to update your data and related reports. Make plans now to join us in this session to learn best practices for accessing and managing data using Excel. In this session, you will learn how you can use Power Query and other Excel tools to quickly access and manipulate your data and generate reports in record time! This is a “must-see” session for any business professional working with Excel!    

This program addresses the many complex financial and tax accounting issues that are common in S corporation transactions, with discussion of common pitfalls and the new AICPA "small" GAAP accounting standards.

Single Audits are an area of focus for the AICPA's Enhancing Audit Quality Initiative. The Uniform Guidance provides very unique audit requirements when auditing federal funds. This course will look into the unique performance and reporting requirements in Single Audits. Participants will have a basic understanding of internal controls over compliance, compliance requirements, how to use the Compliance Supplement, and the elements of a finding in a Single Audit.

One of the most talked about emerging technologies that has the potential to significantly disrupt the accounting profession is blockchain. This course is designed to bring you up to speed on what this revolutionary technology is all about. You will learn about the concepts, nomenclature, technology and potential applications related to blockchain. This will prepare you to participate in conversations about blockchain technology with your colleagues, peers and others. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Bitcoin and other cryptocurrencies have created a new generation of millionaires, with the benefit of anonymity. Whether the cryptocurrency is being used for criminal activity or held as a legitimate investment, the IRS is spending substantial resources in finding those who possess, purchase, and sell cryptocurrencies to ensure that the tax, banking, and money laundering laws are being followed. Are you or your firm prepared to advise your client when reporting cryptocurrency transactions? Can you identify when cryptocurrency is being used for potential criminal purposes? Can you prepare an accurate tax return related to cryptocurrency transactions? Do you know what questions to ask your client or what documents to request? This course will give you a brief overview of cryptocurrencies, how this new technology is being regulated, the common ways that cryptocurrencies are used to evade tax and money laundering laws, and what is expected from taxpayers and their return preparers when cryptocurrencies are involved. Your instructor is a former special agent with IRS-Criminal Investigation. He spent many years finding, investigating, and prosecuting tax and money laundering crimes that were using cryptocurrency as the form of payment. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Your home is now the digital center of your world, and even if you go to an office every day, you have more options to help you manage everything from shopping lists to email accounts. Unfortunately, many new devices your family connects to your WiFi can create security risks and may make remote work and school less secure. For example, tracking devices and services can help parents monitor children and seniors, but outsiders can use the same tools to stalk their loved ones digitally. This session will help you learn about devices, services, and app suites for families, share files, organize photos, manage passwords, and keep your home secure. Attend this breakout and learn about innovative new tools to help you stay safe and make the most of your time away from the office.

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.

The webinar will provide an overview of the regulated, legal side of the industry which now includes 19 states with recreational/adult use access and 38 states with medical access. This session will lay a foundation focusing on the modern historical background of the cannabis plant and the evolution of laws and regulations related to marijuana and agricultural hemp. The segment is designed to be useful for CPA practitioners desiring to provide or enhance their services within the cannabis and hemp niches. 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 2023 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 leighanne.conroy@acpen.com.

When federal prosecutors contemplate charges against business owners, two of their most potent and readily available tools include charges for mail fraud and wire fraud. The elements to convict for these crimes are clear: 1) The defendant devised or intended to devise a scheme or artifice to defraud, and, 2) in executing or attempting to execute the scheme, the defendant used or caused the use of mail or an interstate wire or wireless transmission. Mail, emails, cell phone calls, text messages, Internet transmissions, and even tweets could form the basis for charges of wire fraud or mail fraud. The crime of wire fraud is a reason that many business owners go to prison. In this course, we'll learn about a few people who've experienced a conviction for wire fraud. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Many organizations have implemented Microsoft 365/Office 365 at a basic level, but few have truly explored the breadth and depth of tools included with their subscriptions. Some less commonly known apps help you manage shared email boxes, create and use web forms, schedule appointments, trade shifts, create real-time closed captions, and translate presentations. Attend this session and learn more about the hidden features in Microsoft 365 that you can use to level up your productivity.

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.

This program will explain the new rules for deducting travel, meals and entertainment expenses and the TCJA disallowance of business entertainment expenses.  Documentation requirements and planning opportunities related to travel, entertainment, and automobile expenses will also be addressed.

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.