<div dir="ltr"><div class="gmail_default" style="font-family:monospace,monospace;font-size:x-small;color:#073763">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.</div><div class="gmail_default" style="font-family:monospace,monospace;font-size:x-small;color:#073763"><br></div><div class="gmail_default" style="font-family:monospace,monospace;font-size:x-small;color:#073763">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.</div><div class="gmail_default" style="font-family:monospace,monospace;font-size:x-small;color:#073763"><br></div><div class="gmail_default" style="font-family:monospace,monospace;font-size:x-small;color:#073763">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.</div><div class="gmail_default" style="font-family:monospace,monospace;font-size:x-small;color:#073763"><br></div><div class="gmail_default" style="font-family:monospace,monospace;font-size:x-small;color:#073763">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.</div><div class="gmail_default" style="font-family:monospace,monospace;font-size:x-small;color:#073763"><br></div><div class="gmail_default" style="font-family:monospace,monospace;font-size:x-small;color:#073763">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.</div><div><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><font color="#073763" face="monospace, monospace" size="1"><br></font></div><div dir="ltr"><font color="#073763" face="monospace, monospace" size="1">----<br>Brendan Coupe</font><br></div></div></div></div></div></div></div></div></div><br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Fri, May 24, 2019 at 5:11 PM Jack <<a href="mailto:ostroffjh@aya.yale.edu">ostroffjh@aya.yale.edu</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div bgcolor="#FFFFFF">
<div class="gmail-m_-8780388742257781777moz-cite-prefix">On 5/24/19 6:12 PM, Brendan Coupe
wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">
<div class="gmail_default" style="font-family:monospace,monospace;font-size:x-small;color:rgb(7,55,99)">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.</div>
<div class="gmail_default" style="font-family:monospace,monospace;font-size:x-small;color:rgb(7,55,99)"><br>
</div>
<div class="gmail_default" style="font-family:monospace,monospace;font-size:x-small;color:rgb(7,55,99)">Is
there any way to prevent this? The paycheck deposit date
should not be changed. It's screwing up that account.</div>
<div>
<div dir="ltr" class="gmail-m_-8780388742257781777gmail_signature">
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr"><font size="1" face="monospace,
monospace" color="#073763"><br>
</font></div>
<div dir="ltr"><font size="1" face="monospace,
monospace" color="#073763">----<br>
Brendan Coupe</font><br>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
<p>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.</p>
<p>Jack<br>
</p>
</div>
</blockquote></div>