[GNC] Transactions for multiple accounts in 1 ofx file?

Kalpesh Patel kalpesh.patel at usa.net
Tue Aug 3 12:05:17 EDT 2021


Oh, I didn’t catch that change. I may need to go back to 4.4 version of GnuCash to get back that functionality in that case. That was by large my use case and that change takes away quite bit of usefulness from GnuCash for me. 

I was looking at the code base for libofx and it seems that handling of <INVBANKTRAN> is still hinted in the c header files so I wonder if this is a case where subtle change has just simply broken the handoff between two (libofx and GnuCash) and not being picked up as transaction is symptom of that or is it that that functionality was really removed from libofx rippling into GnuCash. IMHO, moving cash in and out of an account is tightly coupled with buying and selling an investment instrument in that account so that tactical seems counter intuitive philosophically.

Looks like you also submitted a bug report for this specific issue.


-----Original Message-----
From: David Reiser <dbreiser at icloud.com> 
Sent: Monday, August 02, 2021 6:21 PM
To: Kalpesh Patel <kalpesh.patel at usa.net>
Cc: David Carlson <david.carlson.417 at gmail.com>; Chris Good <goodchris96 at gmail.com>; Gnucash Users <gnucash-user at gnucash.org>
Subject: Re: [GNC] Transactions for multiple accounts in 1 ofx file?

There was a change in libofx 10.something that changed the way it interpreted cash transactions. I think they overdid it by taking the philosophy that any non-interest, non-dividend cash transaction should not be an investment transaction. In my case, that means that investment management fees are now skipped by the gnucash importer (I think) because libofx presents them differently to gnucash than it did before. 
--
Dave Reiser
dbreiser at icloud.com





> On Aug 2, 2021, at 11:56 AM, Kalpesh Patel <kalpesh.patel at usa.net> wrote:
> 
> 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 <david.carlson.417 at gmail.com>
> Sent: Sunday, August 01, 2021 7:19 AM
> To: Chris Good <goodchris96 at gmail.com>
> Cc: Kalpesh Patel <kalpesh.patel at usa.net>; Gnucash Users 
> <gnucash-user at gnucash.org>
> 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 <goodchris96 at gmail.com> 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 <goodchris96 at gmail.com <mailto:goodchris96 at gmail.com> 
> >
> Sent: Sunday, 1 August 2021 5:49 PM
> To: 'Kalpesh Patel' <kalpesh.patel at usa.net 
> <mailto:kalpesh.patel at usa.net> >
> Cc: gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org>
> 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 <kalpesh.patel at usa.net 
> <mailto:kalpesh.patel at usa.net> >
> Sent: Sunday, 1 August 2021 5:05 AM
> To: goodchris96 at gmail.com <mailto:goodchris96 at gmail.com>
> Cc: gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org>
> 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
> gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org> 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
> gnucash-user at gnucash.org
> 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.



More information about the gnucash-user mailing list