Databus Logo
Blog Login →
Companies Act 2013 + IT Rule 5 + Section 12A + GST Act 2017 ready

School Inventory Management Software for Indian Schools

CA wants the Fixed Asset Register by Tuesday. You have a 487-line Excel from 2021 and 6 paper registers.

Asset and stock tracking layer for Indian schools. Owns the physical inventory — distinct from Procure-to-Pay (which owns the buying workflow) and from Library / Transport (which own specialized asset class workflows).

Fixed Asset Register with Companies Act 2013 Schedule II + IT Rule 5 parallel depreciation, room-wise barcode mapping, mobile audit scanning, GST Act 2017-compliant POS for uniform sales, moving-average reorder for consumables. Used by 500+ Indian schools.

Sch II
Companies Act 2013
Rule 5
Income Tax depreciation
12A
Trust audit-ready FAR
GST
Act 2017 POS

Four operational gaps in paper-register inventory

The audit-week reality of school inventory tracking.

📑

The October FAR scramble

Section 12A Trust audit due October. Stores Officer compiles the Fixed Asset Register from 6 paper registers, a 2021 Excel sheet, and a year's worth of purchase invoices. Two weeks of work. Six discrepancies the CA flags. One re-audit. Trust exemption status under temporary review.

📦

Silent consumable bleed

A4 paper reams quietly disappear from the supply closet. No formal requisition for half of them. Three months later, the Stores Officer realises consumption is 40% above the prior year — but doesn't know whether teachers actually need more, or someone is taking them home.

🔧

Expired AMC, broken lift

The lift's Annual Maintenance Contract expired 8 months ago — buried in a paper file the Facilities Manager forgot existed. Lift breaks mid-week. No service coverage. Three-day repair quote at non-AMC rates is 4× what the renewal would have cost.

🧮

Two depreciation schedules, manually

Companies Act Schedule II says school computers depreciate over 3 years useful life. Income Tax Rule 5 says 40% per year. The accountant maintains both schedules in Excel. Formulas break when assets are added mid-year. CA flags 11 inconsistencies at audit.

Six regulatory frameworks · One asset tracking layer

The compliance frameworks Indian school assets must satisfy.

School asset management isn't just about knowing what you own. It's about satisfying six different regulatory frameworks that each demand the same information in different formats.

Accounting depreciation

Companies Act 2013 Schedule II

Useful life-based depreciation for accounting and audit. IT equipment 3 years, furniture 10 years, vehicles 8-10 years, buildings 30-60 years. Applies to corporate-trust schools and required for the audited balance sheet.

Tax depreciation

Income Tax Rule 5 + Appendix I

Rate-based depreciation for income tax purposes. Computers 40%, plant & machinery 15%, furniture 10%, buildings 5-10% depending on type. Different from Companies Act rates — schools maintain both parallel computations.

Trust audit requirement

Income Tax Act Section 12A / 12AB

Trust-run schools require audited financials INCLUDING a complete Fixed Asset Register for tax exemption status. FAR shows opening value, additions, deletions, depreciation, closing WDV per asset.

Point of Sale

GST Act 2017

GST-compliant tax invoices required for any taxable supply — uniform sales, textbook sales, sports kit sales. HSN codes per item, applicable GST rate (textbooks 0%, uniforms 5%, stationery 12%), monthly GSTR-1 + GSTR-3B return filing.

CBSE infrastructure

CBSE Affiliation Bye-Laws + Circular 24/2023

Chapter 4 Physical Infrastructure + Chapter 6 Financial Resources require asset records. Circular 24/2023 mandates quarterly water tank purity checks, fire extinguisher service logs, smoke alarm testing logs — all tracked as compliance assets.

Data protection

DPDP Act 2023

When assets are assigned to students (laptops, library books, lab equipment), the student-asset linkage involves child personal data. RBAC + audit trail + verifiable parental consent for any student-linked asset issuance.

