Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 
  • Community
  • Q&A
  • Jira
  • Questions
  • Best way to implement a “Contract Calendar” matrix (Client × Activity × Frequency) in Jira Software

Best way to implement a “Contract Calendar” matrix (Client × Activity × Frequency) in Jira Software

Kirti Rajput
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
December 16, 2025

Hi Community,

I’m trying to design a Contract Calendar in Jira Software Cloud (Standard plan).
We currently maintain an Excel matrix like this:

  • Rows = Clients (Bajaj, Cohizon, SEIL, etc.)

  • Columns = Activities/Controls (Delivery Manager Visit, Monthly SLA/MIS report, Site Audit, CSAT, VIP user connect, etc.)

  • Each cell = Frequency (Daily/Weekly/Monthly/Quarterly/Half-yearly/Yearly/NA)

Goals in Jira:

  1. Create recurring tasks based on frequency (Monthly/Quarterly/Half-yearly/Yearly).

  2. For some activities (e.g., Site Audit), enforce mandatory proof before closure.

    • Evidence is uploaded via Zoho form / SharePoint, so in Jira we prefer storing only a Proof Link / Submission ID (no double upload).

  3. Add an approval step before final closure (Pending Approval → Done).

  4. We have mixed projects (some team-managed, some company-managed), and we want one approach that works across both.

  5. Avoid chaos for PMs and avoid creating thousands of issues for daily checks.

Questions:

  • What is the best Jira design pattern for this?

    • Should we use a Catalog + Occurrence model (master list of controls + auto-created occurrences)?

    • How do you typically handle Daily/Weekly checks (logbook vs individual issues)?

  • What is the best way to enforce proof mandatory (preferably via Proof Link field) and approval before Done on Standard plan?

  • Is there a recommended way to manage “Applicable in this project/client but not in that one” without maintaining different workflows per project?

Any recommended workflow, field structure, and automation approach would really help. Thanks!

0 answers

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events