cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get your Payroll questions answered by a QuickBooks Product Manager here - intuit.me/31Nl3My
linnworkstools
Level 1

Please help me for decimal issue on amount of invoice tax as well on items amount

 
7 REPLIES 7
EmmaM
QuickBooks Team

Please help me for decimal issue on amount of invoice tax as well on items amount

Hi, linnworkstools,

 

Could we ask for a little bit more information on the issue you are having with decimals? Is it the rounding you're referring to? Are you looking to change the amount in the box that is calculating?

 

Thanks😊

linnworkstools
Level 1

Please help me for decimal issue on amount of invoice tax as well on items amount

Hi

please check json file here for invoice data

the total amount of invoice and tax is not proper calculate it should be like 

this is correct calculation as per my json but quickbook not work same way.

tax :4.46

sub total :22.28

net amount :26.74

 

but it;s not working as per my order has.

MaryLurleenM
Moderator

Please help me for decimal issue on amount of invoice tax as well on items amount

Hello there, linnworkstools,

 

When you create invoices or sales receipts, the Rate field allows you to enter more than 3 digits. However, the amount is rounded off to the nearest penny.

 

Furthermore, you can override the amount when filing the VAT return. QuickBooks Online is accepted by HMRC as a valid VAT calculation engine, it's been signed off as per HMRC's testing and calculation criteria.

 

Let me know if you have additional questions.

linnworkstools
Level 1

Please help me for decimal issue on amount of invoice tax as well on items amount

Hi

i have round the item amount and used excluding tax than also tax calucation is wrong while send invoice from api.

 

please check attachment as well.

SubTotal is :22.28

Tax percentage :20% 

than Total tax showing me : 4.55

but actual tax is  22.28*20/100 = 4.46

so please help us to resolve this thing.

 

 

Ryan_M
QuickBooks Team

Please help me for decimal issue on amount of invoice tax as well on items amount

Hi @linnworkstools,

 

I appreciate your prompt reply, as well as sharing a screenshot of the invoice you created.

 

I can see at least one of your line items in the invoice has a negative amount. This causes the VAT calculation to be off. I've tried replicating this on my test account, using an invoice but only has a single line item. The VAT calculation is correct with an amount of 4.46.

 

Based on the description of the line item with a negative amount, I'm assuming it's a refund. I suggest you follow the steps in this article to properly enter a refund: Record a customer refund in QuickBooks Online. This way, the amounts of the boxes on your VAT return will remain accurate. 

 

You can also keep this article for a reference, whenever you need to enter a VAT payment: Record a VAT payment or refund. This includes a short video that demos the process of recording a VAT payment or refund. 

 

Post a comment below in case you need further assistance. I'll be glad to help.

linnworkstools
Level 1

Please help me for decimal issue on amount of invoice tax as well on items amount

Hi 

it's possible for call so i will share my screen to you may be it's help to me and you also what issue i faced.

Becky29
QuickBooks Team

Please help me for decimal issue on amount of invoice tax as well on items amount

Hello, linnworkstools 👋 We can't call out as we are digital facing with the customers, however, if you wish to speak to an agent and set up a screen share this is the contact QBO 0808 234 5337. Becky