cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

All of my vendors who are 1099 eligible are not showing up on 1099 summary

all of my 1099 vendors are not showing up on my 1099 summary or detail report

Solved
Best answer 12-10-2018

Accepted Solutions
Highlighted
Established Community Backer ***

Do you mean that NO vendors show up? There can be a coupl...

Do you mean that NO vendors show up?

There can be a couple of reasons for this.  Only vendors you paid via cash or check should be reported, and only if the payments total $600 or more (actually it's up to you whether to report anything below that).  If you entered, e.g., a check for payment but used DBT or Paypal as the check number, it will be ignored.  See the article below.

http://support.quickbooks.intuit.com/support/pages/inproducthelp/core/qb2k13/contentpackage/payroll/...

Also, you should check the mapping to your accounts.  If the account you used when you entered the bill or paid the vendor is not mapped correctly no payments will show.

http://support.quickbooks.intuit.com/support/pages/inproducthelp/Core/QB2K11/ContentPackage/Payroll/...

Troubleshooting:  http://support.quickbooks.intuit.com/support/pages/inproducthelp/Core/QB2K11/ContentPackage/Payroll/...

35 Comments
Highlighted
Established Community Backer ***

Do you mean that NO vendors show up? There can be a coupl...

Do you mean that NO vendors show up?

There can be a couple of reasons for this.  Only vendors you paid via cash or check should be reported, and only if the payments total $600 or more (actually it's up to you whether to report anything below that).  If you entered, e.g., a check for payment but used DBT or Paypal as the check number, it will be ignored.  See the article below.

http://support.quickbooks.intuit.com/support/pages/inproducthelp/core/qb2k13/contentpackage/payroll/...

Also, you should check the mapping to your accounts.  If the account you used when you entered the bill or paid the vendor is not mapped correctly no payments will show.

http://support.quickbooks.intuit.com/support/pages/inproducthelp/Core/QB2K11/ContentPackage/Payroll/...

Troubleshooting:  http://support.quickbooks.intuit.com/support/pages/inproducthelp/Core/QB2K11/ContentPackage/Payroll/...

Established Community Backer ***

Re: All of my vendors who are 1099 eligible are not showing up on 1099 summary

To set up the vendor:
Click Vendors, and then Vendor Center. From the list on the left, select the desired vendor.  In the Edit Vendor window, click the Tax Settings tab. Ensure that the Vendor eligible for 1099 checkbox is checked, and then click OK.

 

To map the accounts:
Click Vendors and then Print/E-file 1099s > 1099 Wizard. Click Get Started and then Continue to the Map vendor payment accounts page. For each account you used to pay 1099 vendors, click the drop-down arrow in the 1099 box column to choose the box on Form 1099 where these payment amounts should appear.

 

Note: Each account may only be mapped to one 1099 box. If you are unsure of which account to use, please consult your accounting professional for assistance.

Not applicable

Re: All of my vendors who are 1099 eligible are not showing up on 1099 summary

My QB is showing similar signs.  I had 2016 until an hour ago - when I pull the 1099 report; it shows me data.  It's missing pieces - a vendor, with a check box in the right area along with the EIN lists on a vendor.

 

That vendor does not show up in the 1099 Vendor Report.

Moderator

Re: All of my vendors who are 1099 eligible are not showing up on 1099 summary

Hi desktopisbetter,

 

If the vendor is eligible for 1099, unable to see him/her in the 1099 Vendor Report could be a possible data damage. Let's get this fixed by running the Verify and Rebuild tool. Before that, let's make sure that you've backed up your company file. It's safer to keep the original file to avoid data loss. 

 

Then, go ahead and run the report again. 

 

Please get back to us if you need anything else. 

 

 

 

Not applicable

Re: All of my vendors who are 1099 eligible are not showing up on 1099 summary

Hey GarlynGay - appreciate you chiming in.

 

Great though - I ran through a Verify and Rebuild - on the rebuild, it gave me an error (attached).

 

Click on the link and it sends you here - 

https://quickbooks.intuit.com/community/Help-Articles/QBWin-log-Verify-Master-messages/m-p/201914

 

Based on the error, the response is - "It is an innocuous message and is not sufficient reason to run Rebuild."

 

Right - ok, well I had already run it anyway.  

 

The 1099 report is still incorrect.  

 

Where would you start next?

Moderator

Re: All of my vendors who are 1099 eligible are not showing up on 1099 summary

Hi desktopisbetter,

 

I appreciate you coming back with more details. You're on the right track and let's get this fixed. After running the Verify and Rebuild Tool, let's restore the previously backed up company file (before the issue occurred). 


Then, run the 1099 Vendor report again. If you're still not seeing the vendor, let's follow the steps for Auto Data Recovery. It helps to restore previously stored data of your company file. 

Once you're done recovering the data, go ahead and run the report again.

 

We'll keep an eye on this thread if you have any questions. 

Established Community Backer ***

Re: All of my vendors who are 1099 eligible are not showing up on 1099 summary

How did you pay that vendor name? If you paid by Credit Card, you won't report that on a 1099-Misc.

Established Community Backer ***

Re: All of my vendors who are 1099 eligible are not showing up on 1099 summary

Why would you do a rebuild and recover process before checking the actual mapping of the accounts? In my experience, each time vendors were not appearing on the 1099 reports it was due to the mapping of the accounts to the 1099 fields, or because the vendor setups were not done correctly. It does not seem logical to restore data to a previous state in which there was seemingly no difference in how the vendors were setup and how accounts were mapped and being reported on the 1099 report.

Established Community Backer ***

Re: All of my vendors who are 1099 eligible are not showing up on 1099 summary

A valid and logical point.

Established Community Backer ***

Re: Setup should always been confirmed

This is a great point: "each time vendors were not appearing on the 1099 reports it was due to the mapping of the accounts to the 1099 fields, or because the vendor setups were not done correctly."

 

Even when you stick with the same year QB, there are Updates that seem to cause the mapping Thresholds to be affected; since those can change in a tax year, anyway, the first thing to do is step through the 1099 Wizard and confirm or update that everything is ready to go. Then you run reports to see if you also forgot settings on names, other accounts, etc.

 

Rebuild is the least likely tool needed.

Not applicable

Re: Setup should always been confirmed

Thanks - I did run through the 1099 wizard.  Some of the account mappings were off, and there were some threshold issues as well that I fixed.

 

Ultimately, I think the issue was I was looking for people that I paid via credit card.

Not applicable

Re: All of my vendors who are 1099 eligible are not showing up on 1099 summary

Yes - I think this was the answer to my problem all along.  Had no idea this was a thing - now I do, thank you!

Established Community Backer ***

Re: All of my vendors who are 1099 eligible are not showing up on 1099 summary

I attached the 1099- Misc exclusion text, that applies since 2011.

ck5
Not applicable

Re: Do you mean that NO vendors show up? There can be a coupl...

I have my vendors account checked off the track 1099 but it still will not show on the report!

What do I need to do?  They have been paid via check.....  Very frustrating!

 

QuickBooks Team

Re: Do you mean that NO vendors show up? There can be a coupl...

Thank you for taking the time to post in the Community, ck5.

 

It's my priority to get you pointed in the right direction and get this 1099 vendor report straightened out right away.

 

Referencing qbteachmt's and reginamarie's great responses, before running the report, we'll need to go through the 1099 Wizard and make sure the mapping is correct. It's usually due to incorrect mapping that the vendors won't show up on the report, despite checking them off as eligible for 1099.

 

Mapping 1099 Accounts in QuickBooks Desktop:

  1. From the Vendors menu, select Print/E-file 1099s.
  2. Choose 1099 Wizard.
  3. Click Get Started.
  4. Select the appropriate vendors.
  5. Make sure the Tax ID and Address of these vendors are correct. You may also fill in any other applicable details.
  6. Click Continue.
  7. On the Map vendor payment accounts page, check Report all payments in Box 7.
    - We only support Box 7, but if necessary, you may select the other options under the Apply payments to this 1099 box drop-down menu for each account.
  8. Keep hitting Continue until you reach the last page, then Save & Close.

Now that we've mapped them correctly, let's go ahead and pull up the report. Allow me to walk you through the steps on how to do it:

  1. From the Vendors menu, select Print/E-file 1099s.
  2. Choose either 1099 Summary or 1099 Detail Report.

All of this information and more is available from our QuickBooks 1099 Wizard guide. With these resources, you'll be pulling up correct 1099 reports in QuickBooks like an expert before long.

 

Please let me know if there's anything else you need, I want to make sure you're taken care of. Thanks for reaching out, wishing you and your business all the success.

Not applicable

Re: All of my vendors who are 1099 eligible are not showing up on 1099 summary

on the 1099's when I pick on the summary sheet all the names are check and half don't show

up on the summary

Moderator

Re: All of my vendors who are 1099 eligible are not showing up on 1099 summary

Hello Don12,

 

You can report 1099's for those vendors you paid via cash or checks with a total of $600 and more. Transactions that were paid via credit card, debit card, gift card, and PayPal won't be included in 1099s. Excluding electronic payments when reporting 1099-MISC is mandated by the IRS. You can browse this article for more information: IRS Reporting Requirements for Third Party Vendor Payments on 1099-K/1099-MISC

 

If you've only processed credit card charges for these vendors, they won't generally form part of your 1099 Vendor Summary report. These amounts need to be reported by the third party or credit card company via 1099-K form.

 

I'd recommend reaching out to IRS if you need to include these vendors. They can be able to provide legal advice about this. You can also use these articles for more information: 

We'll be right here if you need anything else.

Established Community Backer ***

Re: All of my vendors who are 1099 eligible are not showing up on 1099 summary

The form 1099-K, Payment Card and Third Party Network Transactions, is an IRS information return used to report certain payment transactions processed by these Third Parties if there are gross payments that exceed $20K AND there are more than 200 such transactions.

 

This means that PayPal would file a 1099-K if this minimum reporting threshold is met. If you cross the IRS thresholds in a given calendar year, PayPal will send Form 1099-K to you and the IRS for that year early in the following year. You can access your 1099-K from your PayPal account by January 31st annually.

 

 

Not applicable

Re: All of my vendors who are 1099 eligible are not showing up on 1099 summary

I'm in the exact same boat and have been for over 2 weeks.  My 1099 reports are totally incorrect and I'm beyond disappointed with QBO putting me in this bind.   All the data has been entered correctly.  No one has been paid via Credit cards paypal etc....all 1099 boxes are checked.   Help desk could only add me to the "investigation" with no other information or resolution in place. 

 

I needed these 1099's done yesterday and QBO has really put me in a bind and do nothing but add stress to my plat vs giving me a good user experience.   Fix the 1099 reports PLEASE!!! 

 

QuickBooks Team

Re: All of my vendors who are 1099 eligible are not showing up on 1099 summary

Hello there, telkins.

 

Thanks for joining this thread. Let me provide some additional update about the 1099 vendor report shows incorrect information. 

 

The status of the investigation about this issue is still in progress, but rest assured that our engineers are currently investigating and working on an immediate fix. We'll keep you posted once this issue is resolved. Since you've been added to the list of affected users, you'll be notified of any updates on the progress on the investigation via email. 

 

We appreciate your patience as we work through this. If there's anything else I can do for you, please let me know. I'll be around to help you out. 

Not applicable

Re: All of my vendors who are 1099 eligible are not showing up on 1099 summary

I was in the same boat, so I'm posting to see if you did the same thing I did. I went into my vendors and made sure the box was checked for 1099 tracking and the FEINs were entered, verified that they weren't credit card or other third party payment methods, and still I had vendors not showing on my list. I was at my wit's end and about to just order 1099 software to get through this year after I read this thread that it was under investigation.

 

But then I went back in one last time and I figured out my problem. Every time I went into the Prepare 1099s portal (for lack of a better word), I came in on the 'Review'step. I had previously gone back to the 'Contractors' step and attempted to add the vendors from there, but still couldn't figure out why it wasn't working. Just now I went back again, to the 'Accounts' step. There I needed to select the g/l accounts that needed to be mapped to Box 7 that weren't already checked. Apparently when I did the set up last year, I didn't have payments in a couple of the g/l accounts that I have this year, and totally did not remember going through that step last year. Once I selected the expense accounts I was missing, my vendors appeared on my 1099 list!

 

So maybe that's helpful, or maybe you were smarter than me to start with and went all the way back to step one, but thought I'd throw it out there just in case it would help.

Moderator

Re: All of my vendors who are 1099 eligible are not showing up on 1099 summary

Hi, @Bookkeeper 309.

 

Welcome to the Community and thanks for joining this conversation.

 

I appreciate you sharing the steps that you've done to get this working. Information like this will definitely help other users who are having the same issue.

 

Also, thanks for being a part of our QuickBooks family. Don't hesitate to post again here in the Community or leave a comment on this thread if you have any concerns. Cheers!

Not applicable

Re: All of my vendors who are 1099 eligible are not showing up on 1099 summary

THANK YOU @Bookkeeper 309! This is the exact solution I was looking for and this was NEVER brought up by anyone on the QBO help desk team from multiple different calls/screenshares! 

 

Perfect success story for using the QBO community!!   Much quicker of a resolution vs. depending on the QBO support team to get back to me.   Thank you for helping us solve this riddle!   My 1099 reports are now correct thanks to you @Bookkeeper 309!!   Kudos!

Community Contributor *

Re: All of my vendors who are 1099 eligible are not showing up on 1099 summary

THIS worked for me, THANK YOU! Good grief QBO INTUIT. Please update your help!!! It will take a couple minutes to update and in turn, save you countless hours of your time on the back side trying to figure this out for customers. Shame that it took a frustrated customer (among others) to figure this out.

Need to get in touch?

Contact us