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

  1. Drop in the CSV from your bank, or paste the rows.
  2. Check the columns it has picked for the date, the description and the amount.
  3. Choose 3 or 4 columns and the date format for QuickBooks. Tick Flip signs if your bank shows spending as a plus.
  4. 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.