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 <scami...@fastmail.fm> 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 <scami...@fastmail.fm> > >>>> 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 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. > >> > >> > > _______________________________________________ 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.
