1099-NEC/MISC Mapping

I'm glad to see you here in the Community Forum and help you map 1099 payments, jkope26.

You need to create another 1099-NEC and 1099-MISc expense accounts to separate payments. Then, enter a journal entry to move payments to the new accounts.

You can start by identifying the amounts paid and to which accounts. Here's how:

1. Go to Reports from the left menu.
2. Search and open the 1099 Transaction Detail Report.

Run the report and verify the amounts are showing in the correct accounts for the 1099-NEC and 1099-MISC. This will allow you to map the accounts as you go through the 1099 process.

You can also use the 1099 Contractor Balance Detail or 1099 Contractor Balance Summary reports if either of them adds more information.

Once done, add new accounts and move payments to them or to the existing ones. Please browse this link for complete instructions: Modify your chart of accounts for your 1099-MISC and 1099-NEC filing.

To help you select which form to use for your payments, here's a link as a guide: Understand payment categories for the 1099-MISC and 1099-NEC. It'll tell you which boxes are for the payment type.

Let me know if there's anything else you need about mapping 1099 accounts. Simply leave a comment below, and I'll get back to you.

thanks.  i already read the article about modifying the Chart of Accounts and i find it very confusing. 

for example, right now i have 1099 vendor whose original transaction hit the "Marketing Expense" GL account.  this is being now being mapped to 1099-MISC but really should be 1099-NEC.  If i create a new account (and call it Marketing Expense- NEC or something like that?) in our chart of accounts and move the transaction to the new expense account, how does QB then know that the transaction should go to 1099-NEC?  

why doesn't QB retain the mapping for account for the 1099-MISC and the 1099-NEC?

it doesn't save the mapping from last year.

I updated to do 3 forms per page and now I have to re-enter all of the mapping again.

Hello, Mike72. 

I appreciate you for reaching out to us here in the Community. I'm here to help you with the mapping in QuickBooks. 

Usually, QuickBooks will maintain the account for mapping. Sometimes due to the revises of the form, some data might be missing or needed to re-enter the information. 

Let's go ahead and take a look at the chart of accounts if they are properly mapped for both the 1099-MISC and 1099-NEC forms to ensure the setup is correct. Please refer to this article: Modify your chart of accounts for your 1099-MISC and 1099-NEC filing.

I'm also adding this article to learn more about the boxes on Forms 1099-NEC and 1099-MISC: Understanding payment categories for the 1099-MISC and 1099-NEC. 

If you have any other QuickBooks questions in the future, please let me know by adding a comment below. I'm more than happy to help. Keep safe always!

Hello,

Not sure if you figured this. out yet but I ran into a similar issue. QBO has mapped all my vendors that I had under a expense account to Fed tax withheld so all vendors that was paid showed as if I withheld all the money I paid them!  This caused reports not to show these vendors as qualified for a 1099 paid over $600. Sad that I had to sit here for hours to try and figure it out on my own. Easiest and fastest way to get everything mapped is to just create another exp account then go to transactions & filter it so that all the transactions that you want to map to your new exp account can be done in one shot with the batch action button. I then was able to click on the 1099 check box to complete my 1099's. Hope this helps anyone that is dealing with the same issue.