CSV cleaner for QuickBooks and Xero imports.
Drop in a PayPal, Stripe, Amazon settlement or bank export. Choose QuickBooks Online or Xero. Download a bank-transaction file in the columns and date format it asks for, with fees on their own lines and duplicate rows taken out.
Your file never leaves your browser. Free · no sign-up
Clean-up report
| Rows read | |
|---|---|
| Lines in your new file | |
| Duplicate rows | |
| Rows skipped | |
| Rows that could not be read | |
| Currencies | |
| Dates |
Made on your device · nothing is uploaded or kept
Your file never leaves your browser.
The cleaning runs in this page, on your own device. Your export is not uploaded, stored or sent anywhere, and we never see it. Once the page has loaded it works with your internet connection switched off.
Close the tab and the file is gone from the page. The download is saved by your browser, like any other file.
Three steps to a file your books will take.
- Download the export. From PayPal, the Activity download. From Stripe, the balance or payout reconciliation report. From Amazon, the settlement report (flat file V2). From your bank, the CSV of the statement period.
- Drop it in and check it. The cleaner names the layout it recognises. For any other file, choose the date, description and amount columns. Read the report: rows read, duplicates, anything it could not read, with line numbers.
- Choose the output and download. In QuickBooks Online or Xero, import it into the bank account it belongs to, and pick the same date format at the mapping step.
What each file looks like
QuickBooks Online, 3 columns: Date, Description, Amount (money out negative)
QuickBooks Online, 4 columns: Date, Description, Credit, Debit (as Intuit's example: money out in Credit)
Xero: Date, Amount, Payee, Description, Reference
Amounts are written without currency symbols or thousands commas, zero-amount lines are left out, and each file has one date format throughout. With fees on their own lines, a 45.00 sale with a 1.80 fee becomes a 45.00 line and a −1.80 fee line, which together make the 43.20 that was paid to you.
Sources
- Intuit: Format CSV files to import bank transactions into QuickBooks, fetched 23 Oct 2026 — 3-column and 4-column layouts, the Credit/Debit example, blanks instead of zeros, one date format.
- Intuit: Common errors importing bank transactions, fetched 23 Oct 2026 — no currency symbols or commas in amounts; special characters in descriptions.
- Xero: Import a CSV bank statement, fetched 23 Oct 2026 — Date and Amount required; Payee, Description and Reference optional; signed amounts; accepted date formats.
- PayPal: Activity download, fetched 23 Oct 2026 — the column names and the Balance Impact field (Memo rows have no balance effect).
- Stripe: Balance report, fetched 23 Oct 2026 — the column names of the itemised balance report.
- Stripe: Payout reconciliation report, fetched 23 Oct 2026 — the column names of the itemised payout reconciliation report.
- Amazon: Settlement report types (SP-API), fetched 23 Oct 2026 — the V2 settlement flat file columns, and its local number formats.
CSV cleaner questions.
Is my file uploaded anywhere?
No. The cleaner is JavaScript that runs in this page on your device. The file is read, cleaned and saved by your own browser; nothing is sent to us or anyone else.
Which exports does it read?
It recognises the PayPal Activity download, Stripe's balance and payout reconciliation reports and the Amazon settlement report (flat file V2), using the column names each company documents. Most other CSV exports, from marketplaces and banks, work too: you choose which column is the date, the description and the amount.
Which date format should I choose?
The one you will pick when you map the columns in QuickBooks Online or Xero. Intuit asks for one date format throughout the file and recommends dd/mm/yyyy. Xero reads dd/mm/yyyy, mm/dd/yyyy and yyyy/mm/dd; yyyy/mm/dd cannot be read two ways.
What does it do with duplicates?
When the file has a transaction ID, a row with the same date, amount and ID as an earlier one is taken out, and the report says how many. Without an ID, two identical rows can both be real, so they are kept and counted as possible duplicates; tick the box to remove them.
The file mixes currencies. What now?
A bank account imports one currency, so the cleaner asks you to choose one and makes a file for that currency only. Run it again for each of the others.
Do I still need A2X or Link My Books for Amazon?
This is a one-off clean-up of a file you already have. A2X and Link My Books describe themselves as connecting Amazon settlement data to QuickBooks or Xero, which suits a store that sells there every month.
Clean imports every month, done for you.
Our monthly e-commerce bookkeeping reconciles every payout, fee and refund in QuickBooks Online or Xero. Start with a free review of where your books stand.
See where your books stand — free.
Get a written review of every channel: what's reconciled, what's missing, and the exact price to fix it. Free, with no commitment.
Get my free books review