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 standardizes dates to ISO. European number format is a separate preset for 1.234,56.
Open the cleanerSteps
- 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