BooksReady

CSV to QuickBooks Online converter

QuickBooks Online imports bank CSV files with exactly 3 columns (Date, Description, Amount) or 4 columns (Date, Description, Credit, Debit), one header row and one date format throughout. The converter below builds one from a payment app or bank CSV, on your device.

Convert a CSV to QuickBooks Online (CSV)

To QuickBooks Online (CSV)

A CSV export from Venmo, Cash App, PayPal, Stripe, Square, Shopify, Wise, Etsy, Airbnb, Gumroad or your bank, or an MT940 or camt.053 bank statement. The source is detected automatically.

Your file stays on this device

It is read and converted by this page, inside your browser. Nothing from the file is uploaded, and the converter keeps working offline once the page has loaded.

One email when it ships. The address is used for nothing else. Details.

Pick the app the file came from

From a bank CSV

Bank CSV exports differ from bank to bank: some use one signed amount, some separate debit and credit columns, dates may be day-first or month-first, and many add header or total rows. Choose "Bank CSV" as the source (it is picked automatically when the file is not from a known app).

  1. In your online banking, find Download or Export transactions.
  2. Choose CSV (sometimes called Excel CSV or Comma separated).
  3. Pick the date range and download.
  • We look for the header row even if the file starts with account details.
  • We map Date, Description and Amount, or separate Debit and Credit columns, automatically, and show the result in the preview.
  • We work out whether dates are month/day or day/month and whether "," or "." is the decimal point from the file itself; when the file cannot tell, we ask you instead of guessing. Dotted dates (31.01.2025) are read day first.
  • Card exports that show purchases as positive numbers can be flipped with the "invert sign" option.

What QuickBooks Online requires

  • Columns exactly Date, Description, Amount.
  • Money in is positive, money out is negative; no currency symbols or thousands separators.
  • One date format for the whole file.
  • Up to 1,000 rows and 350 KB per upload (we split bigger files).

How to import it

  1. Go to Transactions > Bank transactions > Link account (or Update) > Upload from file.
  2. Choose this CSV and the account to put it in.
  3. Map the columns: Date to Date, Description to Description, Amount to Amount (one column).
  4. Pick the date format MM/dd/yyyy (or the one you chose here) and confirm that the first row is a header.
  5. Review the transactions under For review.

Questions

Should I choose 3 columns or 4 columns?
Both import the same transactions. The 3-column file has one signed Amount, negative for money out. The 4-column file splits money in (Credit) and money out (Debit) and leaves the unused side blank, which is what Intuit asks for. Use 3 columns unless your accountant prefers the other; switch "To" in the converter to get the 4-column file.
Why does QuickBooks reject my file as too large?
Intuit documents a limit of 350 KB and 1,000 lines per manual upload in QuickBooks Online. When your converted file is bigger, the converter also gives you numbered parts that each fit; upload them one after another.
Will the import post transactions straight to my books?
No. Uploaded transactions land in the For review list of the bank account you chose. QuickBooks suggests matches and categories, and nothing is recorded until you accept each one.
Why do some descriptions start with an apostrophe?
A text cell that begins with =, +, - or @ could be run as a formula if the CSV is opened in a spreadsheet. The converter puts an apostrophe in front of such cells, which is the usual protection; the preview shows each cell exactly as it is written.

Common QuickBooks Online import problems