pair refactoring of renewal reporting with Ram