---
title: Most Recent Contract End Date on Account
description: You need an easy method for reporting and planning around renewals without running a multi-object report.
---

[Rollup Helper Use Case Library | Passage Technology ](https://www.passagetechnology.com/rollup-helper-use-cases)

# [Most Recent Contract End Date on Account](https://www.passagetechnology.com/rollup-helper-use-cases/most-recent-contract-end-date-on-account)

 Written by [Cady Wakitsch](https://www.passagetechnology.com/rollup-helper-use-cases/author/cady-wakitsch) | Mar 31, 2022

## Problem: You need an easy method for reporting and planning around renewals without running a multi-object report.

## Solution: Rollup the most recent Contract end date to Account.

Create a rollup to aggregate the most recent Contract end date to Account.

The first step is to create a new custom field (using Date as the data type) on the Account object. You can name the field "Renewal Date."

Create the rollup:

- Select *Account* as the Destination Object
- Select "*Renewal Date*" as the Target Field
- Select *Contract* as the Child Object
- Use the standard *AccountId* Relationship Field
- Select *Maximum* as the Rollup Type
- Select *Contract End Date* as the Source Field
- A New Filter is optional
- Save the filter, then Save and Run the rollup

You can use this information to send email alerts to customer success teams or clients 30/60/90 days in advance to remind customers of their renewal.

*This use case came from our one our customers! We love to hear how you're using our apps to solve different needs. Let us know if you have a [success story you want to share with us.](https://www.passagetechnology.com/share-your-story)*

[View full post](https://www.passagetechnology.com/rollup-helper-use-cases/most-recent-contract-end-date-on-account)

```json
{
  "@context" : "http://schema.org",
  "@type" : "BlogPosting",
  "author" : {
    "@type" : "Person",
    "name" : "Cady Wakitsch"
  },
  "dateModified" : "2026-04-22T17:45:25.016Z",
  "datePublished" : "2022-03-31T16:59:01Z",
  "headline" : "Most Recent Contract End Date on Account",
  "image" : {
    "@type" : "ImageObject",
    "height" : 1196,
    "url" : "https://www.passagetechnology.com/hubfs/Most%20recent%20contract%20end%20date%20rollup.jpg",
    "width" : 858
  },
  "mainEntityOfPage" : "https://www.passagetechnology.com/rollup-helper-use-cases/most-recent-contract-end-date-on-account",
  "publisher" : {
    "@type" : "Organization",
    "logo" : {
      "@type" : "ImageObject",
      "height" : 60,
      "url" : "/hs/hsstatic/content_shared_assets/static-1.4092/img/default-amp-logo.png",
      "width" : 60
    },
    "name" : "Rollup Helper Use Case Library"
  }
}
```