2013-09-03 GnuCash IRC logs
00:51:58 *** ErKa has joined #gnucash
01:06:24 *** jxqz has quit IRC
01:26:38 *** mikee_ has joined #gnucash
01:26:39 *** mikee has quit IRC
01:53:21 <PaulFertser> warlord: But my account names depend on LC_MESSAGES (I have it =C), and are "data/person-specific" so should be fine. But locale weekday... It might also occassionally errorneously match to e.g. Friday's receipts, right?
01:59:33 *** mikee__ has joined #gnucash
01:59:34 *** mikee_ has quit IRC
02:20:31 *** john has joined #gnucash
02:20:31 *** gncbot sets mode: +o john
02:23:49 *** ErKa has quit IRC
02:39:59 *** Jimraehl1 has joined #gnucash
02:40:54 *** arlie has joined #gnucash
02:42:20 <arlie> I'm lost in report land; trying to get a picture of change in assets over time, with numbers - closest I've gotten so far is income & expenses report
02:44:16 <arlie> err - I mean profit and loss; income and expenses is just a graph, and can't click or hover to get actual numbers
02:45:07 *** john has quit IRC
02:46:39 <arlie> even ancient versions of quicken could do what I want - but the report names don't mean anything to this non-accountant, and docs don't give samples, so really slow trying them all to find a useful one
02:56:56 *** fell_ has joined #gnucash
02:56:56 *** gncbot sets mode: +o fell_
02:58:16 *** fell_ is now known as fell
03:16:05 <arlie> nvm - looks like no one awake, and I'm ready to sleep myself. See why people tend to "ask to ask" ;-)
03:17:20 *** arlie has quit IRC
03:18:25 *** Topcat has joined #gnucash
03:23:56 *** Topcat has quit IRC
03:39:35 *** Topcat has joined #gnucash
03:43:18 *** CeBe1 has joined #gnucash
03:44:40 <CeBe1> hi, any idea why I don't have "Passiva" listed when I create a new Account?
03:45:05 <CeBe1> I mean listed in account type list
03:46:17 <CeBe1> The german example lists it here: http://wiki.gnucash.org/wiki/De/Konfiguration#Beispielkonfiguration_des_Gesch.C3.A4ftsmoduls_f.C3.BCr_kleine_Unternehmen_mit_MWSt.
03:58:10 *** Topcat has quit IRC
03:58:44 *** Topcat has joined #gnucash
04:13:50 *** Topcat has quit IRC
04:14:29 *** Topcat has joined #gnucash
04:19:31 *** Topcat has quit IRC
04:19:53 *** Topcat has joined #gnucash
04:21:45 <PaulFertser> If one has a server handy, and Internet connection on the go, he can run ledger-rest daemon on it, and use ledger-android to add transactions.
04:30:02 *** Topcat has quit IRC
04:30:24 *** Topcat has joined #gnucash
04:34:24 <PaulFertser> Topcat: what's up man, why is that you're parting and joining all the time?
04:40:26 *** Topcat has quit IRC
04:41:00 *** Topcat has joined #gnucash
04:46:00 *** Topcat has quit IRC
04:46:33 *** Topcat has joined #gnucash
04:51:33 *** Topcat has quit IRC
04:51:55 *** Topcat has joined #gnucash
05:03:01 *** aqua___ has joined #gnucash
05:10:27 *** Topcat has quit IRC
05:11:02 *** Topcat has joined #gnucash
05:14:49 *** fell_ has joined #gnucash
05:14:51 *** gncbot sets mode: +o fell_
05:20:00 *** fell has quit IRC
05:27:00 *** Topcat has quit IRC
05:27:23 *** Topcat has joined #gnucash
05:32:22 *** Topcat has quit IRC
05:33:13 *** Topcat has joined #gnucash
05:38:13 *** Topcat has quit IRC
05:38:35 *** Topcat has joined #gnucash
05:43:35 *** Topcat has quit IRC
05:43:58 *** Topcat has joined #gnucash
05:48:59 *** Topcat has quit IRC
05:49:21 *** Topcat has joined #gnucash
05:54:23 *** Topcat has quit IRC
05:54:46 *** Topcat has joined #gnucash
05:59:46 *** Topcat has quit IRC
06:00:08 *** Topcat has joined #gnucash
06:05:07 *** Topcat has quit IRC
06:05:46 *** Topcat has joined #gnucash
06:10:44 *** Topcat has quit IRC
06:11:21 *** Topcat has joined #gnucash
06:16:22 *** Topcat has quit IRC
06:17:14 *** Topcat has joined #gnucash
06:22:15 *** Topcat has quit IRC
06:22:38 *** Topcat has joined #gnucash
06:27:39 *** Topcat has quit IRC
06:28:01 *** Topcat has joined #gnucash
06:30:37 *** Jimraehl1 has left #gnucash
06:35:19 *** wizkid238 has joined #gnucash
06:39:32 *** Topcat has quit IRC
06:42:19 *** fell_ is now known as fell
06:50:13 *** aqua___ has quit IRC
07:04:19 *** Jimraehl1 has joined #gnucash
07:07:46 *** Topcat has joined #gnucash
07:16:55 *** Topcat1 has joined #gnucash
07:17:52 *** Topcat has quit IRC
07:26:57 *** Topcat1 has quit IRC
07:27:29 *** Topcat has joined #gnucash
07:32:30 *** Topcat has quit IRC
07:32:52 *** Topcat has joined #gnucash
07:47:57 *** Topcat has quit IRC
07:48:30 *** Topcat has joined #gnucash
07:53:30 *** Topcat has quit IRC
07:54:16 *** Topcat has joined #gnucash
08:14:19 *** Topcat has quit IRC
08:49:24 *** Topcat has joined #gnucash
09:09:31 *** Topcat has quit IRC
09:09:53 *** Topcat has joined #gnucash
09:14:52 *** Topcat has quit IRC
09:15:26 *** Topcat has joined #gnucash
09:26:39 *** Topcat has quit IRC
09:27:01 *** Topcat has joined #gnucash
09:29:27 <warlord> PaulFertser: No, your account names do not depend on LC_MESSAGES. If you change locale your account names are not changed. Try it and see. And no, "Friday" will not interact with "Friday's" -- two different tokens.
09:30:49 <warlord> Topcat: Can you please reset your thunderbird to stop connecting, please?
09:37:03 *** Topcat has quit IRC
09:37:24 *** Topcat has joined #gnucash
09:38:06 <warlord> CeBe1: Sorry, I don't speak German. But maybe fell can answer your question?
09:39:42 <PaulFertser> warlord: i mean initially the account names might be created based on locale, but that doesn't really make the gnucash file locale-dependent afaict. Can Friday interact with Friday 's or some other clash like that happen? Using those dayweek as tokens feels like a dirty hack to me.
09:47:33 *** Topcat has quit IRC
09:47:56 *** Topcat has joined #gnucash
09:48:36 <warlord> I do agree that day-of-week probably shouldn't be added as a match token; I'm not sure why it was added. I guess some people always get paid on Friday or something. As for the gnucash datafile being locale dependent -- it is. SX formulae are definitely locale specific. And if you take an account tree created in German, I certainly wont be able to understand what the accounts are..
09:52:10 <fell> CeBe1: erklär noch mal,was du versuchst, zu machen.
09:58:05 *** Topcat has quit IRC
09:58:25 *** Topcat has joined #gnucash
10:02:06 *** aqua___ has joined #gnucash
10:08:33 *** Topcat has quit IRC
10:08:56 *** Topcat has joined #gnucash
10:11:51 <CeBe1> fell: Ich versuche die Konten anzulegen aus dem beispiel: http://wiki.gnucash.org/wiki/De/Konfiguration#Beispielkonfiguration_des_Gesch.C3.A4ftsmoduls_f.C3.BCr_kleine_Unternehmen_mit_MWSt.
10:12:25 <CeBe1> hab aber keine auswahl "Passiva" für konto typ
10:16:30 <fell> Den gibt es nicht, weil die Angelsachsen im Gegensatz zu allen Kontinentaleuropäern den nicht kennen.
10:18:06 <fell> Das Beispiel ist was älter und zu der Zeit, als es entstand, was Fremdkapital irrtümlich mit Passiva übersetzt worden.
10:19:04 <CeBe1> fell: das heißt ich wähle jetzt Fremdkapital aus?
10:19:55 <fell> Ja, würde ich machen.
10:20:19 <CeBe1> fell: super, danke!
10:21:03 <fell> Apropos: hast du auch ferigen Kontenrahmen SKRxx, Wohnungswirtschaft ... gesehen? Vielleicht kannst du dir damit eine Menge Arbeit Sparen.
10:21:31 <CeBe1> Danke, hab ich gesehen finde ich aber für den Anfang zu komplex
10:22:49 <fell> Das ist natürlich auch ein Aspekt. Viel Spaß noch!
10:29:20 <fell> So, ich hab dann gleich mal den Absatz in der Wiki-Seite berichtigt.
10:30:51 <CeBe1> cool, danke
10:33:15 <fell> Warlord: we had some outdated translations of accounnt types in an example.
10:34:49 <warlord> fell: ah, okay.
10:34:59 <warlord> In the docs? In the wiki? ...
10:35:39 <fell> In above german wiki page - already fixed.
10:35:48 <warlord> Great.
10:35:56 <warlord> thanks for summerizing for me. :)
10:36:16 <fell> Welcome!
10:49:39 *** Topcat has quit IRC
10:50:02 *** Topcat has joined #gnucash
10:53:02 *** ErKa has joined #gnucash
10:53:30 *** shanny has joined #gnucash
11:03:24 *** Topcat has quit IRC
11:03:47 *** Topcat has joined #gnucash
11:08:47 *** Topcat has quit IRC
11:09:27 *** Topcat has joined #gnucash
11:17:53 *** Topcat has quit IRC
11:18:29 *** Topcat has joined #gnucash
11:23:31 *** Topcat has quit IRC
11:23:41 *** aqua___ has quit IRC
11:24:28 *** Topcat has joined #gnucash
11:29:25 *** Topcat has quit IRC
11:29:48 *** Topcat has joined #gnucash
11:34:46 *** Topcat has quit IRC
11:35:40 *** Topcat has joined #gnucash
11:40:23 *** john has joined #gnucash
11:40:25 *** gncbot sets mode: +o john
11:42:59 *** fell is now known as fell_afk
11:50:44 *** Topcat has quit IRC
11:51:29 *** Topcat has joined #gnucash
11:56:30 *** Topcat has quit IRC
11:56:52 *** Topcat has joined #gnucash
12:01:52 *** Topcat has quit IRC
12:02:29 *** Topcat has joined #gnucash
12:03:41 *** ErKa has quit IRC
12:14:39 *** Jimraehl1 has quit IRC
12:22:41 *** Topcat has quit IRC
12:23:14 *** Topcat has joined #gnucash
12:28:13 *** Topcat has quit IRC
12:28:51 *** Topcat has joined #gnucash
12:33:49 *** Topcat has quit IRC
12:34:24 *** Topcat has joined #gnucash
12:38:02 *** fell_afk is now known as fell
12:43:40 *** ErKa has joined #gnucash
12:49:32 *** Topcat has quit IRC
12:50:05 *** Topcat has joined #gnucash
13:00:05 *** Topcat has quit IRC
13:00:28 *** Topcat has joined #gnucash
13:10:43 *** Topcat has quit IRC
13:17:33 *** ErKa has quit IRC
13:35:28 *** benoitg has joined #gnucash
13:38:44 *** ErKa has joined #gnucash
14:21:25 *** aqua___ has joined #gnucash
14:21:32 *** shanny has quit IRC
14:46:06 *** benoitg has quit IRC
14:53:59 *** Topcat has joined #gnucash
14:58:59 *** Topcat has quit IRC
14:59:31 *** Topcat has joined #gnucash
15:04:33 *** Topcat has quit IRC
15:05:08 *** Topcat has joined #gnucash
15:10:10 *** Topcat has quit IRC
15:10:45 *** Topcat has joined #gnucash
15:21:34 *** shanny has joined #gnucash
15:23:21 *** aqua___ has quit IRC
15:24:59 *** john has quit IRC
15:36:25 *** Topcat has quit IRC
15:37:04 *** Topcat has joined #gnucash
15:56:05 *** mad has joined #gnucash
15:58:43 <mad> I import my account-movements into gnucash, everything works fine. But the thing is… sometimes I pay for things that I 'use up' over a longer period of time. For example I pay 100€ for 10 tickets to some event which I will use up in 4 to 20 months. The whole payment is done in month 0 and also my stats show all expenses on month 0.
15:59:47 <mad> I know the 'propper' way would be to add another asset-account called 'tickets' where I book the actual expense from every time I use one of the tickets.
16:00:31 <mad> But strictly speaking, I would also have to make a food-asset-account and book from it every time I take a box of milk out of my fridge. Which is somewhat stupid <.<
16:02:03 <mad> Is there a way to split up a transaction in a way that it is listed only on the one day (month 0 where I payed the money) but booked at different times?
16:02:19 <mad> Or do I really have to create a new asset-account for each of these cases?
16:05:30 <mad> Because the tickets are one example. I am also doing hall-climbing where I usually pay for 10 times climbing. Or right now my rental-operating-expenses, where I pay a regular fee and at the end of each year, the differential is calculated to the actual expenses and I have to pay additionally. And my rental-operation-expenses diagramm would have a peak at the end of the year then.
16:05:54 <mad> Creating an extra asset-account each time sounds somewhat annoying.
16:12:46 *** Topcat has quit IRC
16:13:23 *** Topcat has joined #gnucash
16:21:13 *** john has joined #gnucash
16:21:14 *** gncbot sets mode: +o john
16:28:31 *** Topcat has quit IRC
16:39:51 *** shanny has quit IRC
16:55:37 *** CeBe1 has quit IRC
17:14:44 *** fell_ has joined #gnucash
17:14:44 *** gncbot sets mode: +o fell_
17:24:28 *** fell has quit IRC
17:41:06 *** fell_ has quit IRC
18:35:31 *** shade304 has joined #gnucash
18:37:43 <shade304> what is the best way to print, export, or copy the "owners" or if I can be specific customers and or vendors? I'm after a list of zip codes right now, but also if I was going to mail statements it would be nice to get a contact list even better if only ones with a balance?
18:59:59 <warlord> mad: If you REALLY want to keep track of your outstanding tickets then yes, you would need an intermediate account and would need to book through it.
19:00:53 <warlord> In general you dont do that unless some tax entity requires you to do; the expense really is incurred when you bought the set of tickets. If you don't use them it's not like you get your money back.
19:01:17 <warlord> shade304: there's no good way to do that through the existing interfaces.
19:03:58 <warlord> You could run the aging reports to get a list of customers or vendors, but it only includes their names. You could use that report as a basis to get the info you want/need.
19:54:55 <shade304> ok
19:55:02 <shade304> thank you
20:14:57 *** sabayonuser2 has joined #gnucash
20:34:51 <sabayonuser2> I extracted the file to desktop and then pulled the zip codes, if you know a more professional way, I was feeling my way in the dark, as you can see from the fifteen pipes
20:35:08 <sabayonuser2> cat myfile.gnucash | grep addr2 | grep , | sed -e 's\</addr:addr2>\\g' | sed -e 's/.*,//g' | sed -e 's/.*\ //g' | sort | uniq > zip.txt
20:58:27 *** mad has quit IRC
21:19:28 <sabayonuser2> discovered zcat works without moving the file and uncompressing, I probably shouldn't be this excited..
21:30:37 *** john has quit IRC
22:27:29 *** ErKa has quit IRC
22:47:24 *** ErKa has joined #gnucash
23:01:54 *** kpreid has joined #gnucash
23:13:08 *** ErKa has quit IRC