Re: trial balance - how to find mismatch question

On 16/02/2018 08:20, Adrien Monteleone wrote: At least on my version of the Trial Balance report, there is no ‘Imbalance entry’ specifically. There is at the bottom, the Imbalance-XXX and Orphan-XXX accounts listed along with the others. There is also a line for ‘Unrealized Gains’ or

Re: trial balance - how to find mismatch question

I am not a custodian but neither do I trust my custodians to remain 100% invulnerable to hacking, so I continue to monitor their reports and check them for accuracy. If all the numbers in GnuCash are correct, the GnuCash reports can line up next to the trustees reports and usually agree to the

Re: trial balance - how to find mismatch question

BTW, quixotic, while based on the famous Don Quixote, is a non-proper (improper?) adjective, and thus does not need capitalization. Whether you pronounce it “key-hotic” or “quick-sotic” depends on your personal predilection, as I undetstand it. David > On Mar 6, 2018, at 7:57 AM, David

Re: trial balance - how to find mismatch question

David, I have IRAs, but I do not *manage* IRAs. The custodian is the entity with whom I maintain my IRA, and so I do not need to report an IRA valuation. THEY do. So, it is true—I do not act as custodian for others’ retirement accounts. I wonder whether this is common for the GnuCash user

Re: trial balance - how to find mismatch question

On 16/02/2018 04:55, David T. via gnucash-devel wrote: I don’t believe I’ve seen anywhere in this thread any attempt to explain that there is a difference between IMBALANCE-XXX (an indication that you have transactions that lacked a balancing split) and the Imbalance entry in the Trial Balance

Re: trial balance - how to find mismatch question

David T, I guess you do not have any IRA's or 401-K's as the IRS requires every custodian to file either a "Fair Market Value" form or a form 5498 which includes the fair market value for each account. The "as of" time is calendar year end. When you turn 70-1/2 you get to take a "Required

Re: trial balance - how to find mismatch question

David Carlson, > On Mar 6, 2018, at 4:27 AM, David Carlson wrote: > > Adrien, I think that you summarized the problem with "nearest in time" > nicely. Wm, no doubt, had tongue in cheek when he was assigning a high > value to future prices. You clarify that reports

Re: trial balance - how to find mismatch question

Adrien, I think that you summarized the problem with "nearest in time" nicely. Wm, no doubt, had tongue in cheek when he was assigning a high value to future prices. You clarify that reports are often run "as of" historical dates (and often need to match accounting reports submitted to

Re: trial balance - how to find mismatch question

Wm, Consider the case of running a historical Balance Sheet for a date that falls on a market holiday that also falls on a weekend. The latest price prior to that holiday might be 2 days prior. The ’nearest price’ will be the day after the holiday. If Gnucash is pulling the day after price, it

Re: trial balance - how to find mismatch question

On 03/03/2018 18:52, D via gnucash-devel wrote: I think having the extra option would be useful and less confusing than having "Nearest in time" only look backwards. Nearest in time is relative to the report date? Where is the confusion? -- Wm

Re: trial balance - how to find mismatch question

On 03/03/2018 18:52, D via gnucash-devel wrote: I think having nearest in time use future dates relative to the report date is not useful. Mind you, matching a broker statement for value (as opposed to holdings) is perhaps equally not useful. I guess I could see a point to a nearest in time

Re: trial balance - how to find mismatch question

On 03/03/2018 17:59, Geert Janssens wrote: Op zaterdag 3 maart 2018 16:35:27 CET schreef David Carlson: On January 30, 2015 I reported https://bugzilla.gnome.org/show_bug.cgi?id=743753 pointing out this behavior in Gnucash suggesting that the nearest in time criterion should not select future

Re: trial balance - how to find mismatch question

Geert, I think having nearest in time use future dates relative to the report date is not useful. Mind you, matching a broker statement for value (as opposed to holdings) is perhaps equally not useful. I guess I could see a point to a nearest in time using later dates (for example, when the

Re: trial balance - how to find mismatch question

Op zaterdag 3 maart 2018 16:35:27 CET schreef David Carlson: > On January 30, 2015 I reported > https://bugzilla.gnome.org/show_bug.cgi?id=743753 pointing out this > behavior in Gnucash suggesting that the nearest in time criterion should > not select future dates. That bug report applied to

Re: trial balance - how to find mismatch question

I am not sure where Wm is going with his comments but I can state that I just ran the Trial Balance report in GnuCash release 2.6.18, which is not quite the very latest release available but is a known reference point. I changed the report dates to start at the beginning of last year and end at

Re: trial balance - how to find mismatch question

On 16/02/2018 11:24, Christopher Lam wrote: I like the way this is going. Please describe or file minimal data file cases in Bugzilla. Perhaps I'll be able to decode the trial balance and we can decide then what it should really do. It is possible I've missed a detail but in RL a TB should

Re: trial balance - how to find mismatch question

On 16/02/2018 10:57, David Carlson wrote: As another user with a lot of stock trades, I sometimes use that report to find an issue, although I have developed a process involving outside spreadsheets to calculate realized gains per security account as GnuCash calculates them and net gains as the

Re: trial balance - how to find mismatch question

> On Feb 16, 2018, at 12:20 AM, Adrien Monteleone > wrote: > > At least on my version of the Trial Balance report, there is no ‘Imbalance > entry’ specifically. > > There is at the bottom, the Imbalance-XXX and Orphan-XXX accounts listed > along with the others.

Re: trial balance - how to find mismatch question

gt; if it does the same thing or only on exactly 12/31/2016. You might > have > > >>> some corrupt data. That might even be the source date of the > imbalance. > > >>>>> > > >>>>> I just entered those two dates in the same report and

Re: trial balance - how to find mismatch question

day before and > >>> after just to be thorough) Also be sure to check all boxes on the > Status > >>> tab in the Filter options. You want to see all transactions for that > date > >>> range. Then just look over them and see if anything looks out of > pla

Re: trial balance - how to find mismatch question

By… and set your date range. (maybe even a day before and > >>> after just to be thorough) Also be sure to check all boxes on the > Status > >>> tab in the Filter options. You want to see all transactions for that > date > >>> range. Then just look o

Re: trial balance - how to find mismatch question

e if anything looks out of place. In >>> particular, look for either the amount you are out of balance by or half >>> that amount if the variance is an even number. (meaning you have an entry >>> that is entered in reverse debit/credit, or entirely duplicated) >>>>> >>>>> For myself, I

Re: trial balance - how to find mismatch question

causing my lot assignments to get out of >> whack. I know I have some open lots that shouldn’t be there and many that >> are applied to the wrong documents. I’ll clean that up first, then re-run >> the trial balance and see if that does the trick. I’m not sur

Re: trial balance - how to find mismatch question

anyway. > > > > > > Regards, > > > Adrien > > > > > >> On Feb 15, 2018, at 2:35 PM, Elmar <etsc...@gmail.com> wrote: > > >> > > >> > > >> > > >> On 02/15/2018 02:28 PM, gnucash-user-requ...@gnucash.org w