There seems to be different potential bug in the ofx import it looks like.
I have a ofx file from a large brokerage house here in the US which has both
the mutual fund transaction and a bank transaction in a single account. It
looks like the cash transactions are not being picked up by the importer. For
example, transactions for mutual fund purchase that is picked up is:
<BUYMF>
<INVBUY>
<INVTRAN>
<FITID>X8278800004101620210520
<DTTRADE>20210520120000
<MEMO>YOU BOUGHT PROSPECTUS
</INVTRAN>
<SECID>
<UNIQUEID>31635T708
<UNIQUEIDTYPE>CUSIP
</SECID>
<UNITS>+0000000000008.09800
<UNITPRICE>000000014.950000000
<COMMISSION>+00000000000000.0000
<FEES>+00000000000000.0000
<TOTAL>-00000000000121.0600
<CURRENCY>
<CURRATE>1.00
<CURSYM>USD
</CURRENCY>
<SUBACCTSEC>CASH
<SUBACCTFUND>CASH
</INVBUY>
<BUYTYPE>BUY
</BUYMF>
But it didn’t pick up following transactions from the same account:
<INVBANKTRAN>
<STMTTRN>
<TRNTYPE>DEP
<DTPOSTED>20210504120000
<TRNAMT>+00000000000064.1500
<FITID>X8278800002501120210504
<NAME>DIRECT DEPOSIT ELA
<MEMO>DIRECT
DEPOSIT ELAN CARDSVCRedemption
<CURRENCY>
<CURRATE>1.00
<CURSYM>USD
</CURRENCY>
</STMTTRN>
<SUBACCTFUND>CASH
</INVBANKTRAN>
I did a test where I created a brand new file with just (all) basic account
types and then imported the file. Sure enough it only registered buy/sell
transactions but skipped all the banking transactions in the import windows.
It asked to create new (MF) securities and assign accounts appropriately but no
cash transactions in any of them. I tried this exercise with version 4.5 of
gnucash on Windows 10 (my base OS). I can provided anonymized ofx file if there
is interest to debug it further.
I installed 4.6 version but I ran into two issues with it which might be
separate from ofx importers: 1) I am seeing silent crash between file à quit
and the actual process being removed from the process list. The symptoms I see
is that when I relaunch next time it tells me that the lock file is still there
on random occasions which shouldn’t be as I went through the proper exit
process. And 2) actions à Check & Repairs à Check & Repair All where it simply
hangs indefinitely after checking few accounts and need to kill the process
from the task manager. The update status bar in the lower right corner goes dim
and does not update for minutes on and the cursor on the window shows a busy
process. I am not 100% sure what is going on with the execution, hence I have
avoided calling them “found” bugs at this time. I reverted to 4.5 of gnucash
and see neither of these issues so I have stayed back.
Kalpesh…
From: David Carlson <[email protected]>
Sent: Sunday, August 01, 2021 7:19 AM
To: Chris Good <[email protected]>
Cc: Kalpesh Patel <[email protected]>; Gnucash Users
<[email protected]>
Subject: Re: [GNC] Transactions for multiple accounts in 1 ofx file?
You will also note that bug report is dated in 2003, the concern was raised
then with the hint that it was inherent in the OFX specification and therefore
probably difficult or impossible to fix.
The most recent changes to the generic import assistant allows re-ordering the
entries into chronological order which will put the duplicate d transactions
close to each other on the screen, making them very easy to spot and manually
pick one or the other to keep.
I think there is no need to automatically skip one or the other unless the
split notes are merged as I suggested in my previous email.
If you really want to get fancy, highlight the duplicate s and offer to skip
one or the other.
On Sun, Aug 1, 2021, 3:12 AM Chris Good <[email protected]> wrote:
When I went to create a bug for this I found one already exists:
https://bugs.gnucash.org/show_bug.cgi?id=105334
Import multiple account OFX files with transfers between the accounts,
duplicate transactions are generated
Regards,
Chris Good
-----Original Message-----
From: Chris Good <[email protected] <mailto:[email protected]> >
Sent: Sunday, 1 August 2021 5:49 PM
To: 'Kalpesh Patel' <[email protected] <mailto:[email protected]> >
Cc: [email protected] <mailto:[email protected]>
Subject: RE: Transactions for multiple accounts in 1 ofx file?
Hi Kalpesh Patel,
Your hiccup sounds exactly like the problem I have described.
2 people have now said they have transactions from multiple bank accounts in
the 1 .ofx file, so there are probably many more who do not subscribe to
this email list and who also may come across this problem. I will raise a
bug to document it.
If Covid-19 lockdown continues for much longer I may have enough time to try
to fix this myself.
Regards,
Chris Good
-----Original Message-----
From: Kalpesh Patel <[email protected] <mailto:[email protected]> >
Sent: Sunday, 1 August 2021 5:05 AM
To: [email protected] <mailto:[email protected]>
Cc: [email protected] <mailto:[email protected]>
Subject: Re: Transactions for multiple accounts in 1 ofx file?
I use it in this manner all the time and works great.
I use an old program called pocketsense, which I modified a bit, which goes
out to multiple institutions, downloads from each in ofx format and then
combines them into single ofx file to import it into gnucash. Literally
speaking they all are concatenation of individual files into one. It has
been working fine since version 3.5 (or earlier I think).
Only hickup that I see now and then is If transaction are across two
accounts (example a transfer) in ofx then gnucash doesn't cross correlate
them but if that happens then I disable import for the "seconds" account,
finish first import and then perform second import of the same file and then
it cross correlates automatically. Nice thing with ofx import in gnucash is
that you can import same file multiple times but not get duplicated entries
for the same transaction.
I have tested combined ofx file that has investment account, banking account
and a credit card account and if anything it is one of the robust feature of
gnucash, IMHO.
-----
Excuse the typos. It's the mobile thingy!
_______________________________________________
gnucash-user mailing list
[email protected] <mailto:[email protected]>
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
_______________________________________________
gnucash-user mailing list
[email protected]
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
