Imported purchase invoices not calculating VAT correctly

I have successfully imported purchase invoice in csv format. They are showing VAT at 0.00% (should be 20%). I have my company settings showing VAT number and VAT box checked. Advice please.

Hi @andyhewing

In your CSV, do you have a VAT column?

The import template will use the values in the VAT columns of the CSV file, or it will use the default (20%).

I did upload a csv with a VAT rate column. I used “20.00%” in each cell of the column

Including the percent sign? It may need to be just the digits (20) to be recognised as a number rather than being an invalid string treated as zero. @QFMathew can probably confirm.


Hi Ian, thanks for that… 20 works

1 Like

This topic was automatically closed after 7 days. New replies are no longer allowed.