Calculate balance for a give date