Back to projects

Apps Script Web App

Refund Management System

A comprehensive multi-portal refund management system with role-based access, analytics dashboard, and automated workflows.

Refund Management System
Click to view all 23 screens

The Problem

The refund process was manual, error-prone, and scattered across multiple teams with no visibility into status or bottlenecks. Teams spent hours on data entry and follow-ups.

The Solution

  • Built a multi-portal web app with role-based access for different teams (Finance, BI, Product, Approvers)
  • Created an analytics dashboard with real-time refund metrics and status tracking
  • Implemented automated workflow routing based on refund type and amount
  • Added a structured refund request form with validation and auto-calculations
  • Integrated with Google Sheets for data storage and reporting

Tech Stack

Google Apps ScriptHTML/CSS/JavaScriptGoogle SheetsWeb App Deployment

Results

Cut refund processing time by 60% with automated workflows

Screenshots

Refund Management System - Screen 1
Click to expand
1 / 23

Need something similar?

Let's discuss how I can help automate your workflows.