I need to produce a report on a monthly basis of the input VAT I have claimed. Report needs to have the following columns:
Amount excluding VAT
Suppliers Vat number
I can see how to put all this information onto a suppliers invoice when entering it into Manager (custom fields?), but am not too sure how to get it all to appear on a report
You can get most of this information from the Tax Transactions report. Export the report to a spreadsheet and add columns for the amount excluding VAT, suppliers’ VAT numbers, and descriptions. Delete the lines for output VAT.