Real Business Solutions Home

How to E-file QuickBooks 1099 Misc Forms with Connecticut

W2 Mate software e-files 1099 Misc forms with the state of Connecticut. Easily import Misc data from QuickBooks with our built in QuickBooks importing wizard. Then simply generate an electronic submission file and upload the file through the Connecticut Department of Revenue Services (DRS) Taxpayer Service Center.

Import 1099 Misc Data from QuickBooks

Step by Step Instructions

Make sure you have the correct Company open inside W2 Mate.

1. Click "Import Data" from the top menu.

2. Select "From QuickBooks (W2 and/or 1099 Data)". This will open the QuickBooks Import wizard.

3. Read Message-understand you will need to have QuickBooks open and actively running.

4. Click "Next".

5. Click "Connect to QuickBooks". This will open a QuickBooks dialog asking if you want to authorize W2 Mate to access the company information in QuickBooks.

6. Click "Yes".

7. Checkmark to allow this application to access personal data.

8. Click "Continue".

9. Click "Done".

10. Click "OK".

11. Click "Next".

12. Select 1099 Data.

13. Select "Tax year" from drop down menu.

14. Select "1099-MISC" from drop down menu.

15. Click "Next".

16. Click "OK".

17. Review data to import.

18. Click "Next".

19. Click "Finish".

Note: The steps above are for importing from QuickBooks desktop. To import from QuickBooks online (QBO), please follow this tutorial. How to Import 1099 Data from QuickBooks Online

Connecticut 1099 Misc E-File Instructions

Step by Step Instructions

Make sure you have the correct Company open inside W2 Mate.

1. You have imported 1099 Misc data from QuickBooks. Review the imported data inside W2 Mate.

2. Under the Company General Information tab inside W2 Mate, make sure to enter "CT" for the State field. Do make sure to enter the state ID if you have one with Connecticut.

3. Very Important: Make sure Box 17 on all 1099-MISC forms is set to "CT". To be on the safe side, select from the top menu inside W2 Mate "Tools > Other Recipient / 1099 Tools > Update Box 17 (State, Payers State #) for multiple 1099-MISC Recipients" and select "CT" as the state abbreviation and the employer state ID (if you have one).

4. From the top menu inside W2 Mate select "E-Filing > 1099-MISC Forms".

5. In the 1099 E-File dialog use "11111" (no quotes) for the TCC code since you are filing with the state.

6. In the 1099 E-File dialog make sure you DO check the box "Include Combined Federal / State Filing Program Information".

7. Once all the data in the 1099 E-File dialog is populated, click the OK button. W2 Mate will create the file and show a success message.

8. Upload the file through Connecticut Department of Revenue Services (DRS) Taxpayer Service Center ( You will need to file with “Batch File Upload Using DRS Standard File Layout” this option allows you to upload a file that is formatted with the Standard (1220, FIRE) File format. For telephone assistance, call Connecticut DRS at 800-382-9463 (Connecticut calls outside the Greater Hartford calling area only); or 860-297-5962 (from anywhere).

© Copyright 2018 Real Business Solutions. All Rights Reserved. Privacy statement and terms of use . Uninstall Instructions