cancel
Showing results for 
Search instead for 
Did you mean: 
Wolfie
Level 2

IIF import error to desktop with IQWare

I am trying to export daily sales information from IQWare(hotel software) into QBs.  And I am getting the following error message:

 

 "you must specify a vendor name for sales tax account", then "error on line 13: Can't record invalid transaction."

 

I know I need to put the vendor name in the name box in the journal entry, which in my case would be the Commonwealth of Massachusetts.  IQWare says it is an QBs issue.  Does anyone have any input as to what I should do so the import will work?

1 Comment 1
IamjuViel
QuickBooks Team

IIF import error to desktop with IQWare

Let me share some troubleshooting steps to resolved this error prompt, @Wolfie.

 

The Sales Tax account associated with IQWare should match with the account set up in your QuickBooks. You can access your IQWare software and look into the sales tax account set up on it. Once completed, let's open QuickBooks to review your sales tax account.

 

Here's how:

  1. Go to the Lists menu.
  2. Choose Chart of Accounts.
  3. Locate the sales tax account.
  4. Right-click on it to edit.
  5. Rename it and assign it a different account number.
    • You can just add -1 to the end of the name and the account.
  6. Click the Save button.

Once completed, you can try exporting your daily sales and import the iif file again. If the issue persists, I'd recommend running the verify and rebuild utility tool to isolate this concern for possible data damage in QuickBooks. 

Here's how:

  1. Go to the File menu.
  2. Select Utilities.
  3. Choose Verify Data.
  4. You may get any of these results:
    • "QuickBooks detected no problems with your data," no further action is needed.
    • A specific error message, there may already be an article for it. Try searching for it in our QuickBooks Desktop support site for specific instructions.
    • "Your data has lost integrity," indicates there is data damage in the file.  Continue to the steps below to Rebuild Data to correct the problem.
  5. Click the File menu.
  6. Pick Utilities.
  7. Choose Rebuild Data.
  8. Click OK if you receive a prompt to backup your company file.
  9. Your computer may display the message QuickBooks is not responding. However, as long as you can see your mouse cursor to move, Rebuild is still ongoing. Wait for it to complete.
  10. Click OK when you get the message Rebuild has completed and process the next troubleshooting steps.

Once completed, you can close and open QuickBooks to ensure that all components are updated. You can refer to this article for more detailed steps: Fix data damage on your QuickBooks Desktop company file.

 

Feel free to get back to us here if you have other questions about resolving unexpected behavior while managing your sales in QuickBooks Desktop. I'm always here to help,

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up