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

linnworkstools · ‎May 27, 2020

Ryan_M · ‎May 30, 2020

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.

View solution in original post

EmmaM · ‎May 27, 2020

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:smiling_face_with_smiling_eyes:

linnworkstools · ‎May 27, 2020

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 · ‎May 27, 2020

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 · ‎May 30, 2020

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 · ‎May 30, 2020

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 · ‎June 01, 2020

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 · ‎June 01, 2020

Hello, linnworkstools :waving_hand: 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

Topics

Training

Community

Resources

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