Excel expert David Ringstrom, CPA, shares helpful tweaks you can use with the venerable VLOOKUP function. In this invaluable presentation, he explains alternatives to VLOOKUP, including the INDEX and MATCH, SUMIF, SUMIFS, SUMPRODUCT, IFNA, and OFFSET functions ...
This webinar will give you the tools to better be able to understand line by line of Form 941 Details around 2020 updates to the form 941 and review of common errors as reported by the IRS Review of Schedule B and the importance of completing it correctly ...
This webinar will cover what the IRS looks at when auditing whether a worker is an employee or a contractor. We will cover the current “3-factor” standard the IRS uses, as well as the older “20-factor” standards. We will also discuss the relief options availab ...
This webinar will discuss reporting 2020 information as required on Forms 1099-MISC and 1099-NEC in early 2021 as well as expected updates to the forms for reporting 2021 information. The webinar will cover specific reporting requirements for various types of ...
Reliance on EBITDA (Earnings before Interest, Taxes, Depreciation, and Amortization) as a measure of cash flow is misplaced because it presumes that borrowers will pay lenders before paying their taxes, expanding their working capital assets and fixed assets t ...
The key to writing an effective audit observation is having a comprehensive structured process. The Institute of Internal Auditors recommends a process known as the 5Cs: Criteria Condition Cause Consequences (Effect) Corrective Action (Recommendation) ...
Issuers of 1099 Forms can adopt best practices and procedures that streamline the year-end process and provide assurance that 1099s are correct, at least so far as vendor names and TINs are concerned. While certain errors in reporting dollar amounts are consid ...
The turbulent ever-changing and technology-driven world of business requires changing and evolving roles for Controllers. The changing focus is more on the soft side of the business rather than accounting & reporting. It is more about people-pleasing than penc ...
This course will explain the changes relating to Form 1099-MISC for 2020, in particular the changes to how contract labor pay is reported. The IRS has created a new form, called Form 1099-NEC, where contract labor pay will be reported. We will cover these chan ...
The NACHA Operating Rules are always changing, updates have recently been made and continue to be in place due to the current COVID-19 situation! There are six ACH Operations Bulletins posted by Nacha in 2020; four of them explain the updates to the Rules due ...