Skip to main content

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:

  • Borrower details - Legal name, jurisdiction, LEI, and tax ID for borrower or customer records.
  • Facility terms - Facility type, commitment amount, currency, tenor, and maturity date for facility setup.
  • Pricing - Base rate, margin, all-in rate, day count convention, and payment frequency.
  • Parties - Agent, arrangers, lenders, guarantors, roles, and shares.
  • Conditions precedent - CP line items and satisfaction status.
  • Covenants - Covenant type, threshold, testing frequency, and calculation method.
  • Key dates - Signing date, effective date, first drawdown, and maturity.
  • Fees - Commitment, arrangement, and utilisation fees.
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​

Common examples include:

  • borrower.legal_name maps to Customer.LegalName on the Customer Summary screen.
  • facility.type, facility.commitment_amount, facility.currency, and facility.maturity_date map to the Facility Summary screen.
  • pricing.base_rate, pricing.margin, and pricing.day_count map to Facility Pricing.
  • party.agent, party.lender[].name, and party.lender[].share map to Deal Parties or Facility Shares.
  • covenant.type and covenant.threshold map to 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. The payload includes an export ID, document ID, timestamp, schema version, and the verified borrower, facility, pricing, party, covenant, fee, and date fields in scope.

The 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​

  • Connection timeout - Smartflow retries when the LoanIQ endpoint is unreachable, then marks the export as failed if retry does not recover.
  • Validation error - Smartflow marks the specific field as an export error and shows the LoanIQ error message.
  • Partial failure - Smartflow marks accepted fields as exported and rejected fields as export errors.
  • Schema mismatch - Smartflow logs the error, alerts the IT administrator, and marks the export as 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.