How do I print a 1099 report showing vendors paid $600 or more?
Description
Cause
Resolution

Note: If you want to print 1099s for different General Ledger prefixes, verify you selected the Retain 1099 totals per GL prefix check box in Accounts Payable settings (File, Company Settings, AP Settings). This check box isn’t retroactive. If the check box wasn’t selected when you originally set up Accounts Payable, then select the check box and manually correct your 1099 totals for each prefix or use the Recalculate 1099 Totals tool. For more information, see How do I use the Accounts Payable Recalculate 1099 Totals tool to correct 1099 amounts?

For versions 20.3 and newer:

Beginning with the 2020 year-end version (20.3), the default 1099 Preparation report has been updated to include a prompt for the minimum reporting amount. Enter 600.00 in the Minimum Reporting Amount prompt field when running the report.

For more information about the changes to the report, see Is there a report that will show the vendors and 1099 amounts in Accounts Payable?

For versions 20.2 and older:

Add a condition when you print the 1099 Preparation report in Accounts Payable. You can print the report for each vendor or print it by General Ledger prefix.

Print the 1099 Preparation report for each vendor

  1. From the Reports menu, select Miscellaneous, 1099 Preparation.
  2. Select To vendor, and then click OK.
  3. Click Conditions, and then click Add.
  4. In the Field section, select 1099 Amt Paid Last Yr, or 1099 Amt Paid This Yr as appropriate.
    • Note: You can verify your current 1099 year ending date in Accounts Payable settings (File, Company Settings, AP Settings). How you enter this condition depends on whether you’ve closed your 1099 year when you print your 1099s. For example, if you want to print 1099s for the current calendar year and your Accounts Payable 1099 year is in the current calendar year, then you would select 1099 Amt Paid This Yr. If you have already closed your 1099 year in Accounts Payable and you want to print 1099s for the previous year, then select 1099 Amt Paid Last Yr.
  5. In the Operator section, select Greater or equal to.
  6. In the Value section, enter the minimum 1099 reporting amount. For example, enter 600.
  7. Click OK twice.
  8. Click Print Preview to preview the report or click Start to print the report to a file or printer.

Print the 1099 Preparation report by General Ledger prefix

  1. From the Reports menu, select Miscellaneous, 1099 Preparation.
  2. Select By fiscal entity, and then click OK.
  3. Click Conditions, and then click Add.
  4. In the Field section, select YTD Amt Paid, or Last Yr Amt Paid as appropriate.
    • Note: You can verify your current 1099 year ending date in Accounts Payable settings (File, Company Settings, AP Settings). How you enter this condition depends on whether you’ve closed your 1099 year when you print your 1099s. For example, if you want to print 1099s for the current calendar year and your Accounts Payable 1099 year is in the current calendar year, then you would select YTD Amt Paid. If you have already closed your 1099 year in Accounts Payable and you want to print 1099s for the previous year, then select Last Yr Amt Paid.
  5. In the Operator section, select Greater or equal to.
  6. In the Value section, enter the minimum 1099 reporting amount. For example, enter 600.
  7. Click OK twice.
  8. Click Print Preview to preview the report or click Start to print the report to a file or printer.

 

[BCB:156:Chat 300 CRE US:ECB]
Steps to duplicate
Related Solutions