Skip to content

Import bank reconciliation data

POST/finance/bank-reconciliation/import

Imports a bank statement reconciliation payload for a given account and period. The payload should contain a 'lines' array of statement entries and a 'source' identifier. The system automatically counts lines and records the import timestamp.

Request

Request body

Content type application/json (required).

FieldTypeRequiredDescription
account_referencestringYes

The bank account identifier or reference code (e.g. "GT-BANK-001").

Max length: 120

periodstringYes

Accounting period in YYYY-MM format (e.g. "2026-03").

Max length: 24

statusstringNo

Initial status of this reconciliation record. Defaults to 'imported'.

Default: "imported" · Max length: 24

import_payload_jsonstringYes

JSON-encoded object containing a 'lines' array of statement rows and a 'source' string identifying the data origin (e.g. "bank_csv").

Example

{
  "account_reference": "GT-BANK-001",
  "period": "2026-03",
  "status": "imported",
  "import_payload_json": "{\"source\":\"bank_csv\",\"lines\":[{\"date\":\"2026-03-01\",\"description\":\"Transfer\",\"amount\":5000},{\"date\":\"2026-03-15\",\"description\":\"Payment\",\"amount\":-1200}]}"
}

Responses

302 Redirect to the finance ops index after successful import

422 Validation error — account_reference, period, and import_payload_json are required

Content type application/json, any.

Example

{
  "errors": {
    "account_reference": [
      "The account reference field is required."
    ],
    "import_payload_json": [
      "The import payload json field is required."
    ]
  }
}

Example request

curl -X POST "https://{tenant}.faciotech.net/api/v1/finance/bank-reconciliation/import" \
  -H "Accept: application/json" \
  -H "Content-Type: application/json" \
  -d '{"account_reference": "GT-BANK-001", "period": "2026-03", "status": "imported", "import_payload_json": "{\"source\":\"bank_csv\",\"lines\":[{\"date\":\"2026-03-01\",\"description\":\"Transfer\",\"amount\":5000},{\"date\":\"2026-03-15\",\"description\":\"Payment\",\"amount\":-1200}]}"}'
Loading