Using a variety of hands-on exercises, this course enables users to learn how to add columns using Power Query (Excel version). Power Query is an "ETL" tool that extracts, transforms, and loads data. This tool has a user-friendly interface that enables the Excel user to connect to data sets they previously did not have access...
Participants must use their expertise to assist a new client who just received Letter 6173 from the IRS. The client didn't share any crypto-related transactions or events with the tax accountant who filed the original return. It's up to the participants to meet with the client and uncover details of the activities so an accurate,...
As a byproduct of the audit, the auditor has a responsibility to communicate certain information to management and those charged with governance, primarily related to risk and internal control deficiencies. In some cases the auditor may be required to report outside the entity, for example, when fraud is identified. Some of these communications to management...
The objective of this course is to train new staff accountants, data processing employees, paraprofessionals, and bookkeepers to prepare a moderately complex federal individual income tax return (Form 1040). Over the years, thousands of new staff have received practical, hands-on experience to become familiar with tax forms. This course covers the latest tax law changes,...
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...
Participants play the role of an auditor collecting information, making inquiries, and documenting findings around the audit of Home D‚cor and More. They develop professional skepticism skills as they analyze data obtained from an interview with Courtney the Controller, comparing, confirming, and corroborating it against information provided by the CFO. Some things aren't matching up...
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...
Tax planning for the end of 2023 and for 2024 is largely built upon legislation contained within the Inflation Reduction Act and the SECURE Act 2.0, both enacted in 2022, that offers new planning options for businesses. There are, however, other business tax changes that come from other pieces of legislation, IRS pronouncements of various...
This course will discuss what to do if you suspect fraud within your organization. The HealthSouth fraud case is presented as a means of understanding how the fraud was committed, and ways in which it could have been prevented. This is the second of five 2-hour courses in Surgent's Fraud Certificate Program. This program includes...
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 goes beyond the basics and addresses important practical issues that an experienced practitioner must know. Even if you have attended other S corporation courses, you will learn something new in this course.
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...