[GNC] Questions

Mon May 6 10:33:57 EDT 2019

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.lck at 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 <scamidge at 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             scamidge at 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 at 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 <scamidge at 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             scamidge at 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 <
>> scamidge at 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             scamidge at 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 at 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 at 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 at 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 at 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.
>>
>