CPE Catalog & Events

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.

Save time and keep current on the latest tax developments. This course covers all legislative, judicial, and IRS developments of the past year with a focus on implementation and compliance. Discover how to effectively and confidently complete tax planning and compliance engagements. Cover current developments affecting individuals, estates, and trusts (including those regarding income, deductions and losses, tax calculations, individual credits, filing matters). Gift tax matters are also covered.

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).

Internal controls are more important than ever, and their importance increases daily. However, internal controls present a challenge for many smaller organizations. This program will teach you how to evaluate, develop, and implement an effective internal control structure in a small business environment. You will identify how to assess risk in smaller organizations and implement preventive, detective, deterrent, and compensating controls to mitigate these risks, even without proper segregation of duties. Additionally, participating in this program will teach you technology-focused techniques for preventing and detecting fraud and securing information systems and sensitive data. For small organizations, maintaining an effective system of internal controls presents a significant challenge. Realistically, implementing many theoretical concepts surrounding internal controls may not be possible in some cases. Consequently, many internal control structures foster an environment where too much risk exists. This factor and uncontrolled information systems can often lead to disastrous results. Participate in this program to learn the necessary insights and tools to design, implement, and monitor effective internal controls, security, and anti-fraud measures in small organizations.

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.

What if being nice, or specifically being a positive best version of yourself, made you a more effective leader?  Ethical leadership, is effective leadership. That’s what Dr. Cohen, noted psychologist, transformational speaker, executive coach, and author of Be The Sun, Not The Salt, has been teaching organizations to do for years. Dr. Cohen’s work is based on scientific studies of human behavior broken down into simple, easily digestible pillars structured around the Heliotropic Effect. In this webcast we will discuss Dr. Cohen’s path to this work, what the Heliotropic Effect is, and how Be The Sun, Not The Salt is the perfect reminder to Do More of That every day.

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.

Conflict is inevitable whenever you have more than one person working together. But conflict doesn't have to be a bad thing. In fact, it's through conflict that some of the most productive conversations, changes, and innovations can occur in organizations...when they're navigated through effective communication. This workshop is designed to help you more strategically approach difficult conversations in the workplace and will arm you with both an understanding of how our minds approach these tough conversations and tools that you can use to approach these conversations more impactfully.

Performance targets and incentives can drive breathtakingly positive results: the moon landings, the eradication of smallpox, or the repair of the ozone layer, for example. They can also have a dark side that can create stress, overload and anxiety and even drive lawbreaking. What is the difference between a healthy ‘stretch’ target and one pushes people too far? How can we spot potential problems in advance and systematically design sensible, humane and effective performance targets? Using practical examples and case studies, Bernie will give you an overview of the essential steps for designing robust, effective, and credible targets for any organization. Designing effective, practical and realistic performance targets will never be easy, but this session will introduce you to the tools that help make the process clearer, simpler and more consistent.

In 2020, 96% of the world’s largest 250 companies published reports on their sustainability performance in accordance with national and international standards.   Now many more companies are committing to sustainability, and Net Zero emissions in particular.   This creates a new responsibility and opportunity for HR leaders.   Staff must be trained in new policies, goals and procedures.  Executives need help as leaders in this new approach.  This one-hour course summarizes SHRM research into HR and sustainability, plus other expert sources and the instructor's own 30-year journey helping companies become more sustainable.   The course presents key concepts, tools and sources to help HR find its role.

Join us for a discussion on what has changed in 2024 for the CTA. This course covers the latest on the Corporate Transparency Act (CTA). We will discuss the new filing timelines, including the recent extension, and will make sense of the broadened definition of "beneficial owner". We will also discuss the ruling in Alabama that has changed things. By the end of this, you’ll have the know-how to craft solid compliance plans that don't just check boxes but work seamlessly in the real world. Expect to leave armed with concrete tips for keeping your clients while staying away from any fines. Make sure you are up to date with the newest financial regulations. **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 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.