Bank Statement CSV Normalizer
Normalize bank statement headers into one consistent transaction schema locally in your browser before accounting import or reconciliation.
Normalize one bank statement CSV entirely in your browser without uploading it, up to 200 MB. The workspace starts with source-backed mappings such as TRAN_DATE → transaction_date, DR → debit_amount, CR → credit_amount, PARTICULARS → narration, and CHQNO → cheque_no. You can keep, rename, reorder, or drop any remaining bank-specific columns before downloading a new CSV. It changes column names and order only; it does not split a signed amount into debit and credit or transform transaction values.
Bank statement mapping workspace
Map varying bank-export headers to one stable transaction schema before reconciliation or accounting import.
Results will appear here
Add valid data in the workspace above to preview and download the result.
Normalize bank CSV headers into a stable transaction schema
- 1
Choose a bank statement CSV from your device.
- 2
Review the suggested canonical names for known bank headers.
- 3
Rename, keep, drop, and reorder the remaining columns for your accounting schema.
- 4
Review the live preview before export.
- 5
Download the normalized CSV for reconciliation or accounting import.
Built for the real task
- Bank-specific header presets
- Canonical transaction field names
- Rename, reorder, keep, or drop columns
- Browser-local processing
See the transformation
Awkward source headers become import-ready columns.
Rename the columns you need while keeping every value under the correct header.
cust_idcustomer_idgiven_namefirst_namemailemail✓ Values stay with the right column
Browser limits
Files are limited to 200 MB to protect browser stability, especially on phones. Processing stays on this device.
Normalize bank statement headers into one consistent transaction schema locally in your browser before accounting import or reconciliation.
The selected file is not uploaded to Nablyx.
No. This tool reads and transforms the file locally in your browser.
Common uses
- Bank-specific header presets
- Canonical transaction field names
- Rename, reorder, keep, or drop columns
- Browser-local processing
Does this convert transaction values or split signed amounts?
No. This focused workflow normalizes CSV headers and column order. It preserves cell values. If a bank provides one signed amount column, this tool does not split it into separate debit and credit values.
Related guide
Related tools
Continue with a related Nablyx tool.
- CSV column mapper and renamerRename, reorder, and remove CSV columns before importing data into a CRM, store, database, or accounting system — without uploading your file.
- Clean and fix CSV files — no uploadRepair common CSV problems including wrong delimiters, uneven rows, empty lines, whitespace, BOM markers, and duplicate headers.
- Validate CSV files online freeScan a CSV once for structural, encoding, header, delimiter, and whitespace problems without changing the file.
Ready to work on your file?
Return to the workspace and process it locally.