CPE & Event Calendar

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.

The course provides general information on proceedings that led to a grand jury indictment of television reality stars, Todd and Julie Chrisley. Participants learn how business decisions can lead to federal charges for conspiracy, bank fraud, wire fraud, and tax evasion. The grand jury also indicted the Chrisley's accountant, Peter Tarantino, on tax-related offenses. Participants learn how to develop resources and tools for effective detection and deterrence of federal crimes, and the learn the consequences that follow white-collar crime, including how responses can influence lengthy prison terms. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

CPAs spend most of their working lives reviewing bank statements and books and records of businesses. They are experts in understanding how to prepare financial statements according to GAAP. But would a CPA know a possible money laundering transaction if they saw it? Would they know about a money laundering business? Money laundering is a subject of many action and thriller movies, but rarely understood. This presentation will educate the CPA in understanding the basics of money laundering and how to identify money laundering. This presentation will help the CPA know the truth about money laundering, how to identify it, the statutes that define it, and the court cases that interpret it. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

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. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Reading the AICPA Code of Professional Conduct can be a daunting experience. This course unpacks the AICPA Code of Professional Conduct by exploring practical considerations for accounting professionals. We will examine selected provisions that are relevant to CPAs in both public accounting and industry. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Recall lessons learned and practical implementation challenges and complexities with the FASB's Accounting Standard Update for Leases (ASC Topic 842). Identify key differences between ASC Topic 842 and ASC Topic 840, Practical Expedients, remeasurement-triggering events. Session will go beyond the basics and will apply to specific examples. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

When putting together a financial plan, it is important to remember that the tax situation of the business and the individual are often intertwined. Therefore, decisions about entity type are vitally important. Practitioners need to understand not only how different entities are taxed, but also which taxes will have the greatest impact on the individual owner. In this course, we will explore when self-employment taxes apply to business income, as well as some of the lesser-known taxes that apply to flow-through entities. We will even explore when a PTE election could be helpful to a small business owner.

Buying and selling a business can be a complex transaction with many tax issues. These issues include whether the transaction is or should be a stock or an asset sale when the business involved is a corporation, as well as the tax consequences associated with the sale of a partnership or a C or S corporation. Tax practitioners who advise clients who are buying or selling a business primarily focus on the tax issues that apply. This program explains and analyzes the tax issues practitioners must address in order to properly advise clients who are either buyers or sellers of businesses.

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.

Bitcoin, the original cryptocurrency, was released in 2009. After 15 years the cryptocurrency market consists of over 5,000 unique coins/tokens with a market capitalization of over 1.5 trillion as of 1/1/24. This course will provide an update on the cryptocurrency market and the blockchain technology that supports it. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Appreciation affects your bottom line and your workplace culture. Don’t think so? Think again! Your customers, clients, and co-workers want and need to know they are appreciated. How do you show them appreciation? You show them in their preferred appreciation style.  You have a bias for how you like to receive appreciation, and so do the people with whom you work. In this program, we will build on the research of Gary Chapman and Paul White on appreciation languages – words, time, service, and gifts.  Appreciation is a skill and practice that promises to influence your work life positively. You will experience strategies you can employ in your day-to-day lives to improve your team culture and manage work relationships.

Significant changes in the audit environment for 401k plans have resulted from recent U.S. Department of Labor reviews of 401k audits and the issuance of Statement of Audit Standards Number 136 (SAS 136), the Auditing Standards Board's new standard for employee benefit plan audits. This course will assist the audit professional with guidance needed to perform 401k audits in the upcoming year. We will discuss the significant changes from SAS 136 and other recent auditing standards, including both the auditor's and plan sponsor's responsibilities when electing and performing an ERISA Section 103(a)(3)(C) audit, which replaced the former limited scope audit. We will also focus on the most common compliance issues identified in 401k audits from both the Department of Labor and peer reviews, along with best practices and recommended corrections.

