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

[Jack]

On 2012.07.05 03:39, Maciej Grela wrote:
> 2012/7/5 Jack <ostroffjh at sbcglobal.net>:
> > On 2012.07.04 16: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 just created a payee for myself, and used something in the memo  
> field to
> > match these transactions.  That way, editing them to change to a  
> transfer to
> > my cash account (and optionally removing the payee) is fairly  
> painless.  I
> > have not yet seen any way for an OFX transaction to be imported as a
> > transfer instead of a payment or deposit.
> >
> 
> Hi,
> 
> thanks for the tip, I will try to pre-process the OFX to put the
> transaction type in the memo so I can match it.
Maciej,

The whole point of my approach is not to have to edit the OFX file.   
For example, if "METRO WILANOWSKA   /WARSZAWA" refers to the location  
of the ATM machine, that is probably good to match.

Jack