Re: [GNC] undo close?

[Liz]

On Mon, 6 May 2019 19:35:24 -0700
ToddAndMargo via gnucash-user  wrote:

> Hi All,
> 
> If you accidentally hit "Close", is there a way to undo it other
> than from backup (which is what I did)?
> 
> Many thanks,
> -T

Start here
https://wiki.gnucash.org/wiki/FAQ#Q:_Somehow_I_managed_to_close_the_account_view_tab._How_can_I_get_it_back.3F
After that, in the account tab, double click on accounts you want to
see open.

Don't Panic *

*https://www.bustle.com/articles/25640-dont-panic-18-indispensable-life-lessons-from-the-hitchhikers-guide-to-the-galaxy-series

Liz
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
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] Okay, why won't it let me restore from backup?

[ToddAndMargo via gnucash-user]

On 5/6/19 7:41 PM, ToddAndMargo via gnucash-user wrote:

I restore yesterday's file and still get today's booboo

Why won't it let me restore from backup?



But I could run it from backup and press "save as" to put it back
where it normally goes.

Why?


___
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] undo close?

[ToddAndMargo via gnucash-user]

Hi All,

If you accidentally hit "Close", is there a way to undo it other
than from backup (which is what I did)?

Many thanks,
-T

___
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] Okay, why won't it let me restore from backup?

[ToddAndMargo via gnucash-user]

I restore yesterday's file and still get today's booboo

Why won't it let me restore from backup?

___
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] Questions

[Stephen C. Camidge]

Sorry. I followed the instructions but do not see the report in the Reports 
Menu.

Steve

--
Stephen C. Camidge scami...@fastmail.fm (519) 363-3912




On Mon, May 6, 2019, at 7:05 PM, Christopher Lam wrote:
> Oops it's set to "Experimental" menu.
> Just delete the 2 lines towards the end of the file as follows:
> 
> 'menu-path (list gnc:menuname-experimental)
> 
> On Tue, 7 May 2019 at 01:31, Stephen C. Camidge  wrote:
>> __
>> Thank you. I found the location but could not locate the report in the 
>> Reports Menu.
>> 
>> --
>> Stephen C. Camidge scami...@fastmail.fm (519) 363-3912
>> 
>> 
>> 
>> 
>> On Mon, May 6, 2019, at 10:31 AM, Christopher Lam wrote:
>>> Hi Stephen
>>> 
>>> You are very welcome to try the following report. Save it into 
>>> standard-reports folder, found deep within the Gnucash.app package, and it 
>>> will automatically add a new multicolumn income-statement and balance-sheet 
>>> report as you describe.
>>> 
>>> https://raw.githubusercontent.com/christopherlam/gnucash/maint-balsheet-pnl/gnucash/report/standard-reports/balsheet-pnl.scm
>>> 
>>> Your input will be very welcome regarding foreign-currency conversions, 
>>> realized/unrealized gain/loss, retained-earnings reporting. I'm sure you 
>>> know these definitions are a deep rabbit-hole. This report is a 
>>> work-in-progress for nearly 1 month due to unresolved questions.
>>> 
>>> Regards, Chris
>>> 
>>> On Mon, 6 May 2019 at 13:37, Stephen C. Camidge  
>>> wrote:
 2) Yes, I can get multi column reports with the Transaction Report, show 
 totals monthly by account, but it will not display monthly totals and it 
 will not display Revenue separately from Expenses with totals for Revenue 
 and for Expenses.
 
 3) I did make the multiple selection. Thank you for confirming that 
 something is indeed going on.
 
 
 -- 
 Stephen C. Camidge scami...@fastmail.fm (519) 363-3912
 
 On Mon, May 6, 2019, at 9:17 AM, David T. wrote:
 > 3 - I spoke too soon. There is something weird going on there. I can 
 > select multiple accounts, and some will display, while others do not. 
 > Not sure what is going on there.
 > 
 > > On May 6, 2019, at 6:38 PM, David T. via gnucash-user 
 > >  wrote:
 > > 
 > > 2 - Multicolumn reports are already part of GnuCash.
 > > 3 - I just loaded 3.5, ran the G/L report, selected a random set of 
 > > disjoint accounts, and received sane results. Is it possible that when 
 > > you attempted to select multiple accounts, you actually selected only 
 > > the last account you clicked? Many’s the time that I have thought I 
 > > had the Command key held down, only to discover that I’d succeeded in 
 > > picking only that last account…
 > > 
 > > 
 > > David
 > > 
 > >> On May 6, 2019, at 6:15 PM, Stephen C. Camidge  
 > >> wrote:
 > >> 
 > >> 1) OK
 > >> 
 > >> 2) yes - this would be most useful
 > >> 
 > >> 3) General Ledger - I can select multiple accounts, but for me (Mac, 
 > >> 3.5) only the first selected account appears in the General Ledger 
 > >> Report.
 > >> 
 > >> -- 
 > >> Stephen C. Camidge scami...@fastmail.fm (519) 363-3912
 > >> 
 > >> On Mon, May 6, 2019, at 8:41 AM, David T. wrote:
 > >>> 1 - As I mentioned, account codes will work for this. Assign each 
 > >>> account a numeric code, add the code column to the COA, and sort on 
 > >>> it. 
 > >>> Done.
 > >>> 2 - Multicolumn reports.
 > >>> 3 - Are you talking about the “General Ledger” report, or the 
 > >>> “General 
 > >>> Journal” report? My version of the former report (GC 3.4 under 
 > >>> MacOX) 
 > >>> behaves exactly like the generic “Transaction Report” you mention 
 > >>> (indeed, I suspect that under the hood, that’s what it is). IOW, I 
 > >>> am 
 > >>> able to select accounts for inclusion on the report. Can you explain 
 > >>> more specifically what you are doing and seeing, and what you expect 
 > >>> to 
 > >>> find that you are not?
 > >>> 
 > >>> David
 > >>> 
 >  On May 6, 2019, at 5:56 PM, Stephen C. Camidge 
 >   wrote:
 >  
 >  1) different order to reflect what I am used to seeing in other 
 >  accounting programs
 >  
 >  2) I agree that comparative reports would be useful - other 
 >  programs offer them as option, the program should too
 >  
 >  3) multiple accounts in a G/L report are standard elsewhere - the 
 >  transaction report can do this, but the G/L detail report should.
 >  
 >  
 >  -- 
 >  Stephen C. Camidge scami...@fastmail.fm (519) 363-3912
 >  
 >  On Mon, May 6, 2019, at 8:08 AM, Michael or Penny Novack wrote:
 > > On 5/6/2019 7:13 AM, Stephen Camidge wrote:
 > >> 1) I set up a new book on the Mac 

Re: [GNC] Questions

[Christopher Lam]

Oops it's set to "Experimental" menu.
Just delete the 2 lines towards the end of the file as follows:

'menu-path (list gnc:menuname-experimental)

On Tue, 7 May 2019 at 01:31, Stephen C. Camidge 
wrote:

