Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy nowThanks for joining us here, srobookkeeper.
The reason why only one vendor appears when you choose Prep My Own, while all vendors show up under Autofill, is due to how accounts are mapped to their respective 1099 boxes. Proper account mapping ensures that transactions are categorized accurately for 1099 reporting.
Here's how to fix this:
I'm also adding this article about how to Troubleshoot missing contractors or wrong amounts on 1099s for future reference.
If you have any additional questions, please don’t hesitate to reach out. We're always here to assist you.
Thank you for your reply. I have been using QuickBooks online to prep 1099 for 8 years and have never had this issue. Prior to reaching out I had checked that all the appropriate vendors had the Track for 1099 box ticked. I checked the mapping and ensured Contracted Services was the account selected for Box 1 on the 1099-NEC. These vendors have a sub-account to track the specific project they are working on (all are the same sub-account). When selecting the accounts on the Select Account used to pay... page, I selected Contracted Services. This returns no vendors that meet the criteria. The appropriate sub-account (VNY) is not listed directly under Contracted Services. The name of the sub-category is listed near the end of the account list (due to alpha order) but as there are numerous sub-accounts with the same name due to tracking of expenses for that specific project - the Contracted Services sub-account is not evident. I've tried selecting all of the same named sub-accounts, but this still only returns one recipient and for an incorrect amount. The only account selected by QB if using the Autofill option is Contracted Services:VNY. Why does it work there and not for Prep Your Own? Thanks.
I appreciate you for providing detailed information and taking the necessary steps to show the 9 vendors while preparing your 1099 form, srobookkeeper.
Just to further check, were any of these payments made by credit card, PayPal, or similar methods? If so, you can consider reviewing the 1099 Transaction detail report to ensure that the contractor payments meet the cash threshold and to identify which payments are excluded.
If everything checks out, consider adding an identifier to the names of the VNC sub-accounts in your Chart of Accounts. This will make it easier to select the correct account when mapping for your 1099 forms.
Here's how:
Once done, proceed with the 1099 preparation wizard as usual.
If the issue persists, and Autofill displays the correct totals but the manual Prep your own option still does not work, I highly recommend reaching out to our QuickBooks Online Support. They can help you investigate the issue further and provide clarification to ensure everything is resolved properly.
If you have any further concerns, please feel free to add a reply. We're here to help.
Hi, @srobookkeeper
Just checking in to see if the solution we shared worked for you.
Please let us know if everything is now working smoothly or if you're still experiencing any challenges.
We'll be glad to assist further if needed.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here