Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

"Nothing to import" when trying to import OFX generated by ofxstatement #813

Open
Holzhaus opened this issue Dec 10, 2024 · 4 comments
Open

Comments

@Holzhaus
Copy link

The tool ofxstatement converts custom CSV formats from various banks into the OFX format. From the description:

Tool to convert proprietary bank statement to OFX format, suitable for importing to GnuCash or other personal finance applications.

Unfortunately, import in Denaro fails with "Nothing to import". I guess some fields that Denaro expects are missing.

@Holzhaus
Copy link
Author

Related issue on the ofxstatement issue tracker: kedder/ofxstatement#327

@Holzhaus
Copy link
Author

Is there a OFX file supported by the Denaro importer available, that can be used as reference?

@Holzhaus
Copy link
Author

Holzhaus commented Dec 10, 2024

Here's a redacted version of the generated file (after passing it through xmllint --format for readability):

<?xml version="1.0"?>
<!--
OFXHEADER:100
DATA:OFXSGML
VERSION:102
SECURITY:NONE
ENCODING:UTF-8
CHARSET:NONE
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:NONE
-->
<OFX>
  <SIGNONMSGSRSV1>
    <SONRS>
      <STATUS>
        <CODE>0</CODE>
        <SEVERITY>INFO</SEVERITY>
      </STATUS>
      <DTSERVER>20241210194354</DTSERVER>
      <LANGUAGE>ENG</LANGUAGE>
    </SONRS>
  </SIGNONMSGSRSV1>
  <BANKMSGSRSV1>
    <STMTTRNRS>
      <TRNUID>0</TRNUID>
      <STATUS>
        <CODE>0</CODE>
        <SEVERITY>INFO</SEVERITY>
      </STATUS>
      <STMTRS>
        <CURDEF>EUR</CURDEF>
        <BANKACCTFROM>
          <BANKID>987654321</BANKID>
          <ACCTID>123456789</ACCTID>
          <ACCTTYPE>CHECKING</ACCTTYPE>
        </BANKACCTFROM>
        <BANKTRANLIST>
          <DTSTART>20241109</DTSTART>
          <DTEND>20241208</DTEND>
          <STMTTRN>
            <TRNTYPE>POS</TRNTYPE>
            <DTPOSTED>20241206</DTPOSTED>
            <DTUSER>20241206</DTUSER>
            <TRNAMT>-100.50</TRNAMT>
            <FITID>20241206abcdefghijklmnop</FITID>
            <NAME>Name of recipient</NAME>
            <MEMO>Foo bar GIROCARD transaction</MEMO>
            <CURRENCY>
              <CURSYM>EUR</CURSYM>
            </CURRENCY>
          </STMTTRN>
        </BANKTRANLIST>
        <LEDGERBAL>
          <BALAMT>9999.99</BALAMT>
          <DTASOF>20241208000000</DTASOF>
        </LEDGERBAL>
      </STMTRS>
    </STMTTRNRS>
  </BANKMSGSRSV1>
</OFX>

@Holzhaus
Copy link
Author

Apparently of statement generated non-compliant OFX: kedder/ofxstatement#332

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant