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
_______________________________________________
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
