Need a formula to deduct payments from balance

Hello everybody, I'm new in this forum.
I've been searching for an answer for my problem for a while but I failed and it ended up asking this here I hope you can help me. It looks kind of easy but I'm not sure if it's that easy or not.

I have one list of booking amounts and another list of payments.
What I'm trying to do is preparing a balance report that automatically deducts payments from booking amounts, as in the table. Now I do it manually but I'm sure there might be a way to do it with a formula. (please note that sometimes some payments don't match, there are overpayments and short payments)
It'd be really appreciated if you could help me with this problem and I'm sorry if it's a repost.

bookings and payments are in order by dates.
when the first payment is deducted, I need the second one to be the next deduction.
I want it to deduct by amounts. If the sum of the bookings are equal or greater then the payment amount, i want to deduct the payments in order.

a simple example:
bookings payments
10 10
30 65
35 20
20 55
10
45

i need to be deducted like:
10-10
30-0
35-65
20-20
10-0
45-55