2008-08-25 GnuCash IRC logs
00:05:21 *** |gunni| has quit IRC
00:08:35 *** RaceCondition has quit IRC
00:27:44 *** benoitg has joined #gnucash
00:57:59 *** mrp has quit IRC
01:02:07 *** Azih has joined #gnucash
01:02:40 <Azih> Hey guys I'm just starting to use gnucash and my account setup for home mortgage is screwing up my cash flow report
01:03:05 <Azih> basically the loan is showing up as cash in but it's not showing up as cash out
01:04:05 <Azih> which is showing my net worth as far higher than it actually should be.
01:11:04 *** Azih has quit IRC
01:46:10 *** RaceCondition has joined #gnucash
01:55:31 *** Rommedahl has joined #gnucash
01:57:09 <Rommedahl> What is the Num column in the transaction window?
02:40:28 *** RaceCondition has quit IRC
02:54:09 *** Mansig has joined #gnucash
03:01:41 *** Mansig has quit IRC
03:55:01 *** esperegu has joined #gnucash
04:52:00 *** Mansig has joined #gnucash
05:49:02 *** Mansig has quit IRC
06:02:06 *** Ozaed_ has joined #gnucash
06:02:21 *** nomeata has joined #gnucash
06:10:43 *** Ozaed__ has quit IRC
06:17:15 *** martincleaver has joined #gnucash
06:24:19 *** Rolf2 has joined #gnucash
06:57:56 *** ErKa has joined #gnucash
07:02:07 *** martincleaver has quit IRC
07:12:53 *** RaceCondition has joined #gnucash
07:24:27 *** RaceCondition has quit IRC
07:51:49 *** JimRaehl has left #gnucash
07:57:25 *** JimRaehl has joined #gnucash
07:59:26 *** JimRaehl has quit IRC
08:00:47 *** JimRaehl has joined #gnucash
08:29:08 *** ErKa has quit IRC
09:14:00 *** esperegu has quit IRC
09:36:27 *** esperegu has joined #gnucash
09:49:30 <Rolf2> How does this SQL stuff work?
09:49:42 <Rolf2> I have a recompiled gnucash from trunk
09:50:03 <Rolf2> Do I need to configure it with some kind of switch?
09:50:18 <Rolf2> Save as does not present me with an option to convert to SQL
09:53:29 *** benoitg has quit IRC
09:56:56 *** ErKa has joined #gnucash
10:03:07 *** twunder has joined #gnucash
10:26:29 *** Rolf2 is now known as Rolf1
10:58:22 *** esperegu has quit IRC
11:03:44 *** aindilis` has quit IRC
11:50:25 *** JoeyJoeJo has joined #gnucash
11:50:59 <JoeyJoeJo> I just installed gnucash 2.2.6 on my mac via fink, but there is no online banking option. Does anyone know how I can fix it?
12:01:36 *** warlord has joined #gnucash
12:01:36 *** gncbot sets mode: +o warlord
12:02:31 *** |gunni| has joined #gnucash
12:10:47 *** _gunni_ has quit IRC
12:14:59 *** RaceCondition has joined #gnucash
12:19:43 *** esperegu has joined #gnucash
12:52:09 *** nomeata has quit IRC
13:18:49 *** RaceCondition has quit IRC
13:35:58 *** RaceCondition has joined #gnucash
13:54:44 *** RaceCondition has quit IRC
13:56:15 *** RaceCondition has joined #gnucash
13:57:07 *** ErKa has quit IRC
14:13:14 *** Blindjesse has joined #gnucash
14:14:07 <Blindjesse> Hi all. Thanks for the help in advance.
14:15:45 <Blindjesse> I'm trying to record splitting the cost of house bills. I'm paying the entire bill from my checking account, splitting costs down the middle, then waiting for the reimbursement from roommates.
14:16:25 <Blindjesse> My best shot so far has been to do a transaction from my checking to the expense account for the bill, then putting the half owed to me from my checking account to an a/r for my roommate.
14:16:53 <Blindjesse> But this takes two transactions and I wonder if I couldn't somehow do it as a split or similar transaction. Thoughts?
14:17:24 <jsled> Move the full amount out of your checking account (of course), then only your portion into the Expense account, and the remainder into the Assets (a/r) accounts for your roommates
14:17:48 <jsled> Instead of using the business features and A/R stuff and all that, just create an {Assets:Money Owed to Me:Roommate} account.
14:18:07 <jsled> (all as splits on one transaction, yes.)
14:19:09 <Blindjesse> But wouldn't the expense account then show only half the bill had been paid?
14:19:39 <jsled> Sure. If that's your portion of the Expense, then that's what it should show, eh?
14:20:55 *** sjc has joined #gnucash
14:23:45 <Blindjesse> That's true...
14:24:15 *** RaceCondition has quit IRC
14:26:32 <Blindjesse> But then it seems like I would have to record somewhere separately (and maybe that's the appropriate thing to do) that the entire bill had been paid.
14:28:14 <jsled> Well, the asset account side of the transaction does record that.
14:28:28 <jsled> The Checking account, obviously, not the "owed to me" accounts.
14:29:22 <Blindjesse> I'll give it a shot. Thanks for the help.
14:32:33 <warlord> [OT] Wow -- it took me 24 hours to migrate from a 250GB -> 320GB disk.. I had to copy the data across no fewer than 3 times to get the repartitioning to work!
14:39:06 *** RaceCondition has joined #gnucash
14:47:52 *** RaceCondition has quit IRC
14:53:07 *** warlord is now known as warlord-afk
15:04:25 <Rommedahl> Rommedahl: What is the Num column in the transaction window
15:05:07 <jsled> It's a number associaited with the transaction. E.g., the physical check number for the transaction.
15:05:11 <jsled> I hardly use it.
15:05:25 <jsled> Basically only for the half-dozen actaul checks I write every year.
15:30:52 *** balubalu has joined #gnucash
15:33:39 <balubalu> hey, im trying to configure a new hbci account, but the qt3-wizard.exe allways crashes during the setup. im using the latest stable version with vista ultimate 32bit. AqBanking should be installed with the installer, or do i have to do it manually whith qt for win?
15:50:17 *** warlord-afk is now known as warlord
15:50:51 <warlord> Have you checked on the mailing list? I remember someone else was having this kind of issue. You shouldn't need to install anything special to get HBCI working.
15:51:31 <balubalu> sry im new to mailinglists i only know forum ;)
15:51:52 <balubalu> can i find the list on the gnucash website?
15:52:14 <warlord> yes
15:52:18 <balubalu> k
15:52:53 <balubalu> maybe its something with the vist useraccount, no adminprevilige
15:52:58 <balubalu> vista
15:59:45 <warlord> Maybe...
15:59:49 <warlord> Vista is kinda weird.
15:59:55 <warlord> And I dont use windows myself.
16:01:54 *** esperegu has quit IRC
16:02:19 <balubalu> that was sure. :) i want to change from a propritarian software, and i searched the internet, and everything i found saif gnucash is the best open source hbci finance solution, so im trying now
16:03:45 *** Blindjesse has quit IRC
16:04:56 <warlord> I think it is, but I use Linux.
16:28:35 <balubalu> the log file contains some pieces german and english
16:28:35 <balubalu> * WARN <qof.engine> [guid_init()] only got 2068 bytes.
16:28:35 <balubalu> The identifiers might not be very random.
16:28:35 <balubalu> * WARN <gnc.app-util> Could not spawn perl: Kindprozess konnte nicht ausgeführt werden (No such file or directory)
16:28:35 <balubalu> * WARN <gnc.import.hbci> Ouch, no Qt demo program was found. Qt not installed?
16:30:55 <warlord> I'm afraid I really know nothing about the windows distribution.
16:31:52 <balubalu> k then i dont bother u anymore withit ;)
16:35:10 *** benoitg has joined #gnucash
16:36:55 <warlord> I'd recommend you ask on the gnucash-de mailing list.
16:40:56 *** JoeyJoeJo has quit IRC
16:41:04 <balubalu> im surfing through the list so far, and found maybe the portable version is a solution. are here also some windows guys around from time to time?
16:46:28 <warlord> periodically andreas and nathan show up.
16:48:48 <balubalu> k thx
17:17:26 *** twunder has quit IRC
17:41:40 *** balubalu has quit IRC
18:20:26 <Rolf1> How does this SQL stuff work? I have a recompiled gnucash from trunk. Do I need to configure it with some kind of switch? Save as does not present me with an option to convert to SQL
18:22:30 <warlord> Yes, you need to --enable-dbi
18:25:06 *** hauptmat has joined #gnucash
18:28:10 <hauptmat> I'm using gnucash for a small business and have some multiple currency issues. I have a foreign currency account and I need to keep a parallel record of the value of each entry in my local currency for gov't reporting purposes. Ideas?
18:30:38 <Rolf1> warlord: thanks
18:38:09 *** ErKa has joined #gnucash
18:43:14 *** warlord is now known as warlord-afk
18:44:31 *** Rommedahl has quit IRC
19:21:53 <Rolf1> warlord-afk: --enable-dbi did not really change a thing it seems
19:22:14 <Rolf1> I have an entry "database connection" under File, but that was there before
19:22:47 <Rolf1> I still don't see how to save an xml gnucash file as an sql file (no such thing under "Save As")
19:22:55 <Rolf1> Any idea?
19:28:17 *** Rolf1 has quit IRC
19:34:14 <jsled> http://www.macworld.com/article/135198/2008/08/quickenonline_iphone.html
20:22:19 *** BlackBsd has joined #GnuCash
20:23:00 *** sjc has quit IRC
20:25:12 *** ErKa has quit IRC
20:40:29 *** localhost has quit IRC
20:48:19 *** localhost has joined #gnucash
21:06:20 *** twunder has joined #gnucash
21:18:18 *** warlord-afk is now known as warlord
21:21:05 *** ninja has joined #gnucash
21:22:52 *** JoeyJoeJo has joined #gnucash
21:40:09 *** JoeyJoeJo has quit IRC
21:43:24 *** twunder has quit IRC
21:58:32 *** ninja has quit IRC
22:02:23 *** quotemstr has joined #gnucash
22:23:54 <quotemstr> Why are my transactions being imported as imbalances?
22:25:46 <warlord> quotemstr: because you're not supplying both ends of the transaction?
22:26:37 <quotemstr> Oh.
22:26:44 <quotemstr> Just starting out. :-)
22:27:45 <quotemstr> I'm trying to import several years worth of financial records. Should I create accounts with which I can balance all these transactions?
22:27:53 <jsled> yes
22:29:04 <quotemstr> Also, I use a credit card to pay for everything, which I then pay off in full every month. Do I account checking account transfers to the same transactions I account the credit card ones to? Or do I just balance the checking transfers with the credit card, and balance the credit card with the various other transactions?
22:29:34 <warlord> CC -> Exp ... and then Checking -> CC
22:29:55 <quotemstr> Thanks.
22:30:00 <warlord> If you haven't read it already I highly recommend you read the Concepts & Tutorial. I explains Double Entry Accounting.
23:34:00 <quotemstr> Why is gnucash complaining that the current transaction isn't balanced when it *is* associated with another account?
23:34:14 <quotemstr> Clicking any transaction causes that dialog to appear.
23:34:42 <jsled> what do the splits in the current transaction look like?
23:34:56 <jsled> What register are you editing "in"?
23:35:33 <quotemstr> I imported some transactions into a checking account. Arbitrarily, let me choose a salary entry. In the generic importer, I associated it with income:salary.
23:36:43 <quotemstr> Ah, wait. I see what's going on now.
23:36:44 <quotemstr> Thanks.
23:37:01 *** benoitg has quit IRC
23:37:55 <quotemstr> I tried to import another set of transactions, but those all came in as imbalanced (even though I canceled the import, I think.)
23:38:03 *** benoitg has joined #gnucash
23:38:15 <warlord> if you canceled the import they shouldn't have come in
23:38:29 <quotemstr> Is there a way to mass-delete them?
23:38:43 <warlord> 'rm /path/to/datafile'?
23:38:56 <jsled> Which would delete your datafile.
23:38:57 <jsled> Don't do that.
23:39:05 <quotemstr> I mean, all these transactions that aren't balanced. That way, I can go ahead and re-import them, balancing them this time.
23:39:21 <jsled> No, there's no bulk-delete.
23:39:49 <warlord> You could revert to a backup from before the import?
23:39:49 <jsled> Unless they all happened to be in the same [sub-]account, in which case when you delete that, you can choose to delete all the transactions.
23:42:15 <quotemstr> Problem solved: gnucash crashed, and when I re-opened it, the new transactions were gone. :-)
23:42:34 <jsled> heh heh
23:42:42 <warlord> oh, .... you didnt save.... you could have just exited. ;)
23:42:55 <quotemstr> warlord: What about autosave?
23:43:23 <warlord> oh, right --- i have that turned off