Was this page helpful?
Thank you!

Comments or suggestions?

Enter Email Address (optional)

Vendors are missing and amounts are lower than expected when creating or reviewing Form 1099 reports

When you create or view Form 1099 reports in QuickBooks, some vendors are missing and amounts are lower than expected.

Why this is happening

This situation occurs when a bill containing a negative line item and 1099 information was entered in a different year than the bill payment. QuickBooks is reporting this information based on the date of the bill rather than the date of the bill payment.

How to fix it

To resolve this issue, temporarily change the dates on the bills so they occur in the same year as the payment.

  1. Create a back up for the QuickBooks company file.
  2. Modify the prior year bills for each affected vendor:
    1. From the Vendors menu, select Vendor Center
    2. Right-click the vendor name and select QuickReport: [Vendor Name].
    3. Double-click a prior year bill for the vendor to open the transaction.
    4. Note the date on the bill so you can change it back after you are finished.
    5. Modify the bill so it is dated in the tax year when it was paid.
      Example: If a bill was entered 12/30/14, and was paid 01/15/15, change the date on the bill to something between 01/01/15 and 01/15/15.
    6. Click Save & Close to save the transaction.
    7. Repeat steps 2a through 2f for each vendor and bill from the prior year.
  3. Review the 1099 reports and then print the 1099 forms.
  4. Undo the date changes to the bills using one of the following methods:
    • Modify each of the bills from step 2 and change the date back to its original date.
    • Restore the backup company file you created in step 1.


KB ID# SLN40297
4/30/2017 7:43:51 AM
QYPPRDQBKSWS09 9138 Pro 2017 1b56bf