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

Having Trouble Importing Foreign Employees using IIF file

We use a data collection program for collecting time data, piece rate pay, etc. We hire 200+ workers from Mexico on an H-2A work Visa. When Importing to QuickBooks using an IIF file, I receive the following error:

The record at (or starting at) this line could not be imported. The enumerated value "" in the field "state" is unknown or invalid for the qbXML version in use. [3110]

Using a local address is not an option as we are required to use their permanent address for their W2. Is there any way to allow States from outside the United States in QuickBooks, as the IRS requires for the W2?

 

2 Comments 2
BigRedConsulting
Community Champion

Having Trouble Importing Foreign Employees using IIF file

There isn't a way import or manually record these addresses.

QuickBooks does not support foreign addresses for employees.

BettyJaneB
QuickBooks Team

Having Trouble Importing Foreign Employees using IIF file

Thanks for visiting the Community for your IIF file concern, @tmartinez.

 

I'd like to ensure you'll get routed to the right direction to help you in getting rid of the error that you received when importing the IIF file.

 

To give you the resolution on what's the right thing to do in fixing the error 3110 that you received, I suggest reaching out to our Intuit Developer. This team is the best resource for such inquiries as they are the experts when it comes to qbXML status code for IIF files.

 

You can reach their forum through this link: Intuit Developer.

 

On the other hand, QuickBooks doesn't allow you to enter an address outside the United States to show in their W-2 form. 

As a workaround, you may consider pulling up the W-2 form, then manually enter or override the home address of the workers from Mexico.

 

To do that:

 

  1. Go to the Employees menu at the top, then select Payroll Center.              1.PNG
  2. In the File Forms section, hit on Annual Form W-2/W-3.
  3. Click on Create Form.2.PNG
  4. Select the appropriate employees, then choose the filing period and click OK.3.PNG
  5. In the Payroll Tax Form, click Next until you reach the Form W-2 Worksheet page.
  6. From the Employee's address and Zip code section, right-click the address, then select Override.
  7. Enter the home address of your employee, then select Next once done.4.PNG

You can always visit this IRS article and refer to page 15 for the employee's name and address in W-2: https://www.irs.gov/pub/irs-pdf/iw2w3.pdf.

 

Know that you can always get back to me here if you need anything else. I'm always up for further assistance. Have a lovely day!

Need to get in touch?

Contact us