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

[Jack]

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