Standardize messy CSV exports from Barclays, HSBC, NatWest, Lloyds, Monzo, and Starling into clean, consistent columns. Formats dates, splits debit/credit amounts, removes duplicate rows, and protects against formula injection vulnerabilities.
Standardizes disparate bank exports into accounting-ready columns: Date, Description, and signed Amount.
Removes point-of-sale junk codes, terminal numbers, “CARD PAYMENT” noise, and trailing timestamps.
Guards against CWE-1236 injection by neutralizing cells starting with =, +, -, or @ before spreadsheet export.
Parsed 100% inside your local browser tab. No transactions, balances, or names ever touch our servers.
Clean dates, standardize amounts, remove bank description noise, and export formula-safe CSVs.
| Date | Cleaned Description | Debit (Out) | Credit (In) | Net Amount | Status |
|---|---|---|---|---|---|
| 2026-10-24 | ADOBE SYSTEMS INCRaw: CARD PAYMENT TO ADOBE SYSTEMS INC | -£14.99 | — | -£14.99 | Cleaned |
| 2026-10-23 | ACME CORP INV-104Raw: FASTER PAYMENTS RECEIPT REF ACME CORP INV-104 | — | +£1,250.00 | £1,250.00 | Cleaned |
| 2026-10-22 | BRITISH GAS TRADINGRaw: DIRECT DEBIT PAYMENT TO BRITISH GAS TRADING | -£85.40 | — | -£85.40 | Cleaned |
| 2026-10-21 | TFL TRAVEL CHRaw: CONTACTLESS TFL TRAVEL CH | -£4.50 | — | -£4.50 | Cleaned |
| 2026-10-21 | TFL TRAVEL CHRaw: CONTACTLESS TFL TRAVEL CH | -£4.50 | — | -£4.50 | Duplicate |
| 2026-10-19 | VIKING DIRECTRaw: DEBIT CARD PURCHASE - VIKING DIRECT | -£120.00 | — | -£120.00 | Cleaned |
| 2026-10-18 | '@PAYMENT FROM SMITH CONSULTINGRaw: @PAYMENT FROM SMITH CONSULTING | — | +£450.00 | £450.00 | Cleaned |
| 2026-10-17 | '=SUM(1+1) VODAFONE MONTHLY BILLRaw: =SUM(1+1) VODAFONE MONTHLY BILL | -£35.00 | — | -£35.00 | Cleaned |
When downloading transaction histories from major banks (such as Barclays, HSBC, Lloyds, NatWest, Monzo, or Starling), files frequently contain formatting quirks that prevent clean importing into accounting software like Xero, QuickBooks, or FreeAgent.
TESCO STORES 2849 2026-11-01 CD 9481, cluttering bookkeeper bank reconciliation.MM/DD/YYYY) mixed with UK standards (DD/MM/YYYY) cause transactions to be sorted out of chronological order.Learn the legal rules, mathematical formulas, and practical best practices behind these calculations.
Exporting CSV statements from UK banks often results in messy date formats, split debit/credit columns, noisy transaction descriptions, and duplicate rows. This guide shows you how to clean and normalize banking data for seamless accounting import.
CSV files are universally assumed to be safe plain text. However, opening an untrusted CSV in Microsoft Excel or Google Sheets can execute malicious formulas or operating system commands via Dynamic Data Exchange (DDE). Here is how formula injection works and how to protect your exports.
No. CSV parsing, sanitization, and re-export occur strictly within your browser using Web Workers and local memory. No financial records are ever sent to our backend.
Malicious or accidental cell values starting with symbols like =, +, -, or @ can trigger formula execution when opened in Excel. Our cleaner neutralizes these prefixes safely.
Calculate VAT additions, reversals, net-to-gross, and gross-to-net at standard (20%), reduced (5%), and zero rates.
Determine gross profit margins, cost markups, revenue targets, and breakeven pricing instantly.