balance sheet formula

Copper Contributor

Hi I am trying to set up a formula wherby when I add a payment it automatically adds this to running total ie c3 +c4 is this possible 

1 Reply

@gordon27 

 

Here's how I would do it. You'll notice I combined Income and Expense tallying into one set of data; there's really no need to separate them as you did. I have them in separate columns, but this way the running total is the combined running total for all in or out transactions. Start with whatever your opening balance is. Then each row below that takes the value in that preceding row, and adds income and subtracts expense to produce a current running total.