I think this is a little different. When I download my credit card I accept the dates that the bank processes the transaction even though it may be a day or two later than the actual transaction date. Same with checks that I've written, sometimes they don't hit the bank for a week or two. I accept the date the bank shows since that when it actually happens as far as the account is concerned. Doing this any other way sounds like way too much work.
With the paycheck it first ends up in my savings account based on the date the bank provides when I download the OFX for the savings account. Many categories get assigned when this happens, including the transfers to the 401(k) account. When it comes time to import and balance the 401(k) account I download the OFX file for it and import it. All of the paycheck related transactions are already in the account as transfers from the paychecks. The problem is that some of the 401(k) transactions don't register until 4 to 6 days after they paycheck date. If they match when I import the 401(k) OFX file it changes the date on the paycheck and every one of the categorized transactions that were originally posted on the date of the paycheck. I have no idea how to correct this but it seems to me that something has to be controlling when it comes to the date of the transaction. Right now it appears to be the last imported transaction wins. Maybe it shouldn't if the existing transaction was already an imported transaction. Or maybe there should be an option to use the transaction date of existing transactions when a newly imported transaction has a different date. After next weeks paycheck I will try re-importing the savings account and see if that switches the date back. Not a great workaround since I frequently only deal with the 401(k) once a quarter. I wish this was the only problem with this problem but the OFX file has the wrong sign on all of the numbers so I have to save it, run my growing OFX correction script on it and then import it. I have some many accounts making this mistake I wonder if there is a way to tell the KMM import process to swap the signs for some accounts. probably not since there are no settings for the import unless the account is mapped. ---- Brendan Coupe On Fri, May 24, 2019 at 5:11 PM Jack <ostrof...@aya.yale.edu> wrote: > On 5/24/19 6:12 PM, Brendan Coupe wrote: > > I'm importing an OFX file for a 401(k) account (retirement account at > work). The transactions are not reported on the date of the paycheck, > sometimes they are record close to a week later. When I import the > transactions and they match with the category in the paycheck entry in my > savings account, the date of the paycheck transaction in my savings account > is changed. This happens when they match automatically and when I tighten > the import date matching criteria and match them manually. > > Is there any way to prevent this? The paycheck deposit date should not be > changed. It's screwing up that account. > > ---- > Brendan Coupe > > This is another one I've also run into, in my case with checking and > credit card accounts. I prefer to keep my KMM accounts using transaction > date, but the imported settlement date or post date of the bank always > overrides the manually entered date. I think I put in a wishlist about > this, but I'm not sure. It makes sense if you are trying to have your KMM > account exactly match the institution's account, but not everybody does > that. > > Jack >
