Adding total to invoice and make Quickfile to calculate the VAT

[expertoswp]

Hi,
Is it possible to define the final amount for an invoice and make Quickfile calculate the VAT?
At the moment I can make the item and then add the VAT, which is fine for most services, but I have some products where the price is rounded with VAT included.
I would like to keep that “rounded” introducing the final price and getting the VAT from there.
Is that possible?

[QFMathew]

Hi @expertoswp

On a sales invoice you can tick the “Enter line totals inclusive of VAT”, which will allow you to type in the gross totals on a line-by-line basis. QuickFile will then work backwards and calculate the net based on the specified VAT rate:

[expertoswp]

Great! Thank you!
Is it possible to do this using the API?

Edit: checking the docs it does not seem possible.

[ian_roberts]

I don’t think it’s possible to have QuickFile calculate the gross-to-net via API but you can override the VAT amount (not just the rate) per line so you can do the equivalent calculation yourself before calling the API.

[expertoswp]

Yeah, I suppose I do not have any other options, but the calculations are sometimes tricky with the decimals, and the gross value needs to match what the client pays.
And in spain is a 21%, which complicates this a little more (20% is much easier with decimals).

So I need to see with the accountant how can we do that.
Not a trivial thing at all.