added redundancy check for manual a/r and added ar spreadsheet wipe