codinguser / gnucash-android

Gnucash for Android mobile companion application.
Apache License 2.0
1.23k stars 540 forks source link

GnuCash 2.4.11 cannot resolve imported transactions #100

Closed strainu closed 10 years ago

strainu commented 11 years ago

I imported the attached ofx file in GnuCash 2.4.11. I was asked to identify all accounts, which I did. GnuCash was only able to resolve 1 transaction. Could this be linked to bug #78 ?

strainu commented 11 years ago
ENCODING:UTF-8
OFXHEADER:100
DATA:OFXSGML
VERSION:211
SECURITY:NONE
CHARSET:UTF-8
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:NONE
<OFX>
  <BANKMSGSRSV1>
    <STMTTRNRS>
      <TRNUID>0</TRNUID>
      <STMTRS>
        <CURDEF>RON</CURDEF>
        <BANKACCTFROM>
          <BANKID>org.gnucash.android</BANKID>
          <ACCTID>3a271e472cca8dc39c8fdd21e0f0c897</ACCTID>
          <ACCTTYPE>SAVINGS</ACCTTYPE>
        </BANKACCTFROM>
        <BANKTRANLIST>
          <DTSTART>20130709204442[+2:EET]</DTSTART>
          <DTEND>20130709204442[+2:EET]</DTEND>
          <STMTTRN>
            <TRNTYPE>CREDIT</TRNTYPE>
            <DTPOSTED>20130706130750[+2:EET]</DTPOSTED>
            <DTUSER>20130706130750[+2:EET]</DTUSER>
            <TRNAMT>74.00</TRNAMT>
            <FITID>b0fe91a6-ee3a-4039-9bcf-ac0590582fe1</FITID>
            <NAME>Description</NAME>
            <BANKACCTTO>
              <BANKID>org.gnucash.android</BANKID>
              <ACCTID>7186e29f694830c761e82b101f626d0d</ACCTID>
              <ACCTTYPE>CHECKING</ACCTTYPE>
            </BANKACCTTO>
          </STMTTRN>
        </BANKTRANLIST>
        <LEDGERBAL>
          <BALAMT>74.00</BALAMT>
          <DTASOF>20130709204442[+2:EET]</DTASOF>
        </LEDGERBAL>
      </STMTRS>
      <STMTRS>
        <CURDEF>RON</CURDEF>
        <BANKACCTFROM>
          <BANKID>org.gnucash.android</BANKID>
          <ACCTID>d5f8af45ae18dfdf891c03445498a7fb</ACCTID>
          <ACCTTYPE>CHECKING</ACCTTYPE>
        </BANKACCTFROM>
        <BANKTRANLIST>
          <DTSTART>20130709204442[+2:EET]</DTSTART>
          <DTEND>20130709204442[+2:EET]</DTEND>
          <STMTTRN>
            <TRNTYPE>CREDIT</TRNTYPE>
            <DTPOSTED>20130707112259[+2:EET]</DTPOSTED>
            <DTUSER>20130707112259[+2:EET]</DTUSER>
            <TRNAMT>9.00</TRNAMT>
            <FITID>db469968-638b-4d0d-92af-8563752f9d9f</FITID>
            <NAME>Description</NAME>
            <BANKACCTTO>
              <BANKID>org.gnucash.android</BANKID>
              <ACCTID>7186e29f694830c761e82b101f626d0d</ACCTID>
              <ACCTTYPE>CHECKING</ACCTTYPE>
            </BANKACCTTO>
          </STMTTRN>
        </BANKTRANLIST>
        <LEDGERBAL>
          <BALAMT>9.00</BALAMT>
          <DTASOF>20130709204442[+2:EET]</DTASOF>
        </LEDGERBAL>
      </STMTRS>
      <STMTRS>
        <CURDEF>RON</CURDEF>
        <BANKACCTFROM>
          <BANKID>org.gnucash.android</BANKID>
          <ACCTID>7186e29f694830c761e82b101f626d0d</ACCTID>
          <ACCTTYPE>CHECKING</ACCTTYPE>
        </BANKACCTFROM>
        <BANKTRANLIST>
          <DTSTART>20130709204442[+2:EET]</DTSTART>
          <DTEND>20130709204442[+2:EET]</DTEND>
          <STMTTRN>
            <TRNTYPE>DEBIT</TRNTYPE>
            <DTPOSTED>20130709124753[+2:EET]</DTPOSTED>
            <DTUSER>20130709124753[+2:EET]</DTUSER>
            <TRNAMT>-10.50</TRNAMT>
            <FITID>51c7fd6b-3278-400e-b244-9b4a7460ceea</FITID>
            <NAME>Description</NAME>
            <BANKACCTTO>
              <BANKID>org.gnucash.android</BANKID>
              <ACCTID>c79b0eb15b0be325fea717f6bb6d0d72</ACCTID>
              <ACCTTYPE>CHECKING</ACCTTYPE>
            </BANKACCTTO>
          </STMTTRN>
          <STMTTRN>
            <TRNTYPE>DEBIT</TRNTYPE>
            <DTPOSTED>20130708172133[+2:EET]</DTPOSTED>
            <DTUSER>20130708172133[+2:EET]</DTUSER>
            <TRNAMT>-3.50</TRNAMT>
            <FITID>0962bb61-a4b8-445e-b8c1-8cb3bd199f92</FITID>
            <NAME>Description</NAME>
            <BANKACCTTO>
              <BANKID>org.gnucash.android</BANKID>
              <ACCTID>1634b431f087f501d35cd32d4ea87eb4</ACCTID>
              <ACCTTYPE>CHECKING</ACCTTYPE>
            </BANKACCTTO>
          </STMTTRN>
          <STMTTRN>
            <TRNTYPE>DEBIT</TRNTYPE>
            <DTPOSTED>20130708172053[+2:EET]</DTPOSTED>
            <DTUSER>20130708172053[+2:EET]</DTUSER>
            <TRNAMT>-2.00</TRNAMT>
            <FITID>d3ec7bc7-b04f-4fc0-8f9b-138b55d659df</FITID>
            <NAME>Timbre fiscale</NAME>
            <BANKACCTTO>
              <BANKID>org.gnucash.android</BANKID>
              <ACCTID>2d61ef913005748515e35f9e7905b5c0</ACCTID>
              <ACCTTYPE>CHECKING</ACCTTYPE>
            </BANKACCTTO>
          </STMTTRN>
          <STMTTRN>
            <TRNTYPE>DEBIT</TRNTYPE>
            <DTPOSTED>20130707112259[+2:EET]</DTPOSTED>
            <DTUSER>20130707112259[+2:EET]</DTUSER>
            <TRNAMT>-9.00</TRNAMT>
            <FITID>db469968-638b-4d0d-92af-8563752f9d9f</FITID>
            <NAME>Description</NAME>
            <BANKACCTTO>
              <BANKID>org.gnucash.android</BANKID>
              <ACCTID>d5f8af45ae18dfdf891c03445498a7fb</ACCTID>
              <ACCTTYPE>CHECKING</ACCTTYPE>
            </BANKACCTTO>
          </STMTTRN>
          <STMTTRN>
            <TRNTYPE>DEBIT</TRNTYPE>
            <DTPOSTED>20130706130750[+2:EET]</DTPOSTED>
            <DTUSER>20130706130750[+2:EET]</DTUSER>
            <TRNAMT>-74.00</TRNAMT>
            <FITID>b0fe91a6-ee3a-4039-9bcf-ac0590582fe1</FITID>
            <NAME>>Description</NAME>
            <BANKACCTTO>
              <BANKID>org.gnucash.android</BANKID>
              <ACCTID>3a271e472cca8dc39c8fdd21e0f0c897</ACCTID>
              <ACCTTYPE>SAVINGS</ACCTTYPE>
            </BANKACCTTO>
          </STMTTRN>
        </BANKTRANLIST>
        <LEDGERBAL>
          <BALAMT>-99.00</BALAMT>
          <DTASOF>20130709204442[+2:EET]</DTASOF>
        </LEDGERBAL>
      </STMTRS>
      <STMTRS>
        <CURDEF>RON</CURDEF>
        <BANKACCTFROM>
          <BANKID>org.gnucash.android</BANKID>
          <ACCTID>1634b431f087f501d35cd32d4ea87eb4</ACCTID>
          <ACCTTYPE>CHECKING</ACCTTYPE>
        </BANKACCTFROM>
        <BANKTRANLIST>
          <DTSTART>20130709204442[+2:EET]</DTSTART>
          <DTEND>20130709204442[+2:EET]</DTEND>
          <STMTTRN>
            <TRNTYPE>CREDIT</TRNTYPE>
            <DTPOSTED>20130708172133[+2:EET]</DTPOSTED>
            <DTUSER>20130708172133[+2:EET]</DTUSER>
            <TRNAMT>3.50</TRNAMT>
            <FITID>0962bb61-a4b8-445e-b8c1-8cb3bd199f92</FITID>
            <NAME>Description</NAME>
            <BANKACCTTO>
              <BANKID>org.gnucash.android</BANKID>
              <ACCTID>7186e29f694830c761e82b101f626d0d</ACCTID>
              <ACCTTYPE>CHECKING</ACCTTYPE>
            </BANKACCTTO>
          </STMTTRN>
        </BANKTRANLIST>
        <LEDGERBAL>
          <BALAMT>3.50</BALAMT>
          <DTASOF>20130709204442[+2:EET]</DTASOF>
        </LEDGERBAL>
      </STMTRS>
      <STMTRS>
        <CURDEF>RON</CURDEF>
        <BANKACCTFROM>
          <BANKID>org.gnucash.android</BANKID>
          <ACCTID>2d61ef913005748515e35f9e7905b5c0</ACCTID>
          <ACCTTYPE>CHECKING</ACCTTYPE>
        </BANKACCTFROM>
        <BANKTRANLIST>
          <DTSTART>20130709204442[+2:EET]</DTSTART>
          <DTEND>20130709204442[+2:EET]</DTEND>
          <STMTTRN>
            <TRNTYPE>CREDIT</TRNTYPE>
            <DTPOSTED>20130708172053[+2:EET]</DTPOSTED>
            <DTUSER>20130708172053[+2:EET]</DTUSER>
            <TRNAMT>2.00</TRNAMT>
            <FITID>d3ec7bc7-b04f-4fc0-8f9b-138b55d659df</FITID>
            <NAME>Description</NAME>
            <BANKACCTTO>
              <BANKID>org.gnucash.android</BANKID>
              <ACCTID>7186e29f694830c761e82b101f626d0d</ACCTID>
              <ACCTTYPE>CHECKING</ACCTTYPE>
            </BANKACCTTO>
          </STMTTRN>
        </BANKTRANLIST>
        <LEDGERBAL>
          <BALAMT>2.00</BALAMT>
          <DTASOF>20130709204442[+2:EET]</DTASOF>
        </LEDGERBAL>
      </STMTRS>
      <STMTRS>
        <CURDEF>RON</CURDEF>
        <BANKACCTFROM>
          <BANKID>org.gnucash.android</BANKID>
          <ACCTID>c79b0eb15b0be325fea717f6bb6d0d72</ACCTID>
          <ACCTTYPE>CHECKING</ACCTTYPE>
        </BANKACCTFROM>
        <BANKTRANLIST>
          <DTSTART>20130709204442[+2:EET]</DTSTART>
          <DTEND>20130709204442[+2:EET]</DTEND>
          <STMTTRN>
            <TRNTYPE>CREDIT</TRNTYPE>
            <DTPOSTED>20130709124753[+2:EET]</DTPOSTED>
            <DTUSER>20130709124753[+2:EET]</DTUSER>
            <TRNAMT>10.50</TRNAMT>
            <FITID>51c7fd6b-3278-400e-b244-9b4a7460ceea</FITID>
            <NAME>Description</NAME>
            <BANKACCTTO>
              <BANKID>org.gnucash.android</BANKID>
              <ACCTID>7186e29f694830c761e82b101f626d0d</ACCTID>
              <ACCTTYPE>CHECKING</ACCTTYPE>
            </BANKACCTTO>
          </STMTTRN>
        </BANKTRANLIST>
        <LEDGERBAL>
          <BALAMT>10.50</BALAMT>
          <DTASOF>20130709204442[+2:EET]</DTASOF>
        </LEDGERBAL>
      </STMTRS>
      <STMTRS>
        <CURDEF>RON</CURDEF>
        <BANKACCTFROM>
          <BANKID>org.gnucash.android</BANKID>
          <ACCTID>1c5f022505815b8591d9c8160d19505e</ACCTID>
          <ACCTTYPE>SAVINGS</ACCTTYPE>
        </BANKACCTFROM>
        <BANKTRANLIST>
          <DTSTART>20130709204442[+2:EET]</DTSTART>
          <DTEND>20130709204442[+2:EET]</DTEND>
          <STMTTRN>
            <TRNTYPE>DEBIT</TRNTYPE>
            <DTPOSTED>20130708121133[+2:EET]</DTPOSTED>
            <DTUSER>20130708121133[+2:EET]</DTUSER>
            <TRNAMT>-58.42</TRNAMT>
            <FITID>0b2cf092-8c0f-4643-9c36-b009de2a1240</FITID>
            <NAME>Description</NAME>
            <BANKACCTTO>
              <BANKID>org.gnucash.android</BANKID>
              <ACCTID>c81cae39a397ba7a3d2ca459af073a31</ACCTID>
              <ACCTTYPE>CHECKING</ACCTTYPE>
            </BANKACCTTO>
          </STMTTRN>
        </BANKTRANLIST>
        <LEDGERBAL>
          <BALAMT>-58.42</BALAMT>
          <DTASOF>20130709204442[+2:EET]</DTASOF>
        </LEDGERBAL>
      </STMTRS>
      <STMTRS>
        <CURDEF>RON</CURDEF>
        <BANKACCTFROM>
          <BANKID>org.gnucash.android</BANKID>
          <ACCTID>c81cae39a397ba7a3d2ca459af073a31</ACCTID>
          <ACCTTYPE>CHECKING</ACCTTYPE>
        </BANKACCTFROM>
        <BANKTRANLIST>
          <DTSTART>20130709204442[+2:EET]</DTSTART>
          <DTEND>20130709204442[+2:EET]</DTEND>
          <STMTTRN>
            <TRNTYPE>CREDIT</TRNTYPE>
            <DTPOSTED>20130708121133[+2:EET]</DTPOSTED>
            <DTUSER>20130708121133[+2:EET]</DTUSER>
            <TRNAMT>58.42</TRNAMT>
            <FITID>0b2cf092-8c0f-4643-9c36-b009de2a1240</FITID>
            <NAME>Description</NAME>
            <BANKACCTTO>
              <BANKID>org.gnucash.android</BANKID>
              <ACCTID>1c5f022505815b8591d9c8160d19505e</ACCTID>
              <ACCTTYPE>SAVINGS</ACCTTYPE>
            </BANKACCTTO>
          </STMTTRN>
        </BANKTRANLIST>
        <LEDGERBAL>
          <BALAMT>58.42</BALAMT>
          <DTASOF>20130709204442[+2:EET]</DTASOF>
        </LEDGERBAL>
      </STMTRS>
    </STMTTRNRS>
  </BANKMSGSRSV1>
</OFX>
codinguser commented 11 years ago

No, I don't think they are linked. But I'll have to check this. I don't think I've tested importing on the newest and greatest of Gnucash desktop

codinguser commented 10 years ago

As was noted in #70 only a subset of OFX features seem to be supported by GnuCash. However QIF is not implemented and should ease importing and matching of accounts and transactions.