Importing Purchase Invoices from excel

Hi,

I’ve just started using quickfile yesterday. Today I’ve created a csv file to import purchases. My first attempt just had gross amounts, I left out VAT information because my company is VAT registered so I expected the purchases to default to Standard rate, however they came through as zero rated. I didn’t want to adjust each invoice separately (there are 50 of them), so thought I’d try again by including a column for VAT rate, however when I try to upload it quickfile cannot read that field. What format should it be in? I’ve tried 20% and Standard VAT Rate but neither of those work.

I’ve imported them and deleted them twice already - surely this should be simple?

Thanks in advance for any help

If you remove the % symbol in the VAT rate column it should work fine. Let me know if that works?

It did! Thanks for the speedy reply

1 Like