2010-03-03 GnuCash IRC logs
00:26:23 *** aldente has joined #gnucash
00:36:18 *** trucklover has joined #gnucash
00:56:26 *** shade304 has quit IRC
00:58:57 *** palshife has joined #gnucash
01:00:09 <palshife> minor question...where does gnucash store the list of recently opened files in the File menu?
01:03:08 <palshife> ahh, i just found it, ~/.gconf/apps/gnucash/history
01:24:48 *** aldente has quit IRC
01:36:05 *** palshife has quit IRC
02:13:08 *** e-ndy has joined #gnucash
02:30:17 *** bentob0x has joined #gnucash
03:12:51 *** trucklover has quit IRC
04:10:39 *** Gokee2 has quit IRC
04:23:13 *** jpetersen has joined #gnucash
04:32:47 *** ErKa has joined #gnucash
04:55:56 *** daedeloth has joined #gnucash
04:59:29 *** jean has joined #gnucash
06:35:39 *** bentob0x has quit IRC
07:01:06 *** fDavid has joined #gnucash
07:54:06 *** Jimraehl has left #gnucash
08:04:43 *** warlord-afk is now known as warlord
08:06:11 *** Jimraehl has joined #gnucash
09:06:00 <daedeloth> what's the best way to import transactions into gnucash again?
09:06:21 <warlord> QIF or OFX
09:06:49 <daedeloth> and which one is easiest to understand? it must support transactions which affects 3 accounts
09:07:04 <daedeloth> (I mean, combined transactions)
09:08:17 <daedeloth> actually, is there a way to export transactions? So I can see how they look?
09:09:35 <warlord> Do you mean "split transactions"? If so, then QIF.
09:09:46 <warlord> There is "GnuCash2QIF"
09:09:53 <warlord> Or you can just find QIF examples in lots of places.
09:10:33 <daedeloth> alright, thanks, going to take a look at that
09:11:21 <daedeloth> bah. it looks cobol-age. :p
09:15:59 <warlord> heh.
09:16:08 <warlord> It's just a plain text file with tags.
09:25:47 <jsled> http://en.wikipedia.org/wiki/QIF has a pretty good description
09:29:15 <daedeloth> I still have some trouble understanding my accounts :) that's probably why I have problems with QIF as well :p
09:30:32 <daedeloth> What do I do with spaces in my account names?
09:30:50 <daedeloth> LActiva:Vlottende activa:Liquide middelen:Rekening Courant:PayPal
09:30:51 <daedeloth> ?
09:30:59 <jsled> nothing?
09:31:12 <daedeloth> ok
09:31:41 <warlord> Spaces are legal.
09:31:49 <jsled> daedeloth: what do you mean by "what do I do with"? In what context are you thinking of?
09:32:18 <daedeloth> writing a QIF to import in my accounts
09:32:56 <warlord> Also note that you probably don't want LActiva:... As that would be an Income/Expense. You probably want L[Activa:...] to specify a QIF Account (Asset/Liability) instead of a QIF Category
09:34:00 *** Linuturk_ has quit IRC
09:34:08 <daedeloth> euh, ok, got that one wrong then :)
09:35:08 *** Linuturk has joined #gnucash
09:44:07 <daedeloth> hm, ok, tiny bit stuck
09:44:24 <daedeloth> it's sales I'm trying to import
09:45:09 <daedeloth> so, example, I need to add 100 euro to sales, 21 euro to vat, 79 euro to income
09:45:19 <daedeloth> that's what I have for now
09:45:19 <daedeloth> view-source:http://daedeloth.dyndns.org/bbgs/credits/stats/home/export/?gateway=paypal
09:45:22 <daedeloth> oops
09:45:28 <daedeloth> http://daedeloth.dyndns.org/bbgs/credits/stats/home/export/?gateway=paypal
09:45:29 *** jpetersen has quit IRC
09:46:04 <daedeloth> but I don't have specified the "sales" account yet
09:46:53 <warlord> daedeloth: in QIF you need to work from the ASSET account.
09:47:38 <daedeloth> euh?
09:47:41 <warlord> So... you need to add 100€ to sales, 21€ to vat, 79€ to income.. Is Sales an asset account?
09:47:49 <warlord> Which are debits, which are credits?
09:48:02 <warlord> Are you trying to debit sales 100, credit vat 21, and credit income 79?
09:48:27 <daedeloth> actually, sorry, wrong, it's 100 to bank, 21 to vat and 79 to sales
09:48:35 <daedeloth> bank is a "bank" account
09:49:21 <daedeloth> credit is the left column right? Yes, debet bank, credit sales and credit income
09:49:22 <warlord> Okay, so you'd create a file bank.qif and the "this" account would be bank. Then you can create you splits
09:49:35 <warlord> I couldn't tell you which column is which.. Sorry.
09:49:38 <daedeloth> aaah, alright
09:51:03 <daedeloth> good, I think I'm done then. Now just the "cost" transation and I'm going to give it a try :p
09:54:46 <warlord> okay
10:04:41 <daedeloth> *woohoo* it's working
10:04:59 <daedeloth> and you don't even need to give the full account names?
10:05:46 *** jpetersen has joined #gnucash
10:07:05 <daedeloth> hm, I spoke too soon.
10:07:20 <daedeloth> negative transactions (costs) should have a minus, right?
10:07:24 <daedeloth> T-1.62
10:07:25 <daedeloth> and
10:07:28 <daedeloth> $-1.62
10:09:03 <warlord> Yes.
10:10:59 <warlord> no, you dont need to give full account names -- in the QIF importer you will map from QIF Category/Account to GNC Account.
10:12:06 <daedeloth> and the "master account" can be defined as well?
10:14:09 <warlord> Yep. "bank.qif" -> "bank" qif account -> map "bank" to GNC Account
10:14:24 <warlord> (i.e., "bank" would be just another qif account for you to map during the import)
10:15:59 <daedeloth> great, changing some headers :)
10:16:59 <warlord> :)
10:30:20 <daedeloth> hm
10:30:26 <daedeloth> everything goes right, except the "costs"
10:30:50 <daedeloth> oh, never mind
10:31:03 <daedeloth> it's right :) just misread the accounts
10:31:30 <warlord> Okay
10:31:30 *** ErKa has quit IRC
10:32:14 <daedeloth> I can only import from file I suppose? there is no "sync" system for it?
10:32:19 *** ErKa has joined #gnucash
10:32:47 <warlord> correct.
10:34:04 <daedeloth> alright, fair enough
10:34:08 <daedeloth> http://daedeloth.dyndns.org/bbgs/credits/stats/home/export/?gateway=paypal&start=01/02/2010&end=01/03/2010
10:34:17 <daedeloth> any tips / improvements that might help me in the future?
10:35:20 *** e-ndy has quit IRC
10:35:51 <warlord> You don't need !Type:Bank before every transaction, just at the top of the file.
10:36:02 <daedeloth> ah, alright
10:36:29 <warlord> Other than that, it looks good.
10:36:57 <daedeloth> thinking about adding the export date in the comments
10:37:40 <daedeloth> but then again, last transaction date does the trick as well
10:37:50 <daedeloth> anyway, thanks for your help and your great software :)
10:38:07 <warlord> You're welcome.
10:39:16 *** Gokee2 has joined #gnucash
12:39:32 *** bentob0x has joined #gnucash
12:50:34 *** KaiForce has joined #gnucash
12:51:54 *** KaiForce has quit IRC
13:08:37 *** KaiForce has joined #gnucash
13:17:42 *** bentob0x has quit IRC
13:20:25 *** bentob0x has joined #gnucash
14:25:12 *** bentob0x has quit IRC
14:29:23 *** jpetersen has quit IRC
14:53:52 *** silky has joined #gnucash
14:56:26 <silky> I have a quick accounting question about how my journal entries should be when I share expenses with other people. For example, Me and three other friends buy a $20 pizza and decide to split it 4 ways. If i paid out of my credit card in full and my friends paid me back $5 each for a total of $15. How do I set up my journal entries
14:59:45 <jsled> silky: http://wiki.gnucash.org/wiki/FAQ#Q:_How_do_I_account_for_loaning.2Fborrowing_money_to.2Ffrom_a_friend.3F
15:01:04 <silky> Thanks
15:03:00 <silky> For refunds, do I just credit the expense account and debit the asset account or is there a special way to keep track of refunds?
15:03:05 *** daedeloth has quit IRC
15:08:25 <jsled> s/refund/rebate/, which matches the Expense account column heading … but yeah, that's fine
15:12:37 *** cort has joined #gnucash
15:20:09 *** daedeloth has joined #gnucash
15:23:07 * warlord now has TWO IP-based phones, on completely different systems.
15:43:45 *** andyt has joined #gnucash
15:45:34 *** KaiForce has quit IRC
16:02:04 *** ErKa has quit IRC
16:06:16 *** silky has quit IRC
16:24:10 <mishehu_> warlord: thank your stars yuo're not a VoIP dev
16:24:14 *** mishehu_ is now known as mishehu
16:24:35 <mishehu> I've got 3 on my desk. and 5 more put away right now
16:24:53 <mishehu> and another voip dev I know has something between 12-18 phones on his desk at any point in time
16:27:14 *** fDavid has quit IRC
16:40:48 <warlord> mishehu: I'm friends with the (relatively new) CTO of Skype. ;)
16:41:17 <warlord> I just installed a Cisco IP phone on my work VPN, and I also have an asterisk server tied to an ATA-186
16:56:09 *** jean has quit IRC
17:03:53 *** Zoolooc_ has joined #gnucash
17:21:51 *** andyt has quit IRC
17:57:13 *** daedeloth has quit IRC
18:37:30 *** KaiForce has joined #gnucash
18:45:23 *** fDavid has joined #gnucash
19:14:11 *** cort has quit IRC
19:32:34 *** KaiForce has quit IRC
19:57:19 *** Zoolooc_ has quit IRC
21:31:16 *** fDavid has quit IRC
22:10:00 <thomas> warlord: Can you influence your friend to get linux Skype updated to Windows capability? I'm pulling my hair out with 320x240 up, but no one can see it...
22:10:45 <warlord> i wish
22:11:01 <thomas> :(
22:22:32 <warlord> I'm trying to get them to produce an x86_64 binary..
22:27:31 <thomas> I just installed the one on their download page marked for Ubuntu 8.10. It was 2.1.0.81 ( my Ubuntu installs 2.1.0.41 ). Works fine, such as it is.
22:28:03 <thomas> I'm ubuntu 9.04 64bit.
22:44:13 <warlord> Right, but it's still a 32-bit app
22:47:27 <warlord> anyways, gotta go. good night
22:47:29 *** warlord is now known as warlord-afk
23:39:30 *** palshife has joined #gnucash
23:51:22 *** palshife has quit IRC