Supplier Transparency
Clarifies an important business outcome theme.
All projects
01 / Professional Project — Internal Business Application
Vendor Bill Tracking System
From Material Receipt to Payment - Giving Suppliers Better Visibility
A supplier-facing visibility system that helps translate bill and payment follow-up into a structured, searchable digital channel.
Vendor VisibilityStatus TrackingExpected ProgressPayment TrackingPayment DetailsPayment AdviceGoogle Apps ScriptJavaScriptGoogle SheetsHTML/CSS
01
Overview
A supplier-facing visibility system that helps translate bill and payment follow-up into a structured, searchable digital channel.
A supplier-facing digital platform providing visibility from material receipt and inspection through bill processing and payment, including detailed payment information and downloadable records.
02
Business Problem
Suppliers frequently need visibility across receipt, inspection, bill processing and payment release.
- material receipt
- inspection
- bill processing
- current processing stage
- expected progress
- payment release
- payment details
03
Objective
Create a supplier-facing digital channel providing convenient visibility into bill and payment status while reducing repetitive manual communication.
04
Process Before Digitalization
- 01
Supplier
- 02
Phone / Email Follow-up
- 03
Internal Status Check
- 04
Manual Response
- 05
Further Follow-up
Operational friction
- repeated communication
- limited self-service visibility
- fragmented status information
- administrative effort
05
Solution
A web-based tracking system allowing suppliers to search authorized bill information using transaction details.
- goods delivered date
- current status
- status update date
- expected progress
- payment date
- detailed payment information
- payment breakup
- downloadable records
06
Workflow
- 01
Vendor Login
- 02
Goods Received
- 03
Inspection / Processing
- 04
Current Status
- 05
Expected Progress
- 06
Payment Released
- 07
Payment Details
- 08
Payment Advice / Vendor Ledger
07
Key Capabilities
Tracking & Visibility
- Vendor self-service search
- Goods-received visibility
- Inspection/process status
- Current-status display
- Expected-progress communication
- Payment-release status
Payment Information
- Detailed payment information
- Deduction visibility
- Net-payment information
- Payment reference visibility
Documents & Records
- PDF download
- Excel download
- Vendor ledger
Automation & Communication
- Automated communication
08
Application Screens
Selected application screens illustrating the end-to-end workflow. Production-sensitive information has been excluded from the portfolio.
Entry & Search
System Introduction
StandardIntroduces the three-step supplier journey: enter details, track status and access records when available.
Vendor Login / Bill Search
MobileProvides the supplier-facing entry point for searching authorized bill information.
Processing Progression
Live Processing Status - Under Inspection
MobileExample Stage: Goods Received - Under Inspection
Shows latest processing status after goods receipt while inspection is still in progress.
Payment Released
MobileShows the same tracking experience once payment visibility becomes available.
Payment Detail
Featured screen placeholder
Detailed Payment Information
A sanitized replacement is required before this payment-details screen can be rendered publicly.
Confidential fields withheld
A sanitized replacement is required before this payment-details screen can be rendered publicly.
Detailed Payment Information
FeaturedReserved for payment components, deductions, net payment details and downloadable records after processing.
Screens and transaction information shown on this portfolio have been sanitized for confidentiality.
09
System Architecture
Conceptual Application Architecture
A lightweight business application flow connecting supplier search, workflow logic, structured records and document outputs.
Layer 1
Supplier / Authorized User
Layer 2
HTML/CSS/JavaScript Interface
Layer 3
Google Apps Script Workflow Logic
Layer 4
Google Sheets Structured Records
Layer 5
Gmail / Document Downloads
10
Business Value
Reduced Follow-Up
Reduces repetitive coordination effort.
Better Supplier Experience
Improves clarity for business users.
Consistent Communication
Improves clarity for business users.
Digital Records
Keeps information structured for later review.
Payment Visibility
Makes process status easier to understand.
11
Design Challenges
- Presenting useful status information without exposing confidential transaction data.
- Designing supplier-facing search that remains practical and controlled.
- Keeping payment visibility understandable for business users.
12
Development Approach
Domain-Led, AI-Assisted Application Development
The system was shaped from supplier communication patterns, bill-processing stages and payment-visibility needs before implementation decisions were made.
13
Lessons Learned
- Self-service visibility is most useful when it follows the real operational language users already understand.
- Status design needs exception handling, not just simple success/failure labels.
- Downloadable records require careful sanitization before portfolio use.
14
Future Evolution
Potential Evolution
- Stronger authentication and access control.
- A more scalable cloud data layer such as Firestore.
- Richer supplier-facing analytics and notification preferences.