How to Clean CSV Exports for Tax Reporting

The Five Problems in Every Accounting Export

• Encoding: bank exports are often Windows-1252 or UTF-16, so names and currency symbols show up garbled.
• Dates: 03/04/2026 means March 4 in one file and April 3 in the next; some platforms use full ISO timestamps.
• Amounts as text: thousands separators, currency symbols, and trailing minus signs stop a column from summing.
• Split rows: gross, fee, tax, and net are spread across rows or across columns that do not line up between platforms.
• Duplicates: the same payout appears in both the processor export and the bank export.

Step 1: Export Raw, Do Not Touch Excel Yet

Download the CSV straight from QuickBooks, Xero, Stripe, PayPal, Wise, or your bank and open it in a CSV-aware tool before Excel can reinterpret dates and IDs. An Auto Fix pass normalizes the delimiter, quoting, and encoding so you are working from a structurally valid file.

Step 2: Force One Date Format

Convert every date column to YYYY-MM-DD. Now every export sorts chronologically and you can filter cleanly to a single tax period without worrying about which locale produced the file.

Step 3: Fix Broken Characters

If names or transaction descriptions look wrong (é instead of é, £ instead of £), that is an encoding mismatch. Convert the file to UTF-8 and re-check a row with an accent or currency symbol.

Step 4: Normalize Amounts and Headers

Parse amount columns as numbers, separate gross and fees into their own columns, and rename headers so amount, fee, net, date, and reference mean the same thing in the Stripe file and the bank file. Consistent structure is what makes reconciliation a lookup instead of a puzzle.

Step 5: Run a Health Report

Finish with a data health report. Target: zero duplicate transaction IDs, zero blank amounts or dates, one currency per column, and a total that matches the number on your processor's dashboard.

Platform Notes

• Stripe: use the Unified payout report, not the per-charge export, so fees and gross are already aligned.
• PayPal: the Activity CSV mixes currencies; filter to one currency before summing.
• QuickBooks / Xero: export the General Ledger or Account Transactions, not a summary report, so every line is present.
• Bank: if the CSV has a multi-row header or a summary block at the top, delete those rows first.

Your Financial Data Never Leaves Your Computer

Every step above runs entirely in your browser. Your CSV is parsed, transformed, and exported locally. Nothing is uploaded, nothing is stored on a server, and no account is required. That matters most for exactly the files this guide is about: bank and payment exports, client lists, and payroll.

Doing This in How To CSV

How To CSV covers each step as a dedicated, browser-based tool:

• Auto Fix for encoding, delimiter, and structural repair (Step 1)
• Datetime Reformat to force one ISO date format (Step 2)
• Change Encoding to fix garbled characters (Step 3)
• Accountant for identifier checks and reconciliation prep (Step 4)
• Data Health for the final validation pass (Step 5)

Frequently Asked Questions