2014-01-03 GnuCash IRC logs
00:53:36 *** MacCoaster has joined #gnucash
00:56:23 <MacCoaster> hi, when I add an account under my brokerage account for an ETF (using stock type), i go in to fill in the name, set up new security, and hit OK, but it does not show up in the main accounts tab, but it does show up in the account tree in the new account/edit account window for another account
00:56:26 <MacCoaster> am i doing something wrong?
01:05:41 *** jmd has joined #gnucash
01:17:40 *** jmd has quit IRC
01:35:13 *** uXus has quit IRC
01:39:03 <fell> MacCoaster: There are 2 steps: define a commodity & create an account for it.
01:39:35 <MacCoaster> yeah that's what i did, the commodity shows up, but the account doesn't on the main accounts tab
01:45:07 <fell> I start with dialog New Account - Assets:Investments:<No name>
01:46:43 <fell> Type:Stock; Select security pops up
01:47:32 <fell> click New; New Security pops up
01:49:37 <fell> After filling that and pressing OK, it is selectet in Select Security; press OK again.
01:50:27 <fell> Fill New Account dialog & prress OK again.
01:51:02 <MacCoaster> thats that's pretty much exactly what i did
01:51:18 <MacCoaster> let me upgrade gnucash first
01:51:51 <fell> (without marking it as hidden) ;-)
01:52:16 <MacCoaster> huh, I didn't see the hidden checkbox
01:53:06 <MacCoaster> ugh that might be it.
01:53:15 <fell> The COA might show >Investments, then you should click on ">"
01:53:49 <fell> to see the accounts below it.
01:54:46 <MacCoaster> is there a way to make it unhidden? i dont see it at all when i expand evrything
01:55:09 <MacCoaster> aha
01:55:17 <MacCoaster> found where to view hidden accounts
01:55:22 <MacCoaster> that was it. major derp. >_<
01:55:47 <fell> View->Filter by->Other: show hidden
01:55:57 <MacCoaster> yep.
01:57:10 <MacCoaster> is there a reason why net assets shows up as negative as though it doesnt count the investment in $ value?
01:57:30 <fell> Edit it again and remove the checkmark
01:57:53 <MacCoaster> yeah it's unhidden now
01:59:34 <fell> Sorry, then you should declare bancrupcy.
02:00:30 <fell> Probably you entered something in the wrong column.
02:00:48 <MacCoaster> heh
02:01:50 <MacCoaster> i have x shares, for y price, under buy i put in x * y, for the account, then for sell, i put in the x * y as well from opening balances
02:02:02 <MacCoaster> it looks right from what i can tell
02:02:24 <MacCoaster> but the parent account shows $0
02:02:46 <MacCoaster> shouldnt a placeholder compute value from all its children?
02:04:34 <fell> In the COA right up is an down Arrow. there you can select different columns to show.
02:06:09 *** kpreid has quit IRC
02:06:27 <MacCoaster> yeah even for Total (USD) it still shows $0 for some reason
02:06:47 *** kpreid has joined #gnucash
02:06:53 <MacCoaster> maybe the commodity was set up wrong
02:07:24 <fell> shows Tools->commodity some quotes?
02:08:33 <MacCoaster> aha bingo
02:08:42 <MacCoaster> price editor didnt have any prices initially
02:10:43 <fell> Open your ETF account and reenter your initial buy. Then it should get the price.
02:11:08 <MacCoaster> yeah
02:11:18 <MacCoaster> I think I got the hang of this.
02:12:23 <MacCoaster> thanks fell for pointing me in the right directions! appreciate it!
02:12:50 <fell> Welcome, MacCoaster.
02:20:27 *** john has joined #gnucash
02:20:28 *** gncbot sets mode: +o john
02:27:51 *** uXus has joined #gnucash
02:47:27 *** fell has quit IRC
02:59:05 *** Krzysiek_K has quit IRC
02:59:35 *** Krzysiek_K has joined #gnucash
03:05:29 *** fell has joined #gnucash
03:05:29 *** gncbot sets mode: +o fell
03:10:39 *** uXus has quit IRC
04:09:39 *** john has quit IRC
04:11:40 *** aqua___ has joined #gnucash
04:19:06 *** uXus has joined #gnucash
04:27:55 *** aqua___ has quit IRC
04:44:22 *** TradeBorG113 has joined #gnucash
04:56:07 *** gncbot has joined #gnucash
04:59:14 *** aqua___ has joined #gnucash
05:27:48 *** mikee sets mode: +o gncbot
05:28:22 *** mikee sets mode: +o warlord
05:32:32 *** aqua___ has quit IRC
06:03:03 *** Krzysiek_K has left #gnucash
06:47:34 *** Krzysiek_K has joined #gnucash
06:56:42 *** Jimraehl has joined #gnucash
07:02:03 *** Jimraehl has quit IRC
07:17:11 *** StuM has quit IRC
07:17:53 *** StuM has joined #gnucash
07:20:18 *** Krzysiek_K has quit IRC
07:20:43 *** Krzysiek_K has joined #gnucash
07:34:25 *** Krzysiek_K has quit IRC
07:34:48 *** Krzysiek_K has joined #gnucash
07:45:07 *** Krzysiek_K has quit IRC
08:01:51 *** Bodhi-Baum has joined #gnucash
08:35:57 *** Bodhi-Baum has quit IRC
08:48:47 *** jeeger has joined #gnucash
08:50:36 <jeeger> Hello! I'm running gnucash, and retrieving my transactions over HBCI. However, my total in gnucash is short by about 13€ from the total shown on the online banking page, and I can't for the life of me figure out why that would be. Is there an easy way to find transactions that weren't added from HBCI? I probably manually added an erroneous transaction to the account.
09:20:26 <warlord> jeeger: Do you go through the reconcile process? If so you can view unreconciled tranasctions via View -> Filter By...
09:23:02 <jeeger> warlord: Yeah, that's what I did later. Found a duplicate transaction. I'm still 2 € off, but I can't be bothered to search for the difference any longer.
09:23:45 <warlord> This is why regular reconciliation is a good thing
09:25:50 <jeeger> warlord: Hm, yeah, I'm just doing monthly "checking that the account totals are the same".
09:25:57 <jeeger> I should start doing reconciliation.
09:29:03 <warlord> Yes, you should. ;)
09:29:16 <warlord> It will also help prevent accidental changes.
09:38:06 <jeeger> Yeah, I never bothered to properly read up on accounting, so I'm still discovering things as I go.
09:44:43 <warlord> There are lots of good resources out there.
09:45:24 <jeeger> Hm, I tried reading the Gnucash manual, but it seems a bit disjointed to learn basic accounting from.
09:45:49 <jeeger> I'd be interested in a "workflow"-like description of how to work with gnucash.
09:49:37 <warlord> Are you reading the Tutorial Guide or the Help Manual?
09:50:46 <jeeger> I think it was the help manual
09:51:39 <warlord> Right, that's targetted to "what does this button do". Read the Tutorial/Guide
09:54:22 *** Sanuj has joined #gnucash
09:55:40 <jeeger> The tutorial and concepts guide? Hm, yeah, I think I started reading it, and got kind of lost with the terms (English isn't my native language).
09:56:05 <jeeger> Meh, I'll have another stab at it.
09:58:15 <warlord> Good luck.
09:58:21 <warlord> There may be translations in a few other languages.
10:00:49 <jeeger> Thanks for your help!
10:01:24 <warlord> fell: are you locked out of code right now?
10:01:31 <warlord> jeeger: you're welcome
10:03:42 <fell> warlord: Yes, in the morning I was. But after I reconnected to the internet I got another IP. :P
10:05:35 <warlord> fell: LOL
10:06:03 <warlord> Once I swap to the new server I plan to switch to fail2ban, which will cause the blocks to time out after a while..
10:06:49 <fell> But I don't know, why I was locked. Did I sleep to long?
10:10:15 *** Sanuj has quit IRC
10:10:54 <fell> BTW: If you set up the new server, can logs get the structure YYYY/MM/DD back instead of YYYY/MM/YYYY-MM-DD?
10:13:27 <warlord> I will see what I can do about that.
10:13:53 *** Sanuj has joined #gnucash
10:13:56 <warlord> Migrating code is going to take a lot more time than migrating my personal mail/jabber server.. And *THAT* took me two weeks..
10:14:25 <Sanuj> Hello. I'm new to gnucash. I'm having a problem with displaying some of the foreign currencies. I live in Oman and want to use Omani rial but gnucash displays a weird currency symbol on reports and such. I noticed that in the previous version it was displayed correctly as OMR. I'm not sure if this is some problem with my system or problem with the new release. Thank you.
10:14:36 <warlord> fell: it looks like you tried to login with an illegal user.
10:14:51 <warlord> (or failed to login as 'git')
10:15:11 <warlord> Sanuj: what verson are you using?
10:15:35 <Sanuj> The latest 2.6.0
10:16:43 <warlord> Ah, okay... I believe that adds a new feature: user settable currency symbols. There should be a way to edit that under the Tools menu. (I don't have a 2.6 handy to look at the menu)
10:17:17 <warlord> It is possible that the default in there is wrong, or has the wrong encoding.. For example if you're not using a UTF-8 LANG it might be an encoding issue, theoretically.
10:17:31 <fell> Salam, Sanuj. You can edit the currency symbol now, but you can tell me also the special symbol and I will add it.
10:19:04 <Sanuj> Oh. How can I edit the currency symbol?
10:21:02 <warlord> Sanuj: like I said, look under the Tools menu.
10:21:09 <Sanuj> Well its usually just R.O. or OMR. Right now its displays something in Arabic
10:21:50 <Sanuj> There is no option under tools to change the currency symbol
10:22:36 <Sanuj> Theres online banking setup, price editor,security editor, loan repayment cal, close book and general ledger
10:22:49 <warlord> Try Security Editor
10:22:53 <fell> wekipedia told me: ر.ع.
10:23:45 <fell> (about 2 years ago)
10:25:10 <Sanuj> Fell: yes that's it
10:25:11 *** himaxx has joined #gnucash
10:26:12 <fell> http://en.wikipedia.org/wiki/Omani_rial
10:27:42 <Sanuj> Warlord, fell: oh k. Found it!
10:27:49 <Sanuj> Thanks!
10:28:36 *** himaxx has left #gnucash
10:29:13 <Sanuj> Fell: yeah but that's in Arabic which I don't understand. The standard is usually OMR.
10:29:43 <fell> Yes OMR is the ISO code.
10:30:26 <fell> You live in Oman and understand no arabic?
10:31:00 *** Krzysiek_K has joined #gnucash
10:34:24 <Sanuj> Fell: haha I'm an expat here. I wouldn't mind that symbol. Problem was that it didn't print well on reports and invoices.
10:41:00 *** Krzysiek_K has quit IRC
10:44:52 *** Sanuj has quit IRC
10:50:00 *** StuM has quit IRC
10:50:00 *** todd has quit IRC
11:21:05 *** todd has joined #gnucash
11:40:20 *** Krzysiek_K has joined #gnucash
11:51:11 *** aqua___ has joined #gnucash
12:15:33 *** mikee has quit IRC
12:16:07 *** mikee has joined #gnucash
12:16:08 *** gncbot sets mode: +o mikee
12:16:09 *** mikee is now known as mikee-afk
12:21:14 *** Krzysiek_K has quit IRC
12:21:35 *** Krzysiek_K has joined #gnucash
12:42:41 *** jmd has joined #gnucash
13:03:07 *** Sanuj has joined #gnucash
13:07:27 *** Sanuj has quit IRC
13:22:47 *** john has joined #gnucash
13:22:47 *** gncbot sets mode: +o john
13:27:31 *** Krzysiek_K has quit IRC
13:32:49 *** rpg has joined #gnucash
14:36:59 *** bhearsum has joined #gnucash
14:40:54 *** benoitg has joined #gnucash
14:42:36 <bhearsum> hi there, i'm trying to set up my personal bank accounts in gnucash. i've been able to import ofx files just fine - but the part that's confusing me is what am i supposed to do with my opening balance? if i set it to 0, the balance is wrong after importing. if i set it to the current balance, the balance is also wrong after importing (because recent transactions are being applied even though the opening balances take them into account) -- any tips?
14:43:19 <warlord> bhearsum: you should set the opening balance the the balance before all the transactions..
14:43:54 <warlord> So e.g. if you import your transactions from 1/1/2013, then the O-B should be the balance as of 12/13/2012
14:44:20 <bhearsum> hrm, that makes sense
14:45:19 <bhearsum> so i guess the usual workflow is to import at a specific interval (eg, per month) - since that's generally what's easiest to download?
14:48:01 <warlord> Or not to import at all and enter your transactions as they occur using the receipts..
14:48:11 <warlord> and then reconcile at the end of the month from your bank statement
14:48:17 <bhearsum> ah
14:48:25 <warlord> (if you import your txns then you lose the ability to notice a bank error)
14:48:37 <bhearsum> ah, i see
14:48:55 <bhearsum> i've only been thinking from a categorizing-my-transactions standpoint so far
14:49:22 <warlord> Right
14:52:41 <bhearsum> thanks for your help!
14:56:22 *** bhearsum has left #gnucash
14:58:30 *** linas__ is now known as linas
15:21:43 <jmd> Since most transactions today are done electronically, what you actually do is export them.
15:29:23 <warlord> jmd: ??
15:36:25 <jmd> Well in the old days you told your bank (somehow externally to gnucash) to transfer some money to somewhere. Independently you entered it in the ledger.
15:37:19 <jmd> Today, thats kindof reversed.
15:43:55 <warlord> I guess so..
15:59:00 *** jmd has quit IRC
16:20:54 *** Gnewbee has joined #gnucash
16:33:32 *** David417 has joined #gnucash
16:34:15 <David417> There is no reference in Bugzilla for bugs in release 2.4.14
16:35:42 <David417> I have added two bug reports for bugs in Windows release of 2.4.14. One is for OFX imports fail and one is for Account Rreport causes error.
16:37:48 <David417> Sorry for the terse text, I am upset by our new puppy, and it is showing, unfortunately.
16:41:48 <warlord> Poor puppy... :(
16:42:43 <David417> I know, she was chasing our cats
16:43:51 <David417> The bug reports are https://bugzilla.gnome.org/show_bug.cgi?id=721434 and https://bugzilla.gnome.org/show_bug.cgi?id=721436
16:43:53 <warlord> David417: I just added a 2.4.14 version
16:44:15 <warlord> Actually, looks like someone else just did it in the last few seconds.
16:44:35 <john> That would have been me. ;-)
16:44:46 <warlord> jinx..
16:46:14 <David417> Wow, talk about service with a smile... ;)
16:48:17 <David417> When someone gets a chance to look at them I can add more info if needed.
16:50:02 <David417> Looks like I will be going back to 2.4.13 for a while.
16:50:17 <David417> Bye
16:50:22 *** David417 has quit IRC
16:51:33 <warlord> Hmm... Did we really have that many backports into 2.4.14?
16:52:00 <john> Looks like we had a few too many. :-(
16:52:05 *** BnMcGn has joined #gnucash
16:52:25 <warlord> Apparently. :(
16:52:44 <john> This looks like a pretty major Scheme issue. The trace file is mostly guile tracebacks.
16:54:26 <warlord> :(
16:54:37 <BnMcGn> I want to regenerate the swig interface (python). Can't figure out how it's done in Gnucash's source tree (2.4)
16:54:39 <warlord> I really wish we had better report tests.
16:55:09 <warlord> BnMcGn: it should auto-generate if you change the .i files. But if not "make maintainer-clean" to force-clean it.
16:55:28 <BnMcGn> K. thanks.
16:56:02 <BnMcGn> Any reason in particular that qof_book_get_collection was not included in swig?
16:56:08 *** aqua___ has quit IRC
16:56:42 <warlord> Not that I know of.. I thought in general we used swig's "include all public functions from .h file" feature.
16:58:05 <BnMcGn> qofbook.h says:
16:58:21 <BnMcGn> * We only want a few things exported to Guile */
16:58:23 <BnMcGn> #ifndef SWIG
16:58:52 <BnMcGn> under which is def of qof_book_get_collection
16:59:12 <warlord> I guess the question is: why do you need access to that function?:
16:59:38 <BnMcGn> Can't figure out how to get whole lists of things, say, all of the vendors.
17:00:28 <warlord> Right..
17:00:31 <warlord> That's on purpose.
17:00:38 <warlord> Use the Query interface.
17:00:44 <BnMcGn> Ahh?
17:00:45 <john> Use QofQuery to find objects. QofBook::Collection is a private interface for engine components to map between GUIDs and object pointers
17:01:07 <BnMcGn> Empty search to get everything?
17:01:08 <warlord> You're assuming you can enumerate; that's a bad assumption.
17:01:19 <warlord> Yes
17:01:35 <john> IIUC, feeding a C object pointer to Python will produce interesting results.
17:02:03 <warlord> I really wish I had decided to use C++ instead of gobjects
17:02:05 <BnMcGn> Can wrap the pointer with... um...
17:02:29 <warlord> The issue is that they are generic pointers... they aren't typed.
17:03:37 <BnMcGn> Can't go, Eg. Account(instance=ptr)?
17:04:01 <warlord> BnMcGn: but basically create a new QofQuery and call qof_query_search_for()
17:04:13 <warlord> BnMcGn: I have no idea...
17:04:18 * warlord doesn't do python
17:04:42 <BnMcGn> I'm getting that picture. The bindings look a little unmaintained.
17:04:55 <warlord> Actually, qof_query_create_for() and then qof_query_set_book()
17:05:19 <warlord> It's not really a binding per-se.. More like wrappers.. To give you access to the C API from Python
17:05:43 <BnMcGn> Yes, but there are a few longstanding typos.
17:05:53 <warlord> patches always welcome
17:06:17 <BnMcGn> Sure. But first I have to figure out what I'm doing.
17:07:01 <BnMcGn> No C skills. Why I'm struggling with swig.
17:08:01 <BnMcGn> Thanks anyways. I'll give that a try.
17:09:00 <warlord> k
17:21:11 <BnMcGn> Hmm... grep -i query in python bindings: Binary file _gnucash_core_c.so matches. Have an alternative? (2.4.11, if it makes a difference)
17:22:07 <BnMcGn> No qof_query... functions
17:25:00 <warlord> BnMcGn: what do you mean? what about 'grep -i qof_query' in the python bindings dir?
17:25:23 <warlord> it should be in there..
17:25:28 <BnMcGn> zilch
17:25:42 <warlord> Well, qofquery is included..
17:25:52 <warlord> %include <qofquery.h>
17:26:00 <warlord> so the APIs from there should be in there.
17:26:10 <BnMcGn> tried source & installed dirs.
17:26:32 <warlord> it's included in src/optional/python-bindings/gnucash_core.i
17:26:39 <warlord> which should pull it into gnucash_core_so
17:27:01 <BnMcGn> is in 2.6 source tree
17:27:05 <warlord> Yes
17:27:17 <warlord> I'm looking at trunk HEAD (which is 2.6)
17:28:11 <warlord> I do not see any "SWIG" in qofquery.h.. So that %include should pull in all the APIs..
17:28:30 <BnMcGn> Ack. How did I miss that gnucash_core.i file sitting there?
17:29:44 <BnMcGn> So upgrade to 2.6?
17:31:16 <warlord> Yes. It appears not to be included in 2.4
17:32:21 <BnMcGn> Is there an alternative way to search in 2.4, then?
17:32:54 <BnMcGn> Ahh... for the days of my youth, when I loved upgrading to shiny new software...
17:33:22 <john> That doesn't make sense. QofQuery is included in the guile bindings; it's used extensively for the reports. Why would it not be in Python?
17:33:23 <warlord> From python? Probably not
17:33:57 <warlord> john: python uses completely separate swig interface definition file (don't ask me why -- I said it was a bad idea then, too)
17:34:14 <john> Oh.
17:34:30 <warlord> c.f. src/optional/python-bindings/*.i
17:35:54 <BnMcGn> So then someone *is* doing a certain amount of work on the python bindings.
17:36:11 <BnMcGn> :-)
17:36:52 <john> Hmm. I see. The utils directories have their own.
17:37:09 <BnMcGn> I saw BillLoookupByID was still there and assumed not.
17:37:47 <john> There's one dev who sort of pokes at them every now and then, and gets irate if something changes in C that breaks them. He's the one who wrote them in the
17:37:51 <john> first place.
17:38:17 <BnMcGn> I see
17:39:09 <warlord> Mark Jeninks
17:39:41 <warlord> See, if he had used a common interface file then we'd have noticed because the scheme side would need to change too.
17:41:23 <john> Oh, you're right. Mike Jenkins wrote them as a submitted patch. I was thinking of Mike Evans, he's the one who pokes at them every once in a while.
17:41:46 <warlord> Maybe he actually uses them for something.
17:42:48 <BnMcGn> I use it for payroll entry, but have never had much luck with the invoice side of things.
17:44:13 <BnMcGn> Gotta do my bookkeeping now. Would like to streamline things a little. Maybe I should learn scheme.
17:48:00 *** StuM has joined #gnucash
17:49:56 *** TradeBorG113 has quit IRC
17:53:12 *** benoitg has quit IRC
17:53:13 *** jeeger has quit IRC
18:11:07 <Gnewbee> I am having a hell of a time getting the mortgage assistant to give me accurate numbers. It's principal / interest calculations are slightly off. Is there somewhere that the (pmt) function is documented so maybe I can edit that manually? I looked in the concepts guide and the other main help guide so far
18:40:38 *** soa2ii has quit IRC
18:43:50 *** soa2ii has joined #gnucash
20:09:15 *** BnMcGn has left #gnucash
20:12:56 *** fell has quit IRC
20:13:34 *** fell has joined #gnucash
20:13:35 *** gncbot sets mode: +o fell
20:20:09 *** rpg has quit IRC
20:21:53 *** puck has quit IRC
20:35:53 *** puck has joined #gnucash
22:25:36 <warlord> Gnewbee: it's implemented in fin.scm -- but how is it "slightly off"? Perhaps your bank rounds the interest percentage?
22:29:39 <Gnewbee> warlord, the interest / principal calculations are off by a couple of dollars when compared to the statement that I get from the bank, so yeah, it could be a rounding error.
22:30:08 <Gnewbee> Honestly, I am going to pay off the mortgage within a few months anyways, so I will just enter it in manually until then.
22:30:26 <warlord> Are you overpaying?
22:30:31 <warlord> GnuCash doesn't handle that, either.
22:52:38 <Gnewbee> No, I am not paying extra on the mortgage. Just going to keep making standard payments, then pay it all off soon. Good to know that Gnucash doesn't handle extra payments, though for future loans that I may set up.