Applying amount to the oldest balance?

Hi Guys,

simply I got the following table:
A B C D E F G Total
100.00 (8,000.00) 200.00 500.00 3,000.00 (2,500.00) 10,000.00 3,300.00

I need a formula or macro that helps me get the following result:

A B C D E F G Total
100.00 - 200.00 500.00 2,500.00 - - 3,300.00


so, basiclly the negative balances deducted from oldest balance (left side).

Thanks in advance.

because we've got (2,500) & (8,000), a total of (10,500) & that deducted from the oldest balance which is 10,000.