Batch Number logic for Intercompany transaction through spreadsheet

Summary:

Batch numbers given while uploading spreadsheets are overridden by the application once they are uploaded. If the same batch number is used in the spreadsheet, the upload will error out. Since the batch numbers used in the spreadsheet and generated in the application are different, how do you check which batch number has already been utilized in the spreadsheet? How should the batch number be populated for intercompany transactions in the spreadsheet??

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):