Skip to main content
taylorandcoacc
Jul 25, 2022 9:30 AM UTC
Solved

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

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.
taylorandcoaccAnswer
Jul 25, 2022 1:50 PM UTC

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.

View in thread

3 replies

Ashleigh1
Jul 25, 2022 11:34 AM UTC

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
Jul 25, 2022 1:50 PM UTC

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
Jul 25, 2022 1:57 PM UTC

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

Terms & ConditionsAccessibility statement