It is not a surprise that we use multiple date formats in our files.
Each country or each Firm uses different date format in their file.
How is it handled in Excel Transactions?
We don’t want to make any assumptions about the date formats.
Because it is difficult to arrive at a conclusion that “01-02-16” is January 2, 2016 or February 1, 2016.
So we have provided the settings to capture your date format.
If you have already imported your transactions using “Excel Transactions” and found that the date is wrong in your QuickBooks, you need to change your date settings.
If you are new to our app, please go through below steps.
- In the Upload screen, “Settings” button (red colored) is available. It will open up bunch of settings that can help your import.
The one which we interested currently is “Date Format”.
The drop down has several date formats as below. You can select the one as per your need.
DD-MM-YYYY (E.g. 15-01-2016)
DD-MM-YY (E.g. 15-01-16)
MM-DD-YYYY (E.g. 01-05-2016)
MM-DD-YY (E.g.: 01-15-16)
MM-DD-YY (E.g. 01-15-16)
YYYY-MM-DD (E.g. 2016-01-15)
YY-MM-DD (E.g. 16-01-15)
DD-MMM-YYYY (E.g. 15-JAN-2016)
DD-MMM-YY (E.g. 15-JAN-16)
MMM-DD-YYYY (E.g. JAN-15-2016)
MMM-DD-YY (E.g. JAN-15-16)
Don’t forget to “Save” the settings.
Wrong Date Format
It is very common that you might have missed this setting and tried to import. But we know that your file has different date format.
So we will alert you as below.
Our App warns you and ask you to open settings to change date format.
You can change the date format or upload.