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

2023-03-17 Thread 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

Re: [GNC] Trial balance

2023-01-08 Thread 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,

Re: [GNC] Trial balance

2023-01-08 Thread 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

Re: [GNC] Trial balance

2023-01-08 Thread 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

[GNC] Trial balance

2023-01-07 Thread 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

Re: [GNC] Trial Balance Report Settings

2023-01-02 Thread 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

[GNC] Trial Balance Report Error

2023-01-02 Thread 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

[GNC] Trial Balance Report Settings

2023-01-02 Thread 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

[GNC] Trial Balance Report Error

2022-12-16 Thread 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

[GNC] Trial Balance Error

2022-10-05 Thread 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

Re: [GNC] Trial Balance Help

2022-06-24 Thread 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

Re: [GNC] Trial Balance Report Settings

2022-01-04 Thread D. via gnucash-user
8 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 tha

Re: [GNC] Trial Balance Report Settings

2022-01-04 Thread 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 >

[GNC] Trial Balance Report Settings

2022-01-04 Thread 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

Re: [GNC] Trial Balance Issue with Fund Merger

2021-09-01 Thread 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

Re: [GNC] Trial Balance Issue with Fund Merger

2021-09-01 Thread 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

Re: [GNC] Trial Balance Issue with Fund Merger

2021-09-01 Thread 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

Re: [GNC] Trial Balance Issue with Fund Merger

2021-09-01 Thread 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

Re: [GNC] Trial Balance Issue with Fund Merger

2021-09-01 Thread 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

Re: [GNC] Trial Balance Issue with Fund Merger

2021-09-01 Thread 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

Re: [GNC] Trial Balance Issue with Fund Merger

2021-09-01 Thread 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

Re: [GNC] Trial Balance Issue with Fund Merger

2021-08-31 Thread 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

[GNC] Trial Balance Issue with Fund Merger

2021-08-31 Thread 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)

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

2021-06-02 Thread 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

Re: [GNC] Trial Balance Error

2021-05-23 Thread 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

Re: [GNC] Trial Balance Error

2021-05-23 Thread 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

Re: [GNC] Trial Balance Error

2021-05-23 Thread 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

[GNC] Trial Balance Error

2021-05-23 Thread 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

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

2021-05-21 Thread 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

[GNC] Trial Balance with more "Display" option

2021-05-21 Thread 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 ___

Re: [GNC] Trial Balance

2019-04-21 Thread 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" > >

[GNC] Trial Balance

2019-04-21 Thread 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

Re: [GNC] Trial Balance report error

2018-08-14 Thread 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

Re: [GNC] Trial Balance report error

2018-08-14 Thread 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

[GNC] Trial Balance report error

2018-08-14 Thread 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