PanlyackERP: From Invoice to Inventory, Accounting and Cash

Description and use

PanlyackERP enables a single reviewed invoice to atomically update inventory, accounting and cash records, guaranteeing consistency, idempotency and immutability.

Problem

In a small business, a single purchase is often entered four times—into an invoice folder, a stock sheet, a cashbook and a ledger—creating opportunities for inconsistent records.

Outcome

PanlyackERP demonstrates that a single reviewed invoice can be used to atomically update inventory, accounting and cash records, providing guarantees of atomicity, gating, idempotency, exactness and immutability. Small‑model experiments show potential for lightweight inference on consumer hardware.

Workflow

• Capture invoice image or PDF
• AI pipeline (EasyOCR + Gemma 3 4B) proposes draft fields
• Human reviewer confirms or corrects draft and approves
• Database posts stock, journal entries, payments and audit record in one transaction

Evidence

In a small business, one purchase is often typed four times: into an invoice folder, a stock sheet, a cashbook and a ledger.

Source

Capture the invoice once. A local AI pipeline proposes its fields, a person confirms them, and a single database transaction posts stock, accounting entries and payments together.

Source

The posting workflow gives five concrete guarantees: Atomic, Gated, Idempotent, Exact, Immutable.

Source

Recognition (EasyOCR and a locally served Gemma 3 4B model) turns an invoice image or PDF into draft fields; a person reviews and confirms them; a deterministic PostgreSQL transaction then updates inventory, the double-entry journal and cash at the same time.

Source