Hello,

I'm completely new to Skrooge, and so far I like it, but I'm stuck at importing OFX file from my bank. In fact I can import the file, but the resulting account shows all positive amounts (all credits and no debits). I'n not familiar with the OFX format, but it looks like my bank doesn't use +/- to mark the transaction type, but the TRNTYPE field to say Debit/Credit. Is there a way for me to directly map this in Skrooge or I will need to pre-process the OXF file somehow?
I'd appreciate any help.Thanks

PS.
I'm running Skrooge on macOS (maybe this is the issue )
Here's an excerpt of the OFX

Code: Select all

<?xml version="1.0" encoding="UTF-8"?>
<OFX>
  <STMTRS>
    <BANKACCTFROM>
      <BANKID>1100</BANKID>
      <ACCTID>[id]</ACCTID>
      <IBAN>[IBAN]</IBAN>
    </BANKACCTFROM>
    <BANKTRANLIST>
      <DTSTART>20150409</DTSTART>
      <DTEND>20170708</DTEND>
      <STMTTRN>
        <TRNTYPE>DEBIT</TRNTYPE>
        <DTPOSTED>20150410</DTPOSTED>
        <DTAVAIL>20150410</DTAVAIL>
        <TRNAMT>5.99</TRNAMT>
        <NAME>440577******2059 Stockholm 5.99EUR Spotify</NAME>
        <BANKACCTTO>
          <ACCTID>0</ACCTID>
        </BANKACCTTO>
        <MEMO>VE INT NAKUP POS EUR</MEMO>
        <CURRENCY>EUR</CURRENCY>
      </STMTTRN>
</OFX>

Hi,

Skrooge doesn't use its own OFX parser.
Skrooge used the library libofx (http://libofx.sourceforge.net/) to load OFX files.

I think that your bank doesn't respect the OFX norm because <TRNAMT> should be negative.

You can may be ask the question to the OFX team here: https://github.com/libofx/libofx/issues

Regards.

Thank you for the help. I'll try to figure out this thing, On KDE it seems to work without a problem.

Hi,

In fact, I implemented a workaround for this issue on Skrooge 1.11.0.
That's why, this is working well on linux.
This should work well on Mac too if you are able to install a version >= 1.11.0.

Regards.