Thanks for your reply.
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?
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.
Jack
-----Original Message-----
From: Derek Atkins <de...@ihtfp.com>
Sent: Thursday, June 23, 2022 10:58 AM
To: Jack Lockard <jelock...@outlook.com>
Cc: GnuCash User List <gnucash-user@gnucash.org>
Subject: Re: [GNC] Trail Balance Help
Hi,
On Thu, June 23, 2022 10:37 am, Jack Lockard wrote:
> I've been using GnuCash for over ten years now and just the other day
> ran a Trial Balance report for the first time. As you might imagine,
> it did not balance and was out of balance in excess of $100k. I
> started running reports year by year. 2011 and 2012 were in balance.
> 2013 was out of balance by $4303.1. I ran it with a date of 7/15/2013
> and it was in balance. Ran it again with a date of 7/16/2013 and it
> was out of balance $4303,10. Next I ran a General Ledger report for
> 7/16/2013 for all accounts and there were only two transactions. One
> was $40.75 for a gas purchase (40.75 credit to checking and 40.75
> debit to expenses:auto:gas&oil). The other was a rollover from an ESOP
> account to an IRA account in the amount of $6222.88. No match to $4303.10.
> There is an Unrealized Gain amount on the trial balance of $87,645.69.
> I ran an Advanced Portfolio report for the same date and it shows an
> Unrealized Gain of $84,389.45. Don't understand why they are different
> by
> $3,256.24 and it doesn't match the out of balance amount and would
> only make the out of balance amount larger.
> I have no clue how to find where the imbalance is coming from. Any
> suggestions on how to locate it?
My INITIAL guess is that the "difference" is due to a change in value in the
PriceDB, and the different reports are using a different exchange rate than the
transaction itself.
Generally an out-of-balance Trial Balance implies you did not account for
realized gains/losses. So the IRA account transaction would be the reason for
that. Perhaps you're missing $4303.10 of realized gain?
> Jack
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
-derek
--
Derek Atkins 617-623-3745
de...@ihtfp.com
https://nam12.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.ihtfp.com%2F&data=05%7C01%7C%7Ca961f3886fcf49f88bc808da5528c496%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637915930842486726%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=fDApnxyj7UtGu4%2Btq4%2F4kh%2BNjN%2B%2Bo04OI4HRci7qF84%3D&reserved=0
Computer and Internet Security Consultant
_______________________________________________
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.