References: Companies Act 2013 Schedule II (Ministry of Corporate Affairs). Income Tax Rules Rule 5 + Appendix I depreciation rates (Income Tax Department). Income Tax Act 1961 Sections 12A and 12AB / Income Tax Act 2025 equivalents. GST Act 2017 (CBIC). CBSE Affiliation Bye-Laws Chapters 4 + 6 (cbse.gov.in). CBSE Circular 24/2023 dated 01.09.2023. NCPCR Manual on Safety and Security of Children in Schools 2021. Digital Personal Data Protection Act 2023.

"I am the Stores and Procurement Officer at a CBSE+ICSE two-campus chain in Hyderabad — 2,400 students across the two schools, around 3,200 fixed assets when I last counted in 2023, and easily 40,000 individual transactions a year if you count every paper ream issued to a department head. Before SchoolDeck, my October was a known horror. The CA would email me on the first working day of October asking for the Fixed Asset Register, the depreciation schedule under Companies Act Schedule II, the parallel schedule under Income Tax Rule 5 — and I would lock myself in the stores office for two weeks compiling it from paper registers, the 2021 Excel sheet that everyone was afraid to touch, and the year's purchase invoices. Last year was the worst — the CA flagged 11 inconsistencies between my two depreciation schedules because my Excel formula broke when we added new lab computers in August. We almost lost a quarter on the Section 12A renewal. With SchoolDeck, the FAR is just there. October arrives, I export three PDFs and one Tally XML, send them to the CA, get my evening back. The thing that changed my mind on the platform during the demo, though, was the moving-average reorder calculation — the SchoolDeck person told me explicitly that it wasn't AI, it was trailing 12-week average with seasonal index. After three years of vendors pitching me 'AI inventory prediction' that turned out to be the same thing dressed up, I trusted the honesty more than I would have trusted another AI pitch. The room-wise barcode audit replaced what used to be a 6-day physical verification with about a day and a half. And the AMC alert caught a lift contract that was 47 days from silently lapsing — that one alert paid for the year's subscription."
H
Mr. Hari Prasad Reddy
Stores & Procurement Officer · CBSE + ICSE 2-campus chain, Hyderabad · ~2,400 students · ~3,200 fixed assets · Migrated September 2024

Inventory ≠ Procurement — two distinct layers that schools routinely confuse

The single most common confusion in Indian school operations: treating inventory management and procurement as the same workflow. They aren't. They're two distinct layers that connect through one moment — the Goods Receipt Note (GRN).

The procurement workflow (Indent → Purchase Order → GRN → Invoice → Payment) is owned by /expense-management/ — which integrates with Income Tax Act 2025 Section 393 + Numeric Payment Codes for vendor TDS. The inventory tracking workflow (tagging → location → custodian → depreciation → disposal) is owned by this module. The two connect at the GRN moment — when goods are received, the inventory module takes over.

Schools that conflate the two end up with neither working properly — payments getting made for items that disappear, or items in the storeroom that no procurement record exists for. SchoolDeck separates the layers cleanly: expense-management owns the buying, this module owns the tracking.

Fixed Asset Register — continuously maintained, not reconstructed

Indian schools running as Trusts under Section 12A / 12AB of the Income Tax Act require audited financials including a complete Fixed Asset Register (FAR). The FAR must show:

  • Opening value of each asset at start of financial year
  • Additions during year (with purchase date + vendor + invoice reference)
  • Deletions / disposals (with sale value or write-off authorization)
  • Depreciation computed for the year
  • Closing Written Down Value (WDV)

Most schools attempt to reconstruct the FAR at audit time from paper receipts and Excel sheets. The reconstruction inevitably produces inaccuracies. The CA flags them. Section 12A status comes under temporary review. This is avoidable.

SchoolDeck maintains the FAR continuously. Every asset enters at the moment of GRN from expense-management. Metadata captured at receipt: barcode/QR, purchase date, vendor, invoice reference, purchase value, location, custodian, useful life category. At audit time, the FAR is already current.

