I am trying to currently reconcile my clients VAT. The company is on cash accounting and I have created a Aged Debtors report on Sage that shows me what the VAT of each o/s item is. However with some of the balances, they have been written down as payments have been allocated against the original invoice. So when I do my Aged Debtors report with VAT amounts, it shows the VAT amount of the original invoice and not of the amount that is currently due. Is there anyway that you can amend the report so it only shows the VAT amount on what is due and not what the orginal invoice is?