cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Level 2

1099 Reports show Vendors marked NOT eligible

I don't know why I haven't posted this question before, as it's been bugging me for at least 10 years.

When I run a 1099 Summary or Detail report, it seems to selectively ignore the "Only 1099 Vendors" option.  It doesn't include every vendor over the threshold, but quite a few of them.  To make it print correctly I have to customize the report to select only the names that I know belong there.

I figured it was a bug in the program, and every year I'm surprised that it hasn't been fixed.  Any ideas?

Solved
Best answer 01-10-2019

Accepted Solutions
Level 15

Re: 1099 Reports show Vendors marked NOT eligible

"I DID use the wizard, but it doesn't offer a report."

Step 5.

 

"I didn't see any option to Reset to Thresholds."

Step 3.

 

"I ticked the Vendors that are eligible (ie, ones that should get a 1099 IF they meet the threshold).  Then clicked on through the wizard until I got to the print 1099s screen."

 

Yes, every year some program update whacks the 1099 settings and the Thresholds, too. Make sure to use the link in the wizard to Set the Thresholds to the IRS defaults, and yes, reviewing the names is what you needed to do. To Easily update, go to Lists menu > Add/Edit Multiple, Vendors, Customize the columns, bring what you need into your view (1099 Y/N and SSN/EIN field) and scan and update. This is another reason it helps to use Vendor Type; you can use Type = Subcontractor, for the 1099-Reportable names, and that doesn't seem to get affected. Then, in that Add/Edit Multiple, you can show only the Vendor Type that matters for this task, and you also can use Reports menu > List Reports, Vendor Phone List. Customize it to display the info you want, retitle it Vendor Year End Info and Memorize it to have it always available.

View solution in original post

11 Comments
QuickBooks Team

Re: 1099 Reports show Vendors marked NOT eligible

Thanks for reaching us out today, kyleknapp.

 

 Let's get this conversion issue taken care of.

 

I've replicated this in my QuickBooks account to be sure, but it doesn't give me the same result as you have. If your filter for Name is set to All names or no filter at all, whether you choose Only 1099 Vendors as your 1099 option, it would still show all the vendors.

 

This issue can be resolved by running the Verifying and Rebuild tool in QuickBooks Desktop. This will help us identify the common data issues within your company file. 

Before doing this, let's secure a backup of your company file before performing the troubleshooting steps. Once done, you can now start to verify and rebuild your QuickBooks Desktop. 

To Verify:

  1. Click File at the top menu.
  2. Go to Utilities.
  3. Select Verify.

To Rebuild:

  1. Click File at the top menu.
  2. Go to Utilities.
  3. Select Rebuild.

Here's an article that'll serve as your step by step guide in resolving common data damage on your company file: Verify and Rebuild Data in QuickBooks Desktop.

 

Keep me posted on how it goes. I'll be around if you need more help while working with your 1099 reports. It's my pleasure to assist you.

Level 2

Re: 1099 Reports show Vendors marked NOT eligible

WARNING!  Just after I started this thread I got a call from QB Tech support.  Turned out to be a scam.  Very convincing.  A little scary.

I posted details in a comment in this thread

Level 2

Re: 1099 Reports show Vendors marked NOT eligible

I've done that before, but I'll try again.
I think I'll also archive old data - haven't done that in many years.

Level 15

Re: 1099 Reports show Vendors marked NOT eligible

It has nothing to do with Archiving.

 

You also likely don't need a rebuild, but that is fine to do.

 

You need to go through the Wizard and click to Reset to the IRS thresholds. The program updates whack your settings. Also, you might need to review if the vendor names that Are subject to this reporting, as still marked as such. The program updates whack your settings. Confirm the accounts that are Mapped. The program updates whack your settings.

 

The settings that control the reports are part of the Wizard, so do that first. If you find settings for Subject TO, changed, I prefer to use Lists menu > Add/Edit Multiple, to update or confirm Vendor Info in one screen.

 

And you need to pay only by check and cash, for these to be reportable on the 1099-Misc. Please see my attachment.

 

Just follow the analysis steps:

Did you mark someone as Reportable?

Were they paid in an Account that is Mapped as reportable? Examples: Box 1 = your Rent Expense needs to be linked. Box 7 = Contract Labor is linked, but not Materials expense.

Then the program evaluates if that Name was paid for those Account Reasons, to the reporting level per that box (they vary), and by the Payment Method that is reportable (check and cash).

 

If all tests are met, this is reported.

Level 2

Re: 1099 Reports show Vendors marked NOT eligible

I tried condensing data, archiving transactions prior to fiscal year end 2015.  It is my understanding that Verification and Rebuilding are automatically done in the condensing process, correct me if I'm wrong.

It ran for about an hour, then crashed.  I had to restore from backup.

Now I'm running Verify.  If that works I'll do Rebuild next, and THEN try to Condense.

Level 2

Re: 1099 Reports show Vendors marked NOT eligible

I DID use the wizard, but it doesn't offer a report.  I didn't see any option to Reset to Thresholds. I ticked the Vendors that are eligible (ie, ones that should get a 1099 IF they meet the threshold).  Then clicked on through the wizard until I got to the print 1099s screen.

Then I went to reports to produce a 1099 report, but it still shows Vendors that were not ticked in the wizard (I also opened their vendor profiles, to insure Eligible for 1099 was also not ticked there).

BTW, I just ran Verify Data - it crashed before completing.
Now I'm running Rebuild.

Level 2

Re: 1099 Reports show Vendors marked NOT eligible

Verify crashed.
Rebuild also crashed.
I should probably move this part of the thread to a different topic, eh?

Level 15

Re: 1099 Reports show Vendors marked NOT eligible

I would not introduce a New Task into this. Set  aside Condense, and get on with 1099 reporting and preparation. Don't compound the issues.

Level 15

Re: 1099 Reports show Vendors marked NOT eligible

"I DID use the wizard, but it doesn't offer a report."

Step 5.

 

"I didn't see any option to Reset to Thresholds."

Step 3.

 

"I ticked the Vendors that are eligible (ie, ones that should get a 1099 IF they meet the threshold).  Then clicked on through the wizard until I got to the print 1099s screen."

 

Yes, every year some program update whacks the 1099 settings and the Thresholds, too. Make sure to use the link in the wizard to Set the Thresholds to the IRS defaults, and yes, reviewing the names is what you needed to do. To Easily update, go to Lists menu > Add/Edit Multiple, Vendors, Customize the columns, bring what you need into your view (1099 Y/N and SSN/EIN field) and scan and update. This is another reason it helps to use Vendor Type; you can use Type = Subcontractor, for the 1099-Reportable names, and that doesn't seem to get affected. Then, in that Add/Edit Multiple, you can show only the Vendor Type that matters for this task, and you also can use Reports menu > List Reports, Vendor Phone List. Customize it to display the info you want, retitle it Vendor Year End Info and Memorize it to have it always available.

View solution in original post

Level 15

Re: 1099 Reports show Vendors marked NOT eligible

Step 3 image attached.

Level 2

Re: 1099 Reports show Vendors marked NOT eligible

Thank you!  I had not noticed the add/edit multiple feature before.  And sure enough many vendors I had unchecked in the Wizard showed up as checked here.  Once I unchecked them here, the report generated correctly.

Much easier than the workaround I've been using for years.  (Still a workaround though...)

Anyway, thank you!

Need to get in touch?

Contact us