How to convert a bank statement for QuickBooks
- Download your transactions. In online banking, open the account and look for Download, Export or Download transactions. Choose CSV or Excel and the date range you need. If your bank only offers PDF statements, use the PDF statement converter.
- Drop the file on the converter above. It finds the header row, the date, description and amount columns, and works out whether dates are month-first or day-first.
- Check the preview and totals. Compare the number of transactions, money in and money out with your bank statement. If something is off, open Change which column is which and adjust the columns.
- Choose a QuickBooks format and download. The 3-column CSV is the safest choice for QuickBooks Online. Choose QBO if you use QuickBooks Desktop or want to skip column mapping.
- Upload it to QuickBooks. In QuickBooks Online go to Transactions → Bank transactions → Upload transactions, choose the file and the account, then review the transactions. Our QuickBooks import guide walks through every screen.
What the QuickBooks CSV looks like
QuickBooks Online accepts two CSV layouts for bank transactions. This tool creates both, with a header row, consistent dates, plain-text descriptions and no zeros in empty cells — the details that most often cause an upload to fail.
| Layout | Columns | Money out shown as |
|---|---|---|
| 3 columns | Date, Description, Amount | Negative amount, e.g. -48.20 |
| 4 columns | Date, Description, Credit, Debit | Positive number in the Debit column |
Bank layouts it recognises
Every bank exports transactions differently. Some put money in and money out in separate columns, some add a DEBIT/CREDIT column, some add summary rows above the table, and some leave out the header row altogether. The converter handles all of these. It has been tested with export layouts from:
- United States: Chase (checking and credit card), Bank of America, Wells Fargo, Capital One and American Express.
- United Kingdom: Barclays, HSBC, Lloyds, NatWest, Monzo and Starling.
- Canada: RBC and TD.
Other banks and credit unions usually work too, because detection is based on column names and the data itself rather than a fixed list. If a column is missed, you can pick it yourself in step 2.
It also reads OFX and QFX files, so you can turn a Quicken download into a QuickBooks file, and Excel workbooks with title rows or real Excel dates.
Tip: QuickBooks Online has a size limit for uploaded bank files. If a large year-long file is rejected, download smaller date ranges (for example, one quarter at a time) and convert each one.
Why amounts sometimes come out backwards
For a bank account, money you spend is negative. For a credit card, banks disagree: Chase exports purchases as negative numbers, while American Express exports them as positive. If your preview shows purchases under Money in, tick Swap money in and money out. When importing a credit card file into QuickBooks, choose the credit card account (not a bank account) so QuickBooks treats charges and payments correctly.
Frequently asked questions
Is this bank statement to QuickBooks converter really free?
Yes. There is no sign-up, no trial, no watermark and no limit on the number of transactions. The site is supported by advertising.
Is my bank data uploaded anywhere?
No. The converter runs entirely in your web browser using JavaScript. Your file is read on your own device and the converted file is created on your device. Nothing is sent to our server, so we never see your transactions.
Which banks does it work with?
It works with any bank that lets you download transactions as CSV, Excel (.xlsx), OFX or QFX. It recognises common layouts automatically, including Chase, Bank of America, Wells Fargo, Capital One, American Express, Barclays, HSBC, Lloyds, NatWest, Monzo, Starling, RBC and TD. For anything else, you can choose the columns yourself in step 2.
Should I choose the 3-column or 4-column QuickBooks CSV?
Both work in QuickBooks Online. The 3-column file has one Amount column where money out is negative. The 4-column file puts money in under Credit and money out under Debit. If you are unsure, use 3 columns. Use 4 columns if QuickBooks asks you to map separate money-in and money-out columns.
What is the difference between a QuickBooks CSV and a QBO file?
A CSV needs you to match the columns during import. A QBO (Web Connect) file is a bank-format file that QuickBooks reads without any mapping, and it is the format QuickBooks Desktop uses for bank imports. See our file format guide for details.
My credit card file shows purchases as positive numbers. What do I do?
Some card issuers, such as American Express, export charges as positive amounts. Tick Swap money in and money out in step 2 and check the preview: purchases should appear under Money out.
Will importing the same file twice create duplicates?
QuickBooks usually spots duplicates in QBO files because each transaction gets a stable ID based on its date, amount and description. With CSV files, QuickBooks may still import duplicates, so only import date ranges you have not imported before.