CPE Catalog & Events

Please join us for an introductory course in international cross border transactions. We will discuss typical situations in which a cross-border transaction arises, and how a taxpayer can utilize the rules to potentially decrease an entities effective tax rate. Other issues, such as documentation and IRS audit risk will also be covered. These rules will be illustrated by a hypothetical US- Canada transaction.Speaker - Allison M. McLeod, LL.M., CPA. A PLLC

Governmental accounting is very unique. This course will introduce the financial reporting basics for governments, including fund accounting and the modified accrual basis of accounting. Attendees will analyze the layouts of the fund financial statements as well as the government-wide financial statements.Speaker - Melisa Galasso

Nonprofits face unique accounting challenges. This course will introduce attendees to the financial statements and unique accounting principles applicable to not-for-profit organizations. Specifically, we will focus on the typical transactions and account balances unique to NFPs, including net assets, agency transactions, contributions, endowments, and programmatic investments.Speaker - Melisa Galasso

Please join us for a discussion on like-kind exchanges (LKE), known as one of the last great tax legal "shelters" available to those buying and selling real property. We cover the basic structure of a LKE, and ways a taxpayer can utilize qualified third-party intermediaries (QI), and tenancy-in-common structures including Delaware Statutory Trusts (DST). We also explore creative solutions to sticky situations a taxpayer may find itself in obtaining replacement property. This course is ideal for CPAs, EAs, lawyers, real estate professionals, accountants or other tax professionals.Speaker - Allison M. McLeod, LL.M., CPA

Today's CPAs can expect their prospects, clients, referral partners, and candidates to research them on LinkedIn. The good news is that you can leverage LinkedIn to craft a digital presence that demonstrates your expertise, showcases your personal brand, and aligns with your values. Learn how to create a LinkedIn profile that is not just a resume but a valuable marketing tool for your CPA business.Speaker - Sandra Long

This CPE course provides an overview and changes with respect to ASU 2016-14 Presentation of Financial Statements and ASU 2016-18 Restricted Cash and Cash Equivalents in Statement of Cash Flows for Not-for-Profit Entities. This course provides common pitfalls and tips on functional expense reporting and, how to manage liquid resources, common peer review findings related to ASU 2016-14, and tips and suggestions on a successful audit. This course also reviews items to consider, given COVID-19, when preparing for an audit and reviewing financial statements. The instructor will explain the key facts and impacts of ASU 2018-08 Clarifying the Scope and Accounting Guidance for Contributions Received and Contributions Made, ASU 2019-03: Updating the Definition of Collections, ASU 2019-06: Extending the Private Company Accounting Alternatives on Goodwill and Certain Identifiable Intangibles to NFP Entities, and ASU 2020-07 Presentation and Disclosures by NFP Entities for Contributed Nonfinancial Assets. Lastly, this course will cover Cybersecurity Issues.Speaker - Adelina Burke, CPA

A discussion of the latest tax provisions and their impact on non-profit entities, including charities, hospitals, and universities.Speaker - Steven C. Dilley, CPA, JD, PhD

We have all heard the statement that it is the people that work at a company that gives it value. It is, sometimes and unfortunately, also the people that provide fraudsters with an entry point into an organization that can lead to hardship. This is even more true now because cyber-attacks on both organization and individuals have increased notably. Many highly publicized corporate hacking events are successful, at least in part, because an individual was targeted. In this session, we look the types of fraud that take aim at individuals with a special focus on the growth of cyber-attacks. We then discuss measures that can be put forth to help employees protect both themselves and the organization.Speaker - Karl Egnatoff

Many leaders in business organizations of all sizes view the system of Internal Control almost purely as a protective security measure. A well-designed internal control system can and will drive all entity objectives which includes successful operations. This session uses information gathered from years of creating internal control systems as well as concepts from well-respected authoritative pronouncements and frameworks to illustrate the power of a strong and well supported control system as well as actions that can help establish such a system. Those that work with internal controls who are tasked with developing ways to improve operation level capabilities should strongly consider this session.Speaker - Karl Egnatoff

This program addresses the most recent developments impacting partnerships operating as LLCs, with a focus on legislative, administrative, and tax form changes. Emphasis will be placed on partners "tax basis" capital accounts, now required for tax form reporting.Speaker - Steven C. Dilley, CPA, JD, PhD

A detailed analysis of the calculations related to determining a partner's tax basis for a partnership interest. How to use the Form 1065 and Schedule K-1 information for basis determination will be reviewed. An illustrated example with filled in forms will demonstrate how the process works, including its many potential pitfalls.Speaker - Steven C. Dilley, CPA, JD, PhD

The course will cover the basic requirements of a peer review performed in accordance with the AICPA's Peer Review Standards for firms that perform preparation, compilation, and review engagements. Topics to be covered include the documents reviewed by the peer reviewers, the evaluation of the engagements, the types of matters and peer review reports, the administrative process, the peer review committee involvement, and the requirements of the state boards of accountancy.Speaker - Allison M. Henry, CPA, CGMA

