GestAImmo Core Processes & REST API Flows

GestAImmo Core Processes & REST API Flows A data-flow diagram generated by Archify. 01 / Trigger & Portals 02 / REST API Endpoints 03 / Process Engines 04 / Durable Ledgers 05 / Settlement & Audit Admin Console · Bank accounts & files · 01 / Trigger & Portals · BankAccountsView Admin Console Bank accounts & files BankAccountsView Invoice Wizard · Split & allocate · 01 / Trigger & Portals · SplitAllocateWizard Invoice Wizard Split & allocate SplitAllocateWizard Maintenance UI · Resident app & portal · 01 / Trigger & Portals · SupplierBidPortal Maintenance UI Resident app & portal SupplierBidPortal AI & Docs Shell · Documents & chat · 01 / Trigger & Portals · AIChatPanel AI & Docs Shell Documents & chat AIChatPanel Bank REST API · POST /bank-movements · 02 / REST API Endpoints · :id/reconcile Bank REST API POST /bank-movements :id/reconcile Finance REST API · POST /invoices/:id · 02 / REST API Endpoints · /allocate Finance REST API POST /invoices/:id /allocate Maintenance API · POST /portal/offer · 02 / REST API Endpoints · POST /triage, /award Maintenance API POST /portal/offer POST /triage, /award Docs & AI API · POST /upload, /chat · 02 / REST API Endpoints · POST /ai/compose Docs & AI API POST /upload, /chat POST /ai/compose Bank Matcher · SHA-256 & 0..1 Scorer · 03 / Process Engines · bank/matcher.js Bank Matcher SHA-256 & 0..1 Scorer bank/matcher.js Split Engine · 2-level & millesimi · 03 / Process Engines · financial/router.js Split Engine 2-level & millesimi financial/router.js Tender Engine · VAT 10/22% split · 03 / Process Engines · maintenance/router.js Tender Engine VAT 10/22% split maintenance/router.js OCR & AI Dispatch · FTS5 & 11-tool loop · 03 / Process Engines · ai/tools.js OCR & AI Dispatch FTS5 & 11-tool loop ai/tools.js Reconciliation DB · 1:1 match ledger · 04 / Durable Ledgers · bank_reconciliations Reconciliation DB 1:1 match ledger bank_reconciliations Allocations DB · FMs & categories · 04 / Durable Ledgers · invoice_allocations Allocations DB FMs & categories invoice_allocations Tender Bids DB · Quotes & offers · 04 / Durable Ledgers · maintenance_bid_offers Tender Bids DB Quotes & offers maintenance_bid_offers FTS5 Search DB · Extracted full-text · 04 / Durable Ledgers · document_text_fts FTS5 Search DB Extracted full-text document_text_fts Settled Balances · Condo & owner debts · 05 / Settlement & Audit · Balance Rollups Settled Balances Condo & owner debts Balance Rollups Consuntivo Matrix · Unit conguagli & lock · 05 / Settlement & Audit · Annual Closure Consuntivo Matrix Unit conguagli & lock Annual Closure Contract Awards · Contractor notices · 05 / Settlement & Audit · Procurement Award Contract Awards Contractor notices Procurement Award Activity Diary · Operational audit log · 05 / Settlement & Audit · activity_log Activity Diary Operational audit log activity_log upload statement CSV/PDF raw movements JSON batch match link reconciled settle payments balances allocate split exercise % compute share millesimi commit splits allocations render matrix conguagli submit quote magic token triage offers VAT 10/22% record bids quotes award tender notice file or query upload / chat run pipeline 11-tool RBAC index content virtual table audit trail activity log Legend primary data policy / PII data store data flow

Bank & Treasury Reconciliation

  • • Ingests multi-bank statements with configurable column mapping
  • • Generates SHA-256 deduplication hashes and 0..1 heuristic candidate scoring
  • • Commits 1:1 reconciliation links to rate installments and supplier invoices

Invoice Split & Consuntivo Matrix

  • • Lossless 2-level percentage splitter across financial management exercises
  • • Millesimal share distribution across units with personal charges and water meters
  • • Generates final balance sheet, owner conguagli, and locks closed exercises

Maintenance & Contractor Bidding

  • • Administrative triage board routing routine work orders vs competitive tenders
  • • Public magic-link contractor bidding portal with line items and VAT selection (10%/22%)
  • • Side-by-side quote comparison matrix with automated contract award dispatch

Document OCR & AI Agent Dispatcher

  • • Asynchronous PDF/DOCX text extraction into SQLite FTS5 virtual table for instant search
  • • Ollama/Gemma-4 tool-calling agent with 11 tenant-isolated database query functions
  • • Immutable append-only activity diary recording administrative actions and overrides