KCS - "Error on Line #: Can’t record invalid transaction" Error When Importing IIF File to Quickbooks Desktop

Issue:

  • Unable to Import my bills or transactions to QBD

Environment:

  • Quickbooks Desktop

Additional Information:

When reviewing Line Items of an error, the problematic line may be the one above or below the line number.

Cause:

There are number of possible causes for this issue.

Resolution:

  1. Check the Other Names list for existing Clients
  2. In the Customers tab in QuickBooks Desktop, search the Vendors and Employees subtabs for any clients that are producing the error.
  3. Confirm Quickbooks Desktop mapping settings are set and spelled correctly
  4. Open the IIF file in Excel and check for:
    1. Stray new line characters in the Address (they will appear as new lines in Excel)
    2. Negative transactions (will cause an error, when imported)
    3. Invoices with no Line Items (will cause an error, when imported)
  5. Contact Clio Support.
Was this article helpful?
This information is confusing or wrong
This isn't the information that I was looking for
I don't like this functionality