[GNC] How to use/add GAU currency?
Hello, In my country we use GAU instead of XAU as a currency. How can I add/use it in GnuCash? GAU = Gold Grams Ex. [1]https://goldprice.org/gold-price-per-gram.html I tried to add it as a new security with NASDAQ type but it only works in stock accounts while I want it to works as Bank/Asset account. -- Best Regards, Skype+Telegram+GMail: mbnoimi References 1. https://goldprice.org/gold-price-per-gram.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.
Re: [GNC] Currency Symbol
On 2019-04-14 15:18, Muhammad Bashir Al-Noimi wrote: Hi, I use Turkish Lira as a primary currency in my file but I noticed after upgrading GnuCash to recent version (3.5) that "Expense Piechart" no longer recognize Turkish currency symbol (₺) while "Transaction Report" does! How can I fix this issue? Notes: * I'm using Microsoft Windows 10 with en_US local. * I tried to modify the currency from "Securities" window by replacing ₺ by £ it worked! so I believe there is something wrong about ₺ symbol. https://en.wikipedia.org/wiki/Turkish_lira I forgot to mention some additional info: * I use "Stylesheet : Technicolor" in "Expense Piechart" report. * I tried to modify "Technicolor" font from "Edit -> Style Sheets" but it didn't fix the problem (default font is: Segoe UI) -- Best Regards, Skype+Telegram+GMail: mbnoimi ___ 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
Hi, I use Turkish Lira as a primary currency in my file but I noticed after upgrading GnuCash to recent version (3.5) that "Expense Piechart" no longer recognize Turkish currency symbol (₺) while "Transaction Report" does! How can I fix this issue? Notes: * I'm using Microsoft Windows 10 with en_US local. * I tried to modify the currency from "Securities" window by replacing ₺ by £ it worked! so I believe there is something wrong about ₺ symbol. https://en.wikipedia.org/wiki/Turkish_lira -- Best Regards, Skype+Telegram+GMail: mbnoimi ___ 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] GAU as currency
On 09/06/2018 09:09 PM, Mike or Penny Novack wrote: Not a currency but a commodity. The reason no currency symbol is at present there is no jurisdiction using gram Au as its CURRENCY. How can I use it in GNC (I didn't use a commodity before)? The most important thing about using GAU is getting updated quote on daily basis. -- Best Regards, Muhammad Bashir Al-Noimi Skype+Telegram+GMail: mbnoimi ___ 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] GAU as currency
Hi, How can use GAU (gold gram) as a currency in GNC instead of XAU (gold ounce)? I'm using GAU on daily basis. -- Best Regards, Muhammad Bashir Al-Noimi Skype+Telegram+GMail: mbnoimi ___ 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] Negative assets!
On 09/06/2018 05:07 PM, Muhammad Bashir Al-Noimi wrote: On 09/06/2018 02:49 PM, Adrien Monteleone wrote: Credit Cards are usually liabilities, not Assets. Actually it's an asset because it's very special card provided by my company. Click that credit card account in the CoA and then click the Edit Account button . What fundamental type is it? Asset? Liability? Asset Also, out of curiosity, does a Balance Sheet also show negative Current Assets? In the attachment you can find my Balance Sheet all the red values are incorrect. I may discovered the problem. In the attachment you can find that "Imbalance-USD" contains on duplicated incorrect transactions which I didn't create them!!! Do you have any suggestion for this strange case? Thanks very much guys I could fix the problem by following these steps: 1. Manually deleted all the duplicated transactions in "Imbalance-USD" 2. Manually deleted all empty transactions in "Imbalance-USD" 3. Emptied "Assets:Current Assets:GAU" then re-entered same transactions once again. It seems that my database entries corrupted because I didn't point to a correct account during deleting the old accounts. -- Best Regards, Muhammad Bashir Al-Noimi Skype+Telegram+GMail: mbnoimi ___ 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] Negative assets!
On 09/06/2018 05:25 PM, Geert Janssens wrote: Yes, that means the transactions you deleted were transferred to imbalance-USD because you didn't assign them to a new account. Does your book use multiple currencies ? Yes, I use multi-currencies -- Best Regards, Muhammad Bashir Al-Noimi Skype+Telegram+GMail: mbnoimi ___ 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] Negative assets!
On 09/06/2018 11:55 AM, Geert Janssens wrote: Most transactions not showing a balance is odd. See this transaction as example: When I open it from "Assets:Current Assets:TRY:Kocamustafapasa - CreditCard" it appears correctly as shown below: But when I open same transaction from "Current Assets and select Edit>Open Subaccounts" it appears without a balance as shown below: -- Best Regards, Muhammad Bashir Al-Noimi Skype+Telegram+GMail: mbnoimi ___ 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] Negative assets!
On 09/06/2018 11:55 AM, Geert Janssens wrote: Most transactions not showing a balance is odd. Have you tried to run check & repair on your assets account and its children ? I did, nothing changed. -- Best Regards, Muhammad Bashir Al-Noimi Skype+Telegram+GMail: mbnoimi ___ 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] Negative assets!
On 09/06/2018 05:37 AM, John Ralls wrote: Well, make completely sure. With the accounts page open, select View>Filter By... and make sure that all of the account types are selected on the “Account Type" tab and that Show hidden accounts is selected on the “Other” tab. There’s another way to get there as well: You can select Current Assets and select Edit>Open Subaccounts, which will open a register showing all of the transactions from Current Assets and all of its sub accounts in the normal order. That might help you see the transactions that drive it to a negative balance. I did that, I couldn't find any negative transactions (only a tiny one which I already know it). But I noticed most transactions don't reflect any balance while others did, does this related to my problem? How much is the discrepancy? IOW, if you add up all of the (positive) totals showing in the first-level sub accounts and then add the opposite of the (negative) total showing in Current Assets, what’s the difference? The discrepancy is big because when I calculate all my assets manually (multi-currencies) they did match the sub-accounts. Are there any transactions in Current Assets? Being a placeholder prevents you from adding transactions from the register, but there are other ways that transactions can get into it, including being transferred there when you delete a sub-account. Double clicking on it won’t work because it’s a placeholder so you have to use Edit>Open Account or pick Open from the context menu when Current Assets is selected. When I disabled "Placeholder" feature for "Current Assets" and "Assets" I found both of them are empty. THIS IS REALLY STRANGE I DID NOT FACE ANY PROBLEM WITH GNC BEFORE ALTHOUGH I USE IT SINCE YEARS AGO Thanks a lot John for the patience. -- Best Regards, Muhammad Bashir Al-Noimi Skype+Telegram+GMail: mbnoimi ___ 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] Negative assets!
On 09/06/2018 03:25 AM, John Ralls wrote: That’s Assets:Current Assets on the Accounts page, right? Not an entry in the summary bar at the bottom of the page? YES; It's an account in Accounts tree defined as a placeholder. Might you have hidden accounts with negative balances? I'm pretty sure all the sub accounts in Assets are in positive values. -- Best Regards, Muhammad Bashir Al-Noimi Skype+Telegram+GMail: mbnoimi ___ 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] Negative assets!
On 09/05/2018 06:06 PM, Muhammad Bashir Al-Noimi wrote: On 09/04/2018 05:55 PM, John Ralls wrote: When you deleted the accounts, what did you tell GnuCash to do with the transact ions? I don't remember exactly. Do you have any Imbalance-XXX accounts? Yes I've these accounts but they are empty. BTW, All the accounts are correct. I couldn't find any strange transaction just the negative -red- value of "Current Assets" account. -- Best Regards, Muhammad Bashir Al-Noimi Skype+Telegram+GMail: mbnoimi ___ 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] Negative assets!
On 09/04/2018 05:55 PM, John Ralls wrote: When you deleted the accounts, what did you tell GnuCash to do with the transact ions? I don't remember exactly. Do you have any Imbalance-XXX accounts? Yes I've these accounts but they are empty. -- Best Regards, Muhammad Bashir Al-Noimi Skype+Telegram+GMail: mbnoimi ___ 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] Negative assets!
Hi, After deleting some sub accounts under "Assets" I get negative value in "Current Assets". I manually look for any transaction(s) related to "Current Assets" but I failed to find any transaction related to it. How can I fix negative assets? NOTES: * I use multi-currencies. * I'm unable to see any negative values under "Current Assets" sub accounts. * All "Current Assets" sub accounts defined as "Asset" account type. -- Best Regards, Muhammad Bashir Al-Noimi Skype+Telegram+GMail: mbnoimi ___ 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: Average of transactions
On 03/19/2018 03:35 PM, Rick Copple wrote: I don't believe there is. The easiest way I know to accomplish that is to create a transaction report restricting it to that day and account, then make sure the create a table box is checked. Once you run the report, you can copy and paste the results into a spreadsheet. From there you should be able to get your average. Thanks Rick Usually I do it manually by getting number of days (from first transaction day to current day) using the following link then apply the average manually (this is really exhausting procedure because I've many accounts like this) [1]https://www.timeanddate.com/date/durationresult.html -- Best Regards, Muhammad Bashir Al-Noimi Skype+Telegram+GMail: mbnoimi References 1. https://www.timeanddate.com/date/durationresult.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.
Average of transactions
Hi, I've a liabilities account and I want to get the daily average of its transactions. Is there any report can calculate this value. -- Best Regards, Muhammad Bashir Al-Noimi Skype+Telegram+GMail: mbnoimi ___ 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.