The real magic is in using a set of "CASE WHEN" currency formulas to SUM() up all transactions up until a given day.