[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