=arrayformula(vlookup(J3-0.01,sort({A4:A,sumif(A4:A,"<="&A4:A,B4:B)}),2,1))
This works in Google Sheets but not in Libre … Err:539
J3 is the Date of Next Deposit … Col A is the Date of all Transactions … Col B if the Value or each transaction …
2020 Credit Tracker 2.ods
This is the entire spreadsheet with all pages included.