[GNC] OFX import reverses charge/payment on CC account (Comenity BJ's MC)
Justin
justinvallon at gmail.com
Sun Jan 22 01:58:00 EST 2023
I noticed that my CC (BJ's via Comenity) has an OFX export, so I tried
it. Unfortunately, the signs are backwards:
Here are two snippets from the OFX:
<STMTTRN>
<TRNTYPE>Charge
<DTPOSTED>20221222120000[0:GMT]
<TRNAMT>26.42
<FITID>...
<CORRECTFITID>...
<CORRECTACTION>REPLACE
<NAME>BJS FUEL...
</STMTTRN>
<STMTTRN>
<TRNTYPE>Payment
<DTPOSTED>20221209120000[0:GMT]
<TRNAMT>-505.43
<FITID>...
<CORRECTFITID>...
<CORRECTACTION>REPLACE
<NAME>AUTOMATIC PAYMENT - THANK YOU
</STMTTRN>
This shows up as:
Date | Description | Account | Payment | Charge
2022-12-09 | AUTOMATIC PAYMENT - THANK YOU | CC | | 505.43
| Checking | 505.43 |
2022-12-22 | BJS Fuel | CC | 26.42 |
| Fuel | | 26.42
The "payment" to the CC from Checking is showing up as +505.43 in Checking.
I reversed the signs in the file (<TRNAMT>X to -X, -Y to Y), and the
reimported entries were correct.
I can write a script to correct the file, but wondering if anybody has
seen this. Maybe the OFX file is wrong, maybe import is wrong.
-Justin
More information about the gnucash-user
mailing list