> Thank you. I found the location but could not locate the report in the
> Reports Menu.
>
> --
> Stephen C. Camidge scami...@fastmail.fm (519) 363-3912
>
>
>
>
> On Mon, May 6, 2019, at 10:31 AM, Christopher Lam wrote:
>
> Hi Stephen
>
> You are very welcome to try the following report. Save it into
> standard-reports folder, found deep within the Gnucash.app package, and it
> will automatically add a new multicolumn income-statement and balance-sheet
> report as you describe.
>
>
> https://raw.githubusercontent.com/christopherlam/gnucash/maint-balsheet-pnl/gnucash/report/standard-reports/balsheet-pnl.scm
>
> Your input will be very welcome regarding foreign-currency conversions,
> realized/unrealized gain/loss, retained-earnings reporting. I'm sure you
> know these definitions are a deep rabbit-hole. This report is a
> work-in-progress for nearly 1 month due to unresolved questions.
>
> Regards, Chris
>
> On Mon, 6 May 2019 at 13:37, Stephen C. Camidge 
> wrote:
>
> 2) Yes, I can get multi column reports with the Transaction Report, show
> totals monthly by account, but it will not display monthly totals and it
> will not display Revenue separately from Expenses with totals for Revenue
> and for Expenses.
>
> 3) I did make the multiple selection. Thank you for confirming that
> something is indeed going on.
>
>
> --
> Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912
>
> On Mon, May 6, 2019, at 9:17 AM, David T. wrote:
> > 3 - I spoke too soon. There is something weird going on there. I can
> > select multiple accounts, and some will display, while others do not.
> > Not sure what is going on there.
> >
> > > On May 6, 2019, at 6:38 PM, David T. via gnucash-user <
> gnucash-user@gnucash.org> wrote:
> > >
> > > 2 - Multicolumn reports are already part of GnuCash.
> > > 3 - I just loaded 3.5, ran the G/L report, selected a random set of
> disjoint accounts, and received sane results. Is it possible that when you
> attempted to select multiple accounts, you actually selected only the last
> account you clicked? Many’s the time that I have thought I had the Command
> key held down, only to discover that I’d succeeded in picking only that
> last account…
> > >
> > >
> > > David
> > >
> > >> On May 6, 2019, at 6:15 PM, Stephen C. Camidge 
> wrote:
> > >>
> > >> 1) OK
> > >>
> > >> 2) yes - this would be most useful
> > >>
> > >> 3) General Ledger - I can select multiple accounts, but for me (Mac,
> 3.5) only the first selected account appears in the General Ledger Report.
> > >>
> > >> --
> > >> Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912
> > >>
> > >> On Mon, May 6, 2019, at 8:41 AM, David T. wrote:
> > >>> 1 - As I mentioned, account codes will work for this. Assign each
> > >>> account a numeric code, add the code column to the COA, and sort on
> it.
> > >>> Done.
> > >>> 2 - Multicolumn reports.
> > >>> 3 - Are you talking about the “General Ledger” report, or the
> “General
> > >>> Journal” report? My version of the former report (GC 3.4 under
> MacOX)
> > >>> behaves exactly like the generic “Transaction Report” you mention
> > >>> (indeed, I suspect that under the hood, that’s what it is). IOW, I
> am
> > >>> able to select accounts for inclusion on the report. Can you explain
> > >>> more specifically what you are doing and seeing, and what you expect
> to
> > >>> find that you are not?
> > >>>
> > >>> David
> > >>>
> >  On May 6, 2019, at 5:56 PM, Stephen C. Camidge <
> scami...@fastmail.fm> wrote:
> > 
> >  1) different order to reflect what I am used to seeing in other
> accounting programs
> > 
> >  2) I agree that comparative reports would be useful - other
> programs offer them as option, the program should too
> > 
> >  3) multiple accounts in a G/L report are standard elsewhere - the
> transaction report can do this, but the G/L detail report should.
> > 
> > 
> >  --
> >  Stephen C. Camidge scami...@fastmail.fm   (519)
> 363-3912
> > 
> >  On Mon, May 6, 2019, at 8:08 AM, Michael or Penny Novack wrote:
> > > On 5/6/2019 7:13 AM, Stephen Camidge wrote:
> > >> 1) I set up a new book on the Mac version of gnucash using "A
> Simple
> > >> Checkbook". The Chart of Accounts places Income below Expenses -
> why?
> > >> I added Top Level Accounts for Liabilities and it was put below
> > >> Income.  The Transaction Report shows Income below Expenses.  How
> do I
> > >> change the order?
> > > Collating sequence ( L > I)   Just curious, but why do you
> want a
> > > different order?
> > >
> > >> 2) Income Statement show the selected period in the right order
> but
> > >> cannot show columns by month. Same with Profit and Loss.
> Transaction
> > 

Re: [GNC] Reporting Tools

[Klaus Dahlke]

Alternative is to use a database (mysql, postgres, SQLite) and e.g. libreoffice 
as GUI frontend for reporting/dataretrieval. Clearly, still some basic SQL know 
might be required.

Cheers,
Klaus

On Wed, 1 May 2019 00:57:50 -0500
Adrien Monteleone  wrote:

> Unless you’re up for learning SQL, there is an easier path if all you want 
> are pretty reports.
> 
> You can copy/paste reports to a spreadsheet and manipulate from there.
> 
> You can get part of the way to a ‘dashboard’ with the multi-column report. 
> Look into it.
> 
> Otherwise, probably an intermediate step would be to use the SQlite backend 
> paired with piecash for your report queries.
> 
> Maintaining and setting up a MySQL db is certainly more involved.
> 
> Regards,
> Adrien
> 
> > On Apr 30, 2019, at 11:07 PM, Sachin Danave  wrote:
> > 
> > Hi All,
> > 
> > I am not a programmer and have been using MS Money for years. While I love
> > the Gnucash features, I miss the MS Money colorful reports (and yes a
> > beautiful dashboard).
> > 
> > I came across a post (I think it was Reddit) that suggests that you can
> > save Gnucash file to a MySQL database and then use an external
> > reporting tool to generate custom reports.
> > 
> > Has anyone tried this ? How difficult it is assuming no programming
> > knowledge ?
> > 
> > Thanks in advance
> > 
> > Best Regards
> > 
> > Sachin
> 
> 
> ___
> 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] Rate column appeared after Balance

[Colin Law]

Of course, I new that.  Brain fade I think.

Thanks

Colin

On Mon, 6 May 2019 at 17:35, Derek Atkins  wrote:
>
> Hi,
>
> Colin Law  writes:
>
> > Using 3.5 on Ubuntu , on just one of my Bank accounts a Rate column
> > has appeared to the right of the Balance column.  I can push it off to
> > the right but it has a habit or re-appearing.  I am not aware of
> > having done anything to make it happen.  I imagine it is to do with
> > exchange rates, but I only use GBP and have checked that the account
> > is still set to that currency.
> >
> > I have looked through the preferences, looked in the manual and
> > Googled to no avail.
> >
> > Any suggestions on why it might have appeared and how to get rid of it?
>
> It's always there.  It just defaults to 1 pixel wide.  You must have
> accidentally double-clicked in the column or grabbed the rate-column
> header and dragged it.
>
> Just grab the right-side of the header and drag it left to again reduce
> the column width to 1 pixel.
>
> Alas, there is no way to have a "hidden" column in the register code. :(
>
> > Colin
>
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
> -derek
>
> --
>Derek Atkins 617-623-3745
>de...@ihtfp.com www.ihtfp.com
>Computer and Internet Security Consultant
___
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] Rate column appeared after Balance

[Derek Atkins]

Hi,

Colin Law  writes:

> Using 3.5 on Ubuntu , on just one of my Bank accounts a Rate column
> has appeared to the right of the Balance column.  I can push it off to
> the right but it has a habit or re-appearing.  I am not aware of
> having done anything to make it happen.  I imagine it is to do with
> exchange rates, but I only use GBP and have checked that the account
> is still set to that currency.
>
> I have looked through the preferences, looked in the manual and
> Googled to no avail.
>
> Any suggestions on why it might have appeared and how to get rid of it?

It's always there.  It just defaults to 1 pixel wide.  You must have
accidentally double-clicked in the column or grabbed the rate-column
header and dragged it.

Just grab the right-side of the header and drag it left to again reduce
the column width to 1 pixel.

Alas, there is no way to have a "hidden" column in the register code. :(

> Colin

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant
___
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] Questions

[Stephen C. Camidge]

Thank you. I found the location but could not locate the report in the Reports 
Menu.

--
Stephen C. Camidge scami...@fastmail.fm (519) 363-3912




