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 <christopher....@gmail.com> 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 <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. >> > _______________________________________________ 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.