Re: trial balance - how to find mismatch question

2018-03-06 Thread Wm via gnucash-devel
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 ‘Unreali

Re: trial balance - how to find mismatch question

2018-03-06 Thread David Carlson
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 pen

Re: trial balance - how to find mismatch question

2018-03-06 Thread David T. via gnucash-devel
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 Carlson

Re: trial balance - how to find mismatch question

2018-03-06 Thread David T. via gnucash-devel
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 base.

Re: trial balance - how to find mismatch question

2018-03-06 Thread Wm via gnucash-devel
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 rep

Re: trial balance - how to find mismatch question

2018-03-05 Thread David Carlson
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 Minimum

Re: trial balance - how to find mismatch question

2018-03-05 Thread David T. via gnucash-devel
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 are often run "as of" > histo

Re: trial balance - how to find mismatch question

2018-03-05 Thread David Carlson
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 government

Re: trial balance - how to find mismatch question

2018-03-05 Thread Adrien Monteleone
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

2018-03-05 Thread Wm via gnucash-devel
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

2018-03-05 Thread Wm via gnucash-devel
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 u

Re: trial balance - how to find mismatch question

2018-03-05 Thread Wm via gnucash-devel
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 da

Re: trial balance - how to find mismatch question

2018-03-03 Thread D via gnucash-devel
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 da

Re: trial balance - how to find mismatch question

2018-03-03 Thread Geert Janssens
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 relea

Re: trial balance - how to find mismatch question

2018-03-03 Thread David Carlson
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 th

Re: trial balance - how to find mismatch question

2018-03-03 Thread Wm via gnucash-devel
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 only

Re: trial balance - how to find mismatch question

2018-03-03 Thread Wm via gnucash-devel
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

2018-02-16 Thread John Ralls
> 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. > > There is also a line for

Re: trial balance - how to find mismatch question

2018-02-16 Thread Christopher Lam
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 it worked > fine, > > >>> so this wouldn’

Re: trial balance - how to find mismatch question

2018-02-16 Thread David T. via gnucash-devel
ve narrowed down to a few weeks, I’d just take a look at > the > >>> General Ledger which contains all transactions from all accounts. > Click on > >>> View > Filter 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 > >

Re: trial balance - how to find mismatch question

2018-02-16 Thread David Carlson
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 > place. In > >>> particular

Re: trial balance - how to find mismatch question

2018-02-16 Thread Adrien Monteleone
is an even number. (meaning you have an entry >>> that is entered in reverse debit/credit, or entirely duplicated) >>>>> >>>>> For myself, I think I want to tackle one other area first. I recall >>> doing some re-organization and I went through

Re: trial balance - how to find mismatch question

2018-02-15 Thread David T. via gnucash-devel
; >>>> For myself, I think I want to tackle one other area first. I recall >> doing some re-organization and I went through a series of unposting paid >> invoices and reposting them, causing my lot assignments to get out of >> whack. I know I have some open lots that shou

Re: trial balance - how to find mismatch question

2018-02-15 Thread Christopher Lam
re 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 sure where the > Trial-Balance report is pulling its numbers from, but it won’t hurt to > perform that cleanup anyway. > > > > > > Regards, > > > Adrien > &