Matching OFX Import - Changes Transaction Date

[Brendan Coupe]

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 <ostroffjh at 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/kmymoney-devel/attachments/20190524/4045b5cc/attachment-0001.html>