All Transactions use today's (import) date instead of the transaction date

All Transactions use today's (import) date instead of the transaction date

#57418
Need more info Opened

I am converting a Credit Card CSV file to QIF.  Everything comes out fine except the date which shows today  (the date when the conversion is done) instead of the day the transaction took place.

Len*** Tue, 2 Jun 2020 - 01:25

Was this resolved. I'm having same problem.  Is it related to the date format used in the original excel file?

Len*** Tue, 2 Jun 2020 - 02:25

I was having this problem, too.  I was using dd/mm/yyyy format.   So, I changed by source data in Excel to m/d/yyyy, and of course then selected mm/dd/yyy in the converter, and now my dates are all loaded.

CSV*** Sat, 22 Aug 2020 - 21:01

For this to work, it is necessary that the CSV contains the format specified. I have seen reports for this kind of issue but the CSV contained only Month and Day, the Year was missing. In that case the best thing to do is to open the CSV in Excel and add the Year, so the format matches what you selected

CSV*** Tue, 25 Aug 2020 - 00:28

I converted the attached CSV and it worked

Mapped as:

  • Date YYYY/MM/DD
  • Ignore
  • Payee
  • Category
  • Amount
  • Ignore

Thre resulting QIF looks like this

!Type:Bank

D2020/01/07

T36.87

PFARM BOY #65

LGROCERY

^

D2020/01/07

T18.75

PPARK...

LTRAVEL

^

D2020/01/07

T9.92

PSUBWAY # 54091

LDINING