soft deleted transactions should not be counted as a transaction