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?
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.
Go to the Lists menu.
Choose Chart of Accounts.
Locate the sales tax account.
Right-click on it to edit.
Rename it and assign it a different account number.
You can just add -1 to the end of the name and the account.
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.
Go to the File menu.
Choose Verify Data.
You may get any of these results:
"QuickBooks detected no problems with your data," no further action is needed.