CPE + Events Catalog

This program addresses the critical issues and special opportunities facing S-corporations, with a focus on reporting shareholder basis and distributions.  **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 QuickBooks platform is a robust environment with features and capabilities that many users are unaware of or do not know how to utilize effectively.  This course helps you get more out of QuickBooks Desktop and QuickBooks Online and resolve the issues that even experienced QuickBooks users struggle with, such as locking down prior periods.  This program starts fast with a chapter covering the top issues accountants face with QuickBooks.  The day continues with practical guidance and solutions designed to help accountants get the most out of QuickBooks for themselves or their clients. You will learn about issues, such as setting up a new company, configuring and customizing QuickBooks preferences, and enabling system security and password protection features.  Also, you will learn how to lock down transactions in prior periods, the audit trail, customizing reports, exporting reports to Excel, and extending QuickBooks’ usefulness with tools such as the Fixed Asset Manager and Loan Manager.    

This session will explore the ethical considerations CPAs and CPA firms should be cognizant of when considering services to the state legal, regulated cannabis industry. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

You don’t need an accounting degree to harness the power of Microsoft Excel. This course shows how Excel makes sense beyond dollars and cents. We will focus on fundamental concepts for creating, editing, and utilizing Excel content. Participants will learn how to use Excel’s menus and other functions to craft Excel workbooks. Because this course is designed for newer users, we intentionally offer a broad overview of Excel’s numerous capabilities with in-depth coverage of selected resources tailored for non-accounting applications.

This course goes beyond the basics and addresses important practical issues that an experienced practitioner must know about S corporations.

Understanding the dynamics of family interaction is one of the most important skills in helping a family business succeed. This course takes a candid look inside the family business, and will help the participant navigate delicate issues while learning to provide counsel that will grow - or protect - the family business and non-family staff.

Tax professionals can get caught up on all the latest developments in the areas of individual, estate, trust, and gift tax in this comprehensive course.

Any corporation or individual can be vulnerable to scams and hoaxes. Learn how to break down the deception into the psychology of the con. We'll review best practices to avoid embezzlement and fraud and case studies of embezzlement, including payroll scams, fraudulent payees, skimming and new technology scams. Fraud can also arise when companies downsize and technology goes missing because there aren't enough gatekeepers on watch. Learn about opportunistic vulnerabilities that stem from having few employees/contractors and using free software.

We're all impacted directly or indirectly by the laws of real estate taxation, possibly as an owner, investor, landlord, developer, or real estate professional. This course explores the key principles of real estate taxation from all these perspectives. We'll discuss personal residences, vacation homes, depreciation, credits, passive losses, qualified business income, installment sales, involuntary conversions, like-kind exchanges, and real estate investment trusts (REITs).

New Technology, the move toward telecommuting, the widespread adoption of electronic documentation, and a wide range of other factors have significantly and forever changed the way business is conducted. It should go without saying that changes in tools and methods lead to upheaval in any organizations internal control system. In this session, we look at all the changes that are occurring and discuss what's coming in the not too distant future. The material then looks at how internal controls have been affected and what other updates are on the horizon. Anyone trying to use controls to keep their organization efficient and secure should consider this session because the rate of change to both operational methods and control processes has been and will continue to be incredible. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

If you work with governments and not-for-profits, a thorough understanding of the Yellow Book is essential. This course will equip you with a comprehensive knowledge of the Yellow Book requirements and increase your confidence and proficiency in performing Yellow Book audits. The course materials utilize a highly illustrative and innovative format including over 20 focused exercises on key practice issues.

Looking to improve the quality of your 401(k) benefit plan audits? This is the course for you. Based on recent data from the U.S. Department of Labor and peer reviews on employee benefit plan audits, we know auditors need to up their game to meet stakeholder demands and provide the best possible audit services. In this advanced course, we will discuss the audit and reporting requirements in accordance with SAS 136 and other recently issued SASs. We will also discuss laws and regulations (such as ERISA) that are unique to employee benefit plans and provide practical guidance on their application. Course topics will focus on the most common compliance issues identified in 401(k) audits by the Department of Labor and peer reviews, as well as recommended corrections. Auditors will identify best practices for auditing areas such as payroll and compensation, participant loans, hardship distributions, investments, and plan mergers and acquisitions.

For the past two decades the trend has been to move away from brick and mortar offices and have a greater number of people work or telecommute from home. Because of the upheaval caused by recent events, the rate of this move has been accelerated. This has and will continue to create control challenges and organizations must work to address these. Such things as moving from time based employee value to task completion based measurement and the ability to drive needed inter-company communication are just a sample of the issues with which entities must contend. This session looks at the benefits and pitfalls of workers that telecommute. It then discusses important risks and controls to consider as this trend continues and evolves in the business world. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The AICPA has determined than 1 in 10 firms are not compliant with the risk assessment standards. This course will discuss how to properly identify risks and assess risks under AU-C 315. We will then review how to respond to identified risks under AU-C 330. The course will focus on the inherent risk model. We will also review common deficiencies and how a proper risk assessment can drive a more efficient and effective audit.

Small businesses have better options now than ever before in the market of accounting solutions. Participate in this session to learn more about these options and which might be best for you or your clients.

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.

Do you love PivotTables? Of course, we all do! Traditional PivotTables are incredible, but they do have limitations. If you have ever encountered one of these limitations, you'll be excited to learn that by using the Data Model as the source for PivotTables, you'll be able to bypass many of the restrictions that exist with traditional PivotTables. The data model (also referred to as Power Pivot) is included in Excel 2016+ for Windows and available as a free download for previous versions (excluding Excel for Mac). Using the data model enables you to build PivotTables that were previously not practical. If you frequently build PivotTables and would like to do more with them, you'll want to understand how to use the data model (Power Pivot) to enhance your reports. Note about Excel versions: Power Pivot is not available in all versions of Excel, including Excel for Mac. If you would like to see if Power Pivot is available in your version of Excel, visit the Microsoft site.

We kick off this course with a look at the GASB standards that are effective this year including GASB 100, Accounting Changes and Error Corrections and GASB 101, Compensated Absences.  We then move to the NFP side of the house with a look at the Accounting Standard Updates issued by the FASB that impacts nonprofit entities. Following that, we review the work of the Not-for-Profit Advisory Committee (NAC) and the projects they advise the FASB on. After the break, we will conduct a deeper dive into Yellow Book and Single Audit engagements. The course closes with a look at the significant changes in the 2024 Compliance Supplement, the changes to the Uniform Guidance and the common deficiencies identified by the federal agencies and peer reviewers. 

Gear up for tax season with Steve Dilley's annual update!  This program provides an update to the latest tax developments, rules and regulations affecting both business and individual taxpayers, including a review and integration of 2023-2024 legislation.    **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 a great foundation to introduce new preparers to tax rules related to business returns. The course provides new staff coverage of tax areas affecting all business entities, providing staff training which they may carry to other business entity returns. Such business tax topics include the sale of assets used in any trade or business (Form 4797), depreciation (Form 4562), deductible vs. non-deductible items, and the basics of uniform capitalization. The objective of this course is to train new staff accountants, data processing employees, paraprofessionals, and bookkeepers to prepare a complicated federal corporate income tax return. It is a hands-on, practical course in filling out most tax forms, with extra emphasis on form changes due to new tax law.