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.
2 Likes
Hi Ian, thanks for that… 20 works
1 Like
This topic was automatically closed after 7 days. New replies are no longer allowed.