2011-12-07 GnuCash IRC logs
00:30:55 <hampton> will do warlord-afk. Let me know if you're up DC way.
00:30:58 *** hampton has left #gnucash
00:42:52 *** pcroque has quit IRC
00:54:03 *** dbreiser has quit IRC
01:53:47 *** Jimraehl2 has quit IRC
02:16:25 *** Krzysiek_K has left #gnucash
03:25:02 *** ErKa has joined #gnucash
03:40:50 *** jonathan has quit IRC
03:49:48 *** jonathan has joined #gnucash
03:49:51 *** opalepatrick has joined #gnucash
04:43:36 *** opalepatrick has quit IRC
04:47:21 *** opalepatrick_ has joined #gnucash
05:11:16 *** fell has joined #gnucash
05:11:17 *** gncbot sets mode: +o fell
05:18:50 *** fellen has quit IRC
05:41:19 *** Krzysiek_K has joined #gnucash
05:43:53 *** morpheous has joined #gnucash
05:45:41 <morpheous> I have considered using gnucash several times in the last few years. I am finally taking the plunge. I need help in mapping my current accounting system (excel based) to GnuCash. For example, how do I set up my daybooks (Sale, SalesReturns, Purchases etc) in gnucash? any links that show how to do this?
06:24:50 *** Krzysiek_K1 has joined #gnucash
06:30:01 *** Krzysiek_K has quit IRC
06:37:52 <fell> morpheous: Did you read the guide? http://svn.gnucash.org/docs/guide/
06:39:19 *** ErKa has quit IRC
06:39:33 <morpheous> @fell: I am reading it now :) I searched Google (and YouTube), but found no obvious items covering this particular issue so I am now working my way through the manual
06:39:33 <gncbot> morpheous: Error: "fell:" is not a valid command.
06:39:43 <morpheous> fell: I am reading it now :) I searched Google (and YouTube), but found no obvious items covering this particular issue so I am now working my way through the manual
06:46:58 <fell> There is no ultimative Account structure. It depends on your target - E.g. "Why is still so much month at the end of my cash?" or tax declaration. What is your situation - business or private user?
06:54:34 <fell> To transfer your current accounting system, you could use Calc2qif and then QIF-import or the integrated csv importer. IIRC there is no need to create the accounts first. The importer should do that for you.
06:59:26 <morpheous> I think you misunderstood my problem. Its actually the daily "procedures" that I want to change from using spreadsheet to gnucash. At the moment, I record sales and purchases daily in my day book. However, I think gnucash uses the wrong terms - what it calls accounts seem to be actually journals - this is what is confusing
07:02:16 <morpheous> Currently, I have record my daily transactions in my journals (daybooks) and then at the end of the month, I post the figures into the relevant account - but gnucash seems to use different terminology from what bookkeepers/accountants use - this is what I am finding confusing - i.e. I don't know how to use gnucash to record my daily transactions (sales, sale returns, purchase, petty cash etc)
07:04:38 <fell> In the time of ink and paper you wrote each transaction at least 3 times: in the journal, the account and the counter account.
07:05:48 <fell> In the time of computers the journal is only a special view over all accounts.
07:08:39 <fell> The usual way in gnucash is, to record the transaction in one account, e.g. cash and name the counter account and voila you can see it in all 3 views: account counteraccount and journal.
07:23:27 *** Jimraehl2 has joined #gnucash
07:24:18 *** Krzysiek_K has joined #gnucash
07:28:44 <morpheous> fell: I think I understand what you are saying. It seems the gnucash terminology is a bit different to what I am used to. I am sure that after reading the online docs, it will become clearer to me. tx 4 ur help anyway
07:29:13 <fell> You are welcome.
07:31:53 *** Krzysiek_K1 has quit IRC
07:58:20 *** Jimraehl2 has left #gnucash
08:04:57 *** warlord-afk is now known as warlord
08:06:03 *** Jimraehl1 has joined #gnucash
08:24:33 *** Krzysiek_K1 has joined #gnucash
08:31:14 *** Krzysiek_K has quit IRC
08:35:28 *** fbond has joined #gnucash
08:36:39 *** Jimraehl1 has quit IRC
08:45:48 *** Krzysiek_K has joined #gnucash
08:46:34 *** Jimraehl1 has joined #gnucash
08:52:54 *** Krzysiek_K1 has quit IRC
09:04:06 *** Krzysiek_K1 has joined #gnucash
09:10:10 *** morpheous has quit IRC
09:10:38 *** ZedDen has joined #gnucash
09:10:39 *** Krzysiek_K has quit IRC
09:15:16 *** ZedDen has quit IRC
09:18:36 *** morpheous has joined #gnucash
09:29:34 *** Krzysiek_K has joined #gnucash
09:31:45 *** Krzysiek_K1 has quit IRC
09:32:13 *** groggycl has joined #gnucash
09:32:44 <groggycl> hi? anyone can help me with a paste to excel question?
09:36:35 <warlord> groggycl: it's considered impolite to send PMs without asking. Just ask your question (here)
09:36:50 <groggycl> :O sory
09:37:10 <groggycl> I didn't know
09:39:44 <groggycl> well, I have a cash flow report and it is giving me all the info with the CLP (chilean peso) prefix and I just can't got it properly pasted onto excel. there's no way I can paste just the numbers so I can work them easily
09:41:05 <warlord> You have a couple options:
09:41:41 <warlord> 1) quit gnucash and restart it in a Chilean locale, so that CLP is the Locale Currency. Then it would print the locale currency symbol instead of the text 'CLP'
09:42:07 <warlord> 2) export the report as HTML and then run it through a processor (like sed, perl, etc) to strip out all occurances of CLP.
09:42:10 <warlord> ... and then load the resultant edited file into excel.
09:46:08 <groggycl> thanks man, looking at the first option u gave me, it turns out I had gnucash defualt currency as argentina's peso, so that's why the software used the CLP to describe the numbers..
09:46:20 <groggycl> thank u very much and sory about the PM
09:50:26 *** groggycl has quit IRC
09:51:35 *** kpreid has quit IRC
09:53:53 *** pcroque has joined #gnucash
10:01:26 *** kpreid has joined #gnucash
10:23:17 *** Krzysiek_K1 has joined #gnucash
10:23:55 *** hpj has joined #gnucash
10:27:22 *** Krzysiek_K has quit IRC
10:41:48 *** Krzysiek_K1 has quit IRC
10:49:48 *** kpreid has quit IRC
10:55:20 *** kpreid has joined #gnucash
10:55:48 *** linas has joined #gnucash
10:58:17 *** linas_ has joined #gnucash
10:58:18 *** linas has quit IRC
10:59:37 *** morpheous has quit IRC
11:01:45 *** linas__ has joined #gnucash
11:01:45 *** linas_ has quit IRC
11:05:18 *** linas_ has joined #gnucash
11:05:18 *** linas__ has quit IRC
11:18:55 *** linas__ has joined #gnucash
11:18:56 *** linas_ has quit IRC
11:31:57 *** linas_ has joined #gnucash
11:32:00 *** linas__ has quit IRC
11:53:38 <linas_> hey, gnucash.org is being slashdotted .. any clue why?
12:02:51 *** linas__ has joined #gnucash
12:02:52 *** linas_ has quit IRC
12:04:50 *** linas_ has joined #gnucash
12:04:50 *** linas__ has quit IRC
12:08:56 *** linas__ has joined #gnucash
12:08:57 *** linas_ has quit IRC
12:18:30 *** arnotixe has joined #gnucash
12:18:35 *** kpreid has quit IRC
12:24:19 <warlord> linas__: I'm afraid I don't know..
12:25:19 *** Krzysiek_K has joined #gnucash
12:25:52 <warlord> linas__: What URL(s) are they hitting?
12:26:22 <linas__> main page ...
12:26:43 <linas__> I tried to look for a common referer, but don't really see one either
12:27:08 <warlord> Maybe it's just end-of-year stuff?
12:27:31 <linas__> its wayy out of normal, something like 3x 4x of the usual traffic
12:27:46 <linas__> and it ramped up over the course of several hours
12:27:54 <warlord> weird.. I didn't see anything on slashdot..
12:28:19 <linas__> can you access gnucash.org/mrtg/ or is that blocked for you?
12:28:25 <warlord> code.gnucash.org isn't seeng that.
12:28:41 <warlord> ( trying )
12:28:50 <warlord> 404
12:28:59 <warlord> (Not found)
12:30:13 <linas__> I lied, most of the traffic *does* have one referer
12:30:23 <linas__> m eyes glazed ovrer the url
12:30:24 <linas__> its
12:30:28 <linas__> http://www.komando.com/downloads/category.aspx?id=6107&utm_medium=nl&utm_source=dotd&utm_content=2011-12-07-article&utm_campaign=end
12:31:19 <linas__> which looks like an ad-infested blah
12:32:39 <linas__> but it seems to be driving all the excess traffic, and its a lot.
12:32:52 <linas__> let me try to get mrtg access for you
12:34:40 <warlord> Interesting.
12:34:54 <linas__> yeah, http://www.komando.com/ has "free daily download" on the front page, which points to article on gnucash who knew
12:35:19 <warlord> It only mentions windows and OSX, not Linux.
12:36:07 <warlord> I guess Kim Komando talked about GnuCash on her show..
12:36:13 <warlord> How big is your pipe?
12:37:14 <linas__> are you accessing mrtg from 18.* and did you put a slash at the end of the url?
12:37:45 <linas__> have you heard of kim komando before?
12:38:00 <linas__> I haven't ..
12:38:01 <warlord> No, I have not .. and no, I am not..
12:48:54 <warlord> ah, now I see mrtg
12:52:25 *** linas_ has joined #gnucash
12:52:26 *** linas__ has quit IRC
12:52:59 *** linas_ has quit IRC
12:53:26 *** linas_ has joined #gnucash
12:53:43 <linas_> irc keeps dropping me due to the traffic ..
12:57:58 <warlord> :(
12:58:05 <warlord> How big is your pipe?
12:58:30 <linas_> not entirely sure any more.
12:59:21 <linas_> under 2 mbits/sec based on the graph, but I think I'm supposed to get more.
13:00:29 <linas_> the marketing special offers etc is so full of churn, I just can't tell
13:02:37 <linas_> that and the fact that my kid is constantly downloading/uploading somethng, 24x7 and he won't tell me what.
13:02:47 *** kpreid has joined #gnucash
13:02:49 <linas_> manga or anime or something ..
13:19:14 <warlord> LOL. You could always rate-limit his address ;)
13:19:52 <linas_> yeah, I got him to voluntarily rate limit
13:22:26 *** ErKa has joined #gnucash
13:24:25 <warlord> Well, at least there is that much!
14:29:49 *** fell has quit IRC
14:33:10 *** warlord is now known as warlord-afk
14:37:48 *** fell has joined #gnucash
14:37:49 *** gncbot sets mode: +o fell
14:51:43 *** kpreid has quit IRC
14:56:06 *** felle has joined #gnucash
14:56:07 *** gncbot sets mode: +o felle
14:59:20 *** kpreid has joined #gnucash
15:01:17 *** opalepatrick_ has quit IRC
15:04:13 *** fell has quit IRC
15:15:38 *** fellen has joined #gnucash
15:15:39 *** gncbot sets mode: +o fellen
15:23:38 *** felle has quit IRC
15:31:52 *** fell has joined #gnucash
15:31:52 *** gncbot sets mode: +o fell
15:40:17 *** fellen has quit IRC
15:49:14 *** kpreid has quit IRC
15:54:43 *** linas__ has joined #gnucash
15:54:44 *** linas_ has quit IRC
15:58:25 *** kpreid has joined #gnucash
16:53:05 *** KaiForce has quit IRC
17:35:48 *** warlord-afk is now known as warlord
18:03:20 *** fDavid has joined #gnucash
18:10:41 *** Sparxz has joined #gnucash
18:11:30 *** sparxz_ has joined #gnucash
18:17:07 *** fbond has quit IRC
18:44:05 *** kpreid has quit IRC
18:49:05 *** felle has joined #gnucash
18:49:05 *** gncbot sets mode: +o felle
18:57:00 *** kpreid has joined #gnucash
18:57:20 *** fell has quit IRC
19:02:20 *** Sparxz has quit IRC
19:02:20 *** sparxz_ has quit IRC
19:10:16 *** kpreid has quit IRC
19:12:43 *** Sparxz has joined #gnucash
19:12:53 *** sparxz_ has joined #gnucash
19:16:28 *** Sparxz has quit IRC
19:16:29 *** sparxz_ has quit IRC
19:23:55 *** Mer|in has quit IRC
19:27:51 *** fDavid has quit IRC
20:03:29 *** ironwolf has left #gnucash
21:41:46 *** markjenkinsparit has quit IRC
22:04:50 *** warlord is now known as warlord-afk
22:56:55 *** linas_ has joined #gnucash
22:56:56 *** linas__ has quit IRC