About this tool
What it does
QuickBooks Online is strict about bank uploads. It wants a CSV with one header row, three or four set columns, one date format and a size of no more than 350 KB. This tool reads the CSV your bank gave you and writes a clean file in that layout.
It runs in your browser. The statement is never uploaded and its contents are never stored. If the file has a balance column, the tool uses it to check the signs and the sums before you download.
How to use it
- Drop in the CSV from your bank, or paste the rows.
- Check the columns it has picked for the date, the description and the amount.
- Choose 3 or 4 columns and the date format for QuickBooks. Tick Flip signs if your bank shows spending as a plus.
- Read the checks, download the file, then upload it to QuickBooks.
Questions
- Is my bank statement uploaded?
- No. The file is read by your own browser. Nothing is sent anywhere and the contents are never stored.
- Which banks does it work with?
- It reads CSV exports, whichever bank they come from. It looks for the date, description and amount columns, and you can correct what it picks.
- What if the file is over 350 KB?
- It is split into several files, each under the limit. Upload them one after the other.
- Can it read a PDF statement?
- No. It reads CSV exports only.