- Problem
- Hitung manual jutaan baris cloud usage, diskon kontrak, dan prorata seat di Excel.
- Approach
- Data pipeline SQL & Python dari BigQuery ke Accounting System untuk hitung prorata eksak.
- Outcome
- Tagihan yang match langsung siap kirim; diskon expired atau akun belum ter-link tertangkap otomatis.
| Customer / Project | Usage & Contract Calc | Draft Invoice ERP | Status |
|---|---|---|---|
| gcp-prod-retail-01 (ID 8841) | 1,420 compute hrs · 12% promo | Unchecked draft | Raw Export Unchecked |
| workspace-seat-sync-id99 | 240 base seats + 15 mid-month | Unchecked draft | Raw Export Unchecked |
Catatan baris (klik baris untuk cek)
Perlu validasi apakah diskon 12% masih aktif bulan ini.
| Customer / Project | Usage & Contract Calc | Draft Invoice ERP | Status |
|---|---|---|---|
| PT Retail Digital (gcp-prod-retail-01) | Net Contract: Rp 64.200.000 (-12%) | Draft INV/0412: Rp 64.200.000 | Matched Ready to Bill |
| PT Kreasi Media (workspace-seat-id99) | 240 seats + 15 prorated (14d) | Draft INV/0419: Rp 31.450.000 | Prorated OK Ready to Bill |
Catatan baris (klik baris untuk cek)
Billing ID, periode diskon, dan total draft invoice cocok.
| Customer / Project | Usage & Contract Calc | Draft Invoice ERP | Status |
|---|---|---|---|
| PT Logistik Utama (Sub-project B) | Expected: Rp 28.900.000 | Draft ERP: Rp 25.432.000 (-12%) | Discount Drift Hold: Expired Promo |
| Project "sinar-abdi-dev" (No ID) | Name similar to "PT Sinar Abadi" | Usage Rp 4.120.000 held | Unlinked ID Hold: Bind ID |
Catatan baris (klik baris untuk cek)
Promo 12% habis bulan lalu, tapi draft ERP masih memotong diskon.