On Mon, May 6, 2019, at 10:31 AM, Christopher Lam wrote:
> Hi Stephen
> 
> You are very welcome to try the following report. Save it into 
> standard-reports folder, found deep within the Gnucash.app package, and it 
> will automatically add a new multicolumn income-statement and balance-sheet 
> report as you describe.
> 
> https://raw.githubusercontent.com/christopherlam/gnucash/maint-balsheet-pnl/gnucash/report/standard-reports/balsheet-pnl.scm
> 
> Your input will be very welcome regarding foreign-currency conversions, 
> realized/unrealized gain/loss, retained-earnings reporting. I'm sure you know 
> these definitions are a deep rabbit-hole. This report is a work-in-progress 
> for nearly 1 month due to unresolved questions.
> 
> Regards, Chris
> 
> On Mon, 6 May 2019 at 13:37, Stephen C. Camidge  wrote:
>> 2) Yes, I can get multi column reports with the Transaction Report, show 
>> totals monthly by account, but it will not display monthly totals and it 
>> will not display Revenue separately from Expenses with totals for Revenue 
>> and for Expenses.
>> 
>>  3) I did make the multiple selection. Thank you for confirming that 
>> something is indeed going on.
>> 
>> 
>>  -- 
>>  Stephen C. Camidge scami...@fastmail.fm (519) 363-3912
>> 
>>  On Mon, May 6, 2019, at 9:17 AM, David T. wrote:
>>  > 3 - I spoke too soon. There is something weird going on there. I can 
>>  > select multiple accounts, and some will display, while others do not. 
>>  > Not sure what is going on there.
>>  > 
>>  > > On May 6, 2019, at 6:38 PM, David T. via gnucash-user 
>>  wrote:
>>  > > 
>>  > > 2 - Multicolumn reports are already part of GnuCash.
>>  > > 3 - I just loaded 3.5, ran the G/L report, selected a random set of 
>> disjoint accounts, and received sane results. Is it possible that when you 
>> attempted to select multiple accounts, you actually selected only the last 
>> account you clicked? Many’s the time that I have thought I had the Command 
>> key held down, only to discover that I’d succeeded in picking only that last 
>> account…
>>  > > 
>>  > > 
>>  > > David
>>  > > 
>>  > >> On May 6, 2019, at 6:15 PM, Stephen C. Camidge  
>> wrote:
>>  > >> 
>>  > >> 1) OK
>>  > >> 
>>  > >> 2) yes - this would be most useful
>>  > >> 
>>  > >> 3) General Ledger - I can select multiple accounts, but for me (Mac, 
>> 3.5) only the first selected account appears in the General Ledger Report.
>>  > >> 
>>  > >> -- 
>>  > >> Stephen C. Camidge scami...@fastmail.fm (519) 363-3912
>>  > >> 
>>  > >> On Mon, May 6, 2019, at 8:41 AM, David T. wrote:
>>  > >>> 1 - As I mentioned, account codes will work for this. Assign each 
>>  > >>> account a numeric code, add the code column to the COA, and sort on 
>> it. 
>>  > >>> Done.
>>  > >>> 2 - Multicolumn reports.
>>  > >>> 3 - Are you talking about the “General Ledger” report, or the 
>> “General 
>>  > >>> Journal” report? My version of the former report (GC 3.4 under MacOX) 
>>  > >>> behaves exactly like the generic “Transaction Report” you mention 
>>  > >>> (indeed, I suspect that under the hood, that’s what it is). IOW, I am 
>>  > >>> able to select accounts for inclusion on the report. Can you explain 
>>  > >>> more specifically what you are doing and seeing, and what you expect 
>> to 
>>  > >>> find that you are not?
>>  > >>> 
>>  > >>> David
>>  > >>> 
>>  >  On May 6, 2019, at 5:56 PM, Stephen C. Camidge 
>>  wrote:
>>  >  
>>  >  1) different order to reflect what I am used to seeing in other 
>> accounting programs
>>  >  
>>  >  2) I agree that comparative reports would be useful - other programs 
>> offer them as option, the program should too
>>  >  
>>  >  3) multiple accounts in a G/L report are standard elsewhere - the 
>> transaction report can do this, but the G/L detail report should.
>>  >  
>>  >  
>>  >  -- 
>>  >  Stephen C. Camidge scami...@fastmail.fm (519) 363-3912
>>  >  
>>  >  On Mon, May 6, 2019, at 8:08 AM, Michael or Penny Novack wrote:
>>  > > On 5/6/2019 7:13 AM, Stephen Camidge wrote:
>>  > >> 1) I set up a new book on the Mac version of gnucash using "A 
>> Simple 
>>  > >> Checkbook". The Chart of Accounts places Income below Expenses - 
>> why? 
>>  > >> I added Top Level Accounts for Liabilities and it was put below 
>>  > >> Income. The Transaction Report shows Income below Expenses. How do 
>> I 
>>  > >> change the order?
>>  > > Collating sequence ( L > I) Just curious, but why do you want a 
>>  > > different order?
>>  > > 
>>  > >> 2) Income Statement show the selected period in the right order 
>> but 
>>  > >> cannot show columns by month. Same with Profit and Loss. 
>> Transaction 
>>  > >> report can, but in the wrong order (see 1).
>>  > > You are asking for a series of "Inc

Re: [GNC] Questions

[Stephen C. Camidge]

2 Thank you. I am not yet comfortable with using that report - can't get it to 
work. Will experiment later.

-- 
Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912

On Mon, May 6, 2019, at 10:11 AM, David T. wrote:
> 2 - You misunderstand me. I am not speaking about using the Transaction 
> Report with subtotals. I am speaking about using multiple instances of 
> the Income report you desire, each set for the period you want. Go to 
> Reports->Sample & Custom Reports->Custom Multicolumn Report and set it 
> up with (for example) two columns, with an Income report for the 
> previous quarter in the first column, and an Income Report for the 
> current quarter in the second column.
> 
> 3 - There is something fishy with the General Ledger report. It doesn’t 
> seem to recognize certain accounts, and there doesn’t seem rhyme or 
> reason to the accounts it includes or omits. This is true in both 3.4 
> and 3.5. It doesn’t seem to be the currency of the accounts (that is, I 
> can see some but not all accounts denominated in different currencies). 
> It doesn’t seem to be the depth of the accounts selected (I can see 
> some but not all accounts at numerous different levels of the 
> hierarchy). I will note that it will not display a selected account if 
> there are no transactions in the period selected. However, that doesn’t 
> explain everything that’s going on here…
> 
> David
> 
> 
> > On May 6, 2019, at 7:05 PM, Stephen C. Camidge  wrote:
> > 
> > 2) Yes, I can get multi column reports with the Transaction Report, show 
> > totals monthly by account, but it will not display monthly totals and it 
> > will not display Revenue separately from Expenses with totals for Revenue 
> > and for Expenses.
> > 
> > 3) I did make the multiple selection. Thank you for confirming that 
> > something is indeed going on.
> > 
> > 
> > -- 
> > Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912
> > 
> > On Mon, May 6, 2019, at 9:17 AM, David T. wrote:
> >> 3 - I spoke too soon. There is something weird going on there. I can 
> >> select multiple accounts, and some will display, while others do not. 
> >> Not sure what is going on there.
> >> 
> >>> On May 6, 2019, at 6:38 PM, David T. via gnucash-user 
> >>>  wrote:
> >>> 
> >>> 2 - Multicolumn reports are already part of GnuCash.
> >>> 3 - I just loaded 3.5, ran the G/L report, selected a random set of 
> >>> disjoint accounts, and received sane results. Is it possible that when 
> >>> you attempted to select multiple accounts, you actually selected only the 
> >>> last account you clicked? Many’s the time that I have thought I had the 
> >>> Command key held down, only to discover that I’d succeeded in picking 
> >>> only that last account…
> >>> 
> >>> 
> >>> David
> >>> 
>  On May 6, 2019, at 6:15 PM, Stephen C. Camidge  
>  wrote:
>  
>  1) OK
>  
>  2) yes - this would be most useful
>  
>  3) General Ledger - I can select multiple accounts, but for me (Mac, 
>  3.5) only the first selected account appears in the General Ledger 
>  Report.
>  
>  -- 
>  Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912
>  
>  On Mon, May 6, 2019, at 8:41 AM, David T. wrote:
> > 1 - As I mentioned, account codes will work for this. Assign each 
> > account a numeric code, add the code column to the COA, and sort on it. 
> > Done.
> > 2 - Multicolumn reports.
> > 3 - Are you talking about the “General Ledger” report, or the “General 
> > Journal” report? My version of the former report (GC 3.4 under MacOX) 
> > behaves exactly like the generic “Transaction Report” you mention 
> > (indeed, I suspect that under the hood, that’s what it is). IOW, I am 
> > able to select accounts for inclusion on the report. Can you explain 
> > more specifically what you are doing and seeing, and what you expect to 
> > find that you are not?
> > 
> > David
> > 
> >> On May 6, 2019, at 5:56 PM, Stephen C. Camidge  
> >> wrote:
> >> 
> >> 1) different order to reflect what I am used to seeing in other 
> >> accounting programs
> >> 
> >> 2) I agree that comparative reports would be useful - other programs 
> >> offer them as option, the program should too
> >> 
> >> 3) multiple accounts in a G/L report are standard elsewhere - the 
> >> transaction report can do this, but the G/L detail report should.
> >> 
> >> 
> >> -- 
> >> Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912
> >> 
> >> On Mon, May 6, 2019, at 8:08 AM, Michael or Penny Novack wrote:
> >>> On 5/6/2019 7:13 AM, Stephen Camidge wrote:
>  1) I set up a new book on the Mac version of gnucash using "A Simple 
>  Checkbook". The Chart of Accounts places Income below Expenses - 
>  why? 
>  I added Top Level Accounts for Liabilities and it was put below 

Re: [GNC] Questions

[Stephen C. Camidge]

Understood, thank you.

-- 
Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912

On Mon, May 6, 2019, at 11:03 AM, wheelercsg-li...@yahoo.com wrote:
> I'm still using GnuCash 2.6.15, so it may be different in later 
> releases, but in 2.6.15 you can change the sort order of the top-level 
> accounts by clicking on the header labelled "Account Name".
> 
> > Date: Mon, 6 May 2019 07:13:17 -0400
> > From: Stephen Camidge
> > To:gnucash-user@gnucash.org
> > Subject: [GNC] Questions
> > Message-ID:<51dc21db-a256-9b77-a0a0-911a821d9...@fastmail.fm>
> > Content-Type: text/plain; charset=utf-8; format=flowed
> >
> > 1) I set up a new book on the Mac version of gnucash using "A Simple
> > Checkbook". The Chart of Accounts places Income below Expenses - why? I
> > added Top Level Accounts for Liabilities and it was put below Income.?
> > The Transaction Report shows Income below Expenses.? How do I change the
> > order?
> >
> > [snip]
> >
> > What am I missing?
> >
> > Thank you.
> 
>
___
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] Questions

[wheelercsg-lists--- via gnucash-user]

I'm still using GnuCash 2.6.15, so it may be different in later 
releases, but in 2.6.15 you can change the sort order of the top-level 
accounts by clicking on the header labelled "Account Name".



Date: Mon, 6 May 2019 07:13:17 -0400
From: Stephen Camidge
To:gnucash-user@gnucash.org
Subject: [GNC] Questions
Message-ID:<51dc21db-a256-9b77-a0a0-911a821d9...@fastmail.fm>
Content-Type: text/plain; charset=utf-8; format=flowed

