Question

If QB is changing the dates of some of transactions manually uploaded on csv bank files: it is switching day and month for example 12th June to 6th December. How to fix?

Forum|Forum|6 years ago
December 11, 2019
1 reply
0 views

Original commenter did not share additional details

QuickBooks Online

Hello Finance57

That sounds like American date formatting. If you are uploading a CSV if you go to the CSV and then on the column with the dates in,right click on the top of the column and go to format cells>date>select date range>apply.Then save the CSV and go back to QuickBooks and browse to the file and then when you map it select the same date range

Any problems at all just reply back here

Emma

F

finance57Author

Hi Emma

Thank you for your reply. Yes, it is American date formatting that the csv file is reverting to. I suspect something has not been set up correctly at the bank because their dating on csv exports is inconsistent. I have tried all sort of ways to correct the date before uploading the csv file to QB, including the method you have suggested. I have also tried converting the exported csv file from the bank into Excel, correcting the dates, then resaving as a csv file, and uploading that QB. No joy: the file still reverts to the American date format. This is intensely frustrating because it makes reconciliation a nonsense! Is there a way to alter the date within Quickbooks? If not, I will have to revert to manually inputting the information from the bank statements, instead of using csv import until such time as the bank sorts out it's formatting issue. Many thanks for your help.