I was leaning towards a custom field on the customer record that I could then finesse into a date and run some case statements in a saved search to try and put $$ where it should be. Seems a bit daunting...