Applying Payments to the oldest charges.

Hello all.

I receive a monthly report from a CC company which includes the following identifiers that looks like the attached sheet.
Column A Charges
Column B Credits
Column C Payments
I can produce a running balance on the account which is Column E but occasionally we send payments after the statement period has closed (usually on the 28th day of the month).

So I want to be able to apply payments to the oldest charges to see which individual items haven’t been paid for or know whether there is a credit balance.

If I could put the formula in to words it would sound like this:
In Column F. If Column A=3, then take that amount and sum it to the oldest items in Column D where Column A =1 or 2 until the value =0, repeat.
Is there a formula that would do this? Is it possible?

Any help would be greatly appreciated.