2009-03-17 GnuCash IRC logs
01:03:22 *** tiamot has joined #gnucash
01:05:47 <tiamot> Hello everyone. Is anyone using gnucash as an alternative for quickbooks. I understand it is a great replacement for quicken, but can it do invoiceing and track customers, etc. llike quickbooks?
01:21:51 *** tiamot has left #gnucash
01:44:35 *** puck has quit IRC
01:45:24 *** puck has joined #gnucash
02:32:12 *** goodger_ has quit IRC
02:33:05 *** goodger has joined #gnucash
04:16:01 *** ErKa has joined #gnucash
04:32:10 *** MechtiIde has joined #gnucash
04:51:04 *** MechtiIde has joined #gnucash
07:22:03 *** twunder has joined #gnucash
07:31:58 *** Jimraehl has left #gnucash
07:41:33 *** twunder has quit IRC
07:47:42 *** bacule has left #gnucash
07:49:40 *** Rolf1 has joined #gnucash
07:51:48 *** JimRaehl2 has joined #gnucash
07:56:10 *** JimRaehl2 has left #gnucash
07:56:41 *** JimRaehl2 has joined #gnucash
09:32:12 *** donfede has quit IRC
09:39:10 *** djMax has quit IRC
10:02:48 *** jwshen has joined #gnucash
10:17:27 *** SebastianHeld has joined #gnucash
10:27:35 *** donfede has joined #gnucash
10:49:11 *** warlord-afk is now known as warlord
11:27:23 *** jypehama has joined #gnucash
11:29:32 <jypehama> howzit, hope someone is around. I am trying to figure out this whole making an invoice with gnucash thing with little success
11:34:26 <warlord> I'm here but I need to leave in about 2 minutes (I'll be back in about 30)
11:34:33 <warlord> What's the problem you're having?
11:34:49 <jypehama> I was confused by the whole system but I think I got most of it now
11:35:02 <jypehama> only thing that confuses me is: What is billing id supposed to be?
11:36:38 <warlord> the Billing ID is your Customer's reference to the invoice. E.g. if they gave you a PO Number or something.
11:37:21 <jypehama> Thanks
11:37:30 <warlord> sorry, gotta run. I'll be back in 30 mins if you have more questions.
11:37:37 *** warlord has quit IRC
12:03:48 *** warlord has joined #gnucash
12:03:49 *** gncbot sets mode: +o warlord
12:04:29 <jypehama> Where are the stylesheets for the printable invoices stored? I at least need to translate one to Finnish
12:05:05 <warlord> there are no stored style sheets.
12:05:36 <warlord> Are you running with LANG=fi
12:05:37 <warlord> ?
12:05:55 <jypehama> apparently not. for some reason it does not respect ubuntus locale
12:07:11 <warlord> what does 'locale' say?
12:08:15 <jypehama> LANG=fi_FI.UTF-8
12:08:15 <jypehama> LC_CTYPE="fi_FI.UTF-8"
12:08:15 <jypehama> LC_NUMERIC="fi_FI.UTF-8"
12:08:15 <jypehama> LC_TIME="fi_FI.UTF-8"
12:08:15 <jypehama> LC_COLLATE="fi_FI.UTF-8"
12:08:17 <jypehama> LC_MONETARY="fi_FI.UTF-8"
12:08:20 <jypehama> LC_MESSAGES="fi_FI.UTF-8"
12:08:22 <jypehama> LC_PAPER="fi_FI.UTF-8"
12:08:24 <jypehama> LC_NAME="fi_FI.UTF-8"
12:08:27 <jypehama> LC_ADDRESS="fi_FI.UTF-8"
12:08:29 <jypehama> LC_TELEPHONE="fi_FI.UTF-8"
12:08:32 <jypehama> LC_MEASUREMENT="fi_FI.UTF-8"
12:08:34 <jypehama> LC_IDENTIFICATION="fi_FI.UTF-8"
12:08:37 <jypehama> LC_ALL=
12:08:39 <jypehama> as it should be
12:09:40 <warlord> Yeah, that should be sufficient. Is any of the gnucash UI in Finish?
12:10:26 <jypehama> none
12:11:14 <jypehama> english is otherwise fine but for printing invoices it is a bit clumsy
12:11:43 <warlord> So when you start up the UI you don't see a button "Tellenna"?
12:12:05 <jypehama> Ayup, its just Save
12:12:13 <warlord> Okay, that means the translation *is* working.
12:12:25 <warlord> I think the .fi translation is just old and.. not complete.
12:12:38 <warlord> It was last touched 2008-07-27
12:12:45 <warlord> You can talk to tuomo.kohvakka@iki.fi
12:12:50 <jypehama> Dunno. It worked on a Windows machine I tried gnucash on
12:13:05 <jypehama> but not on any of my ubuntu boxes
12:13:05 <warlord> It's the same translation.
12:13:28 <jypehama> well, in ubuntu it is in english all the way
12:13:41 <warlord> Oh! On ubuntu you might not have the fi locale installed.
12:13:41 *** chris has quit IRC
12:14:04 <jypehama> entirely possible. the ub untu package might simply not include it
12:16:06 <jypehama> Well, at least I get it to print something, should be fancy enough for billing the university
12:16:39 <warlord> I dont run ubuntu so I dont know offhand the command to add a locale.
12:17:29 <jypehama> the locale works fine in all other programs, but the gnucash package might lack it
12:19:27 *** chris has joined #gnucash
12:19:36 <warlord> You're running KDE, aren't you?
12:19:51 <jypehama> gnome
12:20:07 <jypehama> (and occasionally E17 :))
12:20:17 <warlord> And other GNOME apps are translated?
12:20:29 <jypehama> pretty much all of them
12:20:42 <warlord> Hmm..
12:21:07 <warlord> Well, I know that the .fi gnucash translation is old and incomplete, so it's possibly just that.
12:21:14 *** MechtiIde has quit IRC
12:21:26 <jypehama> might be
12:21:48 <jypehama> the windows version did have plenty of problems compared to the english one on my own laptop
12:22:47 <jypehama> Thanks for your time. I think I'll log off, see if there is something more to register and get some food.
12:23:21 <warlord> Okay, good luck.
12:23:29 *** jypehama has quit IRC
13:01:47 *** soa2ii has joined #gnucash
13:02:31 <soa2ii> Hi there. If I create a new file... how can I get the german account names? Gnucash itself is in german... just the different account sets stay english :S
13:02:57 <jsled> that's strange. If the UI is in de, then we should use the de account hierarchies.
13:04:05 <soa2ii> It seems that it doeanst...
13:04:12 <soa2ii> It#s on gentoo here
13:04:20 <soa2ii> Version 2.2.7
13:04:28 <jsled> 2.2.9's available, fwiw.
13:04:41 <jsled> I'm sure you know.
13:04:49 <jsled> Hopefully it'll get stabilized in a week or so.
13:04:58 <warlord> Try setting both LANG and LANGUAGE env vars?
13:05:40 <soa2ii> soa2ii@thor ~ $ env | grep LAN
13:05:41 <soa2ii> LANG=de_DE.utf8
13:05:41 <soa2ii> LANGUAGE=de_DE.utf8
13:05:45 <soa2ii> warlord: Like this? (:
13:06:09 <warlord> Um, yeah.
13:06:32 <soa2ii> Yeah (:
13:06:35 <jsled> huh. Doesn't seem to work here, either.
13:06:54 <soa2ii> jsled: Wich version? Gentoo too?
13:07:21 <jsled> gentoo. 2.2.9.
13:08:31 <soa2ii> jsled: Hmpf... what's going wrong there again...
13:08:38 <jsled> explicitly set LC_ALL, instead.
13:08:44 <jsled> then it'll pick them up, it seems.
13:08:53 <warlord> Works for me on Fedora-10
13:09:46 <soa2ii> jsled: LC_ALL="de_DE.utf8" ?
13:09:57 <jsled> yeah
13:10:10 <soa2ii> Let's see
13:11:11 <soa2ii> jsled: How do you update env.d again whiztout logging out?
13:11:23 <soa2ii> env-update && source /etc/profile ?=
13:11:30 <jsled> sounds right.
13:12:14 <soa2ii> Just works for root :S
13:12:14 <soa2ii> brb
13:12:18 *** soa2ii has quit IRC
13:14:11 *** soa2ii has joined #gnucash
13:14:19 <soa2ii> jsled: OK, this seems to work
13:26:01 *** warlord is now known as warlord-slow
13:29:40 *** zathras_laptop has joined #gnucash
13:31:03 <zathras_laptop> how do i get access to "business" features when loading a file?
13:31:18 <zathras_laptop> whoops, when using the api I mean
13:44:06 *** SebastianHeld has quit IRC
13:47:04 *** palatin has joined #gnucash
13:51:24 *** warlord-slow is now known as warlord
13:51:40 <warlord> zathras_laptop: what APIs do you want/need? You'll need to load the business-core module
13:52:11 <zathras_laptop> i thought i had loaded that one...you mean load as a backend or link against?
13:52:28 <zathras_laptop> i'm finding the module layout a little difficult to follow at times - sorry
13:53:13 <warlord> It's not a QOF backend. It's a GNC-Module.
13:54:04 *** andyt has joined #gnucash
13:55:19 <zathras_laptop> ok
13:55:42 <zathras_laptop> so i link against it or is there a different load routine i need to use?
13:58:01 <warlord> generally for GNC-modules you run "gnc_module_load()"
14:01:53 <zathras_laptop> :-) thanks...just found it
14:03:13 <warlord> Is there any reason you haven't based your code off gnucash-bin.c?
14:04:14 <jsled> Also, again, the tests are good simple examples of some of this stuff. They're usually the minimal steps necessary to get things initialized before the test can be run.
14:18:55 <zathras_laptop> warlord, hmm, good point - i should go look at that code ;-) thanks for the pointer
14:25:25 *** warlord is now known as warlord-slow
14:32:36 *** jcreigh has joined #gnucash
14:33:41 *** tbnorth has joined #gnucash
14:34:17 <tbnorth> hi all - is there a simple way to merge two account?
14:34:23 <tbnorth> *accounts*
14:36:11 <jsled> two datafiles? Or just two accounts?
14:36:19 <tbnorth> two account
14:36:25 <tbnorth> *accounts :-)
14:36:41 <jsled> If you make one account the child of another, then delete it, I beleieve it will ask you if you want to move the transactions into the parent.
14:36:51 <jsled> This is not "merging", per se.
14:37:01 <tbnorth> but sounds like what I want, thanks
14:53:32 *** ErKa has quit IRC
15:07:41 *** iamawake has quit IRC
15:12:39 *** MechtiIde has joined #gnucash
15:19:57 *** Phil_Ewert has joined #gnucash
15:24:05 <Phil_Ewert> hi together, I'm trying to set up a hbci connection (with pin/tan) in gnucash. Under "User" it asks for a "server". The "Deutsche Bank"-Support couldn't tell me what was meant by that and asked me to ask the "gnucash people". Can you guys help me ?
15:25:16 <Phil_Ewert> (its not in the help)
15:26:01 <Guy-> Phil_Ewert: someone will probably be able to help, but it may be a few hours until they read the question
15:26:11 <Guy-> so stick around
15:27:22 <Phil_Ewert> Ok, thanks. I'll try to stick, but its 8:30 pm, here already ;-)
15:28:28 <Guy-> I'm also in CET :) but in my experience, the channel becomes livelier at around 22:00
15:30:10 *** SebastianHeld has joined #gnucash
15:32:56 <Phil_Ewert> ok, I'll stick
15:49:45 *** warlord-slow is now known as warlord
15:49:58 <warlord> Phil_Ewert: If you haven't already I highly recommend you ask on the gnucash-de mailing list.
16:07:46 *** Zoolooc has joined #gnucash
16:12:03 *** jwshen has quit IRC
16:23:54 *** Zoolooc has quit IRC
16:24:07 *** Zoolooc has joined #gnucash
16:47:54 *** palatin has quit IRC
16:59:02 <Phil_Ewert> warlord : thx, found it in the mailing list archive
16:59:24 <warlord> you're welcome.
16:59:29 <Phil_Ewert> the Deutsche Bank should have known !
16:59:34 <warlord> Heh
16:59:53 <Phil_Ewert> ok, cu guys
17:11:23 *** MechtiIde has quit IRC
17:25:52 *** Zoolooc__ has joined #gnucash
17:25:53 *** Zoolooc has quit IRC
17:31:38 *** SebastianHeld has quit IRC
17:33:15 *** soa2ii has quit IRC
17:45:11 *** tbnorth has quit IRC
17:49:58 *** Zoolooc__ has quit IRC
17:50:01 *** Zoolooc_ has joined #gnucash
17:51:30 *** ErKa has joined #gnucash
18:18:23 *** sjc has joined #gnucash
18:38:27 *** ErKa has quit IRC
19:06:12 *** rockfreak has joined #gnucash
19:07:10 *** andyt has quit IRC
19:07:23 <rockfreak> I have gnucash 2.2.7 on cnet os 5.2. I am creating a new set of accounts. Ont he wizard I have selected business. I wish to enter an opening balance into the wizard screen but I cannot. Please advise
19:10:45 <rockfreak> Ignore that last comment was trying to put it into equity by mistake
19:15:03 *** Zoolooc_ has quit IRC
19:24:40 *** tbnorth has joined #gnucash
19:30:17 *** Rolf1 has quit IRC
19:31:13 <rockfreak> the date format in gnu cash I have %d %b %Y can I add in like 1st 2nd the st/nd bit?
19:35:31 *** Rolf1 has joined #gnucash
20:03:52 *** bacule has joined #gnucash
20:06:45 *** bacule has left #gnucash
20:11:29 *** rgsteele||work has joined #gnucash
20:11:41 <rgsteele||work> Evening folks.
20:13:40 <rgsteele||work> If I split up each paycheck into a variety of different pots (funds for mortgage, car payments, spare cash fund, et. al.), would those initially be liabilities, and only become expenses once I, for example, pay the mortgage?
20:14:34 *** sjc has quit IRC
20:17:00 *** jcreigh has quit IRC
20:19:17 *** lobsang has joined #gnucash
20:30:47 <rgsteele||work> I guess I'm trying to understand how to keep my bank account balance synced with my gnucash checking account asset. If I transfer it from the checking account to various expense "pots", my checking account balance decreases, meaning I can't sync it with my online bank account.
20:31:21 <warlord> rockfreak: nope, there's no format character for that.
20:31:54 <warlord> rgsteele||work: you dont move it to expense pots until you pay those expenses
20:32:27 <rgsteele||work> Well, that's what I've done, but then my checking account balance in gnucash sinks to $0
20:32:44 <rockfreak> ok that you warlord :-)
20:33:12 *** lobsang has left #gnucash
20:33:27 <rgsteele||work> warlord: And then I can't sync it with my online bank account because my online bank account still says I have $XXXXX dollars, but gnucash thinks my checking account balance is $0 because I've transferred it all to expense accounts in preparation for bill payment.
20:33:32 <warlord> rgsteele||work: right, because what you did was wrong.
20:33:48 <rgsteele||work> warlord: Yeah, I've gathered, but I'm not quite sure where I zigged instead of zagging.
20:34:03 <warlord> first, you paycheck should just go to checking. (and your expense accounts for payroll taxes, etc).
20:34:24 <warlord> Then, when you pay your bills, you transfer from assets:checking -> expenses:xxx
20:35:29 <rgsteele||work> But, how can I look at gnucash and know exactly what all that money in the checking account corresponds to?
20:35:43 <warlord> what do you mean?
20:35:50 <warlord> Are you talking about what you've budgeted it for?
20:35:56 <rgsteele||work> Yeah.
20:36:09 <warlord> Ahh... Move it into subaccounts of your checking account.
20:36:29 <warlord> e.g., Assets:Checking:Rent; Assets:Checking:Gas; ...
20:36:32 <rgsteele||work> I want to be able to look at gnucash and see I have $XXX in my mortgage pot, $YYY in my spare cash fund, etc. Ah, okay.
20:36:40 <rgsteele||work> warlord: Thanks :)
20:36:54 <warlord> Then when you pay it you transfer from Assets:Checking:Rent -> Expenses:Rent
20:36:56 <warlord> etc.
20:37:10 <rgsteele||work> Groovy. Cheers.
20:37:20 <warlord> :)
20:38:32 *** lobsang has joined #gnucash
20:41:04 <gxti_> hmm, i should try that
20:41:25 <gxti_> currently i just set up a future txn for things i will need to pay and look at the future minimum balance, but that's obviously quite limited
20:43:56 <rockfreak> I've got my account file setup now. I have got £800 worth of computing equipment I want to add as equity as I started off with this when I started the business.
20:44:22 <rockfreak> do I put it into opening balances or??
20:45:18 <warlord> Sure, Eq:O-B -> Assets:Computers
20:49:27 <rockfreak> so for me that would ve Eq:O-B -> Assests:Fixed:Computers
20:50:41 <warlord> sure.
20:51:47 <rockfreak> silly question but would that go in increase or decrease?
20:52:12 *** mishehu has quit IRC
20:57:10 <warlord> Depends which account you have opened.
20:58:34 <rgsteele||work> warlord: Would those subaccounts be classified as an 'asset' or 'bank' account type? Technically, they're constituent parts of a bank account, but they're also technically not explicit bank accounts.
20:59:15 <warlord> rgsteele||work: doesn't really matter. The main difference between Bank and Asset are the labels in the register.
20:59:24 <warlord> (and you can change it later if you want)
21:00:08 <rockfreak> warlord: I had the Eq:O-B account and I put it as an increase.
21:00:42 <rgsteele||work> Yeah, ok, works for me. I guess since the funds are rather liquid, I'll just classify it as a 'bank' type.
21:01:53 <warlord> the important part is that it needs to "increase" your Assets. So it actually might be a "decrease" in Equity.
21:02:14 <warlord> Sorry, it's not.
21:02:18 <warlord> equity is labeled backwards.
21:03:17 <rockfreak> well my Assests now show 800 so it had the desired effect :-) thanks for your help again! :-)
21:03:24 <warlord> You're welcome.
21:23:28 *** jwshen has joined #gnucash
21:23:42 *** Rolf1 has quit IRC
21:29:33 *** mishehu has joined #gnucash
21:32:17 <rgsteele||work> Would a tax return be considered income?
21:35:21 *** Rolf1 has joined #gnucash
21:37:40 <warlord> depends on who it's fron.
21:37:42 <warlord> from
21:38:10 <rgsteele||work> The government.
21:38:26 <warlord> Yes... but WHICH govt.
21:38:28 <warlord> (whether it'
21:38:40 <warlord> it's taxable income depends on who it's from and what locale)
21:38:51 <rgsteele||work> The federal gov't
21:39:03 <warlord> e.g., in the US Fed tax return is not taxable, but state tax return is taxable to the feds.
21:42:03 <warlord> okay, time to head to dinner.
21:42:33 *** warlord has quit IRC
21:42:43 *** zathras_laptop has quit IRC
21:44:16 *** zathras_laptop has joined #gnucash
22:10:52 *** rgsteele||work has quit IRC
22:18:36 *** JimRaehl2 has left #gnucash
22:21:23 *** Jimraehl has joined #gnucash
22:23:02 *** jwshen has quit IRC
22:27:07 *** dbreiser has joined #gnucash
22:33:35 <dbreiser> I finally deep-sixed 1.8.12 from fink tonight.
22:33:57 <jsled> wow. 1.8. lol. good times.
22:34:08 <dbreiser> now for 6 months I'll get as many complaints about it not being there as I was getting about it being in the way.
22:34:21 <dbreiser> progress is slow
23:03:38 *** sandeen has joined #gnucash
23:03:59 <sandeen> hey, if I have an older gnucash file that doesn't seem to be parseable by gnucash2 ... :( any suggestions for debugging?
23:08:28 <dbreiser> send the error messages from the terminal window to the mailing list?
23:08:56 <dbreiser> I think there were a few common problems, but I can't remember any specifics
23:09:17 <sandeen> ok, thanks
23:10:00 <sandeen> I guess I'm late to the gnucash2 party :)
23:10:24 <sandeen> I didn't get any errors on the terminal, actually, but I'll see if I can make it more verbose
23:10:43 <dbreiser> hmm. what shows up in the registers?
23:11:20 <sandeen> I get nothing, just an error dialog about failed parsing
23:11:29 <sandeen> nothing in the main gnucash window, nothing in the terminal that launched it
23:11:33 <sandeen> as you probably can guess this is in fink :)
23:11:41 <dbreiser> what's the specific message in the dialog?
23:11:44 <sandeen> I might try it on my fedora box too just for fun
23:11:47 <sandeen> let me rerun it, sec
23:12:22 <sandeen> FWIW it first wants to fix up some encoding things, not sure if that's related
23:12:30 <dbreiser> could be.
23:12:47 <sandeen> "There was an error parsing the file <path to file> [ X Close ]
23:13:17 <dbreiser> encoding could be the cause of that.
23:15:23 <dbreiser> another place to look is gnucash.trace (usually in /tmp, but in OS X 10.5, it's elsewhere)
23:16:08 <dbreiser> in OS X 10.5, it'll be somewhere like /private/var/folders/mv/mvhhn92vG+m5tSMQ4ugNWk+++TI/-Tmp-/gnucash.trace
23:17:17 <dbreiser> the one user who reported a similar error was helped by a message in gnucash.trace about a wrong time stamp.
23:17:28 <dbreiser> https://lists.gnucash.org/pipermail/gnucash-user/2007-May/020517.html
23:18:29 <dbreiser> see also https://lists.gnucash.org/pipermail/gnucash-user/2007-May/020505.html
23:19:07 <dbreiser> encoding will be a problem if some of the file is ISO and some of it is UTF-8
23:26:44 *** solomon has joined #gnucash
23:27:01 <solomon> Is there any way to make the same changes to multiple transactions at once?
23:27:44 <solomon> I made a mistake in a massive import and I have a bunch of transactions with exactly the same wrong source account; and i also want to make exactly the same change in the description on all of them
23:28:43 <dbreiser> as long as you don't have any other transactions in that wrong account, I think gnucash will ask you where you want to move them when you try to delete the wrong account
23:28:54 <sandeen> dbreiser, great, thanks
23:29:11 <solomon> oh, i've got a ton
23:29:15 <sandeen> I dunno why it would be different encodings, but ... *shrug* maybe something snuck in from an ofx import
23:29:41 <dbreiser> you can edit the xml directly for something as straightforward as description. It isn't supported, but with backups it can be safe enough
23:30:04 <dbreiser> 1.8 wasn't as careful about encoding as 2.0, so it could have snuck in with an import
23:30:35 <solomon> i imported my savings, checking, and overdraft protection loan accounts for the last 5 years or so; it went pretty well except I accidentally told it that transfers between checking and overdraft protection were transfers between checking and checking
23:31:05 <dbreiser> that might be a manual fix
23:31:10 <dbreiser> one at a time
23:31:19 <solomon> dang
23:31:43 <solomon> well, i guess that's not too terribly bad... there are only a couple of dozen
23:31:49 <sandeen> dbreiser, yep that's what I figured I'd try, thanks
23:32:37 <solomon> there isn't any way to get the search results page to show as basic ledger, is there?
23:32:53 <solomon> that would make the task of fixing things just a bit quicker
23:33:03 <dbreiser> not sure, I always show double line
23:33:29 <dbreiser> you might be able to search and get them all in one results window consecutively
23:34:33 *** tbnorth has quit IRC
23:41:17 <dbreiser> I don't see a way to search for both accounts involved in a transaction
23:41:45 <dbreiser> If the description is unique enough, maybe you could search for that
23:57:17 *** dbreiser has quit IRC
23:57:24 <solomon> editing inside a search results page turns out to be a bit cumbersome because the page gets re-sorted as you change the information