✦ Social Enterprise · Singapore

Automate Monthly
Consignment Reporting

Free 1.5 weeks per month from repetitive manual data work — so the team can focus on partner growth and mission impact.

50+
Consignment Partners
1.5 wks
Lost Every Month
3
Disconnected Sources
<4 hrs
Target After AI
Live Demo
Watch the AI Process Real Data
Simulate the full pipeline: ingest raw transaction data, classify events, and generate a partner consignment report.
Product_mix_Report.xlsx · 555 rows
Riau_Candles_stock_movement.xlsx · Target format
Corporate Orders · 12 records
📥 1. Data Ingestion
🗂 2. Partner Mapping
🤖 3. AI Classification
📊 4. Report Generation
✅ 5. Ready to Send
Processing Log
// Ready. Click "Run AI Workflow" to start.
Transaction Sample — Raw Input
DateSKUPartnerTypeLocationQty
2024-05-01RC-001Riau Candles—KA10
2024-05-03RC-002Riau Candles—PP6
2024-05-05BL-012Beeswax Lab—Online4
2024-05-07RC-001Riau Candles—KA→PP3
2024-05-10GH-008Good Harvest—KA-2
How It Works
The Problem, The Solution & The Impact
The Problem
1.5 Weeks of Manual Work. Every Month.
Three disconnected systems. 50+ partners. No automation. Errors at every step.
1
Download Reports
POS · Online · Corp Orders
2
Identify Partners
Cross-ref 50+ brands manually
3
Clean & Transfer
Manual entry into Google Sheets
4
Error Checking
Re-do entire sections on mistakes
5
Finalise & Send
Reports to 50+ partners, one by one
Pain Points Current State
  • 1.5 weeks per month lost to report generation
  • Manual cross-referencing of 50+ partner SKUs
  • Data entry errors require full rework cycles
  • Reports sometimes sent late — damages partner trust
  • Team cannot focus on partner development
  • Cannot scale to more partners without headcount
Data Complexity 3 Sources
  • 3 source systems, each in a different format
  • Location transfers between KA, PP & Online
  • Corporate orders fulfilled from multiple locations
  • Inventory adjustments require separate classification
  • Ambiguous reconciliation entries throughout
  • 100+ transaction columns per partner per year
The Solution
AI Workflow: 3 Sources → 50+ Reports
An AI pipeline that ingests, maps, classifies, and generates partner-ready Google Sheets reports — automatically.
🖥 POS System (In-Store) Kreta Ayer & Potong Pasir · CSV export
🛒 Online Store Shopify / WooCommerce · order CSV
📦 Corporate Orders Bulk / B2B orders · spreadsheet
→→
🤖
AI Workflow
Powered by Qwen3-Flash
Parse & Ingest Partner Mapping Event Classify Reconcile
→→
Opening Stock Balance
Sales per Channel
Goods Received (GRN)
Inventory Adjustments
Location Transfers
Closing Stock Balance
Revenue Due to Vendor
Works entirely within Google Workspace · No new paid subscriptions required
Impact
Before vs. After Automation
What changes when the monthly reporting cycle runs itself.
Time to Generate All Reports
1.5 wks
↓
<4 hrs
~90% time reduction
Error Rate
High
↓
Near Zero
Ambiguous entries flagged, not dropped
Team Admin Capacity
30–35%
↓
~5%
Time reclaimed for partner development
Scalability
50 max
↑
Unlimited
Add partners without adding headcount
Current Monthly Time Split
Report Consolidation35%
Partner Mapping32%
Error Checking / Rework18%
High-Value Partner Work15%
After Automation — Target State
Review & QA5%
Exception Handling5%
Admin5%
Partner Support & Growth85%
Tech Stack
Built Within Google Workspace
📊
Google Sheets
Partner report templates + master SKU list
⚙️
Google Apps Script
Orchestration layer, triggers, and sheet writing
🤖
Qwen3-Flash
AI classification of ambiguous transactions via OpenRouter
📧
Gmail
Auto-send reports to partners on trigger