Can the system handle UK VAT?
Posted: Sun Apr 20, 2008 4:12 pm
Q: If I use this system, can I use it to help with my VAT returns?
A: Yes - you can, although this is not specifically built in. However, the system will produce a list of lets (and totals) for each property in spreadsheet (.csv) format. Open the file in a spreadsheet, and then just enter the appropriate formula to calculate the proportion of the rental that is VAT or Sales tax etc).
Example (at current UK VAT rates): if the income from a let is in cell D3, enter the formula +D3*0.175/1.175 in an appropriate cell further across the row. The result will be the amount of VAT taken. You can quickly replicate this formula down a column to see the complete list of VAT receipts, and you can then print the sheet to get your VAT return.
A: Yes - you can, although this is not specifically built in. However, the system will produce a list of lets (and totals) for each property in spreadsheet (.csv) format. Open the file in a spreadsheet, and then just enter the appropriate formula to calculate the proportion of the rental that is VAT or Sales tax etc).
Example (at current UK VAT rates): if the income from a let is in cell D3, enter the formula +D3*0.175/1.175 in an appropriate cell further across the row. The result will be the amount of VAT taken. You can quickly replicate this formula down a column to see the complete list of VAT receipts, and you can then print the sheet to get your VAT return.