How to Bulk Upload Data and File a form 1099-NEC
We are breaking down step by step how to easily file a 1099-NEC form with TaxBandits using the Bulk Upload feature!
Once you’ve signed in to TaxBandits, select “Start New” in the upper right corner:
Select form 1099-NEC:
Verify the tax year you are filing for:
Click “Start Now” under “Upload Excel/CSV Template”:
You can either select a business from your address book by clicking “Select Business” or you can manually enter the business information.
Once your business information has been completed, click “Save and Continue”
Validate your business address and click “Okay”
To begin your bulk upload, click “Download Template” and choose your preferred download format.
Complete the template by providing information for each recipient in a different line and filling out columns A-AF as they apply for each recipient.
Note: Column D is the recipient’s SSN or TIN (Reference Box RECIPIENTS TIN of 1099-NEC form)
Column T: Account number
Is required if you have multiple accounts for a recipient for whom you are filing more than one Form 1099 form series.
Column P: If you want to provide online access, type Yes into this column and add the recipient’s email address to column Q
Column V: (Reference Box 1 of 1099-NEC form) 1Nonemployee compensation
Enter nonemployee compensation of $600 or more. Include fees, commissions, prizes, and awards for services performed as a nonemployee, other forms of compensation for services performed for your trade or business by an individual who is not your employee, and fish purchases for cash.
Include oil and gas payments for a working interest, whether or not services are performed. Also, include expenses incurred for the use of an entertainment facility that you treat as compensation to a nonemployee. Federal executive agencies that make payments to vendors for services, including payments to corporations, must report the payments in this box.
Column W: (Reference Box 2 of 1099-NEC form) 2Payer made direct sales of $5,000 or more of consumer product
Payer made direct sales totaling $5,000 or more of consumer products to the recipient for resale
Column X: (Reference Box 4 of 1099-NEC form) 4Federal income tax withheld.
Enter backup withholding. For example, persons who have not furnished their TINs to you are subject to withholding on payments required to be reported in box 1.
Column Y-AG: (Reference Box 5-7 of 1099-NEC form) State information
These boxes are provided for your convenience only and need not be completed for the IRS. Use the state information boxes to report payments for up to two states. If you withheld state income tax on this payment, you may enter it in box 5.
In box 6, enter the abbreviated name of the state and the payer’s state identification number.
In box 7, you may enter the amount of the state payment. If a state tax department requires that you send them a paper copy of this form, use Copy 1 to provide information to the state tax department. Give Copy 2 to the recipient for use in filing the recipient’s state income tax return.
Once the template is complete, save it to your computer and drag and drop the file into the outlined field. Then click “Upload”
Once uploaded, you will receive a preview of the forms. The preview will state the total number of records received, and allow for review. Once you have reviewed your forms, click “Continue to import”
Once imported, you will get a review of how many total records, how many were successfully uploaded, and how many records had errors. If you have errors, you can click the error button to review the provided error information. You can then make the necessary changes and reupload your template.
Click “Continue Filing” once all records have been uploaded successfully.
Now you can choose to begin a new form, edit or preview the recently filed form, adjust your services, or continue filing.
After clicking “Continue” Update any errors, then click “Continue”:
Select the business(es) you are filing for, review your order details, then click to “Complete Your Order”:
When using prepaid credits, there is no need to enter or process a credit/debit card to file. Simply select “Confirm and Transmit”:
*Not sure how to purchase credits? Check out our blog here.
Want to see steps for other business types, forms, or features? Comment below and we’ll make your request a future blog!
Ready to create your free TaxBandits account and get started?