Tea & Coffee Supply Manager — Excel to Web App Conversion

By Subham Ghadge  |  Subu Data Labs  |  Office Automation & Web Tools  |  July 2026

In almost every corporate office, pantry supplies like tea and coffee machines require continuous monthly tracking. Administrative staff need to monitor milk carton usage, coffee bean orders, stirrer counts, and tea bag consumption, then cross-charge these costs accurately to participating companies or internal departments.

Traditionally, this tracking happens inside a shared Excel spreadsheet. While Excel works initially, managing multiple users, concurrent access, user permissions, and month-end vendor reports over email becomes slow and prone to formatting errors.

To solve this, I converted our master Excel tracking workbook into a standalone, browser-based web application. It runs directly in any modern browser without requiring a backend server, database installation, or monthly SaaS subscription. You simply open the HTML file in Chrome or Edge, log in, and manage pantry inventory effortlessly.

The Operational Challenge: Moving Beyond Shared Spreadsheets

In shared commercial office spaces or multi-tenant facilities, several companies often share a common pantry space supplied by multiple beverage vendors. At the end of every month, admin teams need to verify how much inventory each company consumed, confirm what was ordered, calculate closing balances, and audit vendor bills.

Relying solely on a shared spreadsheet file introduces several operational hurdles:

• Manual Email Sharing: Staff have to email updated spreadsheet copies back and forth after every entry.
• Single-User Locks: Only one team member can edit the workbook at a time without causing file conflicts.
• Lack of Access Controls: Anyone with access to the file can edit master price rates or background formulas accidentally.
• No Visual Dashboard: Tracking trends requires building custom Pivot Charts manually every month.
• Unformatted Reports: Printing clean, A4-ready monthly billing summaries requires manual page setup every single time.

By converting the workbook into a dedicated web app, we achieved a much smoother workflow:

• Runs instantly in any browser (Chrome, Edge, Firefox) without internet or server hosting.
• Includes a secure login screen with username and password authorization.
• Supports role-based permissions (Admins have full setup access; Staff can view or enter daily consumption).
• Features a clean Executive Dashboard with live KPI summary cards and 4-month trend charts.
• Provides a 31-day daily entry grid for quick inventory logging across all tracked items.
• Enables one-click CSV data exports to back up or open data in Excel anytime.
• Generates print-ready A4 landscape reports formatted for physical billing file records.
• Logs user activity automatically to track logins, edits, and exports with exact timestamps.

Understanding the Master Excel Architecture

The web application was engineered by analyzing every data table, formula, and logic structure from the original macro-enabled workbook (Tea & Coffee Supporting.xlsm). The original file consists of 5 primary sheets:

The system tracks 3 corporate entities (Office Space Con., OWT Pvt Ltd, and Digital Advice LLP) supplied by 2 primary vendors (Sumant Technotrade and Veebha Beverages).

Here is the full 12-item master catalog along with contracted rates:

• Coffee Beans — ₹700/Kg
• Coffee Beans Value Blend — ₹720/Kg
• Tea Premix 650ML — ₹160 each
• Coffee Premix 650ML — ₹160 each
• Sugar Sachet White — ₹120/Kg
• Milk 1Ltr Good Life — ₹69.52 each
• Stirrer — ₹0.26/Nos
• Flavor Tea Bags Plain — ₹200/box
• Flavor Tea Bags Cardamom — ₹220/box
• Flavor Tea Bags Ginger — ₹210/box
• Flavor Tea Bags Masala — ₹215/box
• Lemon Green Tea Bags — ₹4.50/Nos

Technical Mapping: Translating Excel Features to Web Code

Converting a complex Excel workbook into a web application requires mapping each spreadsheet component to its corresponding web technology:

Application Interface & Visual Tour

1. Authorization & Login Interface

Secure login screen. Authenticates users and applies role-based access permissions based on assigned credentials.

2. Daily Consumption Entry Grid

31-day entry grid. Select month, company, and vendor to log daily usage. Totals update automatically in real time.

3. Master Setup & User Permission Panel

Admin Control Panel. Manage items, vendors, companies, and configure granular access permissions for each user account.

4. Data Synchronization & Activity Audit Log

Sync & Audit Panel. Export data to CSV, import external records, and review logged user activity with exact timestamps.

Core Application Features

Executive Dashboard

• 5 KPI Summary Cards: Monitors Opening Value, Order Value, Usage Value, Closing Value, and Total Items Tracked dynamically.
• Multi-Month Trend Chart: Renders a 4-month comparison of order quantities versus actual usage without third-party chart libraries.
• Interactive Filtering: Filter metrics by Company, Vendor, or Month to analyze specific spending streams instantly.
• A4 Landscape Printing: Includes custom CSS print styling for clean physical paper reporting.

Consumption Register

• Loads 31-day daily usage tables automatically upon selecting month, company, and vendor filters.
• Restricts order entry fields to authorized Admin accounts to prevent unauthorized inventory modifications.
• Provides instant visual confirmation toasts when entries are saved to local memory.
• Exports active monthly registers to CSV format with a single click.

Master Setup (Admin Level)

• Vendor Management: Add, edit, or remove approved beverage suppliers.
• Item Master: Configure item descriptions, units of measurement, brand names, HSN codes, unit rates, and vendor assignments.
• Company Profiles: Manage the list of participating corporate entities or office departments.
• User Permissions: Create accounts and toggle individual access rights for each user.

Default Access Credentials

Operational Use Cases

Software Stack & Architecture

The web application is engineered using clean, native web standards to ensure zero external software dependencies:

• HTML5: Defines clean semantic layout and module structures.
• CSS3: Powers responsive grid layouts, modern dark theme elements, and print stylesheets.
• Vanilla JavaScript (ES6+): Handles data modeling, calculation algorithms, dynamic filtering, and UI rendering.
• Browser localStorage API: Serves as the offline database, persisting all records directly within the browser.
• No Server or Framework Dependencies: 100% self-contained in a single, lightweight .html file.

Quick Setup Guide

Importing Existing Excel Data

To migrate past records from your Excel tracker into the web app, use the CSV import tool in the Sync panel. The importer accepts data formatted in the following CSV structure:

month,company,vendor,item,order,day1,day2,day3,...,day31
Jul-2024,Office Space Con.,Veebha Beverages,Tea premix,20,0,1,0,0,1,0,1,...

Paste your formatted CSV rows into the import text area within the Sync panel and click Import to load historical data into browser memory instantly.

Key Platform Advantages

• ✅ 100% Free & Offline: No hosting costs, server fees, or active internet connection required.
• ✅ Role-Based Access: Individual logins for Admin, Manager, and Staff user roles.
• ✅ Automated Audit Logs: Tracks user actions, logins, data edits, and exports with exact timestamps.
• ✅ Print-Ready A4 Reports: Optimized CSS print styling for physical document filing.
• ✅ CSV Data Mobility: Export complete records to CSV anytime to analyze data inside Excel.
• ✅ Zero Installation: Runs on standard corporate laptops without requiring administrative software installation rights.

Download Files & Resources