I know I'm not accurately explaining that but here's a sample spreadsheet of what I mean:

Link to spreadsheet

1 Answer 1


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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.