Audit Rekening Koran Bank

Hidden Tool

Import CSV rekening koran, validasi saldo, review kategori, lalu sinkronkan ke transaksi bank.

Bandingkan Neraca

Total Records

Belum Direview

Belum Sync

ALUR REKENING KORAN

Saldo Awal Import

Total Kredit Masuk + Rp {{ number_format($stats['total_kredit'], 0, ',', '.') }}

Total Debet Keluar - Rp {{ number_format($stats['total_debet'], 0, ',', '.') }}

SALDO AKHIR KALKULASI Rp {{ number_format($stats['saldo_akhir_calculated'], 0, ',', '.') }}

VALIDASI SALDO CSV

Saldo Akhir dari CSV Rp {{ number_format($stats['saldo_akhir_actual'], 0, ',', '.') }}

Selisih CSV vs Kalkulasi {{ $stats['selisih'] >= 0 ? '+' : '-' }} Rp {{ number_format(abs($stats['selisih']), 2, ',', '.') }}

Status Rekonsiliasi @if(abs($stats['selisih']) < 1) Match @else Perlu Cek @endif

NET MOVEMENT Rp {{ number_format($stats['total_kredit'] - $stats['total_debet'], 0, ',', '.') }}

{{-- Tab 1: Upload --}} @if($activeTab === 'upload')

Upload CSV rekening koran

Bisa pilih banyak file sekaligus.

Format File

rk_kspps_berkah_madani_[bulan]_[tahun]_DB_READY.csv

@if(count($csvFiles) > 0)

{{ count($csvFiles) }} file dipilih

@endif

Periode Ter-Import

Ringkasan file yang sudah masuk ke staging audit.

{{ count($importedPeriods) }} periode

@if(count($importedPeriods) > 0)

@foreach($importedPeriods as $period) @endforeach

Periode	File	Rows	Kredit	Debet	Imported	Aksi
{{ $period->period }}	{{ $period->filename }}	{{ number_format($period->total_rows, 0, ',', '.') }}	{{ number_format($period->total_kredit, 0, ',', '.') }}	{{ number_format($period->total_debet, 0, ',', '.') }}	{{ \Carbon\Carbon::parse($period->imported_at)->diffForHumans() }}

@else

Belum ada periode yang diimport.

@endif

@endif {{-- Tab 2: Review --}} @if($activeTab === 'review')

Review Transaksi

Filter transaksi sebelum ditandai reviewed atau disinkronkan.

@foreach($reviewData as $item) @endforeach

Tanggal	Jam	Keterangan	Debet	Kredit	Tipe	Kategori	Status
{{ $item->transaction_date->format('d/m/Y') }}	{{ substr($item->transaction_time, 0, 5) }}	{{ \Str::limit($item->keterangan, 72) }}	{{ $item->debet > 0 ? number_format($item->debet, 0, ',', '.') : '-' }}	{{ $item->kredit > 0 ? number_format($item->kredit, 0, ',', '.') : '-' }}	{{ $item->detected_type }}	{{ $item->detected_category }}	@if($item->is_synced) @elseif($item->is_reviewed) @else @endif

@endif {{-- Tab 3: Rules --}} @if($activeTab === 'rules')

Auto-Categorization Rules

Urutan prioritas rule yang dipakai saat CSV diimport.

@foreach($categoryRules as $rule) @endforeach

Priority	Pattern	Type	Category	Active
{{ $rule->priority }}	{{ $rule->pattern }}	{{ $rule->type }}	{{ $rule->category }}	@if($rule->is_active) @else @endif

@endif {{-- Tab 4: Sync --}} @if($activeTab === 'sync')

Sinkronisasi ke Bank Transactions

{{ number_format($stats['unsynced'], 0, ',', '.') }} transaksi belum masuk ke tabel transaksi bank.

@if($isProcessing)

{{ $syncProgress }}%

@endif