[GNC] transaction entries

2020-01-06 Thread Carl Hofinga
When I make transactions entries I enter 1) the date; 2) a reference number if applicable; 3) for the description column I enter a vendor or payee name such as Target or the payee's name; 4) the correct general ledger account number; 5) the debit or credit $ amount. There can be splits also. A

[GNC] Question about new 5 fundamental budget categories

2020-01-06 Thread Caleb Begly
In the changelog for 3.8, it says: [gnc-budget-view.c] totals - 5 fundamental types previous showed income/expense/transfers/totals budget totals, of uncertain meaning. now shows income/expense/asset/liability/equity budget totals. The 5 lines also become sensitive to the global sign-reverse

Re: [GNC] Setting up Gnucash for Household

2020-01-06 Thread Malcolm Fitzgerald
Hi David, Thanks for providing a clear explanation of the options, it was very helpful for me. Malcolm > On 6/01/2020, at 9:32 PM, David Cousens wrote: > > Malcolm, > > As others have said you really need professional advice. It will depend upon > your local legislation and how your

[GNC] Suggested source for LibOFX?

2020-01-06 Thread Bennie Gibson
    I'm a new GNUCash user and would like to get OFXDirect working.  Wondering where most folks get LibOFX.  SourceForge seems the most "official" looking but want to feel more comfortable about the source of this library. Thanks ___ gnucash-user

Re: [GNC] Gnucash Reports - Comparative Income Statement

2020-01-06 Thread Adrien Monteleone
I can confirm that on 3.8, you can use the proper dates. I ran a test for those 2 years prior to my last comment and it worked as expected. As for YTD, you’d have to run 2 separate reports and then move to a spreadsheet. There is a comparison transaction report floating around the list from a

Re: [GNC] Gnucash Reports - Comparative Income Statement

2020-01-06 Thread Christopher Lam
On Tue, 7 Jan 2020, 9:18 am Bill Dika, wrote: > > This is what I am looking for. Thank you. The "Options" dialog is a little > off (to get an income comparison of the two years being January 1, 2018 to > December 31, 2019, I must put in a start date of January 1, 2018 > (intuitive) but to get

Re: [GNC] Gnucash Reports - Comparative Income Statement

2020-01-06 Thread Bill Dika
michael d novack Thanks for the reply. I agree with everything you said but I am not looking for presentation Financial Statements. I am looking to make quick year to year comparisons with the reporting facility in Gnucash. Having ten years of financial data, I would like to make quick

Re: [GNC] Setting up Gnucash for Household

2020-01-06 Thread Richard Dawson
I'm not an accountant by any means, so this might be bad advice. I will tell you how I handle my personal and business accounts in one Gnucash file.  I have the usual set of accounts, Equity, Assets, Cash, Income, Liabilities, and Opening Balance for my personal accounts.  These have the usual

[GNC] Budget Flow Report - no column titles, & nothing in the help file

2020-01-06 Thread briancady413--- via gnucash-user
I've worked on a one-year budget in GNUCash 2.6.19, and now have made a budget flow report with two columns, but it has no column titles, nor is there explanation of the columns in the help files - There is only the words 'Budget Flow', under standard reports overview, beneath 'Budget Reports'.

Re: [GNC] Chaning left sidebar spacing

2020-01-06 Thread Adrien Monteleone
The GnuCash GTK3 wiki page will help: https://wiki.gnucash.org/wiki/GTK3#Visual_Styling Report back if there is something there you need more info on. Regards, Adrien > On Jan 6, 2020 w2d6, at 3:42 PM, AEG via gnucash-user > wrote: > > Adrien Monteleone-2 wrote >> Alan, >> >> You have to

Re: [GNC] Chaning left sidebar spacing

2020-01-06 Thread AEG via gnucash-user
Adrien Monteleone-2 wrote > Alan, > > You have to create the gtk-30.css file. It isn’t there by default. > > Regards, > Adrien Adrien, Thank you for pointing that out. I'll try to find out how to do that but would be grateful for any advice/guidance towards the best route. Regards, Alan >>

Re: [GNC] Corrupt security information

2020-01-06 Thread Bruno Acklin
Yes, this did the trick!! Thanks for the great coaching, John! I guess the takeaway is that the origin of bug https://bugs.gnucash.org/show_bug.cgi?id=797512 could be a double entry in the trading account. I just found that I had other stocks

Re: [GNC] Corrupt security information

2020-01-06 Thread John Ralls
Bruno, First delete the test transactions and the gain/loss transactions. Then delete Trading:NASDAQ:INTC. Save. You can try moving Trading:NYSE:INTC to Trading:NASDAQ:INTC (use Edit Account and change the parent account to Trading:NASDAQ with the selector at the bottom). While you're in the

Re: [GNC] Corrupt security information

2020-01-06 Thread Bruno Acklin
Hi John, Yes, a great feature if it worked fully, but.. (one of its flawed features is that one does not have control over when it generated Realized Gain/Loss entries.) Sorry to confuse you. The number of transactions does not tie: I have 5 trades, which are reflected in trading/NYSE/INTC,

Re: [GNC] Opening Balance on Reports

2020-01-06 Thread Evenmoreconfused
Wow, that's great. Talk about fast turn-around! Thank you very much, Paul Christopher Lam wrote > Good news; future releases where "Running Balance" is enabled, and the > sorting/grouping options include account, *will* now print the balance > brought forward. Zero-amount transaction hack isn't

Re: [GNC] Gnucash Reports - Comparative Income Statement

2020-01-06 Thread Michael or Penny Novack
On 1/5/2020 1:46 PM, Bill Dika wrote: What would it cost for someone to create a comparative income statement report comparing this period to the corresponding period last year? I am willing to pay if it is not too much. The report could be included in Gnucash and released under the GPL v3 or

Re: [GNC] Opening Balance on Reports

2020-01-06 Thread Christopher Lam
Good news; future releases where "Running Balance" is enabled, and the sorting/grouping options include account, *will* now print the balance brought forward. Zero-amount transaction hack isn't needed anymore. On Mon, 6 Jan 2020 at 05:01, Christopher Lam wrote: > Wouldn't seem right to offer

Re: [GNC] Gnucash Reports - Comparative Income Statement

2020-01-06 Thread Adrien Monteleone
Even simpler - I forgot about the new (experimental) multi-column Income Statement in v3.8. That will get your two periods lined up neatly. Then you just need to move that to a spreadsheet and add your variance column & formulas. Filing an RFE to add the variance column to the report would get

Re: [GNC] Gnucash Reports - Comparative Income Statement

2020-01-06 Thread Adrien Monteleone
While it is a small amount of work, you can do this yourself. Run each period’s report. Save/open or copy/paste the resulting reports into a spreadsheet. Add percentage/variance columns as desired with formulas. To make your life easier, you should use the same set of accounts for each

[GNC] Gnucash Reports - Comparative Income Statement

2020-01-06 Thread Bill Dika
What would it cost for someone to create a comparative income statement report comparing this period to the corresponding period last year? I am willing to pay if it is not too much. The report could be included in Gnucash and released under the GPL v3 or later. If this is not the correct list

Re: [GNC] Setting up Gnucash for Household

2020-01-06 Thread David Cousens
Malcolm, As others have said you really need professional advice. It will depend upon your local legislation and how your business affairs are structured whether you need to maintain separate books for your business activities or not. What follows is an attempt to outline how GnuCash might be