Quickbooks doesn't support date format for my banking CSV file

Hi there, Eleanor.

Since your bank provides YYYY-MM-DD format in the Date column, you can change it to MM-DD-YYYY or DD-MM-YYYY format in your Excel file. Let me guide you how.

Before we proceed, please make sure to select the correct date format that matches your QuickBooks transactions. This way, you'll not receive any error when matching your transactions.

Here's how to change the date format in your Excel file:

1. In your MS Excel, highlight the date column.
2. At the top of your Excel screen, click the Number Format icon.
3. In the Number tab, select Date under Category.
4. Choose the correct format.
5. Click OK.

Once done, I'm confident that you'll be able to import your bank transactions in QuickBooks Online successfully.

You can check out these article for your reference: 

• Import Bank Transactions using Excel CSV Files.    
• Common Errors for Importing Bank Transactions using CSV.

You might also want to read this article to learn how to match bank transactions: Match and Categorise your Downloaded Bank Transactions.

Please know that you can always get back to me if you have any other questions. It'll be my pleasure to help you.

Thank you so much. This saved my life!

Please add the option to import "yyyy-mm-dd" format, so that we don't have to spend extra time changing the format. Thank you. 

Another option, utilize csv2qbo converter tool. It costs USD 60.

https://www.moneythumb.com/?ref=110

Hi there, shina.

Let me help you forward the date format option that you want to add in QuickBooks. You can send feedback about the feature that you want within your account.

Here's how:

1. Select the Gear icon at the top, then Feedback.
2. Enter your comments or product suggestions. 
3. Click Next to submit feedback.
4.  

Your valuable feedback goes to our Product Development team to help improve your experience in QBO. You can track feature requests through the QuickBooks Online Feature Request website.

I'm adding again this article when importing a CSV file: Format CSV files in Excel to get bank transactions into QuickBooks.

Here's also a link that provides the latest functions and features of your QuickBooks Online UK account: QuickBooks Updates.

Let me know if there's anything else you need by commenting below. I'm always right here to help manage your bank transactions.