Bank Statement Ingestion & Reconciliation

Bank Statement Ingestion & Reconciliation A data-flow diagram generated by Archify. 01 / Sources 02 / Ingest 03 / Process 04 / Store 05 / Consume Bank Portals · CSV, XML, OFX, PDF · 01 / Sources · External Feeds Bank Portals CSV, XML, OFX, PDF External Feeds Ledger Targets · Installments & Invoices · 01 / Sources · Open Receivables Ledger Targets Installments & Invoices Open Receivables Upload Facade · MinIO S3 Storage · 02 / Ingest · Multer :3005 Upload Facade MinIO S3 Storage Multer :3005 Mapping Config · Header preview & format · 02 / Ingest · bank_csv_mappings Mapping Config Header preview & format bank_csv_mappings Movement Parser · Delimiters & SHA-256 · 03 / Process · Deduplication Movement Parser Delimiters & SHA-256 Deduplication Heuristic Matcher · Amount, Date & Name · 03 / Process · Score 0..1 Heuristic Matcher Amount, Date & Name Score 0..1 Bank Movements · Normalized ledger · 04 / Store · bank_movements Bank Movements Normalized ledger bank_movements Reconciliations · Audit & links · 04 / Store · bank_reconciliations Reconciliations Audit & links bank_reconciliations Payment Records · FM payments / invoices · 04 / Store · Marked Paid Payment Records FM payments / invoices Marked Paid Reconcile UI · Admin review & undo · 05 / Consume · Matched / Unmatched · React Reconcile UI Admin review & undo Matched / Unmatched Financial Balances · Per-condo & owner tiles · 05 / Consume · Rollup Engine Financial Balances Per-condo & owner tiles Rollup Engine statement upload raw files sniff delimiter metadata apply column map normalized idempotent insert persisted scored batch movements candidate pool receivables confirmed match audit link create payment settled status status inline read model settled balance aggregates Legend primary data policy / PII data store data flow

Ingestion & Normalization

  • • Uploads saved to MinIO; auto-sniffs delimiters and formats
  • • Generates SHA-256 movement hashes to prevent duplicate booking

Heuristic Matching Engine

  • • 0..1 scoring across exact amount, ±3d date, and fuzzy name
  • • Distinguishes credit installments from debit supplier invoices

Atomic Settlement & Rollups

  • • Atomic reconciliation links and payment status updates
  • • Propagates real-time settled balances to owner and condo tiles