What you need before you start
- The file itself — a PDF, a scan, or a photo of every page.
- The target role or the statement period, so the analysis has a reference.
- Two minutes. No account is needed for the first run.
How to export Santander transactions as JSON
1. Download your Santander statement as a PDF
Grab it from Santander's online banking or mobile app — that PDF is all the tool needs.
2. Upload it to DocPipelineAI
The conversion is free and needs no signup the first time. You can queue up to 20 PDFs in a single batch.
3. The parser reads every transaction
Text-based PDFs process directly; scans and photos go through OCR. Rows with low OCR confidence are flagged needs_review so you can confirm them.
4. Balances are validated
The tool checks that running balances stay continuous across consecutive transactions; any break gets a balance_gap badge so you know where to look.
5. Download the JSON
You get structured JSON — one record per transaction — ready for scripts, integrations or other systems.
What the output looks like
A clean table you can import — not a wall of text you have to re-key.
| Date | Description | Debit | Credit | Balance | Status |
|---|---|---|---|---|---|
| 02 Mar | ACME PAYROLL DIRECT DEP | — | 6,420.00 | 7,905.42 | verified |
| 03 Mar | BLUE BOTTLE COFFEE #214 | 6.75 | — | 7,898.67 | verified |
| 04 Mar | DELTA AIR LINES 0062 | 418.20 | — | — | balance gap |
| 05 Mar | RENT — OAKLINE PROPERTIES | 2,450.00 | — | 5,448.67 | verified |
| 11 Mar | TRANSFER TO SAVINGS ****4412 | 1,000.00 | — | 4,306.49 | verified |
| 2 statements merged · 10 transactions · debit 4,283.47 · credit 6,838.20 · net 2,554.73 · 2 balance gaps flagged | |||||
Why balance verification matters
Without verification
- Digits transposed silently by OCR
- Fees lost at page breaks
- Columns shifted in the CSV export
- Hours spent auditing by hand before you trust the file
With running-balance checks
- Every line checked against the running balance
- Multi-page carry-forward reconciled, not guessed
- Low-confidence rows flagged for review, never hidden
- Exports that open cleanly in Excel or QuickBooks
Supported banks and formats
The parser is trained on statement layouts, not one bank's template. These are the most common; anything with a table and a balance column is worth trying.
Why this fits Santander statements
A few things worth knowing before your first Santander upload:
- A note on Santander statements
- Past Santander statements remain available as PDFs in online banking.
- Up to 20 statements per batch
- Upload several PDFs in one go — ideal for rebuilding a full year of activity.
- Clean structured output
- Each transaction becomes one JSON record, so downstream scripts and integrations get predictable fields.
- Nothing is stored
- Files are processed and deleted immediately after the conversion finishes.
Santander conversion FAQ
Can I convert several Santander statements at once?
Yes — up to 20 files in a single batch. Multiple statements can also be merged into one ledger, sorted by date, with totals for debits, credits and net.
Is the Santander statement conversion free?
Yes — the first conversion is free and anonymous, with no signup. An account is only needed if you want to save your results.
Does it work with scanned or photographed Santander statements?
Yes. Image-based PDFs and photos go through OCR, and any row the OCR isn't confident about is flagged needs_review for you to confirm.