Two depreciation schedules in parallel — Companies Act Schedule II + IT Rule 5

Indian schools must compute depreciation under two parallel frameworks because rates and methods differ:

Companies Act 2013 Schedule II — useful life-based

  • IT equipment + computers + laptops: 3 years useful life
  • Office equipment: 5 years
  • Furniture and fittings: 10 years
  • Vehicles: 8-10 years depending on type
  • Buildings: 30-60 years

Income Tax Rule 5 + Appendix I — rate-based

  • Computers: 40% per year
  • Plant and machinery: 15% per year
  • Furniture and fittings: 10% per year
  • Intangible assets: 25% per year
  • Buildings: 5-10% depending on type

Schools maintaining these parallel computations manually in Excel inevitably make errors. Formulas break when new assets are added mid-year. The CA catches inconsistencies at audit. SchoolDeck computes both schedules automatically from the same asset master — Companies Act WDV for the FAR, IT Rule 5 WDV for the Income Tax depreciation schedule. Two reports, one source of truth.

Consumable stock + moving-average reorder — honest framing

For consumables (A4 paper reams, printer cartridges, lab chemicals, sports equipment), the system tracks inflow + outflow against threshold quantities.

The reorder calculation is statistical, not AI:

  • Tracks weekly consumption over the trailing 12 weeks
  • Computes trailing average plus safety buffer = reorder threshold
  • Applies seasonal index for predictable spikes: exam-period spike for answer sheets (multiplier kicks in 4 weeks before each assessment from examinations), monsoon spike for raincoats and umbrellas (kicks in by June 1), winter spike for woolens
  • When on-hand stock crosses threshold, indent request auto-suggested to Stores Officer who reviews and submits to expense-management for formal P2P workflow

Honest framing: this is moving-average reorder-point calculation with seasonal adjustment — not machine learning. Statistically reliable, defensible to the auditor, interpretable. Schools that have been burned by AI overclaim from vendors appreciate the transparency.

Room-wise barcode audit — 6 days to 1.5 days

Annual physical verification — confirming every asset on the FAR physically exists where the register says it is — is the single most stressful audit task.

