A merge query combines two queries that have a common column or columns. This course discusses best practices for creating merge 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 loads data. This tool has...
When real property is sold for a gain, we always try to find ways to defer recognizing income so that it won't be necessary to send a check to Uncle Sam. There is a provision within the Internal Revenue Code that allows the taxpayer to defer recognition of immediate taxable gain in the year of...
Governments enter into leases for many types of assets. This course is designed to help you understand the core components of governmental lease accounting under GASB No. 87, Leases. You will learn the important definitions involved, the key decision points involved in applying the standard, and how to think through those decision points.
With the effective date of ASC 842, Leases, imminent, it's time to get tactical with your implementation plan. In this webinar, Ane Ohm, the co-founder and CEO of leading lease accounting software provider LeaseCrunch, joins Surgent to discuss lessons learned and best practices from those who have already completed ASC 842 adoption to help assure...
Getting ready for busy season involves not only knowing what's new for the current year, but also understanding how the changing limits, phaseouts and other rules apply to current-year returns. With major legislation enacted over the past few years, the present course will constitute a one-stop "shop" that brings you the essential individual tax information....
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...
Owners of S corporations and partnerships are subject to various limitations on pass-through losses, each with unique rules, applications, and complexities. As many businesses are reporting losses as a result of COVID-19, it is essential for tax practitioners to understand the mechanical aspects of each limitation and how they coordinate to provide effective planning for...
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...
This course is designed to help you proceed and succeed in applying the requirements found in ASU No. 2018-08, Clarifying the Scope and the Accounting Guidance for Contributions Received and Contributions Made. Learn the thought process used in evaluating and recording contribution transactions.
This course focuses on the main elements of financial education and will help accounting and finance professionals guide their clients, and their clients' children, through a personalized teaching roadmap. Clients with wealth face questions about how to teach their children about money to raise financially capable children. Often, their first contact is to their accounting...
This is indeed another year of significant change in the world of government and nonprofit accounting and auditing. Time is valuable, and it's hard to stay current in today's rapidly changing environment. Let us save you time and effort with this informative update course. The course materials utilize a highly illustrative and innovative format. Over...
The role of financial professionals has and continues to change in organizations. The stereotype of collecting and reporting data has been replaced by a broader vision, which focuses on improving an organization's results today and preparing it for the future. This brief program offers specific actions that can be implemented by financial personnel to expand...