How EFIS Works: From Raw Data to Traceable Intelligence
Follow the exact 4-step operational path EFIS uses to process financial records safely and transparently without altering certified accounting systems.
Non-Negotiable Accounting Boundaries
EFIS Does Not Overwrite Accounting History
EFIS is a read-only intelligence layer. It never posts journal entries, alters invoice records, executes payments, or overwrites certified General Ledger history in your QuickBooks Online accounting software.
Client Responsibility for Business Decisions
The client remains solely responsible for accounting, tax filings, legal compliance, credit decisions, cash management, and final business actions. EFIS provides decision support, not regulated advice.
Data Ingestion & Mapping
Connect QuickBooks Online or Upload CSV Files
EFIS ingests financial records from QuickBooks Online via secure OAuth2 API sync, or accepts structured CSV file uploads (Chart of Accounts, Customers, Vendors, Invoices, Payments, GL Journal Entries).
Implementation Specs & Safeguards:
- Interactive column mapping UI for custom CSV schemas
- Supports standard double-entry General Ledger structures
- Encrypted tenant-scoped file storage in AWS S3
- Preserves raw source file checksums and timestamp metadata
Validation & Financial Truth Check
Automated General Ledger Integrity Engine
Before any financial metric or forecast is computed, EFIS runs a deterministic validation suite checking for trial balance equality, missing account references, orphan records, and date format integrity.
Implementation Specs & Safeguards:
- Calculates an explicit Data Quality (DQ) score for each upload
- Flags unmapped transactions or period imbalances immediately
- Computes SHA-256 integrity hashes for accounting line items
- Prevents corrupt or incomplete files from polluting reporting
Intelligence & Forecast Calculation
Deterministic KPIs & Multi-Horizon Forecasts
EFIS computes 11 core financial metrics (EBITDA, Cash Runway, Working Capital, DSO, DPO, AR Overdue %, Concentration Risks) and generates 30/90/180/365-day cash forecasts across Base, Optimistic, and Pessimistic scenarios.
Implementation Specs & Safeguards:
- 15-minute TTL Redis caching for sub-second dashboard loading
- Proactive liquidity shortage alerts with severity classification
- Customer and vendor credit risk scoring (0–100 scale)
- pgvector embedding generation for RAG-based AI search
Governed Review & Actionable Insights
AI CFO Q&A with Refusal Boundaries & Audit Logs
Finance leaders interact with reports, dashboards, and the AI CFO. Every AI answer cites specific source records, provides reasoning steps, and refuses to answer if evidence is missing.
Implementation Specs & Safeguards:
- Human review warning mandatory on all AI outputs
- Immutable append-only access and AI query audit logs (7-year retention)
- Assumption registry for recording manual forecast overrides
- Role-based sign-offs for month-end close workpapers