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

[Allan]

On 04/07/12 21:38, Maciej Grela wrote:
> 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

I'm not an OFX user, so I could be talking bilge, but, to me your 
statement is for an amount of -50.00 cash.  I've imported your 
statement, and the account into which I loaded the import was debited 
with 50.00 (-50.00), and the 'payee' is credited with the corresponding 
amount.

To me, that looks correct.  I thought a transfer was from one of your 
accounts to another of them.

Allan