Solved

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

80 replies
0 views

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

QuickBooks Desktop

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. (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. 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. Check out the video below for more detailed info on troubleshooting these issues.

You can also check out the following articles for more help.

https://quickbooks.intuit.com/learn-support/en-us/1099-misc-payroll-forms/vendor-missing-from-1099-summary-report-or-1099-efile-service/00/370477

Check out Prepare and file 1099s wit QuickBooks Desktop.

NOT MY USER IDAnswer

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. (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. 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. Check out the video below for more detailed info on troubleshooting these issues.

You can also check out the following articles for more help.

https://quickbooks.intuit.com/learn-support/en-us/1099-misc-payroll-forms/vendor-missing-from-1099-summary-report-or-1099-efile-service/00/370477

Check out Prepare and file 1099s wit QuickBooks Desktop.

C

ck5

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!

A

AldrinS

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:

From the Vendors menu, select Print/E-file 1099s.
Choose 1099 Wizard.
Click Get Started.
Select the appropriate vendors.
Make sure the Tax ID and Address of these vendors are correct. You may also fill in any other applicable details.
Click Continue.
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.
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:

From the Vendors menu, select Print/E-file 1099s.
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.

Regina_Lend_A_Hand_Accounting

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.

T

tami5

Mine are not showing and even the ones I filed for 2018 are not showing up. I went to help and check everything. My preferences are set, the vendors are checked for a 1099 and they are over the threshold.

Anna S

Hello, @tami5 and thank you for sharing the steps you have tried so far.

I'm here to offer some insight on the 1099 Vendors not showing up on your summary report.

I recommend merging your Vendors. This allows you to organize and consolidate transactions. It also removes any duplicate accounts you may have. Just make sure to back up your company files before you start.

Merge Vendors for QuickBooks Desktop 2019:

1. Open the Merge Vendors window.

Accountant Edition:
- From the Accountant menu, choose Client Data Review, then select Merge Vendors.
Enterprise:
- From the Company menu, pick Accounting tools, then go to Merge Vendors.

2. In the Merge Vendors window, choose the vendors to be merged and press Next.

3. Select a Master Vendor and pick Merge.

4. Press Yes on the Confirmation prompt and click OK on the Merge Complete window.

If you have Desktop 2018 or later you can use this article to merge your data.

For more assistance with this issue, I suggest reaching out to our Support Team with your Vendors showing up.

Thank you for being part of the QuickBooks family. Best wishes!

D

desktopisbetter

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.

A

Anonymous

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.

D

desktopisbetter

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?

D

Don12

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

J

JamesDuanT

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.

Regina_Lend_A_Hand_Accounting

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.

J

JanyRoseB

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.

M

Mdiem

Your response was written in Jan 2019 and it is now Jan 2020 and I am having the same problem in QBO 1099 App. I have done this for years, so I know what criteria need to be right, and they are right, and the program is missing 1099s in two client companies. Did the engineers ever fix this?

M

mike1202

I have one vendor and there are multiple payments to them. However on 1099 summary and detail report only one payment amount appears.

KlentB

I can share some information about why some of the payments are not showing up on the 1099 report, shcoates.

Internal Revenue Service doesn't require electronic payments to be reported on the Form 1099-MISC. Payments made by credit, debit, gift card, or payment networks like PayPal are excluded. Instead, the payment companies report those transactions to the IRS for you. In addition, QuickBooks Online automatically excludes them for you that's why it's not showing up on the report.

You can read this article learn mpre to know more about how 1099s works in QuickBooks: Common questions about 1099s.

I also encourage visiting link that will guide you in preparing and filing 1099s with QuickBooks Desktop.

Please leave a comment below if there's anything I can help you with. Thanks for reaching out to us, wishing you and your business all the success.

X

xdalex88

When I ask for summary it is giving me 2019 information...

Need 2020 1099 information...

Do not like to update because I always have a problem

Just did an update today

MorganB

Hi there, xdalex88.

Thanks for reaching out here in the Community. I'd be glad to provide some info about preparing 1099s for your employees in your Desktop account.

When viewing the 1099 Summary Report, I recommend first double checking the data range selected. Here's how:

1. Click the Reports tab, then hover over Vendors & Payables.

2. Select the 1099 Summary report.

3. Choose the drop-down menu for Dates, and select Custom or Last Calendar Year.

4. Enter the specific data range if you selected Custom.

5. Click Refresh in the top right corner when you're finished with the dates.

The following articles provides even more info about the 1099 form in QuickBooks Desktop:

That will do it. Please don't hesitate to reach back out if you have any other questions. Take care!

D

digieverafter

There are several answers here that properly walk you through the correct checks. This January 2021 answer is for those who already know how to and have done and redone the checks. I use all QB versions; this year I had this problem with QB Mac. When doing 1099's for one of my clients. the vendor not showing up was...ME! Here's the quirk and the fix: I write my business name, organized ever after, with all lower case letters (because, that's the end of the story, in case you wanted to know). Turns out, QB didn't like the lower case lead "o" in the VENDOR NAME box-- it was okay in the Company Name box. Until I changed it, QB listed my company at the bottom of the 1099 "Review Vendors" page, and did not include it on the "Confirm Entries" page. Once I capitalized the "o," the 1099 populated fine. Hope that helps someone.

Sign up

Login with SSO

Login to the community

Login with SSO