Import Problems
Posted: 18 January 2015, 22:32
I am trying to import an OFX file from my bank, but whenever I do I receive a "error parsing data." On the import screen, I choose the OFX file format and choose my OFX file.
I have a feeling it may be due to the date/time format my bank uses for transactions. I've tried changing the Date format on the import screen with no luck. Here's an example transaction from my OFX file:
<INVBANKTRAN>
<STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20141221110000.000[-5:EST]</DTPOSTED>
<TRNAMT>-11.25
<FITID>4037466002014-12-222000000013
<NAME>SPEEDWAY 09314 MAS
<MEMO>Visa Deferred
</STMTTRN>
<SUBACCTFUND>CASH
</INVBANKTRAN>
Does anyone have any suggestions on how to get the import work?
Thanks a lot!
I have a feeling it may be due to the date/time format my bank uses for transactions. I've tried changing the Date format on the import screen with no luck. Here's an example transaction from my OFX file:
<INVBANKTRAN>
<STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20141221110000.000[-5:EST]</DTPOSTED>
<TRNAMT>-11.25
<FITID>4037466002014-12-222000000013
<NAME>SPEEDWAY 09314 MAS
<MEMO>Visa Deferred
</STMTTRN>
<SUBACCTFUND>CASH
</INVBANKTRAN>
Does anyone have any suggestions on how to get the import work?
Thanks a lot!