XERPIUM ACCOUNTING

Ringkasan

Ekosistem Akuntansi & Laporan Keuangan

XERPIUM ACCOUNTING adalah solusi akuntansi lengkap untuk 32 industri — dari general ledger, balance sheet, P&L, cash flow, hingga daily transaction dengan AI reconciliation & Turbo Report yang menghasilkan laporan keuangan dalam hitungan detik.

📋

CORE

GL, AP, AR, Aset, Budget

📈

TURBO

Report <1 Menit

🤖

Reconcile Otomatis

🌎

32 COA

Siap Pasang

Core Accounting

Modul Akuntansi Inti

23 model, 15 laporan, 17 wizard — kit akuntansi terlengkap. Dari aset tetap hingga bank reconciliation.

📋

General Ledger

GL Report — Filter by journal, date range (month/quarter/year/custom), analytic, posted/draft, cash basis
Trial Balance — Saldo debit/kredit per akun, comparison antar periode
Partner Ledger — Riwayat transaksi per partner, outstanding balance
Aged Receivable/Payable — Aging 30/60/90/120+ hari, multi-currency
Export XLSX — Semua laporan export ke Excel via openpyxl

💰

Cash & Bank

Cash Book — Semua transaksi kas, saldo awal/akhir, mutasi harian
Bank Book — Transaksi bank per rekening, rekonsiliasi
Day Book — Jurnal harian semua transaksi
Bank Statement Import — CSV, OFX, QIF, PDF (BCA, Mandiri)
Bank Reconciliation — Widget interaktif, match with invoices/payments

🎯

Asset Management

Asset Registry — Fixed asset per kategori, nilai perolehan, masa manfaat
Depreciation — Linear & degressive, prorata temporis, monthly/yearly
Asset Report — Register aset, depreciation schedule, book value
Disposal — Penjualan/penghapusan aset, gain/loss calculation

📜

Invoice & Payment

Multi Invoice Layout — 5 layout invoice, kustom per perusahaan
Credit Limit — Limit per partner, auto-block saat melebihi limit
Follow-up — Level collection, email otomatis, aging report
PDC — Post-dated check management, maturity tracking
Journal Audit — Audit trail per jurnal, user tracking

📦

Budget Management

Budget Post — Budgetary position, link ke akun & analytic
Budget vs Actual — Planned vs practical/theoretical amount
Percentage Achievement — % realisasi budget, pro-rata time-based
Workflow — Draft → Confirm → Validate → Done
Analytic — Budget per project/departemen/cost center

📈

Financial Reports

Balance Sheet — Aset, liabilitas, ekuitas — hierarchical tree
Profit & Loss — Revenue, COGS, opex, net profit — comparison period
Cash Flow — Operating, investing, financing — tag-based grouping
Journal Report — Per jurnal, per periode, filter akun
Tax Report — PPN, PPh — per periode, per jenis pajak

Turbo Report

Turbo Report — Laporan Keuangan Cepat

Dari 15-30 menit menjadi <1 menit. Direct SQL engine, report structure tree, consolidation multi-company.

Performa Turbo Report

15-30

Menit (Standard)

Laporan keuangan XERPIUM standard

Menit (Optimized)

Dengan cache & indexing

Menit (Turbo)

Direct SQL + Materialized Views

Turbo Report Engine

Direct SQL — Bypass XERPIUM ORM, query langsung ke PostgreSQL
Report Structure Tree — Hierarchical parent-child, account group mapping
6 Built-in Reports — Balance Sheet, P&L, Trial Balance, Partner Ledger, Cash Book, Bank Book
Comparison Periods — Month-over-month, quarter-over-quarter, year-over-year
Dynamic Columns — Auto-generate columns for comparison periods
Account Group Prefix — code_prefix_start mapping (11→Cash, 41→Revenue)

Fitur Unggulan Turbo

Consolidation — Multi-company consolidation, elimination inter-company
Report Cache — Cache hasil report untuk akses cepat
Year Closing — Year-end closing wizard, automatic
Analytic Filter — Filter laporan per analytic account
Partner Filter — Filter laporan per partner
Formula Support — {"sign":-1,"codes":["4","5","6","7"]} — subtotal formula