1) I set up a new book on the Mac version of gnucash using "A Simple
Checkbook". The Chart of Accounts places Income below Expenses - why? I
added Top Level Accounts for Liabilities and it was put below Income.?
The Transaction Report shows Income below Expenses.? How do I change the
order?

[snip]

What am I missing?

Thank you.


___
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] Questions

[Christopher Lam]

typo: This report is a work-in-progress for nearly 1 year due to such
unresolved questions

On Mon, 6 May 2019 at 14:31, Christopher Lam 
wrote:

> Hi Stephen
>
> You are very welcome to try the following report. Save it into
> standard-reports folder, found deep within the Gnucash.app package, and it
> will automatically add a new multicolumn income-statement and balance-sheet
> report as you describe.
>
>
> https://raw.githubusercontent.com/christopherlam/gnucash/maint-balsheet-pnl/gnucash/report/standard-reports/balsheet-pnl.scm
>
> Your input will be very welcome regarding foreign-currency conversions,
> realized/unrealized gain/loss, retained-earnings reporting. I'm sure you
> know these definitions are a deep rabbit-hole. This report is a
> work-in-progress for nearly 1 month due to unresolved questions.
>
> Regards, Chris
>
> On Mon, 6 May 2019 at 13:37, Stephen C. Camidge 
> wrote:
>
>> 2) Yes, I can get multi column reports with the Transaction Report, show
>> totals monthly by account, but it will not display monthly totals and it
>> will not display Revenue separately from Expenses with totals for Revenue
>> and for Expenses.
>>
>> 3) I did make the multiple selection. Thank you for confirming that
>> something is indeed going on.
>>
>>
>> --
>> Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912
>>
>> On Mon, May 6, 2019, at 9:17 AM, David T. wrote:
>> > 3 - I spoke too soon. There is something weird going on there. I can
>> > select multiple accounts, and some will display, while others do not.
>> > Not sure what is going on there.
>> >
>> > > On May 6, 2019, at 6:38 PM, David T. via gnucash-user <
>> gnucash-user@gnucash.org> wrote:
>> > >
>> > > 2 - Multicolumn reports are already part of GnuCash.
>> > > 3 - I just loaded 3.5, ran the G/L report, selected a random set of
>> disjoint accounts, and received sane results. Is it possible that when you
>> attempted to select multiple accounts, you actually selected only the last
>> account you clicked? Many’s the time that I have thought I had the Command
>> key held down, only to discover that I’d succeeded in picking only that
>> last account…
>> > >
>> > >
>> > > David
>> > >
>> > >> On May 6, 2019, at 6:15 PM, Stephen C. Camidge 
>> wrote:
>> > >>
>> > >> 1) OK
>> > >>
>> > >> 2) yes - this would be most useful
>> > >>
>> > >> 3) General Ledger - I can select multiple accounts, but for me (Mac,
>> 3.5) only the first selected account appears in the General Ledger Report.
>> > >>
>> > >> --
>> > >> Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912
>> > >>
>> > >> On Mon, May 6, 2019, at 8:41 AM, David T. wrote:
>> > >>> 1 - As I mentioned, account codes will work for this. Assign each
>> > >>> account a numeric code, add the code column to the COA, and sort on
>> it.
>> > >>> Done.
>> > >>> 2 - Multicolumn reports.
>> > >>> 3 - Are you talking about the “General Ledger” report, or the
>> “General
>> > >>> Journal” report? My version of the former report (GC 3.4 under
>> MacOX)
>> > >>> behaves exactly like the generic “Transaction Report” you mention
>> > >>> (indeed, I suspect that under the hood, that’s what it is). IOW, I
>> am
>> > >>> able to select accounts for inclusion on the report. Can you
>> explain
>> > >>> more specifically what you are doing and seeing, and what you
>> expect to
>> > >>> find that you are not?
>> > >>>
>> > >>> David
>> > >>>
>> >  On May 6, 2019, at 5:56 PM, Stephen C. Camidge <
>> scami...@fastmail.fm> wrote:
>> > 
>> >  1) different order to reflect what I am used to seeing in other
>> accounting programs
>> > 
>> >  2) I agree that comparative reports would be useful - other
>> programs offer them as option, the program should too
>> > 
>> >  3) multiple accounts in a G/L report are standard elsewhere - the
>> transaction report can do this, but the G/L detail report should.
>> > 
>> > 
>> >  --
>> >  Stephen C. Camidge scami...@fastmail.fm   (519)
>> 363-3912
>> > 
>> >  On Mon, May 6, 2019, at 8:08 AM, Michael or Penny Novack wrote:
>> > > On 5/6/2019 7:13 AM, Stephen Camidge wrote:
>> > >> 1) I set up a new book on the Mac version of gnucash using "A
>> Simple
>> > >> Checkbook". The Chart of Accounts places Income below Expenses -
>> why?
>> > >> I added Top Level Accounts for Liabilities and it was put below
>> > >> Income.  The Transaction Report shows Income below Expenses.
>> How do I
>> > >> change the order?
>> > > Collating sequence ( L > I)   Just curious, but why do you
>> want a
>> > > different order?
>> > >
>> > >> 2) Income Statement show the selected period in the right order
>> but
>> > >> cannot show columns by month. Same with Profit and Loss.
>> Transaction
>> > >> report can, but in the wrong order (see 1).
>> > > You are asking for a series of "Income Statement" reports for
>> > > consecutive periods displayed side by side (each

Re: [GNC] Questions

[Christopher Lam]

Hi Stephen

You are very welcome to try the following report. Save it into
standard-reports folder, found deep within the Gnucash.app package, and it
will automatically add a new multicolumn income-statement and balance-sheet
report as you describe.

https://raw.githubusercontent.com/christopherlam/gnucash/maint-balsheet-pnl/gnucash/report/standard-reports/balsheet-pnl.scm

Your input will be very welcome regarding foreign-currency conversions,
realized/unrealized gain/loss, retained-earnings reporting. I'm sure you
know these definitions are a deep rabbit-hole. This report is a
work-in-progress for nearly 1 month due to unresolved questions.

Regards, Chris

On Mon, 6 May 2019 at 13:37, Stephen C. Camidge 
wrote:

> 2) Yes, I can get multi column reports with the Transaction Report, show
> totals monthly by account, but it will not display monthly totals and it
> will not display Revenue separately from Expenses with totals for Revenue
> and for Expenses.
>
> 3) I did make the multiple selection. Thank you for confirming that
> something is indeed going on.
>
>
> --
> Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912
>
> On Mon, May 6, 2019, at 9:17 AM, David T. wrote:
> > 3 - I spoke too soon. There is something weird going on there. I can
> > select multiple accounts, and some will display, while others do not.
> > Not sure what is going on there.
> >
> > > On May 6, 2019, at 6:38 PM, David T. via gnucash-user <
> gnucash-user@gnucash.org> wrote:
> > >
> > > 2 - Multicolumn reports are already part of GnuCash.
> > > 3 - I just loaded 3.5, ran the G/L report, selected a random set of
> disjoint accounts, and received sane results. Is it possible that when you
> attempted to select multiple accounts, you actually selected only the last
> account you clicked? Many’s the time that I have thought I had the Command
> key held down, only to discover that I’d succeeded in picking only that
> last account…
> > >
> > >
> > > David
> > >
> > >> On May 6, 2019, at 6:15 PM, Stephen C. Camidge 
> wrote:
> > >>
> > >> 1) OK
> > >>
> > >> 2) yes - this would be most useful
> > >>
> > >> 3) General Ledger - I can select multiple accounts, but for me (Mac,
> 3.5) only the first selected account appears in the General Ledger Report.
> > >>
> > >> --
> > >> Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912
> > >>
> > >> On Mon, May 6, 2019, at 8:41 AM, David T. wrote:
> > >>> 1 - As I mentioned, account codes will work for this. Assign each
> > >>> account a numeric code, add the code column to the COA, and sort on
> it.
> > >>> Done.
> > >>> 2 - Multicolumn reports.
> > >>> 3 - Are you talking about the “General Ledger” report, or the
> “General
> > >>> Journal” report? My version of the former report (GC 3.4 under
> MacOX)
> > >>> behaves exactly like the generic “Transaction Report” you mention
> > >>> (indeed, I suspect that under the hood, that’s what it is). IOW, I
> am
> > >>> able to select accounts for inclusion on the report. Can you explain
> > >>> more specifically what you are doing and seeing, and what you expect
> to
> > >>> find that you are not?
> > >>>
> > >>> David
> > >>>
> >  On May 6, 2019, at 5:56 PM, Stephen C. Camidge <
> scami...@fastmail.fm> wrote:
> > 
> >  1) different order to reflect what I am used to seeing in other
> accounting programs
> > 
> >  2) I agree that comparative reports would be useful - other
> programs offer them as option, the program should too
> > 
> >  3) multiple accounts in a G/L report are standard elsewhere - the
> transaction report can do this, but the G/L detail report should.
> > 
> > 
> >  --
> >  Stephen C. Camidge scami...@fastmail.fm   (519)
> 363-3912
> > 
> >  On Mon, May 6, 2019, at 8:08 AM, Michael or Penny Novack wrote:
> > > On 5/6/2019 7:13 AM, Stephen Camidge wrote:
> > >> 1) I set up a new book on the Mac version of gnucash using "A
> Simple
> > >> Checkbook". The Chart of Accounts places Income below Expenses -
> why?
> > >> I added Top Level Accounts for Liabilities and it was put below
> > >> Income.  The Transaction Report shows Income below Expenses.  How
> do I
> > >> change the order?
> > > Collating sequence ( L > I)   Just curious, but why do you
> want a
> > > different order?
> > >
> > >> 2) Income Statement show the selected period in the right order
> but
> > >> cannot show columns by month. Same with Profit and Loss.
> Transaction
> > >> report can, but in the wrong order (see 1).
> > > You are asking for a series of "Income Statement" reports for
> > > consecutive periods displayed side by side (each P&L aka Statement
> of
> > > Revenues and Expenses < what called depends on entity, same report
> >. In
> > > other words, EACH has a defined start and end date since this
> report is
> > > for an interval.
> > >
> > > To produce such a (finished) report, use an 

Re: [GNC] Questions

[David T. via gnucash-user]

2 - You misunderstand me. I am not speaking about using the Transaction Report 
with subtotals. I am speaking about using multiple instances of the Income 
report you desire, each set for the period you want. Go to Reports->Sample & 
Custom Reports->Custom Multicolumn Report and set it up with (for example) two 
columns, with an Income report for the previous quarter in the first column, 
and an Income Report for the current quarter in the second column.

3 - There is something fishy with the General Ledger report. It doesn’t seem to 
recognize certain accounts, and there doesn’t seem rhyme or reason to the 
accounts it includes or omits. This is true in both 3.4 and 3.5. It doesn’t 
seem to be the currency of the accounts (that is, I can see some but not all 
accounts denominated in different currencies). It doesn’t seem to be the depth 
of the accounts selected (I can see some but not all accounts at numerous 
different levels of the hierarchy). I will note that it will not display a 
selected account if there are no transactions in the period selected. However, 
that doesn’t explain everything that’s going on here…

David


> On May 6, 2019, at 7:05 PM, Stephen C. Camidge  wrote:
> 
> 2) Yes, I can get multi column reports with the Transaction Report, show 
> totals monthly by account, but it will not display monthly totals and it will 
> not display Revenue separately from Expenses with totals for Revenue and for 
> Expenses.
> 
> 3) I did make the multiple selection. Thank you for confirming that something 
> is indeed going on.
> 
> 
> -- 
> Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912
> 
> On Mon, May 6, 2019, at 9:17 AM, David T. wrote:
>> 3 - I spoke too soon. There is something weird going on there. I can 
>> select multiple accounts, and some will display, while others do not. 
>> Not sure what is going on there.
>> 
>>> On May 6, 2019, at 6:38 PM, David T. via gnucash-user 
>>>  wrote:
>>> 
>>> 2 - Multicolumn reports are already part of GnuCash.
>>> 3 - I just loaded 3.5, ran the G/L report, selected a random set of 
>>> disjoint accounts, and received sane results. Is it possible that when you 
>>> attempted to select multiple accounts, you actually selected only the last 
>>> account you clicked? Many’s the time that I have thought I had the Command 
>>> key held down, only to discover that I’d succeeded in picking only that 
>>> last account…
>>> 
>>> 
>>> David
>>> 
 On May 6, 2019, at 6:15 PM, Stephen C. Camidge  
 wrote:
 
 1) OK
 
 2) yes - this would be most useful
 
 3) General Ledger - I can select multiple accounts, but for me (Mac, 3.5) 
 only the first selected account appears in the General Ledger Report.
 
 -- 
 Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912
 
 On Mon, May 6, 2019, at 8:41 AM, David T. wrote:
