Trial Balance Report with Investment Transactions

Sat Feb 4 04:56:47 EST 2017

Chris

First off, thank you for getting back to me. This all started when I
decided to run a Trial Balance on my program. I had not done this in a few
years...don't ask me why. It always balanced before but now it was off. I
am currently running GnuCash 2.6.15. This copy was built from git rev
1ef17e6+ on 2016-12-17.

You have given me many questions to answer, and some of these terms I'm
really not even familiar with. So I will try to give you answers to your
questions.

1 - *Have you followed the suggestions in the GnuCash Tutorial and Concepts*
*Guide, **Part II.*
 I set my investments using the "
GnuCash Tutorial and Concepts
 Guide
,
" I'm not aware of the Part II version, only the version with GnuCash
2.6.15. In fact, I have copied this and refer to it regularly.

2 -
*Managing Personal Finances, Ch 9 Investments, Selling Shares, **Automatic
Calculation of Capital Gain or Loss Using Lots, Run a Trial*
Balance, Tip

to try to determine exactly which sale transaction(s) make the Trial Balance

*go out of balance?*
* *Yes I have read this and have my program to automatically update my
portfolio. I go to tools, price editor, get quotes and then I close the
screen, go to my portfolio and run an update. My values are then all
changed according the the results of the new quotes received. Yes I am
able to make the trial balance go out of balance.

3 -* Have you used scrubbing to create capital gain transactions or have
you*
*manually entered them?* I really am not familiar with the term scrubbing
to create capital gain transactions. I have in the past entered all of the
investment transaction manually.

4 -
*If you are using scrubbing, have you ensured you have complied with all
the*
*points in the following "Considerations" paragraph?*
** I guess this is something that I don't use do to my not being familiar
with scrubbing. 

5 -
*Are you using multiple currencies or trading accounts?*
* *I am only using the American dollar.

I have attached a shot of one of my DRIP mutual fund investment
transactions for 12/16/16 that I have manually entered in . You will also
see that I had to manually enter in an account adjustment to force the
Trial Balance to balance out. Could my values be changing due to the change
in stock market pricing? My amount of stocks owned seems to always be there
and my portfolio values seem to be be true as compared to my Scottrade
positions. However my Trial Balance does not agree....? Every time a have a
dividend reinvestment now or I sell a share, I have to enter a correction
 so the Trial Balance will come out okay. Weird - to say the least!

[image: Inline image 3]

The view below shows where I entered a dividend reinvestment and my Trial
Balance does not balance out. Have I entered something wrong?

[image: Inline image 1]

Any help here will certainly be appreciated.

Thank you in advance for your help.

Richard

On Fri, Feb 3, 2017 at 8:01 PM, Chris Good <chris.good at ozemail.com.au>
wrote:

> > Message: 5
> > Date: Thu, 02 Feb 2017 13:07:10 -0500
> > From: Richard Lindgren <rlindgren74 at gmail.com>
> > To: gnucash-user at gnucash.org
> > Cc: gnucash-user at gnucash.org
> > Subject: Trial Balance Report with Investment Transactions
> > Message-ID: <28cd077c-e8f3-4b53-80a0-5bb71474cab0 at typeapp.com>
> > Content-Type: text/plain; charset=UTF-8
> >
> > Hi,
> >
> > Richard Lindgren <rlindgren74 at gmail.com> writes:
> >
> > I have a problem with the Trial Balance report relative to incorporating
> my
> > investments. My regular accounting portion seems to be okay, but when it
> > comes to using the Trial Balance with my investment transactions there is
> > always a discrepancy!
> >
> > It doesn't seem to matter whether it is a Drip fund account a purchase or
> sell
> > transaction. It keeps track of the number of shares okay, but when it
> comes
> > to the actual dollars...it's wrong. I'm not saying that the gnucash
> program is
> > inaccurate, I'm saying I am EXTREMELY frustrated and can not figure what
> I'm
> > doing wrong. Maybe I have set up the various accounts wrong! I need help
> > here before I switch to something else.
> >
> > Please help me?
> >
> > Thank you in advance for your help in this matter, as it is VERY
> important
> to
> > me.
> >
> > Richard Lindgren
>
> Hi Richard,
>
> Have you followed the suggestions in the GnuCash Tutorial and Concepts
> Guide,
> Part II. Managing Personal Finances, Ch 9 Investments, Selling Shares,
> Automatic Calculation of Capital Gain or Loss Using Lots, Run a Trial
> Balance, Tip
> to try to determine exactly which sale transaction(s) make the Trial
> Balance
> go out of balance?
>
> You need to give us something to work with to help you.
> If you identify a particular sale/capital gain that first causes the trial
> balance problem, and you cannot figure out why,
> please provide all the costs for all buys and sells up to and including the
> sale, and the sale and capital gain transaction info,
> so we can check if you or GnuCash is doing something wrong.
>
> It would be even better if you could provide a test (depersonalised)
> GnuCash
> file which shows the problem so there are no misunderstandings.
>
> Have you used scrubbing to create capital gain transactions or have you
> manually entered them?
> If you are using scrubbing, have you ensured you have complied with all the
> points in the following "Considerations" paragraph?
> Are you using multiple currencies or trading accounts?
>
> Regards, Chris Good
>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 63351 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20170204/3f6119e9/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 83844 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20170204/3f6119e9/attachment-0003.png>