2008-03-09 GnuCash IRC logs
00:25:37 *** warlord has joined #gnucash
00:25:37 *** gncbot sets mode: +o warlord
00:52:03 *** bock has joined #gnucash
01:11:46 *** wizkid238 has joined #gnucash
01:14:27 *** warlord is now known as warlord-afk
01:20:42 *** wizkid239 has quit IRC
01:36:06 *** joerlend_ has joined #GnuCash
01:44:35 *** XiXaQ has quit IRC
03:57:15 *** Zoolooc_ has joined #gnucash
04:20:33 *** XiXaQ has joined #GnuCash
04:28:35 *** joerlend_ has quit IRC
06:02:28 *** ErKa has joined #gnucash
06:06:30 *** cort has quit IRC
06:26:01 *** cortana has joined #gnucash
07:04:29 *** ErKa has quit IRC
07:12:19 *** ErKa has joined #gnucash
07:18:45 *** cortana has quit IRC
07:20:14 *** kielein has joined #gnucash
07:26:45 *** cortana has joined #gnucash
08:05:23 *** IanL has joined #gnucash
08:12:03 *** IanL has left #gnucash
08:12:44 *** _gunni_ has joined #gnucash
08:59:14 *** wizkid239 has joined #gnucash
09:00:17 *** _McLANE_ has joined #gnucash
09:04:26 *** wizkid238 has quit IRC
09:05:38 *** twunder has joined #gnucash
09:38:06 *** _McLANE_ has quit IRC
10:01:09 *** twunder has quit IRC
10:06:41 *** |gunni| has joined #gnucash
10:06:41 *** _gunni_ has quit IRC
11:06:51 *** vinci has joined #gnucash
11:09:28 *** _McLANE_ has joined #gnucash
11:11:42 *** _McLANE_ has quit IRC
12:19:16 *** kingofleon has joined #gnucash
12:19:19 <kingofleon> hi
12:19:39 <kingofleon> any idea how i can change the language of my gnucash for windows?
12:28:13 <kingofleon> second question: how do i delete bills that wr
12:28:16 <kingofleon> ere
12:28:21 <kingofleon> were entered before
12:28:35 <kingofleon> ::: sorry for the multiple lines :::
12:50:04 <jsled> kingofleon: re: changing language, see <http://wiki.gnucash.org/wiki/FAQ#Q:_I_want_to_use_GnuCash_in_my_own_language>.
12:50:10 <jsled> I don't know the other answer.
12:54:00 <kingofleon> thank you. but it doesn't work
12:54:31 <kingofleon> i added this line to gnucash.bat on my windows OS
13:11:28 *** bock has left #gnucash
13:20:50 *** warlord-afk has quit IRC
14:19:38 *** andi5 has joined #gnucash
14:19:38 *** gncbot sets mode: +o andi5
14:22:02 <andi5> kingofleon: rather use "set LANG=fr_FR" (for french)
14:24:03 <kingofleon> doesnT work.
14:24:51 <andi5> what did you insert and is that before the last line, containing the "start gnucash-bin"?
14:24:53 <kingofleon> the menus are in a mixture of english and turkish (my native lang).
14:25:04 <andi5> well... that is a completely different story then
14:25:21 <kingofleon> i want it in pure english
14:25:28 <andi5> the localization simply is not complete and out-of-date, i think
14:25:32 <andi5> ah, use LANG=C then
14:25:45 <kingofleon> set LANG=C ?
14:25:47 <andi5> or en_US
14:25:57 <andi5> sure
14:26:30 <kingofleon> where in the bat file should it be? is it ok at the top
14:26:42 <andi5> yes
14:27:13 <andi5> you can also set that as global or user specific environment variable, using windows utilities
14:27:46 <andi5> (http://support.microsoft.com/kb/310519)
14:27:47 <kingofleon> it works now. thank you. (i guess i placed it after the start command. that's why it didn't work)
14:28:04 <andi5> after a moment of thought, do you think that could work? ;-)
14:28:22 <andi5> but i am sorry ...
14:28:51 <kingofleon> i didn't check ;)
14:29:25 <kingofleon> any ideas how i can remove bills that are entered but shouldn't be there in the first place?
14:30:43 <andi5> http://www.gnucash.org/pipermail/gnucash-user/2003-March/006106.html ... i think that is still true
14:32:41 <kingofleon> hmm
14:32:48 <kingofleon> ok. thank you very much.
14:32:58 <kingofleon> i'll continue with my work now.
14:33:06 <kingofleon> by
14:33:08 <andi5> bye
14:33:12 *** kingofleon has quit IRC
15:18:04 <foo> hm, do I need to manually go back to all transaction and changed them from "n" to "c" for R column? c for cleared... or is that more for my purpose? eg. if I leave things at n would hurt anything?
15:21:25 <andi5> not at all, why do you think you should change them?
15:23:00 *** katewill has joined #gnucash
15:23:42 <katewill> new user here. want to import qdb files from quicken 6 (yes, very old). No mention of this in help files. Is this possible? thanks vm.
15:24:17 <andi5> does that mean that quicken 6 does not save in qif files?
15:25:33 <katewill> thanks, it might, but I lost my copy of it and only have the data files which are qdb and other related formats.
15:26:28 <katewill> just chekcing, there appear to be four files one each in these formats: qdb qel qmd and qsd.
15:26:56 <andi5> i am sorry, i have never used quicken :)
15:27:11 <katewill> perhaps you are lucky ;-) wish there was something about this in the gnu help pages.
15:27:40 <andi5> i suppose gnucash will not load it as qif file?;-)
15:28:23 <katewill> no it does not see the file when I try to run the import wizard (AKA druid?).
15:28:57 <andi5> cannot you change the filter to match all files instead of only *.qif ones? ... and yes wizard =^= druid
15:30:43 <katewill> no it does not see the file when I try to run the import wizard (AKA druid?).
15:31:25 <katewill> sorry, meant to say -- tried it on all four files, druid responded, file does not appear to be a qif file
15:32:09 <katewill> have looked all over for a qdb to qif convertor.
15:34:38 <andi5> i do not know
15:34:45 *** andi5 is now known as andi5|away
15:36:16 <katewill> ok, thanks for consulting, bye
15:42:43 <andrewsw-afk> n
15:42:45 *** andrewsw-afk is now known as andrewsw
16:02:56 <foo> andi5|away: just wasn't sure if I had to go back to make all as "cleared" or not, anywho - thnaks
16:19:52 *** jcreigh has joined #gnucash
16:24:18 *** twunder has joined #gnucash
16:50:03 *** twunder has quit IRC
16:52:26 *** sjc has joined #gnucash
16:59:12 *** warlord has joined #gnucash
16:59:12 *** gncbot sets mode: +o warlord
16:59:45 *** andi5|away is now known as andi5
16:59:59 <warlord> jsled: there's a FAQ for kingofleon's other question as well.
17:09:46 *** katewilliamsnow has joined #gnucash
17:10:45 *** katewilliamsnow has left #gnucash
17:17:28 *** warlord is now known as warlord-afk
17:21:48 *** Brandon has joined #gnucash
17:23:36 <zarchne> katewill: you may be able to write your own qdb interpreter...
17:28:02 <Brandon> I have a budget set up. I have the liability account set up in the budget, but any payments appear as a negative number. I'm trying to track my payments to a liability, not the liability itself. Thoughts?
17:28:22 <andi5> Q: do americans typically run with LANG=en_US or LANG=C?
17:31:24 <katewill> zarchne: very sorry, don't know how to code... am hoping to find another copy of quicken 6 and am interested in switching to gnucash so if quicken 6 facilitates an export as qif, i'll be on GC. if writing an interpreter is easy and/or an interesting challenge to someone I'll be very grateful.
17:31:28 <freakynl> andi5: wouldn't know, but on gentoo, neither, they just aren't set and thus default to LANG=C i presume
17:32:01 <andi5> freakynl: right, no LANG is the same as C, as long there is no other locale environment variable changing defaults
17:32:01 <freakynl> atleast, there's only advice in the manual to set them if you need it differently :)
17:32:26 <freakynl> but it would be highly distro dependent i suppose
17:32:49 <andi5> freakynl: is there a way to choose a language when install a binary gentoo base system? en_US is not set, but de_DE is?
17:34:03 <andi5> freakynl: put it differently, in the gnucash report menu, do the items appear in a) strict lexicographic order, b) first menu items, then submenus, both lists sorted lexicographically?
17:34:36 <freakynl> not that i'm aware of, not really familiar with how it works on a compiler lvl, we have to set /etc/locale.gen, i think that will determine what languages will be build
17:34:48 <zarchne> katewill: it might not be as difficult as you think, but I'm not volunteering to do it for you.
17:35:30 <katewill> i understand, no problem, might be a summer vacation project ;-)
17:35:40 <zarchne> katewill: Have you tried reading the files with a more recent copy of Quicken?
17:35:54 <katewill> no -- don't have more recent copy
17:37:09 <zarchne> There are ways to aquire such things.
17:37:40 <freakynl> hmm i usually have LANG=en_US.UTF-8 (cause I override some LC's to dutch, like papersize, time format etc) in which case, a. if i unset LANG and the LC_*'s b
17:38:50 <freakynl> both don't make much sense to me, kinda used to c, first folders then items, both sorted lexicographically :)
17:39:43 <andi5> yeah... that is what i would want as well... but what do you actually see?
17:44:42 <freakynl> with LANG=en_US.UTF-8, a, with LANG and LC* unset b
17:45:01 <andi5> yep
17:45:06 <andi5> thanks a lot!
17:45:13 <freakynl> np
17:45:31 <freakynl> time to hit the hay now, thanks for the help
17:45:43 *** freakynl has quit IRC
17:49:28 *** kielein has quit IRC
17:50:14 *** XiXaQ has quit IRC
17:53:48 *** XiXaQ has joined #GnuCash
18:10:24 *** katewill has left #gnucash
18:20:31 *** ErKa has quit IRC
18:34:18 <Brandon> I have a budget set up. I have the liability account set up in the budget, but any payments appear as a negative number. I'm trying to track my payments to a liability, not the liability itself. Thoughts?
18:35:16 *** andi6 has joined #gnucash
18:37:54 <andrewsw> Brandon: there is a preference for whether liability accounts have the signs reversed, might that apply in this case?
18:40:02 <andrewsw> hmmm... maybe.
18:40:27 <andrewsw> Edit->Preferences->Accounts "Reverse Balanced Accounts" select or deselect "credit accounts"
18:41:11 <Brandon> i'll give that a shot
18:41:12 <Brandon> thanks
18:41:34 <Brandon> i don't think that will apply
18:42:09 <Brandon> the balances are all positive in the account view
18:42:16 <Brandon> but not in the report
18:42:38 <andrewsw> FWIW, I don't think budgeting is really set up to handle assets/liabilities, so any solution will be a kludge at best.
18:42:51 <andrewsw> why not make the budgeted amount negative as well?
18:43:33 <andrewsw> or set up a suspense expense account to flush those payments through. It means an extra txn, but if you are more concerned about budgeting that strict accounting, it would work.
18:43:49 <Brandon> i have a budget.. i can spend 300 on food, 75 on cell phone, 500 on rent, and 500 on paying off my liabilities
18:44:05 <Brandon> is there not a way to make this program show you where you're sitting that month on those numbers?
18:44:17 *** andi5 has quit IRC
18:44:38 <andrewsw> for the expense items, yes. for the liabilities, not so much. (note that I don't work with budgets...)
18:44:46 <Brandon> ok
18:44:59 <Brandon> does gnucash have add-ons/plugins?
18:45:43 <andrewsw> I think it has a plugin architecture, but it's not utilized.
18:47:26 <andrewsw> to your budget problem: create an expenses called "liability payoff" and set a budget amount for that expense. Then for every payment to a liability, pay it to that expense instead and then enter a second txn from the expense to the real liability and then finally exclude txns that touch that liabiltiy from the report.
18:47:40 <andrewsw> just a shot in the dark there.
18:47:47 <Brandon> yeah, that'd be a solution
18:48:01 <Brandon> thanks
18:48:40 *** andi6 has quit IRC
18:53:13 <Brandon> it's a little rough around the edges.. but gnucash is pretty impressive
18:56:22 <Brandon> Ok, money I take out of the ATM is a credit from "Checking Account" and a debit to "Cash in Wallet"
18:56:34 <Brandon> right?
18:56:46 <andrewsw> yep
18:57:06 <Brandon> so.. at the end of the year.. i'm going to have a grand or two in "Cash in Wallet"
18:57:14 <Brandon> ... which isn't the amount of cash i have in my wallet
18:57:34 <Brandon> is it usual to let this be.. or is it proper to create transactions between the cash in your wallet and the expense accounts
18:57:43 <andrewsw> you need to account for how you spend your cash
18:57:50 <andrewsw> yes
18:57:54 <Brandon> yeah.. or else your net worth will be all wrong
18:58:12 <Brandon> that'd be a complicated thing to do... to track cash
18:58:18 <Brandon> do you do that andrewsw?
19:10:03 <andrewsw> Brandon: no.
19:10:11 <andrewsw> I don't get to carry cash. they won't let me ;)
19:10:16 <Brandon> ?
19:10:48 <andrewsw> I just allocate it to what I think I'll spend it on. or to "Expenses:Adults:Andrew personal"
19:11:29 *** Zoolooc_ has quit IRC
19:11:58 <jcreigh> Brandon: I track the cash in my wallet. It's not too hard. I just save my reciepts for cash purchases and enter them at the end of the day.
19:12:21 <Brandon> yeah, thats what i do with my debit card
19:12:48 <Brandon> but theres a lot of places that dont give you receipts
19:12:51 <Brandon> like.. vendig machines
19:12:56 <Brandon> and those fucking girlscouts
19:13:29 <andrewsw> "are your girlscout cookies made with real girlscouts?" -- Wednesday Addams.
19:13:30 <Brandon> .... i'm on a budget.. but i just can't say no to boxes and boxes of overpriced cookies.. when a kid looks at me with puppy dog eyes like.. please.. i need to sell some fucking cookies
19:13:30 <jcreigh> if you don't want to track individual cash expenese, you can just make all ATM-withdrawals (or whatever) against some "Misc" expense account.
19:13:43 <Brandon> yeah.. i'll try to track them i guess
19:13:57 <Brandon> and whatevers left over i'll attribute to misc.
19:14:31 <andrewsw> if your patterns are predictable, a simple log kept for a week or so should be enough for you to estimate.
19:15:28 <andrewsw> later taters
19:15:29 *** andrewsw is now known as andrewsw-afk
19:17:21 *** Brandon_ has joined #gnucash
19:17:22 *** Brandon has quit IRC
19:17:23 *** Brandon_ is now known as Brandon
19:18:10 *** RassBariaw has joined #gnucash
19:18:16 <RassBariaw> help
19:19:49 *** cortana has quit IRC
19:19:54 <Brandon> whats up
19:20:14 <RassBariaw> can I use gnucash with an American bank?
19:20:46 <RassBariaw> my bank says they support quicken, quickbooks, or Money
19:22:09 <RassBariaw> well?
19:24:06 <Brandon> don't know
19:25:09 <Brandon> you could try it
19:25:18 <RassBariaw> or, what is a good time of the day (or good day of the week) to ask questions?
19:25:25 <Brandon> i think that if it supports quicken that gnucash will work with it.. but you'll have to try to find out for sure
19:25:44 <RassBariaw> if what supports quicken?
19:26:00 <andrewsw-afk> RassBariaw: what do you mean "use gnucash with an american bank"?
19:26:01 *** andrewsw-afk is now known as andrewsw
19:26:15 <RassBariaw> gnucash's built in connectivity appear to be geared to German banks
19:26:26 <RassBariaw> I wanted to download account information from my bank
19:26:32 <RassBariaw> and I noticed a template
19:26:46 <andrewsw> ah ha! you mean the direct connection to the bank? the name escapes me at the moment... aqbanking?
19:26:59 <RassBariaw> yes
19:27:02 <RassBariaw> I just looked it up
19:27:04 <RassBariaw> agbanking
19:27:29 <RassBariaw> I went to Tools, online banking set up,...and followed it from there
19:27:38 <andrewsw> some folks definitely use it, but it seems to be a hit or miss thing. Often times you have to use quicken to get the connection details..
19:27:49 <RassBariaw> :-(
19:27:55 <RassBariaw> but I don't have quicken
19:28:03 <andrewsw> your best bet is to try the gnucash-user mailing list to see if anyone else uses your same bank.
19:28:16 *** cortana has joined #gnucash
19:28:17 <andrewsw> or check with the aqbanking people to see if you can get info about what banks they support.
19:28:37 <andrewsw> in theory, if aqbanking supports it, gnucash does.
19:28:41 *** samana has joined #gnucash
19:28:50 <andrewsw> but aqbanking is developed outside of, separate from, gnucash.
19:28:59 <andrewsw> now I really gotta run, good luck
19:29:00 *** andrewsw is now known as andrewsw-afk
19:29:05 <RassBariaw> ok....
19:29:08 <RassBariaw> thanks for that
19:29:18 <RassBariaw> but agbanking appears geared towards German banks
19:31:01 *** samana has left #gnucash
19:31:33 *** RassBariaw has left #gnucash
19:43:16 *** |gunni| has quit IRC
19:49:31 *** badquanta has joined #gnucash
19:51:58 <Brandon> is there a way to change the default colors for the register
19:52:48 *** badquanta has quit IRC
20:04:20 *** sjc has quit IRC
20:17:01 <Brandon> i'm going to ask a dumb question
20:17:27 <Brandon> .... what is there to go gain by letting GnuCash access your account online?
21:04:19 <Brandon> anyone around?
21:05:26 *** warlord-afk is now known as warlord
21:05:35 <warlord> andrewsw-afk: FYI: You can point people to the OFX wiki pages
21:05:56 <warlord> Brandon: downloading your transaction history directory from the bank so you don't nececcasarily need to type it in.
21:06:45 <Brandon> but doen't that go against the idea of reconciliation
21:07:29 <warlord> Kinda, yeah, but some people still want it.
21:07:45 <warlord> Another thing it will do is let you "clear" existing transactions once gnucash notices that the bank has them.
21:10:09 <Brandon> i see
21:10:12 <Brandon> thats what i thought
21:10:37 <warlord> But hey, some people want it.
21:10:50 <Brandon> doesn't appeal to me at all... i'd like to double-check the bank
21:11:22 <Brandon> but that's cool.. just wanted to know if there was some other benefit i wasn't aware of
21:15:11 *** dbreiser has joined #gnucash
21:15:57 *** twunder has joined #gnucash
21:21:02 <dbreiser> I use OFX downloads to clear already entered transactions (checking) and to make sure I've recorded all the credit transactions.
21:21:26 <dbreiser> easier to do it in a few minutes a couple times a month than all at once from paper
21:27:38 *** Brandon_ has joined #gnucash
21:27:39 *** Brandon has quit IRC
21:27:40 *** Brandon_ is now known as Brandon
21:29:10 *** vinci_ has joined #gnucash
21:37:35 *** vinci has quit IRC
21:40:50 <Brandon> OFX?
21:43:14 <warlord> Open Financial eXchange
21:44:03 <dbreiser> the generic of Intuit's qfx
21:50:15 <Brandon> oh ok
22:05:08 *** cortana has quit IRC
22:08:19 <Brandon> where do i put in the interest rate i have on a loan?
22:09:31 <dbreiser> Expenses:interest:loan interest (or similar)
22:09:42 <dbreiser> oops you said rate
22:12:27 <dbreiser> you can 'store' it as part of an SX formula, but you can't do a fully automatic calc yet
22:13:11 <Brandon> oh i see
22:13:33 <Brandon> so it wont figure out monthly what my next interest payment will be?
22:13:47 <warlord> The M&L Druid will set up SXes to compute PPMT/IPMT, but it wont deal with pre-payments at all.
22:14:45 <Brandon> k thanks
22:14:56 * Brandon off to figure out what a druid is
22:15:06 * Brandon is off to figure out what a druid is
22:37:21 *** Brandon has quit IRC
22:43:50 *** nbinon1 has joined #gnucash
22:53:56 *** twunder has quit IRC
22:56:56 *** twunder has joined #gnucash
23:27:15 *** warlord is now known as warlord-afk
23:37:10 *** dbreiser has quit IRC