![QuickBooks Help](https://uxfabric.intuitcdn.net/web-app/sh-exp-sbg-app-experience/sbg_ohh_icon.19f2ae89.png)
Format CSV files in Excel to get bank transactions into QuickBooks
by Intuit• Updated 1 month ago
Learn how to check the format of the CSV file you got from your bank to upload transactions to QuickBooks.
Instead of connecting your bank and credit card accounts to QuickBooks, you can upload them manually. You usually download this file from your bank. Before you can upload it, you need to make sure the data is in the correct format.
Learn about CSV formats
You can upload CSVs with either the following 3-column or 4-column format. These are the only columns QuickBooks can handle and this order.
Each bank formats CSV files differently. This means you may not be able to import CSVs from certain banks since files don't have the format QuickBooks needs. If your bank doesn't support CSV files but offers Quicken (QFX), QuickBooks Online (QBO), or Microsoft Money (OFX), you can try to import your data and then upload more than 90 days of bank transactions through Web Connect.
The 3-column format
This format has a Date, Description, and Amount column.
A | B | C | |
1 | Date | Description | Amount |
2 | 1/1/2018 | Example of a payment | -100.00 |
3 | 1/1/2018 | Example of a deposit | 200.00 |
The 4-column format
This format has a Date, Description, Credit, and Debit column.
A | B | C | D | |
1 | Date | Description | Credit | Debit |
2 | 1/1/2018 | Example of a payment | 100.00 | |
3 | 1/1/2018 | Example of a deposit | 200.00 |
Upload transactions into QuickBooks Online
When your file is formatted correctly, follow these steps to upload them into QuickBooks Online.
Sign in now for personalized help
See articles customized for your product and join our large community of QuickBooks users.
More like this
- Import your chart of accounts to QuickBooks Onlineby QuickBooks•21•Updated June 20, 2024
- Void or delete transactions in QuickBooks Onlineby QuickBooks•39•Updated June 19, 2024
- Export your reports to Excel from QuickBooks Onlineby QuickBooks•3•Updated 1 day ago
- Manually upload transactions into QuickBooks Onlineby QuickBooks•9•Updated 3 days ago
- Create invoices in QuickBooks Onlineby QuickBooks•12•Updated 3 days ago