2009-02-14 GnuCash IRC logs
01:25:05 *** glick has joined #gnucash
01:25:07 <glick> hi
01:25:26 <glick> anyone here?
01:28:01 <gxti> nobody here but us chickens
01:28:23 <glick> heh
01:28:29 <glick> did i do this right
01:28:33 <glick> so i set up an account
01:28:38 <glick> an account hiarchy
01:28:45 <glick> the basic common one
01:28:55 <glick> and i added an account called personal loan
01:29:12 <glick> i borrowed 3k from my bro
01:29:49 <glick> so i created a transaction thats a transfer from Equity:Opening Balances, and created a credit for 3k
01:30:02 <glick> is that right?
01:30:16 <gxti> that's not how i'd do it, although there's usually more than one way to do it
01:30:35 <gxti> i'd create the personal loan account under liabilities, then transfer $3000 from that account to checking
01:30:36 <glick> how should i do it?
01:30:54 <glick> no i already had the money and spent it
01:30:58 <glick> i just owe him now
01:31:24 <gxti> hm, then maybe transfer it to opening balance
01:31:42 <glick> i did, from Equity:Opening Balances
01:31:48 <glick> and credited it into the account
01:32:01 <gxti> to the loan? but you don't have that money, it's money you owe
01:32:09 <glick> thats right
01:32:09 <gxti> it should have a negative balance
01:32:10 <glick> i owe it
01:32:12 <glick> i dont have it
01:32:16 <glick> right
01:32:20 <gxti> though since it's a liability gnucash will invert it for you
01:32:58 <gxti> ok, as long as A) the loan account is a liability and B) you transferred the money *out* of that account
01:33:09 <glick> in Accounts I see my Equity as being red and in parenthesis
01:33:42 <glick> so is that right?
01:33:52 <gxti> it sounds OK to me
01:34:20 <gxti> you could also have created an expense account for whatever you spent the money on and transferred it there
01:35:41 <glick> so whenever i make a payment, i transfer it from some other account and make a debit transaction into the loan account?
01:36:14 <gxti> yes (i think, i still can't keep debit/credit straight)
01:36:29 <glick> debit == deposit
01:36:32 <glick> :)
01:36:44 <glick> both begin with de
01:37:26 <glick> hehe damn its pitiful how little money i have
01:37:31 <glick> and gnucash lays it all out for me
01:37:39 <glick> its laughing at me
01:37:51 <gxti> banks did a good job of making it confusing by having debit cards and credit cards, both of which are used on the same end of a transaction
01:38:11 <glick> heh yeah
01:38:46 <glick> lotta red
01:38:47 <glick> :(
01:38:49 <glick> ugh
01:39:43 <glick> is there a way i can have gnucash automatically keep track of what my stock is worth?
01:39:53 <glick> or do i have to check its value every so often and update it manually?
01:40:08 <gxti> it can pull down quotes from yahoo, and you can even make a cronjob to update it automatically
01:40:27 <gxti> the wiki has some information on that
02:09:36 <glick> damn looks like i cant connect to my bank :(
02:13:41 *** PossumII has joined #gnucash
02:24:27 *** chris has quit IRC
02:37:46 *** chris has joined #gnucash
03:10:54 *** hvx has joined #gnucash
03:59:05 *** bentob0x has joined #gnucash
04:38:20 *** andyt has joined #gnucash
04:48:09 *** PossumII has quit IRC
04:53:51 <glick> hey howcome when you split a transaction
04:54:06 *** PossumII has joined #gnucash
04:54:59 <glick> i dont understand this picture
04:55:00 <glick> http://svn.gnucash.org/docs/guide/txns-registers1.html
04:55:13 <glick> at thebottom of the page
04:58:00 <PossumII> can I do depreciation with gnucash thx
05:28:12 *** bluefox has quit IRC
05:48:00 *** ErKa has joined #gnucash
06:09:20 *** andyt has quit IRC
06:13:08 *** andyt has joined #gnucash
06:45:09 *** Jimraehl has left #gnucash
06:52:51 *** cortana has joined #gnucash
07:00:55 *** Jimraehl has joined #gnucash
07:12:26 *** warlord-afk is now known as warlord
07:12:40 <warlord> PossumII: Sure! It's even discussed in the docs. Have you read them?
07:12:55 <PossumII> IM there now
07:13:00 <PossumII> thx
07:13:08 <warlord> glick: what don't you understand?
07:13:32 <PossumII> I like my Accountant.. but I want to replace him
07:14:46 <PossumII> hey the funny thing is I was working on a tutorial for gnucash and was not looking at this chat...Thats what I do..I make tutorials :)
07:16:34 <PossumII> I do have one important question I cant see in the docs.. how do yu close an opened Tab
07:17:17 <PossumII> For INstance if I have the Checking Interest Tab open.. How do I close it
07:21:31 <warlord> Click on the "Close" button in the toolbar.
07:21:51 <warlord> Sorry, I've gotta run..
07:21:53 *** warlord is now known as warlord-afk
07:21:56 <PossumII> I am such a geek wow
07:22:00 <PossumII> thx
07:22:12 <PossumII> OK..Im new.. thats my excuse
07:23:01 <PossumII> I just did a web page on how to find and download gnucash.. I will show you .. but only if you want.. so you dont think Im a spammer
07:25:57 *** palatin has joined #gnucash
08:13:24 <PossumII> hello
08:39:21 *** palatin has quit IRC
08:59:11 *** hstoellinger has joined #gnucash
09:01:58 <hstoellinger> hello, I am new to gnucash (Linux). I have been using a commercial accounting system under windows for a while (for accounting within a wind band). In that system there existed a capability of defining "templates" for transactions. This makes a lot of sense, since many transactions are of the same type and differ only in the amount and - maybe date and text. Is there something like that in Gnucash?
09:04:38 *** hvx has quit IRC
09:06:31 <cortana> hstoellinger: not really, afaik. gnucash will however auto complete a transaction using a previously entered one (fills in all fields to match it, and you can change them afterwards)
09:06:38 <cortana> autocomplete-as-you-type kind o fthing
09:10:58 *** Jimraehl has left #gnucash
09:11:38 *** JimRaehl2 has joined #gnucash
09:14:24 *** JimRaehl2 has left #gnucash
09:14:52 *** JimRaehl2 has joined #gnucash
09:22:08 *** hstoellinger has quit IRC
09:25:40 *** hstoellinger has joined #gnucash
09:25:41 <hstoellinger> Cortana: thanks a lot. Is there a concept like an "Accounting Year"? I would like to open a new year's accounts with the balance of the previous year. My "old" system does this by simply setting a switch.
09:28:06 <cortana> recent versions added a 'close books' feature but i have not used it
09:28:25 <cortana> i think it does what you describe though
09:35:46 *** hstoellinger has quit IRC
09:47:49 *** Demitar has quit IRC
09:50:44 *** Demitar has joined #gnucash
09:58:51 *** Zoolooc has joined #gnucash
10:07:58 *** PossumII has quit IRC
10:59:09 *** andi5 has joined #gnucash
10:59:09 *** gncbot sets mode: +o andi5
11:01:41 *** KaiForce has joined #gnucash
11:03:49 <KaiForce> dumb question: when importing from my bank, the ATM withdrawals are showing all red and no action is selected - which is the proper action to take for cash withdrawals from a checking account?
11:05:44 <andi5> KaiForce: i think you can double-click the splits and assign them to the according remote accounts
11:05:45 <test-gncbot> andi5: Sent 1 week, 5 days, 22 hours, and 2 minutes ago: <warlord> we should update the About page copyright to say 2009
11:05:56 <andi5> test-gncbot: who are you?
11:05:56 <test-gncbot> andi5: Error: "who" is not a valid command.
11:07:05 <KaiForce> andi5: it wants me to select either the A or R column first - and I can't tell from looking at other transactions which is the correct one. I'm trying to find this documented somewhere
11:07:52 <andi5> hm... double click, select an account and i think A should be selected and the split be green (r stands for reconciling an existing transaction)
11:08:20 <KaiForce> ah yes, you are correct.
11:08:20 <andi5> i think there is a help button somewhere
11:08:30 <KaiForce> I found it, thanks for your help.
11:08:36 <andi5> you are welcome .)
11:08:47 <KaiForce> oh, and Quicken, you can s*ck me!
11:08:50 <KaiForce> :)
11:08:54 <andi5> :-D
11:15:08 *** bluefox has joined #gnucash
11:25:46 *** earthwalker has left #gnucash
11:40:11 *** goodger has quit IRC
11:45:18 *** goodger has joined #gnucash
11:50:57 *** ErKa has quit IRC
12:10:02 *** andyt has quit IRC
12:23:16 *** andyt has joined #gnucash
12:34:04 *** xi1 has joined #gnucash
12:34:38 <xi1> I just upgraded from 2.2.4 to 2.2.6 via ubuntu 8.10, and now the online quote retrieval fails for all tickers. gnc-fq-dump still works fine though in retrieving the quotes
12:34:51 <xi1> anyone know whats wrong?
12:35:23 <xi1> it juts says: "unable to retrieve quotes for..." and then the list of tickers
12:35:26 <andi5> are you using yahoo europe?
12:36:36 <xi1> many of them are set up to use vanguard
12:36:47 <xi1> i don't know if any are yahoo europe
12:36:49 <xi1> its possible
12:39:06 <andi5> i do not understand that answer, just check the quote source information in the "edit security dialog" as can be reached from the security editor
12:40:28 <xi1> yes, the quote source is vanguard
12:40:33 <andi5> ok, you mean that most likely those securities failing are not from yahoo europe, right?
12:40:40 <xi1> correct
12:41:14 <andi5> have you tried gnc-fq-helper?
12:42:35 <andi5> https://lists.gnucash.org/pipermail/gnucash-user/2009-February/028576.html might apply to you
12:42:46 <andi5> found via https://lists.gnucash.org/search/
12:45:46 <xi1> hm
12:45:50 <xi1> ill reinstall finance::quote
12:56:52 <xi1> yeah that seems to fix it
12:56:55 <xi1> thx
12:56:58 <andi5> np
13:10:31 *** palatin has joined #gnucash
13:22:46 *** KaiForce has quit IRC
13:26:01 *** patrick has joined #gnucash
13:42:29 <patrick> It seems there is a corruption during the packaging of gnucash
13:42:58 <patrick> the files /usr/share/gnucash/accounts/fr_*/acctchrt_business.gnucash-xea contains strange chars
13:43:15 <andi5> what version of gnucash?
13:43:22 <patrick> eg. "
13:43:23 <patrick> Les utilisateurs g�rant une entreprise s�lectionneront ceci au lieu des autres choix. Ceci inclut tous
13:43:25 <patrick> les comptes dont vous avez besoin dans la plupart des activit�s, y compris les paiements diff�r�s, les
13:43:26 <patrick> rentr�es et les sorties.
13:43:43 <patrick> 2.2.6
13:44:23 <patrick> I've seen in CVS that the file hasn't changed since 2 years already
13:44:34 <patrick> file is OK in CVS
13:44:58 <patrick> stange chars are in facts chars with accent
13:45:03 <andi5> what do you mean by "strange chars"? do them appear incorrectly in gnucash?
13:45:08 <patrick> eg. é à è...
13:45:41 <patrick> I see in the file a questionmark in a rotated sqare
13:46:02 <andi5> that is probably your editor's fault then
13:46:14 <andi5> what operating system do you use?
13:46:19 <patrick> linux
13:46:26 <andi5> what is your locale?
13:46:27 <patrick> Kubuntu 8.10
13:46:36 <patrick> fr_BE
13:46:49 <andi5> completely, i mean, i.e. what charset, UTF-8 i suppose?
13:46:49 <patrick> but I copied fr_FR to fr_BE
13:46:54 <andi5> what is your editor then
13:47:14 <patrick> the more command
13:47:25 <andi5> use less instead
13:47:36 <andi5> LANG=fr_FR.ISO-8859-15 less <file>
13:48:19 <patrick> less returns
13:48:22 <patrick> Hi<E9>rarchie compl<E8>te de comptes pour les affaires.
13:48:45 <patrick> instead of
13:48:51 <patrick> Hiérarchie complète de comptes pour les affaires.
13:48:56 <andi5> but strangely enough, the xml does not specify the iso encoding...
13:49:39 <patrick> gnucash doesn't accept this original gnucash-xea file
13:50:11 <andi5> lemme see
13:50:21 <andi5> (need to generate the locale first :))
13:50:32 <patrick> after having replaced the one from the ubuntu package by the one copied/pasted from the SVN, it's ok
13:53:31 <andi5> is that the only template misfunctioning?
13:53:36 *** andyt has quit IRC
13:54:04 <andi5> btw, may you run tail on the ubuntu file, please?
13:54:13 <andi5> i mean head instead of tail, sorry
13:55:40 <patrick> I'm trying the others gnucash-xea files...
13:57:43 <andi5> ok, i have run a nicely short grep and fr_{CH,FR}/*business* seem to be the only file missing the encoding
13:58:57 <patrick> all the others seems to be ok... although they contains the sames <E9> codes
13:59:23 <cortana> same in the debian package
14:00:46 <andi5> for file in fr_{CH,FR}/acctchrt_business.gnucash-xea ; do sed -i '1s,?>, encoding="ISO-8859-1"?>,' $file ; done
14:00:46 <andi5> run this in the accounts directory
14:04:16 <patrick> it's OK after this command
14:04:29 <andi5> should be fixed in gnucash 2.2.9
14:04:41 <patrick> great !
14:05:17 <patrick> i wouldn't have expected a so quick fix from microsoft ;)
14:05:21 <patrick> Thanks !
14:05:30 <andi5> http://svn.gnucash.org/trac/changeset/17899 is yours... thanks :)
14:09:22 *** ErKa has joined #gnucash
15:26:03 *** xi1 has quit IRC
15:30:27 *** sjc has joined #gnucash
16:13:04 *** ErKa has quit IRC
16:21:40 *** bluefox has quit IRC
16:22:48 <fbond_> andi5: Hi!
16:22:52 *** fbond_ is now known as fbond
16:23:03 <andi5> hi forest
16:23:35 <fbond> andi5: I have a patch at http://bugzilla.gnome.org/show_bug.cgi?id=570895 that I was hoping I could get applied.
16:23:45 <fbond> andi5: I have a quick tweak to make first, though.
16:23:59 <fbond> Do you think you might be able to get it into trunk for me?
16:24:16 <fbond> I am testing a text change and then I will upload an updated patch.
16:24:37 <andi5> sure
16:24:53 <andi5> i am not sure i will do that today though
16:25:40 <fbond> andi5: Okay, whenever you have time.
16:27:43 <andi5> is bugzilla slow for you as well?
16:30:52 *** glick has quit IRC
16:31:25 <fbond> andi5: Hm, I haven't been using it all that much yet today.
16:32:25 <andi5> ok
16:33:34 <fbond> Yes, it does seem to be slow, but only certain actions.
16:40:09 <andi5> ciao
16:40:17 <fbond> andi5: Bye.
16:40:21 *** andi5 has quit IRC
16:49:59 *** twunder has joined #gnucash
16:53:12 *** palatin has quit IRC
17:04:57 *** jcreigh has joined #gnucash
17:10:31 *** bluefox has joined #gnucash
17:24:53 *** twunder has quit IRC
17:46:01 *** patrick has quit IRC
17:55:27 *** cort has joined #gnucash
18:01:04 *** glick has joined #gnucash
18:04:23 *** cortana has quit IRC
18:11:38 *** glick has quit IRC
18:22:39 *** jcreigh has quit IRC
18:51:01 *** bentob0x has quit IRC
19:18:06 *** Zoolooc has quit IRC
19:43:08 *** jpeach has joined #gnucash
19:46:13 *** glick has joined #gnucash
19:52:46 *** PossumII has joined #gnucash
19:53:40 *** jpeach has left #gnucash
19:54:49 *** PossumII has quit IRC
20:24:43 *** JimRaehl2 has left #gnucash
20:25:23 *** Jimraehl has joined #gnucash
21:11:36 <glick> excuse me i have a gnucash question
21:12:01 <glick> i made a transaction to an acount for 300 bucks, 250 of which came from checking and 50 of which came from cash
21:12:17 <glick> how do i enter that as a split transaction
21:22:45 *** glick has quit IRC
21:32:28 *** sjc has quit IRC
22:21:14 *** cort has quit IRC
23:20:32 *** bluefox has quit IRC
23:22:52 *** bluefox has joined #gnucash
23:49:02 *** gxti has quit IRC
23:49:04 *** gxti has joined #gnucash