[GNC] Asset price source: select by account or commodity?
Hi - I'm using GnuCash for personal finances. There are 2 distinct types of commodity assets I want to account for: #1. Conventional financial market securities like stocks and mutual funds. These work well using the well-established Buy + Sell transactions, lots, and setting Price Source as "Last up thru Report date" when creating Balance Sheet reports. #2. Home heating fuel, specifically propane gas (LPG): We buy propane in deliveries of hundreds of gallons. A delivery is enough to heat the house for several months. I want to be able to report the value of the propane in our tank as an asset, valued at the price we paid for it based on FIFO. A balance sheet does this when buy's, sell's, and lots are set up correctly, and I set (Options > Commodities > Price Source) to "Average cost of purchased weighted by volume." Is there any way to differentiate Price Source by asset? That is, set or select Price Source to: "Average Cost" for Propane, and "Last up thru Report date" for financial assets? Thanks in advance. Chris ___ 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] Report - Income Statement - Layout problem
> On Mar 18, 2022, at 8:50 AM, Michael or Penny Novack > wrote: > > > >> B. WIDTH AND COLUMNS ALIGNMENT >> >> Maybe I didn't use the right words: I don't care about things being pretty >> (color, lines, etc). The report is messed up in its basic structure. Maybe >> showing you is better. I don't know if I can send a picture as attachment on >> the mailing list. I will try sending it in the next e-mail. > > You don't need to send me a picture. I do know what you are talking about. > But I am also considering things like having column alignment under the > meaning of "pretty". > > I (also) have columns not lined up in the "raw report" as produced by > gnucash. But I have deep nesting (in some of my boos) and the nesting is not > the same for all parts of income or expenses. So I expect to be exporting the > raw report and then editing outside of gnucash and I fix the column alignment > then. This is less of a burden to me because I am going to have to edit the > reports anyway. Because: > > 1) As treasurer I will need levels of detail to determine things like "do I > need to fill out a 1099-MISC for this intern when (is their PAY > $600; what > they get for mileage reimbursement isn't "pay"). All the board will want to > see then I present at the meeting is "total amount for all interns". So I > will need both "full detail" and "detail at the level a board would want from > conceptually the report. > > 2) I will be adding annotation to the report handed out to the board (or for > the annual report to the public). In other words, flag anything unusual and > explain in a footnote. Thus an expense item zero when something would be > expected there the annotation might be "vendor did not send us the invoice > for printing and mailing the annual meeting notices until after the end of > the quarter". > > 3) Related to the above example , I want to SELECTIVELY show or not show zero > amounts. > > BUT --- your problem with a fixed text not being translated is a "bug" and > should be brought to the attention of whoever is handling "French > translation". However, to be fair (to do the user's part) instead of JUST > reporting this by itself look at all of the reports to see if there aren't > other fixed text lines that were forgotten in the "French" version. I did > this for a living (designed/wrote/tested software). When we budgeted for a > project, that included a bucket for USER time. > > This is why I, a retired pro with decades in the cypher mines (and doing > :financial software to boot) am NOT helping with development. I am not going > to volunteer to do the design/coding without user commitment to their part of > the process << both in the design phase and the testing phase >> > What version of GnuCash are you using? That string should be translated in GnuCash 4.6 and later. 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.
Re: [GNC] Report - Income Statement - Layout problem
B. WIDTH AND COLUMNS ALIGNMENT Maybe I didn't use the right words: I don't care about things being pretty (color, lines, etc). The report is messed up in its basic structure. Maybe showing you is better. I don't know if I can send a picture as attachment on the mailing list. I will try sending it in the next e-mail. You don't need to send me a picture. I do know what you are talking about. But I am also considering things like having column alignment under the meaning of "pretty". I (also) have columns not lined up in the "raw report" as produced by gnucash. But I have deep nesting (in some of my boos) and the nesting is not the same for all parts of income or expenses. So I expect to be exporting the raw report and then editing outside of gnucash and I fix the column alignment then. This is less of a burden to me because I am going to have to edit the reports anyway. Because: 1) As treasurer I will need levels of detail to determine things like "do I need to fill out a 1099-MISC for this intern when (is their PAY > $600; what they get for mileage reimbursement isn't "pay"). All the board will want to see then I present at the meeting is "total amount for all interns". So I will need both "full detail" and "detail at the level a board would want from conceptually the report. 2) I will be adding annotation to the report handed out to the board (or for the annual report to the public). In other words, flag anything unusual and explain in a footnote. Thus an expense item zero when something would be expected there the annotation might be "vendor did not send us the invoice for printing and mailing the annual meeting notices until after the end of the quarter". 3) Related to the above example , I want to SELECTIVELY show or not show zero amounts. BUT --- your problem with a fixed text not being translated is a "bug" and should be brought to the attention of whoever is handling "French translation". However, to be fair (to do the user's part) instead of JUST reporting this by itself look at all of the reports to see if there aren't other fixed text lines that were forgotten in the "French" version. I did this for a living (designed/wrote/tested software). When we budgeted for a project, that included a bucket for USER time. This is why I, a retired pro with decades in the cypher mines (and doing :financial software to boot) am NOT helping with development. I am not going to volunteer to do the design/coding without user commitment to their part of the process << both in the design phase and the testing phase >> Michael D Novack ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user 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] How to create Transaction Report Filter on Checking to only show Accounts Payable Transactions?
I struggle with the Transaction Report Filter. The Situation:If I create a Transaction Report on Checking for last year...- I can enter key words from the Description field or from the Memo/Notes field...- into Transaction Filter field...- and it works fine...ButIf I enter "Accounts Payable" into the Transaction Filter field... it does not work.Ditto if I enter "Transfer from/to = Accounts Payable" The Question:How do I filter a Transaction Report on Checking to only show Accounts Payable transactions? Thanks for any help! ___ 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 Re: Transaction Report on Expenses, All Children, for 2021
My Bad. Expenses are created when the bill is posted... not when it is paid.Here is how it works...1 - Get Bill from Vendor X2 - Post bill from Vendor X to AP3 - Charge bill to Expense Acct Whatever4 - Pay Bill and Charge Checking Account and relive AP So to get all expenses paid in 2021 you would create a Transaction Report on the Checking Account for the time period you desire...And set the Sorting Option Primary Key to "Other Account"And then lookup Accounts Payable Total in the results. And if you know how you could set the Transaction Report Filter to only show Checking Transactions charged to Accounts Payable...I'm posting another thread on that... more properly titled... to help other poor souls... like me :-) On Thursday, March 17, 2022, 07:58:14 PM EDT, Fran_3 via gnucash-user wrote: Situation: We posted a bill in 2020 but paid it in 2021. I need to create an Expense report for all expenses paid in 2021... regardless of when the bill was posted... My attempted solution:I created a Transaction Report on "Expenses" with "All Children" selected...And with a date range of 1/1/2021 to 12/31/2021 The Problem:The payment for the 2020 bill does not show in the report...Even though the expense was paid in paid in 2021. How can I create a report that will show all expenses paid in 2021 regardless of when the bill was posted? Thanks for any help. ___ 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] Report - Income Statement - Layout problem
Hello, A. TITLE TRANSLATION PROBLEM I have already tried changing the title line. The title line is divided in four parts, the first two of which can be customized: 1. Company name (by default: blank) - customizable at will 2. Core title (by default: "Income statement") - customizable at will 3. A fixed string ("For Period Covering") - not customizable 4. Start and end dates ("01.01.2021 to 31.12.2021") - defined by the dates you choose I left the company name blank, so in my case the entire title line is: "Compte de résultat For Period Covering 01.01.2021 to 31.12.2021" The only problem is that the third part ("For Period Covering") is not translated and I cannot find where is the option to change or remove it. B. WIDTH AND COLUMNS ALIGNMENT Maybe I didn't use the right words: I don't care about things being pretty (color, lines, etc). The report is messed up in its basic structure. Maybe showing you is better. I don't know if I can send a picture as attachment on the mailing list. I will try sending it in the next e-mail. Thank you for your help Best regards Carl-Kensaku HERBORT DIGIENE Case postale CH-1002 Lausanne Suisse +41 (0) 21 320 22 66 Le 18.03.22 à 03:23, Michael or Penny Novack a écrit : On 3/17/2022 5:49 PM, Carl-Kensaku HERBORT wrote: Dear everyone, Thank you all for being here to help new users like me. I am having problems with the "income statement" report ("compte de resultat" in french). The columns of the revenue part and the columns of the expense part are not aligned. In fact, the entire layout of these two parts (including the width) seem to be independently managed from each other (contrary to what happens with the parts making up the "balance sheet"/"bilan" report, perfectly aligned and with an identical width). The result is quite ugly. Changing the stylesheet or making accounts name shorter or longer doesn't solve the problem. Could you please help me out ? An other problem is that there is an untranslated string in the middle of the title of the income statement report: "For Period Covering". As I am creating the report in french, it is a bit of a problem. Is there a way to replace this string by a translation or get rid of this string completely (whatever is easiest) ? The second question helps with the first because it makes me think that you have not yet investigated all the report options available to you. The process is, run the report (open it) and then use edit=>report options to change various things about the report. Though how you could be running an income statement without setting the effective date range is beyond me. Report title is one of the things you can make whatever your heart desires. I had been keeping books for non-profits so "Statement of Revenues and Expenses" HOWEVER -- if your "not lining up" is a matter of different levels of nesting in your CoA << income accounts vs expense accounts >> the report might need prettying up. It is a waste of time to try to do pretty printing INSIDE the accounting package. You want a full service editor for that. Run the report, export the raw report, and then edit THAT with your favorite editor. Michael D Novack ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user 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.