Dashboard Cache

7 Materialized Views — PostgreSQL matviews untuk akses instan
Financial KPIs — ROA, ROE, ROI — computed real-time dari matview
Snapshots — Account balance snapshot per periode
Home Overview — Revenue, SO, PO, open invoices — current vs previous month
Cron Refresh — Auto-refresh via ir.cron, TRUNCATE + INSERT pattern
Profit Flow Sankey — Revenue → COGS → Opex → PBT → Tax → Net Profit

Sankey Dashboard

Visual Profit Flow — Sankey diagram aliran laba dari revenue ke net profit
Turbo Integration — Data dari Turbo Report P&L, real-time
Profitability Analysis — Visual breakdown per komponen laba
Multi-Period — Bandingkan antar periode
Drill-down — Klik node untuk detail akun

AI Daily Transaction

Daily Transaction — AI Reconciliation Otomatis

Transaksi harian, import statement BCA/Mandiri, AI-powered contra account suggestion, auto post & reconcile.

📋 Daily Transaction

Header — Target COA, journal, saldo awal/akhir, metadata statement
Line — Amount signed, contra account, account split multi-COA
Validate — Auto-create account.move per line, multi-leg journal
Reconcile — Link to invoice/payment, auto-reconcile on post
Account Split — Satu line split ke multiple COA, JSON split for frontend
Re-validate — Edit existing moves, reset to draft, re-post

🤖 AI Reconciliation

DeepSeek LLM — OpenAI-compatible API, default deepseek-chat
Candidate Pool — 200+ open invoices + unmatched payments
Employee Context — Employee names + salary COA untuk matching gaji
Custom Prompt — Perusahaan & per-transaction, contoh: "IDM = Biaya ATK"
JSON Response — {line_id, account_id, invoice_id, payment_id, confidence, reason}
Confidence Score — AI memberikan skor keyakinan per suggestion

📄 Bank Statement Import

BCA — PDF parser, pdftotext + regex, multi-page dengan "bersambung"
Mandiri Corporate — PDF parser, mirror BCA architecture
Ekstraksi — Account holder, number, branch, period, currency
Parsing — TANGGAL, KETERANGAN, MUTASI columns, DB/CR to signed
Summary — Saldo awal, mutasi CR/DB, saldo akhir — auto-validate

⚙ AI Settings

Per-company — Unique constraint per company
Extra Accounts — Tambahan akun di pool kandidat AI
Prompt Default — Instruksi default untuk AI, bisa custom per transaksi
DeepSeek — Default provider, suhu 0.1 untuk konsistensi
Config Chain — ir.config_parameter → env var → defaults

l10n

Chart of Accounts — 32 Industri Siap Pasang

COA khusus per industri dengan akun, tax, fiscal position — tinggal install, langsung siap. Dilengkapi report structure untuk Turbo Report.

Daftar COA Industri

Modul l10n_id_	Industri
aerospace	Aerospace Manufacturing
agriculture	Agriculture/Farming
auditor	Auditor Firm
aviation	Aviation/Airlines
beauty_clinic	Beauty Clinic
building_management	Building/Property
civil_construction	Civil Construction
coal_mining	Coal Mining
data_center_it	Data Center/IT
distribution	Distribution
education_foundation	Education Foundation
event_organizer	Event Organizer
feedmill	Feedmill
fishery	Fishery
food_beverage	Food & Beverage
garment	Garment/Textile

Daftar COA (Lanjutan)

Modul l10n_id_	Industri
generic	Generic Business
gold_mining_refinery	Gold Mining & Refinery
hospital_pharmacy	Hospital & Pharmacy
hotel_property	Hotel & Property
koperasi	Koperasi/Cooperative
livestock	Livestock
logistics	Logistics
rental	Rental
retail	Retail
satellite_city	Satellite City
sawit	Palm Oil/Sawit
software	Software House
theme_park	Theme Park
travel_haji_umroh	Travel Haji & Umroh
university	University

