You can check out the Account Reconciliation - Google Sheets that might help you get a running balance.