United States United Kingdom Australia Canada (English) Canada (French) France Singapore South Africa Global Ireland
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
JaneS2021
Level 1
posted
‎June 21, 2022 01:52 PM
last updated ‎June 21, 2022 5:52 AM

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

0 Cheers
Cheer
Reply Join the conversation
3 REPLIES 3
GeorgiaC
QuickBooks Team
QuickBooks Team
‎June 21, 2022 02:29 PM

Importing invoices from CSV file with negative line items

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)? 🧐

0 Cheers
Cheer
Reply Join the conversation
JaneS2021
Level 1
‎June 21, 2022 02:41 PM

Importing invoices from CSV file with negative line items

Hi Georgia,

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

 

0 Cheers
Cheer
Reply Join the conversation
GeorgiaC
QuickBooks Team
QuickBooks Team
‎June 21, 2022 03:44 PM

Importing invoices from CSV file with negative line items

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 :)

0 Cheers
Cheer
Reply Join the conversation
Featured
Get started with QuickBooks Online
Ready to get started with QuickBooks Online? This walkthrough guides you th...
Read more

Need to get in touch?

Contact us