The most difficult concepts to master when dealing with flow-through business entities are the basis and distribution concepts. Major error and malpractice issues occur if the CPA does not fully understand the impact of these rules. This course is designed to focus on the practical applications of these rules.
One of the major transactions CPA clients are faced with is the purchase or disposition of a business. To help tax professionals advise those clients, this course offers a comprehensive analysis of the business and tax aspects of buying and selling a business. It is a practical guide to help practitioners and industry CPAs understand...
This course covers a number of useful transformations using Power Query (Excel version) to clean, enrich, and shape data. Coverage includes pivoting and unpivoting, filtering and grouping, fuzzy matching, and more, with hands-on exercises for users to practice these skills.Power Query is an "ETL" tool that extracts, transforms, and loads data. This tool has a...
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...
The "name of the game" in virtually any business (or profession), and most certainly for Internal Auditors, is adding the greatest possible value to and for all stakeholders of that business/profession. Internal Auditors serve a wide variety of stakeholders who place major reliance on their work. Maximizing IA value in terms of assurance levels expected...
2021 will be a very impactful year for audits, as SASs 134-140 become effective for audits for year-ends after December 15, 2021. In this course, we'll review the key changes coming to financial statement audits as a result of these new standards, including the format of the new auditor's report and consideration of key audit...
This course will take new and administrative staff from the most basic concepts to a full understanding of individual tax return preparation - just in time for the crunch of busy season! Updated for impacts of recent legislation, including the SECURE Act 2.0, the Inflation Reduction Act, American Rescue Plan Act, the Consolidated Appropriations Act...
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...
Employment taxes are often overlooked as an area where more planning may be effective. Payroll taxes have become an increasing burden for the average business and IRS penalties for noncompliance have risen dramatically in recent years. As a result, they have also been subject to employer incentives. The Service has announced that uncovering noncompliance by...
Designed to keep you up to date on recent activity of the Financial Accounting Standards Board (FASB), this course will summarize recently issued Accounting Standards Updates (ASUs) issued by the FASB in 2020 and 2021 year to date. The course will discuss the main provisions of the ASU, application guidance, and information on transition and...
This highly informative course comprehensively covers all the latest tax law developments. The focus is on individual taxation and discussion of the planning opportunities practitioners need to understand to help clients respond effectively. You will come away from the course with the up-to-date knowledge to educate your individual tax clients and implement tax-saving ideas that...
This course guides you through creating formulas using Financial, Date & Time, Math & Trig, Statistical, Lookup & Reference, Database, Text and Logical functions.