![]() Registered Member ![]()
|
I have set up a couple of accounts using the "map to online account" button/tool.
With the exception of on account (Discover card), all works fine. However my Discover account shows numerous (100+) transactions of $0.00 with the vast majority (95+%) showing a payee/memo of something similar to 01903R. Within this noise I have found a few patterns,... The second and third digit appear to represent the day of the month,... but not always. It does appear that they could represent a 'transaction date' as opposed to a posting date and they are always within 3 of the ledger date. Example: I have a few transactions showing as 025xxR showing in the ledger for 8/28. The number of $0.00 transactions does not match the number of valid transactions. So they do not appear to me to be some sort of place-holder or pre-auth transaction. However, I suppose that they still could be. The questions are: How do filter these? (there has to be a better way than manually deleting $0.00 transactions) How do i figure out where they are coming from and why? Using Version 4.7.2 Using KDE Development Platform 4.14.3 on a: Model Name: MacBook Pro Model Identifier: MacBookPro11,5 Processor Name: Intel Core i7 Processor Speed: 2.8 GHz Number of Processors: 1 Total Number of Cores: 4 L2 Cache (per Core): 256 KB L3 Cache: 6 MB Memory: 16 GB Boot ROM Version: MBP114.0172.B09 |
![]() KDE Developer ![]()
|
Filtering is not that easy at this point. We need to know how these transactions look like in their raw form.
Create an empty file in your $HOME directory called ofxlog.txt. Then run the download using KMyMoney. Take a look at the file after you have stopped the program. WARNING: This file contains sensitive information like your login credentials and personal financial data. Don't post any contents of this file without making sure that such data is replaced with placeholder characters. To stop logging (KMyMoney keeps appending to this file if it is present), simply remove the $HOME/ofxlog.txt
ipwizard, proud to be a member of the KMyMoney forum since its beginning.
![]() openSuSE Leap 15.4 64bit, KF5 |
![]() Registered Member ![]()
|
Ipwizard,
Thank you for the reply! I filtered out my sensitive information. Then since the data came as a single line, I ran a text replacement of : </STMTTRN><STMTTRN> to </STMTTRN>\n<STMTTRN> then: cat ofxlog.txt |grep -e ">-0<" >ofxlog.grep.txt to provide a more human readable rendition of the relevant transactions. As a lame user it does not tell me much. I would have posted an attachment but it looks like I need perms. here's a snippet of 3 consecutive lines out of 117: <STMTTRN><TRNTYPE>DEBIT<DTPOSTED>20160730160000.000<TRNAMT>-0<FITID>FITID20160801-0.0KANE0<NAME>03068R</STMTTRN> <STMTTRN><TRNTYPE>DEBIT<DTPOSTED>20160731160000.000<TRNAMT>-0<FITID>FITID20160802-0.0GTEWP<NAME>03148R</STMTTRN> <STMTTRN><TRNTYPE>DEBIT<DTPOSTED>20160731160000.000<TRNAMT>-0<FITID>FITID20160803-0.0FTT26<NAME>03145R</STMTTRN> Again, thank you for taking the time! |
![]() Registered Member ![]()
|
Have you tried calling Discover and asking if they have any idea about these transactions? Sometimes you can get lucky and talk to someone who actually knows what's going on.
|
Registered users: Bing [Bot], Google [Bot]