How to import bank transactions using Excel CSV files

Hi Atoll,

In QuickBooks Online, you can only use the 3-column or 4-column format when importing CSV files. For the formatting restrictions, cells with zeroes (€0) are not allowed anywhere and should be left blank. 

You can check this article for other formatting restrictions: How To Import Bank Transactions Using Excel CSV Files.

Please let me know if you have any additional questions about QuickBooks. Thanks.

Thanks for this. I have left the cells where a 0 should be clear. But Quickbooks still comes up with an error for these specific cells and I am unable to import it, for this reason only. Everything else is fine. 

Thanks for getting back to me, Atoll.

To investigate this import error message, please contact one of our Phone Support Team. They have more resources available and can help you check the CSV file.

You can get our contact information here: Get help with QuickBooks Online.

Feel free to reach out to us if you have any other questions.