Import bank data - dates screwing up | Voters | QuickBooks Accountant Feedback

Import bank data - dates screwing up

in discovery

Jamie Whitener

Imported CSV with date format of both M/DD/YYYY and MM/DD/YYYY and the system keeps putting the date as 12/31/1969! I imported two transactions from this same file that both have the same date format but only ONE has the issue.

August 14, 2025

Aditi Sahani

marked this post as

in discovery

Nicholas Guan

Hi Jamie - We are able to identify scenarios where transactions with a mismatched date format (MM-DD-YYYY) from what was selected (MM/DD/YYYY) in the upload process, they will be uploaded and dated 12/31/1969. If you would like to reach out to the team separately with the CSV file that is causing the issue, we would like to learn about how one transaction is being uploaded incorrectly. Thank you!

Jamie Whitener

Nicholas Guan I'm afraid I didn't save the file that I was working on when this occurred as I ended up entering it manually and not having a bank match. It would have been either dated mm/dd/yy or mm/dd/yyyy in the excel doc. There were 2-3 lines all formatted the same.

Julian Contreras

marked this post as

under review

Julian Contreras

Thank you for your feedback. We will pass your feedback to the team.