Double posting on Import of OFX files
Jack
ostroffjh at aya.yale.edu
Tue Dec 16 16:11:44 GMT 2025
On 12/16/25 5:21 AM, Thomas Baumgart via KMyMoney wrote:
> On Montag, 15. Dezember 2025 22:15:14 CET MV via KMyMoney wrote:
>> I have 4 accounts at the same bank. I tend to transfer money between the
>> accounts.
>>
>> Call them acct1, acct2, acct3, acct4.
>>
>> In a simple case, let's say acct1 is used to transfer some money into each
>> of the other accounts (acct2, acct3, acct4).
>>
>> When I download and import the OFX files from the bank into KMyMoney (the
>> latest 5.2.1) on my Fedora box and import them, I get these results....
>>
>> Import acct1. I got the trans for acct1. And I get the corresponding
>> trans for the other three accounts (acct2, acct3, acct4) posted in those
>> accounts..
>>
>> Now I import acct2. And it also posts that same transfer from acct1, not
>> only in acct2 because it is in the acct2.ofx file, but also in acct1
>> because that's where the money came from.
>>
>> Ignoring acct3 & acct4 imports for now, we have double posting in acct1 and
>> acct2 for each transfer between acct1 and acct2.
>>
>> This might help other people, but it drives me crazy. I now have to edit
>> both accounts and delete the duplicates created by the import ofx
>> operations.
> I understand this problem, but don't have a quick fix for it at hand. To get
> there, please see below.
>
>> And if I were to import acct3.ofx and acct4.ofx, I would get more duplicate
>> transactions. And even more work to clean up the mess it makes.
>>
>> What if the ofx import had a checkbox that I could configure/set as needed
>> that would turn off that feature where an import (of acct1.ofx) of a
>> transfer of funds between acct1 and acct2 would not touch acct2 at all?
>> Then when I import acct2.ofx and set that same setting, it would post only
>> to acct2 and not to acct1.
> That may solve the problem on the visual front but would create more mess
> on the double-entry bookkeeping side as it would result in two unbalanced
> transactions due to a missing counter-account assignment.
>
>> I've searched the settings for KMyMoney, but have yet to find such a
>> setting that would fix my problem.
> Don't waste time on searching: it does not exist.
>
>> Can the developers (or anyone who thinks they have a fix) help me solve
>> this problem?
> Would you be willing to support development by supplying sample files? I
> will get back to you in a private conversation.
I have cases like this, most commonly when I pay bills
automatically/online from my main checking account to my credit card
accounts. When the transaction gets imported to the second account, i
just match the two transactions. I only need to do that in one of the
accounts, as that matches them in both accounts. Now that I think about
it, I'm not sure how those transactions get imported as transfers and
not just separate payment/deposits, but at least some are so because
they are also scheduled transactions. Matching two transactions seems
less work than deleting two transactions.
More information about the KMyMoney
mailing list