[GNC] Trial Balance Discrepancy - another possible reason to consider

[G R Hewitt]

I have been searching through my accounts, as time allowed, for the reason
as to why I had an imbalance in the Trial Balance and also the Balance
Sheet.

Using the 'Find' and all amounts greater than '0' I was checking debits and
credits were the same in the results window. Using the cursor keys so that
I could see where I was, rather than the mouse to scroll. Gnucash threw up
a mis-match warning that I had not seen before, to point out there was a
mis-match. Several transactions in the same account did not match their
counterpart.

Using the 'manual adjustment' offered I found I could not change the
amount, 243.00 to the correct 242.36.

On further investigation I found that for this particular account, the
'Smallest Fraction' in the 'Edit Account' window was set at '1' instead of
'Use Commodity Value'.

After setting this to 'Use Commodity Value' and running 'Repair All', the
disparity went away and now all is well.

I thought I would just pass this on, it may save someone a lot of time, and
possibly their hair.
___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] Trial balance

[David T. via gnucash-user]

John, 

Thanks for the information. I had no idea that the date range had a purpose on 
the TB.

⁣David T. ​

On Jan 8, 2023, 8:34 PM, at 8:34 PM, john  wrote:
>
>
>> On Jan 8, 2023, at 2:47 AM, David T. via gnucash-user
> wrote:
>> 
>> As I understand it, the Trial Balance report is As Of A Date, and
>therefore cumulative to that date. Not sure why the report includes
>start and end dates in that circumstance, except to follow settings
>provided by other reports.
>
>The start date is used to set a date range with end date for filtering
>out book-closing and adjusting splits according to patterns set on the
>Entries page of report options. The default values are descriptions
>"Closing Entries" and "Adjusting Entries" respectively. For all other
>purposes only the end date matters.
>
>Regards,
>John Ralls
___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] Trial balance

[john]

> On Jan 8, 2023, at 2:47 AM, David T. via gnucash-user 
>  wrote:
> 
> As I understand it, the Trial Balance report is As Of A Date, and therefore 
> cumulative to that date. Not sure why the report includes start and end dates 
> in that circumstance, except to follow settings provided by other reports.

The start date is used to set a date range with end date for filtering out 
book-closing and adjusting splits according to patterns set on the Entries page 
of report options. The default values are descriptions "Closing Entries" and 
"Adjusting Entries" respectively. For all other purposes only the end date 
matters.

Regards,
John Ralls

___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] Trial balance

[David T. via gnucash-user]

As I understand it, the Trial Balance report is As Of A Date, and therefore 
cumulative to that date. Not sure why the report includes start and end dates 
in that circumstance, except to follow settings provided by other reports. 

As for multi currency trial balances, there have been many discussions about 
the effect of exchange rates on the report, but the trading accounts are 
supposed to address that. I've never had a trial balance report balance (in 15 
years of GnuCash use), but then I've also never turned trading accounts on 
(because I'm afraid of what it might change in those data).

An opening balance entry is not required; every account begins at some point in 
time at zero. 

I'm sure others can provide additional insights (and correct my inevitable 
inaccuracies).

⁣David T. ​

On Jan 8, 2023, 10:14 AM, at 10:14 AM, Fred Tydeman  
wrote:
>I have run a Transaction report (for all accounts) for just one day in
>the
>past (to find all the transactions on that one day).  It found just one
>transaction where I bought 600 yuan for 99.07 USD (at an ATM in china).
>The grand totals in the report are 0 USD and 0 yuan.
>
>That one transaction has four splits:
>Receive column:
>  Assets:...:$china 600
>  Trading:cash US:ftexx 99.07 Fid. TE MM
>Spend column:
>  Assets:..:Fid. TE MM  99.07 Fed. TE MM
>  Trading:CURRENCY:CNY  600
>
>That transaction is the first one in $china.  There is no Equity
>Opening
>Balance (which would be zero) for $china.
>
>I then ran a Trial Balance report; again for just that one day and all
>accounts.  The two totals at the bottom of the report do not match
>(differ
>by 5.46).  If I change the date to 6 days earlier (again for just one
>day),
>the two totals match.
>
>By one day, I mean both Start date and Date of report are the same.
>
>OS:  Fedora Linux 37
>GnuCash: 4.13
>Trading accounts are on.
>
>Is Trial Balance supposed to work when there is a mixture of
>currencies?
>Is Trial Balance supposed to work for just one day in the past?
>Do all accounts need an Equity Opening Balance?
>___
>gnucash-user mailing list
>gnucash-user@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.
___
gnucash-user mailing list
gnucash-user@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.

[GNC] Trial balance

[Fred Tydeman]

I have run a Transaction report (for all accounts) for just one day in the
past (to find all the transactions on that one day).  It found just one
transaction where I bought 600 yuan for 99.07 USD (at an ATM in china).
The grand totals in the report are 0 USD and 0 yuan.

That one transaction has four splits:
Receive column:
  Assets:...:$china 600
  Trading:cash US:ftexx 99.07 Fid. TE MM
Spend column:
  Assets:..:Fid. TE MM  99.07 Fed. TE MM
  Trading:CURRENCY:CNY  600

That transaction is the first one in $china.  There is no Equity Opening
Balance (which would be zero) for $china.

I then ran a Trial Balance report; again for just that one day and all
accounts.  The two totals at the bottom of the report do not match (differ
by 5.46).  If I change the date to 6 days earlier (again for just one day),
the two totals match.

By one day, I mean both Start date and Date of report are the same.

OS:  Fedora Linux 37
GnuCash: 4.13
Trading accounts are on.

Is Trial Balance supposed to work when there is a mixture of currencies?
Is Trial Balance supposed to work for just one day in the past?
Do all accounts need an Equity Opening Balance?
___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] Trial Balance Report Settings

[Adrien Monteleone]

Surprisingly, no, there is no such setting.

Many if not most other reports have it.

You can file an RFE (Request for Enhancement) at bugs.gnucash.org

In the meantime, export or copy/paste the report to a spreadsheet and 
edit them out from there.


Regards,
Adrien

On 1/2/23 9:51 AM, Benjamin Soffer wrote:

Hello and Happy New Year!

I have lots of accounts with zero balances (which I must keep for legal 
reasons).  When I run a Trial Balance report, all of those accounts are 
included in the report, making the report much longer than necessary.  Is there 
a setting that would enable me to exclude zero-balance accounts from the Trial 
Balance report?


___
gnucash-user mailing list
gnucash-user@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.

[GNC] Trial Balance Report Error

[Murugan Muruganandam]

When i run Trial Balance Report, i am encountering the following error.  Can 
you please help what is causing this error, all other reports like balance 
sheet, income, expense are working fine.


i am attaching the trace file also, can any one help me where the issue could be


Report error

