Bank Imports

List transactions inside a bank import

Returns all transactions for the given import, including reconciliation status, counterparty info, amounts, and any matched invoice / expense / revenue. Drives the reconciliation workflow.

get/bank-imports/{id}/transactions

Request

  • Base URL: https://api.lumabill.ch/v1
  • URL: https://api.lumabill.ch/v1/bank-imports/{id}/transactions
  • Auth: HTTP bearer

Query parameters

status'MATCHED' | 'UNMATCHED' | 'CATEGORIZED' | 'IGNORED'

Filter by reconciliation status

Response

Transactions for this import

idstring uuid required
transactionDatestring date required
valueDatestring date nullable
amountnumber double required

Always positive; use direction to know if it is a credit or debit

currency'CHF' | 'EUR' | 'USD' | 'GBP' | 'JPY' | 'CAD' | 'AUD' | 'SEK' | 'NOK' | 'DKK' | 'HUF' required

ISO 4217 code of a currency the API converts (ESTV/BAZG rates). The same list applies to every currency field of the API.

originalAmountnumber double nullable

Amount in the original currency when the bank converted the payment (CAMT CcyXchg)

originalCurrency'CHF' | 'EUR' | 'USD' | 'GBP' | 'JPY' | 'CAD' | 'AUD' | 'SEK' | 'NOK' | 'DKK' | 'HUF'

ISO 4217 code of a currency the API converts (ESTV/BAZG rates). The same list applies to every currency field of the API.

fxRatenumber double nullable

Exchange rate reported by the bank statement (CAMT CcyXchg)

direction'CREDIT' | 'DEBIT' required
creditorNamestring nullable
debtorNamestring nullable
referencestring nullable
remittanceInfostring nullable
status'MATCHED' | 'UNMATCHED' | 'CATEGORIZED' | 'IGNORED' required
matchedInvoiceIdstring uuid nullable
matchedInvoiceNumberstring nullable
matchedInvoiceStatusstring nullable
matchedInvoiceCurrency'CHF' | 'EUR' | 'USD' | 'GBP' | 'JPY' | 'CAD' | 'AUD' | 'SEK' | 'NOK' | 'DKK' | 'HUF'

ISO 4217 code of a currency the API converts (ESTV/BAZG rates). The same list applies to every currency field of the API.

matchedExpenseIdstring uuid nullable
matchedExpenseVendorstring nullable
matchedExpenseDescriptionstring nullable
matchedExpenseAmountnumber double nullable
matchedExpenseCurrency'CHF' | 'EUR' | 'USD' | 'GBP' | 'JPY' | 'CAD' | 'AUD' | 'SEK' | 'NOK' | 'DKK' | 'HUF'

ISO 4217 code of a currency the API converts (ESTV/BAZG rates). The same list applies to every currency field of the API.

matchedRevenueIdstring uuid nullable
matchedRevenuePayerstring nullable
matchedRevenueDescriptionstring nullable
matchedRevenueAmountnumber double nullable
matchedRevenueCurrency'CHF' | 'EUR' | 'USD' | 'GBP' | 'JPY' | 'CAD' | 'AUD' | 'SEK' | 'NOK' | 'DKK' | 'HUF'

ISO 4217 code of a currency the API converts (ESTV/BAZG rates). The same list applies to every currency field of the API.

counterpartyIbanstring nullable

IBAN of the other side (CAMT, or a mapped CSV column); used to pair transfers between your own bank accounts

transferCounterpartIdstring uuid nullable

For a booked transfer between two own bank accounts: the bank transaction of the other leg (both share one journal entry)

aiSuggestionobject nullable
journalEntryIdstring uuid nullable

Posted journal entry, present once the transaction is reconciled

createdAtstring date-time

Example response

[
  {
    "amount": 1296,
    "currency": "CHF",
    "originalCurrency": "CHF",
    "matchedInvoiceCurrency": "CHF",
    "matchedInvoices": [
      {
        "currency": "CHF"
      }
    ],
    "matchedExpenses": [
      {
        "currency": "CHF"
      }
    ],
    "matchedExpenseCurrency": "CHF",
    "matchedRevenueCurrency": "CHF",
    "adjustments": [
      {
        "description": "Bank fee",
        "amount": 5
      }
    ]
  }
]

Changes

No recorded changes to this operation across all 1 revision of this API.