Allocating payment across a series of invoices

[North100]

Hello,

Based upon the attached, I need an excel formula which will allocate the £3,560 payment amongst the listed invoices, starting from the earliest dated invoice. I anticipate that there will be a part-payment on one invoice.

Thanks for your help.