top of page

AppSheet Internal Operations & Financial Management System

My Role

Business Analyst / App Designer

I was responsible for:

  • Analyzing the existing business processes

  • Identifying key operational and financial data points

  • Designing system logic and data structure

  • Translating business rules into AppSheet workflows

  • Iterating based on user feedback during early usage

Tools & Stack

  • AppSheet (No-Code Application Platform)

  • Google Drive (Data Storage)

  • Google Sheets (Data Structure & Logic)

Key Features

  • Sales Order Recording
    Structured input for sales orders with consistent data capture

  • Automated Pricing Logic
    Pricing calculated automatically based on product specifications

  • Production Tracking
    Monitoring production status from order to completion

  • Shipment Documentation
    Simple tracking of shipment-related information

  • Return & Refund Process
    Clear flow for handling returns and refunds

  • Profit & Loss Summary
    Basic financial overview to support decision-making

Outcome & Impact

  • The app is actively used in daily operations

  • Reduced manual data handling and duplication

  • Improved visibility across operational processes

  • Enabled basic financial tracking without complex systems

Most importantly, the system was designed to match how the team actually works, making adoption smoother.

bottom of page