Format CSV files in Excel to get bank transactions into QuickBooks
by Intuit•5• Updated 3 weeks ago
After you’ve downloaded the .CSV file from your bank, you need to do a little bit of formatting before uploading it to QuickBooks Online.
Before you start
Every bank sets up their .CSV files differently. This means you might not be able to import .CSV files from some banks because the files don't have the format QuickBooks needs. If your bank doesn't export files to .CSV, you can also upload your statements to QuickBooks Online through Quicken (.QFX), QuickBooks Online (.QBO), or Microsoft Money (.OFX) or text (.TXT) files. But these files must follow a specific 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.
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 |
Next steps
Now that your file is formatted correctly, you can manually upload your transactions into Quickbooks Online, and categorise them to keep your books tidy.
We're here to help
If you need additional help or have questions, or you require assistance at any point in this process, our Customer Success team is happy to help.
Sign in to QuickBooks and start a discussion in our QuickBooks Community or join one of our Facebook Groups to connect with other like-minded QuickBooks customers.
Sign in now for personalized help
See articles customized for your product and join our large community of QuickBooks users.
More like this
- Manually upload your transactions, receipts, and bills into QuickBooks Onlineby QuickBooks•181•Updated October 17, 2024
- What to do when your bank no longer supports your bank feed - QuickBooks Self-Employedby QuickBooks•1•Updated 1 year ago
- Common errors for importing bank transactions using CSV in QuickBooks Onlineby QuickBooks•12•Updated 3 weeks ago
- What to do when your bank no longer supports your bank feed - QuickBooks Onlineby QuickBooks•25•Updated June 03, 2024