CPE & Event Calendar

PivotTable is a fancy term for an Excel report that summarizes data. If you have not yet had the good fortune of exploring PivotTables, it is about time. In this session, we'll dig into PivotTables, understand the report layout options, and examine PivotTable formulas.

In today's fast-paced business world, staying ahead of the competition means leveraging every advantage. Business Intelligence (BI) is the game-changer that can transform your organization. Imagine uncovering hidden insights and gaining a competitive edge with data that was once out of reach. With tools ranging from Excel add-ins to the revolutionary Power BI, you can now harness your existing skills to create dynamic, interactive dashboards and analyses that were unimaginable just a few years ago. This program will empower you with the skills to implement "yourself business intelligence" using a variety of techniques and tools. You'll start by mastering advanced Excel data query and summarization features to create stunning Excel-based dashboards. Then, you'll take your knowledge to the next level by building even more powerful BI objects using Microsoft's Power BI tools. If you're passionate about gaining better insights into your data to make smarter decisions, this fast-paced program is for you.

If you perform Yellow Book audits and/or single audits, it is a given that a peer reviewer will be looking at your work on those engagements! Why fret and sweat about what peer reviewers are going to be looking for? In this course, we will explore the key audit requirements that peer reviewers focus on, how the auditor complies with those requirements, and common pitfalls seen in Yellow Book and single audits. This course will help you proceed and succeed in your Yellow Book and single audits.

This course explores the best practices for hiring remotely while leveraging personality assessments to make more informed decisions. Learn how to effectively integrate personality testing into your recruitment process to identify candidates who are the right fit for your team, even from a distance.

As financial and tax professionals well know, information overload is a constant struggle we face because things change quickly, and the sheer number of changes being made on a daily basis is enormous. Of great importance to small and medium tax and advisory firms is differentiating between changes that are relevant to our practice and our clients and changes that are new but totally irrelevant. Distinguishing between the two is difficult and time-consuming. Mike Tucker and a team of experts are pleased to present a weekly series designed to eliminate the clutter and get you what you need to stay up-to-date and perform for your clients. Mike and his co-presenters will dispense news on current events impacting taxes, finance, and industry. The subject matter will differ each week and intermittently include topics such as Social Security and Medicare. The panelists will discuss personal and corporate tax matters as well as other late-breaking news related to practitioners' personal finances and those of their clients. Every financial professional will benefit from this series. This is a cost-effective way for accountants to fulfill their compulsory continuing education because this weekly series will include almost 40 one-hour presentations. Sign up today — your clients and your bottom line will thank you.

This course will help you to stay current on recent changes to the AICPA Code of Professional Conduct, as well as keep you abreast of emerging trends in ethics standards and regulatory initiatives and their potential impact on your practice. We will also explore frequent practitioner ethics compliance challenges, including competence, due professional care, audit quality, and independence. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Accounting and finance practitioners are still grappling with the many changes OBBBA has made to the tax laws, many of which will impact tax filings. This program is an introduction to and review of some of these critical changes and their impact on taxpayers. Accounting and finance practitioners will gain a better understanding of this very complex set of new tax rules. Practitioners will grasp what is new and what is a continuance of prior rules to develop deeper insights into the many changes that the OBBBA made to the law. If you still feel you need to learn more about how OBBBA works, this program is for you. We have assembled a two-hour review and analysis of what we consider the most important changes from OBBBA that impact client transactions. To the extent that Treasury has provided guidance relating to these new OBBBA changes, we will discuss that guidance. Where guidance is lacking, we will point out areas that require future attention from Treasury.

Today's workforce looks a lot different than it used to. With more people working from home and across state lines, employers must examine withholding and unemployment laws in a new light. In this course, we will examine tried and true rules in this area and examine statutes that are still developing. Using real-life examples and discussion, we will examine state laws on reciprocity and residency requirements. We will also look at what to do when state laws are silent or conflict on a particular issue so you can keep your clients in compliance and be well-prepared for the questions that will come your way in these ever-changing times.

