How do I stop the rates on sales invoice from automatically rounding to mulitple decimal please?

3 replies
8 views

We have a client who is producing invoices in Quicbooks Online selling products per KG. One product, for example, is £9.50 per 1 KG so has a rate of 9.5 per Qty of 1. When we create an invoice we enter the quantity of 5.254, the rate of 9.5 is saved in the product details and it works out the correct amount of 49.91, however, when the invoice is saved it changes the rate to 9.499429. Is there any way to stop this from happening? Thank you in advance.

QuickBooks Online

taylorandcoaccAnswer

Thank you for your response but I found a fix.

Even though these items are z rated for VAT I switched from inclusive of VAT to exclusive of VAT. Problem solved, the rates stay as they are supposed to.

Ashleigh1

Level 14

Hello Taylorandcoacc,

Welcome to the Community page,

There is no way in QuickBooks to stop the rounding from happening, you can leave this as feedback within the main cog wheel.

taylorandcoaccAuthorAnswer

Thank you for your response but I found a fix.

Even though these items are z rated for VAT I switched from inclusive of VAT to exclusive of VAT. Problem solved, the rates stay as they are supposed to.

Ashleigh1

Level 14

Hello Taylorandcoac, no problem at all, glad you are all sorted and thanks for sharing it as well.

Sign up

Login with SSO

Let's get you signed in

Login with SSO