Update contract dates and status flags for new sheet rows
Update contract dates and status flags for new sheet rows
Your intake rows miss normalized renewal dates and flags, causing missed follow-ups and extra manual work. It sets renewal and month-end dates and status flags so coordinators can act same day.
Overview
Right now, new contract rows arrive without normalized dates, forcing manual calculations and delaying follow-ups. By computing renewal and month-end dates and setting status flags automatically, coordinators and billing teams get accurate timelines and can act same day.