> 1 - As I mentioned, account codes will work for this. Assign each 
> account a numeric code, add the code column to the COA, and sort on it. 
> Done.
> 2 - Multicolumn reports.
> 3 - Are you talking about the “General Ledger” report, or the “General 
> Journal” report? My version of the former report (GC 3.4 under MacOX) 
> behaves exactly like the generic “Transaction Report” you mention 
> (indeed, I suspect that under the hood, that’s what it is). IOW, I am 
> able to select accounts for inclusion on the report. Can you explain 
> more specifically what you are doing and seeing, and what you expect to 
> find that you are not?
> 
> David
> 
>> On May 6, 2019, at 5:56 PM, Stephen C. Camidge  
>> wrote:
>> 
>> 1) different order to reflect what I am used to seeing in other 
>> accounting programs
>> 
>> 2) I agree that comparative reports would be useful - other programs 
>> offer them as option, the program should too
>> 
>> 3) multiple accounts in a G/L report are standard elsewhere - the 
>> transaction report can do this, but the G/L detail report should.
>> 
>> 
>> -- 
>> Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912
>> 
>> On Mon, May 6, 2019, at 8:08 AM, Michael or Penny Novack wrote:
>>> On 5/6/2019 7:13 AM, Stephen Camidge wrote:
 1) I set up a new book on the Mac version of gnucash using "A Simple 
 Checkbook". The Chart of Accounts places Income below Expenses - why? 
 I added Top Level Accounts for Liabilities and it was put below 
 Income.  The Transaction Report shows Income below Expenses.  How do I 
 change the order?
>>> Collating sequence ( L > I)   Just curious, but why do you want a 
>>> different order?
>>> 
 2) Income Statement show the selected period in the right order but 
 cannot show columns by month. Same with Profit and Loss. Transaction 
 report can, but in the wrong order (see 1).
>>> You are asking for a seri

Re: [GNC] Questions

[Stephen C. Camidge]

2) Yes, I can get multi column reports with the Transaction Report, show totals 
monthly by account, but it will not display monthly totals and it will not 
display Revenue separately from Expenses with totals for Revenue and for 
Expenses.

3) I did make the multiple selection. Thank you for confirming that something 
is indeed going on.


-- 
Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912

On Mon, May 6, 2019, at 9:17 AM, David T. wrote:
> 3 - I spoke too soon. There is something weird going on there. I can 
> select multiple accounts, and some will display, while others do not. 
> Not sure what is going on there.
> 
> > On May 6, 2019, at 6:38 PM, David T. via gnucash-user 
> >  wrote:
> > 
> > 2 - Multicolumn reports are already part of GnuCash.
> > 3 - I just loaded 3.5, ran the G/L report, selected a random set of 
> > disjoint accounts, and received sane results. Is it possible that when you 
> > attempted to select multiple accounts, you actually selected only the last 
> > account you clicked? Many’s the time that I have thought I had the Command 
> > key held down, only to discover that I’d succeeded in picking only that 
> > last account…
> > 
> > 
> > David
> > 
> >> On May 6, 2019, at 6:15 PM, Stephen C. Camidge  
> >> wrote:
> >> 
> >> 1) OK
> >> 
> >> 2) yes - this would be most useful
> >> 
> >> 3) General Ledger - I can select multiple accounts, but for me (Mac, 3.5) 
> >> only the first selected account appears in the General Ledger Report.
> >> 
> >> -- 
> >> Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912
> >> 
> >> On Mon, May 6, 2019, at 8:41 AM, David T. wrote:
> >>> 1 - As I mentioned, account codes will work for this. Assign each 
> >>> account a numeric code, add the code column to the COA, and sort on it. 
> >>> Done.
> >>> 2 - Multicolumn reports.
> >>> 3 - Are you talking about the “General Ledger” report, or the “General 
> >>> Journal” report? My version of the former report (GC 3.4 under MacOX) 
> >>> behaves exactly like the generic “Transaction Report” you mention 
> >>> (indeed, I suspect that under the hood, that’s what it is). IOW, I am 
> >>> able to select accounts for inclusion on the report. Can you explain 
> >>> more specifically what you are doing and seeing, and what you expect to 
> >>> find that you are not?
> >>> 
> >>> David
> >>> 
>  On May 6, 2019, at 5:56 PM, Stephen C. Camidge  
>  wrote:
>  
>  1) different order to reflect what I am used to seeing in other 
>  accounting programs
>  
>  2) I agree that comparative reports would be useful - other programs 
>  offer them as option, the program should too
>  
>  3) multiple accounts in a G/L report are standard elsewhere - the 
>  transaction report can do this, but the G/L detail report should.
>  
>  
>  -- 
>  Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912
>  
>  On Mon, May 6, 2019, at 8:08 AM, Michael or Penny Novack wrote:
> > On 5/6/2019 7:13 AM, Stephen Camidge wrote:
> >> 1) I set up a new book on the Mac version of gnucash using "A Simple 
> >> Checkbook". The Chart of Accounts places Income below Expenses - why? 
> >> I added Top Level Accounts for Liabilities and it was put below 
> >> Income.  The Transaction Report shows Income below Expenses.  How do I 
> >> change the order?
> > Collating sequence ( L > I)   Just curious, but why do you want a 
> > different order?
> > 
> >> 2) Income Statement show the selected period in the right order but 
> >> cannot show columns by month. Same with Profit and Loss. Transaction 
> >> report can, but in the wrong order (see 1).
> > You are asking for a series of "Income Statement" reports for 
> > consecutive periods displayed side by side (each P&L aka Statement of 
> > Revenues and Expenses < what called depends on entity, same report >. 
> > In 
> > other words, EACH has a defined start and end date since this report is 
> > for an interval.
> > 
> > To produce such a (finished) report, use an editor capable of 
> > supporting 
> > columns and export each, then bring into its proper column. WHY not 
> > "within" gnucash? Stop a moment and think. Think of all the possible 
> > variations that would be wanted (how many to show in parallel, somebody 
> > else might want quarters or years, not months). Think about the after 
> > editing required (the CoA might have had changes, not exactly the same 
> > in each interval).
> > 
> > BTW -- since I keep books for non-profits, usually doing two years in 
> > parallel
> > 
> >> 
> >> 3) G/L report shows one account only, no matter how many I select. 
> >> Transaction Report can select all.
> > Why would you expect different reports to be the same in this regard?
> > 
> > Michael D Novack
> > 
> > _

