Bulk import transactions from CSV | Open Ledger Documentation

Upload a CSV file to create multiple transactions for an external bank account

AuthorizationBearer

Bearer authentication of the form Bearer <token>, where token is your auth token.

entityIdstringRequired

The ID of the entity to import transactions for

connectionTypeenumRequired

Must be EXTERNAL for CSV imports

Allowed values:

accountIdstringRequired

The ID of the external bank account to import transactions for

This endpoint expects a multipart form containing an optional file.

csvFilefileOptional

CSV file with Date, Description, Amount columns

Bulk import job created successfully

messagestring

jobIdstring

Unique job identifier for tracking progress

totalRowsinteger

Total number of rows to process

statusenum

Initial job status

Allowed values:

400

Bad Request Error

404

Not Found Error

500

Internal Server Error

1	curl -X POST "https://api-staging.openledger.com/v1/transactions/import?entityId=entityId&connectionType=EXTERNAL&accountId=accountId" \
2	-H "Authorization: Bearer <token>" \
3	-H "Content-Type: multipart/form-data" \
4	-F csvFile=@<file1>

1	{
2	"message": "CSV import job created successfully",
3	"jobId": "string",
4	"totalRows": 1,
5	"status": "PENDING"
6	}