Re: [GNC] Automatic account match doesn't work when import transactions
Thanks David! Well, the manual said that you could edit the rules manually, but how, and where? In the Generic Transaction Import Matcher Window? What do the checkboxes A, U+C and C mean? Nothing was explained in the manual. The manual also indicated that if no match found, the import process would assign the transaction to the Imbalanced account by default. However, if I assign the transaction to unmatched by uncheck all boxes, the transaction won't get imported at all. https://gnucash.org/docs/v5/C/gnucash-manual//trans-import.html#trans-import-matcher I am using GC 5.4 on Mac. Thanks! -- JC On 2/4/24 12:18 AM, David Cousens wrote: The rules are created automatically when you assign transfer accounts during the import matcher process when you first start importing. You have to complete the import after assigning the accounts to create the "rules" (actually a probability table for tokens in the desciption, amount and other fields). They cannot be created manually but therules created can be edited. The bayesian matcher is AFAIK the default. Check with Edit_>Preferences-> the select "use bayesian matching" Checkbox on the Import tab of the dialogue. Tools_>Import Map Editor allows you to edit the data in the probability tables which makes up the rules. Also see https://gnucash.org/docs/v5/C/gnucash-manual//trans-import.html On Sat, 2024-02-03 at 21:01 -0500, Jediator wrote: I couldn't get the automatic account match to work when importing bank/credit card transactions to GC. Is there anyway to manually create the matching rules? Thanks! -- JC ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] GnuCash with Interactive Brokers
While I am NOT with Interactive Broker, your best bet is to see if you can download transactions in OFX (Open Financial Exchange) or QFX (Quicken Financial Exchange) format. That would be the best format and I believe most broker-dealers support that format as a download method from their web portal. -Original Message- From: km22 Sent: Sunday, February 04, 2024 4:57 AM To: gnucash-user@gnucash.org Subject: [GNC] GnuCash with Interactive Brokers Hi Gnucash Users, Does anyone on this mailing list have a method for importing transactions from Interactive Brokers (IBKR) to GnuCash? (Especially multi-currency users.) I currently enter all transactions manually but would like to explore ways of importing transactions. Please share your approach if so. Thanks, Ken ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Automatic account match doesn't work when import transactions
Mostly CSV files, but other file formats as well. On 2/3/24 9:26 PM, Steve Butler wrote: Which import? CSV? On Sun, Feb 4, 2024, 13:04 Jediator wrote: I couldn't get the automatic account match to work when importing bank/credit card transactions to GC. Is there anyway to manually create the matching rules? Thanks! -- JC ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Issues importing transactions (not matching)
Hello, I'm attempting to import transactions from a credit card QFX file / Quicken format. I have the pre-entered transaction as 'LEGO' in the amount of 45.14. The imported transaction is "LEGO Enfeild CT" in the amount of 45.14. Gnucash thinks these are not the same - and there are a number of other transactions that are the same way. How can I manually match these? or adjust it so they match? Thanks, Alan smime.p7s Description: S/MIME cryptographic signature ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] GnuCash with Interactive Brokers
I export a report from IB in QFX format* either when I have transactions or at the end of each month, and import it on GnuCash. It almost works perfectly, occasionally I have to fixup the account references for dividends. IB automatically provides reasonable non-conflicting filenames for the QFX exports too. (AcctNum_StartDate_EndDate.qfx) It has been a while since I had multi-currency transactions, but I don't remember it being an issue. I used to have IB autogenerate and email the reports to me - they would come as CSV, but dealing with duplicated transaction lines in that method was more tedious than using the QFX method. * - Performance & Reports, Statements, Quicken Web Connect; then select the date range you need. On 2/4/24 12:11, Jim DeLaHunt wrote: On 2024-02-04 01:56, km22 via gnucash-user wrote: Hi Gnucash Users, Does anyone on this mailing list have a method for importing transactions from Interactive Brokers (IBKR) to GnuCash? (Especially multi-currency users.) I currently enter all transactions manually but would like to explore ways of importing transactions. Me too! I have Interactive Brokers accounts in two currencies. While the volume of transactions is low enough that I can keep up by hand entry, I would like to learn a more automated method. I encourage contributions to the list and/or GnuCash wiki, not just individual emails to the original poster. Best regards, —Jim DeLaHunt ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] GnuCash with Interactive Brokers
On 2024-02-04 01:56, km22 via gnucash-user wrote: Hi Gnucash Users, Does anyone on this mailing list have a method for importing transactions from Interactive Brokers (IBKR) to GnuCash? (Especially multi-currency users.) I currently enter all transactions manually but would like to explore ways of importing transactions. Me too! I have Interactive Brokers accounts in two currencies. While the volume of transactions is low enough that I can keep up by hand entry, I would like to learn a more automated method. I encourage contributions to the list and/or GnuCash wiki, not just individual emails to the original poster. Best regards, —Jim DeLaHunt ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Multiple Fiscal Years
On 2/3/2024 7:13 PM, Jay McSkimming wrote: Hi Is there any solution (other than repeated manual system-wide changes) to allow for multiple fiscal years for different sets of accounts arising from different country tax years? Are there any add-ons or means to allow this? Any help appreciated. Thanks in advance Means to allow this" 1) Use explicit dates for all reports rather than relative to "current fiscal year". You don't NEED to utilize "fiscal year" in the program sense as opposed to the ;logical sense. Note that you are not being clear when you say "different sets of accounts" whether you mean in separate books or in the same books. 2) If in separate sets of books, you can use "current fiscal year", etc. by creating multiple users on your computer (multiple logins). For example, you probably have (should have) at least two, you yourself as an ordinary user, and as a user with supervisor rights). Well you can create additional ordinary users, just as if multiple people were using your computer. The computer isn't going to know or care all the same human. I don't think Stan's objection is very strong. IF the reason this is being done because reporting for different countries then having shared preferences, report formats, etc. is probably not what you want as the requirements of each country might be different. Even if currently the same, might become different at any time. Yes, a bit more work for the ones where at the current time the requirements the same, but allows for change to any if/when that happens. In other words, look at this in reverse and look at the question "I report to a number of entities and because they were all requiring the same report format, I was sharing this. But now one of there entities requires a different format for some of the reports. Not a BIG change. So how do I unsplit the shared saved format so I can alter one of them?" Michael D Novack ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Multiple Fiscal Years
On Sun, 4 Feb 2024 11:13:49 +1100 Jay McSkimming wrote: > Hi > > Is there any solution (other than repeated manual system-wide > changes) to allow for multiple fiscal years for different sets of > accounts arising from different country tax years? > > Are there any add-ons or means to allow this? > > Any help appreciated. > > Thanks in advance > > Jay If you are on a multi-user OS, then you can have different book preferences for each user. If this is an ongoing need, consider making some more logins, one for each country involved, and split those accounts into the appropriate "users". Liz ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] GnuCash with Interactive Brokers
Hi Gnucash Users, Does anyone on this mailing list have a method for importing transactions from Interactive Brokers (IBKR) to GnuCash? (Especially multi-currency users.) I currently enter all transactions manually but would like to explore ways of importing transactions. Please share your approach if so. Thanks, Ken ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.