Would be good to have that kind of feature which allows settle automatically all the lines using only excel add on. Currently it's not possible - only transactions posted through User Interface are automatically posted. There is of course automatic settlement in account receivable parameters but there would be good to have only feature which allows settling transactions only from excel add on as some customer may not use User Interface at all, especially when we are talking about huge amount of transactions