Append queries combine two or more queries into one output query that is a combination of the originals. This course discusses best practices for creating append queries using Power Query (Excel version) and includes hands-on exercises to enable the user to demonstrate what they have learned.Power Query is an "ETL" tool that extracts, transforms, and...
As companies look for greater investment returns in the current low interest rate environment, they are often investing in more risky types of investments, such as cryptocurrency. Further, as they look to hedge business risks, companies are frequently entering into derivative transactions, which both can contain unexpected risk and accounting complexity.As you advance in your...
Many of our clients are moving to one of the seven states with no personal income tax, particularly Florida and Texas. Others may maintain multiple homes with an eye toward eventually establishing residency in a state with no income tax. This course will give you practical tips for your clients seeking to establish residency in...
This course provides an overview of goodwill impairment testing. The accounting and reporting requirements related to goodwill are prescribed by the Financial Accounting Standards Board (FASB) in ASC Topic 350-20. This course focuses on topics such as the initial recognition of goodwill and subsequent measurement requirements including the accounting alternative allowed for certain eligible entities....
The purpose of this course is to provide an in-depth discussion of selected advanced-level issues affecting LLCs and LLPs.
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...
Most CPA firms perform some level of compilation and review engagements. And some perform engagements under attestation standards. Building off what you learned in the training in Level 1, Module 4, this course offers builds provides a deeper dive into the most frequently missed issues in compilations and reviews engagements. We will also focus on...
Consumers and businesses file for bankruptcy to seek protection from creditors and to reorganize or liquidate debts. Bankruptcy filings rise and fall with the economy. Surveys show that loss of income is the leading cause of consumer bankruptcies, followed by medical expenses and foreclosure. Corporate bankruptcies, on the other hand, are often the result of...
Both businesses and individual clients face major changes as a result of new legislation, and tax professionals face the considerable challenge of delivering effective planning advice and services to address this myriad of recent developments. This course addresses this challenge and also encompasses the latest cases and rulings applicable to individual and business clients. Continually...
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...
This one-hour course will focus primarily on Power Query, Power Pivot, and VLOOKUP skills. Users will learn how to join tables using various techniques and add-ons in Excel. Users will understand how to utilize the tools while maintaining data integrity. The majority of the course will focus on hands-on data exercises. Users will apply skills...
As experienced staff members master the preparation intricacies of an 1120-S tax return, they are expected to understand and apply the underlying concepts, principles and laws governing S corporation status. This course is designed to illustrate in both theory and practice overarching principles that govern S corporations from formation to revocation, termination and liquidation. Experienced,...