SWIFT MT940 & ISO 20022 CAMT.053 Bank Statement to Reconciled Excel & ERP

Parse raw SWIFT MT940 (.sta) and ISO 20022 CAMT.053 (.xml) bank statements into structured opening/closing balances, IBAN extraction, debit/credit transactions, and a ready-to-open .xlsx ledger.

Why Makers Use This Blueprint: Treasury teams manually copy-paste cryptic :60F:, :61:, and :86: SWIFT MT940 bank tags every morning because Power Automate has no native banking statement parser.

Download Blueprint (.JSON) Test Live in Business Hub → Get Free Bearer Key (zl_...)

Cloud Flow Architecture (Trigger → Zetaleap → Destination)

STEP 01 • Zetaleap SFTP / Outlook

Fetch Morning MT940 / CAMT.053 File

Retrieve daily statement file from bank SFTP dropbox or treasury mailbox.

STEP 02 • Zetaleap Banking Engine

POST /api/hub/bank-statement

Validates balance math (Opening + Credits - Debits = Closing) and exports JSON + Base64 .xlsx.

STEP 03 • SharePoint & Power BI

Publish Cash Position Dashboard

Save reconciled Excel workbook and refresh Power BI executive cashflow dataset.

Power Automate HTTP Action Definition (POST /api/hub/bank-statement)

Replace zl_YOUR_API_KEY with your free Personal Access Token from /profile — or import the typed Custom Connector at /connectors.

{
  "type": "Http",
  "inputs": {
    "method": "POST",
    "uri": "https://zetaleap.com/api/hub/bank-statement",
    "headers": {
      "Authorization": "Bearer zl_YOUR_API_KEY",
      "Content-Type": "application/json"
    },
    "body": {
      "statementText": "@{outputs('Get_SFTP_Statement_Text')?['body']}",
      "generateExcel": true
    }
  }
}

Returned Dynamic Output Tokens

formataccountIbanopeningBalanceclosingBalanceisReconciledtransactions[]excelBase64

← All 12 Flow Templates