Gnucash OFX import transaction dates are wrong?

Question

I have exported transaction data from my credit card company in OFX format. When I import it into Gnucash, the dates that show for the transactions are off by a day or two compared to the dates on my statements. My guess is this has something to do with time zones.

Here’s an example record from the OFX file (slightly edited):

<STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20201208120000[0:GMT]
<TRNAMT>-1.00
<FITID>20201208(some more id values here)
<NAME>BUSINESS NAME
</STMTTRN>

Comparing this to my credit card statements the reported date is off by one day.

How can I fix this?

gnucash ofx

mhoran_psprep · Answer

I have seen in credit card and even debit card transaction two dates associated with each completed transaction.  The date it was processed by the bank which one of my cards calls the post date, and the date the card was scanned by the merchant which they call the transaction date.
Many times the dates are the same, many times they can be separated by a day or even two. I have seen this with online transactions, in person transactions, and even ones were there is a two step process such as at a gas station or restaurant.
Unless the data you are working with has both dates, then you have to hope the OFX file date matches the one in the monthly statement.  In the one card I was looking at today it is the transaction date that is the main one they show on the monthly statement.

Gnucash OFX import transaction dates are wrong?

One Answer

Add your own answers!

Ask a Question