Good afternoon.
I'm currently working on an accounting/bookkeeping spreadsheet.
I have a table to input and view transactions.
In column J, i'm looking to create a running balance, however i would like to have the running balance based on the account listed in column A. This serves a few purposes, including being able to filter by account, and then see a consistent running balance for that account. Also i can quick glance on a certain transaction/date and know what an account balance was on that date.
Example:
Account Amount Running Balance
(Column A) ------(Column H)--------- (Column J)
Account 1 ------ 100.00 --------- 100.00
Account 1 ------ 50.00 ---------- 150.00
Account 2 ------ 75.00 ---------- 75.00
Account 3 ------ 100.00 ---------- 100.00
Account 3 ------ 25.00 ---------- 125.00
Also would like the blank rows below the last transaction to show nothing in Account Balance instead of 0.
Apologies if this is not a great representation for the sake of help.
Please let me know what I can do to try to get assistance for this.
Thank you!
Bookmarks