Importing Bills from a csv file - VAT rate

Problem reported by David Colquitt 2 years ago

When importing bills, how do I use import manual and exempt VAT treatments?

3 Replies

Hi David,

For the Exempt VAT rate, you must input 0.00:Exempt in the VAT rate column. For manual, you can input any rate you want, the system will save this as manual if this does not equal to 0%, 5% or 20%.


Hi David What if I want the import to be "Exclude from VAT" what do I need to input in the VAT rate column?

Hi Colin,

For exclude from VAT return, you must input 0.00:Out in the VAT rate.


Reply to this problem

Attach images by dragging and dropping or upload

Your comments will be public and can be answered by anyone in the Clear Books community.

Find out what we do and who we are