Financial · Live
Bank Statement to Excel API
Bank statement PDF in, clean spreadsheet out.
What the Bank Statement to Excel API does
The Bank Statement to Excel API converts a bank-statement PDF into a clean Excel workbook, 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 balances.
Popular use cases
- →Credit appraisal and loan file preparation
- →Accounting and bookkeeping imports
- →Audit and reconciliation work
curl -X POST https://apisathi.in/gw/v1/bank-statement-to-excel-v1/ \
-H "X-API-Key: live_xxx" \
-H "Content-Type: application/json" \
-d '{ "pdf_base64": "<base64 of the statement PDF>", "format": "xlsx" }'{
"account": {
"account_number": "XXXX7890",
"ifsc": "SAMP0001234"
},
"period": {
"from": "2026-04-01",
"to": "2026-04-30"
},
"opening_balance": 10000,
"closing_balance": 34620,
"transaction_count": 5,
"format": "xlsx",
"file_name": "statement_20260401_20260430.xlsx"
}Response fields returned by the Bank Statement to Excel API
| Field | Example |
|---|---|
| account.account_number | XXXX7890 |
| account.ifsc | SAMP0001234 |
| period.from | 2026-04-01 |
| period.to | 2026-04-30 |
| opening_balance | 10000 |
| closing_balance | 34620 |
| transaction_count | 5 |
| format | xlsx |
| file_name | statement_20260401_20260430.xlsx |
Every field, error code and the full schema are in the Bank Statement to Excel API reference.
Call the Bank Statement to Excel API from Node.js or Python
const res = await fetch('https://apisathi.in/gw/v1/bank-statement-to-excel-v1/', {
method: 'POST',
headers: { 'X-API-Key': process.env.APISATHI_KEY, 'Content-Type': 'application/json' },
body: JSON.stringify({"pdf_base64":"<base64 of the statement PDF>","format":"xlsx"}),
});
const data = await res.json();import os, requests
res = requests.post(
"https://apisathi.in/gw/v1/bank-statement-to-excel-v1/",
headers={"X-API-Key": os.environ["APISATHI_KEY"]},
json={"pdf_base64":"<base64 of the statement PDF>","format":"xlsx"},
timeout=30,
)
data = res.json()Bank Statement to Excel API pricing
- → From ₹10 per successful call + 18% GST
- → Prepaid wallet from ₹200; no monthly fee, no minimum volume
- → Failed or timed-out calls are not charged
- → Bonus credit on recharges of ₹1,000 and above; GST invoice on every recharge
Start in four steps
- Create a free account — about a minute.
- Call the Bank Statement to Excel API with your TEST key in the sandbox, free.
- Recharge the wallet (UPI, card or netbanking) from ₹200.
- Switch to your LIVE key — the same key works for every API.
Frequently asked questions
Which output formats are supported?
Excel (xlsx), CSV or JSON rows.
Do you also analyse the statement?
Yes — the Bank Statement Analysis and Average Bank Balance APIs add income, obligations, bounces and balance metrics.
How much does the Bank Statement to Excel API cost?
The Bank Statement to Excel API on API Sathi starts at ₹10 per successful call plus 18% GST, paid from a prepaid wallet. There is no monthly fee or minimum volume, and recharges of ₹1,000 or more earn bonus credit. Live prices for every API are on the pricing page.
Can I test the Bank Statement to Excel API for free?
Yes. Every account gets a TEST key that calls the Bank Statement to Excel API in the sandbox at no cost and returns realistic sample responses, so you can finish your integration before adding money to the wallet.
Am I charged if a Bank Statement to Excel API call fails?
No. You pay only for successful calls. If the source is unavailable, times out or rejects the request, the amount held for that call is released straight back to your wallet.
How do I get a Bank Statement to Excel API key?
Sign up at apisathi.in — it takes about a minute — and create a key under API Keys. Use the TEST key in the sandbox, then recharge from ₹200 and switch to a LIVE key. The same key works for every API on API Sathi.
Related APIs
Bank Statement Analysis API
A statement PDF in, structured transactions and income signals out.
From ₹40/call
Average Bank Balance API
ABB from a statement PDF, on the exact days your lender asks for.
From ₹35/call
Credit Report API (Experian)
Consent-based Experian credit report + score in one call.
From ₹30/call
IFSC Code Lookup API
Turn an IFSC into bank, branch, address and payment-rail support.
From ₹0.50/call
CIBIL Score API
Bureau score and full credit report, with the borrower’s consent.
From ₹125/call
Aadhaar eSign API
Send a PDF, get it signed with Aadhaar OTP — legally valid, no paper.
From ₹30/call
Start using the Bank Statement to Excel API today
Sign up, recharge a prepaid wallet and generate a key in minutes. Lowest price guaranteed, no volume commitment.