2014-03-18 GnuCash IRC logs

01:45:00 *** ErKa has quit IRC
02:03:47 *** MechtiIde has joined #gnucash
02:43:54 *** aqua_ has joined #gnucash
02:52:42 *** aqua___ has quit IRC
03:09:03 *** MechtiIde has quit IRC
03:14:53 *** Takyoji[laptop] has quit IRC
03:38:01 *** uXus has quit IRC
03:39:21 *** fell has joined #gnucash
03:39:23 *** gncbot sets mode: +o fell
03:44:27 *** uXus has joined #gnucash
03:48:10 *** SteveG has joined #gnucash
04:03:18 *** gjanssens has joined #gnucash
04:03:19 *** gncbot sets mode: +o gjanssens
04:29:19 *** gncbot` has joined #gnucash
04:40:34 *** gncbot has joined #gnucash
04:40:53 *** gncbot` has quit IRC
04:48:01 *** Hamaryns has joined #gnucash
04:49:10 <Hamaryns> hi all, is there an easy way to merge two gnucash files? Due to computer troubles, I have to files which are the same up to february, but from then on diverge. I want to replay the bookings from the newer backup
05:45:54 <Hamaryns> ok, solved it, just replayed the logs and deleted doubles (which were added by automatic transactions)
05:46:01 *** Hamaryns has quit IRC
05:47:45 *** SteveG has quit IRC
06:18:22 *** Ardonik has joined #gnucash
06:45:33 *** StuM has quit IRC
07:07:08 *** Jimraehl1 has joined #gnucash
07:12:25 *** Jimraehl1 has quit IRC
08:07:37 *** fell has quit IRC
08:07:37 *** hampton has quit IRC
08:07:37 *** soa2ii has quit IRC
08:07:37 *** linas has quit IRC
08:07:37 *** blathijs has quit IRC
08:07:37 *** gjanssens has quit IRC
08:07:37 *** mikee has quit IRC
08:07:37 *** trams has quit IRC
08:07:37 *** warlord has quit IRC
08:07:37 *** kim27 has quit IRC
08:13:15 *** fell has joined #gnucash
08:13:15 *** kim27 has joined #gnucash
08:13:15 *** SteveG has joined #gnucash
08:13:15 *** gjanssens has joined #gnucash
08:13:15 *** hampton has joined #gnucash
08:13:15 *** mikee has joined #gnucash
08:13:15 *** soa2ii has joined #gnucash
08:13:15 *** trams has joined #gnucash
08:13:15 *** linas has joined #gnucash
08:13:15 *** warlord has joined #gnucash
08:13:15 *** blathijs has joined #gnucash
08:13:15 *** irc.gimp.ca sets mode: +ooo fell mikee warlord
09:00:34 *** aqua___ has quit IRC
09:21:44 *** wol has joined #gnucash
09:27:31 <hampton> No need to patch rssh warlord, unless you're looking for a side project. My scripts are obsolete, unless there's something on the server other than the old svn repository that you want me to copy off site.
09:31:36 <warlord> hampton: Dunno -- did you want to sync mailman?
09:34:54 <hampton> Sure, I can. I've got plenty of disk space. It'll go on a server behind my home firewall so its not directly available from the internet, but could be used to restore from if there were ever a problem.
09:39:21 <warlord> So the question is whether I should go hack rssh to enable the --config option?
09:39:32 <warlord> (I wonder if you could send the --config option?)
09:46:05 <hampton> I've never worked with rssh before. I just installed it and looked at the man page, and the only option mentioned is -v.
09:46:41 <warlord> rssh is just a restricted shell. What I wonder is whether you could send the rsync --config option over the net?
09:47:21 *** SteveG has quit IRC
09:47:41 <hampton> Possibly. Got a command line you'd like me to try?
09:47:51 *** warlord sets mode: +o gncbot
09:47:58 <warlord> PM?
09:49:10 <warlord> But that doesn't work for me.
09:50:26 <warlord> I was maintaining our own restricted shell, cvssh, previously.. I decided to switch to rssh when I dropped svn.. But I might want to hack on this anyways.
09:51:43 <hampton> ok. let me know if you want me to try something.
09:52:52 <warlord> I dont think I'll have time to hack on rssh for a while.. :-/
09:53:33 <hampton> np. send me an email whenever.
09:58:05 <warlord> which is the best addy to use?
10:01:45 *** benoitg has joined #gnucash
10:03:41 *** gncbot sets mode: +o gjanssens
10:04:56 *** SteveG has joined #gnucash
10:13:40 *** ErKa has joined #gnucash
10:16:20 *** wol has quit IRC
11:16:47 *** SteveG has quit IRC
11:27:16 *** ErKa has quit IRC
12:06:58 *** aqua___ has joined #gnucash
12:15:19 *** GabrieleV has quit IRC
12:16:47 *** GabrieleV has joined #gnucash
12:29:14 *** ErKa has joined #gnucash
12:31:51 *** jralls has joined #gnucash
12:31:51 *** gncbot sets mode: +o jralls
13:11:59 *** jmd has joined #gnucash
13:22:50 *** Krzysiek_K has joined #gnucash
13:36:34 *** wol has joined #gnucash
14:01:45 <lmat> So, when I rewrite gnucash in c++, what should I keep in mind (to make it better than gnucash) ?
14:06:34 <warlord> lmat: that there are 30-50 man-years of work spent in GnuCash... so it might take you a while to do it all
14:08:19 *** Chris has joined #gnucash
14:09:39 <lmat> warlord: :) So there's nothing to improve ? Impressive!!
14:09:52 <lmat> warlord: I think doing it in an object-oriented language might shave off a bit of that dev time ;-)
14:10:09 <warlord> not starting from scratch.
14:10:36 <warlord> well, okay, maybe it will reduce the 30-50 down to 10-30.. Still....
14:10:44 <lmat> ^_^
14:10:51 <warlord> You're better off making incremental improvements to the current impl instead of starting over
14:11:06 <Chris> Hey there, using 2.4.15, made a bill for a vender, bill has a negative entry (don't think it should matter). Try to post bill, have to make a currency exchange, but the amount nunder basic information is wrong. :/
14:11:06 <lmat> warlord: I hate OO C enough that it *really* puts me off.
14:13:32 <lmat> warlord: For instance, I would like to see the reports come along a lot.
14:14:16 <warlord> Chris: is the total bill negative? A negative entry is okay, but the total still must be positive.
14:14:36 <warlord> As for the currency exchange, is the bill supposed to be in a different currency?
14:15:14 <warlord> lmat: Yeah, gobject kinda sucks. And yes, it would be nice to migrate that to C++.. But note that I said "migrate" not "rewrite". As for reports, define "come along a lot"
14:16:10 <lmat> warlord: I'm not sure :) It feels like they're not very flexible.
14:16:21 <warlord> They are in scheme -- they are eminently flexible
14:16:25 <lmat> warlord: For instance, shaping elements on the report: controlling font size .
14:16:29 <lmat> warlord: Interesting..
14:16:50 <Chris> To total is still positive and the bill is charge to me in American but since I'm Canadian, I get to deal with Canadian funds.
14:16:59 <lmat> warlord: Maybe that's all...it just feels frustrating to use them, but I haven't put my finger on it.
14:17:07 <warlord> As for the display formatting --- gnucash has been slowly migrating to Webkit which will allow real CSS-based formatting/beautification..
14:17:10 <Chris> http://i.imgur.com/AqI4SeZ.png is an image of what I'm dealing with.
14:17:22 *** rpg has joined #gnucash
14:17:31 <lmat> warlord: Interesting. I'll stay tuned :)
14:17:40 *** Krzysiek_K has left #gnucash
14:17:57 <lmat> Chris: Hey, you use Windows 8?
14:17:58 <Chris> The bill totals to 18.08 in USD, I want to post and charge it to a cc liability but it doesn't use the correct basic amount :/
14:18:07 <lmat> Chris: How do I close a full-screen program (like majong) ?
14:18:47 <Chris> probably a swip from the left and drag to bottom motion if you have a touch screen
14:18:55 <Chris> otherwise I think you'd use a similar action with a mouse
14:19:15 <Chris> swipe*
14:19:19 <warlord> Chris: I've never used the multi-currency business features so I'm afraid I don't know why it's not working. Maybe gjanssens has an insight.
14:19:38 <warlord> lmat: try thinking about it first and then when you put your finger on it let's talk again. :)
14:20:51 <Chris> Hmm, ok, I will stick around and see if I can get some insight. It does appear to be stuck on a value that the previous bill amount was though.
14:24:57 <gjanssens> Chris: I wonder where the 41.81 comes from
14:25:40 <gjanssens> The accounts used in the entries are all in canadian $ ? And you post to a USD account ?
14:27:00 <Chris> The expense account is in Can (I wouldn't have a problem switching it to USD) but the bill is charged in USD and then I just pay the amount that shows up on my cc (which I use for the currency exchange) to pay the bill.
14:27:13 <lmat> Is there a way to do a report based on vendor ? For instance, how would I see all the money I spent at Target this year ?
14:27:17 <Chris> 41.81 was a total for a previous bill.
14:27:22 <Chris> one that I've posted and paid.
14:30:46 <gjanssens> Hmm, you're in 2.4...
14:30:49 <gjanssens> *pondering*
14:31:06 <Chris> Yeah, 2.6.2 was giving me crashing issues when selecting tax tables.
14:31:25 <gjanssens> It's possible that in that version the exchange dialog didn't show actual values
14:31:37 <gjanssens> But rather an exchange rate
14:31:59 <gjanssens> What happens if you just fix the exchange rate an post the invoice ?
14:32:09 <gjanssens> Ignoring the totals that are being displayed ?
14:32:20 <Chris> I'll try that, give me a moment
14:32:29 <gjanssens> Have you reported the tax table crashes btw ?
14:32:44 <gjanssens> Sounds like a regression we should look into
14:34:57 <Chris> I had talked to warlord about it last time (not sure if they remember) but I wasn't able to gather any information about it without doing a stacktrace (which I looked into, and didn't have time for in windows 8 [add windows hatred here])
14:38:37 <Chris> Hmmm, appears that you're correct in that it's more concerned with the exchance rate. I entered the rate and it did calculate it correctly.
14:44:21 <gjanssens> Good
14:48:05 <gjanssens> I have to go now...
14:49:21 *** SteveG has joined #gnucash
14:49:57 *** Ahmuck has joined #gnucash
14:50:13 <Ahmuck> hi. i could use some help with splits
14:50:29 <warlord> Ahmuck: have you read the fine manual?
14:50:39 <Ahmuck> i've read the d* manual, yes
14:51:18 *** gjanssens has quit IRC
14:51:23 <Ahmuck> the manual does not cover the issues i am having. splits not totalling correctly, etc.
14:51:33 <Ahmuck> i
14:52:14 <Ahmuck> warlord: i've even done the example correctly from the manual, from you tube, etc. but it will not work correctly for splits entered in after the transaction
14:53:43 <Ahmuck> http://www.youtube.com/watch?v=_l9sxlfF9Fw
14:53:48 <Ahmuck> that example
14:54:08 <Ahmuck> http://www.gnucash.org/docs/v2.6/C/gnucash-help/trans-multi-enter.html
14:54:10 <Ahmuck> that one
14:54:24 <Ahmuck> http://gnucash.org/docs/v2.4/C/gnucash-guide/txns-registers1.html
14:54:25 <Ahmuck> that one
14:55:48 *** wol has quit IRC
14:56:00 *** wol has joined #gnucash
14:56:03 <Chris> What isn't totaling?
14:56:24 <Chris> Ahmuck: what isn't totaling? *
14:56:36 *** wol has quit IRC
14:56:43 <Ahmuck> http://gnucash.1415818.n4.nabble.com/Split-transactions-are-killing-me-td4659060.html
14:56:44 <Ahmuck> this one
14:56:48 <Ahmuck> i've got more
14:56:54 <Ahmuck> let me start posting more
14:57:09 <Ahmuck> Chris: i've entered my bank statements in
14:57:27 <Ahmuck> now i'm working through reciepts matching to those accounts in the bank statement
14:57:42 <Ahmuck> some reciepts need to be split into different categories for tax and tracking purposes
14:57:50 <Ahmuck> for exmaple, moving, job searches, etc.
14:57:56 <Ahmuck> education, etc.
14:58:32 <Ahmuck> so, i find the transaction, click on the split transaction button to split the transaction into different categories
14:58:38 <Ahmuck> then all h* breaks loose
14:59:53 <Chris> Is the split not balancing?
15:01:51 <Chris> God, I'm just a noobie at irc sometimes.
15:02:01 <Chris> Ahmuck: Is the split not balancing?\
15:02:04 <Ahmuck> it's not only not balancing but it's not showing the true amount of the charge when complete.
15:02:21 <Chris> Hmmm
15:02:32 <Ahmuck> for example, let's say i split a 357.00 charge, when it's done it's showing the charge as 210.00
15:02:52 <Ahmuck> i don't understand if it's what i am doing or if it's a bug
15:03:02 <Ahmuck> and i've been fighting this for about three years ... heh heh
15:04:32 <Chris> oh boy, longer than I've been using gnucash. I'm fairly new to it, but it sounded like something I was doing earlier when I first used gnucash so I thought I'd chime in. I was spliting transactions and just not widthdrawing amounts from accounts properly causing imbalances.
15:04:41 <Chris> But it sounds like you'd had this going longer than I have.
15:05:47 <jmd> I also find the user interface for splits confusing.
15:06:11 <Chris> I'd agree to that, but I'm no financial professional xP
15:06:54 <jmd> I'm not either. That's why I am qualified to offer an opinion on the user interface.
15:06:55 <Chris> I've got to hop away though, best of luck Ahmuck
15:07:11 *** wol has joined #gnucash
15:07:41 *** benbergman has quit IRC
15:26:20 *** Ahmuck has quit IRC
15:28:36 *** jralls has quit IRC
15:37:15 *** fell_ has joined #gnucash
15:37:15 *** gncbot sets mode: +o fell_
15:37:49 *** Ahmuck has joined #gnucash
15:42:08 *** wol has quit IRC
15:43:48 <warlord> Splits are easy.. There are a couple rules: 1) never finsh the txn until you're done. This means never hitting "Enter". 2) GnuCash will always sum up the remainder into the blank split. 3) You need to start witj the split into the current (register) account, or the txn will disappear.
15:44:14 <warlord> Ahmuck: if the transaction isn't adding up: are you doing multiple currencies, and do you have trading accounts turned on?
15:46:53 *** fell has quit IRC
15:46:55 <Ahmuck> warlord, the transaction has already been entered before the split
15:47:16 <Ahmuck> for example, i can import qif, csv, etc files into gnucash with all the proper information
15:47:27 <warlord> Okay...
15:47:28 <Ahmuck> directly into "checking account"
15:47:43 <warlord> Okay, and during the import you properly assign it to the proper Expense account, right?
15:48:17 <Ahmuck> initially it's assigned to no account. for example, a grocery purchase has "imbalance" etc.
15:48:30 <Ahmuck> but just as important, i have accounts which i merely enter in
15:48:46 <Ahmuck> then i need to take the reciept at the end of the month/year and split it out
15:49:20 <Ahmuck> so ... 20140301 5643 SomeStore 145.26
15:49:37 <Ahmuck> this transaction has been entered on 01
15:49:42 <Ahmuck> or somewhere thereabout
15:50:48 *** jmd has quit IRC
15:51:30 <warlord> Ahmuck: first, if you have transactions into Imablance you're doing double-entry wrong.
15:52:04 <warlord> Having said that... Lets say you have a txn from Checking -> Imbalance for 145.26 and you want to split that into groceries, clothes, and home goods.
15:52:17 <warlord> Open your checking account, go to that txn, click "Split" to expand it.
15:52:51 <warlord> Then go to the Imbalance line and change the account to Expenses:Groceries. Tab over to the amount and change it to, e.g. 46.23
15:53:17 <warlord> Then tab off the end of the line and it will create a new empty split with 99.03 in it.
15:53:22 <warlord> Keep doing that until you're done.
15:53:42 <warlord> ... putting an account in, setting the correct amount, and tabbing off the end.
15:53:51 <warlord> When you're done, and only when you're done, hit "enter" to commit it all.
15:54:00 <warlord> (sorry, have to disappear again for ~15mins)
15:54:15 <Ahmuck> ok. i'm going to create a test account and add some entries. when i've tried it in past years it really messes things up and then i have to dump the whole project file
15:58:20 *** MechtiIde has joined #gnucash
16:07:13 <Ahmuck> ya, crazy stupid is what it does
16:07:24 <Ahmuck> it dumps the amount that i assign to each account
16:07:29 <Ahmuck> as i progress down the split
16:08:51 *** jmd has joined #gnucash
16:09:59 <warlord> What do you mean "dumps the amount"?
16:10:05 <Ahmuck> i'm going to do a record my desktop
16:10:09 <warlord> Maybe you can post some screen shots?
16:10:12 <Ahmuck> i think a visual record would be better
16:10:15 <warlord> Okay..
16:10:51 *** jmd has quit IRC
16:15:54 <warlord> are you using accounts of different currencies?
16:24:43 *** jralls has joined #gnucash
16:24:43 *** gncbot sets mode: +o jralls
16:28:02 <Ahmuck> no
16:28:11 <Ahmuck> entered transaction
16:28:21 <Ahmuck> assign imbalance to account
16:28:28 <Ahmuck> open split
16:28:56 <Ahmuck> enter amount for account of first split
16:30:02 <warlord> wait, I'm already confused.. What do you mean by "entered transaction" and then "assign imbalance to account" and "open split"?
16:30:21 *** wol has joined #gnucash
16:31:20 <warlord> Note that I said that you should click on the 'split' to expand the txn before you start making any changes to it.
16:31:57 <Ahmuck> warlord the transaction has already been entered. many of them. the whole month
16:32:09 <warlord> okay..
16:32:25 <warlord> and you didn't properly assign accounts during the import?
16:32:27 <warlord> ;)
16:32:38 <Ahmuck> during input
16:32:39 <warlord> (yes, I'm harping on that, because it will save you significant time doing it)
16:32:49 <Ahmuck> input all the transactions, assign accounts later
16:33:06 <warlord> Okay, if you really want to make more work for yourself...
16:33:25 <warlord> anyways....
16:33:32 <warlord> back to splits.
16:39:32 <warlord> Just talk me through one line and what you do during splits and how it appears to be misbehaving (i.e., what does it do, what did you expect it to do)?
16:39:43 <Ahmuck> bbiam
16:39:50 <Ahmuck> on the phone
16:40:50 <warlord> k
16:40:58 <warlord> (I guess I have two times AFK)
16:44:01 <Ahmuck> ok, back
16:44:08 <Ahmuck> i've got a video, need a place to upload
16:44:54 <Ahmuck> ftp site somewhere?
16:46:53 <warlord> uhh... dont know if imagebin allows videos.
16:48:17 <Ahmuck> videobin :)
16:48:22 <Ahmuck> in a minute
16:48:51 <warlord> k
16:48:54 *** SteveG has quit IRC
16:49:23 <Ahmuck> http://videobin.org/+7ku/9y0.html
16:49:50 <Ahmuck> http://videobin.org/+7ku/9y0.ogg
16:54:30 <warlord> AHA!!! I already see your mistake! You changed the BANK account!
16:55:01 <warlord> Please go and re-read the Docs on Split Transactions.
16:55:14 <warlord> You clearly missed some key points on Debits and Credits and double-entry.
16:55:27 <Ahmuck> i changed the bank account?
16:58:06 <warlord> Yes, you did.
16:58:23 <warlord> When you first expand the transaction there are two splits... The Bank split and the Imbalance split.
16:58:31 <warlord> You changed both.
16:59:31 <Ahmuck> show me?
16:59:47 <Ahmuck> i only see the imbalance split
16:59:50 <Ahmuck> which i corrected
16:59:55 <Ahmuck> and began splitting
17:00:14 <Ahmuck> there was a withdrawal on the other side until the second split
17:00:23 <Ahmuck> recording the split makes it disappear completly
17:02:37 <warlord> Around second :34 in the video, you change your Checking Account split.
17:03:34 *** rpg has quit IRC
17:04:51 <Ahmuck> yes, i put another transaction split there. i assume that is how you add additional splits?
17:04:53 <Ahmuck> no?
17:05:01 <Ahmuck> use the split button again?
17:05:55 <warlord> Yes, but you don't change the split tied to the current account!
17:06:17 <warlord> Think about what the transaction is...
17:06:34 <warlord> You spent $156.23 from your Checking account on Clothes, Food, and Home Goods..
17:06:57 <warlord> Therefore, you need to Credit Checking $156.23, and then Debit Clothes, Food, and Home Goods the splits that total 156.23
17:07:13 <warlord> Please go re-read the docs.. you clearly missed something.
17:07:37 <Ahmuck> huh, i'm in the checking account account
17:07:47 <Ahmuck> how does one credit an account they are already in?
17:08:04 <Ahmuck> it's like getting a double paycheck, or paying oneself twice, no?
17:08:15 *** jmd has joined #gnucash
17:08:20 <Ahmuck> i've been over those docs mutilple times in teh last three years
17:08:24 <Ahmuck> actually since 2008
17:11:32 <Ahmuck> bbl, maybe
17:13:02 *** SteveG has joined #gnucash
17:13:37 <warlord> No...
17:14:16 <warlord> With what you're doing, just don't touch the split that's attached to the current account. I don't know how to be more clear. Don't touch the checking account split.
17:14:35 <warlord> Change the Imbalance split, and then go and add your new splits. But don't touch the checking account split.
17:32:34 *** hampton has left #gnucash
17:33:46 *** MechtiIde has quit IRC
17:48:45 *** wol has quit IRC
18:01:55 *** jmd has quit IRC
19:15:05 *** StuM has joined #gnucash
19:15:58 *** SteveG has quit IRC
19:21:31 *** StuM has quit IRC
19:22:43 *** StuM has joined #gnucash
19:23:23 *** benoitg has quit IRC
19:43:50 *** ErKa has quit IRC
19:44:55 *** SteveG has joined #gnucash
20:06:05 <Ahmuck> warlord: still there?
20:12:46 *** amjam has joined #gnucash
20:14:07 <warlord> yeah
20:14:07 <amjam> hi all. huge request: can someone walk me through setting up one month of transactions in gnucash? I've read the tutorial on the webpage several times but I still have no idea what I'm doing. I've never done any sort of accounting before and am just trying to learn this all for myself. I looked through the old e-mails in the mailing-list but couldn't find someone in a similar position -- everyone seems to already have some knowledge of a
20:14:17 <amjam> But please point me to an e-mail in the mailing list if this is not the case.
20:14:49 <warlord> amjam: your message ended at " everyone seems to already have some knowledge of a"
20:15:20 <warlord> amjam: I recommend you go to http://www.gnucash.org and click on "documentation" and then read the Tutorial/Guide
20:16:07 <amjam> everyon seems to already have some knowledge of accounting.* EOM.
20:16:22 <amjam> warlord: I have read it twice, in fact.
20:17:49 <amjam> I read up to chapter 7 as I don't need to know about investments, capital gains, etc. right now.
20:18:13 <amjam> all I have is a job. and I just want to begin basic accounting habits.
20:19:01 <warlord> amjam: okay, so what exactly is your question that wasn't answered by the tutorial (did you go through and try to follow the examples in the tutorial?)
20:19:50 <warlord> Ahmuck: yes, i'm here
20:19:51 *** fell_ has quit IRC
20:20:59 <amjam> Yes. I did read through the examples in the tutorial. What I am trying to do is import my checking account transactions (.ofx) and savings account transactions (.ofx) and then reconcile everything for one month.
20:21:07 <amjam> I have successfully imported those files.
20:21:28 <warlord> Did you assign the proper expense category accounts for each transaction during import?
20:21:29 <amjam> However, I have hundreds of "Imbalance-USD" listed in the Transfer column.
20:22:00 <amjam> And I am having some trouble editing the split for my income (so that it breaks my paycheck apart for taxes, etc.)
20:24:30 <warlord> amjam: those "Imbalance" listings are because you didn't properly assign the expense category accounts during your import.
20:24:51 <amjam> Is there something that I needed to do prior to importing?
20:24:59 <warlord> During the ofx import you should go down the right side of the matcher window, double click and assign accounts to each transaction.
20:26:28 <amjam> How do I delete a line in an account?
20:26:34 <amjam> (I'm using Mac OS X if that matters)
20:26:56 <warlord> as for splits ... Ahmuck is having similar issues. The way to deal with splits is to take the existing transaction from your bank account register, click on the split button to expand it, then modify the current expense split line (amount and, if necessary, account), and then *TAB* to the newly-created blank split and keep adding new ones.
20:27:19 <warlord> What do you mean "delete a line in an account"? You want to delete a transaction? Click on the "Delete Transaction" button on the toolbar.
20:27:58 <amjam> ok perfect.
20:28:11 <amjam> let me try to import these .ofx files again. I don't recall any matcher window.
20:29:09 <warlord> Note that you will need to delete all the transactions before you import them, otherwise the importer will ignore them.
20:30:31 <amjam> Yes. I just went ahead and deleted everything.
20:33:26 <amjam> Ok. Let's try this one more time.
20:36:03 <amjam> OK
20:36:26 <amjam> so when I import the .ofx file two windows pop-up. One is the "Select Account" window and another is "Generic import transaction matcher"
20:36:48 <amjam> Does it matter which one I address first? (It looks like the Generic import transaction matcher is completely empty, by the way -- is this normal?)
20:37:09 <Ahmuck> amjam, i can help you with splits!
20:37:33 <Ahmuck> heh, contrary to advice, you do need to hit the enter key after the first split to enter another
20:37:40 <Ahmuck> @$*#@#$
20:37:40 <gncbot> Ahmuck: Error: "$*#@#$" is not a valid command.
20:38:30 <amjam> oh okay. So I selected the appropriate account, and now my Generic Import Transaction Matcher is populated.
20:38:33 <amjam> wee!
20:38:51 <amjam> Am I supposed to do something important now? Or just hit "OK"?
20:40:10 <warlord> Ahmuck: no, you don't want to hit enter, otherwise it will assign the blank split to Imabalance
20:40:30 <Ahmuck> yes, you do
20:40:32 <warlord> You just need to tab off the end of the line (and then, possibly, tab off the next line too)
20:40:34 <warlord> No you dont
20:40:36 <Ahmuck> that is the only way it worked
20:40:40 <Ahmuck> yes you do
20:40:58 <Ahmuck> tab off the end of the line produces the result i posted on video
20:41:10 <Ahmuck> it won't create a new line for a new split for me
20:41:32 <amjam> just keep hitting tab.
20:41:36 <Ahmuck> in fact, imho the documentation needs to be re-written to say
20:41:46 <Ahmuck> btw, it's on item 13
20:41:47 <warlord> Ahmuck: No, you dont. I just tried it
20:42:08 <Ahmuck> http://www.gnucash.org/docs/v2.6/C/gnucash-help/trans-multi-enter.html
20:42:09 <warlord> Tabbing off the line works just fine and takes you to the next line just fine.
20:42:11 <Ahmuck> line 13
20:42:17 <Ahmuck> new line requires the enter key
20:42:26 <Ahmuck> tabbing does not work
20:42:29 <Ahmuck> yes you do
20:42:38 <warlord> Ahmuck: yes, it does.. I WROTE THE DAMN CODE!
20:42:43 <Ahmuck> er, item 13
20:42:47 <amjam> warlord: lol.
20:42:59 <amjam> warlord: offtopic -- which Scheme does gnucash use? Chicken? Racket?
20:43:03 <Ahmuck> no it doesn't if it did i wouldn't be messing with gnucash for 6 years
20:43:05 <warlord> amjam: guile
20:43:15 <Ahmuck> chicken
20:43:23 <warlord> Ahmuck: IT DAMN WELL DOES WORK.. I JUST F*****G DID IT
20:43:32 <amjam> omg lol.
20:43:44 <Ahmuck> YEA, AND I JUST TRIED IT FOR X YEARS AND IT DIDN'T
20:43:45 <warlord> I just tried it here, and tabbing F*****G works fine.
20:43:54 <Ahmuck> maybe you have extra special code
20:43:56 <warlord> I don't know WTF you're doing wrong, but it's you, not GnuCash
20:44:08 <Ahmuck> i'm practically perfect
20:44:14 <Ahmuck> it's not me
20:44:33 <warlord> It is, because you're the only person I know of for whom TAB doesn't work.
20:44:36 <Ahmuck> we done?
20:44:42 <warlord> Like I said, I just did it, and it works fine for me.
20:44:45 <Ahmuck> well i'm special i guess
20:44:52 <jralls> Ahmuck, you're a troll. Get lost. Now.
20:44:58 <Ahmuck> i'm not
20:45:03 <Ahmuck> i'm stating the obvious
20:45:17 <Ahmuck> btw, now that you mention it, i am using us keyboard international
20:45:29 <Ahmuck> rather than a vanilla us keyboard
20:45:37 <warlord> AHA... The plot thickens...
20:45:44 <warlord> Perhaps your TAB keytab isn't a TAB
20:45:44 <jralls> The obvious is that you're a troll. There are literally tens of thousands of GnuCash users for whom tabbing works fine. Now get lost before I kick you.
20:46:11 <Ahmuck> i'm ok with getting kicked.
20:46:59 <warlord> amjam: anyways, back to you... If the importer doesn't show anything on the second screen that means the importer thinks there are no "new" transactions to import. If you're really just starting from scratch you may want to literally do that -- delete your data file and start over.
20:46:59 <jralls> Bye-bye, then.
20:47:07 *** jralls sets mode: +b *!*@208.4.188.191
20:47:07 *** Ahmuck was kicked by jralls (jralls)
20:47:19 *** ErKa has joined #gnucash
20:47:26 * warlord sighs
20:47:36 <warlord> he'd been so reasonable for the past day...
20:47:47 <amjam> warlord: i actually got that window to populate
20:48:01 <amjam> what I hadn't done before is double-click on each of the transactions to select an account to send the expense to
20:48:16 <amjam> do I have to do this EVERY time I import an .ofx file or will it remember my past decisions?
20:48:22 <warlord> yeah... Unfortunately that isn't as obvious a thing to do... and the importer doesn't warn you when you haven't done it.
20:48:56 <warlord> Well...... it will remember them in *some* cases... I don't recall when. Proabbly full-desc match.
20:48:56 <amjam> Like right now I am trying to find an account to bucket my POS Transaction at 7-ELEVEN.
20:49:06 <amjam> (which, funnily enough, i'm having a hard time with... )
20:49:59 <amjam> so it is possible that every month I will have to go through and bucket 7-ELEVEN transactions to the appropriate expense account?
20:51:44 *** himaxx has joined #gnucash
20:52:08 <jralls> If the transaction's description is exactly the same, it will remember from month to month. If the transaction has *similar* descriptions, then turn on "bayesian matching" in preferences. It will take a few months to train, and then it will remember.
20:52:19 *** himaxx has quit IRC
20:52:39 <amjam> jralls: this is actually a really interesting problem.
20:53:14 <amjam> suppose I go to Best Buy and purchase a computer. and then next month I go to Best Buy and purchase a refrigerator. And then the mo nth after that I quickly run into Best Buy to buy a candybar at their check-out counters.
20:53:55 <amjam> What you're saying is there is no way for GnuCash to understand that these three purchases should go to different expense accounts.
20:54:07 <amjam> (I'm assuming this is because that information is not contained in the .ofx file in the first place?)
20:55:29 <jralls> That's right. OFX doesn't have any indication of the other account. QIF does, but none of my credit card companies fill it in. So all GnuCash has to go on is what winds up in the description field.
20:56:15 <amjam> Aha! My Credit Union allows me to export a .qif. Let me try that!
20:56:41 <amjam> ah crap. no it doesn't. only .CSV and .QFX.
20:56:43 <jralls> So if you use bayesian matching, and over several months tell GC that txns that say "Best Buy" go in different accounts, then Best Buy will always show up yellow in the matching window for you to bin by hand.
20:56:45 <amjam> er, and OFX.
20:56:56 <amjam> .csv, .ofx, and .qfx are my only options.
20:57:18 <jralls> QFX and OFX are the same. The former is Quicken, the latter M$ Money.
20:57:58 <amjam> Should i turn on bayesian matching before I go through the generic import transaction matcher?
20:58:05 <jralls> Anyway, your Credit Union probably doesn't know what you bought at Best Buy either.
20:58:47 <warlord> amjam: you need to decide whether the descriptions will change month to month.
20:58:49 <jralls> If you want to use it, yes. It collects its data from the import window, so if it's off it doesn't collect any data.
20:58:56 <warlord> for example, if there is a txnid in there, then yes, you want it
20:59:55 <amjam> OK, so for the vast majority of transactions, I want GnuCash to automatically figure out what Expense Account it should go to. There are a handful that I can see some issues with. Whatever GnuCash "auto-completes" for me, I can still edit before it gets pushed through, right?
21:00:15 <amjam> whats the significance of a transaction id?
21:00:17 <warlord> Yes.
21:00:52 <jralls> Yes. It's a good idea to check the assignments in the window before hitting OK. You can always double-click the line to change the assignment.
21:00:52 <warlord> amjam: what I mean is that some banks have transaction descriptons that look like: FOOSTORE 123456787 (where the numbers change for every txn)
21:01:29 <amjam> I think I have that.
21:01:52 <amjam> when looking through the .csv file I see a "Transaction Number"
21:02:22 <amjam> that does change with every transaction, even for the same store.
21:02:32 *** xi_ has joined #gnucash
21:02:38 *** ErKa has quit IRC
21:02:56 <amjam> How does that help, though?
21:03:02 <warlord> amjam: then you'll want bayesian matching
21:03:27 <warlord> because that way it will always notice "FOOSTORE" goes to Expenses:something (and will learn to ignore the numbers)
21:04:20 <amjam> How do I turn on Bayesian Matching?
21:04:30 <amjam> I tried searching for "bayesian" in the help but it didn't find anything.
21:05:40 <warlord> Edit -> Preferences -> Online Banking (IIRC)
21:07:53 <amjam> what the heck. I have to find my Bank Code and all that?
21:08:07 <warlord> ??
21:08:10 <warlord> you shouldn't need that
21:08:14 <amjam> I'm doing some Online Banking Wizard.
21:08:55 <amjam> I think I was doing something else. It looks like bayesian matching was the default.
21:09:00 <amjam> So it was already selected.
21:09:03 <amjam> Cool.
21:10:11 <warlord> Good
21:10:38 <amjam> This is such a dumb question: but what expense account do you all use for things like coffee or quick snacks from 7-11?
21:12:31 <jralls> Depends on whether you want to keep them separate or not. You could have Expenses:Snacks or you could lump it together with all of the other minor things in Expenses:Miscellaneous.
21:14:53 <warlord> amjam: it's up to you. I'd probably use Expenses:Dining or Expenses:Groceries, depending.
21:15:58 <amjam> how difficult would it be to change this later on?
21:16:29 <warlord> The importer will just need to be retrained.. But for existing transactions you can easily change them, but only one-at-a-time.
21:16:43 <amjam> ok.
21:17:15 *** SteveG has quit IRC
21:17:22 <jralls> Time for dinner. G'night.
21:17:29 *** jralls is now known as jralls_afk
21:20:18 <amjam> warlord: okay, last question I hope
21:20:28 <amjam> while going through my transactions, I've hit upon my paycheck.
21:20:45 <amjam> However, its asking me to select an account to bucket this to. Do I just split this apart later or can I do it now?
21:20:55 <warlord> see ya jralls_afk
21:21:18 <warlord> You cannot split it in the importer -- you will have to do that later.
21:29:28 <amjam> My God... I have to stop eating so much.
21:32:47 <amjam> I wish this information came also with the *time* these transactions happened.
21:37:28 <warlord> Time of day?
21:37:29 *** jralls_afk has quit IRC
21:42:57 <amjam> warlord: yes.
21:43:50 <amjam> There needs to be accounting software made specifically for alcoholic 20-something bachelors like myself.
21:44:15 <amjam> An expense at a supermarket? That's groceries right? Except its at 1:30am and I only spend $10. That's not groceries. Thats beer.
21:44:35 <amjam> Also, along with the date, the day of the week would also help with that.
21:44:42 <amjam> "yeah... that was a good Friday."
21:44:48 <warlord> Then expenses:alcohol
21:44:55 <warlord> Anyways, I'm off. TTYL.
21:45:04 <amjam> thanks for your help with everything.
22:28:37 <amjam> In the Generic Import Transaction Matcher
22:28:48 <amjam> does do the columns 'A', 'U+R', and 'R' represent?
22:32:29 <amjam> does this 'R' mean Reconciled like in the other windows?
22:46:32 *** benoitg has joined #gnucash
23:45:21 *** amjam has quit IRC