Receipt Application-Unapplied Amount

Content

This is the business scenario. We are using Receipt Spreadsheet Upload feature(we do not have Lockbox). 

Receipt Amount: $ 100

Invoice A: $ 20 , Invoice B: $ 50, Invoice C: $ 70

Is there any way to load the spreadsheet so that the following is achieved?

Receipt Amount: Fully Applied

Invoice A: $ 20 fully applied, Invoice B: $ 50 fully applied and Invoice C: Partially Applied for $ 30

But currently, this is what is happening:

Receipt Amount: Applied $ 70, Unapplied: $ 30

Invoice A: $ 20 fully applied, Invoice B: $ 50 fully applied and Invoice C: Nothing applied

Thanks!

Thomas