Page Comparison

n.b. can also include past subscription in this report

Steps

<screenshot of nav bar >

<choose report type>Objective: To export a spreadsheet of all current subscriptions, and upcoming renewals

Steps

1. Go to the Reports Module

Expand
title Expand for details on navigating to Reports
In the top navigation bar, hover over MORE In the drop down, click on REPORTS Image Added

2. In the main menu, 📖 copy the report titled “Current and future renewals template”

3. In the “Edit the report” interface, you can further customize this report

4. Expand the PRICES box in the left navigation bar

5. [MANDATORY] Select the calendar years you want to export
   e.g. you want to see current subscriptions for FY23/24 and upcoming renewals for the rest of FY 23/24 and FY 24/25

...

6. Click the REFRESH button to preview

7. Click SAVE REPORT & GENERATE

You should receive a spreadsheet in your email shortly.

In Excel

After downloading and opening your spreadsheet, you will have to do a little data cleaning.

Filter to just the months in your desired reporting period.

Expand
title If you would like more guidance, expand this box for suggested steps.
Select all cells with data Apply a filter Click on the grey square button in the “Start Date” column header In the drop down, click on the + sign expand the start and end years of your reporting period Image Added Uncheck the months that fall outside the fiscal year. For example, if the reporting period is FY22/23 and FY 23/24, I will uncheck all months after March 2024. Image Added Click Ok to close the drop down and see your filtered results. Alternatively, to delete all unwanted records: Follow steps 1-3 above Click the box next to the year to unselect everything Expand the start and end years of your reporting period Check all the months that you don’t want Click ok Select all displayed rows and delete them Image Added Clear the filter Image Added Only the subscription records that fall within your reporting period should remain.

Delete irrelevant price records

The exported data includes price records for products you don’t subscribe to in the present and future. These have to be deleted.

1. Select the whole table and apply filter

2. Filter for rows fulfilling these criteria:

   1. Price type = new

   2. Price status = not sent + waiting

3. Delete the resultant rows

You should have only new + accepted (if any), and renewal + accepted, renewal + waiting, renewal + not sent rows left.