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...
This two-hour course covers most of the specific ethical considerations that come into play as a practitioner in the eyes of the Internal Revenue Service.
With the AICPA's heightened focus on enhancing audit quality, increased oversight of the peer review process and the auditor's overall responsibility to provide high quality services, the focus on compliance with professional standards has never been greater. Recent peer reviews have indicated that auditors are often failing to perform and/or document certain critical components of...
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....
This course is designed as a comprehensive guide to the core concepts of trust and estate income tax preparation. The course explains the common terminology and complicated income tax rules of estates and trusts, fiduciary accounting, and an introduction to or refresher on preparing Form 1041. This practical, over 300-page manual is an excellent reference...
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...
Participants have nine hours before tonight's birthday party, and as they begin the workday, they must review and prioritize their task list to maximize productivity. How much can they get done? As they set off on their day by clicking through each task on the list, they will encounter interruptions and distractions from colleagues. Players...
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...