Line level VAT
Hi,
We use an external website to generate our invoices which get sent to the customer. All of our prices advertised to wholesale customers are net, as they are mostly registered for VAT.
These invoices calculate VAT as total net @ std rate x 20%. This makes it really clear for the customer as they see an invoice for £1,000 and assuming that it's all std rated they will receive an invoice for £1,200.
However, Quickbooks calculates VAT on a line level, so when we import an invoice through our 3rd party with multiple lines then it will calculate by line and round the VAT number before adding to the VAT total, this means that the customer could get a statement saying they owe £1,199.86 (£1,000 net and VAT of £199.86).
It's then compounded because if they call up asking why the invoices are different then the accounts team will look on Quickbooks and it'll say "VAT @ 20% on £1,000= £199.86". Cue a big red flag.
Quickbooks doesn't appear to let you write to the VAT field so we can't change it unless we manually go into each invoice and edit it, which is unsustainable.
Has someone else had this issue and can help me with a workaround, we're all out of ideas!
Appreciate your help & for sticking with the long question!