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

[Allan]

On 05/07/12 13:38, Jack wrote:
> On 2012.07.05 05:30, Allan wrote:
>> 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,
>
> An ATM withdrawal would be just a withdrawal, unless you have created a
> KMM Cash account to track the cash in your wallet, in which case it is a
> transfer to that account. Unless my memory is worse than I remember, an
> OFX file could only specify a transfer between two accounts at the same
> institution, and I'm not sure if KMM would still take it as a deposit or
> withdrawal, rather than a transfer.
>
> Jack

Hi Jack

Agreed.  From what I see, the OP may have earlier withdrawn cash from an 
ATM, which he doesn't show, and then used the cash to make a payment, a 
second transaction, which he does show.

It seems to me he is trying to compress the two transactions into one, a 
transfer from his bank account to the payee.  Perhaps I'm missing something?

Allan