Skip to main content
JaneS2021
Jun 21, 2022 12:52 PM UTC
Question

Importing invoices from CSV file with negative line items

Hi  - I am trying to import a CSV file to generate multiple invoices. 

There are some negative line items in the CSV which causes an error message in QBs and won't allow the file to be uploaded. 

Anyone else had this and resolved the issue? 

Many thanks

3 replies

GeorgiaC
Jun 21, 2022 1:29 PM UTC

Hi JaneS2021, thanks for your post - does your CSV file contain any blank cells within the selected rows/columns or negative values (denoted with a '-' symbol)? 🧐

JaneS2021Author
Jun 21, 2022 1:41 PM UTC

Hi Georgia,

Yes it does contain negative values denoted by '-' symbol. 

 

GeorgiaC
Jun 21, 2022 2:44 PM UTC

Thanks Jane, when importing invoices the value needs to be greater than 0 on each line - any negative (discounts) would then be manually entered afterwards 🙂

Terms & ConditionsAccessibility statement