2015-03-04 GnuCash IRC logs
00:06:15 *** GabrieleV_ has joined #gnucash
00:06:20 *** GabrieleV has quit IRC
00:06:20 *** GabrieleV_ is now known as GabrieleV
00:24:37 *** jimvideo has quit IRC
00:33:50 *** O01eg has quit IRC
00:39:17 *** ErKa has quit IRC
01:10:18 *** keret has quit IRC
01:27:52 *** MechtiIde has joined #gnucash
01:28:37 *** jralls has joined #gnucash
01:30:46 <jralls> warlord: Yes, tomorrow afternoon.
01:39:09 *** Krzysiek_K has joined #gnucash
02:06:03 *** MechtiIde has quit IRC
02:25:37 *** cartsoftware has joined #gnucash
02:41:11 *** Krzysiek_K has quit IRC
03:08:56 *** gjanssens has joined #gnucash
03:11:16 *** GabrieleV_ has joined #gnucash
03:11:27 *** GabrieleV has quit IRC
03:11:27 *** GabrieleV_ is now known as GabrieleV
03:11:49 *** pacon has joined #gnucash
03:18:55 *** pacon has quit IRC
03:46:46 <gjanssens> fell, mikee, warlord can you op gncbot` please ?
03:47:29 *** mikee sets mode: +o gncbot`
03:47:39 <mikee> @nick gncbot
03:47:39 <gncbot`> mikee: Error: You don't have the admin capability. If you think that you should have this capability, be sure that you are identified before trying again. The 'whoami' command can tell you if you're identified.
03:48:20 <mikee> @nick gncbot
03:48:20 *** gncbot` is now known as gncbot
03:49:02 <mikee> gjanssens: Good morning.
03:49:25 <mikee> @op gjanssens
03:49:25 *** gncbot sets mode: +o gjanssens
03:52:10 <gjanssens> hi mikee an d thanks
03:54:02 *** jralls has quit IRC
03:54:50 *** jralls has joined #gnucash
03:59:46 *** fabior has joined #gnucash
04:04:57 *** jralls has quit IRC
04:10:53 *** pacon has joined #gnucash
04:12:26 *** a has joined #gnucash
04:23:50 *** pacon has quit IRC
04:24:41 *** pacon has joined #gnucash
04:28:40 *** cartsoftware has quit IRC
04:44:11 *** cartsoftware has joined #gnucash
04:55:35 *** jralls has joined #gnucash
04:56:30 *** a has quit IRC
05:05:24 *** jralls has quit IRC
05:36:06 *** jralls has joined #gnucash
05:37:12 *** jralls_ has joined #gnucash
05:37:12 *** jralls has quit IRC
05:38:15 *** jralls_ is now known as jralls
05:38:20 <jralls> @op
05:38:20 <gncbot> jralls: Error: You don't have the #gnucash,op capability. If you think that you should have this capability, be sure that you are identified before trying again. The 'whoami' command can tell you if you're identified.
05:38:51 *** gncbot sets mode: +o jralls
05:50:02 *** himaxx has joined #gnucash
05:52:30 *** himaxx has quit IRC
06:31:50 *** GabrieleV_ has joined #gnucash
06:31:50 *** GabrieleV has quit IRC
06:31:51 *** GabrieleV_ is now known as GabrieleV
06:40:21 *** Jimraehl1 has left #gnucash
06:46:55 *** Jimraehl1 has joined #gnucash
06:49:22 *** pacon has quit IRC
07:15:32 *** fabior has quit IRC
07:30:49 *** GabrieleV_ has joined #gnucash
07:31:50 *** GabrieleV has quit IRC
07:31:51 *** GabrieleV_ is now known as GabrieleV
07:44:35 *** jralls has quit IRC
07:45:30 *** jralls has joined #gnucash
07:45:31 *** gncbot sets mode: +o jralls
07:55:36 *** jralls has quit IRC
08:00:52 *** uXus has quit IRC
08:03:21 *** uXus has joined #gnucash
08:05:31 *** rickoehn has joined #gnucash
08:08:23 *** Hinnerk has joined #gnucash
08:08:25 <Hinnerk> hi
08:09:03 <Hinnerk> I'm experiencing the same problem that was discussed on GnuCash-User: Problem installing Crypt-SSLeay
08:09:14 <Hinnerk> Only, I don't understand the solution.
08:09:30 <Hinnerk> PPM downloads and installs all dependences anyway.
08:09:39 <Hinnerk> and I still get that error message.
08:10:00 <Hinnerk> Yesterday I uninstalled and upgraded PERL.
08:10:16 <Hinnerk> I went through the usual moves to get Prices/Quotes back to normal.
08:10:30 <Hinnerk> and that error stopped me on my track.
08:11:15 <Hinnerk> I'm using ActiveState Perl 5.20.1
08:11:49 <Hinnerk> Finance::Quote is version 1.37
08:11:55 <Hinnerk> GnuCash 2.6.5
08:22:02 <Hinnerk> Windows 7
08:28:33 *** andy has joined #gnucash
08:28:38 *** cartsoftware has quit IRC
08:31:02 *** fabior has joined #gnucash
08:32:57 <Hinnerk> also: Crypt-SSLeay is not offered under "All packages".
08:34:12 <gjanssens> Hinnerk: as far as I can see, the gnucash script is still trying to download this for Active Perl
08:34:20 <gjanssens> I'm testing a fix as we speak.
08:34:40 <gjanssens> Until that's released, you may have to resort to Strawberry perl
08:34:56 <Hinnerk> when will it be released?
08:34:56 *** lmat has joined #gnucash
08:36:28 <Hinnerk> anyway, is there a significant difference between the two distros?
08:38:09 <gjanssens> Release is expected end of March
08:39:14 <gjanssens> The only user visible difference between Active and Strawberry is that strawberry perl pops up a console window each time a script is activated, while active perl works completely in the background
08:39:33 <gjanssens> some prefer one or the other behaviour
08:40:21 <gjanssens> For our scripts the two flavours differ in that strawberry takes its extra modules from cpan (perl default repository)
08:40:32 <gjanssens> while active state maintains a ppm database
08:46:09 *** jralls has joined #gnucash
08:46:10 *** gncbot sets mode: +o jralls
08:49:46 *** a has joined #gnucash
08:56:14 *** jralls has quit IRC
09:01:19 <Hinnerk> ok, that worked.
09:01:26 <Hinnerk> another point of curiosity:
09:01:38 <Hinnerk> For one stock there was no price retrieved.
09:01:58 <Hinnerk> I'm a bit surprised, but it could be related to the stock not being traded too much.
09:02:14 <Hinnerk> is there a way of finding out, why no price was retrieved?
09:16:49 <gjanssens> I think you could manually call gnc-fq-dump (or "perl gnc-fq-dump") but the finer invocation details are beyond my knowledge
09:17:44 <Hinnerk> other question, same stock:
09:17:54 <Hinnerk> I currently use only EUR in gnucash.
09:18:05 <Hinnerk> however that particular stock is from the US.
09:18:26 <Hinnerk> Stock quotes in Europe are rare, in the US common for this particular stock.
09:18:49 <Hinnerk> If I change the price source to some US service... what will happen?
09:19:00 <Hinnerk> will it get a USD price and convert it properly?
09:19:22 <warlord> Hinnerk: it wont convert it properly, but if you give it the right code you might get a quote in another currency.
09:19:31 <warlord> E.g. XXXX.TO would give you CAD
09:19:41 <warlord> ... you just need the right symbol
09:19:51 <Hinnerk> that won't help. In the end I need only a EUR price.
09:20:26 *** ErKa has joined #gnucash
09:25:05 <warlord> Hinnerk: my point is tat you just need to fnd thge right symbol.
09:29:35 <gjanssens> Hinnerk: I tested the fixes for Active Perl. Got one error fixed, ran into another one.
09:29:50 <gjanssens> It looks like Strawberry is currently the better supported solution.
09:30:19 <gjanssens> And I have no time left to look into the new errors for a while...
09:34:35 <warlord> I thought jralls had a fix in place already, and was just waiting for the next release?
09:42:38 *** ErKa has quit IRC
09:43:15 *** cartsoftware has joined #gnucash
09:47:12 *** jralls has joined #gnucash
09:47:12 *** gncbot sets mode: +o jralls
10:00:24 *** jralls has quit IRC
10:25:57 *** ErKa has joined #gnucash
10:27:51 *** GabrieleV_ has joined #gnucash
10:28:28 *** GabrieleV has quit IRC
10:28:29 *** GabrieleV_ is now known as GabrieleV
10:28:54 *** lmat_ has joined #gnucash
10:32:51 *** lmat has quit IRC
10:51:44 *** jralls has joined #gnucash
10:51:44 *** gncbot sets mode: +o jralls
10:55:45 <Simon> is there an option I'm missing to stop GnuCash automatically adding prices based on entries in the register?
10:59:48 *** MechtiIde has joined #gnucash
11:00:11 *** a has quit IRC
11:00:57 *** jralls has quit IRC
11:06:13 *** lwells has quit IRC
11:08:07 *** nomeata has joined #gnucash
11:27:23 <Hinnerk> about the symbols: Yes, I have a symbol in place, but that means it takes the price from frankfurt, where it isn't traded in decent volume. I would prefer some US based one with proper currency conversion.
11:34:35 <warlord> The quote grabber does not perform currency conversion.
11:34:48 <warlord> You need to find a website that actually gives you quotes in the currency you desire
11:36:09 <Hinnerk> multiple sources europe didn't help
11:36:20 *** jlo has quit IRC
11:37:27 <warlord> yahoo_europe doesn't work?
11:38:46 <Hinnerk> it works, but it doesn't always give a price.
11:38:56 <Hinnerk> its not a problem of the module.
11:39:12 <Hinnerk> i think it is just the problem that the stock is traded in europe so rarely.
11:39:19 <Hinnerk> quite different in the us.
11:39:56 <warlord> Hinnerk: then your only option is to track the stock in USD
11:40:18 <Hinnerk> ok. but what are the ramifications of doing so?
11:40:32 <Hinnerk> I never had a second currency in GnuCash.
11:40:42 <Hinnerk> And am a bit hesitant to open up that bottle.
11:54:15 *** jralls has joined #gnucash
11:54:16 *** gncbot sets mode: +o jralls
11:59:29 *** GabrieleV has quit IRC
12:04:40 *** jralls has quit IRC
12:08:39 *** rpg has joined #gnucash
12:13:38 *** Hinnerk_ has joined #gnucash
12:17:23 <gjanssens> warlord: jralls fixed the installation part, but our gnc-fq-* scripts were still checking for obsolete modules
12:17:36 <gjanssens> and failing because they were (rightfully) missing
12:18:23 <gjanssens> I fixed the checks, but now gnc-fq-check errors out on a missing JSON/XS.pm module
12:18:51 <gjanssens> (that is Win XP, ActiveState Perl, after running install-finance-quote.cmd)
12:19:13 <gjanssens> As said, I have no time to go digging further though.
12:20:45 *** Hinnerk has quit IRC
12:22:53 <warlord> gjanssens: thanks. maybe jralls can look more once he wakes up.
12:24:08 <warlord> gjanssens: do you know where Mont-Saint-Guibert is?
12:27:04 <gjanssens> warlord: I have also sent the message on the mailing list in case he picks that up
12:27:25 <gjanssens> In what country is that supposed to be ?
12:28:54 <warlord> Belgium
12:32:25 *** O01eg has joined #gnucash
12:33:50 <gjanssens> warlord: I wasn't aware of that town... Now I do ;)
12:34:33 <warlord> Where is it?
12:35:51 <gjanssens> About half an hour from my place
12:36:01 <gjanssens> Or just south-east of Brussels
12:36:25 <warlord> good to know.
12:36:25 <warlord> Thanks
12:37:44 <gjanssens> It seems to have a train station, which should be reachable relatively easily from Brussels
12:59:48 *** jralls has joined #gnucash
12:59:48 *** gncbot sets mode: +o jralls
13:10:01 *** jralls has quit IRC
13:11:36 *** lmat_ has quit IRC
13:14:25 <warlord> gjanssens: thanks.
13:26:21 *** Krzysiek_K has joined #gnucash
13:30:44 <fell> warlord: http://en.wikipedia.org/wiki/Mont-Saint-Guibert
13:33:02 <fell> but the french pages has much more information
13:37:48 *** lwells has joined #gnucash
13:53:38 *** lmat has joined #gnucash
14:00:48 *** jralls has joined #gnucash
14:00:48 *** gncbot sets mode: +o jralls
14:02:53 *** jralls_ has joined #gnucash
14:02:53 *** jralls has quit IRC
14:02:54 *** gncbot sets mode: +o jralls_
14:11:35 *** MechtiIde has quit IRC
14:13:10 *** jralls_ has quit IRC
14:21:29 *** jlo has joined #gnucash
14:24:04 *** wol has joined #gnucash
14:26:03 *** GabrieleV has joined #gnucash
14:27:29 *** himaxx has joined #gnucash
14:32:22 *** himaxx has quit IRC
14:39:11 *** fabior has quit IRC
14:45:14 *** wol has quit IRC
15:01:16 *** buildcomplete has joined #gnucash
15:01:38 <buildcomplete> hi people, I'm about to start using gnucash for my company. but before i get to deep in, I would like to know if it is possible to somehow connect bills and invoices to transaction?
15:04:05 *** jralls has joined #gnucash
15:04:05 *** gncbot sets mode: +o jralls
15:04:45 *** O01eg has quit IRC
15:06:59 <warlord> buildcomplete: I'm not sure what you mean exactly. Could you be more explicit about what you want/need?
15:11:53 *** O01eg has joined #gnucash
15:14:07 *** jralls has quit IRC
15:16:13 <buildcomplete> I might have an invoice that is related to multiple transactions (bank transfer/ gift cards) I would like to enter each transaction, but somehow connect them with the invoice number so I can look them up afterwards.
15:16:24 *** jlo has quit IRC
15:19:58 *** fabior has joined #gnucash
15:20:12 <buildcomplete> an alternative, and perhaps better method, would be to create a 'account' for each project, and then have all transaction, both in and out, as subcategories for that project. But I think I read in the gnucash manual that it was recomended to keep expenses in one tree and income in another tree.
15:23:43 <fell> buildcomplete: You can use the business features to enter invoices or create split transactions to bundle txns affecting different accounts, ...
15:25:58 <buildcomplete> ok, sounds good, what do you think about creating a 'project' with both income and expenses as sub categories?
15:29:09 <fell> Some reports will fail, if income & expense are not top level - but perhaps weshould fix that reports.
15:30:18 <buildcomplete> hmm, if the functionality is not there, is there some other way I could group transaction into projects?
15:31:36 <fell> Income:ProjectA; Income:ProjectB, ... Expense (the same structure) will work
15:32:17 <buildcomplete> ok, I can live with that :)
15:34:07 <fell> If your projects are really complex, read how it is done in industrial accounting.
15:35:21 <fell> E.g. Having a coal mine and a powerpant. Both needs the products of the other ...
15:37:48 *** wol has joined #gnucash
15:37:50 <warlord> buildcomplete: sorry -- had an interruptionhere. I'm still not sure what you mean by "an invoice that is related to multiple transactions". Do you mean you bought something and used multiple payment methods? Or that you bought a bunch of things at the same time of different categories?
15:39:03 <buildcomplete> I bought, or payds multiple people, and need to send one bill to my customer to 'transfer' the cost, in these cases my job is to get and pay people.
15:39:42 <buildcomplete> perhaps 200 persons for one day, but my customer just wan't one bill
15:41:15 <warlord> buildcomplete: Gotcha. Yes, you could use the Invoicing feature to do that.
15:41:40 <warlord> It might be a lot of work, tho, depending on how often you're writing out invoices to customers for the work of 200 people..
15:42:15 <buildcomplete> once or twice a month.
15:43:29 <warlord> To get it all to work out you *might* need to treat your 200 people as vendors, use Vendor Bills to "pay" them out, and then you can chargeback those expenses to your customers and print out a single invoice for all your charges.
15:43:31 <buildcomplete> I have a huge baglock, so I am really looking forward to see how it looks when I get it into gnucash :)
15:43:59 <warlord> But you might find doing the work a bit tedious... (says the guy who wrote the code)
15:44:27 <buildcomplete> yeah, I have to see :), I need that overview.
15:47:38 *** jlo has joined #gnucash
15:53:08 *** gjanssens has quit IRC
15:54:08 *** pacon has joined #gnucash
15:59:32 *** wol has quit IRC
16:04:57 *** jralls has joined #gnucash
16:04:58 *** gncbot sets mode: +o jralls
16:07:17 <buildcomplete> should I enable the 'Use Split Action Field for Number' when settings up a new Book, I don't really understand the text in the mouseover. in the split_register struct it looks like it just controls if the 'transaction line' should be split into two lines
16:19:30 *** jralls has quit IRC
16:23:50 *** fell_ has joined #gnucash
16:23:51 *** gncbot sets mode: +o fell_
16:29:01 *** fell has quit IRC
16:31:44 *** fell_ is now known as fell
16:33:00 <fell> buildcomplete: Usually you will have one number per transaction. But some people wished to have a number per split.
16:37:32 <buildcomplete> hmm, I am not really sure what a split is either.
16:39:02 *** wol has joined #gnucash
16:42:45 <warlord> buildcomplete: a split is just a binding from a transaction to one account.
16:43:06 <warlord> every balanced transaction has at least two splits.. one to the credit account (source of value) and one to the debit account (destination of value)
16:43:19 *** wol has quit IRC
16:43:40 <warlord> But you can have multi-split transactions, too.. E.g., if you go to a store like Target and buy groceries, home goods, and clothes.
16:45:10 *** gjanssens has joined #gnucash
16:45:11 *** gncbot sets mode: +o gjanssens
16:45:18 *** gjanssens has quit IRC
16:45:43 <buildcomplete> thanks, expanding my vocabulary. english is my second language and I don't really know about accounting, only used spreadsheets for simple budget
16:48:10 <warlord> no worries.
16:48:20 <warlord> I highly recommend the Tutotial and Concepts Guide
16:48:24 <warlord> Tutorial even
16:49:06 <buildcomplete> yeah, I should probably look, now I am trying a bit handson first, then I will probably go through the tutorial also.
16:50:32 <buildcomplete> I have a lots of transactions, is there somehow I can import them from a csv file or the like, so they become transactions under a certain account?
16:51:10 <warlord> buildcomplete: absolutely. (although QIF is, IMHO, the best option -- but CSV works)
16:53:21 <buildcomplete> nice :)
16:56:17 *** StuM has joined #gnucash
16:56:41 *** Krzysiek_K has quit IRC
17:07:39 *** pacon has quit IRC
17:09:27 *** jralls has joined #gnucash
17:09:28 *** gncbot sets mode: +o jralls
17:20:52 *** jralls has quit IRC
17:29:00 *** lmat has quit IRC
17:46:46 *** fabior has quit IRC
17:52:13 *** rickoehn has quit IRC
17:57:47 *** lwells has quit IRC
18:05:31 *** jralls has joined #gnucash
18:05:31 *** gncbot sets mode: +o jralls
18:05:37 *** jralls has quit IRC
18:05:39 *** jralls has joined #gnucash
18:05:39 *** gncbot sets mode: +o jralls
18:11:45 *** wizkid238 has quit IRC
18:13:20 <buildcomplete> I am reading the guide now, and it shows an example of a 'checking account', I have a feeling that the word' checking account' should mean something to me, is that going to be elaborated in the guide, or could you give me a hint as to how I should interpret that word?
18:13:51 *** nomeata has quit IRC
18:14:23 <buildcomplete> from the screenshot I would guess it was that bulk account that all your personal transaction goes through
18:34:25 *** wizkid238 has joined #gnucash
18:36:01 *** mib_blesuc has joined #gnucash
18:36:27 <mib_blesuc> hello! i would like to ask something
18:36:35 <mib_blesuc> i came across some problems
18:37:00 <mib_blesuc> wherein it says spread evenly throughout the year, and then it had a solution wherein the average is divided by 2
18:37:36 <mib_blesuc> so how come when looking for the average, you have to divide by 2? this is also the case for problems with constant rates
18:37:42 <mib_blesuc> any idea?
18:48:38 *** jralls has quit IRC
19:10:50 <fell> buildcomplete: the checking account is used if you write cheques. I am not shure if it is still in use in many countries.
19:12:21 <fell> mib_blesuc: I don't know your context. :-(
19:14:17 <fell> you can review, which lines came trugh at http://lists.gnucash.org/logs/2015/03/2015-03-04.html#T18:36:27
19:16:58 <mib_blesuc> L company estimates that 60,000 special components will be used in the manufacture of a specialty steel window for the whole next year. its supplier quoted a price of P60 per component. L company prefers to purchase 5000 units per month, but its supplier could not guarantee this delivery schedule. In order to ensure availability of these components...
19:17:47 <mib_blesuc> L company is cinsidering the purchase of all the 60,000 units at the beginning of the year. Assuming L company can invest cash at 8%, the company's opportunity cost of purchasing all the 60,000 units at the beginning of the year is?
19:19:02 <mib_blesuc> so the solution is 60,000-5,000= 55,000 ; 55,000 x 60 = 3,300,000 ; "(3,300,000/2)" x 8% = 132,000*answer
19:20:27 <fell> mib_blesuc: And where is the relation to gnucash?
19:21:29 <mib_blesuc> i though this was a general chatbox :( sorry
19:21:47 <fell> NP! ;-)
19:22:54 <mib_blesuc> can you suggest any channels, that discusses on accounting stuff generally? :D
19:23:57 <fell> I would try google or similar to find one.
19:24:48 *** rpg has quit IRC
19:29:44 *** mib_blesuc has quit IRC
19:32:31 *** jlo has quit IRC
19:32:38 *** jlo has joined #gnucash
19:35:48 *** jralls has joined #gnucash
19:35:49 *** gncbot sets mode: +o jralls
19:35:52 *** jralls has quit IRC
19:35:54 *** jralls has joined #gnucash
19:35:54 *** gncbot sets mode: +o jralls
19:47:29 *** ErKa has quit IRC
19:55:20 <warlord> buildcomplete: a checking account is a type of bank account where you, well, write checks.
20:10:33 *** mikee has quit IRC
20:16:53 *** mikee has joined #gnucash
20:42:54 <jralls> warlord, buildcomplete: Well, in the old days when people wrote checks. A better name for it now would be a "demand" account, as opposed to a savings account. The former is an account from which one is expected to make frequent withdrawals and the latter one where one is expected to park one's money for a longer time. Back when banks paid interest the latter would have a higher rate and lower fees than the former.
20:49:40 *** jralls has quit IRC
20:49:44 *** jralls has joined #gnucash
20:49:44 *** gncbot sets mode: +o jralls
20:53:23 *** ErKa has joined #gnucash
20:58:34 *** jralls has quit IRC
22:01:12 *** UncleJed has joined #gnucash
22:01:51 <UncleJed> i'm a new user of gnucash. setting it up. anyone up for a quick question?
22:02:26 <UncleJed> oops....i'll just "ask and wait". :P
22:03:02 <UncleJed> Is it better to set up a separate gnucash account for my business or should I do business and personal in the same file?
22:03:49 <UncleJed> ...and BTW, the business is a LLC (pass-through entity), so I'm guessing might be better in the same file for tax purposes later down the road.
22:23:19 *** StuM1 has joined #gnucash
22:30:38 *** StuM has quit IRC
22:47:12 *** GabrieleV_ has joined #gnucash
22:47:16 *** GabrieleV has quit IRC
22:47:16 *** GabrieleV_ is now known as GabrieleV
22:56:46 *** cartsoftware has quit IRC
22:59:38 *** StuM has joined #gnucash
23:07:34 *** StuM1 has quit IRC
23:27:01 *** andy_ has joined #gnucash
23:28:25 *** andy has quit IRC
23:52:11 *** GabrieleV_ has joined #gnucash
23:52:45 *** GabrieleV has quit IRC
23:52:46 *** GabrieleV_ is now known as GabrieleV