2012-07-02 GnuCash IRC logs
00:12:41 *** GabrieleV_ has joined #gnucash
00:14:53 *** GabrieleV has quit IRC
00:14:53 *** GabrieleV_ is now known as GabrieleV
00:40:59 *** GabrieleV_ has joined #gnucash
00:42:12 *** GabrieleV has quit IRC
00:42:13 *** GabrieleV_ is now known as GabrieleV
01:42:23 *** aqua_ has quit IRC
01:47:48 *** cxoffice has joined #gnucash
01:49:15 *** fell_ has joined #gnucash
01:49:15 *** gncbot sets mode: +o fell_
01:49:52 <cxoffice> I'm running Fedora 17 and I just installed gnucash 2.4.10 using "yum". I've never run gnucash on this machine so this is a virgin install. First run results in
01:51:48 <cxoffice> "The configuration data used to specify default values for GnuCash cannot be found ...." I walked through the setup and selected the options to have gnucash fix this but the fix does not stick and I get the same problem when I run gnucash again. Also, no initial setup druid screen ever shows up.
01:54:25 *** fell has quit IRC
02:14:30 *** GabrieleV has quit IRC
02:15:00 *** GabrieleV has joined #gnucash
02:35:19 *** GabrieleV_ has joined #gnucash
02:38:44 *** GabrieleV has quit IRC
02:38:44 *** GabrieleV_ is now known as GabrieleV
02:40:16 *** fell_ is now known as fell
02:40:16 *** cxoffice has quit IRC
02:41:19 *** cxoffice has joined #gnucash
02:44:41 *** cxoffice has quit IRC
02:45:20 *** cxoffice has joined #gnucash
02:48:43 *** cxoffice has quit IRC
02:49:22 *** cxoffice has joined #gnucash
02:54:41 *** cxoffice has quit IRC
02:55:21 *** cxoffice has joined #gnucash
02:59:04 *** ErKa has joined #gnucash
03:04:41 *** cxoffice has quit IRC
03:05:19 *** cxoffice has joined #gnucash
03:07:34 *** Fabzgy has joined #gnucash
03:14:41 *** cxoffice has quit IRC
03:15:20 *** cxoffice has joined #gnucash
03:18:42 *** cxoffice has quit IRC
03:19:32 *** cxoffice has joined #gnucash
03:38:57 *** GabrieleV has quit IRC
03:39:32 *** GabrieleV has joined #gnucash
04:15:28 *** pnema has joined #gnucash
04:25:49 *** xnox has joined #gnucash
04:25:50 *** cxoffice has quit IRC
04:25:57 <xnox> nice view of the big ben and the london eye ;-)
04:26:18 * xnox is in the wrong channel
04:27:19 *** cxoffice has joined #gnucash
04:29:20 *** cxoffice has joined #gnucash
04:34:40 *** cxoffice has quit IRC
04:35:19 *** cxoffice has joined #gnucash
04:38:32 *** fell_ has joined #gnucash
04:38:32 *** cxoffice has quit IRC
04:38:32 *** gncbot sets mode: +o fell_
04:39:35 *** cxoffice has joined #gnucash
04:43:43 *** fell has quit IRC
04:46:27 *** john3voltas has joined #gnucash
04:46:28 *** cxoffice has quit IRC
04:47:28 *** cxoffice has joined #gnucash
04:51:46 <john3voltas> Hi there. I just installed gnucash. I am not a native English speaker so some accounting-related words confuse me a bit.
04:51:46 *** cxoffice has quit IRC
04:52:13 <john3voltas> Is there any Portuguese native here?
04:53:19 *** cxoffice has joined #gnucash
04:55:20 <john3voltas> In case someone can help me, how would I translate equity and liabilities to Portuguese?
04:58:42 *** cxoffice has quit IRC
04:59:03 <fell_> john3voltas: have a look at http://pt.wikipedia.org/wiki/Balan%C3%A7o_patrimonial
04:59:20 *** cxoffice has joined #gnucash
05:04:24 <fell_> Ativo: How do I use the money? Passivo: From where comes/Who ons the money: equity = me, liabilities someone else.
05:04:37 <fell_> ownes
05:04:40 *** cxoffice has quit IRC
05:04:43 *** fell_ is now known as fell
05:05:19 *** cxoffice has joined #gnucash
05:05:54 <fell> cxoffice: Do you have problems to stay online?
05:06:33 <fell> Everytime I want to answer your question, you diappeared.
05:06:34 <john3voltas> I see. So Activo/Passivo is what? Equity, right?
05:07:20 <fell> cxoffice: Is GConfd running?
05:08:49 <fell> john3voltas: The english people in contradiction to the rest of Europe do not know the Active/Passivo terms.
05:09:32 <fell> So it is not used in the docs.
05:10:34 <fell> But in the rest of the world it is the first level of the balance.
05:10:34 *** cxoffice has quit IRC
05:11:20 *** cxoffice has joined #gnucash
05:12:31 <fell> Passivo, the right side, consists of Equity - the part you own - and liabilities - the part someone else ownes.
05:13:16 <fell> E.g you used a credit to buy a house or a car.
05:13:28 <john3voltas> Oh, so passivo=equity and liabilities=activo?
05:13:56 <fell> No, both are passivo.
05:14:02 <john3voltas> oh :(
05:14:20 <john3voltas> gotta make a break because i'm at work
05:14:30 <john3voltas> will read more and be back if still in doubt
05:14:34 <john3voltas> thanks fell
05:15:25 <fell> Activo answers the question: How do you use your money: cash, bank accounts, invenstments...
05:18:41 *** cxoffice has quit IRC
05:19:20 *** cxoffice has joined #gnucash
05:20:55 <fell> Equity = Patrimônio_líquido
05:24:40 *** cxoffice has quit IRC
05:25:18 *** cxoffice has joined #gnucash
05:28:41 *** cxoffice has quit IRC
05:29:34 *** cxoffice has joined #gnucash
05:40:34 *** pnema has quit IRC
05:40:34 *** cxoffice has quit IRC
05:41:19 *** cxoffice has joined #gnucash
05:44:40 *** cxoffice has quit IRC
05:45:33 *** cxoffice has joined #gnucash
05:49:12 *** IanL has quit IRC
05:50:20 *** aruiz has quit IRC
05:50:21 *** cxoffice has quit IRC
05:51:19 *** cxoffice has joined #gnucash
05:53:32 <john3voltas> fell: it's not easy. i even had economics at school but i was always a bad economics student. i guess for now i don't need equity and liabilities. i can always get back and use them later, right?
05:54:40 *** cxoffice has quit IRC
05:55:18 *** cxoffice has joined #gnucash
05:57:27 *** aruiz has joined #gnucash
05:59:20 *** IanL has joined #gnucash
06:02:06 <fell> john3voltas: liabilities are debts. Equity is your economical worth after you would have paid all your debts.
06:02:07 *** cxoffice has quit IRC
06:03:15 <john3voltas> debts as in all the money i owe?
06:03:19 *** cxoffice has joined #gnucash
06:03:49 <fell> Yep.
06:04:13 <john3voltas> say i'm buying a car using a loan. is that a debt?
06:05:53 <fell> Lets assume you had 5000 cash and took a loan of 5000 to buy a car for 10000.
06:05:54 *** cxoffice has quit IRC
06:06:24 <fell> Then your activo would be the car of 10000.
06:06:58 <fell> Passivo is the split in 5000 equity and 5000 liability in your balance.
06:07:05 <john3voltas> wow
06:07:29 *** cxoffice has joined #gnucash
06:08:46 <john3voltas> so, in this case, my liabilities are 5000 (loan) and my equity is 5000 too?
06:08:56 <john3voltas> or my equity is 10000?
06:10:20 *** IanL has quit IRC
06:10:21 *** cxoffice has quit IRC
06:10:30 <fell> No, your car (activo) is 10000. Minus your liabilities (5000 loan) results in an equity of 5000.
06:10:38 <john3voltas> wait. active is worth 10000, minus 5000 of my passive equals 5000.
06:10:43 <john3voltas> beat me to it lol
06:11:37 *** cxoffice has joined #gnucash
06:17:15 *** aruiz has quit IRC
06:18:26 *** IanL has joined #gnucash
06:18:27 *** cxoffice has quit IRC
06:19:34 *** cxoffice has joined #gnucash
06:23:35 <john3voltas> What if I bought a car with cash money instead of getting a loan? It is still considered an active and in such sense a part of equity, right?
06:24:03 *** aruiz has joined #gnucash
06:33:37 *** kpreid has joined #gnucash
06:34:16 *** aruiz has quit IRC
06:41:41 *** aruiz has joined #gnucash
06:41:41 *** cxoffice has quit IRC
06:43:33 *** cxoffice has joined #gnucash
06:47:16 *** Jimraehl1 has quit IRC
06:50:17 *** aqua___ has joined #gnucash
06:50:18 *** cxoffice has quit IRC
06:51:39 *** cxoffice has joined #gnucash
06:54:25 *** Fabzgy has quit IRC
07:18:19 *** aruiz has quit IRC
07:18:19 *** cxoffice has quit IRC
07:19:12 *** Fabzgy has joined #gnucash
07:19:19 *** cxoffice has joined #gnucash
07:22:29 *** Fabzgy has quit IRC
07:22:29 *** cxoffice has quit IRC
07:23:18 *** cxoffice has joined #gnucash
07:25:59 *** aruiz has joined #gnucash
07:26:00 *** cxoffice has quit IRC
07:27:19 *** cxoffice has joined #gnucash
07:32:37 *** kpreid has quit IRC
07:32:38 *** cxoffice has quit IRC
07:33:19 *** cxoffice has joined #gnucash
07:38:59 *** Arafangion has joined #gnucash
07:44:39 *** cxoffice has quit IRC
07:45:19 *** cxoffice has joined #gnucash
07:45:47 *** Jimraehl1 has joined #gnucash
07:48:40 *** cxoffice has quit IRC
07:49:19 *** cxoffice has joined #gnucash
07:54:39 *** cxoffice has quit IRC
07:55:39 *** cxoffice has joined #gnucash
08:03:17 *** aruiz has quit IRC
08:10:28 *** aruiz has joined #gnucash
08:10:29 *** cxoffice has quit IRC
08:11:18 *** cxoffice has joined #gnucash
08:14:39 *** cxoffice has quit IRC
08:15:45 *** cxoffice has joined #gnucash
08:16:05 *** Arafangion` has joined #gnucash
08:27:28 *** aruiz has quit IRC
08:28:41 *** Arafangion has quit IRC
08:34:19 *** aruiz has joined #gnucash
08:36:14 *** xnox has quit IRC
08:36:15 *** cxoffice has quit IRC
08:37:17 *** cxoffice has joined #gnucash
08:44:24 *** IanL has quit IRC
08:44:39 *** cxoffice has quit IRC
08:45:18 *** cxoffice has joined #gnucash
08:54:38 *** cxoffice has quit IRC
08:55:28 *** cxoffice has joined #gnucash
09:01:31 *** aqua___ has quit IRC
09:05:29 *** xnox has joined #gnucash
09:07:28 <john3voltas> fell: What if I bought a car with cash money instead of getting a loan? Would it still be considered an active and in such sense a part of equity?
09:11:35 *** aqua___ has joined #gnucash
09:12:00 <fell> The car, the cash and all other assets are your activa. If you took no loan, the sum is equity.
09:12:04 *** aruiz has quit IRC
09:14:07 <john3voltas> I see. So every non-perishable item that I buy becomes an active. Like a car, or a computer or a telephone, this stuff becomes an active, right?
09:19:03 *** aruiz has joined #gnucash
09:43:02 *** aqua___ has quit IRC
09:44:33 *** GabrieleV_ has joined #gnucash
09:48:13 *** GabrieleV has quit IRC
09:48:13 *** cxoffice has quit IRC
09:49:11 *** GabrieleV_ is now known as GabrieleV
09:49:17 *** cxoffice has joined #gnucash
09:52:59 *** warlord-afk is now known as warlord
09:53:11 <warlord> john3voltas: yes, anything of "value" you buy is an asset.
09:58:40 *** cxoffice has quit IRC
09:59:34 *** cxoffice has joined #gnucash
10:45:29 <john3voltas> warlord: interesting. then it comes to be that I have money in the bank and write a check to buy a computer. the money gets withdrawn from my bank account and gets credited in 'computer-related account'. simultaneously i have to add that amount of spent money to the equity, right? and since it got off directly from my bank account (no loan) there's no need to fill a liability, right?
10:46:15 <warlord> No, you don't need to touch an Equity account. But correct, you don't need to fill liability, either.
10:46:30 <warlord> Don't confuse the equity accounts with Instantaneous Equity ...
10:46:32 <warlord> (which is computed)
10:47:04 <warlord> The equity accounts show you your equity at a point in time (generally your "Opening Balance"). It does NOT show your Instantaneous Equity at any point in time. Use a Balance Sheet to show you that.
10:54:31 <john3voltas> this is all still a bit confusing to me. not only because i'm fresh new to gnucash but also because english is not my native and also because i was always a lousy economics students.
10:58:00 *** aqua___ has joined #gnucash
10:58:01 *** cxoffice has quit IRC
10:58:24 <warlord> Heh.
10:58:41 <warlord> I recommend you read the GnuCash Guide & Tutorial. It's in English, but it's pretty good.
10:59:29 *** cxoffice has joined #gnucash
11:01:21 <john3voltas> I can understand English and the guide is simple, but I lack a lot of vocabulary.
11:02:07 <john3voltas> But I think I'm starting to understand how it works.
11:02:45 <warlord> There's a glossary available.
11:31:41 *** Arafangion` has quit IRC
11:31:42 *** cxoffice has quit IRC
11:33:28 *** cxoffice has joined #gnucash
11:45:30 <john3voltas> I'll make sure to read it over this week. Thanks.
11:47:51 <warlord> Good luck!
11:47:51 *** cxoffice has quit IRC
11:49:16 *** cxoffice has joined #gnucash
11:54:39 *** cxoffice has quit IRC
11:55:16 *** cxoffice has joined #gnucash
12:24:37 *** cxoffice has quit IRC
12:25:16 *** cxoffice has joined #gnucash
12:28:38 *** cxoffice has quit IRC
12:29:31 *** cxoffice has joined #gnucash
12:58:18 *** aruiz has quit IRC
12:58:18 *** cxoffice has quit IRC
12:58:42 *** aruiz has joined #gnucash
12:59:16 *** cxoffice has joined #gnucash
13:04:37 *** cxoffice has quit IRC
13:05:16 *** cxoffice has joined #gnucash
13:08:38 *** cxoffice has quit IRC
13:09:30 *** cxoffice has joined #gnucash
13:31:09 *** john3voltas has quit IRC
13:32:38 *** xnox has quit IRC
13:37:57 *** aqua___ has quit IRC
13:37:57 *** cxoffice has quit IRC
13:39:16 *** cxoffice has joined #gnucash
13:48:38 *** cxoffice has quit IRC
13:49:32 *** cxoffice has joined #gnucash
14:03:12 *** ralf has joined #gnucash
14:07:15 <ralf> Hi, it's for private accounting, I'd like to generate a report with a monthly income/expenses view. I googled but... can someone give a quick tip / link? Thank you!
14:09:15 <warlord> You would have to run the P&L once per month. Unfortunately we don't have a single report that will give you what you want. It *IS* an oft-requested feature, but nobody has ever implemented it.
14:19:35 *** markjenkinsparit has joined #gnucash
14:30:46 *** donfede has joined #gnucash
14:49:42 *** GabrieleV_ has joined #gnucash
14:49:43 *** cxoffice has quit IRC
14:50:55 *** GabrieleV has quit IRC
14:50:55 *** GabrieleV_ is now known as GabrieleV
14:51:28 *** cxoffice has joined #gnucash
14:57:12 <warlord> ralf: please answer in channel.
14:57:20 <warlord> this way other people can benefit from the logs.
15:16:26 <ralf> sorry, here the question concerning the reporting: is there an easy way to gain access to the native xml file (like a driver to plug in a database), in order to structure information through relational links (hope nobody will laugh in the room!!!!!?
15:16:27 *** cxoffice has quit IRC
15:17:15 *** cxoffice has joined #gnucash
15:17:30 <warlord> I don't understand the question. The XML file is an XML file, and you can access it using any tools you want. If you store your data in a SQL server then you can access them from there, too.
15:19:25 *** markjenkinsparit has quit IRC
15:28:37 *** cxoffice has quit IRC
15:29:28 *** cxoffice has joined #gnucash
15:31:10 *** jmd has joined #gnucash
16:05:11 <ralf> I didn't understand how to manage the 'converting XML Gnucash File w. the xslt parser': like perhaps several users, I'm using 'descriptions' not for 'transactions' but to define the 'suppliers', as many financial tools do for home-accounting. In order to analyze the description field and have monthly reports, what would be the easiest way? Can it easily be viewed under oocalc? Or easily be pushed into a mysql table? The migration guide
16:05:11 <ralf> wasn't obvious for me to understand...
16:09:26 <warlord> I've never used xslt
16:09:37 <warlord> but for my uses, the exiting reports have always been sufficient.
16:09:50 <warlord> If you want to migrate to SQL, you can File -> Save As
16:09:56 <warlord> (assuming you use 2.4.x)
16:17:55 *** aruiz has quit IRC
16:17:56 *** cxoffice has quit IRC
16:19:15 *** cxoffice has joined #gnucash
16:20:18 <ralf> under phpmyadmin I tried to import the (uncompressed) file into a mysql database, applying the xml filter to catch the table design & data, but nothing happens...
16:23:56 <warlord> Where did phpmyadmin come in here?
16:24:09 <warlord> To store your gnucash data into MySQL just File -> Save As and select MySQL
16:24:19 <warlord> ... assuming you have the MySQL DBD Driver installed
16:24:44 *** aruiz has joined #gnucash
16:28:37 *** cxoffice has quit IRC
16:29:16 *** cxoffice has joined #gnucash
16:34:36 *** cxoffice has quit IRC
16:34:45 *** jmd has quit IRC
16:35:15 *** cxoffice has joined #gnucash
16:36:00 <ralf> it seems not present, just the 'xml' format, I'm with fedora 17. Found a 'qof' library, installed it, bud it's not linked
16:38:37 *** cxoffice has quit IRC
16:39:28 *** cxoffice has joined #gnucash
16:45:21 <ralf> warlord, thank you very much: you helped me to understand to compile it with the mysql backend. Thank you
16:45:49 <warlord> no need to recompile, just install the dbd driver
16:46:07 <warlord> F17 comes with DBI already in gnucash.
16:46:16 <warlord> (assuming you're using the F17 rpm)
16:46:38 <warlord> just yum install libdbi-dbd-mysql
16:46:45 <warlord> ... and then rerun gnucash
16:47:25 <warlord> NOTE: Do NOT use MySQL for your main data file.. There are still known data loss issues in 2.4.x. Use XML and only use SQL for extra reporting if the standard reports dont work for you.
16:47:37 <warlord> better yet would be to just write a report for gnucash that reports what you want.
16:57:51 *** ralf has quit IRC
16:57:52 *** cxoffice has quit IRC
16:59:14 *** cxoffice has joined #gnucash
17:04:36 *** cxoffice has quit IRC
17:05:15 *** cxoffice has joined #gnucash
17:24:35 *** cxoffice has quit IRC
17:25:27 *** cxoffice has joined #gnucash
18:11:59 <cxoffice> I used "yum" to install gnucash on a recently created Fedora 17 machine. When I run gnucash, it gives me a message window saying that it "Cannot find default values" and an explanation that these are expected in some system location. It then walks me through setting these up and I select to "Update search path" and "GnuCash updates the search path". Gnucash then modifies ~/.gconf.path and...
18:12:01 <cxoffice> ...I can see the update in that file. However, the same message appears again when I next run gnucash. (Sorry if you've seen this before - I asked it yesterday but didn't see an answer).
18:20:28 *** Askarii has joined #gnucash
18:20:28 *** cxoffice has quit IRC
18:21:14 *** cxoffice has joined #gnucash
18:32:17 *** Askarii has quit IRC
18:32:18 *** cxoffice has quit IRC
18:33:24 *** cxoffice has joined #gnucash
18:41:54 <fell> cxoffice: http://lists.gnucash.org/logs/2012/07/2012-07-02.html#T05:05:54
18:41:54 *** cxoffice has quit IRC
18:42:23 *** fell is now known as fell_afk
18:43:24 *** cxoffice has joined #gnucash
19:20:18 *** fell_afk has quit IRC
19:20:18 *** cxoffice has quit IRC
19:21:26 *** cxoffice has joined #gnucash
19:47:45 *** ErKa has quit IRC
19:47:45 *** cxoffice has quit IRC
19:49:13 *** cxoffice has joined #gnucash
19:54:34 *** cxoffice has quit IRC
19:55:13 *** cxoffice has joined #gnucash
19:58:35 *** cxoffice has quit IRC
19:59:14 *** cxoffice has joined #gnucash
20:04:34 *** cxoffice has quit IRC
20:04:55 *** Menuhin_ has joined #gnucash
20:05:12 *** cxoffice has joined #gnucash
20:08:35 *** cxoffice has quit IRC
20:09:34 *** cxoffice has joined #gnucash
20:14:05 *** Menuhin has quit IRC
20:34:02 *** Jimraehl1 has quit IRC
20:36:52 *** aruiz has quit IRC
21:00:53 *** GabrieleV_ has joined #gnucash
21:01:17 *** Jimraehl1 has joined #gnucash
21:03:58 *** GabrieleV has quit IRC
21:03:58 *** GabrieleV_ is now known as GabrieleV
22:14:04 *** GabrieleV_ has joined #gnucash
22:17:43 *** GabrieleV has quit IRC
22:17:44 *** GabrieleV_ is now known as GabrieleV
22:17:44 *** cxoffice has quit IRC
22:19:12 *** cxoffice has joined #gnucash
22:24:33 *** cxoffice has quit IRC
22:25:12 *** cxoffice has joined #gnucash
22:28:34 *** cxoffice has quit IRC
22:29:13 *** cxoffice has joined #gnucash
22:34:33 *** cxoffice has quit IRC
22:35:34 *** cxoffice has joined #gnucash
22:44:59 *** warlord is now known as warlord-afk
23:28:41 *** xnox has joined #gnucash
23:55:20 *** GabrieleV_ has joined #gnucash
23:56:41 *** GabrieleV has quit IRC