[Kmymoney] Processing ATM cash withdrawal transactions when importing OFX files

Maciej Grela maciej.grela at gmail.com
Wed Jul 4 20:38:59 UTC 2012


Hi,

I'm using KMyMoney 4.6.2 and I want to import an OFX file for my bank
transactions. Some of those include ATM cash withdrawals. An example
OFX transaction for such an operation looks like this:

<STMTTRN>
<FITID>77c5207cad9ebefaafb9762b0eb088164d990477</FITID>
<TRNTYPE>CASH</TRNTYPE>
<DTUSER>20120603</DTUSER>
<DTPOSTED>20120604</DTPOSTED>
<TRNAMT>-50.00</TRNAMT>
<MEMO>METRO WILANOWSKA   /WARSZAWA</MEMO></STMTTRN>

For this transaction KMyMoney creates a ledger entry that doesn't
transfer the funds to my cash account but instead to a automatically
created payee ("P000394"):

  <TRANSACTION postdate="2012-06-04" commodity="PLN" memo="METRO
WILANOWSKA   /WARSZAWA" id="T000000000000003478"
entrydate="2012-07-04">
   <SPLITS>
    <SPLIT payee="P000394" reconcileflag="0" shares="-50/1"
reconciledate="" action="" bankid="ID
77c5207cad9ebefaafb9762b0eb088164d990477" account="A000001" number=""
value="-50/1" memo="METRO WILANOWSKA   /WARSZAWA" id="S0001"/>
   </SPLITS>
   <KEYVALUEPAIRS>
    <PAIR key="Imported" value="true"/>
   </KEYVALUEPAIRS>
  </TRANSACTION>

I would like this transaction to be a transfer to my cash account like
this example ATM withdrawal, that I've entered manually (A000001 is my
checking account and A000147 is my cash account):

  <TRANSACTION postdate="2007-10-20" commodity="PLN" memo=""
id="T000000000000000065" entrydate="2007-10-21">
   <SPLITS>
    <SPLIT payee="" reconcileflag="0" shares="-60/1" reconciledate=""
action="" bankid="" account="A000001" number="" value="-60/1"
memo="WYPŁATA W BANKOMACIE&#xa;KBPBI/METRO WILANOW/WARSZAWA "
id="S0001"/>
    <SPLIT payee="" reconcileflag="0" shares="60/1" reconciledate=""
action="" bankid="" account="A000147" number="" value="60/1"
memo="WYPŁATA W BANKOMACIE&#xa;KBPBI/METRO WILANOW/WARSZAWA "
id="S0002"/>
   </SPLITS>
  </TRANSACTION>

Is there a way to import the OFX (or maybe reformat it a bit) so that
KMyMoney will create a transfer to a cash account of ATM "CASH" type
transactions in the OFX statement ?

Best regards,
Maciej Grela


More information about the KMyMoney mailing list