cancel
Showing results for 
Search instead for 
Did you mean: 
Kelise Enterprises
Level 1

Payroll and 1099s

I have a client who has the bank sends one payment to several vendor contracts once a month. I split the transaction thinking that I am putting in the expenses for each vendor, however running 1099 report nothing shows up for these. I am at a loss as to how to separate the payments or re-do the transactions to set this up. They have automatic bank updates into QuickBooks how do I separate a bank transaction that went to several vendors? Or is it possible to fix it the way it is to be able to print 1099s?quickbooks vendor.jpg

Solved
Best answer January 31, 2021

Best Answers
LieraMarie_A
QuickBooks Team

Payroll and 1099s

You've come to the right place, @Kelise Enterprises.

 

To show these payments in the 1099 report, you'll have to specify the payee to the contractor's name. The best way to rectify this is to create a separate expense transaction for each contractor. Make sure that it would sum up the total payment. Then, match them to the bank transaction. I'd be glad to discuss this in detail.

 

First, undo them from the Categorized tab. I'll guide you how.

  1. Navigate to the Transactions menu and select Banking.
  2. Select the blue tile for the account you want to review.
  3. Select the Categorized tab.
  4. Locate the payment that we need to undo.
  5. Select Undo from the Action column. 
    The screenshot below shows you the last three steps.
    Capture.JPG

 

Once you remove a transaction from the Categorized tab, it will return to the For Review list.

 

After that, create the expense transaction for each vendor. 

  1. Click +New.
  2. Select Expense.
  3. Fill in the necessary info.
  4. Select Save and close.
  5. Repeat steps 1 through 4 for the other vendors.

 

Lastly, match these expenses from your bank feeds.

  1. Navigate to the Transactions menu and select Banking.
  2. Locate the payments that you've undone earlier.
  3. Click the transaction, then select Find Match. It will open the Match transactions window.
  4. Select the expenses that match up the payment.
  5. Click Save.

 

Check out our guide on categorizing and matching online bank transactions in QuickBooks Online for more info.

 

Once done, these transactions will show up in the 1099 report. Follow these steps to prepare and print 1099s:

  1. From QuickBooks Online, navigate to the Expenses tab and the Vendors section.
  2. Click Prepare 1099's and walk through the module until you're on Step 5 - File.
  3. Select No, I'll print and mail.
    undefined
  4. Walk through the on-screen instructions to align and print the forms.

 

Doing this will allow you to print your 1099 forms right away. Check out our guide on printing 1099s in QuickBooks Online for more information.

 

You can also read through the common questions and answers about 1099s.

 

Please let me know how it goes by leaving a comment below. I'm only a post away should you have any follow-up questions or concerns. Have a wonderful day!

View solution in original post

3 Comments 3
LieraMarie_A
QuickBooks Team

Payroll and 1099s

You've come to the right place, @Kelise Enterprises.

 

To show these payments in the 1099 report, you'll have to specify the payee to the contractor's name. The best way to rectify this is to create a separate expense transaction for each contractor. Make sure that it would sum up the total payment. Then, match them to the bank transaction. I'd be glad to discuss this in detail.

 

First, undo them from the Categorized tab. I'll guide you how.

  1. Navigate to the Transactions menu and select Banking.
  2. Select the blue tile for the account you want to review.
  3. Select the Categorized tab.
  4. Locate the payment that we need to undo.
  5. Select Undo from the Action column. 
    The screenshot below shows you the last three steps.
    Capture.JPG

 

Once you remove a transaction from the Categorized tab, it will return to the For Review list.

 

After that, create the expense transaction for each vendor. 

  1. Click +New.
  2. Select Expense.
  3. Fill in the necessary info.
  4. Select Save and close.
  5. Repeat steps 1 through 4 for the other vendors.

 

Lastly, match these expenses from your bank feeds.

  1. Navigate to the Transactions menu and select Banking.
  2. Locate the payments that you've undone earlier.
  3. Click the transaction, then select Find Match. It will open the Match transactions window.
  4. Select the expenses that match up the payment.
  5. Click Save.

 

Check out our guide on categorizing and matching online bank transactions in QuickBooks Online for more info.

 

Once done, these transactions will show up in the 1099 report. Follow these steps to prepare and print 1099s:

  1. From QuickBooks Online, navigate to the Expenses tab and the Vendors section.
  2. Click Prepare 1099's and walk through the module until you're on Step 5 - File.
  3. Select No, I'll print and mail.
    undefined
  4. Walk through the on-screen instructions to align and print the forms.

 

Doing this will allow you to print your 1099 forms right away. Check out our guide on printing 1099s in QuickBooks Online for more information.

 

You can also read through the common questions and answers about 1099s.

 

Please let me know how it goes by leaving a comment below. I'm only a post away should you have any follow-up questions or concerns. Have a wonderful day!

Kelise Enterprises
Level 1

Payroll and 1099s

Thanks for the help. This was definitely helpful. Another question: What if part of the transaction was a Owner's Draw? How do I separate that with the vendors when matching?

Adrian_A
Moderator

Payroll and 1099s

Thanks for getting back to me, Kelise Enterprises.

 

 

If it's an owner's draw, you'll not enter it on a 1099 instead, it will be recorded on a W-2 forms.

 

As for matching it with your vendor's transactions, you can split them to the correct expense accounts. I've added these articles as your guide:

 

 

I'm just a post-away if ever you need help. Keep safe!

Need to get in touch?

Contact us