2009-03-19 GnuCash IRC logs

01:07:38 *** hvx has joined #gnucash
01:08:12 *** hvx has quit IRC
01:41:28 *** warlord has joined #gnucash
01:41:28 *** gncbot sets mode: +o warlord
02:20:17 *** troyed has left #gnucash
02:23:00 *** warlord is now known as warlord-afk
02:49:26 *** MechtiIde has quit IRC
03:02:02 *** eukreign2 has joined #gnucash
03:11:09 *** eukreign has quit IRC
04:24:45 *** ErKa has joined #gnucash
04:30:58 *** MechtiIde has joined #gnucash
06:51:31 *** paulproteus_____ has quit IRC
06:52:41 *** paulproteus_____ has joined #gnucash
07:13:48 *** MechtiIde has quit IRC
07:14:25 *** MechtiIde has joined #gnucash
07:27:23 *** vitoc has joined #gnucash
07:47:55 *** Jimraehl has left #gnucash
08:09:11 *** JimRaehl2 has joined #gnucash
08:19:37 *** JimRaehl2 has left #gnucash
08:20:48 *** JimRaehl2 has joined #gnucash
11:11:18 *** KaiForce has joined #gnucash
11:28:38 *** iamawake has quit IRC
11:40:07 *** warlord-afk has quit IRC
11:46:01 *** palatin has joined #gnucash
11:47:03 *** Pyrovatar has joined #gnucash
11:47:39 <Pyrovatar> Hi everybody, I have a problem... anyone to assist?
11:48:39 <jsled> please don't meta-ask. just ask your question
11:49:35 <Pyrovatar> today when I opened my GNUCash all the dates were 1 day back
11:50:22 <Pyrovatar> daily book and reports, like if everything happened the day before
12:03:03 <Pyrovatar> I didnt change my system clock or anything, what could be the problem?
12:06:00 *** warlord has joined #gnucash
12:06:00 *** gncbot sets mode: +o warlord
12:19:51 *** MechtiIde has quit IRC
12:29:06 <warlord> linas: are you going to be around next Sunday (March 29)?
12:29:25 <linas> think so
12:29:34 <linas> why?
12:30:07 <linas> oh, right server/dns stuff :-)
12:30:32 <warlord> Yeah. I'll be home so I'm thinking that will be a good day to do the data/service migration.
12:30:56 <warlord> Just wanted to make sure you'd be around
12:32:00 *** iamawake has joined #gnucash
12:42:31 <linas> I don't have any plans at the moment. If the weather is good, I might run around outside ...
12:43:00 <warlord> That's fine.. So long as I can get about 2 minutes of your time sometime within a 8-hour window.
12:46:19 <linas> Pyrovatar, make sure that your locale settings are correct
12:46:52 <linas> Something, eithr your system, or gnucash, probably thinks is still before midnight, the day before.
12:47:13 <warlord> Pyrovatar: what's your question?
12:47:17 * warlord didn't see you ask one.
12:47:56 <Pyrovatar> oh right
12:48:04 <Pyrovatar> today when I opened my GNUCash all the dates were 1 day back
12:48:09 <Pyrovatar> daily book and reports, like if everything happened the day before
12:48:46 <Pyrovatar> i did move my system clock by 1 hour because of the DST, but i fail to understand how that moved ALL my records by a full day
12:49:40 <linas> which "system clock" did you move? are you sure you didn't accidentally change UTC by 7 hours?
12:50:12 <Pyrovatar> the one in system xp
12:50:33 <Pyrovatar> the stupid clock in the task bar, just moved the timezone by an hour in the little map
12:50:42 <Pyrovatar> *windows xp
12:51:42 <warlord> GnuCash does have a problem when you change timezones.
12:51:52 <warlord> Did you actually change the timezone?
12:52:46 <Pyrovatar> yeah, i didnt substract an hour from the total, i just moved the timezone in the little map, so the extra hour went off
12:53:21 <Pyrovatar> I was -2 and now im -3
12:53:30 <Pyrovatar> GMT
12:54:12 <warlord> Right, and that's why.
12:54:29 <warlord> There's a known issue with changing timezones.
12:54:51 <warlord> There was a whole thread on gnucash-devel; If you really care for the explanation I suggest you go read that.
12:57:16 <Pyrovatar> I care for wathever makes my gnucash go back to normal
12:57:38 <Pyrovatar> i work for the mafia, and i need to put my numbers straight or the boss is gonna chop my balls off, with a saw
12:57:57 <Pyrovatar> (im not kidding)
12:59:13 *** Zoolooc has joined #gnucash
13:01:56 <warlord> LOL.
13:02:04 <warlord> Change you timezone back to the old one and fix the clock. :0
13:25:50 <Pyrovatar> it seems that gnucash dates are stored as being 00:00:01 in LOCAL time
13:25:50 <Pyrovatar> which is obviously causing my problem :(
13:29:59 <warlord> Correct.
13:36:03 <Pyrovatar> this must be one of the most retarded bugs ive ever seen
13:36:22 <Pyrovatar> i mean, i see here that it was reported several times since 2004
13:37:40 <warlord> If it's so retarded then why don't YOU fix it in a way that doesn't break forwards or backwards data file compatibility?
13:38:12 <Pyrovatar> im no programmer since i already told you that im an errand boy for the mafia, but hell... even i can tell that the solution would be to set the default entry time to 12 mid-day
13:38:35 <Pyrovatar> in that way you have a 12 hour window to move east or west w/o messing everything up
13:39:38 <gxti_> heh
13:40:11 *** gxti_ is now known as gxti
13:42:59 <Pyrovatar> the only way you could be screwed by that fix is if you live in Nuku'Alofa (GMT +13) but i dont really think that people in a place named like that know what a computer is
13:43:09 <Pyrovatar> im just saying
13:53:18 *** vitoc has quit IRC
13:59:42 *** warlord is now known as warlord-afk
14:13:56 *** andyt has joined #gnucash
14:28:03 *** |gunni| has joined #gnucash
14:28:53 *** Pyrovatar has quit IRC
14:35:27 *** goodger has quit IRC
14:42:43 *** MechtiIde has joined #gnucash
14:43:28 *** goodger has joined #gnucash
14:48:15 *** warlord-afk is now known as warlord
14:49:07 *** warlord has quit IRC
15:07:59 *** hvx has joined #gnucash
15:08:57 *** sjc has joined #gnucash
15:27:04 *** goodger has quit IRC
15:29:06 *** goodger has joined #gnucash
15:33:59 *** hvx has quit IRC
15:40:40 *** warlord has joined #gnucash
15:40:40 *** gncbot sets mode: +o warlord
15:41:21 *** warlord is now known as warlord-afk
16:24:00 *** warlord-afk is now known as warlord
16:31:06 *** twunder has joined #gnucash
16:31:35 *** danols has joined #gnucash
16:31:39 <danols> hi
16:32:44 <danols> I have read the home mortgage tutorials but am still confused. I have bought the property over a year ago, so filling all of the transactions since than will be very time consuming. Is there a way to set it somehow up useing the 'equity' opening balance ?
16:33:14 <danols> i'm having a hard time seeing the 'big' picture in gnucash
16:33:16 <warlord> Sure, you can just start at "today"
16:33:31 <danols> warlod could you elaborate on that?
16:33:45 <danols> in regards to the account structure
16:33:47 <warlord> So set the opening balance or your loan principal to whatever the balance is (was) when you started your accounting.
16:34:05 <danols> k
16:35:00 <danols> does Opening Equity come in place here at all?
16:35:54 <warlord> Equity:Opening Balance would be the source account for all your opening balances in all Asset and Liability accounts.
16:36:04 <warlord> Have you read the GnuCash Concepts and Tutorial Guide?
16:36:36 <danols> warlord I promise I did :) but i'm having a hard time wrapping my head arround; seeing the big picture on how to setup all of my accounts
16:37:13 <warlord> Use the default file hierarchives.
16:37:16 <warlord> hierachies even
16:37:48 <danols> k question
16:39:03 <danols> In the mortage tutorial the asset house has incrase from liabilities account, how does the opening equity fit into here? or it dosen't
16:39:22 <danols> (sorry for my spelling english is my second language)
16:42:38 <warlord> well, it all depends on whether you bought the house before or after you started accounting.
16:42:59 <warlord> Using Eq:O-B means the house was purchased prior to your Time-0.
16:43:15 <warlord> The L->A txn implies the house was bought AFTER T0
16:46:57 <danols> warlord ok I'm assuming O-B means oppening balance. So I would do Openning Balance -> Asset House (Purchase Prize) and than Openning Balance -> Liabilities: Mortgage right?
16:47:47 <warlord> Yes. Let's say you bought the house July 17, 2005 for $100,000 with an $80,000 mortgage.
16:47:57 <warlord> You're starting your accounting on Jan 1, 2009.
16:48:18 <warlord> On Jan 1, 2009 the mortgage principal is $69,123.52
16:48:39 <warlord> So.. You put a transaction from Eq:O-B -> Assets:Fixed Assets:House for $100,000
16:48:41 <danols> k follow you so far
16:49:00 <warlord> And from Eq:O-B -> L:Mortgage for 69,123.52
16:49:13 <warlord> (make sure you get the signs correct in those transactions)
16:49:59 <danols> warlord please clarify 'signs correct'
16:50:34 <warlord> Debit and Credit. + / 0
16:50:38 <warlord> + / -
16:51:06 <danols> opening balance -> house would be a deposit into house asset wheras o-b > mortgage would be a ?
16:51:35 <danols> withdraw from equity ?
16:52:24 <danols> never mind I think that's obvious
16:52:33 <danols> what about interest how would you set that up?
16:53:04 <warlord> Interest is an expense. There is no opening balance.
16:53:28 <danols> or it's not needed and I should just track interest expense from now on and not worry what I paid prior?
16:53:36 <warlord> When you pay your mortgage it's a split transaction.. You credit your checking account and debit the liability and expense accounts (and your escrow asset account if you have one)
16:54:03 <warlord> You don't care about Income/Expense prior to T0 (Jan 1, 2009 in my example)
16:54:08 <danols> k
16:55:29 <danols> i am confused, sholdn't it be when I pay my mortgage I decrease my checking account and increase(credit) my liabilities so they decrease?
16:56:39 *** twunder has quit IRC
16:57:29 <warlord> You are confused. You have credit and debit backwards. Crediting Checking reduces it.
16:57:34 <warlord> Debiting checking would increase it.
16:58:12 <danols> that was in the intro tutorial, i'll have to read that again
16:58:17 <warlord> Yeah
16:58:25 <warlord> Anyways, I've got a meeting. Gotta run for a while.
16:58:26 *** warlord is now known as warlord-afk
16:58:30 <danols> warlord I think you have given me a good idea on how to tackle this
16:58:31 <danols> thank you
17:07:54 *** palatin has quit IRC
17:09:37 *** KaiForce has quit IRC
17:18:21 *** Zoolooc__ has joined #gnucash
17:26:35 *** Zoolooc has quit IRC
17:36:04 <danols> Should rental property income be an Income type account or A/Receivable?
17:37:14 *** ErKa has quit IRC
17:53:35 <goodger> danols: both, probably
17:54:24 <goodger> i.e., at the end of the month, income is credited and a/r debited, then a/r credited and bank debited when the money is actually paid
17:55:00 <danols> so hmmm
17:57:43 <danols> what about utilities and such is that a/p and another expense account?
17:58:18 <danols> i have to say learnin gnucash is giving me a headache but than again i have no experience in accounting so I think that makes it so difficult to wrap my head arround it
18:02:26 <goodger> well, it depends whether there is a period between receiving the bill and paying it
18:03:05 <goodger> if you receive the bill, wait a while, and pay it, then there is a time when you owe the utility company money, in which case an a/p account is required
18:03:28 <goodger> otherwise money goes directly from the bank to expense account
18:08:30 *** danols has quit IRC
18:12:22 *** MechtiIde has quit IRC
18:16:25 *** rgsteele||work has joined #gnucash
18:45:38 *** iamawake has quit IRC
18:51:52 *** Demitar has joined #gnucash
18:57:56 *** _gunni_ has joined #gnucash
19:03:48 *** _gunni_ has quit IRC
19:05:55 *** andyt has quit IRC
19:07:08 *** |gunni| has quit IRC
19:29:50 *** Zoolooc__ has quit IRC
19:30:08 *** Zoolooc has joined #gnucash
19:45:55 *** warlord-afk is now known as warlord
19:55:04 *** aindilis` has joined #gnucash
19:58:12 *** iamawake has joined #gnucash
20:01:47 *** Zoolooc has quit IRC
20:41:02 *** pupeno has joined #gnucash
20:41:06 <pupeno> Hello.
20:55:24 <pupeno> Is there a way to export my data from gnu cash to another program?
20:55:51 <warlord> gnucash2qif
21:04:22 <rgsteele||work> What's the best method for handling employer matches in a 401K? A separate income account?
21:05:11 <warlord> Yeah
21:17:39 <rgsteele||work> Cool, thanks warlord.
21:17:47 <warlord> no prob
21:30:52 <pupeno> warlord: what should I open with that? an exported file?
21:31:33 <warlord> gunzip your data file.
21:36:40 <pupeno> warlord: thanks :)
21:36:47 <warlord> you're welcome
21:42:35 *** xetn has joined #gnucash
21:42:35 *** chris has quit IRC
21:44:17 *** smacnay has joined #gnucash
21:44:28 *** chris has joined #gnucash
21:45:40 <xetn> as a new user, i have noticed a very large number of .log files, etc. which seem to be filling up my /home dir. how many of these files do i need to retain?
21:46:09 *** twunder has joined #gnucash
21:54:34 *** sjc has quit IRC
22:01:33 *** JimRaehl2 has left #gnucash
22:03:18 *** Jimraehl has joined #gnucash
22:06:53 <warlord> xetn: read the FAQ
22:07:02 <warlord> (you don't need many .log files at all)
22:07:35 <xetn> i did read the faq but didn't find an answer. can you point me in the right direction?
22:07:54 *** twunder has quit IRC
22:16:08 <warlord> http://wiki.gnucash.org/wiki/FAQ#Q:_What_are_all_these_.xac_and_.log_files_filling_up_my_directory.3F
22:18:58 *** rgsteele||work has quit IRC
22:29:30 *** pestilence has joined #gnucash
22:30:23 <xetn> Thanks, warlord.
22:30:34 <warlord> you';re welcome
22:30:37 <pestilence> i'm using gnucash 2.2.6 in ubuntu intrepid, and the "get quotes" function seems to be broken. it used to work, now it says "Unable to retrieve quotes for these items:" (followed by the assets i'm wanting quotes for)
22:30:47 *** xetn has left #gnucash
22:31:55 <pestilence> any ideas on how to debug?
22:34:47 <warlord> Check F::Q
22:35:36 <warlord> Sorry, gotta run
22:36:32 *** warlord has quit IRC
23:31:18 *** pupeno has quit IRC