1099 NEC Electronic File Total does not Match the Report Totals
  • 18 Jan 2023
  • Contributors
  • Dark
    Light
  • PDF

1099 NEC Electronic File Total does not Match the Report Totals

  • Dark
    Light
  • PDF

Article summary

When creating the Electronic File from the "!099 Vendor Report wi/ Fund Information" or the "1099 Vendor Report and Forms" using the 1099 NEC 2020 form, the total amount does not match the report's total amount.

Answer:

This is addressed in FIMS 14.73

Steps To Duplicate

1) Go to FIMS> Reports> Accounts Payable
2) Choose 1099 Vendor Report with Fund information or 1099 Vendor Report and Forms
3) In the report parameters select 1099 NEC check form (user defined or system defined)
4) Under selection set for box 7 only for NEC amounts> run Report
5) Report runs and has a total amount
6.) Click Create Electronic File>
7) Open electronic file with notepad or excel> notice the total does not match the total amount from the report and the total in the data file seems to be picking up the amount of the last grant rather than the total for all grants in the file.


Was this article helpful?