cancel
Showing results for 
Search instead for 
Did you mean: 
jkope26
Level 2

1099-NEC/MISC Mapping

Hello,

I am starting to look at the 1099 feature in QBO, this will be my first year doing the forms in QB.  I am a little confused by how QB is mapping transactions to 1099-NEC or 1099-MISC.

It appears that any 1099 vendor that was coded to contractor expense is correctly getting mapped to a 1099-NEC.  But, with the exception of rent (which I know belongs on the MISC), there are transactions incorrectly being mapped to 1099-MISC.  These are transactions that hit other expense accounts such as production, marketing etc.

Is there a way I can change how these transactions are mapped for 1099 purposes?  I was looking in the COA setup but didn’t see how I could do this.

Any help would be appreciated, thank you!

Solved
Best answer January 12, 2022

Best Answers
ChristieAnn
QuickBooks Team

1099-NEC/MISC Mapping

Hi there, jkope26.

 

Thank you for coming back to the thread to add some clarification about modifying accounts in 1099. With this, I'll ensure to share further details on how 1099-NEC works.

 

When preparing your 1099s you have the option to choose the box for the types of payments you made and the expense accounts you use for these payments. That said, QuickBooks will depend on how you set up the details on 1099. I suggest making sure that the accounts and boxes are properly mapped for both the 1099-MISC and 1099-NEC forms so QuickBooks will automatically determine the entries that should go to the 1099-NEC.

 

To ensure that you select the correct accounts and the records are in shipshape, I suggest consulting an accountant before properly mapping the tax form. They can provide suggestions on how to properly handle the transactions and the specific account to be used. 

 

You can open this article to view details on which payments are not included in the 1099 forms: Understand which payments are excluded from a 1099-NEC and 1099-MISC.

 

I'm also adding this article so you'll be able to see other related information about 1099 and be updated with this form: Get answers to your 1099 questions.

 

You can always post here in QuickBooks Community if you have other concerns or inquiries about 1099-NEC. I'm always here to make sure that everything is taken care of.

View solution in original post

6 Comments 6
MaryLandT
Moderator

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.

jkope26
Level 2

1099-NEC/MISC Mapping

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?  

ChristieAnn
QuickBooks Team

1099-NEC/MISC Mapping

Hi there, jkope26.

 

Thank you for coming back to the thread to add some clarification about modifying accounts in 1099. With this, I'll ensure to share further details on how 1099-NEC works.

 

When preparing your 1099s you have the option to choose the box for the types of payments you made and the expense accounts you use for these payments. That said, QuickBooks will depend on how you set up the details on 1099. I suggest making sure that the accounts and boxes are properly mapped for both the 1099-MISC and 1099-NEC forms so QuickBooks will automatically determine the entries that should go to the 1099-NEC.

 

To ensure that you select the correct accounts and the records are in shipshape, I suggest consulting an accountant before properly mapping the tax form. They can provide suggestions on how to properly handle the transactions and the specific account to be used. 

 

You can open this article to view details on which payments are not included in the 1099 forms: Understand which payments are excluded from a 1099-NEC and 1099-MISC.

 

I'm also adding this article so you'll be able to see other related information about 1099 and be updated with this form: Get answers to your 1099 questions.

 

You can always post here in QuickBooks Community if you have other concerns or inquiries about 1099-NEC. I'm always here to make sure that everything is taken care of.

Mike72
Level 1

1099-NEC/MISC Mapping

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.

 

AileneA
QuickBooks Team

1099-NEC/MISC Mapping

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-MISCUnderstanding 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!

Pena
Level 1

1099-NEC/MISC Mapping

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. 

Need to get in touch?

Contact us