2014-10-20 GnuCash IRC logs
00:05:11 *** mlncn-agaric has quit IRC
00:33:38 *** andy has quit IRC
01:00:30 *** GabrieleV_ has joined #gnucash
01:01:10 *** GabrieleV has quit IRC
01:01:11 *** GabrieleV_ is now known as GabrieleV
01:13:13 *** jralls has quit IRC
01:13:31 *** jralls has joined #gnucash
01:13:33 *** gncbot sets mode: +o jralls
01:20:40 *** MechtiIde has joined #gnucash
01:34:52 *** jralls has quit IRC
01:35:43 *** jralls has joined #gnucash
01:35:44 *** gncbot sets mode: +o jralls
01:50:31 *** GabrieleV_ has joined #gnucash
01:51:08 *** GabrieleV has quit IRC
01:51:08 *** GabrieleV_ is now known as GabrieleV
01:51:28 *** fell has joined #gnucash
01:51:29 *** gncbot sets mode: +o fell
02:14:35 *** MechtiIde has quit IRC
02:22:43 *** uXus has quit IRC
02:27:25 *** uXus has joined #gnucash
02:31:34 *** fell has quit IRC
02:33:16 *** O01eg has quit IRC
02:35:26 *** Coderjoe has quit IRC
02:40:48 *** Coderjoe has joined #gnucash
02:41:29 *** Krzysiek_K has left #gnucash
02:58:04 *** GabrieleV_ has joined #gnucash
02:58:18 *** GabrieleV has quit IRC
02:58:18 *** GabrieleV_ is now known as GabrieleV
03:11:12 *** fell has joined #gnucash
03:11:12 *** gncbot sets mode: +o fell
03:35:34 *** GabrieleV_ has joined #gnucash
03:36:05 *** GabrieleV has quit IRC
03:36:06 *** GabrieleV_ is now known as GabrieleV
03:40:20 *** wol has joined #gnucash
03:44:27 *** rjsetford has left #gnucash
05:11:22 *** wol has quit IRC
05:14:22 *** wol has joined #gnucash
06:37:25 *** Jimraehl1 has left #gnucash
06:38:28 *** Jimraehl1 has joined #gnucash
07:11:28 *** aqua___ has joined #gnucash
07:28:02 *** mlncn-agaric has joined #gnucash
07:38:50 *** wol has quit IRC
07:56:37 *** GabrieleV_ has joined #gnucash
07:56:41 *** GabrieleV has quit IRC
07:56:41 *** GabrieleV_ is now known as GabrieleV
08:18:12 *** nnw has joined #gnucash
08:19:39 *** nnw has quit IRC
08:21:41 *** AndreeeCZ has joined #gnucash
08:40:47 *** Gbarr has joined #gnucash
08:41:37 *** GabrieleV_ has joined #gnucash
08:41:45 *** GabrieleV has quit IRC
08:41:45 *** GabrieleV_ is now known as GabrieleV
08:42:56 *** himaxx has joined #gnucash
08:44:48 *** Gbarr has quit IRC
08:46:26 *** Gbarr has joined #gnucash
08:47:12 *** himaxx has quit IRC
08:49:16 *** andy has joined #gnucash
08:54:27 *** aqua___ has quit IRC
09:26:58 *** lmat has joined #gnucash
09:35:51 *** mlncn-agaric has quit IRC
09:42:03 *** wol has joined #gnucash
09:47:32 *** aqua___ has joined #gnucash
10:20:09 *** Gbarr1 has joined #gnucash
10:20:10 *** Gbarr has quit IRC
10:34:48 *** mlncn-agaric has joined #gnucash
10:37:26 *** fell_ has joined #gnucash
10:37:27 *** gncbot sets mode: +o fell_
10:39:46 *** fell has quit IRC
11:14:45 *** O01eg has joined #gnucash
11:18:22 *** Gbarr1 has quit IRC
11:25:01 *** jralls has quit IRC
11:25:42 *** jralls has joined #gnucash
11:25:43 *** gncbot sets mode: +o jralls
11:47:17 *** mlncn-agaric has quit IRC
11:59:26 *** MechtiIde has joined #gnucash
12:06:23 *** aqua___ has quit IRC
12:32:05 *** Gbarr has joined #gnucash
12:35:14 *** mlncn-agaric has joined #gnucash
13:16:29 *** aqua___ has joined #gnucash
13:33:19 <lmat> marktraceur: I don't use sx to cover school loans. Gnucash does a good job of remembering the last tx, and filling it in. Then, I go in and adjust the interest and principal split. If I make an extra payment, I have to do that over phone, and write a separate tx for that.
13:33:37 <lmat> marktraceur: It screws up the next scheduled payment's P/I ratio.
13:33:53 <marktraceur> Right.
13:34:01 <marktraceur> I'm automatically paying extra now
13:34:15 <marktraceur> So I figure I'm just not going to be able to do anything with gnucash
13:34:19 <lmat> marktraceur: It would be difficult for the loan calculator build into Gnucash to be able to capture all of this. For instance, with school loans my interest acrues daily, and compounds annually.
13:34:25 <marktraceur> I mean, other things, but not with the loan
13:34:35 <lmat> marktraceur: Perhaps nothing automatic anyway :)
13:34:42 <marktraceur> lmat: That must be what happens to mine, I didn't really understand it
13:34:46 <marktraceur> Anyway
13:34:48 *** jralls has quit IRC
13:34:57 <marktraceur> There's definitely a way to calculate it all, just not in gnucash apparently
13:35:07 <marktraceur> Maybe I'll figure out a way to run a cronjob every month that fixes it all.
13:35:29 <kimmo2> I don't think scheduled transactions work well for loan repayment
13:35:34 <lmat> marktraceur: And there are a lot of other loan configurations that gnucash would have to be able to capture (continuous compounding, different rates of accrual and compounding, etc.).
13:35:46 *** jralls has joined #gnucash
13:35:46 *** gncbot sets mode: +o jralls
13:35:58 <kimmo2> it might, if you do an sx for just the payment, and do the interest payments separately
13:36:01 <marktraceur> Right.
13:36:23 <marktraceur> I'm not too worried about it
13:36:26 <lmat> marktraceur: Right, I can't imagine using the loan repayment tool in GnuCash for any of my loans. I *never* repay loans "normally". And really, Gnucash isn't meant for that ^_^. I think having that helper is probably more of a liability because there's so much that it can't do.
13:36:27 <kimmo2> I'm assuming you have a flat amount to pay every month, just the interest-to-capital ratio changes
13:36:36 <lmat> kimmo2: pardon?
13:36:45 <lmat> kimmo2: How can you do the interest payments "separately"?
13:36:47 <marktraceur> kimmo2: Yeah, that's roughly correct
13:37:13 <kimmo2> lmat, have a scheduled transaction for cash -> debt, and then charge the interest on the debt account
13:37:29 <kimmo2> the cash -> debt remains the same, just the interest expense changes
13:37:34 <lmat> kimmo2: eek...that's not GAAP, right?
13:37:44 <lmat> kimmo2: Since it's not actually compounding.
13:38:40 <kimmo2> as long as it's clear what's happening it should be fine
13:39:05 <kimmo2> and personal books can bend GAAP quite a bit
13:54:20 *** AndreeeCZ has quit IRC
13:56:37 *** MechtiIde has quit IRC
13:57:08 *** wol has quit IRC
14:14:25 *** Gbarr has quit IRC
14:14:47 *** Gbarr has joined #gnucash
14:20:23 *** mlncn-agaric has quit IRC
15:01:29 *** Hinnerk has joined #gnucash
15:02:04 <Hinnerk> hi
15:03:47 *** mlncn-agaric has joined #gnucash
15:04:43 <Hinnerk> is there documentation on the various different columns in the CoA? Not sure about the english terms, in german the is "Aktuell (EUR)", "Gesamt (EUR)", "Summe", "Saldo (EUR)", ... i think the all show the same result?
15:07:47 *** marktraceur has left #gnucash
15:41:21 <lmat> Hinnerk: I'm going to go ahead and say, by faith, that they aren't determined by the same formulae :)
15:42:00 <lmat> Hinnerk: For instance, if there is activity in some of the accounts in a different period than the "current" period, I would guess that Aktuell and Summe will be different...perhaps!
15:42:07 <lmat> Hinnerk: What does Saldo mean?
15:42:29 <Hinnerk> I figured out one: "Aktuell" is balance today, while most others are last balance. e.g. if there is a transaction in the future, it makes a difference
15:42:42 <lmat> Hinnerk: Excellent.
15:43:55 <Hinnerk> saldo means "account balance" according to leo. How is that different from sum?
15:44:32 <lmat> Hinnerk: I would calculate the account balance using a sum of all transactions...not sure :)
15:45:30 <lmat> Hinnerk: In Anglish, we have "Balance" and "Total" which probably correspond?
15:45:40 <Hinnerk> I guess so.
15:46:08 <warlord> Saldo == Balance. Summe == Total. Aktuell == Present.
15:46:24 <Hinnerk> Is there a fast way of seeing "Market Value" and "Book Value"?
15:46:40 <warlord> Hinnerk: what do you mean by "Market Value" and "Book Value"?
15:46:58 <Hinnerk> in case of common stock.
15:47:21 <warlord> Gesamt is also "Total".
15:47:23 <Hinnerk> by book value I mean "Price paid"
15:47:31 <warlord> No, there is no column for that.
15:47:58 <warlord> You can get "Market Value" which would be "Total (<CUR>)"
15:48:06 <Hinnerk> so there are 3 or 4 columns for the same thing, but book and market I can't see?
15:48:07 <warlord> Gesamt?
15:48:17 <warlord> There is no column for "book?
15:48:19 <warlord> "
15:48:35 <warlord> The 3 or 4 columns are not necessarily the same.
15:48:48 <Hinnerk> they seem to be :)
15:49:02 <warlord> Total and Total (<CUR>) will show different things based on the account commodity
15:50:02 <warlord> I'm not 100% sure the difference between Total and Balance. One might not include subaccounts?
15:50:05 <Hinnerk> I have an account with common stock, finance quote ... Aktuell = Saldo = Gesamt
15:50:57 <warlord> Hinnerk: That's not too surprising.. Unless you have transactions in the future.
15:51:21 <Hinnerk> ok. then, how do I see "Book Value" in the sense of price paid?
15:51:48 <warlord> Hinnerk: how many times do I have to repeat that there is column for that.
15:52:09 <Hinnerk> until I find it :)
15:52:23 <warlord> You wont find it until you actually implement it and send in the patch.
15:53:01 <Hinnerk> ah, that there "isn't"
15:53:24 <warlord> Sorry, there IS NOT such a column
15:53:50 <Hinnerk> but isn't that a bit strange? seems to me that this should be standard accounting....?
15:53:58 * warlord shrugs
15:54:22 <warlord> Run the Advanced Portfolio report?
15:55:01 <Hinnerk> my impression has been for a long time, that that report isn't trustworthy.... is there reason to blieve otherwise?
15:56:19 <warlord> Uhhh... This is the first I've heard.
15:57:02 <Hinnerk> it's always so difficult to judge if there is irony in writing ...
15:57:35 <lmat> Hinnerk: Which report isn't trustworthy? The chart of accounts?
15:57:44 <Hinnerk> Advanced Portfolio
15:57:48 <warlord> lmat: I thnk he means the Advanced Portfolio
15:57:51 <lmat> ahh
15:58:06 <warlord> I dont know why he'd think it is not trustworthy
15:58:25 <lmat> I mean...add this, subtract that...it does exactly what it was coded to do :)
15:58:28 <lmat> Now me...I might not be trustworthy
15:58:30 <Hinnerk> I ran it a few times intially and it always showed strange results.
15:58:40 <Hinnerk> ok, mlet me check it out once more...
15:58:41 <lmat> Hinnerk: Did you figure out why?
15:58:56 <Hinnerk> i fiddled a bit with it but gave up eventually.
16:00:01 <warlord> it does require you to input your transactions in a very specific way
16:01:48 <lmat> I enter all my transactions in a specific way ;-)
16:03:08 <warlord> lmat: it might not be the specific way that the report requires ;)
16:03:10 <Hinnerk> Well, maybe that's it. looks good now. MAybe back then I didn't enter dividends properly
16:03:30 <lmat> Hinnerk: Glad it's working out for you!
16:04:17 <Hinnerk> Currently my portfolio is a bit empty (bought a house...), so I'll keep a wary eye on it for a while, but indeed, it seems ok now.
16:04:49 <lmat> Hinnerk: But is your *house* empty :-P
16:05:16 <Hinnerk> well, it's not filled with shares
16:06:59 <Hinnerk> puuh, that's good to have overcome that old judgement of the report. I remeber having seen a lot of discussion on this report in the mailing list, which didn't directly enhence my trust :)
16:07:21 *** jralls has quit IRC
16:07:42 *** jralls has joined #gnucash
16:07:43 *** gncbot sets mode: +o jralls
16:07:46 <Hinnerk> other question:
16:07:57 <Hinnerk> multi comlun reports.
16:08:11 <Hinnerk> is this just throwing together various reports?
16:08:14 <warlord> yes
16:08:33 <Hinnerk> so even if it is the same report, it will not e.g. reuse line names?
16:08:37 <Hinnerk> say for balance sheet
16:08:48 <Hinnerk> and I want to show current and previous period?
16:09:39 <Hinnerk> so in that case: Did somebody already create such a report that show current and previous at the same time, next to each other?
16:10:42 <Hinnerk> I'm always a bit disappointed when I search the web for custom reports in gnucash - apparently nobody wrote and published any...
16:10:55 <Hinnerk> or am I missing the obvious place to look at?
16:11:19 <warlord> correct
16:11:23 <warlord> No.
16:12:01 <warlord> Nobody (AFAIK) has written such a report. Everyone I know just runs the report twice and massages it in a document editor or spreadsheet
16:12:28 <warlord> Accountants usually need to add notes ... so that's a major reason they do it in a spreadsheet.
16:18:28 <Hinnerk> question about advanced portfolio:
16:18:45 <Hinnerk> I set it to also see account with balance zero
16:18:58 <Hinnerk> however, I used to have a different broker.
16:19:20 <Hinnerk> so for some shares, there are two accounts, possibly both empty now.
16:19:31 <Hinnerk> can I somehow force it to use the sum?
16:20:48 <warlord> i dont think so..
16:21:33 <Hinnerk> another question: When will the channel topic be updated? :)
16:29:34 <warlord> Probably once we figure out all the windows issues with 2.6.4
16:30:40 <Hinnerk> ohoh - still some pending?
16:30:54 <Hinnerk> admittedly, when I close GnuCash, it usually hangs.
16:31:21 <Hinnerk> thought it was my system though. works fine otherwise for me (GC)
16:36:26 <warlord> I believe that is still one of the issues.
16:36:34 <warlord> I wish fewer people would actually use WinBlows.
16:53:11 <lmat> warlord: I'll quote you for a long time on that one ;-)
16:53:43 <lmat> warlord: I expect there's some (currently) unbreakable synergy between accountants, Microsoft Excel, and Microsoft Windows :-(
16:55:16 *** mlncn-agaric has quit IRC
16:56:25 <kimmo2> there's an unbreakable synergy between windows and excel, and there's an unbreakable synergy between anyone, everyone and excel
17:00:24 *** mlncn-agaric has joined #gnucash
17:04:16 <warlord> {Open,Libre}Office works quite well
17:10:30 <Hinnerk> I'm out. Thx for the help!
17:10:36 *** Hinnerk has quit IRC
17:17:45 *** lmat has quit IRC
17:21:21 *** mlncn-agaric has quit IRC
17:21:55 *** mlncn-agaric has joined #gnucash
17:35:57 *** wol has joined #gnucash
17:37:43 *** wol has quit IRC
17:41:37 *** jralls has quit IRC
17:42:30 *** jralls has joined #gnucash
17:42:30 *** gncbot sets mode: +o jralls
18:10:58 *** fell__ has joined #gnucash
18:10:59 *** gncbot sets mode: +o fell__
18:13:39 *** aqua___ has quit IRC
18:14:39 *** GabrieleV_ has joined #gnucash
18:14:43 *** GabrieleV has quit IRC
18:14:43 *** GabrieleV_ is now known as GabrieleV
18:20:13 *** fell_ has quit IRC
18:47:45 *** mlncn-agaric has quit IRC
18:53:33 *** jralls has quit IRC
18:54:05 *** jralls has joined #gnucash
18:54:06 *** gncbot sets mode: +o jralls
19:09:40 *** GabrieleV_ has joined #gnucash
19:09:46 *** GabrieleV has quit IRC
19:09:46 *** GabrieleV_ is now known as GabrieleV
19:24:58 *** mlncn-agaric has joined #gnucash
19:27:34 *** mlncn-agaric has quit IRC
19:52:02 *** jralls has quit IRC
19:52:53 *** jralls has joined #gnucash
19:52:54 *** gncbot sets mode: +o jralls
19:53:50 *** mlncn-agaric has joined #gnucash
19:55:51 *** jralls has quit IRC
19:56:25 *** jralls has joined #gnucash
19:56:25 *** gncbot sets mode: +o jralls
20:04:24 *** fell__ has quit IRC
20:17:34 *** jralls has quit IRC
20:18:38 *** jralls has joined #gnucash
20:18:39 *** gncbot sets mode: +o jralls
21:06:56 *** Gbarr has quit IRC
21:08:10 *** Gbarr has joined #gnucash
22:19:40 *** GabrieleV_ has joined #gnucash
22:19:52 *** GabrieleV has quit IRC
22:19:52 *** GabrieleV_ is now known as GabrieleV
23:26:20 *** kpreid has quit IRC
23:26:36 *** kpreid has joined #gnucash