2017-02-27 GnuCash IRC logs
00:29:44 *** tuxd00d has quit IRC
00:30:49 *** tuxd00d has joined #gnucash
00:31:30 *** O01eg has quit IRC
00:32:06 *** tuxd00d has quit IRC
00:33:03 *** tuxd00d has joined #gnucash
01:10:37 *** Mechtilde has joined #gnucash
01:57:39 *** Mechtilde has quit IRC
02:27:51 *** gjanssens has joined #gnucash
02:27:51 *** ChanServ sets mode: +o gjanssens
02:28:01 *** mrklintscher has quit IRC
02:45:07 *** mrklintscher has joined #gnucash
02:54:36 *** fabior has joined #gnucash
03:03:22 *** Mechtilde has joined #gnucash
03:38:04 *** Michael0660 has joined #gnucash
03:38:14 <Michael0660> Hello
03:38:33 <Michael0660> Is there someone who can help me with GNUcash? I believe OFX is missing from my install.
03:46:51 *** Michael0660 has quit IRC
03:47:22 *** fekepp has quit IRC
03:51:48 *** AndroUser has joined #gnucash
03:51:59 <AndroUser> Hello
04:09:32 *** fell has joined #gnucash
04:11:37 *** AndroUser has quit IRC
04:13:24 *** fekepp has joined #gnucash
04:14:28 *** oshliaer has joined #gnucash
04:19:44 <oshliaer> Hi there! I'm big fan of open source. Is there the documentation Russian? If not then where do I get a template for translate?
04:21:33 <mikee> oshliaer: https://wiki.gnucash.org/wiki/Translation
04:21:58 <oshliaer> Thanks @mikee
04:23:38 *** CDB-Away has quit IRC
04:25:34 <mikee> the Russian file is ru.po and has information about the last translors in it's header. It was last updated May 3 2016
04:32:02 *** CDB-Away has joined #gnucash
04:35:40 *** CDB-Away has quit IRC
04:51:06 <oshliaer> @mikee, I found http://gnucash.org/develdocs.phtml Thanks for support
04:51:06 <gncbot> oshliaer: Error: "mikee," is not a valid command.
05:14:27 *** odo2063 has joined #gnucash
06:35:26 *** Jimraehl1 has joined #gnucash
06:36:17 *** Jimraehl1 has quit IRC
06:57:50 *** fabior has quit IRC
07:08:59 *** User has joined #gnucash
07:11:09 *** User_ has joined #gnucash
07:13:13 *** User has quit IRC
07:50:39 *** rickoehn has joined #gnucash
08:38:58 *** oshliaer has quit IRC
08:52:39 *** odo2063 has quit IRC
08:58:48 *** fabior has joined #gnucash
09:02:41 <MrKeuner> warlord, thank you
09:13:17 <warlord> MrKeuner: you're welcome
09:24:25 *** kael has joined #gnucash
09:54:49 *** kael has quit IRC
10:02:56 *** mlncn has quit IRC
10:20:17 *** storyjesse has quit IRC
10:24:10 *** mlncn has joined #gnucash
10:35:24 *** mrklintscher has quit IRC
10:36:12 *** Mechtilde has quit IRC
10:41:16 *** Heisenburg has joined #gnucash
10:42:55 *** MrWhite has quit IRC
10:48:29 <MrKeuner> I think the easiest way to start using GNUCash would be to simply create the accounts in my bank in GNUCash with the balance amounts. Going forward I can update GnuCash file. Assuming this is true, and please correct me if not, adding the checking balance in my bank to the checking account in GnuCash as deposit, I should be using imbalance-usd as the account funds are withdrew from, correct?
10:57:02 <warlord> MrKeuner: keep in mind this is double entry accounting, so you need an Equity account (for the opening balance) and then Expense Account(s) for your withdrawals.
11:16:31 *** AndroUser has joined #gnucash
11:16:38 *** AndroUser2 has joined #gnucash
11:18:10 <MrKeuner> warlord, I understand the double entry bookkeeping I think. however I thought the two would be checking vs imbalance for the opening balance transaction. At this point I am not withdrawing anything yet. Just getting the bank balance to GnuCash. Am I still missing something?
11:19:36 *** AndroUser has quit IRC
11:20:46 <warlord> no, it should be Equity, not Imbalance
11:21:36 *** O01eg has joined #gnucash
11:22:59 <MrKeuner> got it. Thank you
11:24:09 <warlord> If you have an Imbalance account, you're doing something wrong. ;)
11:28:28 <MrKeuner> Yes got it. Thanks, never noticed this obviously. Equity:Opening Balances
11:29:51 <warlord> Yes.
11:29:53 <MrKeuner> GNucash is promising, very pumped. Now I can stop relying on my credit union's faulty transaction description handling.
11:29:58 <warlord> I highly recommend you just create a set of accounts.
11:31:33 <MrKeuner> warlard selected all of them actually, removed only couple like education and child expenses. Do you suggest starting with less?
11:31:59 <warlord> Nah. It's much easier to remove accounts later than it is to split an account up.
11:32:07 <warlord> I.e., it's easier to combine than the split
11:34:05 <MrKeuner> now that you mentioned another question :), I created funds and used that as the destination account in couple transactions. Then decided to split funds into an exhaustive set of funds, funds - a, funds - b etc. Now I have to go each transaction that addressed funds and correct it as funds -a, or funds-b, correct?
11:37:45 <warlord> Yep
11:41:06 *** CDB-Away has joined #gnucash
11:54:43 *** rickoehn has quit IRC
12:07:44 *** mlncn has quit IRC
12:17:27 *** Mechtilde has joined #gnucash
12:17:56 *** Michael0660 has joined #gnucash
12:18:16 <gjanssens> Our ahmed friend continues to ask for a refund
12:18:24 <Michael0660> Is there someone who can help me with GNUcash? I believe OFX is missing from my install.
12:18:42 <gjanssens> There's no sign of his so called donation yet on the gnucash account.
12:18:57 <gjanssens> So obviously there's no question of refunding until there is.
12:19:32 <gjanssens> I intend to answer him but I wonder if this conversation should be held on the mailing list rather than in private.
12:19:34 <Michael0660> I will gladly make a donation to GNUcash if I can find someone to help me with OFX
12:20:14 * gjanssens is inclined to take this off-list, as it has a smell to it
12:20:28 <gjanssens> Michael0660: are you trying to bribe us ? ;p
12:20:37 <gjanssens> What's your issue with OFX ?
12:20:53 <Michael0660> lol... honestly, no! But if that helps! :)
12:21:22 <Michael0660> I am done with MS Windows and switcing everything to linux so I am prepared to do what I can to assist the open source and linxu community :)
12:21:37 <Michael0660> So I just installed openSUSE Tumbeweed
12:21:42 <Michael0660> ran all updated
12:21:47 <Michael0660> *updates
12:21:53 <Michael0660> installed GNUcash
12:22:15 <Michael0660> I would like to setup my Chase online checking and savings accounts
12:22:30 <Michael0660> the only option I see in the Aqbanking is HBCI or offline backend...
12:23:06 <gjanssens> Hmm, that's an area I don't know much about I'm afraid
12:23:09 <Mechtilde> Michael0660, what is your prefered language setting
12:23:18 <gjanssens> GnuCash doesn't support online banking in Belgium
12:23:27 <Michael0660> I am in US
12:23:38 <Michael0660> Prefered language in GNU or openSUSE?
12:24:14 <warlord> gjanssens: I noticed
12:24:17 <Mechtilde> first in openSuse
12:24:19 <Michael0660> :)
12:24:26 <Michael0660> Sorry I am a newb
12:24:30 <Michael0660> newbie
12:24:46 <Michael0660> however I am technically inclined, so.... beware :)
12:24:53 <Mechtilde> and I didn't use opensuse but debian
12:25:20 <Mechtilde> under Debian I had to install aqbanking separately
12:25:44 <jralls> Michael0660: It sounds like OpenSuSE has mis-configured AQBanking somehow. For the US you need the OFXDirect backend to AQB.
12:26:01 <jralls> Perhaps they have it as a separate package.
12:26:16 <Michael0660> so using YaST I was able to find OFX dependincies... however still nothing
12:26:41 <Michael0660> I was reaidng that perhaps a command line needs to be issued to enable OFX
12:26:42 <warlord> Michael0660: I don't know how opensuse packages it.
12:26:43 <Michael0660> ?
12:26:53 <warlord> Michael0660: i wouldn't imagine so.
12:27:30 <jralls> There are some OpenSuSE users on the mailing list (gnucash-user@gnucash.org). Try subscribing and asking there.
12:27:34 <gjanssens> Michael0660: I guess the command line option refers to *building* gnucash with ofx support
12:27:49 <Michael0660> I see...
12:27:58 <gjanssens> I know I don't need it when running gnucash
12:28:10 <Michael0660> When I go to Tools > Online Banking Setup
12:28:27 <Michael0660> Forward > Start AqBanking Wizard
12:28:44 <Michael0660> I have 2 tabs... Users and Accounts...
12:28:50 <gjanssens> even though I can't use online banking I always build with it enabled (to detect build regressions) and in my Online Banking Setup the OFX backend is available
12:29:15 <gjanssens> At least when I create a new user, haven't tested further
12:29:33 <gjanssens> (as I can't...)
12:29:44 <Michael0660> When I select the Accounts tab, a new dialog window appears with a drop down list and I can either select HBCI or offline backend... nothing for OFX
12:30:25 <warlord> Michael0660: do you have libofx installed? Do you have the aqb ofx backend installed?
12:31:03 <gjanssens> Michael0660: there is for me. It offerse the aqofxconnect backend
12:31:41 <Michael0660> @warlord I think so, in YaST if appeared and I installed it but so far it is not showing up in GNUcash
12:31:41 <gncbot> Michael0660: Error: "warlord" is not a valid command.
12:31:55 <Michael0660> warlord: I think so, in YaST if appeared and I installed it but so far it is not showing up in GNUcash
12:32:20 <gjanssens> Check if your openSuse aqbanking package installs a version of libaqofxconnect.so
12:32:46 <gjanssens> And whether it's the one gnucash expects (this may be a bit harder)
12:33:51 <gjanssens> jralls, warlord: How do you want me to followup on ahmed ? In private with you guys cc'd ? Or is this best discussed with the full core team ?
12:34:28 <jralls> gjanssens: Has Ahmed's "donation" showed up?
12:35:38 <Michael0660> I opened openSUSE software install and searched for libaqofxconnect and it found it and installed.. I restarted GNUcash but still nothing there on the backend options
12:37:11 <gjanssens> jralls: no. That's what I started my conversation with about 20 mins ago
12:37:45 <gjanssens> Michael0660: then I suspect gnucash isn't built properly on openSuse
12:39:12 <Michael0660> I see.... at the moment I am linux distro agnostic... I prefer a KDE DE that is stable and so far openSUSE is, howver I need GNUcash to rid myself of Micorosft Windows and Quicken... what distro does GNUcash work with OFX "out-of-the-box" with?
12:39:22 <warlord> gjanssens: I would just reply saying "sorry, we cannot do that"
12:39:57 <warlord> Michael0660: it certainly works out of the box on Ubuntu and Fedora.
12:40:06 <jralls> gjanssens: Ah, sorry, I missed that. I suggest that you reply to him on list, tell him that no donation has turned up yet. Say that if one does you'll return it to the bank it came from, but that you're not going to act as a go between for interbank transfers.
12:41:16 <jralls> Micheal0660: Again, there are OpenSuSE users on the user mailing list. Ask there for help getting GnuCash installed.
12:41:45 *** Mechtilde has quit IRC
12:41:51 <Michael0660> Great... thank you for everyones help... should I make a donation on the GNUcash website?
12:41:56 <jralls> Michael0660: HOWEVER, note that there is also an open bug about flakey input when using GnuCash with KDE.
12:42:15 <Michael0660> thanks again... I will try Fedora 25
12:42:49 *** Mechtilde has joined #gnucash
12:43:22 <gjanssens> Michael0660: I'm on F25/KDE myself. As mentioned I see the ofxconnect options in the Online Banking configurator
12:44:43 <Michael0660> Was there anything beyond a standard install that you needd to perform to get it working on F25/KDE?
12:44:53 <gjanssens> I do see the flakey input behaviour jralls mentions
12:46:09 <gjanssens> Oh, spoke too fast :( Since I build myself I can confirm that build works fine. I haven't tested the system provided version for quite some time (I'd need to reinstall to do so)
12:47:04 <gjanssens> However, I don't think I did have to do something after installing
12:47:19 <gjanssens> Perhaps install aqbanking separately if it's considered optional, I don't remember
12:47:20 <Michael0660> OK... I am open to doing whatever is neccessary... I prefer KDE DE
12:48:06 * gjanssens reinstalled system provided gnucash...
12:48:41 <gjanssens> aqofxconnect is also visible in gnucash installed from fedora repos
12:50:43 <Michael0660> whenever I launch the software install app on openSUE and search for aqofxconnect or ofx* it finds it and I install it but nothing comes of it
12:53:46 <warlord> Michael0660: And you're restarting gnucash after you install?
12:54:16 <Michael0660> Yes, I am restarting... however I think I am missing something with regards to YaST2...
12:54:29 <gjanssens> Well, I should probably have said aqbanking is not built properly on openSuse thumbleweed
12:54:36 <Michael0660> I am in YaST2 now and searching for *OFX
12:55:08 <Michael0660> ...and I see several packages/dependeices available... not sure I am using correct terminology....
12:55:35 <gjanssens> I don't think aqbanking depends on any ofx library by the way
12:55:55 <Michael0660> I see the followin packages: libaqofxconnect7, libofx, libofx-devel, libofx6, and aqbanking-ofx
12:57:01 <gjanssens> it comes with its own ofx implementation IIUC
12:57:12 <warlord> Michael0660: and can you confim it's installed? rpm -qa | grep ofx
12:57:15 <gjanssens> Michael0660: aqbanking-ofx seems to be the obvious candidate
12:58:19 <Michael0660> aqbanking-ofx-5.7.4beta-1.2.x86_64
12:58:19 <jralls> You probably want both libofx and aqbanking-ofx: The former is for file imports, the latter for online banking via OFXDirectConnect.
12:58:21 <Michael0660> libofx-0.9.10-2.5.x86_64
12:58:22 <Michael0660> libofx-devel-0.9.10-2.5.x86_64
12:58:24 <Michael0660> libaqofxconnect7-5.7.4beta-1.2.x86_64
12:58:25 <Michael0660> libofx6-0.9.10-2.5.x86_64
12:58:38 <Michael0660> after running that commans rpm -qa | grep ofx, those were the results in temrinal
12:58:41 <gjanssens> warlord, jralls: I've chosen jralls' suggestion regarding ahmed
12:59:25 *** rickoehn has joined #gnucash
12:59:29 <gjanssens> Michael0660: FYI Fedora ships an older aqbanking release: aqbanking-5.6.12-1.fc25.x86_64
12:59:31 <Michael0660> ITS WOKING!
12:59:34 <Michael0660> ITS WORKING!
12:59:51 <gjanssens> Huh, what changed ?
12:59:54 <Michael0660> OFX is now an option!
13:00:26 <gjanssens> Happy for you :)
13:00:26 <Michael0660> I re-ran YaST2, searched again for OFX and it installed some packages... I guess
13:00:39 <Michael0660> can I capture a log to send to you?
13:00:59 <gjanssens> There's not much I could do with that...
13:01:22 <gjanssens> I was just curious what you did to make it work
13:01:40 <gjanssens> Did you already enter data in gnucash ?
13:02:03 <Michael0660> I thinki it was: libaqofxconect7 - version 5.74beta that was installed according to my package history
13:02:19 <gjanssens> I am interested in whether you see the input entry issues as well
13:03:04 <warlord> gjanssens: that's fine
13:04:13 <Michael0660> Now I need to go through setup... however I am getting the new account dialog windows with OFX backend and it found Chase and prompted me to accept security certificate...
13:10:43 <Michael0660> I think some more work is required on my side... I am not sure of the field entries for new account setup for Chase... I am asserting that once everything is setup correctly it should connect and import my transactions?
13:11:40 <gjanssens> Michael0660: no idea...
13:12:19 <Michael0660> Des GNUcash generate the Client UID?
13:15:26 <gjanssens> Michael0660: I don't think any of us who helped you is using online banking ourselves
13:16:15 <gjanssens> (except Mechtilde perhaps but she's in Germany so she'd use it differently from you)
13:16:58 <gjanssens> You really should take it up on the gnucash-user mailinglist as jralls suggested several times
13:17:38 <jralls> Actually, I use online banking frequently.
13:17:53 <Michael0660> jrails... are you in the US?
13:18:02 <jralls> But not with Chase.
13:18:24 <jralls> I am.
13:18:54 <gjanssens> Heh, learned something new today :)
13:19:00 <Michael0660> lol
13:19:19 * gjanssens did know jralls is in the US though ;)
13:19:19 <Michael0660> Did you have to enter BIC codes, etc to get it to work?
13:20:57 <Michael0660> OK... I have to go take an exam in molecular biology now... lol. Thank you everyone for your help. I think I have some work to do, but I am one step closer!
13:21:48 <jralls> Michael0660: There are detailed setup instructions in the wiki: http://wiki.gnucash.org/wiki/Setting_up_OFXDirectConnect_in_GnuCash_2. From that page is a linkwith additional information about particular banks and a couple of data sites with the URLs and codes that you need.
13:22:01 <Michael0660> Thank you!
13:22:10 <jralls> Martin has some of that built in to the new account wizard, so try that first.
13:23:07 <Michael0660> SHould I report back here on my progress/findings?
13:24:58 <warlord> gjanssens: Mechtilde is a she?
13:25:05 * warlord had no clue
13:27:48 <Mechtilde> warlord, Yes I'm a woman.
13:30:15 <warlord> i had no clue.
13:30:21 <warlord> awesome
13:34:04 <gjanssens> warlord: :) All (Western) European names ending in 'ilde' are girl's/woman's names
13:35:13 <gjanssens> But I should probably write "Most" and "are typically"
13:35:31 <gjanssens> Before you know it someone will come up with an exception
13:35:55 *** odo2063 has joined #gnucash
13:36:20 <gjanssens> Heck, while not ending in "ilde" my very own name is used for both men and women... in the Dutch speaking areas of the world
13:37:09 <Mechtilde> yes this are old German (800-1200) names for women
13:37:18 <warlord> Okay.,
13:37:27 <warlord> Silly American learns something new today ;)
13:37:30 <Mechtilde> p.C.
13:37:58 <Mechtilde> or better p.Chr.
13:38:26 *** AndroUser2 has quit IRC
13:41:48 <gjanssens> warlord: heh, if it weren't for an old German police television series I would not have known whether 'Derek' would be a male or a female name either.
13:42:15 <gjanssens> As it happens there used to be a German series called "Derek", which was the name of the lead character.
13:42:37 <gjanssens> But other than that I don't know anyone by that name :)
13:44:46 <gjanssens> anyone *else*
13:48:15 <Mechtilde> die hieß "Derrick
13:49:14 *** fabior has quit IRC
14:01:22 <gjanssens> Mechtilde: oh right! That's not exactly the same. It's been a long time since I've watched that series...
14:04:47 *** frakturfreak has joined #gnucash
14:05:24 <Mechtilde> I also looked at a search engine
14:05:26 <Mechtilde> ;-)
14:06:47 *** frakturfreak1 has joined #gnucash
14:06:47 *** frakturfreak has quit IRC
14:07:27 *** frakturfreak1 has quit IRC
14:07:27 *** frakturfreak has joined #gnucash
14:11:11 <gjanssens> Mechtilde: a search engine ?
14:12:07 *** Mechtilde has quit IRC
14:12:24 *** fekepp has quit IRC
14:53:43 *** AndroUser2 has joined #gnucash
15:06:00 *** fabior has joined #gnucash
15:15:10 <warlord> gjanssens: it's relatively rare even here in the US. I was named after a movie character from the last 1960s and early 1970s, Derek Flint. ("In Like Flint" et al)
15:16:13 <gjanssens> Interesting. So a movie character after all...
15:18:49 <warlord> Yes
15:21:41 <jralls> There's also the noted actor Sir Derek Jacobi.
15:22:12 <warlord> And actress/model Bo Derek.. And the musical group Derek and the Dominoes.
15:23:46 <frakturfreak> And now I’m thinking about driving like it were on rails
15:24:30 *** AndroUser2 has quit IRC
15:26:28 <gjanssens> Ok fellas, I'm off for tonight... See you tomorrow
15:26:48 *** gjanssens has quit IRC
15:54:57 *** Michael0660 has quit IRC
15:55:10 *** mlncn has joined #gnucash
16:20:06 *** frakturfreak has quit IRC
16:22:42 <mikee> warlord: ("In Like Flint" et al) ? Thanks for that. awesome. :)
16:25:03 *** CDB-Away has quit IRC
16:25:54 <warlord> mikee: you're welcome.
16:33:44 *** CDB-Away has joined #gnucash
16:36:27 *** daum has joined #gnucash
16:37:28 <daum> hi - on my payroll accounts each entry is split between taxes and what..is there a way to run a report which shows me the total amount of the transaction not just the split? For example when i run account report it shows me the total amount paid but then at the bottom the total debits of the report only shows the amount to that account versus the total amount
16:37:37 <daum> just trying to get the total amount paid last year for a person
16:39:24 <warlord> daum: run the report from bank account that paid out the payroll?
16:40:16 *** fabior has quit IRC
16:40:39 <daum> trying to get it per person though
16:41:12 <warlord> Dont you have separate transactions per person?
16:41:27 <warlord> (remmeber, gnucash doesn't "do" payroll)
16:41:57 <daum> I do - but how would i group by like account? all payroll comes from the "Checking account"
16:42:34 <warlord> In the transaction report, filter by target account, or sort by description
16:44:45 <daum> ok thanks!
16:57:26 *** jonas has quit IRC
17:08:13 *** User_ has quit IRC
17:20:11 <fell> jralls: matin released Gwenhywfar 4.17.0
17:20:22 <fell> +r
17:20:32 <jralls> fell: OK, thanks.
17:21:09 <fell> and the AqBanking 5.7.5beta has recent german bank data
17:21:35 *** daum has quit IRC
17:21:40 *** jonas has joined #gnucash
17:24:57 *** jonas has quit IRC
17:30:52 *** fekepp has joined #gnucash
17:36:24 *** mlncn has quit IRC
17:37:48 *** jonas has joined #gnucash
17:58:56 *** fekepp has quit IRC
17:59:53 *** User_ has joined #gnucash
18:05:45 *** rickoehn has quit IRC
18:06:18 *** fekepp has joined #gnucash
18:07:25 *** mlncn has joined #gnucash
18:36:48 *** fekepp has quit IRC
18:36:49 *** fekepp has joined #gnucash
19:24:16 *** CDB-Away has quit IRC
19:25:48 *** CDB-Away has joined #gnucash
19:39:17 *** CDB-Away has joined #gnucash
19:41:27 *** CDB-Away has quit IRC
19:54:41 *** CDB-Away has joined #gnucash
20:03:41 *** User_ has quit IRC
20:31:41 *** mlncn has quit IRC
21:22:37 *** odo2063 has quit IRC
21:40:06 *** kael has joined #gnucash
21:45:06 *** kael has quit IRC
23:10:39 *** tuxd00d has quit IRC
23:11:04 *** tuxd00d has joined #gnucash
23:15:09 *** odo2063 has joined #gnucash
23:16:52 *** mlncn has joined #gnucash
23:42:38 *** mlncn has quit IRC