Showing results for 
Search instead for 
Did you mean: 
Level 1

Converting bank statements to upload into Quickbooks

I'm trying to import my bank statements into QB online but even when I convert them to a .csv file it won't allow me to upload them. Any suggestions? Is there something easier I can do? My bank and credit card will only allow me to go back 180 days to upload online. 


1 Comment 1
QuickBooks Team

Converting bank statements to upload into Quickbooks

Thank you for sharing your concern with us, @Scottybeth1A.


I'd be delighted to help ensure you're able to record all of your transactions into the system.


Are you prompted with an error while importing your transactions? If so, may I ask for it?


One possible you're unable to import your .CSV file successfully is due to to format of the data on it. With QuickBooks Online, you can use a 3-column or 4-column CSV file. Your CSV file should contain the following information: DateDescription and Amount. Ensure to leave off leading zeros and format the date like this: M/D/YY, not like this: MM/DD/YY.


For example, January 1, 2016 would be 1/1/16.

3 - column format 4 - column format

For additional references, you may check out these articles:

Be sure to check out these articles for more tips on how to unlock QuickBooks full potential: QuickBooks Online Community Help Articles.


That's it! This should allow you to successfully import your transactions.

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up