XERPIUMACCOUNTING

General Ledger

• GL Report — Filter by journal, date range (month/quarter/year/custom), analytic, posted/draft, cash basis
• Trial Balance — Debit/credit balance per account, period-to-period comparison
• Partner Ledger — Transaction history per partner, outstanding balance
• Aged Receivable/Payable — Aging 30/60/90/120+ days, multi-currency
• Export XLSX — All reports export to Excel via openpyxl

Cash & Bank

• Cash Book — All cash transactions, opening/closing balances, daily movements
• Bank Book — Bank transactions per account, reconciliation
• Day Book — Daily journal of all transactions
• Bank Statement Import — CSV, OFX, QIF, PDF (BCA, Mandiri)
• Bank Reconciliation — Interactive widget, match with invoices/payments

Asset Management

• Asset Registry — Fixed assets per category, acquisition value, useful life
• Depreciation — Linear & degressive, prorata temporis, monthly/yearly
• Asset Report — Register assets, depreciation schedule, book value
• Disposal — Asset sale/disposal, gain/loss calculation

Invoice & Payment

• Multi Invoice Layout — 5 invoice layouts, customizable per company
• Credit Limit — Limit per partner, auto-block when the limit is exceeded
• Follow-up — Collection level, automatic email, aging report
• PDC — Post-dated check management, maturity tracking
• Journal Audit — Audit trail per journal, user tracking

Budget Management

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

Financial Reports

• Balance Sheet — Assets, liabilities, equity — hierarchical tree
• Profit & Loss — Revenue, COGS, opex, net profit — comparison period
• Cash Flow — Operating, investing, financing — tag-based grouping
• Journal Report — Per journal, per period, account filter
• Tax Report — VAT, income tax — per period, per tax type

📋 Daily Transaction

• Header — Target COA, journal, opening/closing balance, statement metadata
• 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 — One line split into multiple COAs, 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 for salary matching
• Custom Prompt — Company & per-transaction, example: "IDM = Stationery Costs"
• JSON Response — {line_id, account_id, invoice_id, payment_id, confidence, reason}
• Confidence Score — AI gives a confidence score per suggestion

📄 Bank Statement Import

• BCA — PDF parser, pdftotext + regex, multi-page with "continued"
• Mandiri Corporate — PDF parser, mirror BCA architecture
• Extraction — Account holder, number, branch, period, currency
• Parsing — DATE, DESCRIPTION, MOVEMENT columns, DB/CR to signed
• Summary — Opening balance, CR/DB movements, closing balance — auto-validate

⚙ AI Settings

• Per-company — Unique constraint per company
• Extra Accounts — Additional accounts in the AI candidate pool
• Prompt Default — Default instructions for AI, customizable per transaction
• DeepSeek — Default provider, temperature 0.1 for consistency
• Config Chain — ir.config_parameter → env var → defaults

Industry COA List

COA List (Continued)

📈 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 from SVL, per product
• Stock Card — Per product per warehouse, opening/closing balance, movements
• Stock Summary — Summary per warehouse, UoM conversion
• Excel Export — FIFO & stock card export ke Excel via openpyxl/xlwt
• Date Range — Filter per period for analysis

💰 Cash Flow

• Cash Flow Statement — Operating, investing, financing
• Tag-based Grouping — account.tag for cash flow categorization
• 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 → complete dashboard
• NL→SQL — Natural language to SQL query real-time
• Chart Insight — AI analysis of trends, anomalies, recommendations
• AI Copilot — Chat with dashboard context
• DeepSeek — LLM engine, temperature 0.1, JSON response