Hi there, @MelonieBP. Welcome to the Community.
The problem you're experiencing typically occurs due to an incorrect date format for the transaction dates in your CSV import file. The 01/01/1970 is a default value QuickBooks uses when it is unable to successfully interpret a valid date.
You have to make sure that the transaction date in your CSV file matches one of the expected formats in QuickBooks. These are the examples:
- MM/dd/yyyy
- MM-dd-yyyy
- MM.dd.yyyy
- dd/MM/yyyy
- dd-MM-yyyy
- dd.MM.yyyy
- yyyy-MM-dd
The date will display properly once you use the correct formats.
To correct the transactions that are picking up the 01/01/1970 date, you need to exclude them and then re-import them with the corrected date format. To exclude them, follow the steps below:
- Navigate to the Pending tab.
- Select the checkbox next to each transaction you wish to exclude.
- Click the Exclude button.
I've also added this article to help you explore more about CSV file formats: Format CSV files in Excel to get bank transactions into QuickBooks.
Please feel free to ask if you have any follow-up questions or need more detail on this topic or any other bank import feature.
