2010-02-01 GnuCash IRC logs
01:30:34 *** XiXaQ has quit IRC
01:43:31 *** warlord has joined #gnucash
01:43:32 *** gncbot sets mode: +o warlord
02:01:38 *** trucklover has joined #gnucash
02:08:12 *** jean has joined #gnucash
02:19:58 *** XiXaQ has joined #gnucash
02:24:57 <kimmo> bonez, maybe grab a accounting 101 book somewhere?
02:42:47 *** bentob0x has joined #gnucash
03:09:05 *** jpetersen has joined #gnucash
03:13:16 *** jean has quit IRC
04:05:27 *** trucklover has quit IRC
04:08:07 *** andi5 has joined #gnucash
04:27:08 *** fDavid has joined #gnucash
05:19:48 *** talso has quit IRC
05:25:16 *** daedeloth has joined #gnucash
05:26:48 *** talso has joined #gnucash
06:03:44 *** bentob0x has quit IRC
07:56:58 *** bentob0x has joined #gnucash
08:16:50 *** sint has joined #gnucash
08:21:22 *** Jimraehl has left #gnucash
08:22:38 *** sint has quit IRC
08:31:08 *** Jimraehl has joined #gnucash
08:32:58 *** sint has joined #gnucash
08:33:31 <sint> hey, is it possible to run gnucash in german even if the system itself is set to english?
08:46:10 *** ErKa has joined #gnucash
08:46:39 <sint> ok, i got it to work. had to change the locale for gnucash
08:52:17 *** sint has quit IRC
09:04:53 *** ajg has joined #gnucash
09:05:24 <ajg> Is there a way to create a reports using cash basis accounting?
09:23:31 <warlord> ajg: You'd have to get the report to substract out the outstanding A/R and A/P..
09:24:28 <warlord> Actually, you'd have to do much more than that; you'd have to look at the payment transaction dates and use THAT to apply to the original..
09:25:51 <ajg> so there's nothing in that by default do handle that?
09:32:19 <warlord> No, none of the current reports do.
09:32:50 <warlord> There's a long standing bug about it, but....
10:03:48 *** mib_gabu86 has joined #gnucash
10:36:22 <ajg> warlord, not an easy change, huh?
10:37:12 <warlord> Nope. By defition Invoices imply accrual.
10:37:26 <warlord> Converting to Cash requires working off the payments..
10:38:11 <warlord> It's usually easier to just do it manually. At the end of a period you manually subtract out the outstanding A/R and A/P, and record those numbers later.
10:38:25 <warlord> .. because the NEXT period you'll have to add that back in.
10:41:06 <ajg> assuming your customers pay you on time ;)
10:41:23 <warlord> Well, that's the thing, with cash accounting it doesn't really matter.
10:41:23 *** ErKa has quit IRC
10:41:39 <warlord> Personally, what I do is just make sure I dont bill anyone near the end of the year. ;)
10:42:04 <ajg> right, well it does when they send you a check 2 months after you performed work, but its dated for the date on which you invoiced them!
10:42:17 *** bonez2046 has quit IRC
10:43:00 <ajg> for instance, i got a 1099 including payment for an invoice i sent on 12/31/09... i still havent gotten the check for htat payment
10:44:19 <warlord> Ummmmmmmmmmmmmm
10:48:35 *** KaiForce has joined #gnucash
11:06:14 <mib_gabu86> I think this is a "beginner's error" on my part, but I just couldn't find the solution to the following problem: in the Expense barchart report, how can I display the barchart for a specific category such as "Expense:Groceries"? In the account options I clear all accounts and then select only that category but the result always always includes all Expenses
11:09:02 <warlord> mib_gabu86: it works fine for me.
11:09:37 <warlord> I ran the report, opened the report options, selected the account tab, hit "clear all", then selected one account from the list and clicked 'apply'.
11:09:42 <warlord> Only that one account is showing up.
11:13:33 <warlord> What account(s) specifically do you choose?
11:19:55 *** ErKa has joined #gnucash
11:32:22 *** kimmo has quit IRC
11:35:04 *** daedeloth has quit IRC
11:35:18 *** kimmo has joined #gnucash
11:38:30 *** warlord has quit IRC
11:44:58 *** jpetersen has quit IRC
11:59:10 *** cfp has joined #gnucash
12:06:31 <cfp> hi. quick query, both the gnucash and the qof docs refer to xaccInitQuery, but it only seems to be mentioned in comments, it never seems to be defined. am i being stupid?
12:06:45 *** warlord has joined #gnucash
12:06:45 *** gncbot sets mode: +o warlord
12:11:44 <ajg> warlord, what was your "Ummmmmmmmm" reply about?
12:12:15 <warlord> ajg: that seems... illegal.. for them to report income they haven't sent you.
12:12:40 <ajg> yea, thats what i've been thinking
12:13:37 *** fbond has quit IRC
12:13:47 <cfp> warlord: you don't happen to know the answer to this question i asked just before you entered do you: both the gnucash and the qof docs refer to xaccInitQuery, but it only seems to be mentioned in comments, it never seems to be defined. has it been replaced by something? do i have to use qof_query_add_term instead?
12:14:23 <ajg> if they're using accrual basis, the recieved the invoice on 12/31, that makes sense, no?
12:14:31 *** fbond has joined #gnucash
12:16:01 <warlord> cfp: xacc*Query routines were all deprecated.
12:16:14 <warlord> Where do the QOF Docs refer to that API? (URL, please?)
12:16:42 <warlord> ajg: it could... Which is why I never send an invoice dated 12/31. I send it dated 1/1 :)
12:16:45 <cfp> ahha. i'm new to the codebase. http://qof.alioth.debian.org/doxy/group__Query.html and http://svn.gnucash.org/docs/HEAD/group__Query.html
12:17:03 <cfp> under "Detailed Description"
12:17:17 <warlord> The former URL is irrelevant. We don't adhere to the official QOF
12:17:58 <warlord> That looks like an outdated comment..
12:18:18 <warlord> I dont even know what xaccInitQuery() did. I dont even recall that API!
12:18:43 <warlord> You should just use qof_query_add_term
12:19:14 <cfp> ahh fair enough. it made it sound rather simpler than it is now. but qof_query_add_term seems just about comprehensible. thanks
12:20:31 <ajg> warlord, i'm told that they'll backdate the check to 12/31 if i send an invoice for 1/1...
12:21:16 <ajg> because it was for work performed in 12... which makes absolutely no sense to me
12:21:25 <ajg> accrual or not, it seems wrong
12:25:02 <warlord> it definitely seems wrong.
12:25:19 <warlord> Especially if you're on a CASH basis.
12:27:21 <mib_gabu86> Hi warlord. Sorry for the delay in responding.... I am selecting Expenses:Groceries (there are no subaccounts under it). I did what you suggested: clear all, selected Groceries and clicked apply. It regenerates the report, but in the end all accounts are included and the selection in the options window expands to include all accounts.
12:27:52 <warlord> I dont know what to tell you. It works fine for me in 2.3.8+
12:28:16 <mib_gabu86> BTW, I am using Windows version of Gnucash
12:28:54 <mib_gabu86> version 2.3.8
12:29:31 <warlord> Oh, windows.. Then anything is possible.
12:29:46 <mib_gabu86> ok. I need to get back to work. If you have any suggestions I would appreciate that. Perhaps I should inquire on users mailing list.
12:30:02 <warlord> Install Linux?
12:30:06 <warlord> Yes, you should ;)
12:34:12 <ajg> warlord, should i even be using gnucash if i'm cash based?
12:39:31 <warlord> Of course you should!
12:39:34 <warlord> (I do!)
12:40:08 <ajg> so if i need an accurate report, how would i generate one?
12:40:27 <warlord> Define "accurate report"?
12:41:05 <ajg> well, one where the cash basis is accounted for... the tax report i generated is wrong because of invoices that fall on previous years, but i havent recieved payment until a month later, for instance
12:41:51 *** Zoolooc_ has joined #gnucash
12:41:54 <warlord> You need to manually convert from accrual to cash.
12:42:08 <ajg> so how do you do it, for instance?
12:42:34 <ajg> to me if i have to enter my amounts into a spread sheet, then what's the point of Gnucash?
12:42:39 <warlord> I send the Income Statement, Balance Sheet, and full transaction report to my accountant.
12:43:39 <ajg> but if you're cash basis, those amounts are wrong
12:44:59 <ajg> *could be* wrong
12:45:11 <warlord> What part of "you need to manually convert from accrual to cash" are you failing to understand?
12:45:34 <warlord> The balance sheet will show an outstanding receivable, which gets manually removed from income.
12:47:54 <ajg> i see that now
12:48:05 <ajg> sorry that i misunderstood
12:48:20 <ajg> with those three reports, there is everything you need to konw
12:52:54 <warlord> Yep
12:53:50 <ajg> but the transaction report is off... it reflects what the 1099 does... but i havent recieved that income yet... so what report shows when i cashed the check?
12:58:57 <warlord> None, because you didn't cash it in the period. But the balance sheet shows that.
13:00:38 <cfp> hey one more query sorry warlord, do you know if QOF_STRING_MATCH_NORMAL matches substrings or the entire string?
13:07:16 *** buddhajuke has joined #gnucash
13:07:52 <buddhajuke> Do you still need X11 to install Gnucash on osx or is that not necessary anymore?
13:08:02 <warlord> should match substrings
13:08:16 <warlord> buddhajuke: the DMG does not require X11
13:08:16 <cfp> thanks
13:08:30 <buddhajuke> thanks warlord
13:10:02 *** warlord is now known as warlord-slow
13:13:14 *** buddhajuke has quit IRC
13:22:22 *** fDavid has quit IRC
13:24:33 *** andi5 has quit IRC
13:27:47 <cfp> am i understanding gncQueryBuildParamList right in thinking that: gncQueryBuildParamList( CUSTOMER_ADDR, ADDRESS_EMAIL, NULL ) will match email addresses?
13:31:48 *** andyt has joined #gnucash
13:36:08 *** bradgers has joined #gnucash
13:38:22 <warlord-slow> Yes
13:38:26 <warlord-slow> cfp: it should.
13:38:43 <cfp> thanks.
13:53:02 <bradgers> I've patched fancy-invoice to allow the printing of the job name on the invoice; would you be interested in a diff?
13:53:49 <warlord-slow> bradgers: sure, file a bug report and attach the diff
14:35:53 *** Zoolooc_ has quit IRC
14:36:03 *** Zoolooc has joined #gnucash
15:31:06 *** bradgers has quit IRC
15:34:04 *** bradgers has joined #gnucash
15:35:13 *** cortana has joined #gnucash
15:55:01 *** jpetersen has joined #gnucash
16:11:00 *** jean has joined #gnucash
16:28:28 *** andi5 has joined #gnucash
16:28:28 *** gncbot sets mode: +o andi5
16:30:54 *** blizgerg- has quit IRC
16:33:36 *** jean has quit IRC
16:33:46 *** jean has joined #gnucash
16:36:44 *** jack_ has joined #gnucash
16:37:02 <jack_> somebody here experience with aqbanking and abn-nl? :D
16:37:17 <andi5> abn-nl?
16:37:26 <jack_> abn amro
16:37:50 <andi5> that is ... a bank?
16:37:59 <jack_> yes....
16:38:40 <andi5> no clue :) ... you might want to ask here, but the aqbanking mailing list (wait, maybe they just split, need to look up) will know better
16:38:58 <jack_> well i'm not sure about it heh
16:39:04 <jack_> the 2.2.9 release shows it has support
16:39:11 <jack_> but i'm not sure how to configure it
16:39:20 <andi5> ((http://lists.aqbanking.de/cgi-bin/mailman/listinfo/aqbanking-user :)))
16:39:31 <andi5> have you seen the aqbanking setup druid?
16:40:11 <jack_> i tried running the setup
16:40:20 <jack_> but then it asks for some details i'm not aware of :P
16:40:24 <jack_> *crinch* zeh germanz
16:40:45 <andi5> do you want me to translate something?
16:40:57 <jack_> ah i can read german
16:41:06 <jack_> i'm just not much of a fan of it heh
16:41:17 <andi5> does not matter, i suppose :)
16:41:29 <andi5> what is it the druid asks you?
16:42:05 <jack_> create a new pin/tan user
16:42:11 <jack_> and then it asks for a bank code/server
16:42:21 <jack_> and some further details i'm not sure where to find those
16:42:39 <andi5> are you sure you need to fill out those extra details?
16:42:54 <andi5> i suppose you need the bank code (bankleitzahl, i suppose) and the server url
16:43:20 <jack_> server url i think i can find but i dont know where to find the bank code :/
16:44:28 <andi5> ahem... what is it you tell others to send you money to? account number and bank code, unless is to a different state
16:45:16 <jack_> hmm that would make sense actually
16:45:20 <jack_> bank account
16:45:37 <jack_> bank code.. i thought they were looking for a code specific for the bank
16:45:38 <jack_> meh
16:45:48 <andi5> it is specific for the bank, actually
16:46:01 <andi5> the account number then specifies your own account at your bank
16:46:38 <andi5> is not there a dutch translation avaiable?
16:46:48 *** jpetersen has quit IRC
16:48:08 <jack_> nope thats why i figured lets check gnucash ><
16:48:21 <andi5> (o.o)
16:50:58 <jack_> how easy things get complicated :D
16:52:19 <jack_> ive to say i like gnucash
16:52:25 <jack_> yet certain things go sligthly complicated
16:52:31 *** KaiForce has quit IRC
16:52:57 <andi5> certain things are complicated :)
16:53:17 <jack_> i'm more in favour of poking some buttons and shizam
16:53:18 <jack_> it works
16:54:41 <jack_> you otherwise might have a clue how to handle payments from others?
16:54:51 <jack_> i get regulary payments from others but i need to keep track if they actually pay
16:55:28 <andi5> i am really bad at the business features, but are you invoicing them?
16:55:50 *** ^linus has joined #gnucash
16:55:55 <jack_> nope
16:56:27 <jack_> but i got a group of clients who are supposed to pay by themself
16:56:32 <jack_> if they dont i move to automatic invoices
16:56:47 <jack_> but sofar that never happened actually they are neat payers
16:56:53 <jack_> but i just want to be sure it stays that way :P
16:57:08 <andi5> ok, even if there is no formal invoice, you would still love if they paid, right? :)
16:57:33 *** ^linus has quit IRC
16:57:34 <jack_> yeh hehe
16:57:42 <andi5> try the business, menus, we are talking about customers and invoices, i think
16:57:59 <jack_> hmmk
17:07:17 <jack_> seems like that's indeed an option
17:07:25 <jack_> shame that a bit more automatic way isnt possible
17:07:30 <jack_> or atleast i dont know howto yet >D
17:08:43 *** jean has quit IRC
17:15:27 *** felichas has joined #gnucash
17:18:43 <cfp> is there any reason why a plugin wouldn't get loaded. i have the requisite (gnc:module-load ... line in config.user, and it was being loaded before, but after a few changes to its source file it no longer seems prepared to
17:19:50 <andi5> maybe it is not a valid module anymore?
17:20:21 <andi5> i used to debug gnc-module.c and its traversal code, but there are probably easier ways :)
17:21:14 <cfp> well i'm pretty sure i've only changed code that gets activated on click, so it seems strange that it should no longer be valid.
17:22:18 <andi5> is anything printed to the terminal?
17:23:46 <cfp> nope. and i added some printfs to the init function which aren't getting hit either.
17:25:47 <cfp> could it be another library dependency that's screwing it up? i would have expected the linker to complain if that was the issue
17:27:01 <andi5> i thought you did not change anything of relevance :P ... if it is a dynamically loaded module, maybe the linker does not see the problem... well, my c foo is getter worse and worse
17:36:12 *** ErKa has quit IRC
17:36:33 *** ErKa has joined #gnucash
17:41:33 <felichas> Hi, when I opened my gnucash file the other day, even though no error messages showed, some accounts had lost all the reccords. Basically Income accounts, but not every income account.
17:41:33 <felichas> The file is 1 year old.
17:41:33 <felichas> Is there a way to recover from this data lost? my closest backup is more than 2 months old :-(
17:42:07 <andi5> are you filtering your view?
17:43:58 <felichas> I don't think so. If I am I'm not aware. View -> filter by -> has every box checked
17:45:36 <felichas> are the .log and .xac file of any help?
17:45:43 <andi5> xac files are log files
17:45:46 <andi5> sorry, backup files
17:46:36 <bradgers> felichas: which accounts lost records?
17:46:51 <bradgers> and which version are you using? Something similar happened to me...
17:47:06 <andi5> someone stealing all the records?
17:49:01 <felichas> I haven't fully audited it, but I have sure lost every record in income-Nomina and income-Clases
17:49:16 <bradgers> no, there was a data corruption issue w/ the sql backend
17:49:42 <felichas> I'm running v2.2.6
17:50:07 <felichas> ubuntu 9.04
17:50:15 <bradgers> ah -- then I can't help you -- too much, anyway
17:50:28 <bradgers> sql didn't happen til 2.3
17:50:53 <andi5> puh, 2.2.6 is pretty old already :D
17:51:39 <felichas> I also load my data in a version (about 1year old) distributed by portableapps.com
17:52:12 <felichas> and edit it also with this windows version
17:52:24 <andi5> so three different programs?
17:52:48 <felichas> 2 actually, but I use linux 90% of the time
17:52:57 <felichas> v2.2.6
17:53:06 <andi5> ok... do those xac files help you recover part of your data?
17:53:28 <andi5> (need to fix this one bug and then get some sleep)
17:53:35 <felichas> how do you use them? simple as file -> open -> any recent xac file
17:53:48 <felichas> ?
17:53:54 <bradgers> yep
17:54:24 <andi5> you may do so to test whether the file contains your data... if they do, rename it, because otherwise your data file name is getting longer and longer (if you keep working from backups of backups of...)
17:55:04 <felichas> they do! thanks god
17:55:15 <felichas> well.... thanks you guys
17:55:45 <andi5> felichas: hey, maybe you have some time and are able to reproduce this bug somehow..., with a recent version and a bug report :)
17:57:49 <felichas> I wish I would know how to reproduce it, but one night I opened the accounting file as any other night, but this time some accounts had no data
18:00:13 <felichas> latest gnucash in ubuntu's repos is v2.2.9 http://packages.ubuntu.com/search?keywords=gnucash&searchon=names&suite=all§ion=all Is it really that old?
18:01:09 <andi5> iirc 2.2.6 is not that bad... 2008-07-31 btw
18:04:20 <felichas> thanks, and sorry for my previous silly question about .xac and .log Chapter 2.8 of the manual explains it very well. I'll RTFM now.
18:11:01 <felichas> I'm thinking now that it may have been a problem of free disk space, as I keep my accounting file in a USB stick, and it was almost out of disk that day
18:11:20 <andi5> i am just working on it ;-)
18:11:26 <andi5> https://bugzilla.gnome.org/show_bug.cgi?id=105669
18:11:40 <felichas> would this make sense? I don't remember any error message though
18:11:48 <andi5> do you compress your filesß
18:12:28 <andi5> i am not exactly sure... i would expect the file to be empty or at least non-valid xml...
18:12:55 *** Zoolooc has quit IRC
18:13:19 <felichas> LOL. I don't do anything special but pray not to loose the stick
18:13:35 <andi5> noted.
18:13:56 <felichas> it was a 1GB FAT stick, no encryption, no compression, very standar
18:14:19 <felichas> If I can help you anyhow, just let me know.
18:14:26 <andi5> in gnucash, you can choose whether you want to compress your data file or not... it is in the general tab of the preferences
18:14:42 *** jack_ has quit IRC
18:14:55 <andi5> yeah, subscribe to the bug and answer all questions :)
18:15:10 <andi5> but i think i am making progress, finally
18:15:50 <felichas> nice to know :-)
18:16:01 <felichas> I have compress files checked
18:42:21 *** mib_gabu86 has left #gnucash
18:50:20 *** andyt has quit IRC
18:57:06 *** KaiForce has joined #gnucash
18:59:41 <bradgers> OK, this is weird.
19:00:15 <bradgers> I have an invoice that, when I try to process a payment for it, defaults to $238, even though the invoice is only for $70
19:11:13 *** andi5 has quit IRC
19:30:07 <warlord-slow> bradgers: that is weird. Maybe you have other outstanding invoices for the customer?
19:37:40 *** felichas has left #gnucash
19:45:12 <bradgers> nope
19:46:04 <warlord-slow> Did you make a payment and then change the amount?
19:48:18 *** ajg has quit IRC
19:54:53 *** KaiForce has quit IRC
19:57:49 *** bradgers has quit IRC
19:58:32 *** bradgers has joined #gnucash
20:01:22 *** cortana has quit IRC
20:01:48 <cfp> thanks a lot for your help earlier warlord and andi5. i now have a working plugin to import customers from a csv file. one plugin down, 4 to go... (but i know what i'm doing now...)
20:24:25 *** cfp has quit IRC
20:26:49 *** fDavid has joined #gnucash
20:27:04 *** jpetersen has joined #gnucash
20:28:44 *** jpetersen has quit IRC
20:47:46 <bradgers> warlord: on an earlier transaction, yes.
20:47:46 *** bradgers has quit IRC
20:48:20 *** bradgers has joined #gnucash
20:48:51 <bradgers> really weird; somehow payment transactions were adding to the total to be paid, rather than subtracting
21:02:33 *** bentob0x has quit IRC
21:09:45 *** ErKa has quit IRC
21:10:14 *** fDavid has quit IRC
21:13:21 <warlord-slow> bradgers: if you made a payment and then changed the amount then you just screwed up the accounting. Don't do that.
21:13:29 <warlord-slow> (sorry, gotta yell and run)
21:13:33 *** warlord-slow has quit IRC
21:14:47 *** bradgers has quit IRC
21:15:51 *** bradgers has joined #gnucash
21:40:24 *** mib_v137h0gxejdo has joined #gnucash
22:21:37 *** bradgers_ has joined #gnucash
22:24:43 *** bradgers has quit IRC
22:33:31 *** blizgerg has joined #gnucash
22:40:21 <blizgerg> hmmm
22:45:12 <blizgerg> I dont' think I filled out this mortgage/loan druid correctly :(
22:46:57 <blizgerg> it's taking something like nearly the entire amount of the loan as the payment and doign something wierd...
22:47:16 <blizgerg> I shoudl probably read teh help file...
23:12:52 *** warlord has joined #gnucash
23:12:53 *** gncbot sets mode: +o warlord
23:34:20 *** ErKa has joined #gnucash