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!
You could set the default tax rate selection to Exclusive of tax this should allow you to overwrite the tax field. However if this does not work or if overwriting the tax field is time consuming we recommend that you contact the Apps developer/customer support for further assistance.
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
We have to collect some data when you use this website so it works and is secure. We'd also like your consent to collect data to study how people use our site. Doing so helps us improve our services and allows us to tailor the marketing you see on our site. Select 'Accept all' to agree or 'Manage consents' to choose which cookies we use. You can change your mind at any time by clicking the 'Manage Cookies' link.
Choose your cookie preferences
Some cookies are needed to make our website work and can't be turned off. But we need your consent to use others that are not essential. You can make your choices below and update them at any time using the 'Manage Cookies' link. To find out more, visit our Cookies Policy.
These cookies are necessary for the site to function. They also help us keep your data safe.
These cookies allow us to enhance your experience and remember your preferences, region or country, language, and accessibility options.
These cookies tell us how customers use our website. We study and organize this data to help us optimise our content and provide you with personalised experiences.
These cookies help us provide you with relevant communications and ads in our products and on other sites.