How to import negative amounts on transactions

You can import negative or credit amounts or rows in transactions into QuickBooks based on the following rules:

  • Discount type items - You can import as a discount line item and the amount or rate will be presented as a negative rate or amount on the transaction, however you will not be able to specify a quantity on a discount line item.
  • Inventory type items -  You can import a negative or credit inventory item type only if you specify a negative quantity, if the data includes a negative rate or amount then QuickBooks will reject that transaction.
  • Service type items - You can specify a negative amount or rate for a service type item.