Receipts created in spreadsheet are not getting applied to the AR invoices automatically

I am trying to load receipts from the ADFDI "Create receipts in spreadsheet". I do pass the customer name, account number and reference as transaction number and transaction amount.

The receipt batch gets created in the system. After posting the receipt, it is not getting automatically applied to the invoice number passed in the spreadsheet. The receipt is getting created with the applied amount 0.00 and asks to add open receivables (invoices) manually at the bottom of the manage receipt page.

Is this a config issue? There is no point of manually adding the open receivables(transactions) to the receipts when the transaction number was already passed in the spreadsheet.