Stone Association Management System
Custom ERP for Tandur Quarry & Stone Merchant Associations

Overview

TSMWA (Tandur Mandal Quarry Owners Welfare Association & Tandur Stone Merchants Welfare Association) needed a centralised digital system to manage day-to-day association operations.

We designed and built a custom internal management system that replaced fragmented manual processes with a structured, role-based, web-based ERP.

The goal was simple: bring all operational data into one controlled, accountable system.


The Problem

The associations were handling multiple operational layers manually:

  • Membership approvals and fee tracking

  • Vehicle registrations and trip records

  • GST-compliant invoicing

  • Labour records

  • Lease ownership tracking

  • Meeting scheduling and communication

Most of this was managed through spreadsheets, physical records, and WhatsApp communication.

There was no unified dashboard. No real-time analytics. No automated reminders.

They needed structure without complexity.


What We Built

Membership Management

  • Add, edit, approve members

  • Track membership fees, dues, and payment history

  • Automated WhatsApp reminders for pending fees

  • Central member ledger with historical tracking

This gave the association complete visibility into financial compliance and active member status.


Vehicle Management

  • Register and manage vehicles

  • Track payments and trip-related records

  • Export reports for operational analysis

The vehicle module allowed the association to monitor logistics-related activity in a structured way.


Finance & GST

  • Invoice generation directly from the portal

  • GST and e-invoicing compliance

  • Dashboard view of dues, approvals, and transactions

The system ensured financial transparency while maintaining regulatory compliance.


Labour Records

  • Maintain a digital registry of active labour

  • Filter and update records

  • Export logs when required

This replaced physical labour tracking and simplified reporting.


Lease Management (Quarry Owners)

  • Manage lease allotments and ownership records

  • Track lease duration and renewal cycles

  • Maintain full lease history

This created accountability and long-term documentation for quarry ownership structures.


Meetings & Communication

  • Schedule meetings

  • Send WhatsApp notifications to members

  • Maintain history of past meetings

Communication became system-driven instead of ad hoc.


Central Dashboard

We built a unified admin dashboard that provides:

  • Overview of members, vehicles, finances, labour, and approvals

  • Notifications for expiring licenses and pending invoices

  • Real-time analytics for decision-making

Leadership can now see the operational health of the association at a glance.


Technical Execution

  • Custom backend system with structured relational data models

  • Role-based access control

  • Export-ready reporting architecture

  • WhatsApp automation integration

  • GST-compliant invoice generation logic

The system was designed to be scalable for future expansion while remaining simple enough for non-technical administrative staff.


Impact

  • Eliminated dependency on spreadsheets and manual ledgers

  • Automated dues reminders

  • Improved financial tracking and compliance

  • Centralised all association operations in one interface

  • Created accountability across members, vehicles, labour, and leases

TSMWA now operates on a structured digital backbone instead of scattered manual processes.


Our Role

  • Product architecture & operational modelling

  • UX for administrative users

  • Backend system design

  • Financial and GST workflow implementation

  • Automation and notification logic

Catergory

Membership 路 Finance & GST 路 Vehicle Tracking 路 Labour Records 路 Lease Management 路 Admin Dashboard

Tech Stack

  • Node.js
  • Express.js
  • Prisma
  • MySQL
  • Redis
  • Next.js
  • Reacts

Leave a Reply

Loveyatri – Multi Property Booking Platform

Loveyatri – Multi Property Booking Platform

ImageFootage – Digital Asset E-Commerce & Management Platform

ImageFootage – Digital Asset E-Commerce & Management Platform