A semi-advanced matching problem which may be solved with formulization or VBA

Dear excel masters,

I have a task to match all vendor invoices with their related payments with FIFO logic. However I cannot build the model in excel and need assistance.

As you can see in data chunk (or screenshot); there are 3 clearing items in data (in my actual data more than 5.000) as seen in B column.

- In clearing 111111; we see 5.000 USD invoice as of 11.11.2022 is paid with 5.000 USD on 30.12.2022.
- However not every clearing consists up of only one invoice and one payment. Such a in clearing 3332222; we see 3 different invoices, where invoice no.s 17 and 18 (total 10 K USD) is paid with payment 32. And Invoice 19 is fully paid with payment 36.
- Sometimes invoice and payments are not directly matched in amount, and some portion of invoices might not have been paid yet. In clearing 111122, we see that,
+ payment 131 (30 K USD) fully pays invoice 112 (15 K USD), and then pays 15 K portion of invoice 114.
+ for invoice 114, the remaining 5 K USD amount is paid by payment 134.
+ With FIFO method; when all invoices and payments are matched; we still see that invoice 131 have a 5 K USD portion which have not yet been paid.

What I am trying to do?
For each invoice; I am trying to obtain what part of amount is paid as of which date; and to see if there is any remaining invoice amount not yet been paid.
How can I construct a model which solves this?

Thanks in advance.



EDIT:
I would like to renew my purpose;
I am just trying to automatically fill the two columns below;
- Payment Matching Amount
- Payment Matching Date

(Also as seen in invoice document 114; sometimes the information may be in more than one line since the invoice is paid with different payments).

I am not interested to find remaining invoice amount that have not yet been filled.