Contract management dashboard: spend and renewals

A contract management dashboard compares contract spending, upcoming renewal decisions, and supplier performance from records your company already maintains. Its purpose is to show which agreements need attention, who owns the decision, and whether the underlying spending and delivery figures reconcile.

Start with the decision date and the money attached to it. A large supplier with an approaching notice deadline and weak delivery results deserves a different conversation from a small agreement with ample time remaining.

Use contract records and purchasing evidence together

Keep a contract register with one row per active agreement version. Include the contract ID, supplier ID, business owner, start date, end date, approved ceiling, currency, and next internal decision date. Ask the owner to confirm dates and the meaning of the ceiling before reporting them.

Bring a separate invoice export with invoice-line IDs, contract IDs, posting dates, and net amounts. Delivery records need a purchase-order line ID, the contract ID, the promised date, and the actual receipt date. This detail lets a reviewer move from a summary back to the evidence.

Do not join raw invoices directly to raw receipt rows. Multiple invoices and multiple receipts for one agreement can multiply each other. Summarize each source to the contract ID first, then attach those summaries to the register.

Invoices matching multiple agreements need an exception review, covered in contract overlap checks. A missing match belongs in an explicit unknown category; unknown contract status explains why missing evidence does not prove unmanaged spending.

Define the measures before arranging the page

Use a small set of measures with clear populations:

For this delivery measure, a delivery due during the period counts as on time only when received by its promised date. A past-due delivery still outstanding counts in the denominator and fails the test. Report quality separately rather than folding it into an unexplained supplier score.

That separation has a useful public-sector precedent: federal contractor evaluation procedures identify technical quality and schedule or timeliness as separate assessment factors. A private company's scorecard should use its own agreed requirements and ownership.

A worked contract portfolio

Consider a US distributor reviewing its agreements on September 30, 2026. Spending and ceilings below cover each agreement's current approved term; delivery counts cover July through September. All amounts are USD, with tax excluded consistently.

Remaining value is ceiling minus spending. Portfolio utilization is 300,000 / 420,000 = 71.4%, rounded to one decimal place. It is a measure of the portfolio's current approved terms, not a quarterly spending rate or a forecast of future obligations.

Keep decision timing and delivery evidence alongside the money:

Portfolio on-time delivery is 44 / 50 = 88.0%. Do not average the supplier percentages: suppliers have different delivery counts. Internal decision dates are supplied by the owners, not inferred from end dates.

Turn the rows into a review

Put contracts whose decisions fall within the next 30 days at the top. C101 and C102 meet that condition, with 120,000 + 90,000 = $210,000 of historical term spending attached to them. Label this amount carefully: it is neither renewal pricing nor the amount payable during the next month.

C102 comes first because the decision is a day away and its delivery result is weaker than the others. The owner should examine the missed deliveries and current business requirements before the review. C103 needs a different check: its ceiling is exhausted even though the renewal decision is further away. Remaining authorization and remaining time answer different questions.

In a spreadsheet, place contract ID in column A, ceiling in B, spend in C, remaining value in D, decision date in E, and report date in H1:

D2 = B2-C2
F2 = E2-$H$1
G2 = IF(B2>0,C2/B2,"")

For historical spending on agreements with an upcoming decision:

=SUMIFS(C2:C5,E2:E5,">="&$H$1,E2:E5,"<="&$H$1+30)

SUMIFS adds values whose rows meet multiple conditions. Keep already-missed decision dates in a separate exception list, so an overdue review does not disappear from the upcoming window.

Prove the totals and assign the action

The first identity is 420,000 − 300,000 = $120,000 of remaining ceiling. The second is the sum of contract spending tied back to the eligible invoice export. Include unmatched amounts in that reconciliation, even when they cannot yet appear against an agreement.

Receiving teams should verify the delivery population independently. Finance confirms spending and credits; procurement confirms identifiers and ceilings; contract owners confirm decision dates and actions. Put the exceptions and owners into the regular management reporting package, with the source cut-off date visible.

Broader exposure belongs in the risk management dashboard. This view should stay focused on the agreements and purchasing evidence behind the decisions.

Where it goes wrong

• Mixing versions. Spending from an old term compared with a renewed ceiling creates false headroom. Retain the version and effective dates.
• Treating all contract values as ceilings. An estimate, a minimum commitment, and a maximum authorization mean different things. Label the field according to the agreement owner's definition.
• Using the end date as the action date. A review that starts at expiration may already be too late for the company's decision process.
• Dropping incomplete records. Blank dates and unknown contract matches need a visible exception population, rather than silent exclusion.
• Calling remaining value savings. Unused authorization is capacity to spend, subject to the agreement. It is not a realized purchasing benefit.

Review your own contract records in Covirage

Bring a sample of your own contract register, invoice export, and delivery records to Covirage. Covirage maps the columns; its tools compute and check the figures, and the external AI model explains them with every figure traced to its rows. Create a free Covirage account, which takes about a minute, then set up your business and bring your file.

See Covirage for procurement teams for the supporting purchasing analysis context.