Almost every business and individual has to file tax returns, which can be a great treasure trove of information for forensic accountants. Whether in a divorce, partnership dispute, recreating books and records, or bankruptcy proceeding, analyzing tax return information should be an initial step in uncovering income and assets. The IRS retains a large amount of information, both from taxpayers and 3rd parties who report financial transactions. This course will be your guide in gathering, analyzing, and evaluating tax return information, so that you have a full picture of the financial investigation. Your presenter is a 20 year veteran with IRS-Criminal Investigation, who used this information as a basis for his federal criminal investigations. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

We’re all familiar with PDF documents. However, it’s safe to say that most professionals use only a tiny fraction of their features. This circumstance is unfortunate, considering all you can do with PDF documents. Therefore, isn’t it time to take another look at PDF K2’s Taking Another Look At PDFs documents and all you can do with them? Participate in this session to learn more about PDFs and how and why they should be a cornerstone technology in most organizations. Collaboration options, long-term storage and archival, and fillable forms are just a few features you will learn about in this session. If you’re ready to elevate your PDF productivity, this session is for you!

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 terri.storer@acpen.com  

The COVID-19 pandemic has altered corporate and public accounting in ways we could never have imagined. This broad-based course will discuss accounting and auditing implications that have arisen as a result of the pandemic.

The employer-employee relationship strains both sides in uncertain times, and businesses need CPAs, controllers, and other advisors to provide understanding of the complex legal, tax, and health care issues associated with all aspects of employment. This course provides in-depth coverage of this critical area.

Recent economic, societal, and political changes have shown us the need for numerous projects and the need to manage those projects in a unique way. Project management is a way of thinking highly recognized and practiced by large organizations, but often neglected by the smallest companies and entrepreneurs. This course quickly discusses the basics of project management thought and practice and then spends the majority of the time exploring some of the greatest mistakes that can be made, the ways to avoid them, and some of the tricks that have been introduced into the discipline. In the program we will explore some of the specific types of project management as well as some of the available software programs to make the task of project management easier.

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 auditing standards. 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.

As long as LLCs, partnerships, and S corporations form the backbone of many CPAs' practices, in-depth knowledge of all tax aspects of these entities will be essential. The purpose of this practical course is to focus on planning issues in creating, operating, and liquidating S corporations, partnerships, and LLCs. This course is essential for CPAs in public accounting and industry who advise these entities or their investors.

Specifically designed for preparation, compilation, and review practitioners, this course will provide you with a comprehensive review and hands-on application for performing financial statement preparation, compilation, and review engagements. You will learn the ins and outs of applying SSARS No. 21, Clarification and Recodification, as well as the additional guidance related to SSARS engagements through the issuance of SSARS Nos. 22-26 by the ARSC. In addition to SSARS 26, the entire suite of quality management standards is discussed. However, knowing the standards is not enough. You need to be able to effectively apply them. To support this, the course will review recent peer review feedback on SSARS engagements, providing insights on how to successfully apply this guidance. Not only will this course bring you up to date on SSARS requirements and guidance, but more importantly, it will provide you with practical examples and illustrations to help you effectively and efficiently perform these types of engagements. This course is intended to be your go-to reference for training your staff and managing your SSARS No. 21-26 services in compliance with professional, ethical, and technical requirements.

Financial statement disclosures are important to provide the information necessary for financial statement users to make economic decisions. Disclosures further explain and clarify information provided in the basic financial statements, but also provide critical information about subsequent events, litigation risk, and other concerns. This course focuses on the most common financial statement disclosures for small- or medium-sized nonpublic entities. 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 is designed for financial professionals looking to understand Form 1120S. It covers the essential aspects of S corporation taxation, including the preparation of Form 1120S, determining taxable income, and accurately reporting and allocating income, deductions, and credits. Electing Subchapter S status as well as reviewing the mechanics of electing Subchapter S status will be discussed. It will further compare the S Corporation to other forms of entities, along with compliance with corporate formalities. Highlights of Form 1120S will be discussed, including build-in capital gains, accountable plans, taxable fringe benefits, officer reasonable compensation and audit strategies. Schedules K-1, K-2, K-3, and effectively connected income will be reviewed in this course as well. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

What happens when businesspeople think they can lie and cheat at work, as long as it makes a profit? Some believe that business is like war, and there are no rules!  Do you really want to behave differently in business than in your personal life? Can, or should, ethics be ‘switched on’ or off?