An error occurred while running the report.

  10 (apply-smob/1 #)
In c-interface.scm:
 35:4  9 (gnc:call-with-error-handling _ _)
In ice-9/boot-9.scm:
829:9  8 (catch _ _ # …)
In c-interface.scm:
39:40  7 (_)
In report-core.scm:
   752:25  6 (gnc:report-render-html #< type: "216cd0cf6931…> …)
In standard/trial-balance.scm:
   549:12  5 (trial-balance-renderer _)
In html-acct-table.scm:
545:4  4 (gnc:make-html-acct-table/env/accts _ _)
818:4  3 (gnc:html-acct-table-add-accounts! #<…> …)
   726:18  2 (traverse-accounts! _ 0 0 #)
In commodity-utilities.scm:
905:8  1 (gnc:sum-collector-commodity # …)
In unknown file:
   0 (+ 135226 190312 321500 241929 18593117 3873095 334397 0 …)

In procedure +: Wrong type: #f



Saludos Cordiales


Murugan


gnucash.trace.Q206X1.log
Description: gnucash.trace.Q206X1.log
___
gnucash-user mailing list
gnucash-user@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.

[GNC] Trial Balance Report Settings

[Benjamin Soffer]

Hello and Happy New Year!

I have lots of accounts with zero balances (which I must keep for legal 
reasons).  When I run a Trial Balance report, all of those accounts are 
included in the report, making the report much longer than necessary.  Is there 
a setting that would enable me to exclude zero-balance accounts from the Trial 
Balance report?

I am using Version: 4.8, Build ID: 4.8a+(2021-09-28)

Thank you!

Ben Soffer
___
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Trial Balance Report Error

[Murugan Muruganandam]

When i run Trial Balance Report, i am encountering the following error.  Can 
you please help what is causing this error, all other reports like balance 
sheet, income, expense are working fine.



Report error

An error occurred while running the report.

  10 (apply-smob/1 #)
In c-interface.scm:
 35:4  9 (gnc:call-with-error-handling _ _)
In ice-9/boot-9.scm:
829:9  8 (catch _ _ # …)
In c-interface.scm:
39:40  7 (_)
In report-core.scm:
   752:25  6 (gnc:report-render-html #< type: "216cd0cf6931…> …)
In standard/trial-balance.scm:
   549:12  5 (trial-balance-renderer _)
In html-acct-table.scm:
545:4  4 (gnc:make-html-acct-table/env/accts _ _)
818:4  3 (gnc:html-acct-table-add-accounts! #<…> …)
   726:18  2 (traverse-accounts! _ 0 0 #)
In commodity-utilities.scm:
905:8  1 (gnc:sum-collector-commodity # …)
In unknown file:
   0 (+ 135226 190312 321500 241929 18593117 3873095 334397 0 …)

In procedure +: Wrong type: #f



Saludos Cordiales


Murugan
___
gnucash-user mailing list
gnucash-user@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.

[GNC] Trial Balance Error

[Murugan Muruganandam]

hi

I have installed Gnucash 14.12 and i am getting an error message while 
generating the trial balance report.  it was working for two days before giving 
me this error. i use multi currency and trading accounting enabled

Can you help me


Report error

An error occurred while running the report.

  10 (apply-smob/1 #)
In c-interface.scm:
 35:4  9 (gnc:call-with-error-handling _ _)
In ice-9/boot-9.scm:
829:9  8 (catch _ _ # …)
In c-interface.scm:
39:40  7 (_)
In report-core.scm:
   752:25  6 (gnc:report-render-html #< type: "216cd0cf6931…> …)
In standard/trial-balance.scm:
   549:12  5 (trial-balance-renderer _)
In html-acct-table.scm:
545:4  4 (gnc:make-html-acct-table/env/accts _ _)
818:4  3 (gnc:html-acct-table-add-accounts! #<…> …)
   726:18  2 (traverse-accounts! _ 0 0 #)
In commodity-utilities.scm:
905:8  1 (gnc:sum-collector-commodity # …)
In unknown file:
   0 (+ 139823 196781 331193 19225192 4004761 345765 0 #f # # …)

In procedure +: Wrong type: #f



Saludos Cordiales


Murugan



___
gnucash-user mailing list
gnucash-user@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.

Re: [GNC] Trial Balance Help

[Stan Brown]

On 2022-06-24 09:18, Jack Lockard wrote:
> How could I record a realized gain and only impact one side of the
> ledger? I don't think you can. Doesn't the imbalance have to be an
> improperly entered transaction?

If you're asking what I think you're asking, that's an impossibility --
not a feature missing from GnuCash, but impossible in terms of
double-entry bookkeeping even if you were doing it on paper.

In every transaction, total debits must always equal total credits. The
GnuCash software creates an "Imbalance" entry if you enter a transaction
where debits =/= credits.

And in the same way, in the totality of your accounts, total debits
(assets + expenses) must equal total credits (liabilities + equity +
income). That equation is also written in other ways, for instance
Assets =Liabilities + (Equity + Income - Expense), but all of them are
equivalent.

I think you were advised earlier in this thread to read the tutorial and
concepts manual, especially the part about double-entry bookkeeping.
Maybe another reading? Your question sounds like you may have read that
section but didn't really take it in.

> I think I'll just give up. It's my personal finances so I guess, at
> the end of the day, it doesn't matter if it is out of balance.
Of course you're free to do whatever you like with the software. But,
speaking as an old software programmer, I'm always nervous about
ignoring an error condition. The problem is, you can't be a little bit
pregnant.Once you start ignoring _some_ errors, you  ever know whether
an error message is showing you a new problem or just echoing the
pre-existing one.

My advice, for what it's worth, is to track down why you're getting an
imbalance, and fix it. Then you can enter new transactions, and if an
imbalance pops up you'll know instantly that it must have been from the
transaction you just entered, so you can easily fix it right away.

Stan Brown
Tehachapi, CA, USA
https://BrownMath.com
___
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.

Re: [GNC] Trial Balance Report Settings

[D. via gnucash-user]

I think the OP is looking to save the settings from one iteration to the next, 
which I'd achieve by saving the settings as "My Trial Balance" and then calling 
that report whenever I needed it. 


 Original Message 
From: Jesse MacDougall 
Sent: Tue Jan 04 20:19:08 EST 2022
To: Benjamin Soffer 
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] Trial Balance Report Settings

Yes i saw a setting for this somewhere dont recall exactly

On Tue., Jan. 4, 2022, 16:41 Benjamin Soffer, 
wrote:

> Hello,
>
> Is it possible to configure the trial balance report so that hidden
> accounts or zero-balance accounts would be excluded from the report?
>
> Ben Soffer
> ___
> 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.

Re: [GNC] Trial Balance Report Settings

[Jesse MacDougall]

Yes i saw a setting for this somewhere dont recall exactly

On Tue., Jan. 4, 2022, 16:41 Benjamin Soffer, 
wrote:

> Hello,
>
> Is it possible to configure the trial balance report so that hidden
> accounts or zero-balance accounts would be excluded from the report?
>
> Ben Soffer
> ___
> 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.

[GNC] Trial Balance Report Settings

[Benjamin Soffer]

Hello,

Is it possible to configure the trial balance report so that hidden accounts or 
zero-balance accounts would be excluded from the report?

Ben Soffer
___
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.

Re: [GNC] Trial Balance Issue with Fund Merger

[Lisa Rowell]

Simple enough in my case. Thanks.

Lisa R

On 9/1/2021 3:54 PM, David Carlson wrote:
If the price in the price database is wrong for a particular day it 
can be manually corrected in the price database tool If there are not 
too many errors to deal with.  I run into that when manually entering 
transactions


On Wed, Sep 1, 2021 at 4:50 PM Lisa Rowell > wrote:



On 9/1/2021 12:28 PM, John Ralls wrote:
>
>> On Sep 1, 2021, at 12:16 PM, John Ralls mailto:jra...@ceridwen.us>> wrote:
>>
>>
>>
>>> On Sep 1, 2021, at 11:15 AM, Lisa Rowell
mailto:lisa.gives...@gmail.com>> wrote:
>>>
>>>
>>> On 9/1/2021 5:27 AM, Lisa Rowell wrote:
 On 8/31/2021 9:41 PM, John Ralls wrote:
>> On Aug 31, 2021, at 8:32 PM, Lisa Rowell
mailto:lisa.gives...@gmail.com>> wrote:
>>
>> I'm working my way through my account history after a
massive GnuCash import, straightening out issues with missing
realized capital gains/losses and came across an event that I
can't figure out how to properly handle.
>>
>> I held shares of a fund called Spartan 500 Index Investor
Class (FSMKX) which merged with Spartan US Equity Index Investor
Class (FUSEX) at some odd rate around 1:0.513. When I did the
import, I ended up with an account for FSMKX and an account for
FUSEX and a manually entered exchange transaction which did a sell
of FSMKX shares and a buy of FUSEX shares with no share price.
This got everything balanced out as far as share counts go, but
now I'm finding it's showing up as being not correct in the Trial
Balance. It looks to me like the exchange is being interpreted as
if an actual sell event had taken place.
>>
>> Can GnuCash properly account for this? The case in the
manual's More Complex Merger example is a bit different because
the example stock continued to trade under the same symbol, so
that solution doesn't map well. I found a past mailing list thread
that said that the proper way to account for this is as a sell
transaction of the going away fund and a buy transaction of the
fund that lives on with an accompanying Realized Gain transaction.
This doesn't seem right to me though since I didn't sell the
shares and did not realize a gain and I don't even have prices for
the time of the merger. In my way of looking at it, the gain
calculation should come at the time of sale and be based on
purchase price of the various share amounts, and not at the time
of the merger, since that maps to the tax view of things where I live.
>>
>> I understand that GnuCash wouldn't be able to calculate the
realized gains post merger, and I'm ok with doing that in a side
spreadsheet, but am more looking for a way around the bogus
realized gain entry at the time of merger just to make the Trial
Balance happy.
> If you're not too compulsive and since this is presumably
ancient history in a personal book one simple way to deal with it
would be to pretend that you bought the FUSEX in the first place
and ignore the FSMKX, but that might be a little painful if you
have a bunch of reinvested FSMKX dividend transactions that you'd
also need to change.
>
> I've handled similar situations in the past by doing a
simple transfer transaction between the two accounts, as in CR
FSMKX 513 and DR FUSEX 1000. As long as there's no currency
component to the transaction it shouldn't create a trading
imbalance in the book currency.
>
> Regards,
> John Ralls
 That solution was what worked for me for share transfers
between brokerages, where the commodity was the same, but when I
changed commodities it somehow shows up as a mismatch in the Trial
Balance. I don't have a share price for the shares in either split
so, in theory it shouldn't involve the book currency at all. I
don't get it at all.

 I'm sure it's this transaction since the balances match on
the previous day and the only other transaction on this date is a
paycheck deposit in the book currency that's no where near the
amount of the imbalance. The transaction is in the image attached,
that's what you're advocating, right?

 Thanks.

 Lisa R.

>>> Additional information:
>>>
>>> Removing the cross commodity sell/buy transaction does remove
the Trial Balance discrepancy. Additionally I added up all of the
purchase prices of shares of the fund being merged away and that
amount does equal to the credit / debit difference in the report.
>>>
>> It is, but that doesn't quite work. Here's a sample that does:
>> If you don't price the share transfer to the currency (USD in
both examples) the trial balance logic assumes 0 and calculates 

Re: [GNC] Trial Balance Issue with Fund Merger

[David Carlson]

If the price in the price database is wrong for a particular day it can be
manually corrected in the price database tool If there are not too many
errors to deal with.  I run into that when manually entering transactions

On Wed, Sep 1, 2021 at 4:50 PM Lisa Rowell  wrote:

>
> On 9/1/2021 12:28 PM, John Ralls wrote:
> >
> >> On Sep 1, 2021, at 12:16 PM, John Ralls  wrote:
> >>
> >>
> >>
> >>> On Sep 1, 2021, at 11:15 AM, Lisa Rowell 
> wrote:
> >>>
> >>>
> >>> On 9/1/2021 5:27 AM, Lisa Rowell wrote:
>  On 8/31/2021 9:41 PM, John Ralls wrote:
> >> On Aug 31, 2021, at 8:32 PM, Lisa Rowell 
> wrote:
> >>
> >> I'm working my way through my account history after a massive
> GnuCash import, straightening out issues with missing realized capital
> gains/losses and came across an event that I can't figure out how to
> properly handle.
> >>
> >> I held shares of a fund called Spartan 500 Index Investor Class
> (FSMKX) which merged with Spartan US Equity Index Investor Class (FUSEX) at
> some odd rate around 1:0.513. When I did the import, I ended up with an
> account for FSMKX and an account for FUSEX and a manually entered exchange
> transaction which did a sell of FSMKX shares and a buy of FUSEX shares with
> no share price. This got everything balanced out as far as share counts go,
> but now I'm finding it's showing up as being not correct in the Trial
> Balance. It looks to me like the exchange is being interpreted as if an
> actual sell event had taken place.
> >>
> >> Can GnuCash properly account for this? The case in the manual's
> More Complex Merger example is a bit different because the example stock
> continued to trade under the same symbol, so that solution doesn't map
> well. I found a past mailing list thread that said that the proper way to
> account for this is as a sell transaction of the going away fund and a buy
> transaction of the fund that lives on with an accompanying Realized Gain
> transaction. This doesn't seem right to me though since I didn't sell the
> shares and did not realize a gain and I don't even have prices for the time
> of the merger. In my way of looking at it, the gain calculation should come
> at the time of sale and be based on purchase price of the various share
> amounts, and not at the time of the merger, since that maps to the tax view
> of things where I live.
> >>
> >> I understand that GnuCash wouldn't be able to calculate the
> realized gains post merger, and I'm ok with doing that in a side
> spreadsheet, but am more looking for a way around the bogus realized gain
> entry at the time of merger just to make the Trial Balance happy.
> > If you're not too compulsive and since this is presumably ancient
> history in a personal book one simple way to deal with it would be to
> pretend that you bought the FUSEX in the first place and ignore the FSMKX,
> but that might be a little painful if you have a bunch of reinvested FSMKX
> dividend transactions that you'd also need to change.
> >
> > I've handled similar situations in the past by doing a simple
> transfer transaction between the two accounts, as in CR FSMKX 513 and DR
> FUSEX 1000. As long as there's no currency component to the transaction it
> shouldn't create a trading imbalance in the book currency.
> >
> > Regards,
> > John Ralls
>  That solution was what worked for me for share transfers between
> brokerages, where the commodity was the same, but when I changed
> commodities it somehow shows up as a mismatch in the Trial Balance. I don't
> have a share price for the shares in either split so, in theory it
> shouldn't involve the book currency at all. I don't get it at all.
> 
>  I'm sure it's this transaction since the balances match on the
> previous day and the only other transaction on this date is a paycheck
> deposit in the book currency that's no where near the amount of the
> imbalance. The transaction is in the image attached, that's what you're
> advocating, right?
> 
>  Thanks.
> 
>  Lisa R.
> 
> >>> Additional information:
> >>>
> >>> Removing the cross commodity sell/buy transaction does remove the
> Trial Balance discrepancy. Additionally I added up all of the purchase
> prices of shares of the fund being merged away and that amount does equal
> to the credit / debit difference in the report.
> >>>
> >> It is, but that doesn't quite work. Here's a sample that does:
> >> If you don't price the share transfer to the currency (USD in both
> examples) the trial balance logic assumes 0 and calculates a loss. To avoid
> that enter the book value of the shares you're transferring as a sell
> (credit) amount in the source split and a buy (debit) amount in the
> destination split:
> >>
> > Unfortunately my screen shot didn't make it to the list. It contained
> the following transactions:
> >
> > 1/23/19   Buy PIODX 1000  Brokerage Account1000
>  25.25,000.00 1,000
> > 

Re: [GNC] Trial Balance Issue with Fund Merger

[Lisa Rowell]

On 9/1/2021 12:28 PM, John Ralls wrote:



On Sep 1, 2021, at 12:16 PM, John Ralls  wrote:




On Sep 1, 2021, at 11:15 AM, Lisa Rowell  wrote:


On 9/1/2021 5:27 AM, Lisa Rowell wrote:

On 8/31/2021 9:41 PM, John Ralls wrote:

On Aug 31, 2021, at 8:32 PM, Lisa Rowell  wrote:

I'm working my way through my account history after a massive GnuCash import, 
straightening out issues with missing realized capital gains/losses and came 
across an event that I can't figure out how to properly handle.

I held shares of a fund called Spartan 500 Index Investor Class (FSMKX) which 
merged with Spartan US Equity Index Investor Class (FUSEX) at some odd rate 
around 1:0.513. When I did the import, I ended up with an account for FSMKX and 
an account for FUSEX and a manually entered exchange transaction which did a 
sell of FSMKX shares and a buy of FUSEX shares with no share price. This got 
everything balanced out as far as share counts go, but now I'm finding it's 
showing up as being not correct in the Trial Balance. It looks to me like the 
exchange is being interpreted as if an actual sell event had taken place.

Can GnuCash properly account for this? The case in the manual's More Complex 
Merger example is a bit different because the example stock continued to trade 
under the same symbol, so that solution doesn't map well. I found a past 
mailing list thread that said that the proper way to account for this is as a 
sell transaction of the going away fund and a buy transaction of the fund that 
lives on with an accompanying Realized Gain transaction. This doesn't seem 
right to me though since I didn't sell the shares and did not realize a gain 
and I don't even have prices for the time of the merger. In my way of looking 
at it, the gain calculation should come at the time of sale and be based on 
purchase price of the various share amounts, and not at the time of the merger, 
since that maps to the tax view of things where I live.

I understand that GnuCash wouldn't be able to calculate the realized gains post 
merger, and I'm ok with doing that in a side spreadsheet, but am more looking 
for a way around the bogus realized gain entry at the time of merger just to 
make the Trial Balance happy.

If you're not too compulsive and since this is presumably ancient history in a 
personal book one simple way to deal with it would be to pretend that you 
bought the FUSEX in the first place and ignore the FSMKX, but that might be a 
little painful if you have a bunch of reinvested FSMKX dividend transactions 
that you'd also need to change.

I've handled similar situations in the past by doing a simple transfer 
transaction between the two accounts, as in CR FSMKX 513 and DR FUSEX 1000. As 
long as there's no currency component to the transaction it shouldn't create a 
trading imbalance in the book currency.

Regards,
John Ralls

That solution was what worked for me for share transfers between brokerages, 
where the commodity was the same, but when I changed commodities it somehow 
shows up as a mismatch in the Trial Balance. I don't have a share price for the 
shares in either split so, in theory it shouldn't involve the book currency at 
all. I don't get it at all.

I'm sure it's this transaction since the balances match on the previous day and 
the only other transaction on this date is a paycheck deposit in the book 
currency that's no where near the amount of the imbalance. The transaction is 
in the image attached, that's what you're advocating, right?

Thanks.

Lisa R.


Additional information:

Removing the cross commodity sell/buy transaction does remove the Trial Balance 
discrepancy. Additionally I added up all of the purchase prices of shares of 
the fund being merged away and that amount does equal to the credit / debit 
difference in the report.


It is, but that doesn't quite work. Here's a sample that does:
If you don't price the share transfer to the currency (USD in both examples) 
the trial balance logic assumes 0 and calculates a loss. To avoid that enter 
the book value of the shares you're transferring as a sell (credit) amount in 
the source split and a buy (debit) amount in the destination split:


Unfortunately my screen shot didn't make it to the list. It contained the 
following transactions:

1/23/19   Buy PIODX 1000  Brokerage Account1000 25.
25,000.00 1,000
2/28/19   Reinv PIODX 11.231  Brokerage Account  11.231 22.2598 
  250.00 1,011.231
9/1/21Transfer to P   -1011.231 
   1,011.231 0
   P1971.211 12.8094
25,250.00
   PIODX   -1011.231 24.9698
   25,250.00

The last transaction is in split view showing the identical cash amounts for 
the two stock accounts. Enter the amounts and let GnuCash compute the prices to 
prevent 

Re: [GNC] Trial Balance Issue with Fund Merger

[John Ralls]

> On Sep 1, 2021, at 12:16 PM, John Ralls  wrote:
> 
> 
> 
>> On Sep 1, 2021, at 11:15 AM, Lisa Rowell  wrote:
>> 
>> 
>> On 9/1/2021 5:27 AM, Lisa Rowell wrote:
>>> 
>>> On 8/31/2021 9:41 PM, John Ralls wrote:
 
> On Aug 31, 2021, at 8:32 PM, Lisa Rowell  wrote:
> 
> I'm working my way through my account history after a massive GnuCash 
> import, straightening out issues with missing realized capital 
> gains/losses and came across an event that I can't figure out how to 
> properly handle.
> 
> I held shares of a fund called Spartan 500 Index Investor Class (FSMKX) 
> which merged with Spartan US Equity Index Investor Class (FUSEX) at some 
> odd rate around 1:0.513. When I did the import, I ended up with an 
> account for FSMKX and an account for FUSEX and a manually entered 
> exchange transaction which did a sell of FSMKX shares and a buy of FUSEX 
> shares with no share price. This got everything balanced out as far as 
> share counts go, but now I'm finding it's showing up as being not correct 
> in the Trial Balance. It looks to me like the exchange is being 
> interpreted as if an actual sell event had taken place.
> 
> Can GnuCash properly account for this? The case in the manual's More 
> Complex Merger example is a bit different because the example stock 
> continued to trade under the same symbol, so that solution doesn't map 
> well. I found a past mailing list thread that said that the proper way to 
> account for this is as a sell transaction of the going away fund and a 
> buy transaction of the fund that lives on with an accompanying Realized 
> Gain transaction. This doesn't seem right to me though since I didn't 
> sell the shares and did not realize a gain and I don't even have prices 
> for the time of the merger. In my way of looking at it, the gain 
> calculation should come at the time of sale and be based on purchase 
> price of the various share amounts, and not at the time of the merger, 
> since that maps to the tax view of things where I live.
> 
> I understand that GnuCash wouldn't be able to calculate the realized 
> gains post merger, and I'm ok with doing that in a side spreadsheet, but 
> am more looking for a way around the bogus realized gain entry at the 
> time of merger just to make the Trial Balance happy.
 If you're not too compulsive and since this is presumably ancient history 
 in a personal book one simple way to deal with it would be to pretend that 
 you bought the FUSEX in the first place and ignore the FSMKX, but that 
 might be a little painful if you have a bunch of reinvested FSMKX dividend 
 transactions that you'd also need to change.
 
 I've handled similar situations in the past by doing a simple transfer 
 transaction between the two accounts, as in CR FSMKX 513 and DR FUSEX 
 1000. As long as there's no currency component to the transaction it 
 shouldn't create a trading imbalance in the book currency.
 
 Regards,
 John Ralls
>>> 
>>> That solution was what worked for me for share transfers between 
>>> brokerages, where the commodity was the same, but when I changed 
>>> commodities it somehow shows up as a mismatch in the Trial Balance. I don't 
>>> have a share price for the shares in either split so, in theory it 
>>> shouldn't involve the book currency at all. I don't get it at all.
>>> 
>>> I'm sure it's this transaction since the balances match on the previous day 
>>> and the only other transaction on this date is a paycheck deposit in the 
>>> book currency that's no where near the amount of the imbalance. The 
>>> transaction is in the image attached, that's what you're advocating, right?
>>> 
>>> Thanks.
>>> 
>>> Lisa R.
>>> 
>> Additional information:
>> 
>> Removing the cross commodity sell/buy transaction does remove the Trial 
>> Balance discrepancy. Additionally I added up all of the purchase prices of 
>> shares of the fund being merged away and that amount does equal to the 
>> credit / debit difference in the report.
>> 
> 
> It is, but that doesn't quite work. Here's a sample that does:
> If you don't price the share transfer to the currency (USD in both examples) 
> the trial balance logic assumes 0 and calculates a loss. To avoid that enter 
> the book value of the shares you're transferring as a sell (credit) amount in 
> the source split and a buy (debit) amount in the destination split:
> 

Unfortunately my screen shot didn't make it to the list. It contained the 
following transactions:

1/23/19   Buy PIODX 1000  Brokerage Account1000 25.
25,000.00 1,000
2/28/19   Reinv PIODX 11.231  Brokerage Account  11.231 22.2598 
  250.00 1,011.231
9/1/21Transfer to P   -1011.231 
   1,011.231 0
 

Re: [GNC] Trial Balance Issue with Fund Merger

[John Ralls]

> On Sep 1, 2021, at 11:15 AM, Lisa Rowell  wrote:
> 
> 
> On 9/1/2021 5:27 AM, Lisa Rowell wrote:
>> 
>> On 8/31/2021 9:41 PM, John Ralls wrote:
>>> 
 On Aug 31, 2021, at 8:32 PM, Lisa Rowell  wrote:
 
 I'm working my way through my account history after a massive GnuCash 
 import, straightening out issues with missing realized capital 
 gains/losses and came across an event that I can't figure out how to 
 properly handle.
 
 I held shares of a fund called Spartan 500 Index Investor Class (FSMKX) 
 which merged with Spartan US Equity Index Investor Class (FUSEX) at some 
 odd rate around 1:0.513. When I did the import, I ended up with an account 
 for FSMKX and an account for FUSEX and a manually entered exchange 
 transaction which did a sell of FSMKX shares and a buy of FUSEX shares 
 with no share price. This got everything balanced out as far as share 
 counts go, but now I'm finding it's showing up as being not correct in the 
 Trial Balance. It looks to me like the exchange is being interpreted as if 
 an actual sell event had taken place.
 
 Can GnuCash properly account for this? The case in the manual's More 
 Complex Merger example is a bit different because the example stock 
 continued to trade under the same symbol, so that solution doesn't map 
 well. I found a past mailing list thread that said that the proper way to 
 account for this is as a sell transaction of the going away fund and a buy 
 transaction of the fund that lives on with an accompanying Realized Gain 
 transaction. This doesn't seem right to me though since I didn't sell the 
 shares and did not realize a gain and I don't even have prices for the 
 time of the merger. In my way of looking at it, the gain calculation 
 should come at the time of sale and be based on purchase price of the 
 various share amounts, and not at the time of the merger, since that maps 
 to the tax view of things where I live.
 
 I understand that GnuCash wouldn't be able to calculate the realized gains 
 post merger, and I'm ok with doing that in a side spreadsheet, but am more 
 looking for a way around the bogus realized gain entry at the time of 
 merger just to make the Trial Balance happy.
>>> If you're not too compulsive and since this is presumably ancient history 
>>> in a personal book one simple way to deal with it would be to pretend that 
>>> you bought the FUSEX in the first place and ignore the FSMKX, but that 
>>> might be a little painful if you have a bunch of reinvested FSMKX dividend 
>>> transactions that you'd also need to change.
>>> 
>>> I've handled similar situations in the past by doing a simple transfer 
>>> transaction between the two accounts, as in CR FSMKX 513 and DR FUSEX 1000. 
>>> As long as there's no currency component to the transaction it shouldn't 
>>> create a trading imbalance in the book currency.
>>> 
>>> Regards,
>>> John Ralls
>> 
>> That solution was what worked for me for share transfers between brokerages, 
>> where the commodity was the same, but when I changed commodities it somehow 
>> shows up as a mismatch in the Trial Balance. I don't have a share price for 
>> the shares in either split so, in theory it shouldn't involve the book 
>> currency at all. I don't get it at all.
>> 
>> I'm sure it's this transaction since the balances match on the previous day 
>> and the only other transaction on this date is a paycheck deposit in the 
>> book currency that's no where near the amount of the imbalance. The 
>> transaction is in the image attached, that's what you're advocating, right?
>> 
>> Thanks.
>> 
>> Lisa R.
>> 
> Additional information:
> 
> Removing the cross commodity sell/buy transaction does remove the Trial 
> Balance discrepancy. Additionally I added up all of the purchase prices of 
> shares of the fund being merged away and that amount does equal to the credit 
> / debit difference in the report.
> 

It is, but that doesn't quite work. Here's a sample that does:
If you don't price the share transfer to the currency (USD in both examples) 
the trial balance logic assumes 0 and calculates a loss. To avoid that enter 
the book value of the shares you're transferring as a sell (credit) amount in 
the source split and a buy (debit) amount in the destination split:

___
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.

Re: [GNC] Trial Balance Issue with Fund Merger

[Lisa Rowell]

On 9/1/2021 5:27 AM, Lisa Rowell wrote:


On 8/31/2021 9:41 PM, John Ralls wrote:


On Aug 31, 2021, at 8:32 PM, Lisa Rowell  
wrote:


I'm working my way through my account history after a massive 
GnuCash import, straightening out issues with missing realized 
capital gains/losses and came across an event that I can't figure 
out how to properly handle.


I held shares of a fund called Spartan 500 Index Investor Class 
(FSMKX) which merged with Spartan US Equity Index Investor Class 
(FUSEX) at some odd rate around 1:0.513. When I did the import, I 
ended up with an account for FSMKX and an account for FUSEX and a 
manually entered exchange transaction which did a sell of FSMKX 
shares and a buy of FUSEX shares with no share price. This got 
everything balanced out as far as share counts go, but now I'm 
finding it's showing up as being not correct in the Trial Balance. 
It looks to me like the exchange is being interpreted as if an 
actual sell event had taken place.


Can GnuCash properly account for this? The case in the manual's More 
Complex Merger example is a bit different because the example stock 
continued to trade under the same symbol, so that solution doesn't 
map well. I found a past mailing list thread that said that the 
proper way to account for this is as a sell transaction of the going 
away fund and a buy transaction of the fund that lives on with an 
accompanying Realized Gain transaction. This doesn't seem right to 
me though since I didn't sell the shares and did not realize a gain 
and I don't even have prices for the time of the merger. In my way 
of looking at it, the gain calculation should come at the time of 
sale and be based on purchase price of the various share amounts, 
and not at the time of the merger, since that maps to the tax view 
of things where I live.


I understand that GnuCash wouldn't be able to calculate the realized 
gains post merger, and I'm ok with doing that in a side spreadsheet, 
but am more looking for a way around the bogus realized gain entry 
at the time of merger just to make the Trial Balance happy.
If you're not too compulsive and since this is presumably ancient 
history in a personal book one simple way to deal with it would be to 
pretend that you bought the FUSEX in the first place and ignore the 
FSMKX, but that might be a little painful if you have a bunch of 
reinvested FSMKX dividend transactions that you'd also need to change.


I've handled similar situations in the past by doing a simple 
transfer transaction between the two accounts, as in CR FSMKX 513 and 
DR FUSEX 1000. As long as there's no currency component to the 
transaction it shouldn't create a trading imbalance in the book 
currency.


Regards,
John Ralls


That solution was what worked for me for share transfers between 
brokerages, where the commodity was the same, but when I changed 
commodities it somehow shows up as a mismatch in the Trial Balance. I 
don't have a share price for the shares in either split so, in theory 
it shouldn't involve the book currency at all. I don't get it at all.


I'm sure it's this transaction since the balances match on the 
previous day and the only other transaction on this date is a paycheck 
deposit in the book currency that's no where near the amount of the 
imbalance. The transaction is in the image attached, that's what 
you're advocating, right?


Thanks.

Lisa R.


Additional information:

Removing the cross commodity sell/buy transaction does remove the Trial 
Balance discrepancy. Additionally I added up all of the purchase prices 
of shares of the fund being merged away and that amount does equal to 
the credit / debit difference in the report.


Lisa Rowell

___
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.

Re: [GNC] Trial Balance Issue with Fund Merger

[Lisa Rowell]

On 8/31/2021 9:41 PM, John Ralls wrote:



On Aug 31, 2021, at 8:32 PM, Lisa Rowell  wrote:

I'm working my way through my account history after a massive GnuCash import, 
straightening out issues with missing realized capital gains/losses and came 
across an event that I can't figure out how to properly handle.

I held shares of a fund called Spartan 500 Index Investor Class (FSMKX) which 
merged with Spartan US Equity Index Investor Class (FUSEX) at some odd rate 
around 1:0.513. When I did the import, I ended up with an account for FSMKX and 
an account for FUSEX and a manually entered exchange transaction which did a 
sell of FSMKX shares and a buy of FUSEX shares with no share price. This got 
everything balanced out as far as share counts go, but now I'm finding it's 
showing up as being not correct in the Trial Balance. It looks to me like the 
exchange is being interpreted as if an actual sell event had taken place.

Can GnuCash properly account for this? The case in the manual's More Complex 
Merger example is a bit different because the example stock continued to trade 
under the same symbol, so that solution doesn't map well. I found a past 
mailing list thread that said that the proper way to account for this is as a 
sell transaction of the going away fund and a buy transaction of the fund that 
lives on with an accompanying Realized Gain transaction. This doesn't seem 
right to me though since I didn't sell the shares and did not realize a gain 
and I don't even have prices for the time of the merger. In my way of looking 
at it, the gain calculation should come at the time of sale and be based on 
purchase price of the various share amounts, and not at the time of the merger, 
since that maps to the tax view of things where I live.

I understand that GnuCash wouldn't be able to calculate the realized gains post 
merger, and I'm ok with doing that in a  side spreadsheet, but am more looking 
for a way around the bogus realized gain entry at the time of merger just to 
make the Trial Balance happy.

If you're not too compulsive and since this is presumably ancient history in a 
personal book one simple way to deal with it would be to pretend that you 
bought the FUSEX in the first place and ignore the FSMKX, but that might be a 
little painful if you have a bunch of reinvested FSMKX dividend transactions 
that you'd also need to change.

I've handled similar situations in the past by doing a simple transfer 
transaction between the two accounts, as in CR FSMKX 513 and DR FUSEX 1000. As 
long as there's no currency component to the transaction it shouldn't create a 
trading imbalance in the book currency.

Regards,
John Ralls


That solution was what worked for me for share transfers between 
brokerages, where the commodity was the same, but when I changed 
commodities it somehow shows up as a mismatch in the Trial Balance. I 
don't have a share price for the shares in either split so, in theory it 
shouldn't involve the book currency at all. I don't get it at all.


I'm sure it's this transaction since the balances match on the previous 
day and the only other transaction on this date is a paycheck deposit in 
the book currency that's no where near the amount of the imbalance. The 
transaction is in the image attached, that's what you're advocating, right?


Thanks.

Lisa R.

___
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.

Re: [GNC] Trial Balance Issue with Fund Merger

[John Ralls]

> On Aug 31, 2021, at 8:32 PM, Lisa Rowell  wrote:
> 
> I'm working my way through my account history after a massive GnuCash import, 
> straightening out issues with missing realized capital gains/losses and came 
> across an event that I can't figure out how to properly handle.
> 
> I held shares of a fund called Spartan 500 Index Investor Class (FSMKX) which 
> merged with Spartan US Equity Index Investor Class (FUSEX) at some odd rate 
> around 1:0.513. When I did the import, I ended up with an account for FSMKX 
> and an account for FUSEX and a manually entered exchange transaction which 
> did a sell of FSMKX shares and a buy of FUSEX shares with no share price. 
> This got everything balanced out as far as share counts go, but now I'm 
> finding it's showing up as being not correct in the Trial Balance. It looks 
> to me like the exchange is being interpreted as if an actual sell event had 
> taken place.
> 
> Can GnuCash properly account for this? The case in the manual's More Complex 
> Merger example is a bit different because the example stock continued to 
> trade under the same symbol, so that solution doesn't map well. I found a 
> past mailing list thread that said that the proper way to account for this is 
> as a sell transaction of the going away fund and a buy transaction of the 
> fund that lives on with an accompanying Realized Gain transaction. This 
> doesn't seem right to me though since I didn't sell the shares and did not 
> realize a gain and I don't even have prices for the time of the merger. In my 
> way of looking at it, the gain calculation should come at the time of sale 
> and be based on purchase price of the various share amounts, and not at the 
> time of the merger, since that maps to the tax view of things where I live.
> 
> I understand that GnuCash wouldn't be able to calculate the realized gains 
> post merger, and I'm ok with doing that in a  side spreadsheet, but am more 
> looking for a way around the bogus realized gain entry at the time of merger 
> just to make the Trial Balance happy.

If you're not too compulsive and since this is presumably ancient history in a 
personal book one simple way to deal with it would be to pretend that you 
bought the FUSEX in the first place and ignore the FSMKX, but that might be a 
little painful if you have a bunch of reinvested FSMKX dividend transactions 
that you'd also need to change.

I've handled similar situations in the past by doing a simple transfer 
transaction between the two accounts, as in CR FSMKX 513 and DR FUSEX 1000. As 
long as there's no currency component to the transaction it shouldn't create a 
trading imbalance in the book currency.

Regards,
John Ralls

___
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.

[GNC] Trial Balance Issue with Fund Merger

[Lisa Rowell]

I'm working my way through my account history after a massive GnuCash 
import, straightening out issues with missing realized capital 
gains/losses and came across an event that I can't figure out how to 
properly handle.


I held shares of a fund called Spartan 500 Index Investor Class (FSMKX) 
which merged with Spartan US Equity Index Investor Class (FUSEX) at some 
odd rate around 1:0.513. When I did the import, I ended up with an 
account for FSMKX and an account for FUSEX and a manually entered 
exchange transaction which did a sell of FSMKX shares and a buy of FUSEX 
shares with no share price. This got everything balanced out as far as 
share counts go, but now I'm finding it's showing up as being not 
correct in the Trial Balance. It looks to me like the exchange is being 
interpreted as if an actual sell event had taken place.


Can GnuCash properly account for this? The case in the manual's More 
Complex Merger example is a bit different because the example stock 
continued to trade under the same symbol, so that solution doesn't map 
well. I found a past mailing list thread that said that the proper way 
to account for this is as a sell transaction of the going away fund and 
a buy transaction of the fund that lives on with an accompanying 
Realized Gain transaction. This doesn't seem right to me though since I 
didn't sell the shares and did not realize a gain and I don't even have 
prices for the time of the merger. In my way of looking at it, the gain 
calculation should come at the time of sale and be based on purchase 
price of the various share amounts, and not at the time of the merger, 
since that maps to the tax view of things where I live.


I understand that GnuCash wouldn't be able to calculate the realized 
gains post merger, and I'm ok with doing that in a  side spreadsheet, 
but am more looking for a way around the bogus realized gain entry at 
the time of merger just to make the Trial Balance happy.


Thanks.

Lisa R.

___
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.

Re: [GNC] Trial Balance with more "Display" option

[John Ralls]

Thanks for the hint but nobody but me will see it if you don't copy the list. 
You should make sure to do that for all replies to list emails.

Regards,
John Ralls

> On Jun 1, 2021, at 10:43 PM, Andreas Vyrides  wrote:
> 
> Dear Mr Ralls,
> 
> Thank you for your email.
> 
> This is just for future reference to anyone with a similar question to mine.
> 
> The best way to get a Trial balance like look would be to create a 
> Transaction report, and at the "Display" tab, select the subtotal table 
> option. Then at sorting, you can select "Show Subtotals only (Hide 
> transactional data), resulting in only table being show.
> 
> I am sure you can then play around with different options to make the report 
> the way you want it.
> 
> I hope this helps
> 
> Thank you for your time
> 
> 
> On 21/05/2021 17:49, John Ralls wrote:
>> 
>>> On May 21, 2021, at 2:48 AM, Andreas Vyrides  wrote:
>>> 
>>> Dear Sir,
>>> 
>>> I would like to know if there is a way to include "Account codes" into the 
>>> Trial Balance Report. Currently only account name is visible, and there are 
>>> no other options available.
>>> 
>>> Thank you for your time
>> Unfortunately the only way is for you to copy that report and base a new 
>> custom report on it. That's not easy unless you're a fairly proficient 
>> programmer. There are some instructions at 
>> https://wiki.gnucash.org/wiki/Custom_Reports to get you started.
>> 
>> Regards,
>> John Ralls
>> 

___
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.

Re: [GNC] Trial Balance Error

[David Carlson]

Dennis.

I do not have a good understanding of how the trial balance report works,
but it does look at security prices in the GnuCash price database.  That is
over my pay grade.
If you have been tracking that stock price in GnuCash, that can do funny
things to the way the report assigns values to the stock at various times.
In fact, I have found that there are ways to fill the price database with
bad numbers so it would not hurt to look at what is in your price
database..

I also do not use scrubbing, so I cannot comment there either.

On Sun, May 23, 2021 at 4:40 PM  wrote:

> Hi David,
> Thanks.  I’ve studied the cap gains and think I have a reasonable
> understanding of how to determine either manually or by scrubbing.  In this
> case, I sold the stock for exactly what I paid for it.  I waited until the
> price was close and put a limit order in and it hit.  No commission either
> way so cap gain is zero.  I did the automatic with scrub but nothing
> registered anywhere and I assumed it was because there was zero gain/loss.
> Do you think that might be my trial balance report difference even though
> the numbers aren’t close or multiples?
> ___
> 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.
>


-- 
David Carlson
___
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.

Re: [GNC] Trial Balance Error

[smada46]

Hi David, 
Thanks.  I’ve studied the cap gains and think I have a reasonable understanding 
of how to determine either manually or by scrubbing.  In this case, I sold the 
stock for exactly what I paid for it.  I waited until the price was close and 
put a limit order in and it hit.  No commission either way so cap gain is zero. 
 I did the automatic with scrub but nothing registered anywhere and I assumed 
it was because there was zero gain/loss.  Do you think that might be my trial 
balance report difference even though the numbers aren’t close or multiples?
___
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.

Re: [GNC] Trial Balance Error

[David Carlson]

Dennis,

When you sold the stock you realized a capital gain or loss.  To account
for that in GnuCash is a little tricky.  You can determine the amount by
adding up all cash spent to buy the stock and the sale proceeds.  The
difference is the (hopefully) gain.  Look in the tutorial for details on
recording the capital gain.

I will warn you that you need to use the tab key to navigate into the split
line where you actually enter the gain in order to avoid entering a
quantity of shares.

Good Luck

On Sun, May 23, 2021 at 3:40 PM dennis adams  wrote:

> 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?
> ___
> 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.
>


-- 
David Carlson
___
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.

[GNC] Trial Balance Error

[dennis adams]

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?


PastedGraphic-1.pdf
Description: PastedGraphic-1.pdf
___
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.

Re: [GNC] Trial Balance with more "Display" option

[John Ralls]

> On May 21, 2021, at 2:48 AM, Andreas Vyrides  wrote:
> 
> Dear Sir,
> 
> I would like to know if there is a way to include "Account codes" into the 
> Trial Balance Report. Currently only account name is visible, and there are 
> no other options available.
> 
> Thank you for your time

Unfortunately the only way is for you to copy that report and base a new custom 
report on it. That's not easy unless you're a fairly proficient programmer. 
There are some instructions at https://wiki.gnucash.org/wiki/Custom_Reports to 
get you started.

Regards,
John Ralls

___
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.

[GNC] Trial Balance with more "Display" option

[Andreas Vyrides]

Dear Sir,

I would like to know if there is a way to include "Account codes" into 
the Trial Balance Report. Currently only account name is visible, and 
there are no other options available.


Thank you for your time

Kind Regards

A V




___
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.

Re: [GNC] Trial Balance

[Christopher Lam]

Fix: https://bugs.gnucash.org/show_bug.cgi?id=796696#c9
Better Fix: Upgrade to v3.5.

On Sun, 21 Apr 2019 at 16:58, Martin  wrote:

> Hi,
>
> I'm using version 3.2
>
> When I run Reports=>Income & Expense=>Trial Balance
>
> I get the error message "An error occurred while running the report"
>
> I'm OK with other standard reports like P and Balance Sheet but for some
> reason cannot get the TB to run  does anyone know a fix.
>
> Regards
>
> Mart
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> 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.

[GNC] Trial Balance

[Martin]

Hi,

I'm using version 3.2 

When I run Reports=>Income & Expense=>Trial Balance

I get the error message "An error occurred while running the report"

I'm OK with other standard reports like P and Balance Sheet but for some
reason cannot get the TB to run  does anyone know a fix.

Regards

Mart



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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.

Re: [GNC] Trial Balance report error

[James Thorpe]

Thanks, bugfix edit to html-utilities.scm seems to have worked!


On 14/08/2018 15:00, Christopher Lam wrote:

https://bugs.gnucash.org/show_bug.cgi?id=796696

Known bug, fixed for next release. This bug report has instructions 
for fixing in interim.


On Tue, 14 Aug 2018, 19:52 James Thorpe > wrote:


Dear List

I just upgraded to the latest version on Windows (3.2) and now it
seems
the Trial Balance report is not working (no matter what options I
choose, it just returns "Report error"). I was previously on a
version
around 2.6 I think.

Can anyone give me guidelines as to how to trace the error? Same
seems
to be the case on my Fedora Linux installation.

kind regards

-- 
--

James Thorpe
061 476 2775
ja...@fusionsystems.co.za 

___
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.



--
--
James Thorpe
061 476 2775
ja...@fusionsystems.co.za

___
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.

Re: [GNC] Trial Balance report error

[Christopher Lam]

https://bugs.gnucash.org/show_bug.cgi?id=796696

Known bug, fixed for next release. This bug report has instructions for
fixing in interim.

On Tue, 14 Aug 2018, 19:52 James Thorpe  wrote:

> Dear List
>
> I just upgraded to the latest version on Windows (3.2) and now it seems
> the Trial Balance report is not working (no matter what options I
> choose, it just returns "Report error"). I was previously on a version
> around 2.6 I think.
>
> Can anyone give me guidelines as to how to trace the error? Same seems
> to be the case on my Fedora Linux installation.
>
> kind regards
>
> --
> --
> James Thorpe
> 061 476 2775
> ja...@fusionsystems.co.za
>
> ___
> 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.

[GNC] Trial Balance report error

[James Thorpe]

Dear List

I just upgraded to the latest version on Windows (3.2) and now it seems 
the Trial Balance report is not working (no matter what options I 
choose, it just returns "Report error"). I was previously on a version 
around 2.6 I think.


Can anyone give me guidelines as to how to trace the error? Same seems 
to be the case on my Fedora Linux installation.


kind regards

--
--
James Thorpe
061 476 2775
ja...@fusionsystems.co.za

___
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.