Personality Styles - Adapting to Different Types of Personalities for Improved Relationships and Interactions provides guidance for effectively adapting to various personality styles. Every individual has a dominant personality style, which includes relevant strengths and weaknesses. Effective interactions require individuals to adapt behaviors to complement, balance or counteract the traits of others.Speaker - Jennifer F. Louis, CPA

Excel is a popular tool for data analysis, yet most users have never learned the basics of data analysis using Excel or the tools that Excel offers to help with data analysis. This session is designed to teach participants the importance of PivotTables for analyzing data. We will demonstrate how PivotTables can make data analyzation an easy task for all accountants. Participants will learn the step-by-step process to create PivotTables and PivotCharts. We will also cover all the setup options and features. 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.Speaker - Bryan L. Smith, CPA.CITP, CISA

Most accountants use Excel to help them make decisions about their data. However, as the amount of data grows, it becomes difficult to make strategic decisions based on rows and rows and columns and columns of data. In this course, you will learn how to build robust dashboards for analyzing key metrics in Excel. We will begin with some dashboard design guidelines, such as understanding your audience and identifying necessary metrics. Then, we will work through creating key performance indicators (KPIs) for the dashboards. You will learn how you can add charts and eye-catching visuals, in order to make your dashboards easily understood. This course focuses on using standard Excel features to create visuals. Although we will introduce new tools like Power BI Desktop, this course is NOT about using Power BI to create visuals. This session is presented using Excel 2019. Regardless of the version you are using, most concepts covered in this course apply to all versions of Excel.Speaker - Bryan L. Smith, CPA.CITP, CISA

This course focuses on using the Power Pivot features to enhance data analysis. We will review the 4 features of Power Pivot (data model, calculations, hierarchies and KPI's) and you will learn how you can use each of these features. Although, the majority of the time will be spent on building the data model and using calculations. You will learn how to add data to your data model either directly into Power Pivot or from Power Query. We will discuss the benefits of the data model relationships versus using the VLOOKUP function to access data in different tables. One of the strengths of Power Pivot is the formula language called DAX (Data Analysis eXpressions). We will introduce DAX so that you can use basic DAX formulas to build various calculations in the data model. You will learn the difference between calculated columns and measures as we build these various calculations into our data model. This session is presented using Excel 2019/Office365. Regardless of the version you are using, most concepts covered in this course apply to all versions of Excel.Speaker - Bryan L. Smith, CPA.CITP, CISA

Excel is a popular data analysis tool, yet most users have never learned the basics of data analysis using Excel or the tools that Excel offers to help with data analysis. Those that learned to analyze data using PivotTables, soon learned there were many weaknesses in PivotTables that resulted in elaborate calculations in order to perform simple tasks. In 2010, after much development and little hype, Microsoft released Power Pivot, a new data analytic tool that removed the weaknesses of PivotTables. This single product took Excel from a low-end data analytic tool to one of the most sophisticated and comprehensive tools. Since 2010, Microsoft has continued their development of end-user data analytic tools. This entire suite of products is called Power BI. In this session, we will provide an overview of the various Power BI tools and discuss Microsoft's Power BI Strategy. We will begin by explaining the challenges faced by many accountants when it comes to analyzing data in Excel. You will learn how each Power BI tool reduces the challenges and improves your data analytic skills. You will also gain a complete understanding of when to use which tool. This session is an overview of the various Microsoft Power BI tools and should be your first step in learning the complete set of Power BI tools. As an overview, we will not be teaching the details of each tool but you will receive a thorough understanding of what each tool can accomplish. 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.Speaker - Bryan L. Smith, CPA.CITP, CISA

This course is an extension of the Power BI series of courses that specifically explores using OLAP formulas and advanced time intelligent functions. OLAP formulas provide the ability to create a calculation in a cell that is based upon the measure in the data model. This powerful tool provides the ability to create calculations in an Excel worksheet without using a PivotTable to perform the calculation. Gone are the days of creating a PivotTable, then using those values in the PivotTable for additional calculations.When using Power BI to build a data model that connects to data files, you may want to know the date of these files. This class teaches you how to create a measure based upon the refresh date of your data. In the class "Power BI - Use Advanced Calculations with DAX Formulas," you learned the basics of time intelligent functions, the ability to calculate measures based upon dates. In THIS course, we will take it to the next step and teach you how to perform many more date-based calculations.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.Speaker - Bryan L. Smith, CPA.CITP, CISA

Before you can analyze data, you first must get the data. This course focuses on getting data into Excel using different data sources. Whether your data is text, comma delimited (CSV), reports, Excel, databases, web, applications and/or many others, Excel provides the ability to access that data. You will learn about tools that have been added to Excel that will make accessing that data even easier, such as data models and Power Query (Get and Transform). After this class, you will finally be able to get the data you need to perform data analysis.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.Speaker - Bryan L. Smith, CPA.CITP, CISA

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.Speaker - Bryan L. Smith, CPA.CITP, CISA