Question asked by Nick Broadbent 9 years ago
Hi,
I would like to be able to set the VAT amount on import. The system does not allow me to map VAT to that column. Please help asap. My VAT return is due in the next few days!
Thanks,
Nick
Hello again - you could import the spreadsheet as bills, recording the VAT, then import it again as "Bill payments' to pay them all off. It would mean you fiddling with it and importing non bill payments as normal, but if there were lots of entries this would work.
Unless you've done it before the format of bills and bill payments CSVs are explained in the tools>Import menu and you can download templates.
The same works for sales, if you need to, with sales payments.
Best answerHi Nick,
Unfortunately mapping the VAT rate and treatment on an imported statement is not a feature on any of our plans.
What may possibly help cut down on clicking for you, though, is that you can specify a default VAT rate and treatment for specific customers from the Customer Invoice Defaults on their Edit Contact screen.
https://s3-eu-west-1.amazonaws.com/uploads-eu.hipchat.com/36185/2561547/MWkNqXpFGQKDNbW/upload.png
This default will then be picked up when you select that customer while explaining a transaction on an imported bank statement and will fill in the appropriate fields automatically.
I hope that helps.
All the best.
Thank you for the quick response even though it wasn't the answer I was looking for!
Correct. Yes, I am familiar with doing it that way. It is significantly more time consuming to do it on the web than it would be to do it in excel. I have the basic plan, I wondered if this mapping was available on the more advanced plans? This feature would be a huge time saving. Far less click clicking on the web and ability to get it sorted in excel before importing.
Hi Nick - it looks like you are Importing a bank statement, in which case, you just import the sums paid out or received, then go through the statement a line at a time on screen to tell the system what to do with each, including, where applicable, VAT is applicable.
Here's the guide: https://www.clearbooks.co.uk/support/guides/explain/explaining-payments-and-receipts-on-an-imported-bank-statement/
You must 
