CPE + Events Catalog

What do you need to get ahead? In this day and age, we live in a network economy - - it's all about who you know, who knows you, and what they know about you. In this talk Connector's Advantage author Michelle Tillis Lederman explains the types of relationships you want and need, how to adopt the Connector's mindset and move up the Connector spectrum to get better, faster, and easier results. At the end of the day it is the strength of your relationships that leads to your success.

Yes, taking an ethics course is a requirement to keep your license. But that doesn't mean that an ethics course can't be practical and meaningful. This update course is meant to give the tax practitioner two hours of ethics CPE but at the same time provide a detailed analysis of the Circular 230 rules for conduct of a tax practice. Best practices and guidance issues will also be provided. **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.

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 and dive 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 barber, blacksmith, butcher, baker and candlestick maker used to have an intimate knowledge their customers. This tacit knowledge got lost in the Industrial Revolution. It is now coming back. The world is moving from products and services to subscriptions, favoring access and transformations over ownership and deliverables. McKinsey reports that the subscription ecommerce market has grown by more than 100% per year for past five years. Further, subscription-based companies are growing eight times faster than the S&P 500 Index (17.6% vs. 2.2%), and five times faster than US retail sales (17.6% vs. 3.6%). The advantages to a subscription model include predictable revenue, collective knowledge of your customers, one-to-one marketing, forecasting for demand and planning more effectively, breaking down silos and creating a true "one-firm" model.

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.

How to pay for the cost of long-term care remains a primary concern for most clients over the age of 50. Explore clients' motivations, misconceptions and objections to purchasing long-term care insurance, and a look at the latest long-term care solutions, including hybrids. 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 #9 in the Microsoft Power BI series of webinars. Click button in Program Content section below to see suggested viewing order. * What good is data analysis if you can't share it? This course will focus on using Microsoft's cloud-based sharing/publishing platform, PowerBI.com. You will learn the interface as well as the benefits of using PowerBI.com. You will learn how to use PowerBI.com to leverage the work performed in Power Pivot or Power BI Desktop. Using PowerBI.com to create visuals is very similar to Power BI Desktop, so we will only review this feature. If you want detailed instructions on creating visualizations, please attend the Power BI Desktop course. This class can be taken with no Excel or Power BI Desktop knowledge, but some concepts will be a repeat from those classes and will serve as a knowledge reinforcement for experienced users. Many data analysts may create models in Power Pivot or Power BI Desktop, so we will spend time to learn how to share that data with PowerBI.com. This will ensure that everyone is looking at the same data, no matter the toolset. PowerBI.com adds the ability to create and share dashboards, so we will demonstrate how to create visualizations that can be turned into dashboards that allow users to customize their PowerBI.com with dashboards that are meaningful to them. This session is presented using Excel 2019/Office 365. Regardless of the version you are using, most concepts covered in this course apply to all versions of Excel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Schedules K-2 and K-3 are promulgated by the IRS in order to standardize the reporting of foreign-related tax information for pass-through entities. Even pass-through entities that have no foreign activities, investments, or partners may have a reporting requirement. Schedules K-2 and K-3 for reporting partners' income, deductions, and credits from foreign activity are now required for passthrough returns (Form 1065, 1120-S and 8858). This requirement starts with returns with a tax year that ends in 2021. This course discusses each part of these schedules and explain these new reporting obligations in detail. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

With the AICPA's heightened focus on enhancing audit quality, increased oversight of the peer review process and the auditor's overall responsibility to provide high quality services, the focus on compliance with professional standards has never been greater. Recent peer reviews have indicated that auditors are often failing to perform and/or document certain critical components of an audit such as the auditor's assessment of risk and linking the results of the assessment to substantive procedures performed. In addition, auditors are not adequately documenting their consideration of fraud, expectations in analytical procedures and the appropriate level of work needed to understand an entity's internal control. Now is time to revisit the way that auditors are performing and documenting the work performed to meet professional standards since nonconforming engagements can result in an auditor's referral to the AICPA Ethics Committee. The ASB has not made significant changes to its quality standards since 2006. There are currently three standards on quality management in exposure draft that are expected to be issued in the second quarter of 2022. These changes will be substantive. This course will discuss the new standards. This course will also focus on the most significant items resulting in deficiencies identified in the peer review process. We will also discuss the applicable audit standards, documentation requirements and best practices. The objective of the course is to provide the insights necessary to help an auditor improve not just the quality of their work but also the perception of the accounting profession as a whole.

This program will provide a detailed analysis of the real estate professional passive activity rules, including forms reporting examples, and integrates those rules with when real estate is considered a "business" under the Section 199A flow-through entity deduction, A detailed analysis of the self-rental passive activity rules will be given, including forms reporting examples and integrates them with the flow-through entity rules related to self-rental. **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.

COSO framework overview Gain an overview of COSO's internal control framework comprising five components and their related principles. Learn how to evaluate the control environment, risk assessment, control activities, information and communication, and monitoring activities at your or your client's entity. Through real-life examples, enhance your understanding of how to apply the framework as it relates to financial reporting whether you are an auditor or entity management.