Thanks @JasroV , the only problem is that the transactions isn't showing as a deleted one when I look in the audit log but when I look in the reconciliation report it is saying it has been deleted?