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

Updating Product Changes Cost Numbers

I have transactions coming from PayPal in a bank feed.  This works great but sometimes the item name doesn't match up with an item exactly (various reasons on my side for that, I understand why it's happening) so the items ends up listed as PayPal Item.  I then just update it manually in Quickbooks.  However, if there are multiple items there seems to be a little glitch which I took a screen video of at https://www.screencast.com/t/ImKTPOBiB.

 

As you can see in the video, when I change to the desired product it keeps the quantity, but it moves the full calculated amount (Qty * Rate) to the rate box, so it ends up in this case trippling the amount listed (and in the case of the line below would be 20 times the amount).  It's easy enough to reset it to the right amount before adding it, but sure seems like a bug...

5 Comments
Highlighted
Moderator

Updating Product Changes Cost Numbers

Hi, sfaust.

I can provide some information about updating product changes from the PayPal account.

 

Once the transactions are updated via the PayPal account, these changes will not synchronize when imported into QuickBooks Online. All previously created transactions will continue to reflect the old product item. If the income account or default account is affected, you'll need to delete and recreate the transactions. However, if you'll only need to change the product name, then you can edit them manually.

 

You may find this article helpful: https://help.quickbooks.intuit.com/en_US/kb/modify-settings-sync-with-paypal/000007435_en_US:SALESFO....

 

If you'd like to go through this over the phone, you can call our dedicated team who will be happy to assist you further. Our contact details can be found here along with our opening hours: https://quickbooks.intuit.com/community/Getting-Started/Get-help-with-QuickBooks-Online/m-p/185932.

 

I wish you continued success with your business. Please let me know if you have any other questions. Have a great day!

Highlighted
Level 1

Updating Product Changes Cost Numbers

No I get that.  The import part is working as expected.  I was just putting that in there to say how the transaction came to be recorded as it is, maybe I should have left it out.  

 

The issue is in editing it in QB.  If you watch the video, that is editing the transaction inside of QB.  If you watch, it original is listed as 'PayPal Item' and is 3@ 29.25 for a total 87.75 in amount.  I change the product and it switches to 3@87.75 for a total of 263.25.  It shifts the number that is originally in the 'Amount' column to the 'Rate' column...

 

Sorry I realized somehow the video link got messed up in my original post so I edited and corrected it...

Highlighted
QuickBooks Team

Updating Product Changes Cost Numbers

Thank you for updating the video link, @sfaust.

 

One possible reason the rate of the product or service changes upon trying to update it is due to how the item  is set up on your end. It could be that the rate on it is different from the rate set in your PayPal account. Let's review your Product and Service page.

 

Here's how:

  1. Click the Gear icon.
  2. Choose Product/Service.
  3. In the Product and Service page, locate the specific item.
  4. From the Action's column, click Edit.
  5. Scroll down to the bottom and look for Sales price/rate.

That should do it! If the price or rate is different from your PayPal account, you can modify it.

 

Feel free to leave a comment below if you have follow-up questions about managing your product and services item. I'm always here to help.

Highlighted
Level 1

Updating Product Changes Cost Numbers

Sorry I never saw this for some reason and moved on...  However saw it now so resurrecting it.

 

No that's not it either.  My rates are different that what is there in some cases, but they aren't the numbers that come up either.  I have my payment site set up to dynamically calculate rates in some cases so they can be any calculated amount and don't necessarily line up with what is in the settings as a 'base' rate.  However, it's not taking the base rate, it's very specifically moving the full amount over to the rate column and then multiplying THAT by the quantity so if my quantity is 3 I get triple the total after changing it, if it's quantity 5 I get 5 times the total, and if it's just one it stays the same.  Watch the video and you will see it.  It is still doing it as of now....

Highlighted
QuickBooks Team

Updating Product Changes Cost Numbers

We want to make sure this gets sorted out, sfaust.

 

I'd recommend reaching out to our Phone Support Team. This will help us investigate what's causing the rate to change when updating the product. 

 

Here's how you can reach out to us:

  1. Click the Help icon located in the upper right-hand corner.
  2. In the Help window, click the Contact Us button located at the bottom.
  3. Enter your question and click Let's talk.
  4. Choose either Start a chat or Call us.

If you have other questions or concerns with QuickBooks Online, feel free to visit us at any time. Thanks.

Need to get in touch?

Contact us