2020-11-06 GnuCash IRC logs
01:04:46 *** sbluhm has joined #gnucash
01:04:46 *** ChanServ sets mode: +v sbluhm
01:07:16 *** David has quit IRC
01:07:21 *** David has joined #gnucash
01:24:16 *** sbluhm has quit IRC
01:27:20 <CDB-Work> chris: OK. also re your reply in the ticket, does it mean i needed to do anything? am tired right now so cant pick it out
01:28:09 <CDB-Work> i kinda read it as either (1) you added a report option i needed to toggle or (2) you need to change your detection method due to how i set it up or (3) both
01:42:54 *** sbluhm has joined #gnucash
01:42:54 *** ChanServ sets mode: +v sbluhm
01:51:19 *** CDB-Work is now known as CDB-PHONE
01:52:11 *** CDB-PHONE is now known as CDB-Work
01:52:16 *** CDB-PHONE has joined #gnucash
01:52:16 *** ChanServ sets mode: +v CDB-PHONE
01:52:53 *** CDB-Work is now known as CDB-Away
01:52:55 *** CDB-Away is now known as CDB-Away_
01:53:02 *** CDB-Away_ is now known as CDB-Work
01:58:02 *** CDB-Work has quit IRC
01:59:02 *** fell has quit IRC
02:00:21 *** fell has joined #gnucash
02:00:21 *** ChanServ sets mode: +o fell
02:03:51 *** Mechtilde has quit IRC
02:18:34 *** Mechtilde has joined #gnucash
02:22:21 *** Mechtilde has quit IRC
02:32:38 *** Mechtilde has joined #gnucash
02:41:19 *** Aussie_matt has quit IRC
02:44:51 *** Mechtilde has quit IRC
02:48:08 *** Mechtilde has joined #gnucash
03:33:33 *** gnomey has quit IRC
03:35:50 *** Mechtilde has quit IRC
03:39:53 *** gjanssens has joined #gnucash
03:39:54 *** ChanServ sets mode: +o gjanssens
03:43:08 *** Mechtilde has joined #gnucash
04:01:33 *** fabior has joined #gnucash
04:03:21 *** Mechtilde has quit IRC
04:04:39 *** Mechtilde has joined #gnucash
04:08:36 *** neku has quit IRC
04:14:45 *** User_ has joined #gnucash
04:30:22 *** bertbob has quit IRC
04:32:10 *** bertbob has joined #gnucash
04:32:10 *** ChanServ sets mode: +v bertbob
04:37:47 *** bertbob has quit IRC
04:48:14 *** bertbob has joined #gnucash
04:48:15 *** ChanServ sets mode: +v bertbob
04:59:31 *** Hamaryns has joined #gnucash
04:59:32 *** ChanServ sets mode: +v Hamaryns
05:04:03 *** Hamaryns has quit IRC
05:14:11 <chris> cdb-PHONE: ok np leave the data as it is
05:20:46 *** AdrienM has quit IRC
05:21:48 *** AdrienM has joined #gnucash
05:21:48 *** ChanServ sets mode: +v AdrienM
05:44:14 *** jwhitmore has joined #gnucash
06:20:14 *** Agfarmer18 has joined #gnucash
06:21:53 *** fabior has quit IRC
06:50:58 *** Herbert has joined #gnucash
07:02:39 *** jwhitmore has quit IRC
07:07:01 *** AdrienM has quit IRC
07:07:09 *** AdrienM has joined #gnucash
07:07:09 *** ChanServ sets mode: +v AdrienM
07:45:08 *** halipaul has joined #gnucash
08:07:50 *** Mechtilde has quit IRC
08:09:52 *** Mechtilde has joined #gnucash
08:11:42 *** Jimraehl1 has joined #gnucash
08:12:39 *** Jimraehl1 has quit IRC
08:12:52 *** Mechtilde has quit IRC
08:13:09 *** Mechtilde has joined #gnucash
08:47:14 <chris> CDB-Man_ CDB-PHONE your XLS has a sales transcation template. I wonder if it is up to date?
08:49:09 <chris> + can you figure out a universal template which can handle all variations?
08:49:33 <chris> this would imply any other format can be labelled invalid
09:05:15 <CDB-PHONE> chris universal is a tall order
09:05:47 <CDB-PHONE> I mean that one on there I THINK is pretty universal, but only to the extent that I am able to think of scenarios
09:07:07 <CDB-PHONE> unrelated, it is agnostic to the cost basis method (FIFO, average) -- though the entire template is setup for average so this is a moot point
09:11:17 <CDB-PHONE> also in terms of being up to date, well, if it matches the sales transactions in the actual Gnucash file, then the answer should be yes
09:11:50 <chris> I'll need to try figure out a universal template anyway for the report; I was wondering if yours is updated
09:12:19 <chris> it can be done, just takes time
09:18:34 <chris> main dificulty is how to decode a transcation into component columns - do we use heuristics "fee" "dividend" in action column, or use option "fee account" "proceeds account". the latter is more reliable.
09:33:12 <CDB-PHONE> going by memory I think mine is updated, especially if it matches the actual transactions in the posted Gnucash file
09:33:49 <CDB-PHONE> heuristics relies on strict adherence to non mandatory inputs in the form of action flags
09:33:54 *** sbluhm has quit IRC
09:34:22 <CDB-PHONE> fee and proceeds accounts is better, and I emphasize the s on accounts for plural
09:35:03 <CDB-PHONE> for example I have several fee accounts, since I track fees separately in different accounts depending on currency, taxability, country of the investment, etc
09:35:57 * chris agrees explicit account(s) is better however for development i'll stick to one
09:36:01 *** fabior has joined #gnucash
09:37:33 *** jervin has joined #gnucash
09:37:34 <CDB-PHONE> but yeah my template has worked for me over the past 5 years for all the situations that I've had so far
09:37:50 <CDB-PHONE> and the sales transactions in the Gnucash file have descriptions on each split
09:38:05 <CDB-PHONE> explaining each split for your understanding,
09:38:11 <CDB-PHONE> so it should be good
09:38:13 <chris> yes thx
09:38:46 <chris> template is for *sales though, purchase will be different (but much simpler)
09:39:00 * chris wants both
09:39:18 <chris> ^ don't worry easier I figure out from xLS
09:42:10 *** jervin has quit IRC
09:55:26 *** ramontjunior has joined #gnucash
09:59:21 *** Mechtilde has quit IRC
10:06:16 *** sbluhm has joined #gnucash
10:06:16 *** ChanServ sets mode: +v sbluhm
10:10:32 *** fabior has quit IRC
10:13:17 *** Mechtilde has joined #gnucash
10:33:18 <CDB-PHONE> from XLS and Gnucash combined yeah you should have all the info
10:33:29 <CDB-PHONE> we've literally added every combo under the sun
10:33:33 <CDB-PHONE> that we thought of
10:34:13 <CDB-PHONE> The dates thing can be changed as well, I just started inserting lines in between existing data and I didn't feel like renumbering the dates lol
10:34:27 <CDB-PHONE> there's no particular reason the dates are all clustered... other than I was lazy
10:36:19 *** jcarl43 has joined #gnucash
10:36:19 *** ChanServ sets mode: +v jcarl43
10:56:06 *** storyjesse has joined #gnucash
11:22:31 *** gnomey has joined #gnucash
11:48:03 *** storyjesse has quit IRC
11:58:37 *** guak has joined #gnucash
12:03:16 *** sbluhm has quit IRC
12:44:40 *** dpj has joined #gnucash
12:55:55 *** ChanServ sets mode: +v dpj
13:03:26 *** dpj has quit IRC
13:05:55 *** dpj has joined #gnucash
13:05:55 *** ChanServ sets mode: +v dpj
13:08:03 *** sbluhm has joined #gnucash
13:08:03 *** ChanServ sets mode: +v sbluhm
13:12:57 <dpj> Dean Jagels here on nick "dpj". No question, just lurking.
13:28:32 <CDB-PHONE> we welcome lurkers, hopefully ones that also become participants!
13:39:02 *** sergiomiguelrp has joined #gnucash
13:50:03 *** sbluhm has quit IRC
14:01:01 *** Hamaryns has joined #gnucash
14:01:01 *** ChanServ sets mode: +v Hamaryns
14:02:14 *** David has quit IRC
14:02:19 *** David has joined #gnucash
14:10:34 *** sbluhm has joined #gnucash
14:10:34 *** ChanServ sets mode: +v sbluhm
14:26:23 *** CDB-Work has joined #gnucash
14:26:23 *** ChanServ sets mode: +v CDB-Work
14:29:42 *** frakturfreak has joined #gnucash
14:35:26 *** Hamaryns has quit IRC
14:51:15 *** sergiomiguelrp has quit IRC
14:55:12 *** jervin has joined #gnucash
15:03:28 *** ramontjunior has quit IRC
15:36:19 *** jw4 has quit IRC
15:36:56 *** jw4 has joined #gnucash
16:10:01 *** gjanssens has quit IRC
16:16:05 *** AdrienM_ has joined #gnucash
16:16:07 *** AdrienM has quit IRC
16:27:50 *** Mechtilde has quit IRC
16:29:22 *** fell has quit IRC
16:29:42 *** fell has joined #gnucash
16:29:43 *** ChanServ sets mode: +o fell
16:41:10 *** halipaul has quit IRC
16:42:09 *** halipaul has joined #gnucash
16:54:03 *** sbluhm has quit IRC
17:46:27 *** Aussie_matt has joined #gnucash
17:50:28 *** Aussie_matt has quit IRC
17:52:16 *** Aussie_matt has joined #gnucash
17:55:22 *** KaiForce has quit IRC
18:05:25 *** Aussie_matt has quit IRC
18:08:12 *** frakturfreak has quit IRC
19:20:14 *** bertbob has quit IRC
19:21:53 *** bertbob has joined #gnucash
19:21:54 *** ChanServ sets mode: +v bertbob
20:17:00 *** jcarl43 has quit IRC
20:27:09 *** guak has quit IRC
20:38:22 *** User_ has quit IRC
20:46:33 *** bralyclow has joined #gnucash
20:46:33 *** ChanServ sets mode: +v bralyclow
20:50:18 *** bralyclow has quit IRC
20:50:44 *** bralyclow has joined #gnucash
20:50:44 *** ChanServ sets mode: +v bralyclow
21:05:40 *** bertbob has quit IRC
21:10:16 *** storyjesse has joined #gnucash
21:18:43 *** bertbob has joined #gnucash
21:18:43 *** ChanServ sets mode: +v bertbob
21:59:44 *** bralyclow has quit IRC
22:00:04 *** bralyclow has joined #gnucash
22:00:04 *** ChanServ sets mode: +v bralyclow
22:12:31 <chris> CDB-PHONE CDB-Man_ your regular BUY and SELL have fees. Am I assuming all other activity are commission-free? :)
22:13:30 <CDB-Work> i've never heard of commissions on anything not a buy or sell
22:13:41 <CDB-Work> not to say its impossible, but ive certaintly never seen it
22:14:35 <chris> ok
22:19:39 *** jervin has quit IRC
22:20:15 <chris> I think the absolute *safest* approach is to explicitly specify accounts: (asset)broker, (exp)fees, (inc)dividends
22:20:22 <chris> none of this action-field business
22:22:32 *** jervin has joined #gnucash
22:23:10 <chris> (asset)broker, (exp)fees, (inc)dividends, (inc)capgain
22:25:55 *** jervin has quit IRC
22:34:03 *** jervin has joined #gnucash
22:58:22 <CDB-Work> agree, use the account section interface
22:58:22 <CDB-Work> since you'll need the ability to select multiple accounts
22:59:19 *** Agfarmer18 has quit IRC
23:43:24 <chris> getting there :)
23:46:14 <chris> CDB-Work: Don't Dividends need to be converted to report-currency?