Bank Statement to Excel
aiConvert a bank-statement PDF into a clean Excel workbook (or CSV, or JSON rows): one row per transaction with date, narration, reference, debit, credit and balance, plus a summary sheet with the account, period, opening and closing balance and totals. The reading is checked against the statement's own running balance, so the rows add up. Works across Indian banks without per-bank templates. Digital PDFs from net banking only, not scans. The file comes back base64-encoded with its file name.
POST /gw/v1/bank-statement-to-excel-v1/SLA p95: 30000 ms
Authentication
Pass your key in the X-API-Key header. Use a test_ key against the sandbox and a live_ key in production. Send an optional Idempotency-Key header to safely retry — the same key returns the same response for 24h.
X-API-Key: live_xxxxxxxxxxxx
Request
Endpoint: POST https://apisathi.in/gw/v1/bank-statement-to-excel-v1/
The trailing slash is required. /v1/bank-statement-to-excel-v1/ works; /v1/bank-statement-to-excel-v1 returns 404 Not Found. This applies to every product.
| Field | Type | Required | Constraints |
|---|---|---|---|
| pdf_base64 | string | required | Base64-encoded bank-statement PDF (digital, not a scan). Max 15 MB. |
| password | string | optional | PDF password, if the statement is locked. |
| format | string | optional | Default xlsx. |
Code snippets
curl -X POST https://apisathi.in/gw/v1/bank-statement-to-excel-v1/ \
-H "X-API-Key: $API_SATHI_KEY" \
-H "Content-Type: application/json" \
-H "Idempotency-Key: $(uuidgen)" \
-d '{"pdf_base64":"<base64 of the statement PDF>","format":"xlsx"}'Response
| Field | Type | Required | Constraints |
|---|---|---|---|
| account | object | optional | — |
| period | object | optional | — |
| opening_balance | number | optional | — |
| closing_balance | number | optional | — |
| currency | string | optional | — |
| transaction_count | integer | optional | — |
| format | string | optional | — |
| file_name | string | optional | — |
| content_type | string | optional | — |
| file_base64 | string | optional | — |
| transactions | array | optional | — |
| meta | object | optional | — |
Sample response
{
"account": {
"account_holder": null,
"account_number": "XXXX7890",
"bank": null,
"ifsc": "SAMP0001234",
"account_type": null
},
"period": {
"from": "2026-04-01",
"to": "2026-04-30"
},
"opening_balance": 10000,
"closing_balance": 34620,
"currency": "INR",
"transaction_count": 5,
"format": "xlsx",
"meta": {
"engine": "apisathi-statement-export-v1",
"pages": 1
},
"file_name": "statement_20260401_20260430.xlsx",
"content_type": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
"file_base64": "UEsDBAoAAAAIAK8aUl3qc8NaXAEAAHgFAAATAAAA…"
}Reading a 400
A schema rejection returns INVALID_REQUEST with a details array naming the exact field. Read it before guessing — it gives you the JSON path and what was wrong with it.
{
"error": {
"code": "INVALID_REQUEST",
"message": "Request body failed schema validation",
"details": [
{ "path": "/callback_url",
"message": "unexpected property 'callback_url' — this endpoint does not accept unknown fields" }
]
}
}Most endpoints reject unknown top-level fields outright, so an extra key you added for your own bookkeeping will fail the call. Enum errors list the accepted values, and a missing required field is named with its full path.
Error codes
| Code | HTTP | When |
|---|---|---|
| INVALID_INPUT | 422 | The request was rejected as invalid — either it failed OUR schema validation (malformed input; not charged), or the upstream source rejected the value you sent. NOTE: an identifier that is well-formed but simply has NO RECORD is no longer an error — it returns 200 with `verified: false` and is charged (see the result-code table below). FIX the input before retrying; retrying the same value will fail again. |
| INVALID_API_KEY | 401 | Missing, malformed, or revoked X-API-Key. |
| OUT_OF_SCOPE | 403 | API key is not scoped for this product. |
| INSUFFICIENT_BALANCE | 402 | Wallet balance is below the per-call sale price. Recharge and retry. |
| RATE_LIMITED | 429 | Per-key RPS or RPM limit exceeded. Back off and retry after the Retry-After header. |
| PRODUCT_DEPRECATED | 410 | This API has been retired and is no longer available. Stop calling it — it will not return. Check the catalog for the current equivalent. |
| ROUTER_NO_VENDOR | 503 | No healthy vendor is currently available for this product. Transient — safe to retry after a short backoff. Not charged. |
| VENDOR_AUTH_FAILED | 502 | Upstream vendor rejected our credentials (our config issue). Not charged. |
| VENDOR_ERROR | 502 | A genuine transient upstream error (the source was briefly unavailable). Safe to RETRY after a short backoff. Not charged. NOTE: this is NOT for bad input — invalid values return 422 INVALID_INPUT, not 502. |
| TIMEOUT | 504 | Upstream vendor did not respond within the SLA window. Safe to retry after a short backoff. Not charged. |
| INVALID_INPUT | 422 | The PDF could not be read: scanned, password-protected without the password, or a layout we cannot prove against its running balance. Not charged. |
OpenAPI 3.1
Generated from this product's request/response JSON Schemas.
{
"openapi": "3.1.0",
"info": {
"title": "API Sathi — Bank Statement to Excel",
"version": "1.0.0",
"description": "Convert a bank-statement PDF into a clean Excel workbook (or CSV, or JSON rows): one row per transaction with date, narration, reference, debit, credit and balance, plus a summary sheet with the account, period, opening and closing balance and totals. The reading is checked against the statement's own running balance, so the rows add up. Works across Indian banks without per-bank templates. Digital PDFs from net banking only, not scans. The file comes back base64-encoded with its file name."
},
"servers": [
{
"url": "https://apisathi.in/gw/v1"
}
],
"components": {
"securitySchemes": {
"ApiKeyAuth": {
"type": "apiKey",
"in": "header",
"name": "X-API-Key",
"description": "Your live or test key, e.g. `live_xxxxxxxxxxxx`."
}
}
},
"paths": {
"/bank-statement-to-excel-v1": {
"post": {
"operationId": "bankStatementToExcelV1",
"tags": [
"ai"
],
"summary": "Bank Statement to Excel",
"description": "Convert a bank-statement PDF into a clean Excel workbook (or CSV, or JSON rows): one row per transaction with date, narration, reference, debit, credit and balance, plus a summary sheet with the account, period, opening and closing balance and totals. The reading is checked against the statement's own running balance, so the rows add up. Works across Indian banks without per-bank templates. Digital PDFs from net banking only, not scans. The file comes back base64-encoded with its file name.",
"security": [
{
"ApiKeyAuth": []
}
],
"parameters": [
{
"name": "Idempotency-Key",
"in": "header",
"required": false,
"schema": {
"type": "string"
},
"description": "Optional. Same key returns the same response for 24h."
}
],
"requestBody": {
"required": true,
"content": {
"application/json": {
"schema": {
"type": "object",
"required": [
"pdf_base64"
],
"properties": {
"pdf_base64": {
"type": "string",
"description": "Base64-encoded bank-statement PDF (digital, not a scan). Max 15 MB."
},
"password": {
"type": "string",
"description": "PDF password, if the statement is locked."
},
"format": {
"type": "string",
"enum": [
"xlsx",
"csv",
"json"
],
"description": "Default xlsx."
}
},
"additionalProperties": false
},
"example": {
"pdf_base64": "<base64 of the statement PDF>",
"format": "xlsx"
}
}
}
},
"responses": {
"200": {
"description": "Successful, normalized response.",
"content": {
"application/json": {
"schema": {
"type": "object",
"properties": {
"account": {
"type": "object"
},
"period": {
"type": "object"
},
"opening_balance": {
"type": "number"
},
"closing_balance": {
"type": "number"
},
"currency": {
"type": "string"
},
"transaction_count": {
"type": "integer"
},
"format": {
"type": "string"
},
"file_name": {
"type": "string"
},
"content_type": {
"type": "string"
},
"file_base64": {
"type": "string"
},
"transactions": {
"type": "array"
},
"meta": {
"type": "object"
}
}
},
"example": {
"account": {
"account_holder": null,
"account_number": "XXXX7890",
"bank": null,
"ifsc": "SAMP0001234",
"account_type": null
},
"period": {
"from": "2026-04-01",
"to": "2026-04-30"
},
"opening_balance": 10000,
"closing_balance": 34620,
"currency": "INR",
"transaction_count": 5,
"format": "xlsx",
"meta": {
"engine": "apisathi-statement-export-v1",
"pages": 1
},
"file_name": "statement_20260401_20260430.xlsx",
"content_type": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
"file_base64": "UEsDBAoAAAAIAK8aUl3qc8NaXAEAAHgFAAATAAAA…"
}
}
}
},
"401": {
"description": "Missing, malformed, or revoked X-API-Key.",
"content": {
"application/json": {
"schema": {
"type": "object",
"properties": {
"error": {
"type": "object",
"properties": {
"code": {
"type": "string"
},
"message": {
"type": "string"
},
"call_id": {
"type": "string"
}
}
}
}
}
}
}
},
"402": {
"description": "Wallet balance is below the per-call sale price. Recharge and retry.",
"content": {
"application/json": {
"schema": {
"type": "object",
"properties": {
"error": {
"type": "object",
"properties": {
"code": {
"type": "string"
},
"message": {
"type": "string"
},
"call_id": {
"type": "string"
}
}
}
}
}
}
}
},
"403": {
"description": "API key is not scoped for this product.",
"content": {
"application/json": {
"schema": {
"type": "object",
"properties": {
"error": {
"type": "object",
"properties": {
"code": {
"type": "string"
},
"message": {
"type": "string"
},
"call_id": {
"type": "string"
}
}
}
}
}
}
}
},
"410": {
"description": "This API has been retired and is no longer available. Stop calling it — it will not return. Check the catalog for the current equivalent.",
"content": {
"application/json": {
"schema": {
"type": "object",
"properties": {
"error": {
"type": "object",
"properties": {
"code": {
"type": "string"
},
"message": {
"type": "string"
},
"call_id": {
"type": "string"
}
}
}
}
}
}
}
},
"422": {
"description": "The request was rejected as invalid — either it failed OUR schema validation (malformed input; not charged), or the upstream source rejected the value you sent. NOTE: an identifier that is well-formed but simply has NO RECORD is no longer an error — it returns 200 with `verified: false` and is charged (see the result-code table below). FIX the input before retrying; retrying the same value will fail again.",
"content": {
"application/json": {
"schema": {
"type": "object",
"properties": {
"error": {
"type": "object",
"properties": {
"code": {
"type": "string"
},
"message": {
"type": "string"
},
"call_id": {
"type": "string"
}
}
}
}
}
}
}
},
"429": {
"description": "Per-key RPS or RPM limit exceeded. Back off and retry after the Retry-After header.",
"content": {
"application/json": {
"schema": {
"type": "object",
"properties": {
"error": {
"type": "object",
"properties": {
"code": {
"type": "string"
},
"message": {
"type": "string"
},
"call_id": {
"type": "string"
}
}
}
}
}
}
}
},
"502": {
"description": "Upstream vendor rejected our credentials (our config issue). Not charged.",
"content": {
"application/json": {
"schema": {
"type": "object",
"properties": {
"error": {
"type": "object",
"properties": {
"code": {
"type": "string"
},
"message": {
"type": "string"
},
"call_id": {
"type": "string"
}
}
}
}
}
}
}
},
"503": {
"description": "No healthy vendor is currently available for this product. Transient — safe to retry after a short backoff. Not charged.",
"content": {
"application/json": {
"schema": {
"type": "object",
"properties": {
"error": {
"type": "object",
"properties": {
"code": {
"type": "string"
},
"message": {
"type": "string"
},
"call_id": {
"type": "string"
}
}
}
}
}
}
}
},
"504": {
"description": "Upstream vendor did not respond within the SLA window. Safe to retry after a short backoff. Not charged.",
"content": {
"application/json": {
"schema": {
"type": "object",
"properties": {
"error": {
"type": "object",
"properties": {
"code": {
"type": "string"
},
"message": {
"type": "string"
},
"call_id": {
"type": "string"
}
}
}
}
}
}
}
}
}
}
}
}
}