Internal Audit Template for IT Managers: Annual Vendor True-Up Reconciliation

1. Software Vendor, Product SKU & Deployment Details

This section captures foundational vendor and product information essential for audit trail and contract correlation. Provide accurate metadata to ensure proper license reconciliation.

 

Software Vendor Name

Vendor Account Manager Name

Enterprise Contract Number

Product SKU or Part Number

Software Product Name & Version

License Model Type

Deployment Architecture

Deployment Environment Details

Geographic Deployment Regions (Select all applicable)

Current Contract Start Date

Current Contract End Date

True-Up Assessment Date

Is this software subject to regulatory compliance requirements?

 

Select applicable compliance frameworks

Special License Terms or Restrictions

2. Active User Seat Count & Cloud Telematics Consumption Audi

Audits active license consumption against entitlements. Quantifies actual usage and captures cloud-native telemetry data for consumption-based billing models.

 

Total Licenses Purchased (Baseline Entitlement)

Total Licenses Currently Allocated

Active Users (Last 30 Days)

Active Users (Last 90 Days)

User Activity Segmentation Analysis

User Segment

Total Seats

Daily Active (>4 hours)

Weekly Active (1-4 hours)

Monthly Active (<1 hour)

No Activity (0 hours)

A
B
C
D
E
F
1
 
 
 
 
 
 
2
 
 
 
 
 
 
3
 
 
 
 
 
 
4
 
 
 
 
 
 
5
 
 
 
 
 
 
 

Does this product include cloud infrastructure consumption charges?

 

Cloud Telematics Consumption Metrics (Last Quarter)

Metric Type

Actual Consumption

Contracted Baseline

Overage (Units)

Overage Cost

A
B
C
D
E
1
 
 
 
 
 
2
 
 
 
 
 
3
 
 
 
 
 
4
 
 
 
 
 
5
 
 
 
 
 
 

Are there automated provisioning workflows integrated with this software?

 

Select integrated provisioning systems

Describe any usage anomalies or irregular patterns detected during audit period

Rate the accuracy of your organization's current license allocation tracking

3. License Over-Allocation & Unused Seat Reclamation Analysis

Identifies license inefficiencies. Quantifies over-allocation, categorizes unused seats, and builds reclamation strategies to optimize license usage prior to true-up.

 

Total Unused Seats (No activity last 90 days)

Unused Seat Categorization & Reclamation Feasibility

Category

Count

Reason for Non-Use

Reclaimable?

Reclamation Action Plan

A
B
C
D
E
1
 
 
 
 
 
2
 
 
 
 
 
3
 
 
 
 
 
4
 
 
 
 
 
5
 
 
 
 
 

Are there licenses allocated to service accounts or non-human identities?

 

How many service account licenses can be converted to free tiers or developer licenses?

Has your organization identified any shadow IT usage of this software?

 

Describe shadow IT instances and remediation plan

Assess the risk level of maintaining current over-allocated licenses

Very Low

Low

Medium

High

Critical

Financial waste risk

Compliance audit risk

Security risk from dormant accounts

Operational inefficiency risk

Vendor relationship impact

Projected Annual Savings from License Reclamation

Business justification for retaining any intentionally over-allocated licenses

4. True-Up Cost Adjustment & Budget Re-Allocation Proposal

Calculates true-up financial impact and budget adjustments. Translates audit findings into concrete cost scenarios and reallocation strategies for executive decision-making.

 

Current Annual Contract Value (Baseline)

Projected True-Up Cost (Without Optimization)

Projected True-Up Cost (With Reclamation)

Cost Adjustment Scenario Analysis

Scenario

Total Cost

Increase from Baseline

Budget Impact %

Assumptions

A
B
C
D
E
1
 
 
 
 
 
2
 
 
 
 
 
3
 
 
 
 
 
4
 
 
 
 
 
5
 
 
 
 
 

Recommended True-Up Strategy

 

Negotiation leverage points and target discount rate

 

Alternative vendor evaluation summary

Budget Re-Allocation Proposal (Savings Reinvestment)

Cost Category

Original Budget

Adjusted Budget

Variance

Justification

A
B
C
D
E
1
 
 
 
$0.00
 
2
 
 
 
$0.00
 
3
 
 
 
$0.00
 
4
 
 
 
$0.00
 
5
 
 
 
$0.00
 

Does this true-up require board-level financial approval?

 

Board presentation summary and approval timeline

Confidence level in cost projections (1 = Low, 5 = High)

Attach supporting financial models and vendor quotes

Choose a file or drop it here
 

5. Attestation & Sign-off

Final review and approval by technical and procurement leadership. This section ensures both architectural compliance and commercial viability before executing true-up negotiations.

 

Lead IT Architect

Lead IT Architect Name

Lead IT Architect Employee ID

IT Architect Approval: Does the current usage comply with architectural standards and security policies?

 

Architectural non-compliance issues and remediation plan

IT Architect Approval: Is the proposed license allocation technically justified?

 

Technical justification gaps and required adjustments

Enterprise Procurement Director

Enterprise Procurement Director Name

Procurement Director Employee ID

Procurement Director Approval: Have all commercial alternatives been evaluated?

 

Missing alternative evaluations and procurement risk

Procurement Director Approval: Is the budget re-allocation proposal financially viable?

 

Financial viability concerns and required budget modifications

Risk Assessment Scorecard (Rate 1-5 where 5 = Highest Risk)

Vendor lock-in risk

Compliance audit risk

Cost overrun risk

Business disruption risk

Data security risk

IT Architect acknowledges that all technical data provided is accurate to the best of their knowledge

Procurement Director acknowledges that commercial terms have been reviewed and align with enterprise procurement policies

Both parties acknowledge that this audit will be used as formal evidence in vendor negotiations

Lead IT Architect Signature

Enterprise Procurement Director Signature

Attach final audit report PDF and supporting documentation

Choose a file or drop it here
 

Has this audit been reviewed by internal audit or compliance team?

To configure an element, select it on the form.

To add a new question or element, click the Question & Element button in the vertical toolbar on the left.