Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
This issue often occurs because of incorrect format of the transaction date in your CSV file when importing data in QuickBooks. In many cases, 01/01/1970 is a default value used when QuickBooks is unable to interpret a valid date, thewni.
You'll have to make sure that the transaction date in your CSV file matches the expected format. I've added a screenshot for your reference:

Once you have the correct format, it will eventually show the correct date. See below:

To correct the transactions that is picking up the 01/01/1970 date, you can exclude them and re-import again with the correct date format. To exclude, follow the steps below:

If you have any other questions and need clarification related to the transaction date or any other aspect, please let us know. The Community team is always here and happy to help you at anytime.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here