📷

Screenshot: Chart of Accounts Industri

COA Koperasi, COA Retail, COA Manufaktur, COA Hospital — 32 template siap pakai

Additional

Laporan Tambahan & Integrasi

📈 Dynamic Reports

GL — General ledger with multi-filter, XLSX export
Trial Balance — Dynamic TB, comparison MTD/YTD
Balance Sheet — Comparison period, multi-level hierarchy
Profit & Loss — Month-over-month, year-over-year
Cash/Bank Book — Daily cash & bank transactions
Aged Report — AR/AP aging 30/60/90/120+
Tax Report — PPN, PPh — per period, per tax type

📦 Stock Reports

FIFO Report — Manual layer computation dari SVL, per product
Stock Card — Per product per warehouse, saldo awal/akhir, mutasi
Stock Summary — Summary per warehouse, UoM conversion
Excel Export — FIFO & stock card export ke Excel via openpyxl/xlwt
Date Range — Filter per periode untuk analisis

💰 Cash Flow

Cash Flow Statement — Operating, investing, financing
Tag-based Grouping — account.tag untuk kategorisasi arus kas
Hierarchical — Expandable sections, beginning/closing balance
Period Filter — Monthly, quarterly, yearly, custom
Sankey UI — AJAX-powered interactive cash flow diagram

🤖 AI Integration

AI Generate Dashboard — Natural language → dashboard lengkap
NL→SQL — Natural language to SQL query real-time
Chart Insight — AI analisis tren, anomaly, rekomendasi
AI Copilot — Chat dengan konteks dashboard
DeepSeek — LLM engine, suhu 0.1, response JSON

Comparison

Mengapa XERPIUM ACCOUNTING?

Aspek	ERP Standard	XERPIUM ACCOUNTING
Financial Reports	ORM-based, 15-30 menit	✓ Direct SQL, <1 menit
COA Industri	Hanya generic	✓ 32 template siap pasang
Bank Statement	CSV/OFX manual	✓ BCA & Mandiri PDF auto-import
AI Reconciliation	✗ Tidak ada	✓ DeepSeek AI, match invoice/payment
Dashboard Cache	✗ Tidak ada	✓ 7 materialized views, instant
Consolidation	Enterprise only	✓ Multi-company, elimination
Cash Flow	Enterprise only	✓ Tag-based, Sankey visualization
Budget	Enterprise only	✓ Budget vs actual, analytic
Asset Management	Enterprise only	✓ Linear/degressive, disposal
Multi-Currency	Basic	✓ Full multi-currency, FX gain/loss

Portfolio

Portofolio Industri XERPIUM

Industri	Modul	Dashboard	Report
Inventory & WMS	275+	✓	✓
Manufacturing	230+	✓	✓
Purchase	105	✓	✓
HR & Payroll	29	✓	✓
Aerospace	10	✓	✓
Accounting	9	✓	✓
University	9	✓	✓
Distribution	8	✓	✓
Koperasi	8	✓	✓
Retail & POS	7+	✓	✓
Gold Mining	7	✓	✓
Aviation	6	✓	✓
Coal Mining	6	✓	✓
Hospital	6	✓	✓
Travel Umroh	6	✓	✓
Logistics	5	✓	✓
Hotel	5	✓	✓
Beauty Clinic	5	✓	✓
Rental	4	✓	✓
Livestock	4	✓	✓
Fishery	4	✓	✓
Software House	4	✓	✓
Event Organizer	4	✓	✓
Satellite City	2	✓	✓
Education	2	✓	✓
Food & Beverage	1	✓	✓
Civil Construction	1	✓	✓
Garment	1	✓	✓
Agriculture	1	✓	✓
Theme Park	1	✓	✓
Data Center / IT	1	✓	✓
Sawit / Palm Oil	1	✓	✓
Feedmill	1	✓	✓
Building Management	1	✓	✓
Auditor	1	✓	✓

XERPIUMACCOUNTING