Bookkeeping and bank exports
Clean bank and accounting exports before they go into your books
Bank statements and accounting exports arrive with local date formats, currency symbols, bracketed negatives and blank lines. Fix them in your browser — client data never leaves your computer.
Before
| Date | Description | Amount |
|---|---|---|
| 03/04/2026 | CARD PAYMENT OFFICE SUPPLIES | (45.20) |
| (blank) | (blank) | (blank) |
| 04/04/2026 | TRANSFER FROM CLIENT | £1,250.00 |
After
| Date | Description | Amount |
|---|---|---|
| 2026-04-03 | CARD PAYMENT OFFICE SUPPLIES | -45.20 |
| 2026-04-04 | TRANSFER FROM CLIENT | 1250.00 |
Every bank and accounting system exports slightly differently, and the differences break imports: a date that your software reads as 4 March instead of 3 April, an amount with a currency sign that imports as text, a refund written as (45.20) instead of -45.20, a blank line that becomes an empty transaction. When you handle exports for several clients every month, these fixes add up to hours.
What GridRinse fixes
- Dates: one output format for the whole file. Where a column could be day-first or month-first and the data cannot tell, GridRinse asks you instead of guessing (see why dates go wrong).
- Amounts: strips currency symbols and thousands separators, turns
(45.20)into-45.20, and can fix the number of decimals (number formats). - Descriptions: trims stray and repeated spaces and invisible characters so matching rules in your software work.
- Blank and duplicate rows: removed, and every removed row is listed with the reason before you download.
- Columns: rename, reorder or drop columns to match the import template your software expects.
Client data stays on your computer
The file is read and cleaned by this web page in your browser. It is never uploaded to us or anyone else; the site’s Content-Security-Policy blocks the page from sending data to other servers. That matters when the file is a client’s bank statement.
Do it once, then one click every month
Build the steps on this month’s file, check the preview, and save them as a workflow. Next time, load the new export and apply the workflow: the same steps, in the same order, every time. The free plan keeps workflows in your browser and lets you export them as JSON; Pro ($9/month) saves up to 50 workflows to your account so they follow you between computers, and raises the limits to 50 MB files, 500,000 rows and 20 files per batch.
Questions
- Can it process several clients' statements at once?
- Yes. Load several files and choose batch mode: the same steps are applied to each file and you download a ZIP with one cleaned file per input (3 files at a time on the free plan, 20 on Pro, 100 on Business).
- Will it change the original file?
- No. The original is never modified, and 'Download original' returns the exact bytes you loaded.
- Which formats does it read and write?
- CSV (any common separator and encoding) and Excel XLSX, in and out.
Try it on this month’s export
The cleaner is free in your browser, no sign-up. When the steps are right, save them as a workflow; Pro keeps them in your account for $9/month, cancel any time.
Other uses: Shopify and e-commerce exports · CRM and mailing-list imports