2017-04-04 GnuCash IRC logs
01:03:12 *** Mechtilde has joined #gnucash
01:23:45 *** O01eg has quit IRC
01:32:50 *** warlord has quit IRC
01:33:05 *** warlord has joined #gnucash
01:33:05 *** gncbot sets mode: +o warlord
01:48:34 *** Mechtilde has quit IRC
01:51:39 *** fell_ has joined #gnucash
01:53:58 *** fell has quit IRC
02:42:07 *** fabior has joined #gnucash
03:04:19 *** GabrieleV has quit IRC
03:06:28 *** GabrieleV has joined #gnucash
03:20:33 *** linas has joined #gnucash
03:29:36 *** linas has quit IRC
03:31:42 *** linas has joined #gnucash
03:37:53 *** mrklintscher has joined #gnucash
03:39:46 *** linas has quit IRC
03:49:08 *** gr8kodr has joined #gnucash
03:51:26 <gr8kodr> trying to setup Currency accounts so I can use Lots to track FX, are there any help pages available?
03:53:30 *** linas has joined #gnucash
03:54:39 <gr8kodr> from what I have found so far, I can create a "Stock" account, but if I try to select a Currency Commodity it jumps back to "AMEX" type and a blank field
04:24:07 *** linas has quit IRC
04:37:52 *** linas has joined #gnucash
04:56:00 *** linas has quit IRC
04:56:36 *** linas has joined #gnucash
05:09:52 *** linas has quit IRC
05:28:21 *** Wolf has quit IRC
05:51:26 *** fekepp has joined #gnucash
05:55:54 *** simon_ has quit IRC
06:28:41 *** To7 has quit IRC
06:38:21 *** Jimraehl1 has joined #gnucash
06:40:55 *** Jimraehl1 has left #gnucash
07:02:54 *** fabior has quit IRC
07:17:21 *** Cyp_ has joined #gnucash
07:17:42 <Cyp_> Hi, is the gnucash.org site currently down?
07:21:24 *** linas has joined #gnucash
07:21:35 <Cyp_> Is https://sourceforge.net/projects/gnucash/ the official place to download from? (I can't get to the site, so can't really check if that's what it says.)
07:30:40 *** linas has quit IRC
07:31:00 *** linas has joined #gnucash
07:40:43 *** User has joined #gnucash
07:43:23 *** User_ has joined #gnucash
07:43:37 *** storyjesse has joined #gnucash
07:44:46 *** To7 has joined #gnucash
07:45:26 *** User has quit IRC
07:49:22 *** tuxd00d has quit IRC
08:18:29 *** tuxd00d has joined #gnucash
08:26:04 *** mlncn has joined #gnucash
08:30:34 *** mrklintscher has quit IRC
08:32:32 <warlord> Cyp_: Yes, the site is down. There's a hardware problem. It's being worked on. But yes, SF is the official download site.
08:33:47 <warlord> gr8kodr: Stock/Mutual accounts cannot hold a "currency". Alas, there's really no way to use Lots to track foreign exchanges.
08:35:00 *** mrklintscher has joined #gnucash
08:52:24 *** fabior has joined #gnucash
09:10:20 *** KaiForce has joined #gnucash
09:46:41 *** linas has quit IRC
09:48:19 *** linas has joined #gnucash
09:55:03 *** linas has quit IRC
09:55:26 *** linas has joined #gnucash
10:08:12 *** MrKeuner has joined #gnucash
10:09:03 <MrKeuner> hi, can I duplicate the whole subtree Investments::Retirement to Investments::Retirement2, for example?
10:09:21 <MrKeuner> source subtree is empty
10:09:28 <MrKeuner> as in no transactions
10:15:15 *** fekepp has quit IRC
10:16:02 *** storyjesse has quit IRC
10:17:46 <warlord> MrKeuner: not easily. One way you can do it is to export your account tree to a new file, then open that new file and prune out everything but the tree you want to duplicate. Save that as uncompressed XML, and then turn that into a Hierarchy Template.
10:18:11 <warlord> Then you can use the Hierarchy Assistant to load that in.
10:25:22 *** fekepp has joined #gnucash
10:28:24 *** fekepp has quit IRC
10:38:15 *** fell_ is now known as fell
10:38:25 *** gncbot sets mode: +o fell
10:41:01 *** azwieg103 has quit IRC
10:48:50 <MrKeuner> warlord, all right, thank you.
11:07:52 <warlord> you're welcome
11:17:19 *** kael has joined #gnucash
11:24:05 *** fekepp has joined #gnucash
11:31:36 *** MoeD has joined #gnucash
11:34:42 *** MoeD has quit IRC
11:36:30 *** fekepp has quit IRC
11:36:59 *** tuxd00d has quit IRC
11:37:07 *** fekepp has joined #gnucash
11:38:06 *** tuxd00d has joined #gnucash
11:57:47 *** linas has quit IRC
11:59:15 *** tuxd00d has quit IRC
11:59:19 *** fekepp has quit IRC
12:00:58 *** chf has joined #gnucash
12:12:26 *** kael has quit IRC
12:13:15 *** linas has joined #gnucash
12:16:32 *** mlncn has quit IRC
12:20:24 *** linas has quit IRC
12:21:56 *** linas has joined #gnucash
12:24:33 *** fekepp has joined #gnucash
12:24:43 *** fekepp has quit IRC
12:27:41 *** tuxd00d has joined #gnucash
12:28:06 *** linas has quit IRC
12:28:38 *** linas has joined #gnucash
12:29:08 *** rickoehn has quit IRC
12:29:15 *** rickoehn has joined #gnucash
12:31:14 *** O01eg has joined #gnucash
12:33:25 *** fabior has quit IRC
12:38:37 *** tuxd00d has quit IRC
12:41:33 *** tuxd00d has joined #gnucash
12:48:47 <jralls> gr8kodr: STOCK and FUND accounts can use only non-currency commodities and all other types of account can use only currencies. FX trading wasn't a use case the designers considered. Sorry.
12:50:34 <jralls> Cyp_: Yes, www.gnucash.org has a hardware problem. Yes, the downloads at SourceForge are official downloads and are in fact where the links on www.gnucash.org point.
12:59:13 *** kael has joined #gnucash
12:59:50 *** kael has quit IRC
12:59:53 <Cyp_> warlord, jralls: Ok, thanks.
13:05:28 *** kael has joined #gnucash
13:06:02 *** chf has quit IRC
13:08:39 *** kael has quit IRC
13:09:29 *** chf has joined #gnucash
13:12:57 *** mrklintscher has quit IRC
13:21:45 *** mlncn has joined #gnucash
13:30:06 *** mlncn has quit IRC
13:40:31 *** linas has quit IRC
13:48:09 *** kael has joined #gnucash
13:49:47 *** Mechtilde has joined #gnucash
13:53:35 *** Mechtilde has quit IRC
13:53:54 *** Wolf has joined #gnucash
13:59:57 *** mlncn has joined #gnucash
14:00:46 <warlord> Hi Wolf
14:01:45 *** simon_ has joined #gnucash
14:06:30 *** mlncn has quit IRC
14:07:05 *** Mechtilde has joined #gnucash
14:15:38 *** Mechtilde has quit IRC
14:17:45 *** mlncn has joined #gnucash
14:21:50 *** kael has quit IRC
14:23:54 *** tuxd00d has joined #gnucash
14:25:44 *** Wolf has quit IRC
14:43:10 *** frakturfreak has joined #gnucash
14:48:08 *** mlncn has quit IRC
14:50:56 *** fabior has joined #gnucash
14:52:53 *** Mechtilde has joined #gnucash
15:11:12 *** Mechtilde has quit IRC
15:21:21 *** linas has joined #gnucash
15:29:13 *** wolf has joined #gnucash
15:29:18 <wolf> Hm
15:29:56 <wolf> Temporarily took out a psu from another desktop
15:30:01 <wolf> Turns on
15:30:06 <wolf> HDD's on
15:30:11 <wolf> er the light
15:30:30 <wolf> but no display, keyboard, nor net appears to be there
15:31:11 <warlord> Hmm. Hopefully it's not a bad mobo.
15:37:05 *** Robert has joined #gnucash
15:39:58 <wolf> I hear no hdd clicking,
15:40:06 <wolf> It skips post when I provide power
15:40:22 <wolf> skips as it doesn't turn off after a second or two
15:40:44 *** linas has quit IRC
15:44:56 <wolf> warlord, if you have no magic spells I could try to cast, I will go get a new box
15:45:21 <warlord> Are fans running?
15:45:26 <wolf> Yea
15:45:33 <warlord> If you don't hear a POST beep, tho....
15:45:48 <wolf> SB light on, no beep.
15:46:23 <warlord> Everything is plugged in? You're not missing a plug somewhere? (well, you did unplug the old PSU so you should know everywhere it WAS plugged in)
15:46:44 <warlord> I can't think of anything else, if this PSU is "known good" ...
15:46:55 <warlord> You could try to re-seat the RAM and such...
15:47:07 <wolf> Ripped it out of my box I was using an hour ago
15:47:13 <wolf> ok
15:47:42 <warlord> Okay, then same to assume the PSU is good, so either something came unseated or the mobo is bad.
15:54:13 *** gnomeirc has quit IRC
15:55:28 *** gnomeirc has joined #gnucash
15:55:52 <wolf> CPU fan likes to turn off after a few seconds on attempts
15:56:39 <wolf> Gonna get a new box
15:57:15 <wolf> However I see a potential problem: there is a pata hdd that connects to the mobo directly
15:57:35 <warlord> UH OH!
15:59:10 <wolf> I did find a pci card for it though
16:00:18 <warlord> phew
16:02:24 <gr8kodr> warlord: I found that if I enter as a "Funds Transfer" then check lots on either account used in transfer window, I can see the lots :)
16:05:20 *** linas has joined #gnucash
16:08:16 <gr8kodr> mainly wanting to check losses on Paypal transaction to or from home currency, when payment involves multiple lots, so that will work well enough for my purposes
16:10:08 *** linas has quit IRC
16:10:33 <warlord> Okay
16:28:59 *** frakturfreak has quit IRC
16:41:32 *** kael has joined #gnucash
16:48:05 *** kael has quit IRC
17:01:31 <MrKeuner> when keeping account of 401k how does one should import these transactions in Gnucash? Should I simply enter the balance every month and separate employee contributions from employer contributions and dividends or is there a notion of fund level tracking, number of stocks, price of stock etc.?
17:05:17 <warlord> I think it's up to you.
17:05:30 <warlord> I just keep a total of my contributions w/o tracking the value.
17:11:55 *** kael has joined #gnucash
17:13:30 *** User_ has quit IRC
17:31:48 *** fabior has quit IRC
17:51:40 *** mlncn has joined #gnucash
17:55:05 *** ArtGravity has joined #gnucash
17:57:05 *** KaiForce has quit IRC
18:07:43 *** mlncn has quit IRC
18:09:15 *** mlncn has joined #gnucash
18:13:08 <ArtGravity> anyone know why the (Gnucash 2.6.12) Payable Aging report shows all my bills as 91+ days past due?
18:14:56 *** kael has quit IRC
18:20:12 *** User_ has joined #gnucash
18:23:04 *** To7 has quit IRC
18:40:15 *** mlncn has quit IRC
18:41:52 <MrKeuner> my bank exports withdrawl and deposit on separate columns and withdrawals as negative and deposits as positive. I suspect this is an issue for GNUcash, isn't it?
18:57:48 <MrKeuner> withd, dep, and bal are listed as separate columns. withd is listed as negative. Should I simply edit the CSV and remove the minuses?
18:57:56 <MrKeuner> or am I doing something worng?
19:07:25 <jralls> MrKreuner: Dunno if you're doing something wrong or not. If changing the sign makes the import work editing it is probably the easiest solution.
19:09:52 <MrKeuner> jralls, I also noticed an OFX option when exporting from my bank
19:10:08 <MrKeuner> BUt it seems that deposits to my checking account are shown as negative
19:10:14 <MrKeuner> withdrawals as positive
19:10:57 <MrKeuner> qfx and qbo are also possible
19:11:05 <MrKeuner> didn't try them though
19:11:48 <jralls> Well, ordinarily it's much better to use OFX. QFX is the same as OFX, though they might not have messed up the signs. GnuCash doesn't know how to interpret QBO.
19:13:19 *** mlncn has joined #gnucash
19:13:25 <MrKeuner> jralls, could it be that the intermediate dialog in GNUCash is making me confused? The one that I am supposed to attach a transaction to a second account
19:13:43 <MrKeuner> 2.6.4 here
19:14:06 <MrKeuner> OK, I'll just complete importing and see if the signs are reversed
19:14:08 <jralls> I don't know. How might it be confusing?
19:14:18 <MrKeuner> I'll tell in a sec
19:15:46 <MrKeuner> for instance this is an example line in the generic import transaction matcher dialog
19:15:48 *** kael has joined #gnucash
19:16:27 <MrKeuner> new, unbalanced, (need acc to transfer -$2500)!
19:16:56 <MrKeuner> this transaction is actually a deposit to the checking acc I am trying to import it into
19:17:04 <MrKeuner> but shows as negativ
19:17:35 <MrKeuner> similary a transacion that is a withdrawal is shown as non-negative value
19:17:47 <MrKeuner> jralls, makes sense?
19:21:59 <ArtGravity> MrKeuner: I always use QFX when available. It's a seamless process.
19:27:48 *** kael has quit IRC
19:35:15 <MrKeuner> ArtGravity, jralls I think I was right. generic import transaction matcher dialog shows the signs in reverse for some reason I do not know.
19:35:35 <MrKeuner> after finalizing the import the value signs are correctly reflected in the account
19:39:29 *** User_ has quit IRC
19:46:19 <jralls> MrKeuner: Sorry, I went afk for a few minutes. I thought that might be the case, that GnuCash can figure out from the OFX tags what to do with the amounts.
19:56:38 *** tuxd00d has quit IRC
19:56:42 *** ArtGravity has quit IRC
20:00:01 *** rickoehn has quit IRC
20:00:52 <MrKeuner> another question, in the generic import transaction matcher, I see multiple color bars. what does rrryygg mean versus a rrryyggg?
20:01:26 <MrKeuner> some confidence?
20:17:42 <jralls> Yes, that's an indication of how confident the matcher is that it has found a matching transaction and so shouldn't import the one in question. You should inspect the match by double-clicking it to be sure that you agree. If you don't, click the left-most box. If in doubt, import: You can always delete but if you let the importer ignore then you'll have to enter it manually.
20:19:24 <MrKeuner> jralls, Which one shouldn't be imported? rrryygg or rrryyggg? is rryggg also possible for instance?
20:21:30 <jralls> Umm, by "rrryyggg" you're referring to the colored bar-graph in the transaction matcher line, right?
20:21:43 <MrKeuner> jralls, correct
20:22:10 <MrKeuner> rrryyggg is three red bars 2 yellow bars and three green bars
20:22:53 <MrKeuner> rryggg is a different combination, I am wondering which one show more confidence
20:23:26 <jralls> So the color of each element is hard-coded, it's intended to look like a bar-meter on an instrument panel. The more elements that are lit up the more confident the matcher is that it has found that transaction already in the account. Past a certain threshold it will color the transaction red.
20:23:53 <MrKeuner> I see, rryggg is not a possible combination then right
20:23:56 <MrKeuner> ?
20:23:57 <jralls> Which means that it doesn't intend to import that transaction because it's quite sure that it's already there.
20:24:04 <jralls> Correct.
20:24:30 <MrKeuner> got it thanks.
20:24:49 <jralls> However, it's often wrong. Kind of like me, "often wrong, seldom in doubt". ;-)
20:25:11 <MrKeuner> hahaha, sure so like me
20:25:26 <jralls> So you should double click on each one and examine the apparently matched transaction to make sure that it's the same one.
20:25:27 <MrKeuner> I am only 43 but often find myself mis calculating simple algebra
20:26:17 <MrKeuner> I understand, that's what I do but I also appreciate what Gnucash thinks as a second eye
20:26:36 <MrKeuner> also, I have a money market account which I sue to collect different funds, would the correct way to handle this like this: Assets::Current Assets::Bank::Money Market together with an Assets::Current Assets::Bank::Money Market::fund foo?
20:26:56 <MrKeuner> first get from checking to Money Market and then move the funds to ...::fund foo?
20:27:30 <MrKeuner> I started by making money market a placeholder account but I am thinking I made a wrong decision
20:32:19 <MrKeuner> jralls, this was my last question I promise :)
20:32:24 <jralls> A placeholder account can't take new splits, so if it's a real account then you don't want that. The intended purpose of a placeholder account is as a parent, like "Assets" or a bank where you have more than one actual account, e.g. Assets:Deutsch Bank:Checking, Assets:Deutsch Bank:Savings.
20:33:00 <MrKeuner> got it
20:33:10 <MrKeuner> thank you very much
20:33:27 <jralls> You're welcome.
20:38:41 *** mlncn has quit IRC
20:42:04 <Hello71> I thought it was Deutsche
21:04:11 *** fell has quit IRC
21:31:14 *** mlncn has joined #gnucash
21:52:22 *** fell has joined #gnucash
23:02:02 *** Robert1 has joined #gnucash
23:03:23 *** Robert has quit IRC
23:10:35 <Robert1> hello
23:12:37 *** Robert1 has left #gnucash
23:48:18 *** tuxd00d has joined #gnucash