SHS Admin Dashboard
A admin dashboard for Sahyadri Hospitality Services for creating Invoices, generating reports and managing packages.
Purpose
An internal admin dashboard that centralizes every financial and operational workflow for a multi-unit hospitality business into one platform. Staff log in, manage daily operations, and generate reports without switching between spreadsheets and paper registers.
Problem
The business operated across multiple units with no unified system. Purchase bills, sales invoices, supplier payments, staff salaries, and daily cash records were tracked in separate spreadsheets and paper registers. Monthly financial summaries required days of manual reconciliation. Errors were frequent, and real-time visibility into profit margins was non-existent.
Solution
A role-based web dashboard that replaces all manual record-keeping with structured, queryable data.
- Billing and invoicing with automated calculations across packages, products, and programs
- Purchase management with supplier tracking, bill entry, and payment history
- Sales module covering invoices, daily cash collection, and pending payment tracking
- Staff payroll for monthly salaries, daily wages, and government deductions (PF/Tax)
- Financial reports including monthly P&L summaries, unit-wise breakdowns, and vendor-wise analysis
- Role-based access control so each user only sees what they are authorized to access
- Data export in PDF, Excel, CSV, and TXT formats with print-ready layouts
- Automated database backups to Google Drive on a configurable schedule
Process
- Audited existing workflows across all business units to identify every data entry point
- Designed the database schema around units, vendors, clients, and billing entries
- Built the dashboard module by module, starting with inventory and billing, then expanding to sales, purchases, payroll, and reporting
- Implemented role-based permissions at the middleware level to enforce access control on every route
- Added export APIs and PDF generation for accountant-ready financial documents
- Deployed on Vercel with Supabase as the backend
Tech Stack
| Layer | Technology |
|---|---|
| Framework | Next.js 15 (App Router, Turbopack) |
| Language | TypeScript |
| Database | Supabase (PostgreSQL) |
| Auth | Supabase Auth with SSR helpers |
| UI | Tailwind CSS, Radix UI, Recharts |
| Tables | AG Grid Enterprise, TanStack Table |
| PDF/Export | PDFKit, SheetJS (xlsx), PapaParse |
| Deployment | Vercel |
| Backups | Google Drive API |
Impact
- Replaced 5+ separate spreadsheets and manual registers with a single dashboard
- Monthly financial reconciliation reduced from 2-3 days to under 10 minutes
- Real-time profit/loss visibility across all business units and vendors
- Role-based access enforced for 4+ user roles, eliminating unauthorized data exposure
- Export-ready reports used directly by accountants without reformatting
- Automated daily backups eliminated the risk of data loss