Instead of connecting your bank and credit card accounts to QuickBooks, you can upload them manually using a .CSV file. Usually, you download this file from your bank, but before you can upload it into QuickBooks Online you need to make sure the data is in the correct format.
Before you start
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 export to a .CSV file, you can also upload your statements to QuickBooks Online via Quicken (.QFX), QuickBooks Online (.QBO), or Microsoft Money (.OFX) or text (.TXT) files as long as they follow the following 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.
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.