Skip to main content
K
kyleknapp
January 9, 2019
Solved

1099 Reports show Vendors marked NOT eligible

  • January 9, 2019
  • 2 replies
  • 0 views

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?

Best answer by qbteachmt

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.


"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.

2 replies

C
Charies_M
January 9, 2019

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.

K
kyleknappAuthor
January 10, 2019

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.

qbteachmt
qbteachmt
January 10, 2019

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.

K
kyleknappAuthor
January 10, 2019

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

Terms & ConditionsAccessibility statement