Total Piutang
Rp 245 Jt
12 Agen
Piutang Lancar
Rp 180 Jt
73.5% dari total
Jatuh Tempo
Rp 45 Jt
18.4% perlu follow-up
Macet (>90 hari)
Rp 20 Jt
Perlu tindakan
Rekonsiliasi Pertamina
Data Bulan Ini Sudah Direkonsiliasi
Selisih 0.12% masih dalam batas toleransi (maks 0.5%)
Total Penebusan (Pembelian)
Rp 1,248,000,000
Total Penerimaan Fisik
156,000 Kg
Harga Rata-rata/Kg
Rp 8,000
Selisih
Rp 1,497,600 (0.12%)
Aging Schedule Piutang
Lancar (0-30 hari)
Rp 180 Jt
31-60 hari
Rp 30 Jt
61-90 hari
Rp 15 Jt
Macet (>90 hari)
Rp 20 Jt
Daftar Piutang Agen
| Agen | Total Tagihan | Sudah Dibayar | Sisa | Jatuh Tempo | Umur | Status | Aksi |
|---|---|---|---|---|---|---|---|
| CV. Mitra Gas Sejahtera | Rp 85,000,000 | Rp 60,000,000 | Rp 25,000,000 | 15 Jan 2024 | 7 hari | Lancar | |
| PT. Bumi Energi | Rp 120,000,000 | Rp 75,000,000 | Rp 45,000,000 | 28 Dec 2023 | 11 hari | Jatuh Tempo | |
| Agen Sumber Rezeki | Rp 65,000,000 | Rp 50,000,000 | Rp 15,000,000 | 20 Jan 2024 | 2 hari | Lancar | |
| UD. Flame Indo | Rp 50,000,000 | Rp 30,000,000 | Rp 20,000,000 | 01 Oct 2023 | 99 hari | Macet | |
| CV. Gas Prima | Rp 78,000,000 | Rp 48,000,000 | Rp 30,000,000 | 05 Dec 2023 | 34 hari | 31-60 Hari |
Pencocokan DO - Faktur - Pembayaran
| No. DO | No. Faktur | Agen | Nilai Faktur | Pembayaran | Sisa | Status |
|---|---|---|---|---|---|---|
| DO-2024-0892 | INV-2024-0456 | CV. Mitra Gas Sejahtera | Rp 15,000,000 | Rp 15,000,000 | Rp 0 | Lunas |
| DO-2024-0891 | INV-2024-0455 | PT. Bumi Energi | Rp 24,000,000 | Rp 12,000,000 | Rp 12,000,000 | Sebagian |
| DO-2024-0890 | INV-2024-0454 | Agen Sumber Rezeki | Rp 10,500,000 | Rp 10,500,000 | Rp 0 | Lunas |
| DO-2024-0889 | INV-2024-0453 | UD. Flame Indo | Rp 25,000,000 | Rp 0 | Rp 25,000,000 | Belum Bayar |
| DO-2024-0888 | INV-2024-0452 | CV. Gas Prima | Rp 12,000,000 | Rp 0 | Rp 12,000,000 | Pending |