[GNC] gnucash-user Digest, Vol 218, Issue 35

Sun May 23 17:34:25 EDT 2021

To all who replied:

Thank you. Immediately after posting, I (of course) found what I was looking for. On the ‘accounts’ page, one of the selectable columns is “present”, which is actually current balance. My mistake was looking for the term ‘balance’. “Present” works very nicely. In the actual account page, the future transactions are separated from the current balance by a thick blue line, which also works perfectly for me.

Thanks for your help.

Get Outlook for Android<https://aka.ms/AAb9ysg>

________________________________
From: gnucash-user <gnucash-user-bounces+z.ionis=mendz.com at gnucash.org> on behalf of gnucash-user-request at gnucash.org <gnucash-user-request at gnucash.org>
Sent: Sunday, May 23, 2021 4:39:21 PM
To: gnucash-user at gnucash.org <gnucash-user at gnucash.org>
Subject: gnucash-user Digest, Vol 218, Issue 35

Send gnucash-user mailing list submissions to
        gnucash-user at gnucash.org

To subscribe or unsubscribe via the World Wide Web, visit
        https://lists.gnucash.org/mailman/listinfo/gnucash-user
or, via email, send a message with subject or body 'help' to
        gnucash-user-request at gnucash.org

You can reach the person managing the list at
        gnucash-user-owner at gnucash.org

When replying, please edit your Subject line so it is more specific
than "Re: Contents of gnucash-user digest..."

Today's Topics:

   1.  Bank & Credit Card account balance (Ze'ev Ionis)
   2. Re:  Bank & Credit Card account balance (David Carlson)
   3. Re:  Bank & Credit Card account balance (Eric Coates)
   4.  Trial Balance Error (dennis adams)

----------------------------------------------------------------------

Message: 1
Date: Sun, 23 May 2021 19:40:50 +0000
From: Ze'ev Ionis <z.ionis at mendz.com>
To: "gnucash-user at gnucash.org" <gnucash-user at gnucash.org>
Subject: [GNC] Bank & Credit Card account balance
Message-ID:
        <DM4PR03MB59660F2600995730D1DFB045EB279 at DM4PR03MB5966.namprd03.prod.outlook.com>

Content-Type: text/plain; charset="us-ascii"

Currently the bank and credit card balances reflect all the activity in the account.  But I enter many post-dated entries (future dated).  Is it possible to display Current balance - i.e. ignore future activity?

Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 10

------------------------------

Message: 2
Date: Sun, 23 May 2021 15:03:15 -0500
From: David Carlson <david.carlson.417 at gmail.com>
To: "Ze'ev Ionis" <z.ionis at mendz.com>
Cc: "gnucash-user at gnucash.org" <gnucash-user at gnucash.org>
Subject: Re: [GNC] Bank & Credit Card account balance
Message-ID:
        <CADYgSbnkLeRt5b2fCP-KNg+eLcocAoj+TxC12c3gcCRqFrV8eA at mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"

Where do you want to see the present balance?  If you have the account
register open you can see the present balance in the bottom left corner of
the register next to the future balance, cleared balance, reconciled
balance and projected minimum balances.  You can run various reports to get
many account balances on one page.
 If, for some reason you want to temporarily hide future transactions in a
single account you can click View > Filter by > and choose to hide dates
after today...

On Sun, May 23, 2021 at 2:41 PM Ze'ev Ionis <z.ionis at mendz.com> wrote:

> Currently the bank and credit card balances reflect all the activity in
> the account.  But I enter many post-dated entries (future dated).  Is it
> possible to display Current balance - i.e. ignore future activity?
>
> Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for
> Windows 10
>
> _______________________________________________
> 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.
>

--
David Carlson

------------------------------

Message: 3
Date: Sun, 23 May 2021 21:25:42 +0100
From: Eric Coates <TwistedWood at talktalk.net>
To: gnucash-user at gnucash.org
Subject: Re: [GNC] Bank & Credit Card account balance
Message-ID: <216808c7-7a04-ffe0-a7dd-1e78ef188c09 at talktalk.net>
Content-Type: text/plain; charset=utf-8; format=flowed

In addition to David Carlson's answer:
On the Accounts tab use the down arrow (at the right end end of the top
line to display Present(GBP) (in my case, your base currency will
appear) as well as the Total. (There are lots of other options as well.)
The former is today's balance, the latter takes into account all
transactions.
Eric
======================

On 23/05/2021 20:40, Ze'ev Ionis wrote:
> Currently the bank and credit card balances reflect all the activity in the account.  But I enter many post-dated entries (future dated).  Is it possible to display Current balance - i.e. ignore future activity?
>
> Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 10
>
> _______________________________________________
> 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.

------------------------------

Message: 4
Date: Sun, 23 May 2021 20:39:16 +0000
From: dennis adams <smada46 at hotmail.com>
To: Gnucash User <gnucash-user at gnucash.org>
Subject: [GNC] Trial Balance Error
Message-ID:
        <CH2PR13MB4489B05114115EC1E07EAD73B7279 at CH2PR13MB4489.namprd13.prod.outlook.com>

Content-Type: text/plain; charset="us-ascii"

I recently ran a Trial Balance report for the first time.  Debits and credits different by tens of thousands.  Most problems were easy to find and got the difference down to about $161.50.  I walked the difference first by year, then by month and then by day until I found the day where it went from balanced (11/19/20) to unbalanced (11/20/20).  Then ran a transaction report for 11/20/21.  There were only two, sale of a stock and a dividend for another stock.

The dividend entry had a debit with a corresponding credit in the correct accounts.    The stock sale proceeds showed a debit for my sweep account (asset) but no credit for any other account although it showed a credit for the number of shares sold.  Checked the stock account and sweep account and everything looked good.  I ran a balance sheet for the day and assets minus liabilities equaled total equity.  Finally, I did a side by side, line by line comparison of the 11/19/20 and 11/20/20 Trial Balance reports.  Everything matched perfectly with the exception of the bank sweep account and the stock dividend account which reflected the transactions for 11/20/20.  The only other differences was the unrealized gains for stocks and the daily downloaded stock prices from 11/19/20 to 11/20/20.  I do not know what else to do to try to find the error.  Any thoughts or recommendations?
-------------- next part --------------
A non-text attachment was scrubbed...
Name: PastedGraphic-1.pdf
Type: application/pdf
Size: 47755 bytes
Desc: PastedGraphic-1.pdf
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20210523/b1218a9e/attachment.pdf>

------------------------------

Subject: Digest Footer

_______________________________________________

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.

------------------------------

End of gnucash-user Digest, Vol 218, Issue 35
*********************************************