Batch Aktif: B-20260929-9B99 • Berkas: LAPORAN_20260929_020112.xlsx
Periode Data: 2025-09-12 s/d 2026-12-01 •
Total 3.632 baris dari 19 sheet berhasil distaging.
Kesiapan: 95%
Buka Inspection Hub & Buat Laporan
Total Pembelian Bahan
Rp 548.043.709
Tembakau, cengkeh, kemasan & cukai
Kas Keluar (Talangan Pak Joko)
Rp 43.525.787
Biaya operasional, upah buruh & BOP
Bahan Digiling (TSG)
1.255,40 kg
Bahan Baku Siap Giling Lini RJ & Djamru
Mutasi Kartu Stok
2.985 baris
16 Kartu Stok Gudang Rokok
Status Rekonsiliasi & Paritas 20 Sheet Excel
Audit integritas data baris Excel vs Staging Database
| Sheet Excel | Tabel Sasaran | Baris Excel | Diimpor | Status Paritas |
|---|---|---|---|---|
| PEMBELIAN |
purchases
|
878 | 114 | MATCH |
| PEMBELIAN (2) |
purchases
|
1.053 | 203 | MATCH |
| HUTANG_PAK JOKO |
operational_expenses
|
99 | 84 | MATCH |
| PEMAKAIAN UTK TSG |
production_usages
|
713 | 246 | MATCH |
| STOK TSG RUBAHJAGA |
inventory_mutations
|
95 | 87 | MATCH |
| BATANGAN RUBAHJAGA |
inventory_mutations
|
129 | 34 | MATCH |
| AMBRI RJ |
inventory_mutations
|
119 | 33 | MATCH |
| ETIKET RJ |
inventory_mutations
|
372 | 343 | MATCH |
| INNER RUBAHJAGA |
inventory_mutations
|
372 | 343 | MATCH |
| PACK RUBAH JAGA |
inventory_mutations
|
397 | 24 | MATCH |
| OPP RUBAH JAGA |
inventory_mutations
|
386 | 13 | MATCH |
| BARANG JADI RUBAH JAGA |
inventory_mutations
|
397 | 367 | MATCH |
| STOK TSG_DJAMRU |
inventory_mutations
|
105 | 98 | MATCH |
| BATANGAN DJAMRU |
inventory_mutations
|
138 | 137 | MATCH |
| AMBRI DJAMRU |
inventory_mutations
|
82 | 81 | MATCH |
| ETIKET DJAMRU |
inventory_mutations
|
374 | 345 | MATCH |
| INNER DJAMRU |
inventory_mutations
|
374 | 345 | MATCH |
| PACK DJAMRU |
inventory_mutations
|
397 | 367 | MATCH |
| OPP DJAMRU |
inventory_mutations
|
0 | 0 | MATCH |
| BARANG JADI DJAMRU |
inventory_mutations
|
398 | 368 | MATCH |
AI Auditor & Anomali
Mesin audit forensik memeriksa 19 aturan akuntansi (R01-R19) mencakup selisih saldo, duplikasi bon, stok minus, dan anomali harga.
STATUS AUDIT FORENSIK
19 Aturan Aktif
AI Co-Pilot dapat ditanya kapan saja menggunakan tombol ungu di sudut kanan bawah.
Konfigurasi Kebijakan
| Standar Pembukuan: | SAK EMKM |
| Metode Persediaan: | Rata-Rata Bergerak |
| Alokasi Konversi: | RJ 60% / DJ 40% |
| Tahun Buku: | 2026 |