2008-07-13 GnuCash IRC logs
00:29:25 *** Schroeder has quit IRC
00:38:36 *** Schroeder has joined #gnucash
01:56:15 *** warlord has joined #gnucash
01:56:16 *** gncbot sets mode: +o warlord
02:37:22 *** lyte_ has joined #gnucash
02:43:01 <lyte_> I'm trying to setup an account for a shared household. There are multiple people paying different bills out of their own pocket and the bills are not always split up evenly between all the people involved. I can't for the life of me figure out a sane way to setup gnucash to cater for this. Any hints?
02:43:20 <warlord> account per person.
02:43:36 <lyte_> i have one "bank" account per person
02:43:39 <warlord> (either asset or liability -- a liability is a negative asset)
02:43:49 <warlord> sure, that works.
02:44:19 <lyte_> but when i lodge say a phone bill against an account that paid for it, how can i track that the other people owe that person money?
02:44:21 <warlord> then split up appropriately.
02:45:31 <warlord> so if A pays $100 for the phone bill, and B owes $20 and C owes $40, it would be:
02:46:10 <warlord> A: -100; B +20 ; C: +40 ; Expenses:Phone: +40
02:46:57 <warlord> Effectively, A is loaning money to B and C to pay their shares of the Phone Expenses.
02:47:31 <lyte_> but does that mean i have to enter it on 3 different screens? once on the bill and then once on B and C's bank screens?
02:47:46 <warlord> "bank screens"?
02:47:57 <warlord> It's a single split transaction. You can enter it from anywhere.
02:58:24 *** lyte_ has quit IRC
03:06:21 *** warlord is now known as warlord-afk
03:17:17 *** Zoolooc has joined #gnucash
03:54:12 *** Zoolooc has quit IRC
03:54:22 *** Zoolooc has joined #gnucash
04:10:21 *** Rolf1 has joined #gnucash
04:26:03 *** Zoolooc has quit IRC
04:26:10 *** Zoolooc has joined #gnucash
04:34:31 *** Schroeder has quit IRC
04:37:37 *** Zoolooc has quit IRC
05:42:24 *** Zoolooc has joined #gnucash
05:44:31 *** nbinont has quit IRC
05:47:23 *** Zoolooc__ has joined #gnucash
05:55:32 *** Zoolooc has quit IRC
05:55:39 *** Zoolooc has joined #gnucash
06:02:20 *** Zoolooc__ has quit IRC
06:02:43 *** Zoolooc_ has joined #gnucash
06:06:55 *** Zoolooc__ has joined #gnucash
06:11:31 *** Zoolooc has quit IRC
06:12:04 *** Zoolooc has joined #gnucash
06:15:51 *** Zoolooc_ has quit IRC
06:17:38 *** Zoolooc__ has quit IRC
08:55:56 *** IanL has joined #gnucash
09:02:07 *** JimRaehl has left #gnucash
09:06:58 *** JimRaehl has joined #gnucash
09:49:01 *** |gunni| has joined #gnucash
09:57:50 *** _gunni_ has quit IRC
10:27:35 *** warlord-afk is now known as warlord
10:48:55 *** SergeyG has joined #gnucash
10:49:31 *** Schroeder has joined #gnucash
10:50:31 <SergeyG> Hello. I have problem with transferring money from EUR account to local currency account - no conversion is made although I have conversion course entered in prefs... Is this a bug? Thanks.
10:51:29 <warlord> did you enter the exchange rate in the transaction?
10:56:27 *** SergeyG has quit IRC
10:57:49 *** SergeyG has joined #gnucash
10:58:26 <SergeyG> It seems I did not (thought it is taken from currency prefs). Thanks for the quick answer!
11:00:23 <warlord> prefs have very little to do with actual transactional data.
11:04:51 *** Schroeder2 has joined #gnucash
11:05:30 <SergeyG> I see. Thank you.
11:11:12 *** Schroeder has quit IRC
11:13:29 <warlord> you're welcome
11:18:50 *** HASM has joined #gnucash
11:25:48 *** JimRaehl has left #gnucash
11:30:19 *** JimRaehl has joined #gnucash
11:32:27 *** Schroeder2 has quit IRC
11:40:26 *** HASM has quit IRC
11:42:11 *** HASM has joined #gnucash
11:44:10 <HASM> My import maps seem to have several <slot:key> entries that are very similar, of the form <BANK AUTOPAY IDXXX>, where the only difference in them is in the IDXXX
11:45:02 <HASM> I understand that's the way the bank tags those transactions. Just wondering if those entries are any good for matching, or whehter I should pare them down to <BANK AUTOPAY> they would still work.
11:49:12 *** twunder has joined #gnucash
11:49:55 *** Schroeder2 has joined #gnucash
11:50:17 <warlord> QIF uses full string matches.
11:51:24 <warlord> OFX can use substrings.
11:52:57 <HASM> The slot:key entries were generated by OFX imports. I'll take it that I can edit them and they'll match in the future.
11:58:50 <HASM> Is there a way of merging transactions? My Quicken QIF export to GNUcash QIF import procedure a few years back yielded three transactions for each of my by-monthly paychecks for the last 20 years or so and I would like them back into one transaction.
11:58:51 <warlord> Oh, you didn't turn on Bayesian Matching.
11:59:27 <warlord> Turn that on and it'll do substring matches.
12:00:17 <HASM> Just did it, thanks.
12:02:47 *** twunder has quit IRC
12:03:27 <warlord> as for "merging"... No. Your only real option is to mark is as duplicate during the import.
12:05:04 <HASM> They're not duplicate transactions. Each one of those transactions had N splits in Quicken and they ended up as one transaction with N-2 splits and two more transacations containing one of the remaining 2 splits.
12:05:45 <HASM> I have about 24*20 (times the three expansion) of these. I guess I'll have to do it in Perl.
12:06:23 <warlord> Load the multiple QIF files simultaneously (in 2.2.5) and it should work properly.
12:07:06 <warlord> the importer SHOULD merge them..
12:08:56 <HASM> It didn't. I imported all my QIF files for a given currency simultaneously. (DId have transactions in three currencies, which I imported separately and fixed the cross-currency transactions later)
12:09:10 <warlord> What gnucash version?
12:09:46 <HASM> This was about two/three years ago, whatever gnucash I could get into Fedora at the time.
12:10:03 <HASM> The error could have been on the Quicken export, though.
12:11:33 <warlord> Oh..... Yeah, there's been a LOT of QIF import fixes in the last few months.
12:12:55 <HASM> Just looked at the QIF files and they are a single transaction there. I'm not going to go back and re-import, I want to merge them, just not manually. Should be a relatively easy Perl script...
12:12:58 <warlord> So, two/three years ago doesn't count
12:13:03 *** nomeata has joined #gnucash
12:13:20 <warlord> Um, merging transactions in gnucash would be much more than a perl script.
12:17:39 <HASM> Maybe in the general case, but in this case I'll have two splits from two transaction into another (which I can identify with not much trouble) merge three of the splits into one, on the target transaction, and remove the two source transaction. Any reason this wouldn't work?
12:18:28 <HASM> I meant "copying two splits from two ..."
12:19:47 <warlord> Um, internally it's a lot more complicated.
12:19:53 <warlord> you need to make sure the transactions balance.
12:19:59 <warlord> you need to make sure the GUIDs all map
12:21:18 <warlord> Seriously, you might be better off just re-importing.
12:21:23 <warlord> (if there are that many)
12:30:33 <HASM> Don't believe so. Just did one manually and it worked fine. I copied the transaction splits from the extra transaction into the destination transaction. Then merged three that had the same guid account target into one, adding the transaction values, keeping only one of the split guids. Deleted the two extra transactions, rerun gnucash. Seems fine.
12:32:41 <warlord> okay. just keep in mind that what you're doing is not supported.
12:33:28 <HASM> Obviously.
12:35:48 <HASM> Thanks,
12:35:51 *** HASM has quit IRC
13:12:10 *** awdyson has joined #gnucash
13:13:03 <awdyson> anyone willing to answer a question for me?
13:13:20 <warlord> only if you ask it.
13:13:26 <awdyson> fair enough
13:13:43 <awdyson> I'm handling the bills for my roommates and I
13:14:10 <awdyson> I was hoping there was a way to handle expenses with a user style payment scheme
13:14:32 <awdyson> -stop me here if I'm not making sense-
13:14:57 <awdyson> not sure how I'd work this out though
13:15:38 <warlord> Make an asset account for your room mate. Then make split transactions for each payment. The balance of that account is either how much they owe you or how much you owe them, depending on the sign (positive/negative)
13:16:27 <warlord> So if you have a $100 bill split 50/50 and you pay it all, then you would Credit your checking account $100, Debit your roommate's account $50, and Debit Expenses:Bill $50
13:17:41 <awdyson> I think I understand
13:17:54 <awdyson> please excuse the silence by the way
13:18:16 <warlord> no worries
13:23:17 *** Schroeder2 has quit IRC
13:23:34 <awdyson> huzzah, I think I have it
13:23:40 <awdyson> thank you very much sir
13:23:42 <warlord> great
13:23:47 <warlord> you're welcome
13:41:21 *** Schroeder2 has joined #gnucash
14:03:45 *** awdyson has quit IRC
14:45:30 *** localhost has quit IRC
14:46:00 *** HS has joined #gnucash
14:53:21 *** Schroeder2 has quit IRC
14:53:26 *** SergeyG has quit IRC
15:14:10 *** HS has quit IRC
15:55:36 *** Schroeder2 has joined #gnucash
16:15:25 *** andi5 has joined #gnucash
16:15:25 *** gncbot sets mode: +o andi5
16:16:30 *** warlord has quit IRC
17:02:47 *** nomeata has quit IRC
17:33:19 *** Zoolooc has quit IRC
17:38:19 *** _gunni_ has joined #gnucash
17:42:38 *** |gunni| has quit IRC
17:54:39 *** andi5 has quit IRC
17:59:51 *** Schroeder2 has quit IRC
18:13:29 *** McLANE has joined #gnucash
18:19:22 *** Schroeder2 has joined #gnucash
18:21:58 *** warlord has joined #gnucash
18:21:58 *** gncbot sets mode: +o warlord
18:44:20 *** warlord is now known as warlord-afk
18:55:16 *** Schroeder2 has quit IRC
19:13:57 *** McLANE has quit IRC
19:15:43 *** Schroeder2 has joined #gnucash
19:16:04 *** twunder has joined #gnucash
19:20:39 *** McLANE has joined #gnucash
19:21:43 *** nbinont has joined #gnucash
19:30:20 *** Cpt has joined #gnucash
19:30:30 *** Cpt has joined #gnucash
19:32:43 *** McLANE has quit IRC
19:36:32 *** benoitg has joined #gnucash
19:50:43 *** Cpt has quit IRC
20:01:03 *** Schroeder2 has quit IRC
20:20:17 *** Schroeder2 has joined #gnucash
21:12:11 *** nbinont has quit IRC
21:35:28 *** twunder has quit IRC
21:56:28 *** dbreiser has joined #gnucash
22:02:00 *** Schroeder2 has quit IRC
22:23:25 *** Schroeder2 has joined #gnucash
22:44:20 *** N00b has joined #gnucash
22:44:49 <N00b> hello
23:00:52 <dbreiser> hi
23:01:25 <N00b> i am trying to write a shell script to convert a csv to qif
23:01:34 <N00b> the payee in the csv has quotes around it
23:01:48 <N00b> can I make the print statement alter that value to remove the " ?
23:02:21 <N00b> *a beginner at shell commands.. familar with dos - bat files
23:02:25 <dbreiser> I'd be tempted to just strip quotes from the whole file after the fact
23:02:53 <dbreiser> I probably know less shell scripting than you do, though
23:03:00 <N00b> I tired this: print "P" {$2//\"/} but it doesn't like
23:03:53 <N00b> I might venture over to ubuntu's irc..see if someone can help
23:03:54 <N00b> thx
23:04:00 <dbreiser> good luck
23:04:06 *** N00b has left #gnucash
23:06:37 <Schroeder2> "On the field, from Rockford/Loves Park, Illinois, performing their 1994 show 'Songs for a Summer Night', Drum Corps International is proud to present...PHANTOM REGIMENT!"
23:15:51 <Schroeder2> "On the field, from Rockford/Loves Park, Illinois, performing their 2002 show 'Heroic Sketches: the Passion of Shostakovich', Drum Corps International is proud to present...PHANTOM REGIMENT!"
23:40:19 <jsled> Schroeder2: WTF?
23:42:08 <Schroeder2> Dmitri Dmitrievich Shostakovich == greatest. composer. ever.
23:42:33 <jsled> perhaps, but what does that have to do with #gnucash?
23:54:51 <Schroeder2> Shostakovich is relevant everywhere
23:55:36 <jsled> http://www.fluidapp.com/
23:56:42 <jsled> Schroeder2: go find #composers or something. While I understand the need to promote Awesome, this channel is not about what you're talking about.
23:56:55 <jsled> So, fuck off. :D