In the audit reports (e.g. AUDITDL) when downloaded as an Excel/csv file, how do you identify the deleted or cancelled transactions (which are shown in red when you look at it in Sage). They all appear to start with "Cancel - see tran" oe "Deleted" in the TransactionItemised.Details field, but surely somebody could enter text like that in a normal entry in the Details column, so that isn't absolutely guaranteed to be a system deleted or cancelled transaction.  Sage must have some way of identifying the transactions to be ignored, but how do we do it?

Alternatively is there a version of the AUDITDL report which excludes deleted/cancelled transactions?