cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
finance57
Level 1

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?

 
14 REPLIES 14
EmmaM
QuickBooks Team

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?

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

finance57
Level 1

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?

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.

Fiat Lux - ASIA
Level 15

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?

@finance57 

Explore the importer tool. When you are mapping the raw data (i.e CSV), make sure to set the date format as needed.

https://transactionpro.grsm.io/qbo

 

Hope it helps.

finance57
Level 1

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?

Thank you for replying. I've tried that, too. Did not work.

 

There is definitely an issue with the bank: I have double-checked transactions for this month so far: some transactions are formatted correctly for UK date; others are formatted for USA date. Sloppy formatting at their end! 

EmmaM
QuickBooks Team

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?

Hello Finance57

 

Which bank is this with?This is not great no,it makes it hard to reformat.

 

What we can do is email you using the email address you set up the Community with if you could then email us back  with the CSV so we can test and make sure we can get it to upload before emailing you it back we will then delete it.

 

Thanks

 

Emma

finance57
Level 1

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?

Hi Emma

 

That sounds a good idea: I am about to go on holiday until January 6th so, it will be best to do the testing in the new year. I will message you when I am back at work. The bank is The Co-operative Bank!

 

Best wishes

Clare

Becky29
QuickBooks Team

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?

Thank You,

 

We will await to hear from you in the New Year.

 

^Becky

finance57
Level 1

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?

Hi Becky

 

Thank you for your reply. I broke a finger over the holiday! So I am going to ask my colleague to help me do  the .csv emailing - typing is not easy one-handed.

 

 

Becky29
QuickBooks Team

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?

Ouch, and I bet you its a finger on your best hand too.

 

Wishing you a speedy recovery and if you need any assistance please do not hesitate to reach out to us.

 

^Becky

 

 

ESBQisAnnoying
Level 1

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?

I've found QBSE is doing this to my receipts. (nothing to do with my bank). QBSE logs 90% as DDMMYYYY then flips some to MMDDYYYY. Amazingly frustrating. Have you had any luck with your issue?

Ryan_M
Moderator

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?

Hi,

 

If you're referring to downloaded bank transactions instead of those imported through a CSV file, then it's a possible browser-related issue. 

 

The stored cache on your browser is the common cause of unusual behaviours. To isolate this, open your browser's private window. 

 

  • Google Chrome: Ctrl + Shift + N
  • Microsoft Edge: Ctrl + Shift + P
  • Firefox: Ctrl + Shift + P
  • Safari: Command + Shift + N

Proceed with logging in to your QuickBooks Self-Employed (QBSE) company via the private browser. If that works, clear your browser's cache. Otherwise, open an alternative browser that's available for you. 

 

In case you'd like to remove your online banking data in your QBSE company, refer to this article: Delete bank and transaction data in QuickBooks Self-Employed. It lists the steps on how you can proceed from a browser or mobile device. 

 

Should you have any other questions, leave them in the comments below. I'll get back to you. 

anandshah
Level 3

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?

I have same concern, transactions uploaded with date 22-03-2021 are now showing as 23-03-2021, i have removed cache, i have tried various computers, the change in date is showing every where

customer care has no clue 

absurdity 

Ashleigh1
QuickBooks Team

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?

Hello Anandshah, thanks for posting on this thread. So when the updated your account and the transactions first showed as the 22-03-2021 and then showed as 23-03-2021, on your actually bank account when you look what is the date of them transactions is it the 22-03-2021 or is it the 23-03-2021? Is it the same when you try different browsers as well? 

 

emmam6
Moderator

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?

Hello Community Users, we just wanted to pop in and add an article with helpful tips on formatting a CSV of bank transactions in Quickbooks Online here. In particular the fine tuning section which in case you can not access the article we have included below. Any questions at all about this we're happy to help.

 

Fine tune the formatting

If you see an error message when you upload, do the following:

  • Remove any zeroes (0) from the file. Leave those cells blank.
  • Correct any transactions that display numbers in the Description column.
  • Remove the word "amount" if it appears in the Credit or Debit column header. They should only read "Credit" and "Debit" without the word "amount."
  • Make sure the dates are in one format. We recommend you use: dd/mm/yyyy.
  • Mac users must save the file as a Windows CSV file.
  • Some banks add the day of the week in the Date column (for example, 20/11/2018 TUE). You need to remove the day of the week. To do this, split the date and the day of the week into separate columns:
    1. Open the CSV in Microsoft Excel.
    2. Highlight the column that contains the date.
    3. Go to Data then select Text to Columns.
    4. Follow the onscreen steps and select the following:
      • Original data type: Delimited
      • Delimiters: Space
      • Column data format: General

 

Need to get in touch?

Contact us