You mentioned the transaction has not been reconciled in a previous return.
If you are using Version 23 or above you can delete journals and transactions by highlighting the transaction and clicking the delete button.
However, if you do cash vat accounting you need to delete the payment element first and then reenter the Invoice customer receipt or Payment this means that the vat is now dealt with correctly for cash accounting.
Sage is just as easy to edit as any other software when it comes to Cash accounting. You need to be careful with cash accounting and check your Vat report in detail.
I have found that in the case of Cash VAT Accounting in Versoin 24 you now don't even have to delete the supplier payment or customer receipt first , right click on the invoice and select unallocate, then edit.
I have also had a staff member edit a transaction that had been through the VAT Return, Sage then showed the delected transaction as a credit and the amened one as an invoice in the next VAT Return, I did blow the top at the staff memeber so they have not done that again!! but at least I know for future that Sage can handle it.
I do know that a lot of the C.A.s do not like bookkeepers making adjustments by using edit, mainly because it makes the audit trail messy, they would prefer that in the case of invoicesor credits you just processed the opposite transacton then a new transaction or process a journal.
Edited at 26 Sep 2018 07:03 PM GMT”