Matching invoice amounts and payment amounts

Dear all,

I have a task to match invoice and payments related to the same clearing documents with FIFO method. I tried it with Excel however could not succeed. MS Access might be the solution however I have quite limited SQL experience. A very simple dataset consists up of invoices and payments is this;

Invoices table

Payments table


And the desired outcome is to obtain which portion of invoice is paid as of which date. Like this;


As you may see in the desired outcome,

1) For clearing no. 222; since there is only one invoice and there is only one payment which are matching in amount (7.500); the result is so smooth.
2) For clearing no. 111; it is a bit more complicated.
a) Invoice 1 and 2 (each 25 K) was paid with payment 7 (50 K). In the desired outcome we see that half of payment 7 (25 K) is attribute to invoice 1; and the other half is attributed to invoice 2.
b) As per FIFO, Payment 8 (30 K) first pays invoice 3 (25 K), and then pays the 5K portion of invoice 4. The remaining of invoice 4 is paid by payment 9.

So basicly; for under each clearing item and based on FIFO; I am trying to match invoices and payments according to the two rules I mentioned above.
It does not matter if the total amount of invoices and total amount of payments under the same clearing chunk is not the same (ie; does not result in 0). The code should run until either total invoice or total payment amount in that chunk runs to 0.

However I cannot formulate it in SQL.
Any help is appreciated.