Need help with Payroll Year End? Visit our help hub
Ask your Making Tax Digital (MTD) questions in our community drop-in session
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Have a question about Payroll Year End? - Ask it here!
Eleanor2
Level 1

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

I am using a bank that does not link directly to QB so I need to manually upload the csv file with my bank transactions. However QB does not support the date format in my csv file which is YYYY-MM-DD. I can see QB supports this date format in other parts of the site (in its settings) but it is not listed for uploading bank transactions. I'm unable to complete the process as QB flags the date column as being in the wrong format. I am using QB online. Please help Eleanor
Solved
Best answer August 10, 2019

Accepted Solutions
Eleanor2
Level 1

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

Hi 

Thanks for your message.

As I do not have Excel I have been trying to reformat the date cells in Open Office with no success. However I just tried it will Google Sheets and it worked! Such a simple problem that has been giving me so much grief. For anyone else with this problem and you don't want to pay for Excel (which automatically reformats the date simply by opening the file in Excel and re-saving) then try opening in Google Sheets and reformat the date, then download as a csv file - works a treat.

Eleanor

View solution in original post

6 REPLIES 6
Mark_R
QuickBooks Team

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.

1.PNG 2.PNG

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: 

 

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.

Eleanor2
Level 1

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

Hi 

Thanks for your message.

As I do not have Excel I have been trying to reformat the date cells in Open Office with no success. However I just tried it will Google Sheets and it worked! Such a simple problem that has been giving me so much grief. For anyone else with this problem and you don't want to pay for Excel (which automatically reformats the date simply by opening the file in Excel and re-saving) then try opening in Google Sheets and reformat the date, then download as a csv file - works a treat.

Eleanor

fogouriou
Level 1

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

Thank you so much. This saved my life!

shina
Level 1

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

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. 

Fiat Lux - ASIA
Level 15

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

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

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

 

MaryLandT
Moderator

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

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.

Need to get in touch?

Contact us