Re: [GNC] Questions

[Stephen C. Camidge]

I am an accountant and am quite familiar with this information. I just expected 
to be able to select all transactions for a period in a number of accounts with 
the General Ledger report.

-- 
Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912

On Mon, May 6, 2019, at 9:18 AM, Michael or Penny Novack wrote:
> On 5/6/2019 8:22 AM, Stephen C. Camidge wrote:
> 
> >
> > 3 - G/L is General Ledger
> >
> 
> Ah. being misled by the name of the report.
> 
> This is a situation where useful to understand how traditional pen and 
> ink on paper bookkeeping worked. You FIRST entered transactions in 
> chronological order into a "book" called the Journal. These entries were 
> then "posted" to the Ledger (to the ledger accounts affected).
> 
> Gnucash allows us to enter the transactions beginning in any of the 
> affected ledger accounts. We don't even see something resembling a 
> journal entry unless entering a "split transaction". In other words, the 
> journal is virtual.
> 
> But gnucash CAN show you the journal if you ask it to. As a report. Your 
> problem is with your expectation of what you are looking at when you ask 
> gnucash to give you a G/L or General Journal report.
> 
> 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.

Re: [GNC] Questions

[David T. via gnucash-user]

3 - I spoke too soon. There is something weird going on there. I can select 
multiple accounts, and some will display, while others do not. Not sure what is 
going on there.

> On May 6, 2019, at 6:38 PM, David T. via gnucash-user 
>  wrote:
> 
> 2 - Multicolumn reports are already part of GnuCash.
> 3 - I just loaded 3.5, ran the G/L report, selected a random set of disjoint 
> accounts, and received sane results. Is it possible that when you attempted 
> to select multiple accounts, you actually selected only the last account you 
> clicked? Many’s the time that I have thought I had the Command key held down, 
> only to discover that I’d succeeded in picking only that last account…
> 
> 
> David
> 
>> On May 6, 2019, at 6:15 PM, Stephen C. Camidge  wrote:
>> 
>> 1) OK
>> 
>> 2) yes - this would be most useful
>> 
>> 3) General Ledger - I can select multiple accounts, but for me (Mac, 3.5) 
>> only the first selected account appears in the General Ledger Report.
>> 
>> -- 
>> Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912
>> 
>> On Mon, May 6, 2019, at 8:41 AM, David T. wrote:
>>> 1 - As I mentioned, account codes will work for this. Assign each 
>>> account a numeric code, add the code column to the COA, and sort on it. 
>>> Done.
>>> 2 - Multicolumn reports.
>>> 3 - Are you talking about the “General Ledger” report, or the “General 
>>> Journal” report? My version of the former report (GC 3.4 under MacOX) 
>>> behaves exactly like the generic “Transaction Report” you mention 
>>> (indeed, I suspect that under the hood, that’s what it is). IOW, I am 
>>> able to select accounts for inclusion on the report. Can you explain 
>>> more specifically what you are doing and seeing, and what you expect to 
>>> find that you are not?
>>> 
>>> David
>>> 
 On May 6, 2019, at 5:56 PM, Stephen C. Camidge  
 wrote:
 
 1) different order to reflect what I am used to seeing in other accounting 
 programs
 
 2) I agree that comparative reports would be useful - other programs offer 
 them as option, the program should too
 
 3) multiple accounts in a G/L report are standard elsewhere - the 
 transaction report can do this, but the G/L detail report should.
 
 
 -- 
 Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912
 
 On Mon, May 6, 2019, at 8:08 AM, Michael or Penny Novack wrote:
> On 5/6/2019 7:13 AM, Stephen Camidge wrote:
>> 1) I set up a new book on the Mac version of gnucash using "A Simple 
>> Checkbook". The Chart of Accounts places Income below Expenses - why? 
>> I added Top Level Accounts for Liabilities and it was put below 
>> Income.  The Transaction Report shows Income below Expenses.  How do I 
>> change the order?
> Collating sequence ( L > I)   Just curious, but why do you want a 
> different order?
> 
>> 2) Income Statement show the selected period in the right order but 
>> cannot show columns by month. Same with Profit and Loss. Transaction 
>> report can, but in the wrong order (see 1).
> You are asking for a series of "Income Statement" reports for 
> consecutive periods displayed side by side (each P&L aka Statement of 
> Revenues and Expenses < what called depends on entity, same report >. In 
> other words, EACH has a defined start and end date since this report is 
> for an interval.
> 
> To produce such a (finished) report, use an editor capable of supporting 
> columns and export each, then bring into its proper column. WHY not 
> "within" gnucash? Stop a moment and think. Think of all the possible 
> variations that would be wanted (how many to show in parallel, somebody 
> else might want quarters or years, not months). Think about the after 
> editing required (the CoA might have had changes, not exactly the same 
> in each interval).
> 
> BTW -- since I keep books for non-profits, usually doing two years in 
> parallel
> 
>> 
>> 3) G/L report shows one account only, no matter how many I select. 
>> Transaction Report can select all.
> Why would you expect different reports to be the same in this regard?
> 
> 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/

Re: [GNC] Questions

[Michael or Penny Novack]

On 5/6/2019 8:22 AM, Stephen C. Camidge wrote:



3 - G/L is General Ledger



Ah. being misled by the name of the report.

This is a situation where useful to understand how traditional pen and 
ink on paper bookkeeping worked. You FIRST entered transactions in 
chronological order into a "book" called the Journal. These entries were 
then "posted" to the Ledger (to the ledger accounts affected).


Gnucash allows us to enter the transactions beginning in any of the 
affected ledger accounts. We don't even see something resembling a 
journal entry unless entering a "split transaction". In other words, the 
journal is virtual.


But gnucash CAN show you the journal if you ask it to. As a report. Your 
problem is with your expectation of what you are looking at when you ask 
gnucash to give you a G/L or General Journal report.


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.

Re: [GNC] Questions

[David T. via gnucash-user]

2 - Multicolumn reports are already part of GnuCash.
3 - I just loaded 3.5, ran the G/L report, selected a random set of disjoint 
accounts, and received sane results. Is it possible that when you attempted to 
select multiple accounts, you actually selected only the last account you 
clicked? Many’s the time that I have thought I had the Command key held down, 
only to discover that I’d succeeded in picking only that last account…


David

> On May 6, 2019, at 6:15 PM, Stephen C. Camidge  wrote:
> 
> 1) OK
> 
> 2) yes - this would be most useful
> 
> 3) General Ledger - I can select multiple accounts, but for me (Mac, 3.5) 
> only the first selected account appears in the General Ledger Report.
> 
> -- 
> Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912
> 
> On Mon, May 6, 2019, at 8:41 AM, David T. wrote:
>> 1 - As I mentioned, account codes will work for this. Assign each 
>> account a numeric code, add the code column to the COA, and sort on it. 
>> Done.
>> 2 - Multicolumn reports.
>> 3 - Are you talking about the “General Ledger” report, or the “General 
>> Journal” report? My version of the former report (GC 3.4 under MacOX) 
>> behaves exactly like the generic “Transaction Report” you mention 
>> (indeed, I suspect that under the hood, that’s what it is). IOW, I am 
>> able to select accounts for inclusion on the report. Can you explain 
>> more specifically what you are doing and seeing, and what you expect to 
>> find that you are not?
>> 
>> David
>> 
>>> On May 6, 2019, at 5:56 PM, Stephen C. Camidge  wrote:
>>> 
>>> 1) different order to reflect what I am used to seeing in other accounting 
>>> programs
>>> 
>>> 2) I agree that comparative reports would be useful - other programs offer 
>>> them as option, the program should too
>>> 
>>> 3) multiple accounts in a G/L report are standard elsewhere - the 
>>> transaction report can do this, but the G/L detail report should.
>>> 
>>> 
>>> -- 
>>> Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912
>>> 
>>> On Mon, May 6, 2019, at 8:08 AM, Michael or Penny Novack wrote:
 On 5/6/2019 7:13 AM, Stephen Camidge wrote:
