2020-11-17 GnuCash IRC logs
00:06:21 *** hfxpaul has joined #gnucash
00:07:35 *** halipaul has quit IRC
00:28:13 *** o01eg has quit IRC
00:29:12 *** o01eg has joined #gnucash
00:36:22 *** sbluhm has quit IRC
00:39:07 *** Vollstrecker has quit IRC
00:40:44 *** Vollstrecker has joined #gnucash
00:44:22 *** bertbob has joined #gnucash
00:44:23 *** ChanServ sets mode: +v bertbob
00:58:22 *** sbluhm has joined #gnucash
00:58:22 *** ChanServ sets mode: +v sbluhm
01:07:26 *** marusich has joined #gnucash
01:07:26 *** ChanServ sets mode: +v marusich
01:14:56 *** Mechtilde has joined #gnucash
01:18:37 *** sbluhm has quit IRC
01:24:13 *** Vollstrecker has quit IRC
01:25:47 *** Vollstrecker has joined #gnucash
01:25:58 *** marusich has quit IRC
01:26:05 *** hfxpaul has quit IRC
01:34:40 *** CDB-Work has quit IRC
01:37:52 *** sbluhm has joined #gnucash
01:45:48 *** fell has quit IRC
01:47:07 *** fell has joined #gnucash
01:47:07 *** ChanServ sets mode: +o fell
01:48:27 *** frakturfreak has joined #gnucash
01:48:27 *** ChanServ sets mode: +v frakturfreak
03:08:45 *** Aussie_matt has quit IRC
03:14:40 *** ghost has left #gnucash
04:17:20 *** iduno8912 has joined #gnucash
04:17:20 *** ChanServ sets mode: +v iduno8912
04:40:32 *** iduno8912 has quit IRC
04:48:44 *** gjanssens has joined #gnucash
04:48:45 *** ChanServ sets mode: +o gjanssens
04:51:22 *** User has joined #gnucash
05:11:00 *** qwer has quit IRC
05:17:27 *** qwer has joined #gnucash
05:33:59 *** Aussie_matt has joined #gnucash
05:35:56 *** ramontjunior has joined #gnucash
05:41:48 *** Herbert has joined #gnucash
06:05:59 *** User has quit IRC
06:27:44 *** default_1 has joined #gnucash
06:30:42 *** halipaul has joined #gnucash
07:15:29 *** puck has quit IRC
07:19:56 *** qwer has quit IRC
07:23:54 *** Aussie_matt has quit IRC
07:24:07 *** puck has joined #gnucash
07:46:11 *** Vollstrecker has quit IRC
07:49:02 *** qwer has joined #gnucash
08:20:52 *** halipaul has quit IRC
08:21:47 *** halipaul has joined #gnucash
08:53:13 *** storyjesse has joined #gnucash
09:08:12 *** Jimraehl1 has joined #gnucash
09:16:48 *** qwer has quit IRC
09:29:45 *** chris has joined #gnucash
09:29:45 *** ChanServ sets mode: +v chris
09:29:49 *** gncbot sets mode: +o chris
09:30:10 <chris> CDB-Man if the issue with ACB-tool is the autodetect 'note' column then I'm not surprised. Mainly testing the formulas for now.
09:30:22 <chris> autodetect is always difficult.
09:30:54 <chris> with a perfect autodetect the report can describe exact stock activity in plain english. It's *possible* but not easy!
09:41:28 <chris> CDB-Man CDB-PHONE you'll be surprised to know I still can't process Dr Cr completely, but I can work out complicated .gnucash data -> .xls
09:42:08 *** Mechtilde has quit IRC
09:43:26 <chris> if all formulas match then it's a good step forward and we can work on fixing autodetect note column
09:48:08 *** fell has quit IRC
09:48:31 *** fell has joined #gnucash
09:48:31 *** ChanServ sets mode: +o fell
09:50:57 *** Mechtilde has joined #gnucash
09:58:18 <CDB-PHONE> it's also affecting the dividend column in addition to the note column
10:01:37 <chris> is there a similar txn in your .gnucash?
10:13:41 *** qwer has joined #gnucash
10:20:01 *** fell has quit IRC
10:22:44 *** qwer has quit IRC
10:35:12 <chris> CDB-PHONE: I'm confused about your screenshots 31-12-2017 - they show Asset:Stock<->Income:Dividend labelled ROC, and Asset<->Income:Capgain labelled ND..... my analysis says Asset:Stock<->Cash = ROC, Inc:Cash <-> Cash = Dividend
10:35:51 <chris> CDB-PHONE: I'm confused about your screenshots 31-12-2017 - they show Asset:Stock<->Income:Dividend labelled ROC, and Asset<->Income:Capgain labelled ND..... my analysis says Asset:Stock<->Cash = ROC, Asset:Stock <-> Inc:Dividend = ND
10:36:12 *** storyjesse has quit IRC
10:37:38 *** qwer has joined #gnucash
10:38:13 <chris> maybe for the first one (your desc = ND adj to book value) we'll allow ND to have Capgain split.
10:39:15 <chris> I'd suggest to minimize misunderstand it'll be best that you add similar txns in your .gnucash
11:07:07 *** sbluhm has quit IRC
11:10:04 <CDB-PHONE> Hmm, I'll need to recheck the ND one
11:11:54 <chris> ok. also because acb-tool works with stock-editor dialog, they now live in https://github.com/Gnucash/gnucash/pull/818
11:18:58 *** jcarl43 has joined #gnucash
11:18:58 *** ChanServ sets mode: +v jcarl43
11:27:16 <CDB-PHONE> I'll check it out this weekend
11:27:23 <CDB-PHONE> along with uploading the new file
11:28:06 <CDB-PHONE> does that pull request mean it will show up in maintenance branch nightly?
11:31:55 <chris> no; it means anyone who compiles this branch will get both stock-editor and acb-tool.scm features
11:33:37 <chris> just had a thought; perhaps we'd want to split dialog-stock-editor into two sections: (1) stock activity eg Dividends/ROC/ND/Stock-split and (2) investor activity eg Buy/Sell. Usually we want to choose one activity, but we can combine (1) and (2).
11:34:45 <chris> activities in (1) which releases liquidity eg Dividend/ROC/SS can also enable (2) Buy.
11:35:25 <chris> and your exercise is to let me know which activities will also enable (2) Sell
11:35:35 <chris> also shorting rules
11:48:46 *** frakturfreak has quit IRC
12:02:58 *** chris has quit IRC
12:14:56 *** David has quit IRC
12:15:01 *** David has joined #gnucash
12:20:27 *** fell has joined #gnucash
12:20:27 *** ChanServ sets mode: +o fell
12:32:59 *** Agfarmer18 has joined #gnucash
12:34:09 *** krumel has joined #gnucash
12:35:50 *** Agfarmer18 has quit IRC
12:37:33 *** qwer has quit IRC
12:38:55 <krumel> Hi. I'm really new to gnu cash and I want to import transactions from a csv which I downloaded from online banking. I really don't have a clue about bookkeeping (but I need to change that) so I'm somewhat unsure on how to import the dates. Do I import both booking and value date? Or do I just pick one as "Date" and if so, which?
12:41:47 <warlord> GnuCash only has one date, the "post date". If your CSV has multiple, you can choose which is the Post Date. (GnuCash does have an EntryDate, but it is not user visible or changeable).
12:47:05 *** qwer has joined #gnucash
12:53:59 *** guak has joined #gnucash
13:03:34 *** ArtGravity has joined #gnucash
13:03:34 *** ChanServ sets mode: +v ArtGravity
13:07:33 *** ramontjunior has quit IRC
13:08:53 *** qwer has quit IRC
13:16:17 *** jervin has joined #gnucash
13:44:58 <krumel> Thanks, warlord
13:52:50 *** sbluhm has joined #gnucash
13:52:50 *** ChanServ sets mode: +v sbluhm
13:54:01 *** jervin has quit IRC
13:55:57 *** David has quit IRC
13:56:06 *** David has joined #gnucash
13:56:55 <CDB-PHONE> @tell Chris I would not over engineer the tool and try to combine features like that or try and have an A leads to B relationship
13:56:55 <gncbot> CDB-PHONE: The operation succeeded.
14:19:50 *** sbluhm has quit IRC
14:20:35 *** prg has joined #gnucash
14:21:58 <prg> Hi! I'm tracking a few accounts in gnucash and it's working very well. However, on the summarybar, my grand total doesn't look like it's being calculated. I see "$, Grand Total: " on the summary bar with no monetary value attached to it.
14:22:20 <prg> Is there something extra I need to do so that gnucash can calculate the total value of my accounts?
14:24:14 *** frakturfreak has joined #gnucash
14:37:00 <warlord> prg, are you using multiple currencies?
14:39:35 <prg> Nope; everything should be USD
14:40:27 <warlord> Do you have numbers for Net Assets and Profits?
14:40:39 <prg> Yup; both net assets and profits look right
14:41:31 <warlord> Well, that's what you're supposed to see. The bug is that there shouldn't be a colon after "Grand Total". That's the label for what the other two values are showing you.
14:41:34 <prg> I'm going through and double checking that each of the accounts didn't somehow get on something other than USD
14:41:44 <warlord> If you click there you can select other totals to display
14:43:31 <prg> Okay thank you.. Although I think I am slightly confused about the contents of the statusbar... I'll show you exactly what I'm seeing in this paste https://pastebin.com/2Gas5Zab
14:43:53 <prg> I see a line with a "$, Grand Total" label and an a line below it with a "$:" label
14:43:57 <prg> Is this for multiple currencies?
14:44:32 <prg> to where "$, Grand Total" would show me the amount (in $) for lets say all my euro and usd if I had euro accounts?
14:45:57 <warlord> Yes.
14:46:16 <prg> Awesome! Okay - that makes perfect sense. Thanks for explaining
14:46:18 <warlord> I have $, Grand Total; $; <STOCK1>; <STOCK2>; ...
14:47:07 <prg> Oh i see! That makes sense. Thanks again.. My parents want to use gnucash so I'm trying to get to the bottom of all my questions before they end up asking me :)
14:47:55 *** sbluhm has joined #gnucash
14:47:55 *** ChanServ sets mode: +v sbluhm
14:54:55 <warlord> sounds like a great idea.
14:58:50 <krumel> How would I go about numbering invoices by year? E.g. 2020-013 should be the thirteenth invoice of year 2020…
15:02:58 <krumel> I could probably use 2020-%04li as number format. Will I run into issues when I reset the invoice counter at the turn of the year? Invoices will have the same "number" then.
15:18:12 <warlord> GnuCash doesn't care about the invoice numbers; you can name them whatever you want. So yes, you should be able to number them by year that way and reset on Jan 1
15:37:25 *** jw4 has quit IRC
15:38:03 *** jw4 has joined #gnucash
15:38:03 *** ChanServ sets mode: +v jw4
15:38:14 <frakturfreak> clear
15:38:23 <frakturfreak> sorry wrong window
16:11:54 <krumel> So when I want to create a receipt from an invoice, even if I have the invoice, I will always have to go Reports->Business->Receipt->Options then type in the invoice number and press ok?
16:21:04 <warlord> krumel, sorry, I honestly don't know. Never used that feature.
16:52:25 *** sbluhm has quit IRC
16:58:43 <krumel> What I really want to know is how easy it would be to create an invoice template that works for me and receipe seemed like a good starting point for writing an eguile template. Receipe doesn't seem to do anything fundamentally different than invoice.scm, but it uses an eguile template and has no toolbar button. There's a long wiki page on writing custom reports https://wiki.gnucash.org/wiki/index.php?title=Custom_Reports_Using_Eguile bu
16:58:43 <krumel> t even if I take the time to write my own custom invoice, the menu navigation that involves typing in the invoice id into the reports options menu wouldn't be satisfactory
16:59:15 *** Aussie_matt has joined #gnucash
17:12:04 *** frakturfreak has quit IRC
17:27:08 *** Mechtilde has quit IRC
17:28:58 *** David has quit IRC
17:29:14 *** David has joined #gnucash
17:42:10 *** krumel has quit IRC
18:19:35 *** chris has joined #gnucash
18:19:35 *** ChanServ sets mode: +v chris
18:19:35 *** gncbot sets mode: +o chris
18:36:07 <chris> CDB-Man sure however the action list will then be: Buy Sell ROC ND SS DIV ROC+Buy DIV+Buy
18:37:33 <CDB-PHONE> dunno if roc needs a +buy option
18:38:01 <chris> ok
18:38:19 <chris> SS + CashInLieu => SS + Buy?
18:39:04 <chris> The idea is show minimum fields, with additional fields unlocked if buying more stock with the cashout
18:39:22 <CDB-PHONE> Hmm
18:39:52 <CDB-PHONE> i guess it depends on the broker whether a reinvestment on ROC is allowed
18:40:26 <CDB-PHONE> ROC plus buy is more likely than SS plus buy
18:42:18 <chris> your datafile+xls has at least clarified that we'd need only 4 accounts for Cash/Capg/Divi/Fees - this is good progress
18:48:31 <chris> if we don't want to split between stock-activity and user-activity, then I'd leave it as Buy Sell ROC ND SS DIV, and an ANY/ADV action - unlocks all fields, no restriction. But this one is exactly the same as the register, with same error-prone manual calculations
18:50:16 *** guak has quit IRC
18:51:41 <jralls> chris Does "show minimum fields" mean that you plan to hide the ones that aren't used?
18:52:14 <chris> either - they are currently simply disabled - but can be hidden too
18:58:16 <chris> anyway - I'm floating ideas around
18:59:44 <chris> gtg
19:00:35 <jralls> chris, disabled is OK, hidden is discouraged by most HIGs.
19:00:41 <CDB-PHONE> I would keep them visible but disabled
19:00:59 <CDB-PHONE> [18:48] (@chris) if we don't want to split between stock-activity and user-activity,
19:01:06 <CDB-PHONE> not sure what your mean by this
19:01:36 <CDB-PHONE> Div+buy is definitely something that can go into default option
19:02:16 <CDB-PHONE> the other buy combinations with SS and ROC perhaps we simply say it is outside the scope of this tool
19:02:22 <CDB-PHONE> given how rare they are
19:02:28 <CDB-PHONE> and the user can manual enter
19:08:34 *** chris has quit IRC
19:10:10 *** krumel has joined #gnucash
19:15:47 *** krumel has quit IRC
19:31:49 *** jervin has joined #gnucash
19:32:49 *** jcarl43 has quit IRC
19:36:45 *** jervin has quit IRC
20:02:19 *** sergiomiguelrp has joined #gnucash
20:06:48 *** storyjesse has joined #gnucash
20:18:30 *** bertbob has quit IRC
20:26:45 *** bertbob has joined #gnucash
20:26:46 *** ChanServ sets mode: +v bertbob
20:43:47 *** sergiomiguelrp has quit IRC
20:58:00 *** storyjesse has quit IRC
22:13:07 *** bertbob has quit IRC
22:17:23 *** bertbob has joined #gnucash
22:17:23 *** ChanServ sets mode: +v bertbob
22:25:38 *** chris has joined #gnucash
22:25:39 *** ChanServ sets mode: +v chris
22:25:42 *** gncbot sets mode: +o chris
22:34:50 *** ArtGravity has quit IRC
22:37:28 <chris> cdb jralls ok it means the dialog is fine as it is
22:38:31 <chris> I'd understand DIV/ND/SS/ROC will never record capgains
22:48:23 <CDB-PHONE> I need to double check if ND can involve cap gains
22:48:35 <CDB-PHONE> I wouldn't write that one off yet
22:49:06 <CDB-PHONE> my memory says no, but your comment on my screenshot suggests I should check it again
22:56:38 <CDB-PHONE> this weekend that is :)
23:06:54 *** bertbob has quit IRC
23:11:56 *** bertbob has joined #gnucash
23:11:56 *** ChanServ sets mode: +v bertbob