How can you include a non standard amount of tax to expense lines?
While the rate of VAT in my country is a standard 15% it is only applied to certain items. If a receipt contains both VAT and zero rated items then the amount of tax will be anywhere between 0 and 15%.
The exported CSV includes a Tax Amount field, however when I import a CSV either with OR without the Tax Name and Percentage completed, Zoho Books appears to ignore the Tax Amount and overwrite it.
If the tax name and amount are left blank it overwrites the Tax Amount with 0 AND overwrites the "Is Inclusive Tax" field with FALSE.
If the tax name and amount are completed it overwrites the Tax Amount with that percentage of the Total.
Had I not checked the export CSV against the import CSV, I might have been prosecuted for over claiming VAT.
As I need an answer urgently, I will list some workarounds that I have already considered and discounted as impractical: Please don't suggest that I split expenses into VAT and non VAT components, as some expenses have hundreds of lines which we would then need to manually total. Please also don't suggest that we work out the percentage and add a new tax type for each expense - we have hundreds.
THIS IS URGENT: We have 4 days to complete the accounts - hence posting this here as I have not yet received an answer from support. I have also called your phone number, which allowed me to leave my number, but didn't give time to explain the problem. I tried pressing 3 to change the message multiple times but it didn't work. Apologies for the odd message.