> 1) I set up a new book on the Mac version of gnucash using "A Simple 
> Checkbook". The Chart of Accounts places Income below Expenses - why? 
> I added Top Level Accounts for Liabilities and it was put below 
> Income.  The Transaction Report shows Income below Expenses.  How do I 
> change the order?
 Collating sequence ( L > I)   Just curious, but why do you want a 
 different order?
 
> 2) Income Statement show the selected period in the right order but 
> cannot show columns by month. Same with Profit and Loss. Transaction 
> report can, but in the wrong order (see 1).
 You are asking for a series of "Income Statement" reports for 
 consecutive periods displayed side by side (each P&L aka Statement of 
 Revenues and Expenses < what called depends on entity, same report >. In 
 other words, EACH has a defined start and end date since this report is 
 for an interval.
 
 To produce such a (finished) report, use an editor capable of supporting 
 columns and export each, then bring into its proper column. WHY not 
 "within" gnucash? Stop a moment and think. Think of all the possible 
 variations that would be wanted (how many to show in parallel, somebody 
 else might want quarters or years, not months). Think about the after 
 editing required (the CoA might have had changes, not exactly the same 
 in each interval).
 
 BTW -- since I keep books for non-profits, usually doing two years in 
 parallel
 
> 
> 3) G/L report shows one account only, no matter how many I select. 
> Transaction Report can select all.
 Why would you expect different reports to be the same in this regard?
 
 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.
>> 
>> 

___
gnucash-user mailing list
gnucash-user@gnuc

[GNC] Rate column appeared after Balance

[Colin Law]

Using 3.5 on Ubuntu , on just one of my Bank accounts a Rate column
has appeared to the right of the Balance column.  I can push it off to
the right but it has a habit or re-appearing.  I am not aware of
having done anything to make it happen.  I imagine it is to do with
exchange rates, but I only use GBP and have checked that the account
is still set to that currency.

I have looked through the preferences, looked in the manual and
Googled to no avail.

Any suggestions on why it might have appeared and how to get rid of it?

Colin
___
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] Questions

[Stephen C. Camidge]

1) OK

2) yes - this would be most useful

3) General Ledger - I can select multiple accounts, but for me (Mac, 3.5) only 
the first selected account appears in the General Ledger Report.

-- 
Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912

On Mon, May 6, 2019, at 8:41 AM, David T. wrote:
> 1 - As I mentioned, account codes will work for this. Assign each 
> account a numeric code, add the code column to the COA, and sort on it. 
> Done.
> 2 - Multicolumn reports.
> 3 - Are you talking about the “General Ledger” report, or the “General 
> Journal” report? My version of the former report (GC 3.4 under MacOX) 
> behaves exactly like the generic “Transaction Report” you mention 
> (indeed, I suspect that under the hood, that’s what it is). IOW, I am 
> able to select accounts for inclusion on the report. Can you explain 
> more specifically what you are doing and seeing, and what you expect to 
> find that you are not?
> 
> David
> 
> > On May 6, 2019, at 5:56 PM, Stephen C. Camidge  wrote:
> > 
> > 1) different order to reflect what I am used to seeing in other accounting 
> > programs
> > 
> > 2) I agree that comparative reports would be useful - other programs offer 
> > them as option, the program should too
> > 
> > 3) multiple accounts in a G/L report are standard elsewhere - the 
> > transaction report can do this, but the G/L detail report should.
> > 
> > 
> > -- 
> > Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912
> > 
> > On Mon, May 6, 2019, at 8:08 AM, Michael or Penny Novack wrote:
> >> On 5/6/2019 7:13 AM, Stephen Camidge wrote:
> >>> 1) I set up a new book on the Mac version of gnucash using "A Simple 
> >>> Checkbook". The Chart of Accounts places Income below Expenses - why? 
> >>> I added Top Level Accounts for Liabilities and it was put below 
> >>> Income.  The Transaction Report shows Income below Expenses.  How do I 
> >>> change the order?
> >> Collating sequence ( L > I)   Just curious, but why do you want a 
> >> different order?
> >> 
> >>> 2) Income Statement show the selected period in the right order but 
> >>> cannot show columns by month. Same with Profit and Loss. Transaction 
> >>> report can, but in the wrong order (see 1).
> >> You are asking for a series of "Income Statement" reports for 
> >> consecutive periods displayed side by side (each P&L aka Statement of 
> >> Revenues and Expenses < what called depends on entity, same report >. In 
> >> other words, EACH has a defined start and end date since this report is 
> >> for an interval.
> >> 
> >> To produce such a (finished) report, use an editor capable of supporting 
> >> columns and export each, then bring into its proper column. WHY not 
> >> "within" gnucash? Stop a moment and think. Think of all the possible 
> >> variations that would be wanted (how many to show in parallel, somebody 
> >> else might want quarters or years, not months). Think about the after 
> >> editing required (the CoA might have had changes, not exactly the same 
> >> in each interval).
> >> 
> >> BTW -- since I keep books for non-profits, usually doing two years in 
> >> parallel
> >> 
> >>> 
> >>> 3) G/L report shows one account only, no matter how many I select. 
> >>> Transaction Report can select all.
> >> Why would you expect different reports to be the same in this regard?
> >> 
> >> 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.
> 
>
___
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] Questions

[David T. via gnucash-user]

1 - As I mentioned, account codes will work for this. Assign each account a 
numeric code, add the code column to the COA, and sort on it. Done.
2 - Multicolumn reports.
3 - Are you talking about the “General Ledger” report, or the “General Journal” 
report? My version of the former report (GC 3.4 under MacOX) behaves exactly 
like the generic “Transaction Report” you mention (indeed, I suspect that under 
the hood, that’s what it is). IOW, I am able to select accounts for inclusion 
on the report. Can you explain more specifically what you are doing and seeing, 
and what you expect to find that you are not?

David

> On May 6, 2019, at 5:56 PM, Stephen C. Camidge  wrote:
> 
> 1) different order to reflect what I am used to seeing in other accounting 
> programs
> 
> 2) I agree that comparative reports would be useful - other programs offer 
> them as option, the program should too
> 
> 3) multiple accounts in a G/L report are standard elsewhere - the transaction 
> report can do this, but the G/L detail report should.
> 
> 
> -- 
> Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912
> 
> On Mon, May 6, 2019, at 8:08 AM, Michael or Penny Novack wrote:
>> On 5/6/2019 7:13 AM, Stephen Camidge wrote:
>>> 1) I set up a new book on the Mac version of gnucash using "A Simple 
>>> Checkbook". The Chart of Accounts places Income below Expenses - why? 
>>> I added Top Level Accounts for Liabilities and it was put below 
>>> Income.  The Transaction Report shows Income below Expenses.  How do I 
>>> change the order?
>> Collating sequence ( L > I)   Just curious, but why do you want a 
>> different order?
>> 
>>> 2) Income Statement show the selected period in the right order but 
>>> cannot show columns by month. Same with Profit and Loss. Transaction 
>>> report can, but in the wrong order (see 1).
>> You are asking for a series of "Income Statement" reports for 
>> consecutive periods displayed side by side (each P&L aka Statement of 
>> Revenues and Expenses < what called depends on entity, same report >. In 
>> other words, EACH has a defined start and end date since this report is 
>> for an interval.
>> 
>> To produce such a (finished) report, use an editor capable of supporting 
>> columns and export each, then bring into its proper column. WHY not 
>> "within" gnucash? Stop a moment and think. Think of all the possible 
>> variations that would be wanted (how many to show in parallel, somebody 
>> else might want quarters or years, not months). Think about the after 
>> editing required (the CoA might have had changes, not exactly the same 
>> in each interval).
>> 
>> BTW -- since I keep books for non-profits, usually doing two years in 
>> parallel
>> 
>>> 
>>> 3) G/L report shows one account only, no matter how many I select. 
>>> Transaction Report can select all.
>> Why would you expect different reports to be the same in this regard?
>> 
>> 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.

___
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] Questions

[Stephen C. Camidge]

1) different order to reflect what I am used to seeing in other accounting 
programs

2) I agree that comparative reports would be useful - other programs offer them 
as option, the program should too

3) multiple accounts in a G/L report are standard elsewhere - the transaction 
report can do this, but the G/L detail report should.


-- 
Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912

