2020-03-01 GnuCash IRC logs

00:42:06 *** sbluhm has joined #gnucash
00:42:06 *** ChanServ sets mode: +v sbluhm
00:47:27 *** omnireq has joined #gnucash
00:50:51 *** omnireq has quit IRC
01:03:40 *** delli3 has quit IRC
01:04:19 *** delli3 has joined #gnucash
01:11:28 *** Maschinenhans has joined #gnucash
01:15:50 *** fell has joined #gnucash
01:15:50 *** ChanServ sets mode: +o fell
01:25:34 *** omnireq has joined #gnucash
01:28:45 *** omnireq_ has joined #gnucash
01:29:34 *** omnireq has quit IRC
01:33:51 *** fell has quit IRC
01:35:10 *** fell has joined #gnucash
01:35:10 *** ChanServ sets mode: +o fell
01:39:06 *** sbluhm has quit IRC
01:45:40 *** omnireq_ has quit IRC
01:56:24 *** sbluhm has joined #gnucash
01:56:24 *** ChanServ sets mode: +v sbluhm
01:59:25 *** hussam has joined #gnucash
01:59:25 *** ChanServ sets mode: +v hussam
02:07:39 *** sbluhm has quit IRC
02:08:43 *** Maschinenhans has quit IRC
02:10:58 *** Maschinenhans has joined #gnucash
02:18:03 *** Maschinenhans has quit IRC
03:35:38 <chris> warlord: what do you think of 797633 - can SGML have <BR/> within the alphanumeric field?
03:44:52 *** sbluhm has joined #gnucash
03:44:52 *** ChanServ sets mode: +v sbluhm
03:54:35 *** sbluhm has quit IRC
04:14:02 *** bertbob has quit IRC
04:18:58 *** bertbob has joined #gnucash
04:18:58 *** ChanServ sets mode: +v bertbob
04:29:08 *** bertbob has quit IRC
04:30:21 *** grmpf has joined #gnucash
04:30:59 *** bertbob has joined #gnucash
04:30:59 *** ChanServ sets mode: +v bertbob
04:36:45 *** gjanssens has joined #gnucash
04:36:45 *** ChanServ sets mode: +o gjanssens
04:40:23 *** sbluhm has joined #gnucash
04:55:22 *** sbluhm has quit IRC
05:11:06 *** sbluhm has joined #gnucash
05:11:06 *** ChanServ sets mode: +v sbluhm
05:11:53 *** Mechtilde has quit IRC
05:13:48 *** omnireq has joined #gnucash
05:18:18 *** omnireq has quit IRC
05:18:28 *** omnireq has joined #gnucash
05:18:35 *** Mechtilde has joined #gnucash
05:20:05 *** gggg has joined #gnucash
05:20:30 *** omnireq_ has joined #gnucash
05:20:54 *** gggg has quit IRC
05:21:43 *** omnireq has quit IRC
05:23:30 *** Mechtilde has quit IRC
05:25:11 *** Mechtilde has joined #gnucash
06:04:20 *** User__ has joined #gnucash
06:18:44 *** Maschinenhans has joined #gnucash
06:21:24 *** storyjesse has joined #gnucash
06:27:35 *** sbluhm has quit IRC
06:34:55 *** storyjesse has quit IRC
06:44:31 *** sbluhm has joined #gnucash
06:44:32 *** ChanServ sets mode: +v sbluhm
06:56:38 *** grmpf has left #gnucash
07:59:19 *** puck has quit IRC
08:01:27 *** puck has joined #gnucash
08:46:38 <warlord> chris, I'm not familiar enough with the SGML spec.
08:50:59 <chris> warlord: ok.
09:12:57 <chris> any idea who would that expert be? benoitg?
09:22:47 *** sbluhm has quit IRC
09:39:50 *** sbluhm has joined #gnucash
09:57:40 *** ajmt_ has joined #gnucash
09:59:26 *** ajmt_ has quit IRC
10:01:56 *** ajmt has joined #gnucash
10:33:28 *** sbluhm has quit IRC
10:43:59 *** jralls has joined #gnucash
10:44:04 <jralls> chris,
10:47:57 <jralls> chris, the libofx project at https://github.com/libofx/libofx is the place to raise the issue. SGML doesn't require closing tags so the <br> gets treated as a new field unless the parser recognizes it as special markup.
10:53:15 <jralls> <br> isn't a legal tag in the OFX160 DTD (you can get it along with documentation at https://www.ofx.org/downloads.html so there's no way for the parser to know that it doesn't start a new field.
10:53:42 <jralls> chris, does libofx drop the memo field entirely or just the second line?
10:54:36 <ajmt> not sure if this is the right place to ask; I'm a retail trader (multiple brokers, equities worldwide, multiple currencies, hundreds of trades per year) looking for software that allows me to bulk import trades (csv) and quickly create a report on pnl in a given base currency. Is this a use case for gnucash?
10:55:33 <chris> jralls: try import the .ofx in 797633 - it drops the whole <MEMO> line
10:56:34 <chris> fwiw this .ofx is from ING Bank Aus which annoyingly doesn't have <NAME> in Transactions. so, gnucash-ofx will duplicate memo into description. in any case the whole memo is left null.
10:56:45 <chris> ^ for the memo containing <BR/>
10:57:38 <chris> I'd report to the bank but they're stupid and refuse to fix .... hence I still use https://github.com/goodvibes2/IngAusOfxFixWin/ to add the obligatory <BANKACCTFROM> section.
10:59:02 <jralls> OK. Post an issue on the libofx project but note that neither Benoit nor cstim have a lot of time to work on it.
11:00:15 <jralls> Does IngAusOfxFixWin also pull out the br tag? If not ask Chris Good about adding that on gnucash-user.
11:00:29 <chris> No I've just asked on github
11:00:44 <chris> btw how do the names Bruce vs Ruby sound ? :)
11:01:48 <chris> ajmt: the engine supports your use case, but the bulk importing is not always obvious. best try and experiment.
11:02:24 <jralls> Bruce is a good Scottish name for boys. Ruby is usually for girls, (think the Kenny Rogers song "Ruby, Don't Take Your Love to Town").
11:03:01 <ajmt> ok, thank you, will do
11:03:12 <jralls> You're likely to get a quicker response from Chris Good that from Benoit.
11:03:19 <jralls> s/that/than/
11:03:21 <chris> true
11:04:14 <chris> we're keeping things unknown until the 20wk scan :P
11:05:56 <jralls> OK. Still plenty of time after that to play with names.
11:07:13 <jralls> Oh, didn't Monty Python use Bruce a lot to make fun of Ozzies? Maybe you should ask the locals if it's wise.
11:07:39 <chris> uh ok... maybe
11:13:52 <chris> ok gtg now, nite!
11:14:00 <jralls> 'night!
11:20:28 *** User__ has quit IRC
11:21:10 *** oozer has joined #gnucash
11:32:04 *** jralls has quit IRC
11:32:26 *** ajmt has quit IRC
11:40:20 *** Gerd has joined #gnucash
11:48:25 *** luwum[m] has joined #gnucash
11:48:58 *** warlord has quit IRC
11:49:06 *** warlord has joined #gnucash
11:51:05 *** fell has quit IRC
11:55:43 *** fell has joined #gnucash
11:55:43 *** ChanServ sets mode: +o fell
13:38:20 *** Gerd has quit IRC
13:45:57 *** Mechtilde has quit IRC
13:54:23 *** Mechtilde has joined #gnucash
14:01:48 *** sbluhm has joined #gnucash
14:01:48 *** ChanServ sets mode: +v sbluhm
14:25:24 <gnomey> how do you handle a dividend that months after reconciliation gets partially recharacterized as "nondividend distribution"?
14:25:45 <gnomey> my stock broker doesn't even tell me when this happens
14:26:28 <gnomey> i only discover it when the cost basis reported to the tax authority differs from what I paid for the stock
14:28:57 <gnomey> should I create a seperate transaction that moves money from income:dividends to income:capital gains? Or is it more sensible to alter the reconciled transaction to have another split?
14:30:17 <gnomey> it's a bit haphazard either way, because the Gnucash way of recording a stock sale is to hack in a capital gain in a way that circumvents the double-accounting design
14:38:16 *** oozer has quit IRC
14:48:02 <gnomey> it's always annoyed me that the register for a stock only shows buys,sales, and stock splits, but not dividends. That problem is exacerbated when it comes to nondividend distributions
14:48:22 <gnomey> (which effectively modify the sale price)
15:02:14 *** oozer has joined #gnucash
15:15:23 *** frakturfreak has joined #gnucash
15:15:24 *** ChanServ sets mode: +v frakturfreak
15:19:08 *** Gerd has joined #gnucash
15:54:18 *** sbluhm has quit IRC
15:59:44 *** Mechtilde has quit IRC
16:19:39 *** Maschinenhans has quit IRC
16:33:33 *** Aussie_matt has joined #gnucash
16:55:14 *** Gerd has quit IRC
17:05:39 *** frakturfreak has quit IRC
18:11:06 *** bertbob has quit IRC
18:16:06 *** bertbob has joined #gnucash
18:16:07 *** ChanServ sets mode: +v bertbob
18:25:52 *** Aussie_matt has quit IRC
18:28:27 *** Aussie_matt has joined #gnucash
20:14:59 *** oozer has quit IRC
20:31:28 *** kenahoo has joined #gnucash
20:38:37 <kenahoo> Hi, a conceptual question on tangible assets (e.g. my house). I've been using GnuCash for about 3 months, and I have accounts for my bank accounts, mortgage, etc.
20:39:12 <kenahoo> I have created an account for my house value, what would be a good way to assign its current value?
20:39:54 <kenahoo> Anything I can think of with double-entry procedures would assign an equal and opposite amount somewhere else, and I would like my total "net worth" to go up as a result of adding the value.
20:40:32 <kenahoo> the house purchase predates my usage of GnuCash by a couple decades.
20:50:52 <kenahoo> (BTW - I was going to ask on gnucash-user@gnucash.org, but Nabble seems to not have an SSL option, and I try to make it a rule in this day & age not to submit passwords over cleartext...0
20:51:09 <kenahoo> s/0/)/
21:16:34 <kenahoo> hmm, maybe I want to use `Equity:Opening Balances`? Does that account have some special designation in GnuCash, or is it a vanilla account like anything else?
22:03:55 <chris> kenahoo: that's the right answer
22:04:45 <chris> I'd write it as Equity:Opening Balances -> Asset:House, dated on the day of purchase
22:04:59 *** storyjesse has joined #gnucash
22:08:12 *** TownsendHardware has joined #gnucash
22:28:02 <kenahoo> Thanks chris. So make that the purchase price.
22:29:07 <kenahoo> For any appreciation over time (minimal, unfortunately) looks like I could create an "unrealized gains" account, like what's shown in https://www.gnucash.org/docs/v3/C/gnucash-guide/capgain_example1.html
22:30:56 <kenahoo> the dance of unrealized -> realized -> cost -> bank account seems pretty complex if I go that route
22:39:18 *** puck has quit IRC
22:39:38 <chris> Usually you wouldn't add unrealized gains until you sell
22:41:04 <kenahoo> okay - probably only an academic point for me in this case. Thanks for the help.
22:41:24 *** puck has joined #gnucash