AI Systems Architecture · Finance

Four finance pipelines, architected for control.

Reference architectures for the close, the plan, the cash and the board pack. Managed services, Claude Code intelligence cores and custom code, governed end to end by the F3i Command Center.

CONTINUOUS CLOSE · ROLLING FORECAST · CASH INTELLIGENCE · BOARD REPORTING
DETERMINISTIC · AUDITABLE · HUMAN-IN-THE-LOOP
The visual grammar

How to read these diagrams

Managed service
Solid navy. The platforms we configure and run: the governed data warehouse, finance ledgers, orchestration and collaboration.
Claude Code intelligence core
Gold. The reasoning layer that analyzes, reconciles, forecasts and drafts, always under guardrails.
Custom code
Dashed. Purpose-built connectors, parsers, calculations and checks owned by the client.
F3i Command Center
The base band of every pipeline. Governs the flow and feeds monthly, quarterly and ad hoc reporting.
Use Case 01

Continuous Close & Reconciliation

Compress days-to-close and surface anomalies before they reach the GL. Reconciliation runs continuously, not in a month-end scramble.

Data warehouse · SQL / Postgres
Claude Code · MS Teams
ERP & bank connectors
Sources Systems of record
ERP / GL (QuickBooks, NetSuite, Sage, SAP, etc.)
AR & AP sub-ledgers
Bank feeds
Close schedules (Sheets)
Ingest
Stage A Ingest & normalize
Custom codeERP & bank connectorsExtract, map to chart of accounts, stage to warehouse
Reconcile
Stage B Reconcile & detect
Claude Code coreReconciliation & anomaly coreMatches transactions, flags variances and outliers with explanations
Review
Stage C Review & approve
Custom codeException workflowRoutes only true exceptions to a humanHuman sign-off
Govern & report
Governance & orchestration
F3i Command Center
Controls the pipeline, holds the audit trail, schedules every run.
feeds →
Monthly
Close pack & reconciliation status
Quarterly
Flux analysis & control review
Ad hoc
Anomaly & exception alerts
Use Case 02

Rolling Forecast & Scenario Planning

Driver-based rolling forecasts and scenarios on demand, with every assumption traceable to its source. The plan rebuilds itself as actuals land.

Data warehouse · SQL / Postgres
Claude Code · HubSpot
Datarails (downstream)
Sources Actuals & drivers
Actuals (data warehouse)
Pipeline (HubSpot)
Headcount & plan (Sheets)
Operational drivers
Consolidate
Stage A Consolidate actuals & drivers
Custom codeDriver ingestionNormalizes operational inputs into model drivers
Model
Stage B Model & forecast
Claude Code coreDriver-model & scenario coreBuilds rolling forecasts, prices what-if scenarios, explains the delta
Custom codeAssumption registryEvery input logged with source and owner
Validate
Stage C Validate & version
Custom codeBack-test & bias checkScores accuracy against prior forecastsHuman sign-off
Govern & report
Governance & orchestration
F3i Command Center
Locks versions, traces assumptions, schedules the re-forecast.
feeds →
Monthly
Forecast vs actual & variance
Quarterly
Board scenarios & guidance
Ad hoc
What-if & sensitivity runs
Use Case 03

AR / AP & Cash Flow Intelligence

Prioritized collections, smarter payables timing and a live 13-week cash view. Working capital managed proactively, not reactively.

Data warehouse · SQL / Postgres
Claude Code · MS Teams
Invoice & email parsers
Sources Receivables, payables & cash
AR aging
AP & vendor invoices
Bank balances
Customer emails
Ingest & parse
Stage A Ingest invoices & aging
Custom codeInvoice & email parsersExtracts terms, amounts and intent from documents and threads
Score & prioritize
Stage B Score, prioritize & forecast
Claude Code coreCollections & payment-timing coreRanks collections effort, recommends payment timing
Claude Code core13-week cash coreBuilds a rolling direct cash forecast with drivers
Act
Stage C Act with oversight
Custom codeCollections outreach draftsPrepares messages for review, never auto-sendsHuman sign-off
Govern & report
Governance & orchestration
F3i Command Center
Sequences the runs, enforces approval before any outreach.
feeds →
Monthly
AR / AP & collections review
Quarterly
Working-capital strategy
Ad hoc
Cash & liquidity alerts
Use Case 04

Board & Management Reporting

Board-ready packs and narrative generated from governed data, every figure tied out and traceable. The pack assembles itself, the CFO signs it.

Data warehouse · Board pack
Claude Code · MS Teams
Excel · Power BI · PowerPoint
Sources Governed finance data
Close pack (UC 01)
Forecast versions (UC 02)
Cash view (UC 03)
KPI definitions
Assemble
Stage A Assemble governed dataset
Custom codeKPI & flux calculationsDeterministic metric logic, defined once
Generate
Stage B Generate analysis & narrative
Claude Code coreReporting & narrative coreDrafts commentary and analysis from the governed numbers only
Custom codeTie-out & citation checkEvery figure links back to its source row
Review & publish
Stage C Review & publish
Govern & report
Governance & orchestration
F3i Command Center
Holds the citation trail so every number is defensible.
feeds →
Monthly
Management reporting pack
Quarterly
Board deck & narrative
Ad hoc
Investor & lender requests