On Mon, May 6, 2019, at 8:08 AM, Michael or Penny Novack wrote:
> On 5/6/2019 7:13 AM, Stephen Camidge wrote:
> > 1) I set up a new book on the Mac version of gnucash using "A Simple 
> > Checkbook". The Chart of Accounts places Income below Expenses - why? 
> > I added Top Level Accounts for Liabilities and it was put below 
> > Income.  The Transaction Report shows Income below Expenses.  How do I 
> > change the order?
> Collating sequence ( L > I)   Just curious, but why do you want a 
> different order?
> 
> > 2) Income Statement show the selected period in the right order but 
> > cannot show columns by month. Same with Profit and Loss. Transaction 
> > report can, but in the wrong order (see 1).
> You are asking for a series of "Income Statement" reports for 
> consecutive periods displayed side by side (each P&L aka Statement of 
> Revenues and Expenses < what called depends on entity, same report >. In 
> other words, EACH has a defined start and end date since this report is 
> for an interval.
> 
> To produce such a (finished) report, use an editor capable of supporting 
> columns and export each, then bring into its proper column. WHY not 
> "within" gnucash? Stop a moment and think. Think of all the possible 
> variations that would be wanted (how many to show in parallel, somebody 
> else might want quarters or years, not months). Think about the after 
> editing required (the CoA might have had changes, not exactly the same 
> in each interval).
> 
> BTW -- since I keep books for non-profits, usually doing two years in 
> parallel
> 
> >
> > 3) G/L report shows one account only, no matter how many I select. 
> > Transaction Report can select all.
> Why would you expect different reports to be the same in this regard?
> 
> 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.

Re: [GNC] Questions

[Stephen C. Camidge]

2 - The Transaction Report is a workaround, but does not give a subtotal for 
income and a subtotal for expenses.

3 - G/L is General Ledger


--
Stephen C. Camidge scami...@fastmail.fm (519) 363-3912




On Mon, May 6, 2019, at 7:47 AM, David T. wrote:
> 1 - it's alphabetical. You could rename the accounts with numeric prefixes or 
> use account codes and story on them. 
> 
> 2 - the income statement isn't set up to accommodate those breakdowns. You 
> might try creating a multi column report with income statements for different 
> time periods.
> 
> 3 - don't even know what "G/L" stands for here, so can't help. 
> 
> David
> 
> 
> 
>> On Mon, May 6, 2019 at 16:44, Stephen Camidge
>>  wrote:
>> 1) I set up a new book on the Mac version of gnucash using "A Simple 
>> Checkbook". The Chart of Accounts places Income below Expenses - why? I 
>> added Top Level Accounts for Liabilities and it was put below Income. 
>> The Transaction Report shows Income below Expenses. How do I change the 
>> order?
>> 
>> 2) Income Statement show the selected period in the right order but 
>> cannot show columns by month. Same with Profit and Loss. Transaction 
>> report can, but in the wrong order (see 1).
>> 
>> 3) G/L report shows one account only, no matter how many I select. 
>> Transaction Report can select all.
>> 
>> What am I missing?
>> 
>> Thank you.
>> 
>> 
>> 
>> 
>> 
>> ___
>> 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] Questions

[Michael or Penny Novack]

On 5/6/2019 7:13 AM, Stephen Camidge wrote:
1) I set up a new book on the Mac version of gnucash using "A Simple 
Checkbook". The Chart of Accounts places Income below Expenses - why? 
I added Top Level Accounts for Liabilities and it was put below 
Income.  The Transaction Report shows Income below Expenses.  How do I 
change the order?
Collating sequence ( L > I)   Just curious, but why do you want a 
different order?


2) Income Statement show the selected period in the right order but 
cannot show columns by month. Same with Profit and Loss. Transaction 
report can, but in the wrong order (see 1).
You are asking for a series of "Income Statement" reports for 
consecutive periods displayed side by side (each P&L aka Statement of 
Revenues and Expenses < what called depends on entity, same report >. In 
other words, EACH has a defined start and end date since this report is 
for an interval.


To produce such a (finished) report, use an editor capable of supporting 
columns and export each, then bring into its proper column. WHY not 
"within" gnucash? Stop a moment and think. Think of all the possible 
variations that would be wanted (how many to show in parallel, somebody 
else might want quarters or years, not months). Think about the after 
editing required (the CoA might have had changes, not exactly the same 
in each interval).


BTW -- since I keep books for non-profits, usually doing two years in 
parallel




3) G/L report shows one account only, no matter how many I select. 
Transaction Report can select all.

Why would you expect different reports to be the same in this regard?

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.

Re: [GNC] Questions

[David T. via gnucash-user]

1 - it's alphabetical. You could rename the accounts with numeric prefixes or 
use account codes and story on them. 
2 - the income statement isn't set up to accommodate those breakdowns. You 
might try creating a multi column report with income statements for different 
time periods.
3 - don't even know what "G/L" stands for here, so can't help. 
David

 
 
  On Mon, May 6, 2019 at 16:44, Stephen Camidge wrote:   
1) I set up a new book on the Mac version of gnucash using "A Simple 
Checkbook". The Chart of Accounts places Income below Expenses - why? I 
added Top Level Accounts for Liabilities and it was put below Income.  
The Transaction Report shows Income below Expenses.  How do I change the 
order?

2) Income Statement show the selected period in the right order but 
cannot show columns by month. Same with Profit and Loss. Transaction 
report can, but in the wrong order (see 1).

3) G/L report shows one account only, no matter how many I select. 
Transaction Report can select all.

What am I missing?

Thank you.





___
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.

[GNC] Questions

[Stephen Camidge]

1) I set up a new book on the Mac version of gnucash using "A Simple 
Checkbook". The Chart of Accounts places Income below Expenses - why? I 
added Top Level Accounts for Liabilities and it was put below Income.  
The Transaction Report shows Income below Expenses.  How do I change the 
order?


2) Income Statement show the selected period in the right order but 
cannot show columns by month. Same with Profit and Loss. Transaction 
report can, but in the wrong order (see 1).


3) G/L report shows one account only, no matter how many I select. 
Transaction Report can select all.


What am I missing?

Thank you.





___
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] A really basic question ...

[Sachin Danave]

Hi Geoff,

The tabs are auto opened when you double click an Account for data entry.

So if you are entering a Deposit, navigate to the Deposit account in your
COA and double click. It will open in a new tab.

Hope this helps

Sachin

On Mon, May 6, 2019 at 2:47 PM gp  wrote:

> I only use Gnucash occasionally for a limited number of tasks, hence this
> very basic question.
>
> I accidentally closed the tab where I enter deposits, withdrawals, etc and
> can't work out how to open it again. (All that's showing in Gnucash is the
> Accounts tab.)
>
> What's that secret?
>
>
>
> --
> 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.
>
___
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] gtk-3.0 is empty

[Sachin Danave]

Hi Geert

Thanks a lot. I was wondering if something was wrong with my installation !!

This brings me to my earlier question. Is there a way by which you can set
a background colour to the Accounts screen ?

I dont mean the Account colour, that can be set. But can the whole Accounts
screen have - say a Blue background ?

Not a must requirement but will improve the visibility ...

Thanks and Regards

Sachin

On Mon, May 6, 2019 at 1:48 PM Geert Janssens 
wrote:

> Hi Sachin,
>
> I believe this file is not created by default. If you like to use it for
> style
> modifications you can create it yourself. It's an ordinary plain text file.
>
> Regards,
>
> Geert
>
> Op maandag 6 mei 2019 05:10:47 CEST schreef Sachin Danave:
> > Dear All,
> >
> > I have installed Gnucash on Windows 10 and it is working smoothly.
> >
> > Based on the feedback in this group, I wanted to check my settings.ini
> > file. Surprisingly, when I navigated to :
> >
> > C:\Users\user-name\AppData\Local\gtk-3.0
> >
> > the directory is empty.
> >
> > The roaming profile has Gnucash directory and has *.gcm files.
> >
> > Any clues on this ? As a result, I am not able to customize the screens
> to
> > suite my color preferences.
> >
> > Thanks and regards
> >
> > Sachin
> > ___
> > 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] A really basic question ...

[Liz]

On Mon, 6 May 2019 04:06:36 -0500 (CDT)
gp  wrote:

> I only use Gnucash occasionally for a limited number of tasks, hence
> this very basic question.
> 
> I accidentally closed the tab where I enter deposits, withdrawals,
> etc and can't work out how to open it again. (All that's showing in
> Gnucash is the Accounts tab.) 
> 
> What's that secret?
> 
> 

>From the accounts tab either double click on your bank account
or right click and choose open.

Liz
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
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] A really basic question ...

[gp]

I only use Gnucash occasionally for a limited number of tasks, hence this
very basic question.

I accidentally closed the tab where I enter deposits, withdrawals, etc and
can't work out how to open it again. (All that's showing in Gnucash is the
Accounts tab.) 

What's that secret?



--
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.

Re: [GNC] gtk-3.0 is empty

[Geert Janssens]

Hi Sachin,

I believe this file is not created by default. If you like to use it for style 
modifications you can create it yourself. It's an ordinary plain text file.

Regards,

Geert

Op maandag 6 mei 2019 05:10:47 CEST schreef Sachin Danave:
> Dear All,
> 
> I have installed Gnucash on Windows 10 and it is working smoothly.
> 
> Based on the feedback in this group, I wanted to check my settings.ini
> file. Surprisingly, when I navigated to :
> 
> C:\Users\user-name\AppData\Local\gtk-3.0
> 
> the directory is empty.
> 
> The roaming profile has Gnucash directory and has *.gcm files.
> 
> Any clues on this ? As a result, I am not able to customize the screens to
> suite my color preferences.
> 
> Thanks and regards
> 
> Sachin
> ___
> 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.