Why do my mapped accounts keep resetting back to "omit these payments from 1099"?

Thanks for reaching out to the Community forum, @hgjhgdjg. I'm here to help in mapping your 1099.

When creating 1099s, QuickBooks uses the expense accounts you mapped to report 1099 transactions. To resolve the issue you're having, let's ensure that contractors are paid from the correct expense accounts.

Here's how:

1. On your QuickBooks Desktop account, go to Reports menu at the top.
2. Select Vendors & Payables.
3. Choose 1099 Summary.
4. In the 1099 options dropdown menu, select All allowed accounts.
5. If you find the missing vendor, find the Account and make it a 1099 Account.
6. Once done, close the 1099 Detail report.
7. Select the second 1099 Options drop-down, then choose Only 1099 accounts.

For more details about the process, see this article: Fix missing contractors or wrong amounts on 1099s.

In addition, for more tips about preparing and filing 1099s in QuickBooks Desktop, I also suggest opening these links:

• Create and file 1099s with QuickBooks Desktop
• Modify your chart of accounts for your 1099-MISC and 1099-NEC filing

If you have any other questions about QuickBooks forms and taxes, please feel free to leave a comment below. I'm always here to help. Have a good day!

MirriamM,

Again, at least quarterly I go in and check my 1099 reports to see if everything looks correct, and I don’t know if it is after an upgrade or an update, but the next quarter I go in to check this report again and nothing is on it.  So, I go into the mapping of all accounts in NEC & MISC and any accounts that I had previously set as Box 1 are all switched back to Omit these payments from 1099.  It is very frustrating that I must keep mapping these accounts repeatedly for 10 different companies, this was never the case before the NEC change, all I would have to do is go in and add any new accounts that I had created throughout the year.  8 companies are on a Network system, the other 2 companies are on a stand alone computer, 2 different locations.

Good morning, @hgjhgdjg. 

Thanks for following up with us and sharing those extra details of your concern. 

It sounds like you might have some data integrity issues with your company file. Oftentimes, we see that data integrity issues can cause unexpected problems with the File. Such as:

• Fatal errors when you use QuickBooks Desktop.
• Discrepancies on reports, such as invoices or bills that post with negative values.
• Deposited payments show up in the Payments to Deposit window.
• Balance sheet reports do not show all accounts.
• Names are missing from lists.
• Transactions are missing.

With that being said, I recommend running our Rebuild and Verify Utilities. These tools are designed to scan the company file for any issues and resolve them. You can use the steps I've included below to run the tools. 

To Rebuild: 

1. Choose File, Utilities, then Rebuild Data.
2. You will receive a warning message to backup your company file, press OK. A rebuild requires a company file backup beforehand. This is just in case you have any issues with the company file. 
3. The Rebuild Data utility starts as soon as the backup is finished.
4. Click OK when you get the message "Rebuild has completed."

To Verify: 

1. Choose Window, then Close All.
2. Verify Data. Choose File, then Utilities. Select Verify Data. 

For additional details about this process, check out Verify and Rebuild Data in QuickBooks Desktop. 

Once the tools have finished, check your File to see if the issue persists. If so, you'll need to contact our Technical Support Team for further investigation. This way, one of our tech support agents can review your account in a secure environment and remote into your computer to take a deeper look. 

Please let me know if you have any questions or concerns. Take care! 

This occurs with our accounts as well!  Every year QB makes us RE-MAP each and every QB file.  It has to be a software bug, not a file bug.  We have 90+ different QB files and ALL of them have reset again to "Omit these payments from 1099".  I thought it was a user error last year and re-mapped without question.  But it happened again.  This is an issue with QuickBooks that needs to be resolved.  Rebuilding the data does not solve.

I appreciate you for joining the thread, @PBRG.

I understand how things have been challenging for you when you were prompted to remap everything over again. With this, I'd like to share some information and clarifications about this matter.

In QuickBooks Desktop (QBDT), the system will automatically unmap your accounts in nature. This is to make sure that the records are accurate since we file our 1099's every year and possible changes might be applied the following year. With this, the system will refresh and we'll be prompted to map the accounts we've already mapped to double-check everything.

You may also refer to this article for more details on how the 1099 works in QuickBooks: Get answers to your 1099 questions.

Lastly, should you need to make some changes and add a new account to your chart of accounts for your 1099's, feel free to browse through this article: Modify your chart of accounts for your 1099-MISC and 1099-NEC filing.

The Community always has your back and I'm only a post away if you need further assistance in managing your 1099's. Just hit on the Reply button and I'll get back to you. Take care and have a great day!

So I do understand that this is a programing set up with QB, is there no way to turn this feature off or allow us to review the accounts from the prior year and keep what we had? 

Remapping all these accounts after January 1 for each of our companies is a large time consuming project in an already busy time of the year for accountants. 

Is there a way to not have this happen?

Agreed.  I have had the same experience since 2021 when I went to do my 2020 1099's.  I assumed it must have something to do with the Quickbooks update for the new 1099-NEC but then the same thing happened in 2022 when I went to do the 2021 1099's and the same thing is happening again this year.  So here I am again, up against a filing deadline, having to remap all of my accounts.   Maybe we should just find something other than Quickbooks since they apparently refuse to address this issue. 

Whaaaaat!?  That's insane.  Nobody has time to remap every year!     If we think something that we've already mapped has to be changed, WE will do it.  It's not up to Quickbooks to delete everything we've already set up and make us redo it every year.   That WILL cause errors.