[GNC] Total and Grand Total at the end of a Transaction Report

[Peter S. Shenkin]

Thank you, Adrian.

The reason I created the Transaction report was simply to obtain a printed
record of the transactions from that month to keep on file in order to
examine them offline and/or send them to others within my organization.

I now realize that the reason I did not get a  total of zero is that I did
not have all accounts selected. It was your response that led me to check.
By the way, I did have "One transaction per line" selected.

When looking for  imbalances, I do start with the Imbalance total in the
balance sheet. If it  is not zero, I assume everything balances.

Thanks,
-P.

On Wed, Oct 26, 2022 at 12:18 AM Adrien Monteleone <
adrien.monteleone at lusfiber.net> wrote:

> The Subtotal in this case is for one month. It represents the net
> (credit in this case) balance *for the chosen accounts* over that
> period. (you could have set subtotal by account first instead of date
> first)
>
> The Grand Total is the net debit/credit over the entire report range -
> *for those account*.
>
> The other splits are not part of these calculations.
>
> In Options > Display > Detail level, try 'One Transaction Per Line'
> instead of 'One Split Per Line' and you'll see this more clearly.
>
> I would not expect to see a zero balance in these spots unless I had
> exactly the same amount of debit as credit, which is pretty odd in any
> one single account, but could happen if you intentionally chose two or
> more accounts that are always on opposite sides of a transaction. Such a
> report wouldn't tell you much however, except documenting that the
> transaction exists.
>
> If you did this intentionally to see if all transactions balanced
> between a set of accounts and didn't get a zero balance, that just means
> at least one transaction involves one or more accounts you did not include.
>
> The Transaction Report can be used for lots of things. The first
> question I'd have for you is, "What question are you trying to answer by
> running it?" This should guide your choice of options.
>
> Regards,
> Adrien
>
> On 10/25/22 10:22 PM, Peter S. Shenkin wrote:
> > Hi,
> >
> > What do the Total and Grand Total at the end of a Transaction Report
> > signify?
> >
> > Please see the attachment, which shows the last few lines of a
> Transaction
> > Report. For most reports I generate, the values shown are zero, but here
> > both the Total and Grand Total are shown as $20.83
> >
> > I thought at first that this might imply a mismatch between debits and
> > credits, but if that were correct I guess I would see a non-zero balance
> in
> > the Imbalance account. However, the Balance Sheet for the end of the
> month
> > that this Transaction Report includes shows a zero balance in this
> account.
> >
> > The same is true if I look at the Imbalance account in the Register. That
> > is, it has a zero balance.
>
> _______________________________________________
> 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
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>