In my experience, credits from a cancelled award usually have the same posting date as the original award, so even getting a balance as of a specified date might not give you what you need. That's why many of us maintain our own spreadsheets.