Expense Report Sum Totals

I am trying to enter a new formula and just can't seem to get it. What I need is column C2 to subtract Column D1 and to equal the new balance on D2 except for when column E has the word Advance in it. When it has the word Advance in it, it then Adds column C2 to D1 equaling on D2.

And if column D has a balance of 0 and the word Advance is not in column E then D2 stays at 0.

Also column C need to have a running total balance.

See attached Spreadsheet

Thanks so much.