LoanIQ Export Guide

Smartflow extracts structured data from credit agreements and exports it to Finastra LoanIQ in a format ready for loan booking. This guide covers what data is exported, how fields map, and how to trigger and verify an export.

---

What Data Smartflow Sends to LoanIQ

Smartflow exports the following categories of extracted data:

Category	Fields (examples)	LoanIQ Destination
Borrower details	Legal name, jurisdiction, LEI, tax ID	Borrower profile / Customer master
Facility terms	Facility type, commitment amount, currency, tenor, maturity date	Facility setup
Pricing	Base rate, margin, all-in rate, day count convention, payment frequency	Pricing / Interest setup
Parties	Agent, arrangers, lenders, guarantors with roles and shares	Parties / Shares
Conditions precedent	CP line items, satisfaction status	Conditions / Checklist
Covenants	Type, threshold, testing frequency, calculation methodology	Covenant setup
Key dates	Signing date, effective date, first drawdown, maturity	Timeline / Calendar
Fees	Commitment fee, arrangement fee, utilisation fee	Fee setup

note

The export includes only fields that have been extracted and verified (either AI-confirmed at 95%+ confidence or human-reviewed). Unverified fields are excluded by default.

---

Field Mapping

Smartflow fields map to LoanIQ fields based on a configurable mapping table. The default mapping follows Finastra's standard LoanIQ field schema.

Sample Mappings

Smartflow Field	LoanIQ Field	LoanIQ Screen
borrower.legal_name	Customer.LegalName	Customer → Summary
facility.type	Facility.FacilityType	Facility → Summary
facility.commitment_amount	Facility.GlobalCurrentAmount	Facility → Summary
facility.currency	Facility.Currency	Facility → Summary
facility.maturity_date	Facility.MaturityDate	Facility → Summary
pricing.base_rate	Pricing.BaseRate	Facility → Pricing
pricing.margin	Pricing.Spread	Facility → Pricing
pricing.day_count	Pricing.DayCountConvention	Facility → Pricing
party.agent	Deal.AdminAgent	Deal → Parties
party.lender[].name	Lender.Name	Facility → Shares
party.lender[].share	Lender.ProRataShare	Facility → Shares
covenant.type	Covenant.Type	Facilities → Covenants
covenant.threshold	Covenant.Threshold	Facilities → Covenants

tip

Custom field mappings can be configured per institution. Contact your Smartflow implementation team to adjust mappings for non-standard LoanIQ configurations.

---

Export Format

Smartflow exports data in JSON format conforming to the Smartflow LoanIQ Integration Schema (v1.0).

{
  "export_id": "EXP-2026-001234",
  "document_id": "DOC-2026-005678",
  "timestamp": "2026-03-25T10:30:00Z",
  "schema_version": "1.0",
  "borrower": {
    "legal_name": "Acme Corporation Pte Ltd",
    "jurisdiction": "Singapore",
    "lei": "549300EXAMPLE000LEI01"
  },
  "facility": {
    "type": "Term Loan",
    "commitment_amount": 50000000,
    "currency": "USD",
    "maturity_date": "2029-03-25"
  },
  "pricing": {
    "base_rate": "SOFR",
    "margin_bps": 250,
    "day_count": "ACT/360"
  },
  "parties": [
    {
      "role": "Administrative Agent",
      "name": "Global Bank AG"
    },
    {
      "role": "Lender",
      "name": "Pacific Finance Ltd",
      "share_pct": 40.0
    }
  ]
}

The JSON payload is sent via Smartflow's integration API to your institution's LoanIQ middleware or direct import endpoint.

---

How to Trigger an Export

From the Smartflow UI

1. Open the document in the Extraction Review screen.
2. Ensure all required fields are verified (green checkmarks).
3. Click Export → LoanIQ in the top-right action bar.
4. Review the export summary showing fields to be sent.
5. Click Confirm Export.
6. Smartflow displays an export confirmation with:
   • Export ID
   • Timestamp
   • Number of fields exported
   • LoanIQ destination system

Automatic Export (if configured)

If your institution has enabled automatic export:

1. Once all required fields reach Verified status, Smartflow queues the export.
2. The export runs within 60 seconds.
3. A notification is sent to the assigned operations officer.

---

What Happens on Error

Error Type	Cause	What Smartflow Does
Connection timeout	LoanIQ endpoint unreachable	Retries 3 times at 30-second intervals, then marks export as Failed
Validation error	LoanIQ rejects a field value (e.g., invalid currency code)	Marks the specific field as Export Error, provides LoanIQ error message
Partial failure	Some fields accepted, others rejected	Marks accepted fields as Exported, rejected fields as Export Error
Schema mismatch	Export schema version incompatible with LoanIQ middleware	Logs error, alerts IT admin, export marked Failed

Resolving Export Errors

1. Navigate to the document's Export History tab.
2. Find the failed export and click View Details.
3. Review the error message for each failed field.
4. Correct the field value in Smartflow (if data issue) or contact IT (if system issue).
5. Click Retry Export to resend only the failed fields.

---

How to Verify Data Landed Correctly

In Smartflow

1. Navigate to Export History for the document.
2. Status should show Completed with a green checkmark.
3. Click the export to see field-level confirmation from LoanIQ.

In LoanIQ

1. Open the deal/facility corresponding to the exported document.
2. Verify key fields: borrower name, facility amount, maturity date, pricing.
3. Check the Audit Trail in LoanIQ for the Smartflow import event.

Reconciliation

Smartflow provides a reconciliation report (available under Export History → Reconciliation) that shows:

• Fields sent vs. fields received.
• Any value transformations applied during import.
• Timestamp comparison (Smartflow export time vs. LoanIQ receipt time).

warning

If discrepancies are found, do not manually edit LoanIQ fields. Instead, correct the data in Smartflow and re-export to maintain audit trail integrity.