Bank Statement & Invoice PDF to CSV / Excel avatar

Bank Statement & Invoice PDF to CSV / Excel

Pricing

$10.00 / 1,000 page converteds

Go to Apify Store
Bank Statement & Invoice PDF to CSV / Excel

Bank Statement & Invoice PDF to CSV / Excel

Convert bank statement PDFs into clean transaction rows (date, description, debit, credit, balance) and invoice PDFs into invoice fields and line items. Works with Indian, US, UK and European formats. Export to CSV, Excel or JSON.

Pricing

$10.00 / 1,000 page converteds

Rating

0.0

(0)

Developer

Saksham Singh

Saksham Singh

Maintained by Community

Actor stats

0

Bookmarked

2

Total users

1

Monthly active users

2 hours ago

Last modified

Features

Limited permissions

Share

Turn bank statement PDFs into clean transaction rows and invoice PDFs into structured invoice data, ready to download as CSV, Excel or JSON. There is no start fee: you pay a small price per page converted.

What it does

Bank statements: one row per transaction:

datedescriptionreferencedebitcreditamountbalancecurrency
2026-10-03UPI-SWIGGY-swiggy@icici-ORDER 8812000004410450.00-450.0024,550.00INR
2026-10-07NEFT CR-ACME SOFTWARE PVT LTD-SALARY OCT 202600000441185,000.0085,000.00109,550.00INR
  • Reads the table header to find the date, description, withdrawal/debit, deposit/credit, amount and balance columns.
  • Handles single "Amount" columns with signs, Dr/Cr, S/H (Soll/Haben) and brackets.
  • Joins descriptions that wrap onto two or three lines.
  • Number formats 1,234.56, 1,23,456.00 (Indian), 1.234,56 and 1 234,56 (European).
  • Dates such as 03/10/26, 2026-10-03, 15 Nov 2026, Nov 15, 2026, 03.11. and 10/02. Day-first or month-first order is detected from the whole statement.
  • Balance check: opening balance plus all transactions must equal the closing balance, so you know the conversion is complete. The result is in the run's SUMMARY record.
  • Built for Indian, US, UK and German (Kontoauszug) statement layouts.

Invoices: invoice number, invoice date, due date, PO number, vendor, GSTIN / EU VAT IDs, subtotal, tax (CGST/SGST/IGST/VAT), total and line items (description, HSN/SAC, quantity, unit price, amount).

  • ZUGFeRD / Factur-X / XRechnung PDFs: the exact data is read from the e-invoice XML embedded in the PDF.
  • Choose one row per invoice or one row per line item. The second option works best for Excel and accounting imports.

How to use

  1. Paste direct links to your PDFs into PDF URLs. For Google Drive or Dropbox, use a direct-download link.
  2. Leave Document type on Auto, or pick Bank statement or Invoice.
  3. Run the actor, then open the Output tab → Export → CSV or Excel.

You can also call it from the API, Make, Zapier or n8n, for example to convert every statement that arrives by email.

Pricing

Pay per event: $0.01 per page converted. Pages of files that fail, such as scanned images without text or wrong links, are not charged. Use Max pages per PDF to cap costs.

Limits (please read)

  • The PDF must have a text layer. Statements downloaded from net banking usually do. Scanned or photographed statements need OCR first and are reported as an error, not charged.
  • Every bank layout is different. The column-based reader covers most statements, but check the balance check result. If a layout doesn't convert well, open an issue with an anonymised sample and we'll add support.
  • Password-protected PDFs must be unlocked first.
  • Invoice field detection on free-form PDF invoices is heuristic. E-invoices (ZUGFeRD/Factur-X) are exact.

Privacy

Files are downloaded, processed in memory during your run and not stored anywhere except your own run's dataset. Delete the run to remove the data.

Output fields

Bank rows: file, documentType, date, valueDate, description, reference, debit, credit, amount, balance, page, currency. Invoice rows: file, documentType, source, invoiceNumber, invoiceDate, dueDate, poNumber, vendor, buyer, gstins, vatIds, currency, subtotal, taxAmount, total, lineItems (or lineNo, description, hsn, quantity, unitPrice, taxRate, amount per row).

Made by SSquared Labs.