cancel
Showing results for 
Search instead for 
Did you mean: 
La-LCCPA
Level 1

1099 excel importing

I have a client that only pays us to enter and print 1099nec's.

They send us an excel file and we enter each vendor's information into IOP.Intuit.com by hand. Is there a way to import the file into QB or IOP.Intuit?

 

1 Comment 1
Rose-A
Moderator

1099 excel importing

Hey there, La-LCCPA.

 

The option to import 1099 information is unavailable in QuickBooks or Intuit Online Payroll. I'd suggest entering the details manually.

 

Here's how:
 

  1. Go to Taxes & Forms, then select 1099. From January 1 to April 30 you can also use your To-Do item to return to the 1099 service.
  2. Select Enter Information. Note: if you paid contractors in Intuit Online Payroll in the previous year, and they meet the threshold, they’ll have a checkmark for 1099 e-filing. Select Continue.
  3. 1099-NEC and 1099-MISC forms are listed. Select Edit to make updates including contractor information and values for the supported boxes or Add to add a new contractor or form. Select Continue.
  4. Select Print For Contractors or Print for your records for your contractors or for your records. Note: don’t forget to mail the forms, we don't mail 1099s to contractors for you.
  5. Place a checkmark next to contractors paid in prior years you also want to create 1099 for. Select Continue.
  6. Enter a credit card for billing or make sure the current credit card information for Intuit Online Payroll is correct. Select Approve.
  7. If you're ready to e-file, select Submit final forms.

 

To get more details about this, here are some articles to guide you with setting up vendor's information as well as steps in filing them:
 

Create and file 1099s using Intuit Online Payroll or no payroll.

Set up contractors and track them for 1099s in QuickBooks.

 

Let me know if there's anything else you need. I'd be more than willing to lend you a hand. Have a good one!

Need to get in touch?

Contact us