Imogi Finance

bench get-app https://github.com/Abisena/IMOGI-FINANCE

[![Listed on Frappe Gems](https://frappegems.com/api/method/frappe_gems.seo.badge?app=Abisena%2FIMOGI-FINANCE)](https://frappegems.com/gems/apps/Abisena/IMOGI-FINANCE)

Imogi Finance

Version: v1.5.0 (Released Feb 10, 2026) Status: Production Ready

App for managing expenses at IMOGI with comprehensive expense request workflows, OCR-powered tax invoice processing, budget control, payment automation, and Indonesian tax compliance features.

> For detailed documentation, see DOCUMENTATIONMASTERINDEX.md and START_HERE.md

Requirements: - ERPNext v14+ (v15+ recommended for native Payment Ledger features) - Frappe v14+ - Python 3.10+

---

Key Features

Expense Request & Approvals

• Dynamic approval routes: routes are calculated from Expense Approval Settings per Cost Center + expense account + amount, stored on the document, and must be refreshed before approval (configuration changes are detected and block approval until refreshed). Submit is restricted to the creator, approvers must match the user/role on the route, and levels cannot be skipped.
• Edit controls & post-submit states: changing amount/cost center/expense account while Pending resets to Pending Review (level 1) with an audit comment; key fields cannot change in Approved/Linked/Closed. Pending edits are limited to the owner or approver, and all rejections/overrides are recorded in the timeline.
• Protected reopen & close: reopen is reserved for System Manager unless an override flag is set; it enforces audit when active links to Payment Entry/Purchase Invoice/Asset exist. Close validates the latest route or final snapshot; an emergency override flag is available with audit trail.
• Status guardrails & audit trail: off-workflow status changes are blocked, approval routes are snapshotted when Approved to validate Close, and automatic comments are posted for denied workflow actions, pending edits, or reopen overrides.

Budget Control & Internal Charge

• Staged budget lock: Budget Control Settings can lock budgets at Approved/Linked, reserving per Cost Center + Account (+Project/Branch) and releasing automatically on Reject/Reopen. Consumption occurs on Purchase Invoice submit and is reversed on cancel.
• Overrun handling & special role: the allow_budget_overrun_role can permit overruns when reservation fails. Lock status (Locked/Overrun Allowed/Consumed/Released) is synchronized to the Expense Request.
• Integrated internal charge: the "Allocated via Internal Charge" mode requires an Approved Internal Charge Request before approval/PI; the create_internal_charge_from_expense_request helper auto-creates a draft with a starter line. "Auto JE on PI Submit" posts a reclass Journal Entry across Cost Centers according to allocation.

Accounting & Downstream Documents

• Purchase Invoice creation from Expense Request: a whitelisted helper ensures the request is Approved, type (Expense/Asset) matches, no duplicate links exist, and copies items (including VAT/WHT) with pending/submitted markers to prevent duplicate invoices.
• Asset & Payment Entry linking: hooks on Asset, Purchase Invoice, and Payment Entry maintain request status, prevent duplicate links, and verify downstream documents are submitted before payment. Requests are automatically Closed after Payment Entry succeeds.
• Multi-branch compliance: branch is derived from Cost Center/Finance Control Settings when creating PI from Expense Request; PI/PE/Asset links validate branch alignment when enforcement is enabled.

Customer Receipt & Payment Validation

• Customer Receipt document: chooses default print layout from Finance Control Settings, validates Sales Invoice/Sales Order references by customer & company, locks items after Issued, and computes Issued/Partially Paid/Paid status based on incoming payments.
• Payment safeguards: Payment Entry hook enforces "Mandatory Strict" mode (must link to a Customer Receipt when open receipts exist), blocks over-allocation or unrelated references except in mixed payment mode, and automatically updates/removes payment notes on Receipt during submit/cancel.
• Collection automation: the make_payment_entry button on Receipt creates Payment Entry with automatic allocation per outstanding reference.
• Stamp policy & Jinja utilities: Receipts apply digital/physical stamp policy per configuration (mandatory/threshold/fallback) and expose Jinja filters terbilang_id and build_verification_url for print templates.

Reconciliation & Bank Imports

• BCA Bank Statement Import: upload BCA CSV, the system hashes to prevent re-uploads, validates headers/numbers (detecting merged columns/"sep=" preamble), computes balances, and skips balance/pending rows. Parse CSV BCA prepares rows then Convert to Bank Transaction creates Unreconciled Bank Transactions with duplicate prevention and success/failure reporting. Open Bank Reconciliation Tool opens with the same date range & bank account.
• Bank Transaction controls: Unreconciled transactions cannot be cancelled (backend guard + hidden Cancel button) to preserve reconciliation history.

Cash/Bank Daily Reporting & Dashboard

• Branch-aware cash/bank rollup: build_daily_report partitions Bank Transactions per branch (with optional allowed branch filter), computes opening balances from earlier transactions, and aggregates inflow/outflow/closing for each branch plus a consolidated "All Branches" view.
• Reporting snapshots & signers: daily snapshots include signer blocks (prepared_by/approved_by/acknowledged_by) resolved from Finance Control Settings and can be cached via run_daily_reporting; dashboard payloads combine daily metrics with optional monthly reconciliation overlays.
• Extensible inputs/exports: helpers parse CSV bank statements, serialize combined daily + reconciliation data for export, and expose planning APIs for daily/monthly schedules without forcing a background worker.

Transfer Application & Payment Automation

• Automatic Payment Entry creation: helper button creates Payment Entry from Transfer Application with paidfrom/paidto defaults from settings or company accounts; can auto-submit and copy document references.
• Bank Transaction matching: on Bank Transaction submit/update, the system searches Transfer Application candidates by amount (with tolerance), account number/hint/payee name, and marks confidence Strong/Medium/Weak for review. Strong matches can auto-create Payment Entry and mark the TA as Paid.
• Link protection: Payment Entry hooks ensure a TA is not linked to multiple payments, update status/paidamount/paiddate on submit, and clear links on cancel.

Advance Payments (Native First Strategy)

> IMPORTANT: IMOGI Finance uses ERPNext native Payment Ledger for advance payment tracking. Custom APE module is deprecated. > Documentation: Native Payment Ledger User Guide | Installation Guide

• Native Payment Ledger: ERPNext v15+ automatically tracks all advances via Payment Ledger Entry (zero custom code needed for Supplier/Customer advances).
• Enhanced Dashboard: Custom report provides status visualization (Fully/Partially/Unallocated), aging analysis (0-30, 30-60, 60-90, 90+ days), and summary cards.
• Employee Advance Extension: IMOGI Finance adds "Get Employee Advances" button to Expense Claim with auto-allocation on submit.

VAT Out Batch

• Grouped invoice management: collects output VAT Sales Invoices into named batches for review, approval, and tax reporting. Invoices can be added/moved/removed across groups before locking.
• CSV template export: generates CoreTax-compatible CSV for e-Faktur bulk upload.
• Integration with Tax Period Closing: batch status is tracked against period lock to prevent edits after period closure.

Tax, OCR, & CoreTax Export (v1.5.0 Enhanced)

OCR Improvements (v1.5.0): - Pre-compiled regex patterns: 30-40% performance improvement for field extraction - Field swap auto-detection: Automatically detects and flags swapped DPP/PPN fields with business logic correction - Zero-rated transaction support: Handles 0% tax rate for exports and exempt goods - Confidence scoring: Returns 0-0.95 confidence per extraction with multiple capping strategies - Structured error tracking: Queryable ParsingError and ParsingErrorCollector classes for debugging

Tax Invoice Features: - Tax Invoice OCR: OCR configuration (provider/size limit/threshold) for Purchase Invoice, Expense Request, and Sales Invoice; parses tax invoice text (NPWP, number/date, DPP/VAT) with NPWP normalization and duplicate flag. - Tax Invoice Upload: Verified uploads required whenever manual Faktur Pajak fields are filled on Purchase/Expense Requests. Validation enforces unique 16-digit numbers, valid NPWP, and stored PDF; Sales Invoice sync copies verified upload to out_fp* fields with NPWP safeguards and status tracking. - Tax profile controls: Each company's Tax Profile requires PPN input/output, PB1 payable, and PPh payable accounts for tax registers, closings, and payment posting. - Tax period closure: Tax Period Closing blocks changes to tax/tax-mapping fields on ER/PI/SI when period is Closed, except for System Manager/Tax Reviewer roles. - Reporting & exports: Utilities compute snapshots for input/output VAT registers, withholding tax, and PB1; CoreTax mappings required for DPP, PPN, NPWP, faktur date; Payment Entry/Journal Entry creation for Tax Payment Batch and VAT netting (debit output/credit input/payable).

Deferred Expense Amortization (New in v1.5.0)

• Amortization processor module: Python functions for generating monthly amortization schedule from prepaid expense Purchase Invoices
• Monthly journal entry generation: Automatically creates GL entries for prepaid expense amortization based on posting date
• Status tracking: Tracks amortization creation status to prevent duplicate processing
• Flexible start date: Amortization can start from invoice date or custom month

Custom Reports & Dashboards

Built-in reports accessible from the Finance workspaces:

Report	Description
VAT Input Register Verified	Input VAT summary with verified faktur status
VAT Output Register Verified	Output VAT summary for CoreTax reconciliation
Withholding Tax Register	PPh 21/23/4(2) withholding summary by period
PB1 Register	PB1 tax summary per branch/company
Advanced Payment Dashboard	Advance payment aging (0-30, 30-60, 60-90, 90+ days)
Budget Control Dashboard	Budget reservation/consumption status visualization
Outstanding Approvals Dashboard	Pending approvals across all expense workflows
Deferred Expense Tracker	Amortization schedule status and posting progress
Customer Receipt Control Report	Receipt payment collection status
Digital Stamp Expense Report	Materai usage and threshold tracking
VAT Out Batch Register	VAT output batch grouping and status

Print Formats

Five custom print formats included:

• Expense Request — formal expense request layout with approval route visualization
• Customer Receipt — multi-design receipt with digital stamp and verification URL
• Transfer Application Bank Form — bank transfer form for payment processing
• Cash Bank Daily Report — daily report with signer blocks

---

Installation

You can install this app using the bench CLI:

cd $PATH_TO_YOUR_BENCH
bench get-app https://github.com/YOUR_ORG/imogi_finance --branch main
bench install-app imogi_finance

Post-install configuration: 1. Set up Tax Profile per company (PPN input/output, PB1 payable, PPh payable accounts) 2. Configure Finance Control Settings (branch e