Skip to main content
December 10, 2020
Question

Vendor not showing up on 1099 report even though they are over threshold

  • December 10, 2020
  • 3 replies
  • 0 views
Original commenter did not share additional details

3 replies

IamjuViel
December 10, 2020

Let me help you sort this out, @theproblemsolver.

 

There are certain requirements so that vendor payments will be included in your 1099 taxes. Payments made electronically or by credit card, debit card, or gift card are excluded in this report. 

 

However, for reporting purposes, let me guide you in customizing your 1099 transaction details report. Here's how to include those transactions in your report:

  1. Open the 1099 Transaction Detail report.
  2. Choose the Customize Report button.
  3. Expand the Filter section.
  4. Put a checkmark on Payment Type.
  5. From the drop-down, select All
  6. Click Run Report.

You can read through these articles to learn more about tracking your 1099 transactions:

Keep me posted if you have other questions about managing your 1099 reports. I'm always here to help.

IamjuViel
December 13, 2020

Greetings, @theproblemsolver.

 

I'm back to check if you were able to include all your vendors in generating the 1099 report using the steps I shared. If you need more clarification on this, just leave a comment below. I'll be sure to get back to you.

 

Have a great day ahead!

February 7, 2023

We are having the same issue.  All vendors with 1099's are entered and checked for tracking and over threshold, but nothing is coming up on our 1099 Transaction Detail reports. We are using the Desktop version of QB.  We DID upgrade our QB last year.  Could that have caused this?

MaryLandT
February 7, 2023

I'm happy to help you figure this out, ABC_BRITT.

 

Your 1099 shouldn't be affected as long as the tracking is correct. Let's find those missing 1099 payments and put them back in the 1099 Transaction report.

The first thing you need to do is check if payments to these vendors meet the threshold. Only those contractors you paid above the annual $600 cash threshold get a 1099. 

 

You can see which contractors didn’t meet the threshold with these steps and the 1099 reports. 

 

  1. Go to Reports, then select Vendors & Payables.
  2. Select 1099 Summary.
  3. In the 1099 Options dropdown menu, select Ignore thresholds.
  4. If you see the vendor, they have not met the threshold.

 

If this is a 1099 Vendor using 1099 Accounts, you need to enter more transactions or change the thresholds. Please follow the steps I've outlined below.

 

  1. Go to Edit, then click Preferences.
  2. On the Preferences window, select Tax:1099 from the left pane, then go to the Company Preferences tab.
  3. Hit the you can do it here link to map your accounts to boxes on form 1099-MISC.
  4. QuickBooks 1099 wizard page will come up.
  5. From the Map Accounts step, select Show IRS 1099-MISC filing thresholds link.
  6. In the 1099-MISC IRS Thresholds window, double-click the Thresholds column for the appropriate 1099 Box.
  7. The screen will display: Your settings do not match the current IRS thresholds message in red. Hit Reset to IRS Thresholds if you want to follow the IRS-mandated threshold and add more transactions instead.
  8. Click Save & Close.

 

If contractors are still missing or amounts are wrong when preparing 1099s, you can use this article: Fix missing contractors or wrong amounts on 1099s.

 

If you're ready to file your 1099s, check out these articles as guidance for submitting tax returns.

 

 

You can always post here in QuickBooks Community if you have other concerns or inquiries about 1099s. I'm always here to make sure that everything is taken care of. May you have a wonderful day ahead!

February 7, 2023

Thank you for getting back to me.  I have attached a couple screen shots to illustrate the issue better.

January 29, 2025

I am having the exact same problem. A vendor is showing up (correctly, with the correct over-threshhold amount) when I "Prepare 1099", but, that same vendor and the related transaction is not in the "1099 Transaction Detail Report". I've adjusted settings for the report. Difficult to reconcile the 1099 report to the actual 1099's prepared. Kind of assumed the numbers would be the same, or differences would be easily identifiable. 

Any idea why QBO would prepare a 1099 for a vendor but not have any transactions in the 1099 Transaction Detail Report?

I've read all of the comments, so it's not necessary to re-post the standard instructions.

January 29, 2025

When creating 1099s, QuickBooks uses the expense accounts you mapped to report 1099 transactions, Steve. I can help you get the missing vendor and transactions in your 1099 Transaction Detail Report.

 

To begin, please ensure the expense account used to pay your vendors is selected as a 1099 account when you prepare 1099s. Incorrect account mapping could result in missing vendor and vendor transactions in your 1099 report. Here's how you can go about choosing accounts for 1099 tracking and reports:

 

  1. Select the Expenses tab, then the Vendors section.
  2. Click on the Prepare 1099's option.
  3. In Step 2 - Accounts, check the option for whichever type of 1099 you have.
  4. In the drop-down menu, check off each Ledger Account that holds transactions for your 1099 vendors.

 

Once you have worked through adding that to the vendor, you can cancel or exit the 1099 wizard, and your report will populate. You can then reopen the 1099 Transaction Detail Report.

 

Finally, you can customize and save the report modifications to save time on future management.

 

With these adjustments, you can fully utilize the report and review all your 1099 vendor transactions. Should you require additional support, please let us know in the comments. Our team is readily available to assist you whenever necessary.

January 29, 2025

Thank you, but that did not work. When I select Prepare 1099s and follow your steps, I find that the expense account is already selected for 1099 filing. The 1099 filing includes the comp paid to this vendor for this account. When I re-run the "1099 Transaction Detail Report", the comp paid to this vendor is missing.

Now, I know that QBO has issues with its servers from time to time, and I have discovered that if i delete a setting, then re-institute the setting, that the report fixes. Do you think that is the issue here (simply delete the account from the 1099 filing, exit the 1099 filing process, go back into the 1099 filing process and re-add the account and then re-run the 1099 Transaction Detail Report)?

If i don't hear back from you with a better solution, I'm going to try that.