I know I'm not accurately explaining that but here's a sample spreadsheet of what I mean:
Here are two options.
Note that it is advisable to treat the opening balance as a transaction in the "Credits/Deposits" column
Assumption - "Total" is Column G
Option #1: Enter these formulas in the nominated cells
=F2- enter in Cell G2.
=G2-E3+F3- enter in Cell G3. Then copy cell down as many rows as necessary
- Enter this formula in cell G2
This will automatically update the Total as transactions are added.