Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
June 25, 2025
Question

After importing CSV the date format is accepted but the date of the transaction is showing for year 1970

  • June 25, 2025
  • 1 reply
  • 2 views

After importing CSV the date format is accepted but the date of the transaction is showing for year 1970

1 reply

JenoP
QuickBooks Team
June 25, 2025

QuickBooks Online follows the date on the file that you're importing, as long as it's an acceptable format, Priya.

 

You can review the file you downloaded from your bank and make sure it's in the correct format. We recommend using the dd/mm/yyyy format for best results.

 

You can read more details about this in these articles to make sure the import process is successful: 

 

 

After that, reupload the file and check if the date format is now correct. 

 

If the new upload looks correct, you can exclude the transactions from the first upload. Let me share this article as a guide: Exclude a bank transaction you downloaded into QuickBooks Online.

 

You may also want to check out this article in case you need to set up some rules to speed up the process of adding categories: Set up bank rules to categorise online banking transactions in QuickBooks Online.

 

Please know that the Community is open all the time if you need more help from us.