Skip to main content
July 25, 2022
Solved

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

  • July 25, 2022
  • 1 reply
  • 0 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.
Best answer by taylorandcoacc

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.

1 reply

July 25, 2022

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
July 25, 2022

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.

July 25, 2022

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