Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Simplify payday and set payroll to run automatically on QuickBooks. Explore QuickBooks Payroll
srobookkeeper
Level 1

When I select Prep My Own (1099s) via Quickbooks, only one vendor is displayed. When I select Try Autofilled Forms the correct 9 vendors are displayed.

 
4 Comments 4
Joemar_B
QuickBooks Team

When I select Prep My Own (1099s) via Quickbooks, only one vendor is displayed. When I select Try Autofilled Forms the correct 9 vendors are displayed.

Thanks 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: 

 

  1. Go to Expenses and bills, then select 1099's.
  2. Select Try Autofilled form, take note and use it as your reference for mapping accounts.
  3. Then go back and choose Prep My Own.
  4. Click on Confirm info and start filling, then hit Select accounts.          
  5. Scroll down and choose the accounts that was showing in Autofilled form. Make sure they are the same.
  6. Finally, click on Save

 

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.

srobookkeeper
Level 1

When I select Prep My Own (1099s) via Quickbooks, only one vendor is displayed. When I select Try Autofilled Forms the correct 9 vendors are displayed.

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.

KiazzymaeC
QuickBooks Team

When I select Prep My Own (1099s) via Quickbooks, only one vendor is displayed. When I select Try Autofilled Forms the correct 9 vendors are displayed.

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:

 

  1. Click on the Gear icon, then Chart of Accounts.
  2. Find the VNC sub-account, and click Edit from the drop-down menu.
  3. Add a unique label in the name field, and select Save.

 

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.

MichaelaS
QuickBooks Team

When I select Prep My Own (1099s) via Quickbooks, only one vendor is displayed. When I select Try Autofilled Forms the correct 9 vendors are displayed.

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.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us