This final course in the series covers advanced features in Power Query (Excel version), including functions and parameters and basics of data modeling in Power BI and Power Pivot. Multiple hands-on examples help to reinforce these concepts.Power Query is an "ETL" tool that extracts, transforms, and loads data. This tool has a user-friendly interface that...
Due to IRS issue focused examinations, Accounting and Finance Professionals need to understand what types of returns are selected for examination and ways to help clients survive an IRS audit with little or no change. As a result of issue focused examinations, Accounting and Finance Professionals must understand what the high audit risk area issues...
While the effective date of Topic 606 has passed for companies, there will always be a need for a comprehensive review of the accounting related to revenue recognition, including recently issued changes to this guidance. Whether you are looking to improve your revenue recognition processes, benchmark your financial statement disclosures against your peer group, or...
The objective of this course is to train new, rusty, or returning-to-practice staff with a hands-on, pencil-pushing gold standard for preparing Form 1065. Common to advanced issues of partnerships are explored in the current course that can double as a quick and practical reference guide for tax treatment and tax preparation guidelines. Within each chapter,...
Clients think that estate planning only applies to the very rich. In truth, there are many issues of critical concern for which the middle-income client needs to plan. This course is a must-attend for all Accounting and Financial Professionals who work with middle-income clients and are looking for ways to provide additional quality services. Continually...
With the largest overhaul of the federal income tax code in 30 years and the repeal of the physical presence nexus standards for sales tax in the Wayfair case, the states are working fast and furious to overhaul their tax laws. As some states scramble to fund their budgets, they continue to look for additional...
The "permanent" changes from the TCJA may stand like a lion in the pathway of change, but Washington has its own definition of permanent. Inflation adjustments and technical corrections are included within this deep analysis of the complex maze of rules dealing with depreciation, amortization, and sale of property. This course contains many examples and...
In addition to being experts on the nuts and bolts of accounting and auditing, experienced auditors must also be aware of the emerging trends in our industry, as well as those complex topics with which we don't need to deal on an everyday basis. In this session, we'll cover some of those emerging and challenging...
The recent pandemic showed us one very important thing: the nimble business was in a far better position to change quickly and survive. Some organizations are nimbler, but why? The reason is that they know that change will happen quickly, and they specifically plan for that change. This program will take a look at planning...
Most Accounting and Financial Professionals have been preparing individual income tax returns for years, and while many of the returns are easy, there are always a number of issues that come up in busy season of which experienced practitioners wish they had more knowledge. This course is designed to explore the tough tax issues for...
A clear and concise set of proper financial statement disclosures can make or break an entity's financial statements. Such disclosures are no longer simply additional information provided by a business; they can be complex in nature and difficult to both prepare and understand, especially for small and medium-sized businesses. Oftentimes financial statement users will first...
Many partnerships and S corporations are now required to complete the voluminous Schedules K-2 and K-3 to report foreign-related tax information. Updated for the 2023 tax year, this course is an essential guide for tax preparers on how to tackle the preparation of these forms. Understanding and preparing these forms requires a basic knowledge of...