Live workbook snapshot

Period

Tracked records▤

—Across the register

Purchase requestsPR

—Requests submitted

Invoice value captured₹

—From vendor invoices

Renewals tracked↻

—Renewal-tagged records

Submission activity

Monthly volume by document type

PRInvoice

Workflow position

Derived from populated tracking fields

0records

Vendor aging report

Recorded vendor invoice values grouped by invoice age

0

Vendor	0–30 days	31–60 days	61–90 days	90+ days	Total value	Oldest

Vendor-wise monthly expenses

Top vendors by recorded invoice value

0

Recent submissions

Latest activity in the selected register year

Record	Submitted	Owner	Value	Position

Attention queue

Missing fields worth resolving

0

License & renewal date tracker

Upcoming and overdue AMC, subscription and renewal dates in one report

0

From date To date Status

License / service	Vendor	Department	Start date	Expiry / renewal date	Date position	Purchase value	Status

Operational register

Purchase requests & invoices

Search, filter, inspect and update the selected tracking year.

⌕

0 recordsShowing the complete register

Record	Submitted	Type	Product name	Description	Department	Employee / received by	Vendor	Value	Position

Lifecycle intelligence

Renewal history & purchase value

AMC, subscription and renewal history for the selected register year.

Renewal purchases0

↻

Captured purchase value—

₹

Due within 120 days0

!

Expired records0

×

0 renewalsGrouped by register year

Supplier intelligence

Vendor directory

Consolidated activity and invoice value from the register.

Vendor	Mail ID	Phone	Records	Invoice value	Last activity	Status

Inventory management

Stock Control

12 managed inventory categories across ITCS, DC and AV Team with availability, allocation and replenishment control.

SchoolDepartmentStaff type

Total stock▦

0Units recorded

In use↗

0Allocated units

Not in use✓

0Available units

Low stock alerts!

0Reorder attention required

Inventory distribution

Total and assigned units by stock category

TotalAssigned

Stock position

Current availability and reorder exposure

0units

Laptop aging distribution

Asset age calculated from the recorded purchase date

0 laptops

Laptop brand-wise distribution

Laptop count grouped by manufacturer brand

Group by

Employee-wise stock report

Assets currently allocated to employees and custodians

0

Inventory register

Search and monitor every stock item across the three operational teams

0

Team / Category	Item / Asset	Total	Assigned	Available	Location	Current employee / custodian	Previous issue employee	Warranty / Expiry	Status	Actions

Workforce directory

Employees

Maintain the approved employee master used for stock allocation and reporting.

Employee directory

Employee details can be added individually or imported from Excel.

0 employees

Employee	Employee ID	School	Department	Designation	Grade	Staff type	Mail ID	Phone	Status

Campus infrastructure

Infrastructure

Maintain the SRM University location hierarchy for buildings, floors, rooms and future asset placement.

SRM University

Buildings, floors and rooms

0 locations

Enterprise asset governance

Asset Operations Centre

Lifecycle, employee custody, approvals, reconciliation, budgets, documents and administration in one controlled workspace.

Automated alerts

Approvals, warranty expiry, low stock, renewals and synchronization

0

Data-quality controls

Duplicates, missing identifiers and invalid dates

0

Recent audit trail

Accountable history of operational changes

Date & time	Action	Entity	Reference	Details

Record asset lifecycle event

Procurement, allocation, transfer, return, reissue, repair or disposal

Stock movement register

Complete inward, issue, return and transfer history

Date	Asset	Event	Qty	Employee	Department	From → To	Reference

Employee asset profiles

Current custody and complete equipment history

⌕

Create approval workflow

Route decisions through ITKM, Purchase and Finance

Approval queue

Pending decisions and escalation status

Budget plan

Planned versus actual expenditure

Budget performance

Year, department and product-level variance

Year	Department	Product	Planned	Actual	Variance	Utilisation

Vendor performance

Expenses, delivery time, renewals, payment delays and rating

Vendor	Expense	Purchases	Renewals	Avg. delivery	Payment delays	Rating

Physical audit / barcode scan

Compare the observed asset against ERP and Google Sheets

Reconciliation register

Physical verification results and exceptions

Audited	Asset	Barcode	Result	Location	Auditor

Asset document upload

Quotation, PO, invoice, GRN, warranty and disposal records

Document repository

Controlled supporting records by asset

Role-based security

Super Admin, Purchase, Stock Manager, Approver and Viewer

Scheduled reports

Monthly purchase, stock and expiry distribution

Backup and recovery

Create, download or safely restore a database snapshot. A safety backup is created before every restore.