How the room-wise audit works:

  1. Auditor (internal or external CA's team) opens the Audit App on a mobile/tablet
  2. Selects "Classroom 8-A" from the room hierarchy (Block → Floor → Room)
  3. App displays expected asset list for that room: Projector PRJ-1042, Smart Board SB-204, 40 student desks, 1 teacher table, 4 fans, 2 tube lights, fire extinguisher FE-89 (last serviced 14 Sept 2025), smoke alarm SA-12
  4. Auditor scans each asset's barcode with the phone camera
  5. Green tick on match; "Discrepancy" flag on missing items
  6. Discrepancies tracked for follow-up — typically because an item was moved without updating the system

The 6-classroom block audit that took 2 full days of manual checklist work now takes around 90 minutes. Whole-school annual physical verification — typically 6 days of work — completes in about 1.5 days.

GST Act 2017-compliant Point of Sale — for uniforms, textbooks, sports kits

Many Indian schools operate internal stores selling uniforms, textbooks, sports kits, and stationery directly to parents. Without integrated POS, these stores typically lose 8-15% of inventory annually to "informal" issuance without proper records.

How the POS module works:

  • Administrators bundle items (e.g., "Class 5 Starter Kit" = Maths textbook + English textbook + Hindi textbook + summer uniform shirt + summer uniform trousers + 2 notebooks)
  • Parent approaches counter; clerk selects the bundle
  • System deducts components from master stock register
  • System generates GST Act 2017-compliant tax invoice: HSN codes per item, applicable GST rate (textbooks typically 0%, uniforms 5%, stationery 12%)
  • Payment routed to fees for ledger posting (parent's wallet, UPI, card, or cash)
  • Sale transaction logged for year-end GST return (GSTR-1 + GSTR-3B)

AMC + warranty expiration alerts

During asset entry (at GRN time or bulk upload), warranty expiration date and AMC (Annual Maintenance Contract) details are captured. System monitors the calendar — 30 days before AMC expiration or warranty expiration, automated alerts go to the Facilities Manager and Stores Officer.

For warranties: alert flags items where a repair could be claimed under warranty if processed within the remaining window. For AMCs: alert prevents service coverage lapse on critical infrastructure like water purification plants, lift systems, AC units.

Schools typically have 40-80 active AMCs across IT + facilities + equipment. Manual tracking in Excel means at least 3-4 expire silently each year — costing renewal-discount opportunities and exposing critical infrastructure to uncovered service gaps.

CBSE Circular 24/2023 + Affiliation Bye-Laws asset compliance

CBSE Circular 24/2023 (for residential schools and general school safety) mandates specific compliance asset tracking. The inventory module operationalizes these requirements:

  • Quarterly water tank purity check records: every water tank tagged as an asset; service intervals tracked; results logged for inspection
  • Fire extinguisher register: every fire extinguisher tagged with serial; service date tracked; refill schedule monitored; expiry alerts
  • Smoke alarm testing logs: every smoke alarm tagged; monthly testing scheduled and recorded
  • Lifts and elevators: statutory inspection certificates tracked; service history maintained
  • Generator + UPS service records: critical infrastructure logs per CBSE Affiliation Bye-Laws Chapter 4 Physical Infrastructure

During CBSE inspection or NCPCR safety audit, the school produces the complete compliance log from the inventory module without scrambling for paper records.

Cross-cluster integration — boundaries with other modules

The inventory module connects with — but doesn't duplicate — the following modules:

  • Expense Management — owns full Procure-to-Pay (Indent → PO → GRN → Payment) with Income Tax Act 2025 TDS. Inventory CONSUMES the GRN output. No duplicate data entry.
  • Finance Management — Trust executive dashboard surfaces FAR closing value as part of consolidated balance sheet. Inventory provides the asset numbers; finance-management contextualizes them at Trust level.
  • Fees — receives damage fines automatically when a student breaks lab equipment. Inventory triggers the event; fees manages the ledger.
  • Library Management — owns specialized book inventory subset (Dewey classification, OPAC catalogue, borrowing workflow). Inventory provides the master framework; library extends it.
  • Transport — owns vehicle fleet subset (fuel logs, route assignment, GPS). Vehicles appear in the FAR for depreciation; transport owns the operational workflow.
  • Hostel Management — owns medical record workflow (dispensed medication log per student); inventory owns medical STOCK side (paracetamol reorder when low). Two adjacent, non-overlapping workflows.
  • Audit Logs — every stock movement (issuance, transfer, disposal) captured in the immutable audit trail.

Excel + paper registers vs SchoolDeck Inventory Management

Capability Excel + paper registers SchoolDeck Inventory ERP
FAR availability at audit time 2 weeks of reconstruction work Already current — export in 30 min
Companies Act + IT Rule 5 Manual Excel — formulas break Both auto-computed in parallel
Physical verification audit 6 days manual checklist 1.5 days mobile barcode scan
Consumable reorder Reactive when shelf empty Moving-avg threshold + seasonal index
AMC + warranty tracking 3-4 silent lapses per year 30-day advance alerts
POS for uniform sales Receipt book chaos GST-compliant invoice + stock deduction
Room-wise asset visibility Multiple Excel tabs, often inaccurate Block→Floor→Room→Custodian hierarchy
CBSE safety asset logs Paper files, often missing Water + fire + smoke alarms logged
Damage fine to student Manual paper form + accountant entry Auto-routed to student fee ledger
Section 12A audit pack Compiled by accountant over 2 weeks FAR + IT depreciation + audit trail in 30 min
Stock movement audit trail No record beyond paper register Immutable log via /audit-logs/

Frequently asked questions

What Stores Officers and CAs ask first.

What is school inventory management software and how is it different from procurement software?

+

Two distinct layers. Procurement (Procure-to-Pay) is the BUYING workflow — Indent → PO → GRN → Invoice → Payment. Owned by /expense-management/ which integrates with Income Tax Act 2025 Section 393 + Numeric Payment Codes for vendor TDS. Inventory Management is the TRACKING layer — once goods received (GRN moment), inventory takes over: tagging with barcode, assigning room and custodian, computing depreciation, tracking warranties, managing disposal, generating Fixed Asset Register for Section 12A Trust audit. Schools conflating the two end up with neither working — payments made for items that disappear, items in storeroom with no procurement record. SchoolDeck separates cleanly.

How does the FAR support Section 12A Trust audit requirements?

+

Indian schools running as Trusts under Section 12A / 12AB of the Income Tax Act require audited financials including a complete Fixed Asset Register. FAR must show: opening value per asset, additions during year (with purchase date + vendor + invoice ref), deletions/disposals (with sale value or write-off authorization), depreciation for year, closing WDV. Most schools attempt reconstruction at audit time from paper receipts + Excel — leading to inaccuracies that compromise tax exemption. SchoolDeck maintains FAR continuously — every asset enters at GRN moment from /expense-management/, metadata captured at receipt. At audit time, FAR is already current. CA imports directly into Tally for statutory audit.

How does depreciation work — Companies Act Schedule II vs Income Tax Rule 5?

+

Two parallel computations. Companies Act 2013 Schedule II (accounting + audit): IT 3yr useful life, furniture 10yr, vehicles 8-10yr, buildings 30-60yr. Income Tax Rule 5 + Appendix I (income tax only): computers 40% p.a., plant 15%, furniture 10%, intangibles 25%, buildings 5-10%. Schools maintaining both manually in Excel inevitably make errors that CA catches at audit. SchoolDeck computes both automatically based on asset category — Companies Act WDV for FAR, IT Rule 5 WDV for IT depreciation schedule. Two reports, generated from the same asset master, ready for CA.

Can we track room-wise or department-wise inventory?

+

Yes — foundation of the audit workflow. Each asset assigned hierarchical location: Block → Floor → Room → Custodian (specific staff member). Projector PRJ-1042 lives in Block A, Floor 2, Classroom 8-A, custodian Mrs. Ramamurthy. When auditor walks Classroom 8-A for physical verification, Audit App displays expected asset list — 40 student desks, 1 teacher table, 1 Smart Board, 1 projector, 4 fans, 2 tube lights, fire extinguisher (with last service date), smoke alarm. Auditor scans each barcode with mobile camera. Missing assets flagged "Discrepancy" for follow-up — typically because moved without updating system. 6-classroom block audit that took 2 full days manually now takes 90 minutes.

Is the reorder calculation actually AI?

+

Honest framing: no. The reorder point is computed using moving-average of trailing consumption velocity with seasonal adjustment — not machine learning. Tracks weekly consumption over trailing 12 weeks; trailing average plus safety buffer = reorder threshold. Seasonal index for predictable spikes — exam-period spike for answer sheets (multiplier kicks in 4 weeks before assessment from /examinations/), monsoon spike for raincoats (June 1), winter spike for woolens. When on-hand crosses threshold, indent request auto-suggested to Stores Officer who submits to /expense-management/ for formal P2P. Statistically reliable, defensible to auditor, entirely interpretable — not a black-box AI model.

Can we sell uniform sets and textbooks to parents through the system?

+

Yes — GST Act 2017 compliant POS module. Administrators bundle items ("Class 5 Starter Kit" = textbooks + uniforms + notebooks). Clerk selects bundle at counter; system deducts components from master stock; generates GST-compliant tax invoice (HSN codes per item, applicable rate — textbooks 0%, uniforms 5%, stationery 12%); payment routed to /fees/ for ledger posting; transaction logged for year-end GSTR-1 + GSTR-3B. Schools running busy uniform stores at session start (typically April-May) find this eliminates the receipt-book chaos that historically meant the school had no idea by end-May which inventory was sold vs stolen vs informally given to staff.

How do we transition our current physical inventory into the system?

+

Bulk upload via CSV — standard onboarding path. Schools provide current asset list (from paper registers + Excel + year's purchase invoices) in CSV template: asset name, category, purchase date, purchase value, location, custodian. Implementation team helps Stores Officer compile from existing records. Upon upload: (a) ingests all assets into master register; (b) auto-generates unique barcode per asset; (c) prints barcode stickers for physical tagging; (d) computes opening WDV per Companies Act Schedule II + IT Rule 5 retroactively. Stores Officer walks school over 2-3 days with printed barcode roll, tagging each asset. By end of week 1, entire school inventory digitized. First year's audit becomes the comparison baseline.

How does the AMC and warranty expiration alert work?

+

At asset entry (GRN time or bulk upload), warranty expiration date + AMC details captured. System monitors calendar — 30 days before AMC or warranty expiration, automated alerts to Facilities Manager and Stores Officer. For warranties: alert flags items where repair could be claimed within remaining window. For AMCs: alert prevents service coverage lapse on critical infrastructure (water purification plants, lift systems, AC units). Schools typically have 40-80 active AMCs across IT + facilities + equipment. Manual Excel tracking means at least 3-4 expire silently each year — costing renewal-discount opportunities + exposing critical infrastructure to uncovered service gaps.

Does it track CBSE Circular 24/2023 mandatory infrastructure compliance?

+

Yes — Circular 24/2023 mandates specific asset compliance tracking. Quarterly water tank purity checks (every tank tagged, service intervals tracked, results logged). Fire extinguisher register (every extinguisher tagged with serial, service date, refill schedule). Smoke alarm testing logs (every alarm tagged, monthly testing recorded). Lifts and elevators (statutory inspection certificates tracked, service history maintained). Generator + UPS service records per CBSE Affiliation Bye-Laws Chapter 4 Physical Infrastructure. During CBSE inspection or NCPCR safety audit, school produces complete compliance log from inventory module without scrambling for paper records.

How does this integrate with the rest of SchoolDeck?

+

Native cluster integration. /expense-management/ owns Procure-to-Pay; inventory CONSUMES GRN output. /finance-management/ Trust dashboard surfaces FAR closing value. /fees/ receives damage fines automatically. /library-management/ owns book inventory subset. /transport/ owns vehicle fleet subset (vehicles still in FAR for depreciation). /hostel-management/ owns medical record workflow; inventory owns medical stock. /audit-logs/ captures every stock movement in immutable trail.

What does deployment and pricing look like?

+

Deployment: bundled within standard SchoolDeck rollout (7-10 days). Module-specific adds 5-7 days for asset master compilation. Includes: CSV template upload of current asset list; barcode sticker generation + printing (typically 1,500-3,500 stickers for mid-size school); physical tagging walk with Stores Officer (2-3 days); Companies Act Schedule II + IT Rule 5 depreciation category mapping; opening WDV computation for financial year cutover; RBAC setup per Stores Officer / Facilities Manager / Principal / Trust Treasurer / external CA (read-only); first audit walkthrough with school's existing CA to validate FAR format. Pricing: bundled within standard SchoolDeck plan at ₹30 per student per month. No separate per-asset charge. No per-transaction charge. Barcode sticker printing covered as one-time setup; ongoing sticker reorders at cost.

Connected modules

Inventory integrates with — not duplicates — these modules.

For Indian Stores Officers, Facilities Managers & Trust CAs

Walk into your October audit with the FAR already done. Not the 487-line Excel from 2021.

Companies Act 2013 Schedule II + IT Rule 5 parallel depreciation. Room-wise barcode audit. GST Act 2017 POS. AMC + warranty alerts. CBSE 24/2023 safety asset compliance. Section 12A audit pack in 30 minutes.

From ₹30/student/month · 500+ Indian schools · Live in 7-10 days