Demo 3.10: Finance & Accounting (Central Treasury Remittance & 3-Way Matching)

Functional Objective: Covers comprehensive financial management across Enterprise HQ, Regional Distribution Centers, and IROs. Features daily sales proceeds remittance to the Central Treasury Remittance Pool, automated 3-way matching (PO vs. GRN vs. Supplier Invoice), payment voucher generation, imprest cash registers, bank reconciliation, multi-entity general ledger, and GST/Excise accounting on TigerBeetle.

🎥 Video Walkthrough & Feature Tour

Automated 3-Way Matching, Central Treasury Daily Remittance & Multi-Leg GL

Demonstrates automated PO-GRN-Invoice matching, daily treasury remittance voucher to Central Treasury, vendor payment run, and TigerBeetle GL balance audit.

📋 Core Functional Capabilities

Central Treasury Remittance Pool Daily Remittance: Automated consolidation of daily sales across 34 regional distribution centers and remittance voucher creation into the government treasury.
Automated 3-Way Matching: Tolerance-based verification between PO quantities/rates, Distribution Center GRN received counts, and Supplier e-Invoice figures.
Imprest Cash & Budgeting: Sub-ledger tracking of distribution center operational imprest accounts, expense claims, and cost center budget utilization.
Taxation & Compliance: Automated GSTR-1, GSTR-3B return generation, state-wise regulated commodities excise duty accounting, and quantitative discount (QD) disbursements.
Document Lifecycle Management: Comprehensive submission workflows with controlled amend/cancel procedures for audit adjustments and reconciliation.

🏗️ Technical Architecture & DocType Mapping

In Business M and Framework M, this domain is powered by native, metadata-driven DocTypes, async controllers, and distributed ledger adapters:

Active Business M DocTypes

PurchaseInvoice, SalesInvoice, PaymentVoucher, PaymentReceipt, JournalEntry, Account, CostCenter, Budget, ImprestRequisition, BankReconciliation, EInvoice, GSTReturn

graph LR
    User["Stakeholder Portal / Desk"] --> Gateway["API Gateway"]
    Gateway --> Controller["Domain Controller & RBAC"]
    Controller --> DB[("PostgreSQL / RLS Master")]
    Controller --> Relay["Outbox Relay Worker"]
    Relay --> TB[("TigerBeetle Immutable Ledger")]

🧪 Verifiable Test Script (Human Review Flow)

Follow these steps in the running Business M instance to replicate the live PoC demonstration (mapped directly from end-to-end test automation):

Open Supplier Bill from: Apex Enterprise Supplies

✅ Action: Submit Document

Automated 3-Way Match: PO rate, GRN qty, Invoice amount
Invoice auto-advances to ‘Approved: for Payment’ after match
Create Payment Voucher against: approved supplier invoice

✅ Action: Submit Document

Submit Payment Voucher: verify TigerBeetle ledger entries
Create Daily Central Treasury: Remittance Voucher for aggregated distribution center sales

✅ Action: Submit Document
📝 Action: Amend Document
✅ Action: Submit Document
❌ Action: Cancel Document

Auto-reconcile bank statement via: BankReconciliation
Verify budget consumption and: available balances across cost centers
Verify GSTR-1 and GSTR-3B: summary numbers match ledger