cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
MTJJ
Level 2

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!

Solved
Best answer February 27, 2020

Accepted Solutions
Ashleigh1
QuickBooks Team

Line level VAT

Hello MTJJ, 

 

With you using a 3rd party it is not going to allow you to choose  the field as it works on a one line basic of an invoice that ha\s vat on. 

 

You have 3 options 

 

1- to manually go in and overwrite the field 

2- dont use a 3rd party and just csv them using quickbooks 

3- download them from the 3rd party app do any changes needed so you can them csv them into quickbooks 

View solution in original post

4 REPLIES 4
John C
QuickBooks Team

Line level VAT

Hi MTJJ

 

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.

MTJJ
Level 2

Line level VAT

Hi John, thanks for your reply. The default rate selection is Exclusive of Tax.

 

We can overwrite the field manually but not through an import as Quickbooks doesn't accept the field, despite it existing.

Ashleigh1
QuickBooks Team

Line level VAT

Hello MTJJ, 

 

With you using a 3rd party it is not going to allow you to choose  the field as it works on a one line basic of an invoice that ha\s vat on. 

 

You have 3 options 

 

1- to manually go in and overwrite the field 

2- dont use a 3rd party and just csv them using quickbooks 

3- download them from the 3rd party app do any changes needed so you can them csv them into quickbooks 

MTJJ
Level 2

Line level VAT

Ok, thank you.  Appreciate the response.

Need to get in touch?

Contact us