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

[Maciej Grela]

2012/7/5 Allan <agander93 at gmail.com>:
> 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?
>

Hi Alan,

I'd like to clarify this further. I'm tracking cash payments (which I
enter manually based on paper receipts) on a Cash-type account in KMM.
For these the payee is the payee and that's simple.

I also have a bank checking account on which operations include both
card payments and ATM cash withdrawals. For this account I have an OFX
file which I want to import.

Now, I don't want to compress these two operations into one. The thing
I want is: when KMM imports an ATM cash withdrawal operation in the
OFX (marked by TRNTYPE "CASH") I'd like to have the amount added to my
cash account - so this would be a transfer between two accounts, not a
payment AFAIK.

For the time being Jack's solution is sufficient for me because I can
create a payee for myself, configure it to match all the transactions
with memos like "METRO WILANOWSKA /WARSZAWA" and set the default
category to be my cash account.

Br,
Maciej Grela