CPE + Events Catalog

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!    

OneNote is a fantastic application included in your Microsoft 365 subscription. Yet, it is underutilized and misunderstood most of the time. If you genuinely want to change how you work, embrace OneNote. Stop using Outlook as a filing cabinet for essential emails and move them to OneNote instead. If you share a OneNote notebook with others, you can stop emailing altogether within your group and use OneNote as your collaboration and reference platform.

Governmental entities are the second largest victims of embezzlement.  This seminar examines recent events involving the theft of public money and the circumstances that allowed the fraud to occur.  We will be looking at a variety of case studies to illustrate these points.  

Hacks, attacks, ransomware, malware – where does it end? Unfortunately, tech crimes continue to plague businesses of all sizes. Participate in this session to learn how you can reduce the risk of becoming yet another victim.

QuickBooks remains one of the leading accounting solutions for small and growing businesses and Intuit has added numerous advanced features to the application over the past few releases. In this seminar, you will learn how to take advantage of many of QuickBooks’ new and advanced features to solve important issues. For example, you will learn advanced inventory management techniques, including the ability to change the default costing methodology in QuickBooks, and implementing lot and serial number tracking. You will also learn how to build complete sets of financial statements in Excel that link in real-time to underlying QuickBooks data files and how to create multi-company financial statements. Additionally, you will learn how to put the Client Data Review feature to work to streamline the process of identifying and correcting errors and closing accounting periods in QuickBooks. Knowing how to take advantage of the advanced tools and features available can determine your level of success when working with QuickBooks. Take advantage of this opportunity to learn about QuickBooks’ “deep” features so that you maximize your effectiveness with the application.

The Secure Act 2.0 was passed in a flurry of year-end legislation. This one hour program will cover the important changes that employers need to know about company retirement plans. Employers will also need to consider how Secure Act 2.0 will the administration of existing plans or the creation of new ones.  This course will provide a concise look at these hot topics.   **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.

Anytime someone says "I want," "I need," or "Will you," you are in a negotiation. For decades, the negotiation techniques described in "Getting to Yes" by Fisher and Ury of the Harvard Negotiations Project were the world's standard negotiation methods. These techniques involved collaborative methods for discovering how to make the "pie" bigger and then split it. More recent research on human psychology has revealed new methods that will allow you to do even better. Sometimes, you can't settle for getting half of what you want. Sometimes you have to have it all. This webinar explores negotiation's human side, to give you powerful people skills that will let you get more. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The Secure Act 2.0 was passed in a flurry of year-end legislation. This one hour program will cover the important changes that individuals need to know about contributions to accounts and new ways of accessing these funds.  This course will provide a concise look at these hot topics.   **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.

Just as there is some convergence of U.S. accounting standards (GAAP) with international standards (IFRS), a convergence of U.S. professional ethics standards (AICPA Code of Professional Conduct) with the international Code of Ethics for Professional Accountants is continuing to emerge. This workshop compares these two sets of ethics standards, emphasizing both the theoretical aspects and practical implications for today's accounting professionals.

Even though they have been around for several years, the tax laws pertaining to S corporations remain some of the more difficult areas of the Internal Revenue Code. In this course, we will examine how S corporations break away from the normal tax rules for flow-through entities. We will explore which employee benefits are disallowed for S corporation shareholders, as well as which taxes are assessed at the entity level. Finally, we will discuss how state level taxation may have changed permanently with the addition of PTE elections.

Breaking the Wall of blind acceptance; avoiding habitual complacency and Yoking the dots between cause and effect.

Auditing contract revenue can be challenging. Long-term contracts can be even more difficult. Learn the knowledge necessary to conduct a successful audit of contracts, and the key issues affecting construction auditing, including auditing under the new revenue recognition and leases guidance.

Challenges and solutions of auditing contracts With construction comprising a large and growing portion of the economy, it's important to stay on top of the very latest in accounting and auditing changes for the construction industry. In this webcast, you will gain insight about: Audit planning and substantive auditing procedures The core knowledge necessary to succeed Key issues affecting construction auditing, including auditing under the new revenue recognition and leases guidance Audit risks and risk assessment

The GASB has been working on some big projects lately. 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 will then switch gears to the GASB standards coming down the pike, including the major projects of the GASB. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Don't let the title frighten you. It is critical that staff be trained on the increasingly complex forms-related issues that challenge them each busy season. This course will help experienced staff focus on the essential amidst the cacophony of IRS and legislative changes and avoid costly mistakes. This course brings to the forefront advanced preparation issues, from individual returns to flow-through entities such as S corporations, LLCs, and partnerships.

This course provides an update of the recent changes that have occurred in the financial reporting frameworks commonly used by small and medium-sized entities (SMEs). Troublesome areas in these financial reporting frameworks as identified in peer reviews and litigation will be highlighted. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

It is easy for us to get caught up in our work, but it is better to examine the ‘big picture’ by studying the outside factors that impact our business beyond our internal processes and day to day responsibilities. We are sometimes so busy with our tasks that we miss new developments until the developments have a profound impact on us and the organization. This session is designed to review many of these current trends, while thinking and discussing how these trends can impact our organizations and us. This is a fun and lively session that is intended to be interactive with participants either live, virtual or both. Our ever-changing world is evolving more than many realize.

The process of closing out the books every month can make year-end accounting a breeze! But isn't this time consuming? Not when you know the steps to take on a monthly basis. We'll show you what to do in QuickBooks Online as well as what you can do monthly to ensure a tax return that will stand up again an IRS audit. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Our guidance on ethics comes from the AICPA and other groups, but it does not fully address the “why” behind ethics. This session will examine and define what ethics is and what it means to varying people in the workplace. Understanding what motivates people and understanding those people are key to both solving ethical dilemmas and workplace issues that can lead to greater job satisfaction and efficiency. To correct an issue, you need to delve into the root cause – the why?

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.