[GNC] how to encode ATM withdrawals with fees
when withdrawing at a foreign location, most of the time you get charged a fee. So, for example, your bank is in PHP, then when you're in Japan, you withdraw in JPY. Here are the facts: 1. You receive JPY10,000.00 2. ATM charges JPY110.00 3. Your local bank shows a withdrawal of PHP4282.49 4. At the time of this transaction the exchange rate was: JPY1 = PHP0.3928 or PHP1 = JPY2.5456 in GNUCASH, the splits I have are: Account Deposit Withdrawal JPYCash JPY1 0 Fee PHP PHP43.21 0 Imbalance PHP PHP311.28 0 Trading:CURRENCY:PHP PHP3928 0 Local Bank PHP 0 PHP4282.49 Trading:CURRENCY:JPY 0 JPY1 Questions: 1. What is the easiest way to do this? I find this one transaction to be of so many steps. Perhaps there's a way that I don't know of? 2. Is there an easier way to specify the 110JPY fee if my base currency is PHP? I had to manually convert it using the date's exchange rate to come up with the equivalent PHP43.21. 3. The imbalance-PHP was automatically calculated by GNUCASH. Is this considered to be my loss from the difference between the bank's exchange rates and the one I used which I got from https://www.exchange-rates.org/exchange-rate-history/jpy-php? Thanks gio ___ 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] Issues Recognizing Account Names When Importing CSV into GnuCash
Thank you On Sat, Oct 7, 2023 at 3:35 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > If I'm not mistaken, you should only have to do this once per account. > Now, combining this with your other question, there is reason #2 to > break this into smaller import chunks. You don't want to have to > manually assign those in a large quantity in a single pass. > > Regards, > Adrien > > On 10/7/23 12:01 AM, Gio Bacareza wrote: > > I'm experiencing difficulties when importing a CSV file into GnuCash, > > particularly when the file contains both "Account" and "Target Account" > > columns. Despite meticulously encoding the account names in the CSV to > > match the exact account names as they appear in GnuCash (e.g., > > “Asset:Cash”), the software does not seem to automatically recognize and > > match these names during the import process. > > > > Instead, GnuCash prompts me to manually match the account names through > its > > import wizard every time, which is unexpected and inconvenient. For > > instance, even if the CSV file contains the precise name “Asset:Cash”, > > GnuCash still requires manual intervention to match the names correctly. > > > > Is there a specific reason for this issue, or am I possibly making an > error > > during the import process? I would appreciate any insight or advice on > how > > to streamline this process and ensure GnuCash recognizes account names > from > > the CSV file automatically. > > > > ___ > 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. > -- cheers, Gio ___ 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] Issues Importing a Large CSV with Multiple Accounts into GnuCash: Is Duplicated Transactions Normal?
Thank you, Adrien. I get it now. On Sat, Oct 7, 2023 at 3:33 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > This is one of the reasons why it is not recommended to import a large > file, especially one containing transactions from more than a single > account on one side of each transaction. > > Read over the Help Manual & the Tutorial & Concepts Guide concerning > imports. > > The usual recommended procedure is to break the import into smaller > chunks depending on how many transactions you have in a month/year, etc. > > So for example, you might import January 2023 of your checking account. > (from whatever other app, or from a bank download) Then reconcile, and > repeat for February, then March, etc. > > As you go, you are training the matcher, so the imports speed up, and > duplicates are detected. > > It is up to you, how big the import chunks are, but bigger is not > necessarily faster, and maybe rarely is. > > Regards, > Adrien > > On 10/6/23 11:57 PM, Gio Bacareza wrote: > > I've been attempting to import a large, consolidated CSV file containing > > multiple accounts into GnuCash. Previously, I used to import transaction > > logs from various accounts individually, which I thought was a cumbersome > > process. To simplify this, I’ve created scripts to compile all > transactions > > into one comprehensive CSV file for what I thought would be a more > > straightforward import process. > > > > However, I've encountered an issue where GnuCash duplicates certain > > transactions during the import. Specifically, this happens when a > > transaction represents a withdrawal from one account and a deposit into > > another, which are naturally recorded as two separate entries in the CSV. > > For instance, when money is withdrawn from a bank account and deposited > > into a cash account, the consolidated CSV file includes one row showing > the > > bank account debit and another showing the cash account credit. > > > > I assumed that GnuCash’s import algorithm would recognize and eliminate > > these duplicate transactions during the import process as it typically > does > > with other duplicates. Unfortunately, my tests indicate that it imports > > both transactions, resulting in duplicated entries. > > > > Is this a mistake on my part, or is this behavior expected from GnuCash > > when importing a large CSV with multiple accounts? Any insights or > > solutions to prevent these duplicates would be greatly appreciated. > > > > ___ > 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. > -- cheers, Gio ___ 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 Recognizing Account Names When Importing CSV into GnuCash
I'm experiencing difficulties when importing a CSV file into GnuCash, particularly when the file contains both "Account" and "Target Account" columns. Despite meticulously encoding the account names in the CSV to match the exact account names as they appear in GnuCash (e.g., “Asset:Cash”), the software does not seem to automatically recognize and match these names during the import process. Instead, GnuCash prompts me to manually match the account names through its import wizard every time, which is unexpected and inconvenient. For instance, even if the CSV file contains the precise name “Asset:Cash”, GnuCash still requires manual intervention to match the names correctly. Is there a specific reason for this issue, or am I possibly making an error during the import process? I would appreciate any insight or advice on how to streamline this process and ensure GnuCash recognizes account names from the CSV file automatically. -- cheers, Gio ___ 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 a Large CSV with Multiple Accounts into GnuCash: Is Duplicated Transactions Normal?
I've been attempting to import a large, consolidated CSV file containing multiple accounts into GnuCash. Previously, I used to import transaction logs from various accounts individually, which I thought was a cumbersome process. To simplify this, I’ve created scripts to compile all transactions into one comprehensive CSV file for what I thought would be a more straightforward import process. However, I've encountered an issue where GnuCash duplicates certain transactions during the import. Specifically, this happens when a transaction represents a withdrawal from one account and a deposit into another, which are naturally recorded as two separate entries in the CSV. For instance, when money is withdrawn from a bank account and deposited into a cash account, the consolidated CSV file includes one row showing the bank account debit and another showing the cash account credit. I assumed that GnuCash’s import algorithm would recognize and eliminate these duplicate transactions during the import process as it typically does with other duplicates. Unfortunately, my tests indicate that it imports both transactions, resulting in duplicated entries. Is this a mistake on my part, or is this behavior expected from GnuCash when importing a large CSV with multiple accounts? Any insights or solutions to prevent these duplicates would be greatly appreciated. -- cheers, Gio ___ 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] How to do property asset and loan when acquired in the past
Hi guys, this is my scenario simplified with hypothetical figures: 1. I bought property ex valued at $100 5 years ago. 2. I start with GnuCash today 3. As of today, let's say I have paid off a part of the loan, and let's say I have $25 left to pay. Is this how you would do it? 1. create an asset account with a beginning balance of $100 to capture the value of the property. 2. create a liability account with a beginning balance of $25 3. track transactions on the loan, eg interests and payments moving forward not an accounting expert. -- cheers, Gio ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] currency symbol problem in reports
Thanks John. I did try those settings, first to P. Then I realized null would be better but it defaulted back. So a space is a solution. I didn't think of that. Thanks much for your help had to resend coz first was just reply to you. On Sun, Feb 28, 2021, 9:32 AM John Ralls wrote: > Not in settings, in the security editor. Open the Currencies namespace, > find and select the currency, and select Edit. There's a spot for Display > Symbol. Deleting it will get the default but a space will replace it. That > might make amounts look odd in some places but should be OK on most. > > Regards, > John Ralls > > > > On Feb 27, 2021, at 1:37 PM, D. via gnucash-user < > gnucash-user@gnucash.org> wrote: > > > > ISTR that there is a place in the settings to choose the character to > display with each currency. Never tried it though. > > > > > > Original Message > > From: Gio Bacareza > > Sent: Sat Feb 27 09:18:47 EST 2021 > > To: Jim DeLaHunt > > Cc: GnuCash Users > > Subject: Re: [GNC] currency symbol problem in reports > > > > I use Arial which should have it. But for some reason Gnucash does not > > render it. > > > > If you copy paste the report to another program like a text editor or > > excel, the peso sign shows up. > > > > But to be honest I really just want to eliminate currency symbols. I > mostly > > work in pesos so there is no added information it gives me. > > > > Is there a way to configure such that no currency symbol is displayed or > > printed? > > > > thanks > > > > On Sat, Feb 27, 2021 at 4:32 PM Jim DeLaHunt > wrote: > > > >> On 2021-02-26 17:21, Gio Bacareza wrote: > >> > >>> This seems to be a nagging problem with currencies in reports. I > thought > >> I > >>> had solved this in previous versions of mac that I'm using but it's > back > >>> again with Big Sur and the remedies that worked before no longer works > >> now. > >>> > >>> My currency is Philippine Peso. Reports show a square looking symbol > >> which > >>> could probably mean it could not find the right font. > >> > >> According to Wikipedia, the Philippine Peso symbol is "₱". It looks like > >> a capital "P" with two horizontal lines through the upper bowl. The > >> Unicode code point is U+20B1. > >> > >> What font are you using to format the report? I suspect that not all > >> fonts contain this character. On my Mac, the main system fonts like > >> Arial and Courier have it, the pan-Unicode fonts like Noto Sans have it, > >> but more specialised text fonts like Calibri do not. > >> > >> [1] https://en.wikipedia.org/wiki/Philippine_peso_sign > >> > >> Hope this helps, > >> > >> —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 > >> 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. > >> > > > > > > -- > > cheers, > > > > Gio > > ___ > > gnucash-user mailing list > > gnucash-user@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@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@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.
Re: [GNC] currency symbol problem in reports
Thanks John. I did try those settings, first to P. Then I realized null would be better but it defaulted back. So a space is a solution. I didn't think of that. Thanks much for your help On Sun, Feb 28, 2021, 9:32 AM John Ralls wrote: > Not in settings, in the security editor. Open the Currencies namespace, > find and select the currency, and select Edit. There's a spot for Display > Symbol. Deleting it will get the default but a space will replace it. That > might make amounts look odd in some places but should be OK on most. > > Regards, > John Ralls > > > > On Feb 27, 2021, at 1:37 PM, D. via gnucash-user < > gnucash-user@gnucash.org> wrote: > > > > ISTR that there is a place in the settings to choose the character to > display with each currency. Never tried it though. > > > > > > Original Message > > From: Gio Bacareza > > Sent: Sat Feb 27 09:18:47 EST 2021 > > To: Jim DeLaHunt > > Cc: GnuCash Users > > Subject: Re: [GNC] currency symbol problem in reports > > > > I use Arial which should have it. But for some reason Gnucash does not > > render it. > > > > If you copy paste the report to another program like a text editor or > > excel, the peso sign shows up. > > > > But to be honest I really just want to eliminate currency symbols. I > mostly > > work in pesos so there is no added information it gives me. > > > > Is there a way to configure such that no currency symbol is displayed or > > printed? > > > > thanks > > > > On Sat, Feb 27, 2021 at 4:32 PM Jim DeLaHunt > wrote: > > > >> On 2021-02-26 17:21, Gio Bacareza wrote: > >> > >>> This seems to be a nagging problem with currencies in reports. I > thought > >> I > >>> had solved this in previous versions of mac that I'm using but it's > back > >>> again with Big Sur and the remedies that worked before no longer works > >> now. > >>> > >>> My currency is Philippine Peso. Reports show a square looking symbol > >> which > >>> could probably mean it could not find the right font. > >> > >> According to Wikipedia, the Philippine Peso symbol is "₱". It looks like > >> a capital "P" with two horizontal lines through the upper bowl. The > >> Unicode code point is U+20B1. > >> > >> What font are you using to format the report? I suspect that not all > >> fonts contain this character. On my Mac, the main system fonts like > >> Arial and Courier have it, the pan-Unicode fonts like Noto Sans have it, > >> but more specialised text fonts like Calibri do not. > >> > >> [1] https://en.wikipedia.org/wiki/Philippine_peso_sign > >> > >> Hope this helps, > >> > >> —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 > >> 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. > >> > > > > > > -- > > cheers, > > > > Gio > > ___ > > gnucash-user mailing list > > gnucash-user@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@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@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.
Re: [GNC] currency symbol problem in reports
I use Arial which should have it. But for some reason Gnucash does not render it. If you copy paste the report to another program like a text editor or excel, the peso sign shows up. But to be honest I really just want to eliminate currency symbols. I mostly work in pesos so there is no added information it gives me. Is there a way to configure such that no currency symbol is displayed or printed? thanks On Sat, Feb 27, 2021 at 4:32 PM Jim DeLaHunt wrote: > On 2021-02-26 17:21, Gio Bacareza wrote: > > > This seems to be a nagging problem with currencies in reports. I thought > I > > had solved this in previous versions of mac that I'm using but it's back > > again with Big Sur and the remedies that worked before no longer works > now. > > > > My currency is Philippine Peso. Reports show a square looking symbol > which > > could probably mean it could not find the right font. > > According to Wikipedia, the Philippine Peso symbol is "₱". It looks like > a capital "P" with two horizontal lines through the upper bowl. The > Unicode code point is U+20B1. > > What font are you using to format the report? I suspect that not all > fonts contain this character. On my Mac, the main system fonts like > Arial and Courier have it, the pan-Unicode fonts like Noto Sans have it, > but more specialised text fonts like Calibri do not. > > [1] https://en.wikipedia.org/wiki/Philippine_peso_sign > > Hope this helps, > > —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 > 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. > -- cheers, Gio ___ gnucash-user mailing list gnucash-user@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.
[GNC] currency symbol problem in reports
This seems to be a nagging problem with currencies in reports. I thought I had solved this in previous versions of mac that I'm using but it's back again with Big Sur and the remedies that worked before no longer works now. My currency is Philippine Peso. Reports show a square looking symbol which could probably mean it could not find the right font. * Mac OS System Preference Region is set to the Philippines and it displays the proper currency symbol. * GNUCASH Preference - Accounts - Default Currency defaults to USD. Why? I had to set it to PHP (Philippine Peso) * GNUCASH Preference - Reports - Default Currency defaults to USD. Why? I had to set it to PHP (Philippine Peso) * I tried Edit - Style Sheets and manually specifying Arial which I know for sure contains our symbol. * The only solution that worked was to go to Tools - Security Editor and manually specify text to Php I have given up. So is there any way to actually just show blank? Unless it is a foreign currency, we can just assume it's in Pesos anyways. Most of my reports are in Php anyways so I really don't need it. There's too much trouble to make it work. It's not worth it for me. Thanks for the help. -- cheers, Gio ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Help with mult-currency multi-split import
Thanks John. That's really weird because I swear the csv contains a 2nd transaction that is 1678 to 56286.85. I've been copy pasting from a set of csvs for the tests. I tried it with some other accounts since then because I had to get the transactions in. In some imports it worked. In some I noticed a pattern where gnucash for some weird reason takes the AUD of the preceding transaction, uses that as an entry into the next one. Hence I think that's causing the exchange rates conflicts. I should have collected the screenshots. I will try the experiment on another computer and share results and figure it out. I will continue to try this out on the next batch of statement imports next month. I will also test if doing it in OFX will be more predictable. Will just have to do pre-processing to translate csv to to ofx. Does anyone in the community have any leads for csv->ofx tools? thanks On Sat, Aug 15, 2020 at 12:07 AM John Ralls wrote: > > > > On Aug 13, 2020, at 10:07 PM, Gio Bacareza wrote: > > > > Test 1: > > Import: > >Withdraw Deposit > > 02/21/2020,test first transaction,Account 1 in AUD,1486,0,, > > ,,Account 2 in AUD,0,1486,, > > 02/27/2020,test second transaction,Account 1 in AUD,0,1678.08,, > > ,,Account 3 in PHP,56286.85,0,,note- conversion price stored in gnucash > is is 33.54241157. That is the same price I use to pre-convert. So > 1678.08*33.54241157 = 56286.85 > > > > BZZZT! That's not what your first screen shot says. It says the second > transaction is Account 1 DR AUD 1468.00, Account3 CR 56286.85. > > Regards, > John Ralls -- cheers, Gio ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Help with mult-currency multi-split import
Hi John, Thanks for the feedback. Always learning. Let me answer. I did check whether this was a currency exchange rate issue. But I'm sure it's not because: (a) I imported daily prices to gnucash prior to export and I pre-converted the currencies using the same price. In this case, the AUD to PHP on 02/27/2020 is 33.54241157. That is the same price I use to pre-convert. So 1678.08*33.54241157 = 56286.85. So unless gnucash uses other means to calculate, it couldn't be an exchange rate issue. (b) Why is it then that when I import the same 2 transactions one at a time, the issue does not happen? (c) It could be purely coincidental but the amount in 1st transaction (AUD to AUD so no conversion) is AUD 1486.00 and that is precisely what gnucash. Thanks for feedback on images. I'm recreating the scenarios below for reference: Test 1: Import: Withdraw Deposit 02/21/2020,test first transaction,Account 1 in AUD,1486,0,, ,,Account 2 in AUD,0,1486,, 02/27/2020,test second transaction,Account 1 in AUD,0,1678.08,, ,,Account 3 in PHP,56286.85,0,,note- conversion price stored in gnucash is is 33.54241157. That is the same price I use to pre-convert. So 1678.08*33.54241157 = 56286.85 Result: 02/21/2020,test first transaction,Account 1 in AUD,1486,0 ,,Account 2 in AUD,0,1486 02/27/2020,test second transaction,Account 1 in AUD,0,1486 ,,Orphan,,192.08 ,,Account 3 in PHP,56286.85,0 ,,Trading:CURRENCY:PHP,1678.08, ,,Trading:CURRENCY:USD,,1678.08 Test2: 2 imports. 1 by 1 Result: Correct 02/21/2020,test first transaction,Account 1 in AUD,1486,0,, ,,Account 2 in AUD,0,1486,, 02/27/2020,test second transaction,Account 1 in AUD,0,1678.08,, ,,Account 3 in PHP,56286.85,0 On Fri, Aug 14, 2020 at 12:42 AM John Ralls wrote: > You're relying too much on images to tell your story, made worse by the > fact that the list server doesn't work with inline images. Have a look at > your message in the archive: > https://lists.gnucash.org/pipermail/gnucash-user/2020-August/092596.html > > What's more, you've blanked out most of the account names on the images, > and the main comment on the register image seems incomplete. If for some > reason you think that your account names reveal too much about your > finances, replace them with fake names so that the viewer can track the > account flow through the process. > > To the "why is this here" question on that image, the arrow is pointing to > 1468.00. That's the amount of AUD in your imported transaction. The last > image, annotated "It Works" has the AUD amount as 1678.08. ISTM that rather > indicates that it doesn't work. ISTM the question should be "where does > that 168.08 come from?" and I think it comes from using the wrong exchange > rate between AUD and whatever the other currency is, resulting in 56286.05 > being calculated as 1678.08 AUD. 168.08 = 1678.08 - 1468.00, the amount > needed to balance the transaction. > > I think that the work around is to specify a price in multi-commodity > imports, but I'm not as familiar with the csv importer as I should be so I > can't say authoritatively that it will work. > > Regards, > John Ralls > > > On Aug 13, 2020, at 4:16 AM, Gio Bacareza wrote: > > > > I maintain multi-currency accounts. I rely on monthly or quarterly > > statements to enter the transactions into Gnucash. So I rely on the > import > > feature. > > > > Without a reliable import, a system will be too manual for me. So it is > > vital that import works. > > I know that multi-currency imports have been a known issue but I thought > I > > had found a solution through correctly doing a multi-split in this > manner: > > Date Description Accounts Debit Credit > > mm/dd/ Some description Account Amount in currency 1 0 > > Transfer Account 0 Amount in currency 02 > > > > I've tested this with dummy data as well as real information. So far it > has > > worked. > > > > Except my last import. The import was a real mess so I had a little > > experiment. I set it up by taking samples from the actual data. > > Scenario 1: 2 transactions. 1 has conversion. 1 no conversion. > > > > 1. Set up the import > > > > [image: image.png] > > > > 1. Match the accounts > > > > [image: image.png] > > > > > > 1. In "Match Transactions" step, it was already exhibiting weird > > behaviors. > > > > [image: image.png] > > > > > > 1. Checking the registry, Gnucash added in an amount from the first > > transaction and completely wrongly assigned transactions in the split. > I > > can't figure out why it does that. > > > > [image: image.png] > > > > Checking if it's an excha
Re: [GNC] multi-currency imports
Thanks! On Mon, Aug 3, 2020 at 11:29 PM GTI .H wrote: > Em seg., 3 de ago. de 2020 às 01:07, Gio Bacareza > escreveu: > >> Hi, >> >> I read in this list some time ago that multi-currency imports is a known >> issue in gnucash. I just wanted to know if this has been fixed. >> >> Also, is there a best recommended format for import. I mean is CSV, QIF, >> etc, whichever format, is better in handling imports in general and >> multi-currency imports in particular? >> > > This issue is very old and we have been waiting for a solution for many > years. > > This seems to be a difficult issue that has challenged DEVs. > > We have prayed less than necessary, let's pray more! : ) > > https://bugs.gnucash.org/show_bug.cgi?id=796955 > > > -- > Regards > -- cheers, Gio ___ gnucash-user mailing list gnucash-user@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.
[GNC] multi-currency imports
Hi, I read in this list some time ago that multi-currency imports is a known issue in gnucash. I just wanted to know if this has been fixed. Also, is there a best recommended format for import. I mean is CSV, QIF, etc, whichever format, is better in handling imports in general and multi-currency imports in particular? -- cheers, Gio ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] gnucash cannot see printer
Thanks! On Fri, Jul 17, 2020, 12:53 AM John Ralls wrote: > > > > On Jul 16, 2020, at 3:38 AM, Gio Bacareza wrote: > > > > Just fresh installed a new mac. installed gnucash. it can't seem to find > > the printer (see screenshot). Help! > > > > [image: image.png] > > > > when printer is set up properly (see screenshot) > > [image: image.png] > > > > https://bugs.gnucash.org/show_bug.cgi?id=797831 > > Regards, > John Ralls > ___ gnucash-user mailing list gnucash-user@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.
[GNC] gnucash cannot see printer
Just fresh installed a new mac. installed gnucash. it can't seem to find the printer (see screenshot). Help! [image: image.png] when printer is set up properly (see screenshot) [image: image.png] Hardware: MacAir Mid 2013 OSX Catalina 10.15.5 Gnucash Version: 4.0 -- cheers, Gio ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Question marks instead of currency in reports
I finally solved it! Thank you Adrien. I followed your lead and examined the style sheets. There I found out that the default style sheets has Fonts set to NONE. I still don't quite understand what default font GNUCASH defaults to if it is set at NONE but I experimented and created my own style sheet and explicitly specified a font. It worked! Thanks Adrien. I'm just curious. What font does it default to if it's set to NONE? Thanks On Thu, Jun 18, 2020 at 2:24 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Also, are you using a custom/modified stylesheet for the report with a > different font for the totals? > > Regards, > Adrien > > > On Jun 18, 2020 w25d170, at 1:20 AM, Christopher Lam < > christopher@gmail.com> wrote: > > > > The only technical difference between regular lines and total lines is > that > > the latter is in bold. Try checking your font for bold symbol? > > > > On Thu, 18 Jun 2020, 1:57 pm Gio Bacareza, wrote: > > > >> it now shows up in the reports but the total is still a question mark. > see > >> screenshot below > >> [image: image.png] > > > ___ > gnucash-user mailing list > gnucash-user@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. > -- cheers, Gio ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Question marks instead of currency in reports
Thank you Fred. I was also pointing out to other fonts. That was just an example to show that it's there. On Fri, Jun 19, 2020, 7:04 PM Fred Bone wrote: > On 19 June 2020 at 18:29, Gio Bacareza said: > > > Thank you for the help Christopher. Yes there are bold fonts capable of > > displaying Philippine Peso but the report still displays question marks. > > See screenshot below > > > > [image: image.png] > > Your total line is very obviously not in Arial so the display of Arial in > Character Viewer is irrelevant. > > ___ > gnucash-user mailing list > gnucash-user@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@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.
Re: [GNC] Question marks instead of currency in reports
Thank you for the help Christopher. Yes there are bold fonts capable of displaying Philippine Peso but the report still displays question marks. See screenshot below [image: image.png] On Thu, Jun 18, 2020 at 2:20 PM Christopher Lam wrote: > The only technical difference between regular lines and total lines is > that the latter is in bold. Try checking your font for bold symbol? > > On Thu, 18 Jun 2020, 1:57 pm Gio Bacareza, wrote: > >> it now shows up in the reports but the total is still a question mark. see >> screenshot below >> [image: image.png] >> >> On Thu, Jun 18, 2020 at 1:49 PM Gio Bacareza wrote: >> >> > Hi Adrien and others, >> > >> > I checked the character viewer and Peso is confirmed to be there >> available >> > in various fonts including Apple Symbols collection. See screenshot. >> > [image: image.png] >> > >> > It is also in the Security Editor. see screenshot below >> > [image: image.png] >> > >> > So I don't know what else I need to do. >> > >> > >> > >> > On Thu, Jun 18, 2020 at 12:47 AM Adrien Monteleone < >> > adrien.montele...@lusfiber.net> wrote: >> > >> >> Your font probably doesn’t have that symbol. Check your custom CSS file >> >> and find a different font. I’d use either the Mac Character Viewer or >> Font >> >> Book to find a suitable one. It looks like that is Unicode 20B1. A >> simple >> >> search in Character Viewer for ‘peso’ brought it right up. Select the >> >> character in the search results in the middle pane, then use the >> >> bottom-right pane to click each sample to see what fonts have it. >> (that is >> >> a really bad UI/UX for this, but it is doable) >> >> >> >> Also check Tools > Security editor and make sure a symbol is displayed >> >> there. If not, you can reset it manually. >> >> >> >> Regards, >> >> Adrien >> >> >> >> > On Jun 17, 2020 w25d169, at 3:34 AM, Gio Bacareza < >> gbacar...@gmail.com> >> >> wrote: >> >> > >> >> > Why am I getting question marks instead of currency in the reports? >> >> > >> >> > Gnucash Version: 3.7 >> >> > Preferences / Default Currency = PHP (Philippine Peso) >> >> > >> >> > Mac OSX Catalina >> >> >> >> ___ >> >> gnucash-user mailing list >> >> gnucash-user@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. >> >> >> > >> > >> > -- >> > cheers, >> > >> > Gio >> > >> >> >> -- >> cheers, >> >> Gio >> ___ >> gnucash-user mailing list >> gnucash-user@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. >> > -- cheers, Gio ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Question marks instead of currency in reports
No. I'm just using default On Thu, Jun 18, 2020 at 2:24 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Also, are you using a custom/modified stylesheet for the report with a > different font for the totals? > > Regards, > Adrien > > > On Jun 18, 2020 w25d170, at 1:20 AM, Christopher Lam < > christopher@gmail.com> wrote: > > > > The only technical difference between regular lines and total lines is > that > > the latter is in bold. Try checking your font for bold symbol? > > > > On Thu, 18 Jun 2020, 1:57 pm Gio Bacareza, wrote: > > > >> it now shows up in the reports but the total is still a question mark. > see > >> screenshot below > >> [image: image.png] > > > ___ > gnucash-user mailing list > gnucash-user@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. > -- cheers, Gio ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Question marks instead of currency in reports
Thanks Adrien. Let me try this. Let you guys know On Thu, Jun 18, 2020 at 12:47 AM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Your font probably doesn’t have that symbol. Check your custom CSS file > and find a different font. I’d use either the Mac Character Viewer or Font > Book to find a suitable one. It looks like that is Unicode 20B1. A simple > search in Character Viewer for ‘peso’ brought it right up. Select the > character in the search results in the middle pane, then use the > bottom-right pane to click each sample to see what fonts have it. (that is > a really bad UI/UX for this, but it is doable) > > Also check Tools > Security editor and make sure a symbol is displayed > there. If not, you can reset it manually. > > Regards, > Adrien > > > On Jun 17, 2020 w25d169, at 3:34 AM, Gio Bacareza > wrote: > > > > Why am I getting question marks instead of currency in the reports? > > > > Gnucash Version: 3.7 > > Preferences / Default Currency = PHP (Philippine Peso) > > > > Mac OSX Catalina > > ___ > gnucash-user mailing list > gnucash-user@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. > -- cheers, Gio ___ gnucash-user mailing list gnucash-user@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.
[GNC] Question marks instead of currency in reports
Why am I getting question marks instead of currency in the reports? Gnucash Version: 3.7 Preferences / Default Currency = PHP (Philippine Peso) Mac OSX Catalina -- cheers, Gio ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Training the classifier of imported transactions in GnuCash
Hi Cliff, I also want to first say thanks to all the developers. I am a user and a fan. 2nd, awesome to meet you Cliff. I love your products too. I was also looking into an automated way of classifying transactions. I did a quick automl using google and have achieved 90%+ accuracy. However, I wasn't able to use it because I think gnucash does its own and requires you to classify them upon import. After a few imports it also "learns." So subsequent imports will have these transfer accounts autopopulated. I hope it helps. gio On Mon, Jun 15, 2020 at 5:11 PM Cliff Kushler wrote: > Hello - > > I am a long-time user and fan of GnuCash, and start by offering my > gratitude to everyone who has contributed to it. For what it’s worth, I am > also a co-inventor of T9 and Swype, so perhaps I have contributed something > to make your life easier too. > > My question is whether there is a tool, technique or strategy to improve > the accuracy with which GnuCash assigns imported transactions to > destination accounts. I import large quantities of credit card > transactions, and while many of them are assigned to the correct accounts, > a very large number of repeat transactions (i.e. from the same vendor) are > either repeatedly assigned to the same wrong category or simply left as > “Imbalance-USD”. I have not been able to identify a way to correct them > while they are still displayed in the initial import window, although I > suspect that would be the time to correct them. I go through and manually > correct them in the register after importing them, but this does not seem > to help future classification accuracy. > > Any help would be much appreciated! I probably should have asked this > years ago… > > Joy & Blessings, > > Cliff Kushler > ___ > gnucash-user mailing list > gnucash-user@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. > -- cheers, Gio ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] redoing reconciliation
Thanks Adrien. That's a great solution indeed. However I only discovered about the fluke transaction which made it necessary for me to repeat the reconciliation process months after. Therefore there have been many transactions after that. Thanks. On Fri, Jun 12, 2020, 1:17 AM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > If you don’t have one this time, make a habit in the future of saving a > copy of your datafile as a backup before each reconcile. > > Then rolling that back is as simple as opening the backup instead of the > current file. > > Of course, that would be complicated by anything you enter between > reconciling and when you decide to roll it back if you don’t do it right > away. > > Regards, > Adrien > > > On Jun 11, 2020 w24d163, at 5:11 AM, Gio Bacareza > wrote: > > > > Hi David, > > > > Sorry my question was a bit confusing after reading it again. What I > meant > > to say was that they are already reconciled, ie R. But then I want to > > UN-Reconcile it because I needed to. I was just wondering if there's a > > better way to UN-R transactions than having to click each back to N. > > > > Thanks > > > ___ > gnucash-user mailing list > gnucash-user@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@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.
Re: [GNC] redoing reconciliation
Hi David, Sorry my question was a bit confusing after reading it again. What I meant to say was that they are already reconciled, ie R. But then I want to UN-Reconcile it because I needed to. I was just wondering if there's a better way to UN-R transactions than having to click each back to N. Thanks On Thu, Jun 11, 2020 at 5:39 PM David H wrote: > Hi Gio, > > Not sure you can set the reconcile column to 'R' manually. If I have an > issue like I've updated a previously reconciled txn and it's changed the > indicator to 'C' for instance I just re-run the reconciliation with the > last used date and balance and when the reconciliation window displays the > txns I just re-select the one/s that have become excluded from the original > reconciliation to rebalance it for the reconciliation. > > Cheers David H. > > > On Thu, 11 Jun 2020 at 18:13, Gio Bacareza wrote: > >> Hi experts, if one finds himself having to redo reconciliation, what is a >> better way than having the change R on a line by line basis? >> >> -- >> cheers, >> >> Gio >> ___ >> gnucash-user mailing list >> gnucash-user@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. >> > -- cheers, Gio ___ gnucash-user mailing list gnucash-user@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.
[GNC] redoing reconciliation
Hi experts, if one finds himself having to redo reconciliation, what is a better way than having the change R on a line by line basis? -- cheers, Gio ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] importing multiple CSVs to Gnucash
Thank you Adrien, David and @flywire for your very helpful responses.
I actually created a script that would transform different file formats and
data structures and through a machine learning classifier autopopulate the
"Transfer Account '' depending on the description.
My script would scour through the different formats since banks generally
are not standardized and transform these different files into a standard
simple CSV with DATE, DESCRIPTION, ACCOUNT, DEPOSIT, WITHDRAWAL.
After transformation, I run it through my classifier and that will add the
TRANSFER ACCOUNT field and autopopulate with the predicted transfer account
that is an exact string match, eg if transfer account is "XXXYYYZZZ" in the
csv, there is such an account in GNUCASH that the exact string equivalent
"XXXYYYZZZ". I figured that if I explicitly include the specific Transfer
Account per line in the csv, it should help GNUCASH match.
This could save me a lot of time since I don't have to transform each bank
account statement or logs individually. I have lots of accounts. I can
imagine I'm not alone in this case.
I understand from your comments that GNUCASH follows a Naive-bayes
algorithm to predict the TRANSFER ACCOUNT given the description and you
have to feed it transactions little by litle for it to learn. But as I have
said, I have already pre-processed that data so GNUCASH does not have to do
that. I explicitly feed it with the exact transfer account.
I really want to avoid doing the import account by account if I could.
On Wed, Jun 3, 2020 at 5:21 AM David Cousens
wrote:
> Gio,
>
> The Gnucash import matching procedure searches for duplicate transactions
> in a time window around the date of the
> imported recorded set at +-42 days. A match score is then calculated based
> on the differenes in dates and amounts and
> the matching of tokenized data. It is generally very good at picking up
> duplicates but will sometimes match repular
> repeated payments. An imported transition which matches an existing one
> will have the "C" ("R" in older GnuCash
> versoions) checkbox checked if the match is very good but may have the
> "U+C" ("U+R" in older GnuCash versions)
> chceckbox checked if it is not a very close match ( usually if
> descriptions and memo fields are different. It will pay
> to check all matches are actually valid. You can swap between viewing the
> register(s) and the import matcher window.
> The Help manual section on importing will help you with understanding the
> significance of the background colours to the
> rowsand the meaning of the checkboxes in the importer.
>
> https://www.gnucash.org/docs/v3/C/gnucash-help/trans-import.html#:~:text=Navigate%20to%20the%20MT940%2C%20MT942,the%20transactions%20in%20the%20file
> .
>
> Even though you are specifying the transfer accounts the importer will ask
> to to map the account name in the trnsfer
> field to an internal GnuCash account each time it encounters an account
> name for the first time in the import data.
>
> David Cousens
>
>
>
> On Tue, 2020-06-02 at 17:57 +0800, Gio Bacareza wrote:
> > Hi GNUCash experts,
> >
> > I'm planning to consolidate all my statements into 1 big CSV. This CSV
> > would naturally have an account field and a transfer field.
> >
> > Since all transactions are there, there will be instances where there
> will
> > be duplicates. For example, a statement from bank1 could have a transfer
> > from bank1 to bank2. So account = bank 1, transfer = bank 2, amount =
> -100
> > for example. But, since I put in all together in 1 file, there will be
> > another line where account = bank 2, transfer = bank1, amount = 100.
> >
> > When I import this big file containing all transactions from different
> > statements, how will gnucash handle this? Can it automatically detect
> that
> > this is one and the same transaction?
> >
> > The alternative is to import account by account but that is too time
> > consuming for me.
> >
> > Is there a better way?
> >
> --
> Dr David R Cousens
> B.Sc, M.Prof. Acc., Ph.D., G.C.Ed
>
>
--
cheers,
Gio
___
gnucash-user mailing list
gnucash-user@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.
[GNC] importing multiple CSVs to Gnucash
Hi GNUCash experts, I'm planning to consolidate all my statements into 1 big CSV. This CSV would naturally have an account field and a transfer field. Since all transactions are there, there will be instances where there will be duplicates. For example, a statement from bank1 could have a transfer from bank1 to bank2. So account = bank 1, transfer = bank 2, amount = -100 for example. But, since I put in all together in 1 file, there will be another line where account = bank 2, transfer = bank1, amount = 100. When I import this big file containing all transactions from different statements, how will gnucash handle this? Can it automatically detect that this is one and the same transaction? The alternative is to import account by account but that is too time consuming for me. Is there a better way? -- cheers, Gio ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] importing csv multisplit multicurrency problems
Not your fault at all but mine. I was looking at all possible causes for the faulty import. Thanks On Wed, Mar 11, 2020, 1:40 PM wrote: > Sorry Gio, I don’t have any experience with the import or multi-currency > transactions in GnuCash. > > I only responded to your query because you wanted a better way to load a > price database rather than entering them manually. > > Cheers. > > On 11-Mar-2020, at 10:32 AM, Gio Bacareza wrote: > > Hi Pobox.Deva, > > Thank you for the suggestion. I'll try that out. However my problem, I > think though I may be wrong, is not the price database but the importing > multicurrency transactions. > > I even made it simpler. Pre-import, I calculated and populated the > currency conversions using just 1 exchange rate. I thought that by doing > this I avoid having to maintain a price database that could change on a > daily basis. Because this would mean the calculating the conversions prior > to import will require me to have a different conversion rate depending on > the day. It's possible but I thought it will take more work. > > But I may be wrong. So do you think that fixing the price database will > fix the multi-currency import problem I am having? > > Thanks. > > > On Fri, Mar 6, 2020 at 1:37 PM wrote: > >> Gio, >> >> If you are using the 3.x series, there’s a convenient CSV price importer >> that works well. You can even save the CSV price file template for future >> use, so you’d have to set it up only once. >> >> That should alleviate a lot of burden in entering prices in price >> database manually. >> >> Cheers. >> >> > On 06-Mar-2020, at 9:53 AM, gnucash-user-requ...@gnucash.org wrote: >> > >> > Date: Fri, 6 Mar 2020 12:23:17 +0800 >> > From: Gio Bacareza mailto:gbacar...@gmail.com>> >> > To: GnuCash Users > gnucash-user@gnucash.org>> >> > Subject: Re: [GNC] importing csv multisplit multicurrency problems >> > Message-ID: >> > < >> caec3bmq5irklc0ew79ra3ktvb+xejkou72r9pv0a9v7bxi_...@mail.gmail.com >> > caec3bmq5irklc0ew79ra3ktvb+xejkou72r9pv0a9v7bxi_...@mail.gmail.com>> >> > Content-Type: text/plain; charset="UTF-8" >> > >> > As mentioned I did some follow through tests with empty and >> pre-populated >> > currency price databases. Sharing it here: >> > >> > Conclusions: >> > When doing multi-currency csv imports, it works when the price database >> is >> > pre-populated with exchange rates consistent with exchange rates used in >> > the import. >> > The issue I have with this is that pre-populating the price DB is >> > cumbersome. >> > There has to be a better way. >> > >> > More details of test here >> > >> https://docs.google.com/document/d/1d-j6195r3-hHyKopCCwFmGDu94f_8m5bj-fVPb4IJwk/edit?usp=sharing >> < >> https://docs.google.com/document/d/1d-j6195r3-hHyKopCCwFmGDu94f_8m5bj-fVPb4IJwk/edit?usp=sharing >> > >> ___ >> gnucash-user mailing list >> gnucash-user@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. >> > > > -- > cheers, > > Gio > > > ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Find or search all expenses in a certain account
Hi Alton, I'm sorry I shot from the hip and answered before I realized I misunderstood you. Your solution is exactly what I'm following now. Thanks. On Wed, Mar 11, 2020 at 7:31 AM Alton Brantley wrote: > In situations like this, I have usually just moved the 10 or so > transactions from the current account(“AccountX”) to a new account (say > AccountXNew), then delete AccountX, then rename AccountXNew to AccountX. -- cheers, Gio ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Find or search all expenses in a certain account
Hi Alton, I actually tried that at first but I have hundreds of transactions and it became cumbersome fast. Thanks for the suggestion. On Wed, Mar 11, 2020 at 7:31 AM Alton Brantley wrote: > In situations like this, I have usually just moved the 10 or so > transactions from the current account(“AccountX”) to a new account (say > AccountXNew), then delete AccountX, then rename AccountXNew to AccountX. -- cheers, Gio ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] importing csv multisplit multicurrency problems
Hi Pobox.Deva, Thank you for the suggestion. I'll try that out. However my problem, I think though I may be wrong, is not the price database but the importing multicurrency transactions. I even made it simpler. Pre-import, I calculated and populated the currency conversions using just 1 exchange rate. I thought that by doing this I avoid having to maintain a price database that could change on a daily basis. Because this would mean the calculating the conversions prior to import will require me to have a different conversion rate depending on the day. It's possible but I thought it will take more work. But I may be wrong. So do you think that fixing the price database will fix the multi-currency import problem I am having? Thanks. On Fri, Mar 6, 2020 at 1:37 PM wrote: > Gio, > > If you are using the 3.x series, there’s a convenient CSV price importer > that works well. You can even save the CSV price file template for future > use, so you’d have to set it up only once. > > That should alleviate a lot of burden in entering prices in price database > manually. > > Cheers. > > > On 06-Mar-2020, at 9:53 AM, gnucash-user-requ...@gnucash.org wrote: > > > > Date: Fri, 6 Mar 2020 12:23:17 +0800 > > From: Gio Bacareza mailto:gbacar...@gmail.com>> > > To: GnuCash Users gnucash-user@gnucash.org>> > > Subject: Re: [GNC] importing csv multisplit multicurrency problems > > Message-ID: > > < > caec3bmq5irklc0ew79ra3ktvb+xejkou72r9pv0a9v7bxi_...@mail.gmail.com > <mailto:caec3bmq5irklc0ew79ra3ktvb+xejkou72r9pv0a9v7bxi_...@mail.gmail.com > >> > > Content-Type: text/plain; charset="UTF-8" > > > > As mentioned I did some follow through tests with empty and pre-populated > > currency price databases. Sharing it here: > > > > Conclusions: > > When doing multi-currency csv imports, it works when the price database > is > > pre-populated with exchange rates consistent with exchange rates used in > > the import. > > The issue I have with this is that pre-populating the price DB is > > cumbersome. > > There has to be a better way. > > > > More details of test here > > > https://docs.google.com/document/d/1d-j6195r3-hHyKopCCwFmGDu94f_8m5bj-fVPb4IJwk/edit?usp=sharing > < > https://docs.google.com/document/d/1d-j6195r3-hHyKopCCwFmGDu94f_8m5bj-fVPb4IJwk/edit?usp=sharing > > > ___ > gnucash-user mailing list > gnucash-user@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. > -- cheers, Gio ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Find or search all expenses in a certain account
I'll give it a try. Thanks Adrien On Tue, Mar 10, 2020 at 11:41 AM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > That was the right criteria. I’m not sure why it isn’t working for you. > > Maybe I missed something, but you noted earlier that you have 10 > transactions that are transfers and are fixed properly. You want to delete > everything else in AccountA. > > Doing a search for ‘everything else’ seems to be overkill. (especially at > this point) Can’t you just do one of the following: > > 1. Delete every transaction starting from the top, but mindful to skip the > 10 transfers. > > 2. Delete AccountA entirely, re-create it and re-create the 10 transfer > transactions. > > If there are transactions in AccountA other than the transfers you don’t > want to delete, then skip them too. If there are too many and there are > only *some* expense transactions you want to delete, then do those > one-by-one. > > I think this is a case where you probably could have trudged through it > and been finished by now. (Though the challenge is always fun) > > Another approach is to open the expense registers you want to deal with, > do a search for “All Accounts” that match AccountA - delete those > transactions, proceed to the next expense account. Rinse, repeat. > > Regards, > Adrien > > > On Mar 9, 2020 w11d69, at 9:54 PM, Gio Bacareza > wrote: > > > > Hi Adrien, > > > > see below: > > > > On Mon, Mar 9, 2020 at 11:54 PM Adrien Monteleone < > adrien.montele...@lusfiber.net> wrote: > > Gio, as per the other thread, and John’s advice here, you’re still > missing a setting change for criteria search. > > > > If you are referring to the criteria: "any criteria are met" I have > actually included that in my first set of tests but concluded that they did > not differ. So I concluded that this criteria only works when you have more > than 1 search criteria after doing an "Add" button. Believe me I tried to > be as exhaustive as possible. See screenshot of earlier result below: > > > > > > If this is not the criteria you were referring to pls let me know. > > > > > > Looking at the chart in your GoogleDoc, the only combo that is relevant > is the last pair. > > > > Actually the relevant results I found were "test find account + 1 > expense". And the only conditions that work are: > > Window -> Criteria01 -> Criteria02 -> Choose Accounts > > Accounts -> All Accounts -> matches all accounts -> "test find" account > + 1 expense > > Account Window -> All Accounts -> matches all accounts -> "test find" > account + 1 expense > > Account Window -> All Accounts -> matches all accounts -> 1 expense > > > > However, I concluded that this is not optimal for what I'm trying to > achieve since that means I have to do it 1 by 1 to all expense accounts > relevant to the account I'm trying to correct. It's doable but is so > cumbersome. So I was hoping a select ALL expense or even multiple select > will do. > > > > Multiple-select could have been a manageable compromise but alas it also > doesn't work. See screenshots: > > Search = > > > > Results = > > > > > > > > > > 1. Conduct the Find from the Account Register in question. (so far > referred to as AccountA, or test_find in your Doc) > > 2. Use an All Accounts criteria > > 3. The only middle option here is to ‘match all accounts’ you can’t > choose anything else. > > 4. Select either a single target expense account, or multiples. (try > with just one first) > > **5. In the upper right hand corner, above the criteria, you need to > change the setting labeled “Search for items where” to “any criteria are > met” (the default is ‘all criteria are met’) > > > > Do not include AccountA/test_find in your account selection, you are > already doing a Find from within that register. > > > > You should get proper results. I’ve tried this sequence several times > with different accounts and for each one I’m getting the expected results > and I’ve verified them looking over the register in question. > > > > I've tried this many times too. It only works, as mentioned above, when > one and only expense transaction is selected. > > > > When selecting MORE than 1 or selecting ALL, it returns blank. see above > screenshot. > > > > What else am I missing? > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe
Re: [GNC] Help Find Feature
No worries. You;ve been a great help. Thanks! On Tue, Mar 10, 2020 at 11:19 AM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > > > On Mar 9, 2020 w11d69, at 10:00 PM, Gio Bacareza > wrote: > > > > Hi Adrien, > > > > Yes I'm afraid that is the only solution I find. It is not a viable > option right now because I'm looking at hundreds of lines. > > > > I'm very grateful for the time and attention you have given me in trying > to solve this problem as well. Thanks very much. > > > > Gio > > PS The root of all this was the issue with gnucash importing > multicurrency transactions with CSV. Would you have any idea if other > imports eg QIF can handle multi-currency? > > Sorry, can’t help there. > > Regards, > Adrien > > ___ > gnucash-user mailing list > gnucash-user@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. > -- cheers, Gio ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Help Find Feature
Hi Adrien, Yes I'm afraid that is the only solution I find. It is not a viable option right now because I'm looking at hundreds of lines. I'm very grateful for the time and attention you have given me in trying to solve this problem as well. Thanks very much. Gio PS The root of all this was the issue with gnucash importing multicurrency transactions with CSV. Would you have any idea if other imports eg QIF can handle multi-currency? On Tue, Mar 10, 2020 at 10:22 AM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Let’s say you want to delete transactions between AccountA and Expense:E, > > Are there any transactions in Expense:E between it and some other account > besides AccountA? > > If no, then just delete the entire account Expense:E, GnuCash will offer > to move the transactions, but in this case you want to decline. That should > save you lots of time. > > For those expense accounts that *do* involve *any* account, other than > AccountA, then you’ll have to do them one-by-one, from a Find done from > AccountA. > > Regards, > Adrien > > > > > On Mar 9, 2020 w11d69, at 9:05 PM, Gio Bacareza > wrote: > > > > Hi Adrien, i'll answer this first because it's much faster for me since > i've done it. I have tried with 1 expense account or several specific > accounts. It works. > > > > But when you try with select ALL expense accounts that's when it's blank. > > > > So I think that when you ID the specific expense accounts and manually > select them 1x1 it will work. But I was hoping again for a more efficient > method since selecting all is much faster than selecting dozens of specific > expense accounts. > > > > But if it's the only thing that works for now then I have to bite the > bullet. > > > > Thanks once again. > > > > > ___ > gnucash-user mailing list > gnucash-user@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. > -- cheers, Gio ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Help Find Feature
Hi Adrien, "Do ANY of the target expense accounts involve transactions with ANY other account than AccountA?" Yes. My objective is to be able to select ALL expense accounts. Because they are expense accounts it is very very likely that they will have transactions with other accounts besides AccountA. For example, you may have an expense:dining when using your AUD credit card as well as your USD credit card. On Mon, Mar 9, 2020 at 10:46 AM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > The picture is getting clearer. > > Okay then, next question: > > Do ANY of the target expense accounts involve transactions with ANY other > account than AccountA? > > Put another way, do you have even a single transaction between some other > bank account in any of those same expense accounts? > > > Regards, > Adrien > > > On Mar 8, 2020 w11d68, at 9:37 PM, Gio Bacareza > wrote: > > > > Hi Adrien, thanks for being patient with me. > > > > I think my earlier illustration was not clear because I just realized > that > > it could be read as contents of a single transaction viewed as > multi-splits > > when what I wanted to illustrate are single transactions. > > > > So with that let me try to answer your question. > > 1. Non expense accounts involving AccountA USD and Account B PHP have > been > > fixed. Reason is these are usually interbank transfers and they are not > as > > many so I had fixed them manually. eg 1 transaction in multi-split view: > > Dr. Account A USD XX > > Dr. Trading PHP YY > > Cr. Account B PHP YY > > Cr. Trading USD XX > > > > 2. Typical example below of an expense transaction in multisplit view. > > Notice how gnucash imported and autopopulated with 1:1 currency exchange. > > There are hundreds of these so changing them one by one is a a no-go. > > Dr. Account A USD XX > > Dr. Trading PHP XX > > Cr. Expense:C,D, E PHP XX ( meaning different expenses) > > Cr. Trading USD XX > > > > 3. So that's why I wanted to just find with Account A USD those that > > expenses so I can delete them and re-import with the correct exchange > rates. > > > > Thanks > > > ___ > gnucash-user mailing list > gnucash-user@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. > -- cheers, Gio ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Help Find Feature
Hi Adrien, i'll answer this first because it's much faster for me since i've done it. I have tried with 1 expense account or several specific accounts. It works. But when you try with select ALL expense accounts that's when it's blank. So I think that when you ID the specific expense accounts and manually select them 1x1 it will work. But I was hoping again for a more efficient method since selecting all is much faster than selecting dozens of specific expense accounts. But if it's the only thing that works for now then I have to bite the bullet. Thanks once again. On Mon, Mar 9, 2020 at 10:59 AM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Try the search with just one expense account then. (that you can easily > see in the register so you know it is there) > > Regards, > Adrien > > > On Mar 8, 2020 w11d68, at 9:44 PM, Gio Bacareza > wrote: > > > > I did that. Still blank :( > > ___ > gnucash-user mailing list > gnucash-user@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. > -- cheers, Gio ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Find or search all expenses in a certain account
Hi John, I tried your recommendation. I actually tried to test all scenarios I can think of (I can't help myself). Unfortunately, it still does not produce the result I want. I'm sharing the results and details of what I did here. Google Docs here https://docs.google.com/document/d/16-4oAiKGfULuI0GJXV73JUx6dv7aLk5mjYDAAo3FK5E/edit?usp=sharing or if you prefer PDF here https://docs.google.com/document/d/16-4oAiKGfULuI0GJXV73JUx6dv7aLk5mjYDAAo3FK5E/edit?usp=sharing Is there anything I am missing? Thanks. On Mon, Mar 9, 2020 at 11:52 AM John Ralls wrote: > Gio, > > No surprise, that's not exactly lucid. > > I just tried again with a more realistic test book. The problem is that > "matches all accounts" means what it says: if you give it ten accounts then > any transaction must have splits in all 10 of them to match. > > Experimenting around a bit more, I find that if you start from the > Accounts page and use Accounts - Matches Any Account - Foo + Bar (where Foo > and Bar are accounts selected in the account list box) you get all of the > transactions with a split touching either Foo or Bar. If you use All > Accounts - Matches Any Account - Foo + Bar you get transactions with at > least one split in each of Foo and Bar. > > If you start from a register tab then the Accounts - Matches Any Account - > XXX will return no transactions unless XXX is the account whose register > you have focussed. Using All Accounts with a single account selected will > return the transactions from that register with a split touching that one > account. > > So the way to get what you want is to change the selector in the upper > right from "all criteria are met" to "any criteria are met" and then enter > a line All Accounts - Matches Any Account - XXX for each expense account > that you want to include in the result. > > Regards, > John Ralls > > > > On Mar 8, 2020, at 8:00 PM, Gio Bacareza wrote: > > > > Hi John, > > > > I also actually tried that Find > All Accounts > Choose Accounts = > > Expenses:(all children) and it's still blank. > > > > To be honest, I find this text in the documentation really hard to > > understand: > > "The Account option performs a search where the accounts selected in the > > Choose Accounts dialog will both be searched individually for results. > This > > means that a match in any of the selected accounts will either be > displayed > > (matches any account) or discarded (matches no account). > > > > The All Accounts option performs a search where accounts selected in the > > Choose Accounts dialog will only return results that match in both > > accounts." > > > > Thanks > > > > On Sun, Mar 8, 2020 at 12:40 PM John Ralls wrote: > > > >> > >> > >>> On Mar 7, 2020, at 8:04 PM, Gio Bacareza wrote: > >>> > >>> Thanks John. I'm trying to run in from the register page. > >>> > >>> On Sun, Mar 8, 2020 at 1:52 AM John Ralls wrote: > >>> > >>>> > >>>> > >>>>> On Mar 7, 2020, at 1:20 AM, Gio Bacareza > wrote: > >>>>> > >>>>> Hi I tried to search all expenses in a certain account by doing Find > > > >>>>> Account > Matches Any Account - Selected Expense Account and ALL > child > >>>>> accounts. > >>>>> > >>>>> Result: blank > >>>>> > >>>>> What am I doing wrong? > >>>>> > >>>> > >>>> Did you run Find from the Accounts page or from a register page? > >>>> > >> > >> When you run from a register page Find searches only that account and > >> Account in find matches the current account rather than the transfer > >> account. If I understand what you're trying to do, use All Accounts - > >> matches all accounts - xxx where xxx means to select the accounts you > want > >> to search for in the selector dialog box. > >> > >> Regards, > >> John Ralls > >> > >> > >> > >> > >> > > > > -- > > cheers, > > > > Gio > > ___ > > gnucash-user mailing list > > gnucash-user@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. > > -- cheers, Gio ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Find or search all expenses in a certain account
Hi John, I also actually tried that Find > All Accounts > Choose Accounts = Expenses:(all children) and it's still blank. To be honest, I find this text in the documentation really hard to understand: "The Account option performs a search where the accounts selected in the Choose Accounts dialog will both be searched individually for results. This means that a match in any of the selected accounts will either be displayed (matches any account) or discarded (matches no account). The All Accounts option performs a search where accounts selected in the Choose Accounts dialog will only return results that match in both accounts." Thanks On Sun, Mar 8, 2020 at 12:40 PM John Ralls wrote: > > > > On Mar 7, 2020, at 8:04 PM, Gio Bacareza wrote: > > > > Thanks John. I'm trying to run in from the register page. > > > > On Sun, Mar 8, 2020 at 1:52 AM John Ralls wrote: > > > >> > >> > >>> On Mar 7, 2020, at 1:20 AM, Gio Bacareza wrote: > >>> > >>> Hi I tried to search all expenses in a certain account by doing Find > > >>> Account > Matches Any Account - Selected Expense Account and ALL child > >>> accounts. > >>> > >>> Result: blank > >>> > >>> What am I doing wrong? > >>> > >> > >> Did you run Find from the Accounts page or from a register page? > >> > > When you run from a register page Find searches only that account and > Account in find matches the current account rather than the transfer > account. If I understand what you're trying to do, use All Accounts - > matches all accounts - xxx where xxx means to select the accounts you want > to search for in the selector dialog box. > > Regards, > John Ralls > > > > > -- cheers, Gio ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Help Find Feature
I did that. Still blank :( On Mon, Mar 9, 2020 at 10:32 AM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Yes, it is blank, because you missed this step: > > >>-then change the “Search for items where” to “any criteria are > met” > > Thus, with ‘all criteria’ you’re asking it to return transactions where > ‘all' of those accounts have splits in the *same* transaction, of which > there are none. > > By changing it to ‘any criteria’ you are asking for all transactions where > ‘any’ of those accounts have splits. > > Still though, to make sure I don’t advise you in a way that makes a mess, > see my earlier question about what other accounts are involved. I see you > aren’t using View > Transaction Journal, so go ahead and turn that on > first. (it is also possible to do some find operations to check this if > needed) > > Regards, > Adrien > > > > On Mar 8, 2020 w11d68, at 9:20 PM, Gio Bacareza > wrote: > > > > Hi Adrien, thanks for this. I really appreciate it. > > > > I've tried exactly what you have prescribed because that's how I thought > I > > understood Find - All Accounts work. But alas it has always returned a > > blank result. (screenshots attached) > > [image: image.png] > > [image: image.png] > > [image: image.png] > > > ___ > gnucash-user mailing list > gnucash-user@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. > -- cheers, Gio ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Help Find Feature
Hi Adrien, thanks for being patient with me. I think my earlier illustration was not clear because I just realized that it could be read as contents of a single transaction viewed as multi-splits when what I wanted to illustrate are single transactions. So with that let me try to answer your question. 1. Non expense accounts involving AccountA USD and Account B PHP have been fixed. Reason is these are usually interbank transfers and they are not as many so I had fixed them manually. eg 1 transaction in multi-split view: Dr. Account A USD XX Dr. Trading PHP YY Cr. Account B PHP YY Cr. Trading USD XX 2. Typical example below of an expense transaction in multisplit view. Notice how gnucash imported and autopopulated with 1:1 currency exchange. There are hundreds of these so changing them one by one is a a no-go. Dr. Account A USD XX Dr. Trading PHP XX Cr. Expense:C,D, E PHP XX ( meaning different expenses) Cr. Trading USD XX 3. So that's why I wanted to just find with Account A USD those that expenses so I can delete them and re-import with the correct exchange rates. Thanks On Mon, Mar 9, 2020 at 10:05 AM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Gio, I recall the multi-currency thread. This puts some things in > perspective. > > In order to help you find the best method, there are a few more questions, > here’s the first: > > Do any of those transactions in AccountA-USD that have splits with the > expense accounts also have splits with AccountB-PHP? > > Such as something similar to: > > Cr. AccountA-USD > Dr. AccountB-PHP > Dr. ExpenseE-??? > > That is, do any of them involve A, B *and* the offending expense accounts? > (actual debits/credits aren’t really relevant, that was just an > illustration) > > Use View > Transaction Journal, if you aren’t already, to see this. > > Regards, > Adrien > > > > > On Mar 8, 2020 w11d68, at 8:46 PM, Gio Bacareza > wrote: > > > > Hi Adrien, thanks for the response. > > > > To answer your questions: > > The reason I want to delete these transactions is because of a faulty > > multi-currency import. See, I imported a year's worth of multicurrency > > accounts and now I am fixing these as gnucash does not handle > > multi-currency accounts export well. So I ended up with accounts where > the > > exchange rates between these accounts were auto populated by gnucash > with a > > 1:1 ratio by default. I have fixed some accounts and have reconciled > them. > > I selected those with a few transactions because the process is very > manual > > and time consuming. So now I am left with accounts with transactions some > > of which are with (1) reconciled accounts and some with (2) expense > > accounts. Those with reconciled transactions I don't want to touch > because > > the other side is reconciled. Those on expense I want to delete and > > reimport with a method I found that works with multi-currency imports. > > Hence this is the reason I want to delete the transactions where the > > transfer account = expense and children. > > > > Illustrating the scenario without showing actual transactions, consider > > Bank Account A USD. It has 10 or so transfers to Bank Account B in PHP > and > > 200 expenses. I have fixed the 10 transfers manually. But I dont want to > > fix the 200 expenses manually because it's too much time and effort for > me. > > So I plan to delete them and re-import with new method that works. > > > > I hope this also answers your 2nd question: “Do you want to delete some > or > > *all* of the transactions in that expense account?" > > > > Sorry if I didn't include the background in my first post as I didn't > want > > to complicate the question. > > > > Now that I've explained the background is there a better way? Thanks. > > > ___ > gnucash-user mailing list > gnucash-user@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. > -- cheers, Gio ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Help Find Feature
Hi Stephen, thanks for the response. Once again, I want to apologize if my initial and following posts were not clear. My bad. As I have explained to Adrien in my earlier response (I respond on a FIFO basis.) the reason I cannot do what you have suggested is that it doesn't apply. The Expense account and all its children is not the problem. The problem is with specific accounts where I need to delete all expenses within them. I tried to explain in gnucash nomenclature where expenses are not categories but just another accounts. So within the concerned accounts (which are bank and credit card accounts), I just need to delete the expenses. I hope this is much clearer. If it's not responsibility to improve clarity is mine. Do let me know. Thanks. On Mon, Mar 9, 2020 at 1:49 AM Stephen M. Butler wrote: > On 3/7/20 8:03 PM, Gio Bacareza wrote: > > Thanks Tommy. This is a really interesting method and I can already think > > of use cases. For my scenario though, as I mentioned earlier response, it > > will add extra steps to what it is that I want to do. > > > > I want to be able to find transactions to/from expense accounts because I > > need to delete them and I am looking for the fastest way to do that. > Thanks > > > Hmm. Did you say _every_ transaction involved in _all_ expense accounts? > > Open your file and save off a copy. > > Then on the Accounts tab, find the top-level Expenses account and > highlight that. > > Click on Edit menu item and then on Delete Account. > > On the popup screen select the options to delete sub-accounts and to > delete transactions. > > Click on the Delete button on the lower right corner. > > POOF -- all transactions involving an expense account are gone. So are > all the Expense accounts! But you can add those back in as needed. > > -- > Stephen M Butler, PMP, PSM > stephen.m.butle...@gmail.com > kg...@arrl.net > 253-350-0166 > --- > GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 > > > ___ > gnucash-user mailing list > gnucash-user@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. > -- cheers, Gio ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Help Find Feature
Hi David, thanks for the response. Sorry If my original post was not clear. My bad. I was not planning to delete split lines. I was planning to delete the whole transaction. I understand that any transaction has at least 2 splits: a debit and a credit account or left or right or source or target. In my scenario, anything where the other side = expense and all its children eg Expense:Groceries, Expense:Dining etc needs to be deleted as a whole transaction not as just the split. Why do I want to do this? It has something to do with gnucash's issue with multicurrency imports. I detailed the background in my earlier response to Adrien. I've tried many solutions and most of them require me to change each transactions manually one at a time. To do that with a year's worth of expense transactions is a no-go for me. I have experimented with an import method that seem to work. So I plan to just delete the expenses and re-import them. If there's a better way I am all ears. Thanks David. On Sun, Mar 8, 2020 at 1:29 PM David Carlson wrote: > Gio, > > In GnuCash you cannot delete split lines without throwing the transaction > out of balance. Hence, you need to replace the undesired account with a > different account. If you want to delete every instance of an expense A > and replace it with expense B you can do that in the account tree by > relocating expense A under expense B then deleting expense A. > > If you want to only select a few instances of A and replace them with B, > that probably means examining one transaction at a time and changing A to > B individually. If you use the technique described by Tommy Trussell you > can generate a "short list" of transactions that meet your criteria for > finding the desired transactions, but you would still need to edit those > transactions one at a time. > > David Carlson > > On Sat, Mar 7, 2020 at 10:10 PM Gio Bacareza wrote: > >> Thanks Tommy. This is a really interesting method and I can already think >> of use cases. For my scenario though, as I mentioned earlier response, it >> will add extra steps to what it is that I want to do. >> >> I want to be able to find transactions to/from expense accounts because I >> need to delete them and I am looking for the fastest way to do that. >> Thanks >> >> On Sun, Mar 8, 2020 at 4:30 AM Tommy Trussell >> wrote: >> >> > On Sat, Mar 7, 2020 at 5:43 AM Maf. King wrote: >> > >> > > On Saturday, 7 March 2020 11:34:33 GMT Gio Bacareza wrote: >> > > > Hi, >> > > > >> > > > I've read the manual, tried everything and searched the lists but >> can't >> > > > seem to figure out how you can search for ALL expense transactions >> > from a >> > > > certain account. >> > > > >> > > > Any help would be appreciated. >> > > >> > > Try the transaction report, (or possibly the account report.) >> > > >> > >> > I just happened to be wondering the same thing so here's what I did in >> > detail >> > >> > 1) Go to the Accounts page and select the top-level item you want to >> report >> > under. In this case: >> > Expenses >> > >> > 2) Edit--> Open SubAccounts [OR right-click --> Open SubAccounts] >> > >> > 3) A new register will open; GnuCash may warn you that it's read-only. >> In >> > this case the tab says "Expenses+" to indicate it includes SubAccounts. >> > >> > 4) I wanted to see JUST last month's expenses so I chose >> > View --> Filter By... >> > o Select Range >> > 2/1/2020 >> > 2/29/2020 >> > >> > 5) Now that you have the transactions filtered, open the Account report: >> > Reports --> Account Report >> > >> > 6) Play with the report settings till the report shows the detail you >> need. >> > (If you need to tinker further, you can copy the report contents and >> paste >> > into a spreadsheet.) >> > >> > - >> > > 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 >> > If you are using Nabble or Gmane, please see >> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >> > - >> >
Re: [GNC] Help Find Feature
Hi Adrien, thanks for the response. To answer your questions: The reason I want to delete these transactions is because of a faulty multi-currency import. See, I imported a year's worth of multicurrency accounts and now I am fixing these as gnucash does not handle multi-currency accounts export well. So I ended up with accounts where the exchange rates between these accounts were auto populated by gnucash with a 1:1 ratio by default. I have fixed some accounts and have reconciled them. I selected those with a few transactions because the process is very manual and time consuming. So now I am left with accounts with transactions some of which are with (1) reconciled accounts and some with (2) expense accounts. Those with reconciled transactions I don't want to touch because the other side is reconciled. Those on expense I want to delete and reimport with a method I found that works with multi-currency imports. Hence this is the reason I want to delete the transactions where the transfer account = expense and children. Illustrating the scenario without showing actual transactions, consider Bank Account A USD. It has 10 or so transfers to Bank Account B in PHP and 200 expenses. I have fixed the 10 transfers manually. But I dont want to fix the 200 expenses manually because it's too much time and effort for me. So I plan to delete them and re-import with new method that works. I hope this also answers your 2nd question: “Do you want to delete some or *all* of the transactions in that expense account?" Sorry if I didn't include the background in my first post as I didn't want to complicate the question. Now that I've explained the background is there a better way? Thanks. On Sun, Mar 8, 2020 at 1:26 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > First, I would ask, “Why do you want to delete these transactions?” and > second, “Do you want to delete some or *all* of the transactions in that > expense account?" > > You don’t need to ‘find’ transactions from an expense account to delete > them. > > Just open the expense account if you want to delete certain ones, which > you can narrow with a Find operation there if you like. > > Or if you want to delete all transactions in an expense account, just > delete the account. > > GnuCash will ask you upon account deletion if you want to move the > transactions as re-assigned to a different account (good for refactoring > your tree) or if you want to delete the transactions entirely. Choose > accordingly. > > But I’d still be interested in the original “why?” because you *may* be > thinking deletion is an answer to a problem that might have a better > solution. > > Regards, > Adrien > > > On Mar 7, 2020 w10d67, at 10:03 PM, Gio Bacareza > wrote: > > > > Thanks Tommy. This is a really interesting method and I can already think > > of use cases. For my scenario though, as I mentioned earlier response, it > > will add extra steps to what it is that I want to do. > > > > I want to be able to find transactions to/from expense accounts because I > > need to delete them and I am looking for the fastest way to do that. > Thanks > > ___ > gnucash-user mailing list > gnucash-user@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. > -- cheers, Gio ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Find or search all expenses in a certain account
Thanks John. I'm trying to run in from the register page. On Sun, Mar 8, 2020 at 1:52 AM John Ralls wrote: > > > > On Mar 7, 2020, at 1:20 AM, Gio Bacareza wrote: > > > > Hi I tried to search all expenses in a certain account by doing Find > > > Account > Matches Any Account - Selected Expense Account and ALL child > > accounts. > > > > Result: blank > > > > What am I doing wrong? > > > > Did you run Find from the Accounts page or from a register page? > > Regards, > John Ralls > > > -- cheers, Gio ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Help Find Feature
Thanks Tommy. This is a really interesting method and I can already think of use cases. For my scenario though, as I mentioned earlier response, it will add extra steps to what it is that I want to do. I want to be able to find transactions to/from expense accounts because I need to delete them and I am looking for the fastest way to do that. Thanks On Sun, Mar 8, 2020 at 4:30 AM Tommy Trussell wrote: > On Sat, Mar 7, 2020 at 5:43 AM Maf. King wrote: > > > On Saturday, 7 March 2020 11:34:33 GMT Gio Bacareza wrote: > > > Hi, > > > > > > I've read the manual, tried everything and searched the lists but can't > > > seem to figure out how you can search for ALL expense transactions > from a > > > certain account. > > > > > > Any help would be appreciated. > > > > Try the transaction report, (or possibly the account report.) > > > > I just happened to be wondering the same thing so here's what I did in > detail > > 1) Go to the Accounts page and select the top-level item you want to report > under. In this case: > Expenses > > 2) Edit--> Open SubAccounts [OR right-click --> Open SubAccounts] > > 3) A new register will open; GnuCash may warn you that it's read-only. In > this case the tab says "Expenses+" to indicate it includes SubAccounts. > > 4) I wanted to see JUST last month's expenses so I chose > View --> Filter By... > o Select Range > 2/1/2020 > 2/29/2020 > > 5) Now that you have the transactions filtered, open the Account report: > Reports --> Account Report > > 6) Play with the report settings till the report shows the detail you need. > (If you need to tinker further, you can copy the report contents and paste > into a spreadsheet.) > > - > > 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 > 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. > -- cheers, Gio ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Help Find Feature
Thanks Maf, I tried that but it doesn't let me do what I ultimately want to do. The goal is to be able to delete all transactions to expense account and all it's children. So example consider accountA. In it you would have transactions to/from: AccountB AccountC Expense:E Expense:F I want to be able to search so it will list Expense:E and F but NOT Accounts B and C. Then I can delete these expenses. Doing it with the report requires me to do 2 steps: 1 click the link, then 2 delete. Then I have to go back to the report and do it again. If I'm deleting many transactions, it will take so much time. So I'm looking for a better way. On Sat, Mar 7, 2020 at 7:41 PM Maf. King wrote: > On Saturday, 7 March 2020 11:34:33 GMT Gio Bacareza wrote: > > Hi, > > > > I've read the manual, tried everything and searched the lists but can't > > seem to figure out how you can search for ALL expense transactions from a > > certain account. > > > > Any help would be appreciated. > > Try the transaction report, (or possibly the account report.) > > HTH, > Maf. > > > > -- cheers, Gio ___ gnucash-user mailing list gnucash-user@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.
[GNC] Help Find Feature
Hi, I've read the manual, tried everything and searched the lists but can't seem to figure out how you can search for ALL expense transactions from a certain account. Any help would be appreciated. -- cheers, Gio ___ gnucash-user mailing list gnucash-user@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.
[GNC] Find or search all expenses in a certain account
Hi I tried to search all expenses in a certain account by doing Find > Account > Matches Any Account - Selected Expense Account and ALL child accounts. Result: blank What am I doing wrong? -- cheers, Gio ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] importing csv multisplit multicurrency problems
Adrien, results here https://docs.google.com/document/d/1d-j6195r3-hHyKopCCwFmGDu94f_8m5bj-fVPb4IJwk/edit?usp=sharing On Fri, Mar 6, 2020 at 3:05 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > I might have misunderstood your earlier reply, but what if you leave off > the Trading accounts from the import entirely and don’t have a price > defined in the database? (that is, only 2 splits, not 4) > > What does GnuCash do then? I should think it should add the Trading > account splits as exact based on the entered splits just as if you had done > the transaction manually and enter the resulting exchange rate in the price > db. But I could be mistaken. Perhaps that was one of the bugs Geert was > referring to. > > Regards, > Adrien > > > On Mar 5, 2020 w10d65, at 10:23 PM, Gio Bacareza > wrote: > > > > As mentioned I did some follow through tests with empty and pre-populated > > currency price databases. Sharing it here: > > > > Conclusions: > > When doing multi-currency csv imports, it works when the price database > is > > pre-populated with exchange rates consistent with exchange rates used in > > the import. > > The issue I have with this is that pre-populating the price DB is > > cumbersome. > > There has to be a better way. > > > > More details of test here > > > https://docs.google.com/document/d/1d-j6195r3-hHyKopCCwFmGDu94f_8m5bj-fVPb4IJwk/edit?usp=sharing > > > ___ > gnucash-user mailing list > gnucash-user@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. > -- cheers, Gio ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] importing csv multisplit multicurrency problems
As mentioned I did some follow through tests with empty and pre-populated currency price databases. Sharing it here: Conclusions: When doing multi-currency csv imports, it works when the price database is pre-populated with exchange rates consistent with exchange rates used in the import. The issue I have with this is that pre-populating the price DB is cumbersome. There has to be a better way. More details of test here https://docs.google.com/document/d/1d-j6195r3-hHyKopCCwFmGDu94f_8m5bj-fVPb4IJwk/edit?usp=sharing On Fri, Mar 6, 2020 at 11:48 AM Gio Bacareza wrote: > Thank you Adrien. Inspired by your answers I did a few more tests. > 1. I got rid of the lines with the trading accounts assuming from past > behavior that gnucash will autopopulate with trading currency accounts > based on price database: > Date Description Account Deposit Withdrawal > 3/6/2020 Description test_foreign 200 > test_local 10013 > > it was a success! gnucash added trading currency accounts automatically > and there was no imbalance line. > > 2. So I applied it to the actual transaction data using the same method. > FAILED. gnucash added the imbalances again :( > > 3. So I changed the price database for USD then made it all the same > value. Then I deleted and re-created the account. Then I reimported the > transactions. > SUCCESS!!! > > So conclusion: As long as price is consistent, you can import > multi-currency transactions using multiplit with 1 side currency 1 and the > other side converted currency 2. > > i'll do some test with a blank price database and let everyone know. > > > On Fri, Mar 6, 2020 at 12:55 AM Adrien Monteleone < > adrien.montele...@lusfiber.net> wrote: > >> >> >> > On Mar 5, 2020 w10d65, at 7:14 AM, Gio Bacareza >> wrote: >> > >> > I'm encountering problems with importing transactions in csv when >> accounts >> > have different currencies. >> > >> > I've been reading the debates. So this is not about definitions of >> > multi-split or terminology. >> > >> > I did a test with a sample csv with the following contents: >> > >> > Date,Description,Account,Deposit,Withdrawal >> > 1/3/2019,Description,test_foreign,,200 >> > ,,Trading:CURRENCY:PHP,,10013 >> > ,,Trading:CURRENCY:USD,200, >> > ,,test_local,10013, >> > >> > gnucash imported successfully but it created an extra line >> Imbalance-USD. >> > See results below: >> > Date Description Account Deposit Withdrawal >> > 1/3/2019 Description 200 >> > Trading:CURRENCY:USD 197.78 >> > test_local 10013 >> > Imbalance-USD 2.22 >> > test_foreign 200 >> > Trading:CURRENCY:PHP 10013 >> > >> > 1. Why does it do that when imported transactions is already balanced in >> > the first place? >> >> Not certain, sorry. Perhaps this is a bug, or perhaps there is a price in >> the database that is conflicting and GnuCash is trying to use that rather >> than set a new price based on the transaction. (I’m not intimately familiar >> with multi-currency import) >> >> See below about manual entries, as I’d suspect either some step is >> missing for the import, or there is a bug. >> >> > 2. When I try to manually correct in gnucash (197.78->200), it wouldn't >> > allow me. It keeps the imbalance no matter what I do. >> >> I’m not certain if this will work with editing an existing imported >> transaction, but doing a manual version of your test I was able to get it >> to behave properly. >> >> > 3. How do I solve this? >> >> I entered these splits first: (Dr/Cr. reversed for my book which is in >> USD) >> >> Dr. test_local 200 >> Cr. test_foreign 10013 >> >> When I tabbed off the last one, the exchange rate dialog popped up. It >> defaulted to having me enter or fetch the rate, instead I chose Debit >> Amount (credit in your case) and entered the amount in the test_local >> account that I wanted to debit and committed the dialog. >> >> This created 2 more splits in their respective trading accounts that were >> exact @ 200 and 10013 respectively as they should be. >> >> Your post reminded me of an issue I had a few months ago that I couldn’t >> get rid of a similar Imbalance split involving trading accounts. I solved >> it by switching to using the debit/credit amount field instead of the >> exchange rate field. This makes sense because if you know
Re: [GNC] importing csv multisplit multicurrency problems
Hi Geert, thanks for the feedback. Questions: Is it advisable then to convert csvs to another format? What is the preferred format for multicurency imports? Any other tips on doing multicurrency imports? Thanks! On Fri, Mar 6, 2020 at 1:01 AM Geert Janssens wrote: > There are several bugs with multi-currency csv imports. I don't think it's > currently possible to do such imports. Sorry. > > Geert > > Op donderdag 5 maart 2020 14:14:56 CET schreef Gio Bacareza: > > I'm encountering problems with importing transactions in csv when > accounts > > have different currencies. > > > > I've been reading the debates. So this is not about definitions of > > multi-split or terminology. > > > > I did a test with a sample csv with the following contents: > > > > Date,Description,Account,Deposit,Withdrawal > > 1/3/2019,Description,test_foreign,,200 > > ,,Trading:CURRENCY:PHP,,10013 > > ,,Trading:CURRENCY:USD,200, > > ,,test_local,10013, > > > > gnucash imported successfully but it created an extra line Imbalance-USD. > > See results below: > > Date Description Account Deposit Withdrawal > > 1/3/2019 Description 200 > > Trading:CURRENCY:USD 197.78 > > test_local 10013 > > Imbalance-USD 2.22 > > test_foreign 200 > > Trading:CURRENCY:PHP 10013 > > > > 1. Why does it do that when imported transactions is already balanced in > > the first place? > > 2. When I try to manually correct in gnucash (197.78->200), it wouldn't > > allow me. It keeps the imbalance no matter what I do. > > 3. How do I solve this? > > > > Thanks, > > > > gio > > > > > -- cheers, Gio ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] importing csv multisplit multicurrency problems
Thank you Adrien. Inspired by your answers I did a few more tests. 1. I got rid of the lines with the trading accounts assuming from past behavior that gnucash will autopopulate with trading currency accounts based on price database: Date Description Account Deposit Withdrawal 3/6/2020 Description test_foreign 200 test_local 10013 it was a success! gnucash added trading currency accounts automatically and there was no imbalance line. 2. So I applied it to the actual transaction data using the same method. FAILED. gnucash added the imbalances again :( 3. So I changed the price database for USD then made it all the same value. Then I deleted and re-created the account. Then I reimported the transactions. SUCCESS!!! So conclusion: As long as price is consistent, you can import multi-currency transactions using multiplit with 1 side currency 1 and the other side converted currency 2. i'll do some test with a blank price database and let everyone know. On Fri, Mar 6, 2020 at 12:55 AM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > > > > On Mar 5, 2020 w10d65, at 7:14 AM, Gio Bacareza > wrote: > > > > I'm encountering problems with importing transactions in csv when > accounts > > have different currencies. > > > > I've been reading the debates. So this is not about definitions of > > multi-split or terminology. > > > > I did a test with a sample csv with the following contents: > > > > Date,Description,Account,Deposit,Withdrawal > > 1/3/2019,Description,test_foreign,,200 > > ,,Trading:CURRENCY:PHP,,10013 > > ,,Trading:CURRENCY:USD,200, > > ,,test_local,10013, > > > > gnucash imported successfully but it created an extra line Imbalance-USD. > > See results below: > > Date Description Account Deposit Withdrawal > > 1/3/2019 Description 200 > > Trading:CURRENCY:USD 197.78 > > test_local 10013 > > Imbalance-USD 2.22 > > test_foreign 200 > > Trading:CURRENCY:PHP 10013 > > > > 1. Why does it do that when imported transactions is already balanced in > > the first place? > > Not certain, sorry. Perhaps this is a bug, or perhaps there is a price in > the database that is conflicting and GnuCash is trying to use that rather > than set a new price based on the transaction. (I’m not intimately familiar > with multi-currency import) > > See below about manual entries, as I’d suspect either some step is missing > for the import, or there is a bug. > > > 2. When I try to manually correct in gnucash (197.78->200), it wouldn't > > allow me. It keeps the imbalance no matter what I do. > > I’m not certain if this will work with editing an existing imported > transaction, but doing a manual version of your test I was able to get it > to behave properly. > > > 3. How do I solve this? > > I entered these splits first: (Dr/Cr. reversed for my book which is in USD) > > Dr. test_local 200 > Cr. test_foreign 10013 > > When I tabbed off the last one, the exchange rate dialog popped up. It > defaulted to having me enter or fetch the rate, instead I chose Debit > Amount (credit in your case) and entered the amount in the test_local > account that I wanted to debit and committed the dialog. > > This created 2 more splits in their respective trading accounts that were > exact @ 200 and 10013 respectively as they should be. > > Your post reminded me of an issue I had a few months ago that I couldn’t > get rid of a similar Imbalance split involving trading accounts. I solved > it by switching to using the debit/credit amount field instead of the > exchange rate field. This makes sense because if you know the exact > amounts, you are defining a new price, you don’t need to fetch or employ an > existing one. I find that fetching or using price db figures are good for > current-value reports of my foreign currency and commodity assets. They > aren’t as useful (to me) for transaction entry. > > Regards, > Adrien > ___ > gnucash-user mailing list > gnucash-user@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. > -- cheers, Gio ___ gnucash-user mailing list gnucash-user@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.
[GNC] importing csv multisplit multicurrency problems
I'm encountering problems with importing transactions in csv when accounts have different currencies. I've been reading the debates. So this is not about definitions of multi-split or terminology. I did a test with a sample csv with the following contents: Date,Description,Account,Deposit,Withdrawal 1/3/2019,Description,test_foreign,,200 ,,Trading:CURRENCY:PHP,,10013 ,,Trading:CURRENCY:USD,200, ,,test_local,10013, gnucash imported successfully but it created an extra line Imbalance-USD. See results below: Date Description Account Deposit Withdrawal 1/3/2019 Description 200 Trading:CURRENCY:USD 197.78 test_local 10013 Imbalance-USD 2.22 test_foreign 200 Trading:CURRENCY:PHP 10013 1. Why does it do that when imported transactions is already balanced in the first place? 2. When I try to manually correct in gnucash (197.78->200), it wouldn't allow me. It keeps the imbalance no matter what I do. 3. How do I solve this? Thanks, gio -- cheers, Gio ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Gnucash automatically created trading accounts
Thank you David. On Sun, Jan 26, 2020 at 5:56 AM David Cousens wrote: > Gio, > > There is one problem that does occur with importing multiple currencies > associated with the price that I am aware of. If the price is expressed as > a > rational number i.e. one integer number divided by another integer number > or > 1+ a rational number, GnuCash sometimes does not appear to parse the price > information correctly. I have mainly experienced this while reimporting > exported data while testing the importer. One thing to try is if the price > information is expressed as a rational number in the CVS file try > converting > it to a decimal number before importing. > > To use the Actions > Edit Exchange Rate you need to select the split of the > transaction which will have the exchange rate information attached to it. > Try selecting the other split. I am able to edit the exchange rate /price > information in both registers an exchange rate transaction affects, but > only > one split in each register has the price information attached, the other > split has a price of 1 so you will need to apply this action to the right > split. > > Hope this helps > > > David > > > > - > David Cousens > -- > Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html > ___ > gnucash-user mailing list > gnucash-user@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. > -- cheers, Gio ___ gnucash-user mailing list gnucash-user@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.
[GNC] Gnucash automatically created trading accounts
So I started a new file. Then I imported csvs containing transactions which have been pre-populated with Gnucash expense accounts. While Gnucash expense accounts are in 1 currency, there are some accounts that have other currencies. After importation, I find that gnucash created a trading accounts category. Also the amounts on the imported transactions were not converted. Now that I enter in the split the correct currency by doing Actions > Edit Exchange Rate. But nothing happens. How do I correct these? Thanks. -- cheers, Gio ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] What if stock is from a country not in the list of types
Many thanks!! On Fri, May 4, 2018 at 7:20 PM John Ralls <jra...@ceridwen.fremont.ca.us> wrote: > > > > On May 4, 2018, at 5:32 AM, Gio Bacareza <gbacar...@gmail.com> wrote: > > > > I'm just about to start tracking my stocks. I'm reading the manual and > > tried to enter a stock which is traded in the Philippine Stock Exchange. > > > > Under type I only see AMEX, EUREX, NASDAQ, NYSE, FUND, All non currency. > > > > I assume I enter All Non Currency. But what does FUND mean? > > > > Make your own category. Those are just examples that are pre-populated > into GnuCash. BTW, the categories exist only for your convenience to reduce > the size of pick lists. You can just create one called “stocks” if you want > and lump all of them together regardless of exchange. You can also > recategorize commodities at will, so you could have an “Open” and “Closed” > category, the former for stocks that you currently own (as in “open > position”) and the latter for stocks that you’ve sold out of. > > FUND is intended for open-ended mutual funds which generally trade only > with the issuer and are priced daily at net asset value. That doesn’t mean > that that’s what you have to use it for, of course. > > Regards, > John Ralls > > -- cheers, Gio ___ gnucash-user mailing list gnucash-user@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.
[GNC] What if stock is from a country not in the list of types
I'm just about to start tracking my stocks. I'm reading the manual and tried to enter a stock which is traded in the Philippine Stock Exchange. Under type I only see AMEX, EUREX, NASDAQ, NYSE, FUND, All non currency. I assume I enter All Non Currency. But what does FUND mean? -- cheers, Gio ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] help setting accounts to track contributions
Thanks! On Fri, May 4, 2018 at 4:31 PM Maf. King <m...@chilwell.net> wrote: > On Friday, 4 May 2018 09:13:57 BST Gio Bacareza wrote: > > Hi, > > > > My partner and I are moving in together and we'd like to share expenses > > like groceries, rent, etc. So we'd like to track expenses as well as our > > appropriate contributions to make sure that we both are contributing > > equally to house expenses. > > > > How should I set up the contribution? Under what main account type should > > it be? Any recommendations? > > I'd suggest a datafile for you and a separate one for the "joint accounts" > > record contributions into the joint accounts as income (possibly with sub > accounts like Income:Contribution:Gio) and bill paid in the usual way as > Expenses:Electricity and so on. > > 0.02 > Maf. > > > -- cheers, Gio ___ gnucash-user mailing list gnucash-user@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.
[GNC] help setting accounts to track contributions
Hi, My partner and I are moving in together and we'd like to share expenses like groceries, rent, etc. So we'd like to track expenses as well as our appropriate contributions to make sure that we both are contributing equally to house expenses. How should I set up the contribution? Under what main account type should it be? Any recommendations? -- cheers, Gio ___ gnucash-user mailing list gnucash-user@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.
mixing business and personal
Hi, I have used gnucash initially to track household expenses. So my flatmate and I would contribute. We track what the transactions are for and also keep track of contributions so we know that we both contribute equally. Now that we are also going into a small business, I'd like some tips on what the best practices are. Should I incorporate the business transactions into the original file? Or should I create a different file for business? -- cheers, Gio ___ gnucash-user mailing list gnucash-user@gnucash.org 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.
