2008-03-10 GnuCash IRC logs

00:11:04 *** twunder has quit IRC
01:22:52 *** Def has quit IRC
01:35:49 *** Def has joined #gnucash
02:00:47 *** wizkid238 has joined #gnucash
02:05:49 *** wizkid240 has joined #gnucash
02:09:06 *** wizkid239 has quit IRC
02:11:01 *** wizkid238 has quit IRC
02:16:24 *** wizkid238 has joined #gnucash
02:22:16 *** wizkid240 has quit IRC
02:40:01 *** wizkid239 has joined #gnucash
02:49:23 *** wizkid238 has quit IRC
03:05:38 *** puck has quit IRC
03:23:18 *** nbinon1 has left #gnucash
04:00:28 *** ErKa has joined #gnucash
05:25:53 *** andi5 has joined #gnucash
05:25:53 *** gncbot sets mode: +o andi5
05:59:27 *** basanta has joined #gnucash
06:08:12 *** cortilap has joined #gnucash
06:31:44 *** ErKa has quit IRC
06:35:38 *** joerlend_ has joined #GnuCash
06:35:38 *** XiXaQ has quit IRC
06:53:02 *** ErKa has joined #gnucash
07:01:46 *** wizkid238 has joined #gnucash
07:01:47 *** wizkid239 has quit IRC
07:27:55 *** XiXaQ has joined #GnuCash
07:28:43 *** wizkid239 has joined #gnucash
07:30:05 *** nomeata has joined #gnucash
07:35:16 *** wizkid238 has quit IRC
07:35:52 *** joerlend_ has quit IRC
07:48:37 *** nomeata has quit IRC
07:55:27 *** nomeata has joined #gnucash
08:17:50 *** _McLANE_ has joined #gnucash
08:27:54 *** twunder has joined #gnucash
08:30:10 *** joslwah has joined #gnucash
08:37:53 *** basanta has quit IRC
09:46:13 *** Slart has joined #gnucash
09:50:38 *** donfede has joined #gnucash
10:07:15 *** _McLANE_ has quit IRC
10:17:58 *** Slart has quit IRC
10:26:25 *** kielein has joined #gnucash
10:46:09 *** warlord-afk is now known as warlord
10:54:01 *** Slart has joined #gnucash
11:06:06 *** wizkid238 has joined #gnucash
11:13:17 *** wizkid239 has quit IRC
11:31:58 *** warlord is now known as warlord-afk
11:32:06 *** joerlend_ has joined #GnuCash
11:37:20 *** ErKa has quit IRC
11:40:13 *** XiXaQ has quit IRC
11:50:53 *** cortilap has quit IRC
11:55:58 *** cortilap has joined #gnucash
11:58:36 *** cortilap has quit IRC
12:02:58 *** cortilap has joined #gnucash
12:38:00 *** IanL has joined #gnucash
12:59:55 *** nomeata has quit IRC
13:07:00 *** cortilap has quit IRC
13:14:02 *** freakynl has joined #gnucash
13:15:06 <freakynl> q: my bank offers to download csv, i've got a tool that converts it to qif. can import the qif, but it books to the wrong accounts. is there any way i can specify what transaction should be booked against what account (the double booking, the bank account is obvious)
13:20:44 *** cortilap has joined #gnucash
13:24:40 *** warlord has joined #gnucash
13:24:40 *** gncbot sets mode: +o warlord
13:25:01 <warlord> freakynl: what version of gnucash? there's a bug in 2.2.4 processing memos
13:25:49 *** warlord-afk has quit IRC
13:39:21 *** xai has joined #gnucash
13:52:38 <foo> Hm, when I "process payment" on a bill and it goes from, say, accounts receivable to my checking account. In my checking account register, it just says the business name and that it came from accounts receivables, but it doesn't say what the invoice number was, hm.
13:53:01 <foo> that'd be nice /me goes back to all invoices to try to find out what payment this was
13:53:35 *** palatin has joined #gnucash
13:54:06 <warlord> foo: because you're not paying an invoice; you're paying the vendor.
13:54:18 <warlord> You can back-track to the invoice(s) paid via the A/P lots.
13:54:39 <foo> warlord: my bad, I used the wrong terminology. Not on a bill, on an invoice, I mean
13:54:56 *** IanL has left #gnucash
13:55:45 <foo> ah, I do see it in accounts receivable, though
13:55:45 <foo> thanks
13:56:29 <warlord> It's the exact same code, just replace A/P with A/R ;)
13:57:08 *** andi5 has left #gnucash
13:57:24 <foo> :)
13:57:25 <foo> yup
13:57:32 <foo> Thanks warlord
13:57:36 <warlord> you're welcome
14:01:17 *** ErKa has joined #gnucash
14:05:55 <foo> warlord: I stumbled across a transaction and I don't really know how it got in here and I can't really find any ties to it... I just replaced the invoice/deposit numbers to both be $0 and put what the value was in the description. If I have a transaction in here that serves no other purpose other than to show me what used to be here (in case I find something wrong later down the road) ... that's ok, right?
14:06:42 <freakynl> 2.2.4 :)
14:07:04 <freakynl> i'm also going quite nuts over the reconcile stuff. normally when i book stuff.. it's booked :)
14:07:11 <warlord> freakynl: right. You'll need to update the qif-to-gnc.scm
14:07:22 <warlord> foo: I dont understand.
14:07:43 <freakynl> it's gentoo tho'.. if it's a known bug it might be patched already
14:08:10 <freakynl> is there some easy way to reconcile?
14:08:15 <foo> warlord: Hm, let me try again. I have a transaction in the system that's throwing everything off and I don't know how/why it's there (I have no record of it)... I'm thinking it must have been a mistake when I entered it. So, I'm just changing the values to 0 so it doesn't do anything... that should be ok, right?
14:08:31 <freakynl> also, if i have a transaction that withdrawls bank and increases expenses, why reconcile both?
14:09:15 <warlord> freakynl: what do you mean, "easy way to reconcile"? Click on the "reconcile" button.
14:09:41 <warlord> freakynl: you dont usually reconcile income/expense accounts; only asset/liability
14:10:01 <warlord> foo: well, what's the transaction say?
14:11:24 <foo> warlord: I don't think it matters, it's money coming from accounts receivable to my checking account... but I just set both values to 0 in both registers. I think I was still learning the ropes of gnucash when I entered those
14:12:12 <warlord> hmm.
14:14:15 <freakynl> warlord: don't need to reconcile expenses/income/equity?
14:14:35 <warlord> Nope.
14:15:49 <freakynl> hmm that saves some time :) don't quite get that anyways (that it's possible) as you already reconcile 1 side of the transaction on assets/liability (in my case anyways), don't quite get why that doesn't reconcile the other side immediately
14:16:31 *** cortilap has quit IRC
14:16:39 <warlord> freakynl: think "split transaction"
14:16:56 <warlord> Or.. think "asset -> asset" or "asset -> liability". They might clear at different times.
14:18:00 <freakynl> ah k thx
14:19:23 <warlord> you're welcome
14:28:50 <freakynl> one more q, here, in the netherlands, we get tax back for certain things, for example child day care. at this moment I pay the full amount from the bank, then get tax back (income) to the bank, this gives a distorted view in report on child expenses (and also on income i presume). any way to solve that? same goes with mortgage btw
14:29:26 *** Janos has joined #gnucash
14:29:29 *** cortana has joined #gnucash
14:30:47 <warlord> I'm afraid I dont know.
14:31:26 <Janos> hello! i have a problem with gnucash under windows vista: the q3wizard doesnt work. i have the gnucash-version 2.2.4. and on the faq it stays that i dont need the QT/Open Source Windows from Trolltech... Can someone help me? Thank you!
14:32:06 <warlord> Janos: the two people to help you, andi5 and nbiont, aren't here. You can try asking on the gnucash-user mailing list.
14:32:48 <Janos> warlord: thank you
14:33:05 <warlord> you're welcome
14:33:19 <Janos> they speak english or also german?
14:33:28 <freakynl> warlord: would using the childcare expense account as the income account solve it, or would that raise other issues?
14:34:21 <warlord> andi5 speaks german, but if you're asking on gnucash-user please ask in English
14:34:41 <warlord> freakynl: I dont know. You might need to ask a local accountant.
14:35:23 *** wizkid238 has quit IRC
14:36:01 *** wizkid238 has joined #gnucash
14:43:18 *** xai has left #gnucash
14:51:35 *** Janos has left #gnucash
14:56:48 *** wizkid239 has joined #gnucash
15:03:24 *** wizkid238 has quit IRC
15:05:43 *** SamRose has joined #gnucash
15:09:18 <foo> hm, I invoiced some folks throughout 2007 and marked the income account as "reimbursed expenses" ... I did this, but I should have just marked it as sales then went to sales and deducted cost of goods sold... but I didn't. The only way to fix this is to go back, unpost the respective invoices, and make them go to sales, right?
15:10:51 <foo> I suppose I could just transfer all the money in reimbursed expenses to sales and then from sales to cost of goods sold, actually, right? Kind of hackery, but will that work here?
15:11:19 <warlord> The "best" way is to unpost/change/repost.
15:12:39 <foo> ok, I'll just do that, thanks
15:13:01 <foo> There was only 6 of them
15:13:33 <foo> warlord: hm, just to make sure, I need to unpost and then go to "process payment" - right? Or does the fact that I've already processed a payment still stay in the system even if I unpost?
15:14:26 <warlord> The fact that you've processed payment stays with the system.
15:15:18 <foo> alright, thanks warlord. :)
15:15:32 * foo going over book keeping for last year to make sure everything is accurate/entered in
15:23:51 <foo> warlord: If I purchased some magazines for business use, what would you classify that as? Subscriptions expense, or book expense? Or something else? Hm
15:24:02 <warlord> Sorry, I dont know.
15:24:22 <foo> No problem - thanks anywho
15:27:11 <cortana> foo: it's really up to you (and/or your accountant)
15:29:58 <foo> cortana: thanks, I'll just mark it up to books. That's what I thought. Appreciate the input :) First year actually using gnucash for reporting
15:32:09 *** wizkid238 has joined #gnucash
15:36:40 *** puck has joined #gnucash
15:39:30 *** wizkid239 has quit IRC
15:48:43 *** wizkid239 has joined #gnucash
15:52:25 *** wizkid238 has quit IRC
15:52:36 *** twunder has quit IRC
15:53:45 *** wizkid238 has joined #gnucash
16:00:54 *** wizkid239 has quit IRC
16:41:52 *** andi5 has joined #gnucash
16:46:44 <andi5> warlord: ping ... /me has the bad habit of trying to transfer email conversation to irc ;-)
16:47:35 <foo> :)
16:47:35 *** Zoolooc has joined #gnucash
16:49:29 <warlord> andi5: pong.
16:49:47 *** wizkid239 has joined #gnucash
16:51:24 <andi5> i have already written it in the email and as you did not comment that, i am confused again :-D i wonder whether xaccAccountGetBalanceAsOfDate should rather include splits from transactions posted exactly at the time given by itself.... that is how i would have imagined the function to work anyway
16:52:03 <andi5> if it did, you would not need the +1, do not you?
16:53:52 *** wizkid238 has quit IRC
16:55:03 <andi5> another completely different i wonder about is whether it sounds reasonable to change the meaning of an empty qofquery by making it match _nothing_ instead of matching _every object_ of type t or being invalid (do not know exactly) [to make it possible to easily merge (qof-query-merge AND A (qof-query-merge AND B empty-query))]
16:55:07 <warlord> Umm... If it was changed from < to <= then no, you wouldn't need the +1.
16:55:19 <andi5> and rather invent something like a match-all-qof-query
16:55:32 <andi5> yes, that is what my patch does as well
16:55:54 <warlord> Does it? Maybe I missed that part.
16:56:39 <warlord> As for the qof query -- where do we have an empty query? And why would we be merging it?
16:56:43 <andi5> in the second patch, inside the start-from-head case, i search for the first split > s
16:56:53 <andi5> > the given time, i mean
16:58:15 <andi5> http://svn.gnucash.org/trac/browser/gnucash/trunk/lib/libqof/qof/qofquery.c#L1084 ... this comment i mean
16:59:36 <andi5> i think an empty query could perfectly exist, but it should mean _match nothing_, as this is the union over an empty family of objects
17:00:15 <warlord> Looking at patch #2 you shouldn't need the +1 anymore. But you can easily test that. Just run the book close dialog twice using the same date and look at some expense account that had a balance before the first run to see if it now has a negative balance.
17:00:27 <andi5> will do that!
17:00:54 <warlord> If it has a negative balance after the second run that means you still need the +1 ;)
17:01:08 <andi5> 1 € ? ;-)
17:01:23 <warlord> :-P
17:02:52 <andi5> oh, and question #3: do you envision other areas of code that would profit from walking the split list starting from the tail?
17:03:34 <andi5> (at least i could s,g_list_last,q->tail, about three times) :-)
17:04:23 <warlord> looking at that Query URL.. A query over a book DOES return everything of that type in the book. That shouldn't be changed because that IS a valid query.. E.g. SELECT * from Transactions where Book=<Book_GUID>
17:05:03 <warlord> Oh, I'm sure a number of places would benefit from a GQueue. For example any place that does a "list reverse ; prepend ; list reverse"...
17:07:29 <andi5> huh: http://svn.gnucash.org/trac/browser/gnucash/trunk/lib/libqof/qof/qofquery.h#L135 ?
17:08:05 *** twunder has joined #gnucash
17:08:07 <andi5> ah, the comment repeats itself
17:08:13 <andi5> hiho twunder :-)
17:08:36 <twunder> hi andi5
17:08:50 <twunder> no, I haven't tested the patch yet
17:09:01 *** kielein has quit IRC
17:09:03 <andi5> lol
17:09:38 <andi5> did the smiley betray me? ;-)
17:09:54 <andi5> or reveal
17:10:27 <twunder> heh... a little
17:11:48 <twunder> andi5: maybe tonight or tomorrow night
17:11:55 <andi5> oh, cool! :-D
17:13:21 <warlord> andi5: right. an EMPTY query will return nothing. But once you set the book, it's no longer empty.
17:14:15 <andi5> the book and the type to be search for, i assume?
17:14:28 <andi5> maybe that is too big a beast to touch (yes, i think that is ugly)
17:15:40 <warlord> Well, the "search for" part is required, but doesn't count towards non-emptiness. the book, however, does.
17:15:53 <warlord> E.g. Select * from <search for> where ...
17:16:13 <warlord> So, the search-for is required, but is not sufficient for a non-empty query.
17:16:34 <andi5> see, i thought "select * from <book>.<search for> where ..."
17:17:04 <andi5> but i know you are right :-)
17:18:00 <warlord> ahh, no. the book is a characteristic of the object, not part of the table structure.
17:18:46 <warlord> HOWEVER.. that code may still be buggy, because a query with a book but 0 search terms might still be valid.
17:18:48 *** danield has joined #gnucash
17:19:15 <warlord> I'd need to look again but I dont have time now. I need to head to a meeting.
17:19:33 <andi5> ok... have fun!
17:21:28 *** twunder has quit IRC
17:22:09 <danield> Hi. I've import transaction from 2 different cash accounts into Gnucash. However there are a couple of transfers between the accounts that take place over a couple of days. How can I link up the transactions in both accounts?
17:22:10 <warlord> always.
17:22:41 <danield> s/import/imported
17:26:23 <warlord> danield: QIF or OFX?
17:26:51 *** _gunni_ has joined #gnucash
17:26:52 <danield> Both I think
17:28:00 <danield> QIF
17:28:06 <danield> Only QIF
17:29:39 <warlord> Mark them as dups.
17:29:44 <warlord> during the import.
17:29:58 <warlord> Sorry, gotta run right now. I'll be back in 20 minutes or so...
17:30:12 <danield> Okay. Thanks for your help. I'll be here then.
17:32:45 *** warlord has quit IRC
17:42:37 *** SamRose has quit IRC
17:44:34 *** warlord has joined #gnucash
17:44:34 *** gncbot sets mode: +o warlord
17:50:14 *** SamRose has joined #gnucash
18:07:35 <warlord> andi5: could you help Geoffrey on -user, subject "Newbie question" ?
18:07:52 <warlord> Er, sorry.. ossiemanners
18:08:40 <andi5> i will see
18:09:53 <andi5> http://community.activestate.com/forum-topic/ppm4-mswin32-x64-404-erro ... sounds familiar (ff plugins for java, flash ;-))
18:10:29 *** palatin has quit IRC
18:17:24 *** donfede has quit IRC
18:26:54 *** Zoolooc has quit IRC
18:31:33 <danield> I have a QIF file that is rejected. Is 'T- 1' a valid line in a QIF file? The Gnucash QIF parser doesn't appear to like 'T- 1' but does accept 'T-1'.
18:33:13 *** ErKa has quit IRC
18:34:12 <warlord> No, the whitespace isn't valid.
18:36:02 <danield> Thanks
18:37:14 <danield> Regarding my other question. Is it possible to have a transfer between two accounts that appears a withdrawl from account A on the 1st and a deposit to account B on the 5th say?
18:37:23 *** andi6 has joined #gnucash
18:37:27 <danield> (days of the month)
18:38:48 <warlord> The 'date' is tied tothe transaction, not to the split. So there is only one visible date regardless of the view.
18:39:56 <danield> Sorry, I'm not sure what you mean by 'the split'/
18:40:12 <warlord> Have you read the GnuCash Concepts & Tutorial?
18:40:47 <danield> I have...let me reread though
18:44:17 *** andi5 has quit IRC
18:49:32 <danield> Okay. It doesn't seem like I'm going to do what I want. If the transaction occurred on the same day then I'd be able to link them up but because they are on different days it isn't possible.
18:49:56 <warlord> That's not completely true. You just need to choose one date that the transaction occured.
18:50:04 <warlord> OR you can use some 'in transit' account..
18:50:23 <warlord> BUT then you lose the information about A->B because you get two transactions A->Transit and Transit->B.
18:50:25 <danield> Those are compromises.
18:50:31 <warlord> Of course they are..
18:50:39 <warlord> Most people just choose one date.
18:50:57 <warlord> Then use the 'cleared' reconciled flag to note that the transactoin got posted. The reconcile flags are per-split.
18:51:34 <danield> Okay.
18:51:54 *** _gunni_ has quit IRC
18:53:22 <warlord> Yes, we do get the occasional question about how to put multiple dates on transactions, but seriously, there's no real reason to do it.
18:53:50 <danield> Well hopefully my banks will eventually do transfers in 1 day :)
18:54:56 <danield> No your right, if I import the transactions and specify the default 'in transit account then' and then reconcile. That shouldn't be too much work.
18:55:00 <warlord> Even if they dont... that's exactly what the 'cleared' bit is for.
18:59:24 *** wizkid238 has joined #gnucash
19:01:14 *** wizkid239 has quit IRC
19:08:14 *** wizkid239 has joined #gnucash
19:14:56 *** kling0n has joined #gnucash
19:15:36 *** wizkid238 has quit IRC
19:29:24 <danield> I'm off. Thanks for the help warlord
19:29:41 *** danield has left #gnucash
19:50:09 *** joerlend__ has joined #GnuCash
19:58:03 *** warlord has quit IRC
19:58:38 *** joerlend_ has quit IRC
20:02:32 *** kling0n has quit IRC
20:12:07 *** warlord has joined #gnucash
20:12:07 *** gncbot sets mode: +o warlord
20:12:46 *** warlord is now known as warlord-afk
20:20:51 *** twunder has joined #gnucash
21:04:43 *** andi6 has quit IRC
21:26:16 *** andrewsw-afk is now known as andrewsw
21:27:02 *** andrewsw is now known as andrewsw-afk
21:28:52 *** twunder has quit IRC
21:29:40 *** vinci__ has joined #gnucash
21:34:56 *** wizkid238 has joined #gnucash
21:38:19 *** vinci_ has quit IRC
21:42:48 *** wizkid239 has quit IRC
22:02:30 *** twunder has joined #gnucash
22:05:28 *** twunder has quit IRC
22:08:43 *** wizkid239 has joined #gnucash
22:16:35 *** wizkid238 has quit IRC
22:24:29 *** cortana has quit IRC
22:30:01 *** puck has quit IRC
22:31:56 *** puck has joined #gnucash
22:38:04 *** wizkid238 has joined #gnucash
22:42:59 *** wizkid240 has joined #gnucash
22:47:20 *** wizkid239 has quit IRC
22:48:13 *** wizkid238 has quit IRC