I fix messy e-commerce spreadsheets and automate daily sales & inventory reporting.
Selling across Shopify, Amazon, and TikTok? I eliminate manual copy-pasting, reconcile platform deduction fees, and build bulletproof Google Sheets formulas that calculate your true net margins in 30 seconds.
Bereskan rekap penjualan yang berantakan & otomatisasi pembukuan toko online Anda.
Pusing mencocokkan potongan fee Shopee, TikTok Shop, dan Tokopedia? Saya bantu bersihkan data CSV mentah, hitung laba bersih riil, dan bangun sistem Google Sheets otomatis tanpa pusing langganan software mahal.
PROVEN SYSTEMS & LIVE DEMOS
SISTEM KERJA & CONTOH SPREADSHEET ASLI
Real datasets, automated formulas, and interactive dashboards. Click buttons to verify.
Multi-Channel Sales Reconciliation & Net Profit Engine
Rekapitulasi Penjualan & Laba Bersih Multi-Channel Otomatis
Shopify, Amazon, and TikTok CSV exports have conflicting date formats, currency columns, and platform deduction fees. Manual auditing took 8 hours every Monday.
Built a standardized Google Sheets engine that ingests raw transaction exports, isolates platform commissions/shipping cuts, and outputs clean net revenue automatically.
Monday reconciliation time dropped from 8 hours to 30 seconds. Zero formula breakages, executive KPI cards for daily owner decisions.
Dynamic Reorder Point (ROP) & 3PL Restock Alerts
Pengendalian Stok Otomatis (ROP) & Alarm Restock Gudang
Fast-growing brand suffered unexpected stockouts on best-selling SKUs and tie-up cash in dead inventory due to static reorder rules.
Built an automated inventory tracker calculating Dynamic ROP based on daily sales velocity, supplier lead times, and safety buffer days.
Color-coded traffic lights (🚨 REORDER NOW, ⚠️ MONITOR, ✅ HEALTHY) prevent stockouts and automatically compute the exact reorder quantity.
Targeted B2B Lead Extraction & Directory Enrichment
Ekstraksi Kontak Bisnis B2B & Standarisasi Nomor Telepon
Agency needed 500+ verified business contacts (roasteries, clinics, retail stores) for outbound sales, but manual data entry was too slow.
Built a cloud-based Python pipeline running on a Linux VPS to extract verified phone numbers, clean domains, format international dial codes, and deduplicate records.
Delivered clean, deduplicated spreadsheet with 100% verified domains and standardized phone numbers ready for CRM import within 24 hours.
HOW WE WORK TOGETHER (100% ASYNC)
CARA KERJA SAYA (100% PRAKTIS & CEPAT)
No endless Zoom calls. Just clean deliverables on time.
Drop your sample CSV, messy Google Sheet, or describe what numbers you need calculated via Telegram or WhatsApp.
I write the scripts, structure the formulas, verify mathematical accuracy, and lock editing permissions to prevent staff errors.
You receive a clean, tested spreadsheet with a brief 2-minute video walkthrough. Includes 14-day warranty for tweaks.