CleanMySheet guide
Clean QuickBooks and finance CSV/Excel exports
The Financial statements preset trims, unifies empties, converts text to numbers (including ($1,234) → -1234 and ₹1,23,456.78), and standardizes dates to ISO. Clean numbers auto-detects grouping; European number format remains an override for 1.234,56.
Finance pack will be suggested after scan.
Drop CSV or Excel here
Tap to choose a file. Parsing stays on this device.
Parsing stays on this device. Optional: drop a .cleanmysheet.json recipe with it.
Steps
- Drop the ledger export
- Apply Financial statements
- Lock account-code columns if needed
- Export
Audit trail
Download the markdown quality report for counts of dates and numbers converted. Pro removes the CleanMySheet footer line.
Related searches this page answers
- clean quickbooks export
- accounting negative parentheses
- finance csv cleaner