Joshua, a CFO from Chicago, did not go to prison for stealing the $2 million in liquid cash he had access to on a daily basis. Instead, Joshua ended up in prison by rationalizing that he was entitled to a few small perks of the profession. This course explores Joshua's story and covers how and why executives with high annual incomes make short-sighted decisions that can cost them their job and freedom. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Review the availability and application of three special rules that allow exclusion or deferral of gain from the sale of the stock of a corporation not making the S corporation election. IRC 1202 provides that all or part of the gain from the sale of "qualified small business stock" can be excluded from gross income. IRC 1045 describes situations when the gain from the sale of "qualified small business stock" can be deferred. To understand the application of these two favorable provisions, the meaning of "qualified small business stock" and other requirements and limitations must be understood. IRC 1042 allows the deferral of gain from the sale of corporate stock to an employee ownership plan ( ESOP). This deferral requires a qualified reinvestment in an adequate amount at the right time. Study how these three provisions apply in the context of tax planning for corporate businesses.

This course allows you to get reacquainted with the statement of cash flows. We will refresh your skills regarding both the preparation and utilization of the statement of cash flows. Significant emphasis will be placed on the informational role of the statement of cash flows and insights that can be obtained using the statement of cash flows in concert with the other elements of a company's accrual-basis financial statements. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

How do you raise your skills to the next level to master the Controller or CFO role?  Welcome to a course that provides insights that align the CGMA Competency Framework. The course will examine each of the areas: Technical, Business, Leadership and People to increase your competency.  How are your technical skills?  Are you a traditional accountant or have you learned to expand your technical skills to go beyond “what are the financial numbers?” to “why did these financial results occur?”  Are you able to use ratios to understand the business dynamics and the implications to change course or take corrective action?  Are the systems that you implement and operate best practices or merely stop-gap solutions? How are your business skills?  Can you set a vision? Can you develop a strategy?  Do you understand the macroeconomic environment of your organization?   Can you lead a major project to a successful conclusion?  This session will explore the role of business as opposed to tracking the results of the business. How are your people skills?  How good is your ability to influence others? How are successful are your negotiation skills?   How well can you communicate?  Are you a collaborator or a partner?  This section will help accountants understand that it is people skills that drive the overall success of the accounting operations. Finally, how are your Leadership skills?  Do you inspire staff or make them angry?  Do you know why your staff work for your company and you?  Do you understand what employees want from their position?  Do you know how to deal with a difficult staff person?  Can you lead difficult change?  This session will help you recognize what leadership truly is as opposed to what passes for day to day management.

This program analyzes and applies the AICPA Code of Professional Conduct and other sources of ethical guidance 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 to answer your questions during the event.

Common Audit and Financial Reporting Deficiencies in State and Local Governments, is a 2 hour webcast detailing many of the more common mistakes that auditors and accountants are making in either the preparation of their annual financial statements or the audits of such financial statements. Deficiencies in audit standards (AICPA, GAO, Single Audit) and preparation standards (GASB) noted in this webcast are driven by the most recent results found in audit organization peer reviews, workpaper or desk reviews, and various organizations checklists for oversight. 

Designed for accounting and attestation practitioners at all levels in both public accounting and business and industry, this course provides a detailed review of SAS No. 145 and brings you up to date on FASB and AICPA standards issued over the past few years. The course also provides many hands-on examples and illustrations to help apply the guidance in practice and discusses other important A&A practice matters to be aware of, including an update on peer review and audit quality.

The need for a forensic accountant has grown in the last two decades, with more expected in the future. From oil well spills to divorces - from stealing trust funds to partnership disputes - forensic accountants are needed to find and calculate losses. They are financial detectives that are needed to explain the money story to attorneys, judges, and juries. If you are interested in starting a forensic accounting practice or adding on this service to your existing firm, this course is for you. In this presentation, you will know what service to provide possible clients, how to find those clients, and the cost-effective ways to start the forensic accounting practice. Your instructor has over 20 years of experience as a special agent with IRS-Criminal Investigation where he conducted investigations into tax and money laundering crimes across the globe. After his successful investigative career, he started a CPA firm from scratch that focused on forensic accounting. He shares the successes and failures in starting a forensic accounting practice, including getting the right credentials, various ways of marketing to potential clients, closing the deal with engagement letters, and delivering the service to the client. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.