Commenting mostly because I hope to see what people say, but I would imagine you could have a new column in your spreadsheet that records for each historical transaction how much or it got spent when.