cancel
Showing results for 
Search instead for 
Did you mean: 
upstatecabling
Level 1

Importing Invoices and Expenses Error

Hello!

 

I am trying to switch from Zoho Books to QB Online. I have imported customers and vendors just fine and now I am trying to import my invoices and expenses. I have not tried expenses yet, but I did notice that there is no image from Zoho Books with the receipt. Is there a trick for this?

 

My main issue is with invoices. I have gotten it all working up to a certain point. When I import and do the mapping it comes back with this error:

 

Spoiler
The Item Rate is invalid for the following invoices. Go back to your CSV and add a positive value before trying again.

For those invoices I had some negative values. I have to have this! What do I need to do for something like this?

3 Comments 3
Fiat Lux - ASIA
Level 15

Importing Invoices and Expenses Error

Consider using an importer tool to help you.

https://transactionpro.grsm.io/qbo

 

One limitation is that you have to manually migrate attachment files for each transaction. Alternatively, consider purchasing a third party service to convert your data with attachments from Zoho Books to QBO or vice versa.

JenoP
Moderator

Importing Invoices and Expenses Error

Joining you here to share details about managing invoices in QBO, upstatecabling.

 

At the moment, there's no option to record or import invoices with negative total amounts. This is the reason why you're getting an error about an item rate being invalid. 

 

I'd also like to know why the invoices are negative in value. Are there credits or refunds for them? We just want to make sure that we're giving you the right steps to help create a workaround for this. 

 

Aside from that, can you tell us more details what do you mean by there's no image from Zoho Books with the receipt. Are you referring to attachments or expense receipts?

 

In the meantime, I recommend sending feedback or a feature request about this from your QBO account. All customer inputs are tracked and reviewed when product updates are designed. Here's how:

 

  1. Go to the Gear icon and select Feedback.
  2. Type in your feedback and suggestions about being able to import or record negative invoices in QBO.
  3. Click Next to submit them.

 

feedback.PNG

 

Similar to Fiat's suggestion, you'll also want to use a third-party app for importing data. Let me share these steps on how to look for an approved and accredited app:

 

  1. Go to the Apps menu and proceed to the Find Apps tab.
  2. Click the drop-down list for Browse category and select Sync data.

 

find apps sync data.PNG

 

Please reply back to us for more details or follow-up questions. We're always here to help. 

upstatecabling
Level 1

Importing Invoices and Expenses Error

Hello, thanks for the information. So I have a negative amount because I do work on a platform, and they charge a fee on each work order I complete. So on the invoice I put all the normal stuff like Labor and materials and then I will put the platform fee on there so there will be a -10.00 fee or something on the invoice to show I had to pay that.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us