How to import 1099-MISC/1099-NEC recipient information from QuickBooks?
3.0k views |
Last modified 1/28/2021 1:21:58 PM EST |
Added by TaxBandits Team
TaxBandits allows you to import the vendor details and their payment history from your QuickBooks account for filing Form 1099-MISC/1099-NEC.
Use your QuickBooks credentials to choose the payer/company and map categories for the payments recorded in QuickBooks against the Form 1099-MISC/1099-NEC fields in TaxBandits. By doing so, the payment details will be imported into TaxBandits, and you can proceed to file the returns for your vendors.
Before you begin, ensure that the Track Payments for 1099 option is enabled in QuickBooks. Only then will you be able to pull in the data into TaxBandits.
Log in to TaxBandits and choose Form 1099
- Log in to TaxBandits, and go to Home >> Forms tab.
- Under 1099 Forms - Federal & State Filing, choose 1099-MISC or 1099-NEC.
- Choose Tax Year and click Next.
Connect QuickBooks account and import vendor details
- Click Start Now under QuickBooks online. Click Connect to navigate to the QuickBooks sign-in page.
- Enter your QuickBooks login credentials and click Sign In.
- Once connected to QuickBooks, search for the payer/company to choose the payer and click Next.
- Click Connect to allow TaxBandits to access the vendor data in QuickBooks. On a successful connection, the payer and vendor information will be imported into TaxBandits.
- Verify the payer details and edit if needed. Click Save and Continue.
Categorize Payments to Vendor
- Select or check the applicable boxes against the categories of QuickBooks Account for the payments made to your vendors. This will map the payments in TaxBandits for each vendor.
- After selecting, click on Save and Continue. The payments from QuickBooks will be imported into TaxBandits.
Vendor Details - Select TIN type and enter TIN
- Verify the vendor information imported from your QuickBooks Account.
- Select the Type of TIN and enter the Tax Identification Number (TIN) for each vendor.
- If TIN is not available, select “I don’t know TIN” under the type of TIN and click Save and Continue.
- Review the amounts mapped for each vendor on the next page and continue with the return filing.
Note: If any amount is unmapped, it will be shown under Excluded amounts. Click on the amount to map it.
TaxBandits also supports importing your vendor details from XERO to file Form 1099-MISC/1099-NEC. To know the step-by-step instructions, click here.