[GNC] OFX import reverses charge/payment on CC account (Comenity BJ's MC)

[David Carlson]

Perhaps Comenity is to blame.  I have the same problem with Petco, which is
another Comenity card.

On Sun, Jan 22, 2023 at 12:59 AM Justin <justinvallon at gmail.com> wrote:

> 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 at 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.
>


-- 
David Carlson