2015-10-13 GnuCash IRC logs
00:09:40 *** rpg has quit IRC
01:12:45 *** MechtiIde has joined #gnucash
01:30:33 *** MechtiIde has quit IRC
01:41:01 *** MechtiIde has joined #gnucash
02:04:04 *** MechtiIde has quit IRC
02:13:51 *** ThomasKeller has quit IRC
02:13:51 *** codesmythe has quit IRC
02:13:51 *** GabrieleV has quit IRC
02:13:51 *** puck has quit IRC
02:13:51 *** dgtlmoon has quit IRC
02:13:51 *** jralls has quit IRC
02:15:06 *** ThomasKeller has joined #gnucash
02:15:06 *** codesmythe has joined #gnucash
02:15:06 *** GabrieleV has joined #gnucash
02:15:06 *** puck has joined #gnucash
02:15:06 *** dgtlmoon has joined #gnucash
02:15:06 *** jralls has joined #gnucash
02:15:06 *** irc.gimp.ca sets mode: +o jralls
02:42:51 *** ErKa has joined #gnucash
02:54:08 *** uXus has quit IRC
03:01:42 *** Coderjoe has quit IRC
03:04:43 *** Coderjoe has joined #gnucash
03:06:59 *** uXus has joined #gnucash
03:25:10 *** autoditac__ has joined #gnucash
03:27:11 *** nomeata has joined #gnucash
04:37:25 *** fabior has joined #gnucash
04:45:58 *** rubdos has joined #gnucash
05:20:26 *** len has quit IRC
07:00:33 *** Jimraehl1 has left #gnucash
07:07:36 *** Jimraehl1 has joined #gnucash
07:22:48 *** gour has joined #gnucash
07:36:01 <gour> morning
07:36:55 *** fabior has quit IRC
07:39:33 <gour> after several months of using ledger-cli and attempting to use beancount, i've decided to switched back to gnucash...ledger-cli had some sense when i was using emacs for most of stuff, but after switching to vim (for the 2nd time experienced slight wrist pain) and not having enough time to re-organize ledger file into beancount one, i've decided that those solutions are 'too simple' to
07:39:35 <gour> paraphrase Einstein's quote, so I'm back to GC...now wondering if renaming/re-organizing account's tree is sage operation?
07:39:47 <gour> i'd like to simplify a bit my old tree of accounts
07:40:08 <gour> another concern is what are current directions of GC development in general?
08:01:19 <reactormonk> Is it easier to delete the current accounts and recreate them from a template or to purge the file and create a new one?
08:19:37 <ThomasKeller> I have added another account in a different currency
08:20:05 <ThomasKeller> how can I tell gnucash to automatically fetch the exchange rate from the internet
08:20:18 <ThomasKeller> and show the total in my base currency ?
08:21:10 <ThomasKeller> It works manually when I go to Tools -> Price Editor -> get quotes
08:21:35 <ThomasKeller> but can gnucash recalculate the exchange rate automatically ?
08:27:53 <warlord> ThomasKeller: no, there is no automated get-quotes. You either have to click the button manually, or set up a system cron job to run gnucash --get-quotes..
08:28:16 <warlord> However, in the latter case you need to also ensure that gnucash isn't running when the cron job runs
08:28:48 <warlord> gour: it depends what kind of simplification you desire. It's always easier to merge accounts than to separate them.
08:29:15 <warlord> Moreover, reoganizing accounts is relatively easy, but you do need to do it one-at-a-time which can be cumersome if you have lots and lots of accts to shift around.
08:32:33 <gour> warlord: good...yeah, plan to trim my tree of acounts a bit - mostly merge some expenses account as well as rename-one some other ones
08:34:17 <gour> warlord: i did that sort of work when i was beginning with GC...now i'd like just to do some 'refactoring'...i thought that ledger/beancount would be easier, but they're not and i'm not such a financial geek to require their possible extra features...actually none of them have proper budget support
08:35:01 <gour> the only thing i have to do is to possible adjust some GC report for our needs - entering and reconciling worked better in GC anyway
08:35:27 <gour> as far as text-format is concerned, i keep my GC files under vcs uncompressed :-)
08:35:59 <ThomasKeller> $ gnucash --get-quotes
08:35:59 <ThomasKeller> Unknown option --get-quotes
08:36:20 <ThomasKeller> warlord: --get-quotes does not work
08:38:51 <gour> warlord: in the archives i've found the following link: http://genietvanhetleven.blogspot.hr/2014/10/importing-csv-into-gnucash.html but wonder how does import of CSV works in general with GC? here i'm thinking about converting bank's Excel reports to CSV (using Gnumeric) and then importing into GC?
08:45:00 *** thelastflash has joined #gnucash
08:56:34 *** fabior has joined #gnucash
09:00:54 *** Absurd-Mind has quit IRC
09:06:14 *** Absurd-Mind has joined #gnucash
09:10:05 <warlord> ThomasKeller: sorry, --add-price-quotes
09:10:39 <warlord> gour: if you're going to convert it you're better off (IMHO) converting to QIF
09:12:52 *** fell_ has joined #gnucash
09:13:32 <ThomasKeller> warlord: it needs a filename, --add-price-quotes=FILE
09:14:12 <ThomasKeller> should this be an existing file ?
09:14:36 *** fell has quit IRC
09:16:42 *** kdub has quit IRC
09:24:44 <warlord> ThomasKeller: yes, it should be your data file
09:24:56 <warlord> .. which is why you can't have it already open.
09:29:13 *** ThomasKeller has quit IRC
09:29:35 *** ThomasKeller has joined #gnucash
09:30:49 <ThomasKeller> warlord: there are several files in ~/.gnucash/ and in my data dir
09:31:00 <ThomasKeller> which of those is "the data file" ?
09:31:22 <gour> warlord: it's possible to convert excel to qif on linux?
09:32:09 <warlord> gour: Calc2QIF?
09:32:44 <gour> warlord: ohh, that's new for me. thanks a lot!
09:32:45 <warlord> ThomasKeller: I can't tell you ... it's going to be wherever you saved it. It'll be named <something>.gnucash ... It most likely will NOT live under ~/.gnucash/
09:35:49 <warlord> That's like you asking me how to find you Spreadsheet file, or your Thesis. I have no idea where you saved it, or what you named it.
09:39:32 <ThomasKeller> warlord: sorry, but I find the gnucash file structure chaotic. There are 10s of files in my data-dir, all of them named foo.gnucash.<date>.gnucash
09:40:54 <warlord> ThomasKeller: http://wiki.gnucash.org/wiki/FAQ#Q:_What_are_all_these_.gnucash_and_.log_files_filling_up_my_directory.3F
09:44:12 <ThomasKeller> warlord: thanks a lot
09:44:35 <ThomasKeller> gnucash --add-price-quotes=foo.gnucash works
09:51:32 <warlord> ThomasKeller: just make sure you're not concurrently opening your datafile.
09:56:19 *** thelastflash has quit IRC
10:04:39 *** mlncn_ has joined #gnucash
10:06:47 <ThomasKeller> another question:
10:06:57 <ThomasKeller> I am reading that gnucash supports integration with online banking (through OFX, AqBanking, ..)
10:07:03 <ThomasKeller> but I am unable to find any bank that offers this interface for its clients
10:07:10 <ThomasKeller> and I have never heard about anybody using it
10:07:21 <ThomasKeller> is there a list of banks (in Europe) which support this ?
10:08:29 <warlord> in Europe? No, AFAIK nobody in Europe uses OFX.
10:08:36 <warlord> HOWEVER there is HBCI in Germany
10:08:48 <warlord> And I belive there is something like... SIPE?? for other areas of europe.
10:10:33 <ThomasKeller> how can I find out whether my bank supports any of those ?
10:10:51 <ThomasKeller> I assume, they might not know gnucash
10:13:05 <warlord> Ask them what online protocols they support?
10:13:25 * warlord doesn't use any online banking protocols
10:16:17 *** kdub has joined #gnucash
10:34:47 *** Simon has quit IRC
10:42:49 *** Simon has joined #gnucash
10:58:17 <lmat> Is there a keyboard shortcut for "make this transaction balance"?
10:58:56 <lmat> For instance, I'm entering a taco bell receipt. Automatic recall fills out some values. I only have the total, so I enter that as CR liability (credit card).
10:59:19 <warlord> lmat: is it auto-filling out as a split transaction
10:59:21 <warlord> ?
10:59:29 <lmat> I calculate the base amount (using total/1.07 because our sales tax rate is .07). Then, I go to the sales tax split, and it says the wrong amount.
11:00:00 <lmat> I see at the bottom of the transaction what I need to add to this incorrect amount , but I'd rather just press the magic button, and it fills in the tax as whatever needs to happen to this transaction to make it balance.
11:00:04 <lmat> (Sorry if I'm being unclear)
11:00:48 <lmat> warlord: Autofill is working properly and fills out a balanced transaction, but it's the old one, and needs adjusted. For the new transaction, I only have the total.
11:01:08 <warlord> sorry, you need to adjust it manually
11:01:18 *** gour1 has joined #gnucash
11:01:31 <warlord> remember you can use math, so you can go into the current amount and do <curr_amt>+1.02
11:02:58 *** gour has quit IRC
11:03:09 <lmat> warlord: Yes, that's often what I do. Another option is to delete what's there, press 'up', then the amount at the bottom is what I need to type.
11:03:21 <lmat> warlord: Okay, thanks, just checking.
11:20:21 *** nomeata has quit IRC
11:40:43 <gour1> my main used currency is Croatian native (hrk), but i also track few accounts in €s (EUR). however when i'm looking in Balance Sheet report's Assets, the amount reported in hrk is wild in comparison with the €s, and the 'exchange rate' is the same but total out of reality. any hint where to look for potential problem?
11:45:28 *** MechtiIde has joined #gnucash
11:45:38 <jralls> gour1: Start with Tools>Price Editor. You've probably got a bad exchange rate.
11:46:20 <jralls> MechtiIde: Have you had a chance to fix up your PR?
11:48:58 <MechtiIde> no
11:49:09 <MechtiIde> I will write you a mail if I'm ready
11:49:18 <MechtiIde> not before next weekend
11:49:53 <jralls> OK.
11:50:11 <gour1> jralls: price editor seems ok, but i have found something strange with Equity
11:51:57 <jralls> gour1: OK, but something in an Equity account isn't going to affect the conversion from EUR to HRK. Hmm, are you on 2.6.9?
11:55:45 <gour1> jralls: no, but at 2.6.7....the strange thing is that e.g. i borrowed 4000€ from a friend and registered it as transaction from Equity to Liabilities which increased for that amount (in hrk). however, when looking at Equity account - Initial amounts,the Equity was decreased for the amount of amount(in hrk)*exchange_rate (for hrk <--> EUR) which was at some point recorded as 7.6
11:57:37 <jralls> gour1: That's what Google is reporting as the current rate: 7.62HRK = 1.00EUR.
12:00:40 <gour1> jralls: well, the strange is that both Equity & Liability accounts are set to operate in hrk, and liability it's shown that my Equity has decreased for 30000hrk*7.6 while Liability increased for 30000hrk only?
12:00:42 <jralls> gour1: Equity and Liability are on the same side of the accounting equation, so a transaction between them will increase one and decrease the other. Normally a loan would credit (increase) Liabilities and debit (increase) Assets or Expenses.
12:01:49 <gour1> jralls: that's clear, but while Equity amount is multiplied by 7.6, while Liability is not, although both should not be multiplied since they are supposed to be in native hrk?
12:01:56 *** gour1 is now known as gour
12:04:36 <gour> have to go to the kitchen...bbl
12:05:51 <jralls> gour: You said the load was 4000€, so how did you convert it to HRK? Is there an imbalance split for the other 198000HRK?
12:07:47 <gour> jralls: loan was 4000€ in hrk, which at that time was 30000hrk (7.5)
12:08:53 <gour> iow, from the very beginning i'm tracking it in HRK
12:09:50 <gour> but based on equity it looks as the loan was 30400€ - poor me :-(
12:10:36 <gour> same thing happened with another loan, it was also multiplied by 7.6
12:11:08 <jralls> gour: There's got to be a split for the rest of the money--the balance that isn't in Libabilities.
12:11:19 <jralls> gour: How are you entering these loans?
12:14:33 <gour> jralls: see http://pasteboard.co/1lFWya9P.png & http://pasteboard.co/1lFUNTnT.png
12:14:50 <gour> now have to go to the kitchen...bbl if oyu have any hint
12:17:37 <jralls> gour: That doesn't answer either question.
12:19:20 <jralls> gour: Please show the transaction in split view, that will at least answer the first one. The second question is how did you create the transaction in the first place. I.e., did you do it by hand in a basic-view transaction, did you use the transfer dialog, etc.
12:54:57 <gour> jralls: can't remember how i did enter them, but here is split view: http://pasteboard.co/1lIuw6aZ.png & http://pasteboard.co/1lIxJuEn.png
12:55:32 <gour> i wonder how is it that transaction does not balance?
12:56:07 <jralls> I wonder the same thing. Are you sure that "Liabilities:Barhi" isn't in Euro?
12:57:41 <gour> jralls: nope, it still shows balance of 30000 kn
13:00:04 <gour> i'm still busy in the kitchen. bbs
14:08:40 *** MechtiIde has quit IRC
14:19:26 *** fabior has quit IRC
15:32:48 *** Q-Chymera has quit IRC
15:33:26 *** Q-Chymera has joined #gnucash
15:34:12 <gour> jralls: you're right. for some reason, GC considers those two accounts in EUR...tried to rename them, re-check that they're set as HRK, but it does help. any clue?
15:45:23 <gour> in any case, i consider that GC should prevent me having non-balanced transactions?
15:49:17 <gour> *it does not help
16:01:47 <jralls> gour: I think that only one, Liabilities:Barhi is in EUR, and that GC does think that they're balanced because of the exchange rate. You'll probably need to right-click the transaction (or the "other account" split if in split view) and select Edit Exchange Rate to reset the commodities after fixing the currency.
16:06:03 <gour> jralls: what do you mean by 'after fixing the currency' since the currency is set to HRK?
16:10:51 <gour> i'm looking in the source, and for account 'Barhi' it is said: <cmdty:id>HRK</cmdty:id>
16:13:18 <gour> however, source also says: <cmdty:id>EUR</cmdty:id> for that transaction. how to resolve that?
16:35:42 <gour> i'm going to sleep...will post to the list tomorrow...
16:35:46 *** gour has quit IRC
16:43:53 *** rubdos has quit IRC
17:49:31 *** zippity has joined #gnucash
17:50:12 *** zippity has quit IRC
18:12:22 *** CharlesIC has joined #gnucash
18:12:26 <CharlesIC> hello
18:12:35 <CharlesIC> for some reason, on one of my credit card accounts now, gnucash is not pulling any new transactions
18:12:37 <CharlesIC> saying there are none?
18:14:48 *** ErKa has quit IRC
18:20:30 <CharlesIC> Status for transaction statement request: Account not found (Code 2003, severity "ERROR")
18:20:30 <CharlesIC> The specified account number does not correspond to one of the user's accounts.
18:23:49 <jralls> CharelsIC: Sounds like you got a new card number. You'll need to change it in the online banking wizard.
18:30:01 <CharlesIC> oh, that makes sense
18:30:09 <CharlesIC> you are right, but how do i do that?
18:30:18 <CharlesIC> the card # is the account #?
18:31:34 <CharlesIC> "account id" is the credit card #?
18:32:42 <jralls> CharlesIC: Yes, the card # is the account #. Pick Tools>Online Banking Setup, go to the second page and start the AQBanking Wizard.
18:33:08 <CharlesIC> jralls, well, the expiration date changed, but it looks like the CC name is correct
18:33:21 <CharlesIC> ok, from aqbanking wizard
18:34:26 <jralls> Right, in the accounts tab. But if the number is the same then there's something else going on. Does the account number match in the AQBanking session window?
18:36:35 <CharlesIC> ok, under accounts
18:36:43 <CharlesIC> the account number is the same as CC
18:37:00 <CharlesIC> (i did recently get a new AMEX, but the cc is the same, only expiration date changed and it has a chip)
18:40:43 <CharlesIC> retrieve account list isn't doing anything
18:40:54 <CharlesIC> under accounts, i deleted the account
18:40:58 <CharlesIC> the amex account
18:41:02 <CharlesIC> i just wanted to readd it
18:41:17 <jralls> On the third page of the Setup Online Banking Assistant is a mapping between account numbers and GnuCash accounts. Make sure that that hasn't gotten messed up. Then look at the session window (you might want to check the "don't close" box) and make sure that Amex is using the card number.
18:41:49 <jralls> Not all banks support "get accounts" via OFX.
18:42:47 <CharlesIC> oh ok
18:42:55 <CharlesIC> i thought this one did before
18:42:57 <CharlesIC> it did in the past
18:43:48 <CharlesIC> The server successfully processed the request.
18:43:48 <CharlesIC> 17:43:34 Status for account info request: Success (Code 0, severity "INFO")
18:43:48 <CharlesIC> The server successfully processed the request.
18:43:49 <CharlesIC> 17:43:34 Operation finished, you can now close this window.
18:43:52 <CharlesIC> but it didn't show any accounts
18:45:52 <jralls> CharelsIC: Rats. See if there's anything in the TraceFile (see http://wiki.gnucash.org/wiki/Tracefile if you don't know where to find it).
18:47:24 <CharlesIC> i just readded account manually, and did get balance
18:47:25 <CharlesIC> Status for transaction statement request: Account not found (Code 2003, severity "ERROR")
18:47:25 <CharlesIC> The specified account number does not correspond to one of the user's accounts.
18:49:09 <CharlesIC> as far as i know, the only thing that changed is the expiration date
18:50:57 <CharlesIC> i emailed the bank
18:51:13 <jralls> Looks like that's an OFX response error from Amex. Odd that it would respond with that and give you the balance anyway.
18:51:22 <CharlesIC> it didn't give me the balance
18:51:24 <CharlesIC> i requested it
18:51:32 <CharlesIC> but im sure in the past that the same bank provided the account list when i requested it
18:51:45 <CharlesIC> i have 3 account with bank. checking, savings, amex
18:52:42 <jralls> Maybe the bank changed their software. You could call their customer service and pretend you're using an old version of Quicken.
18:53:01 <CharlesIC> im fairly sure its since my new amex came
18:53:57 <CharlesIC> i just added the user again
18:54:04 <CharlesIC> for the bank, and did retrieve accounts, and it said this
18:54:21 <CharlesIC> http://fpaste.org/278886/44477684/
18:56:11 *** mlncn_ has quit IRC
18:57:26 <jralls> And didn't actually tell you anything, I suppose.
18:57:38 <CharlesIC> correct
19:00:17 <jralls> Sounds like they did a software change, though it's possible that they're just down right now. It might be that they've bumped the required Quicken version and you need to change the protocol settings.
19:00:20 <CharlesIC> "under server capabilities check the following"
19:00:28 <CharlesIC> http://wiki.gnucash.org/wiki/OFX_Direct_Connect_Bank_Settings
19:00:32 <CharlesIC> Under Server Capabilities Check the following:
19:00:33 <CharlesIC> Supports Account List Download
19:00:33 <CharlesIC> Supports Statement Download
19:00:37 <CharlesIC> where is "server capabilities?"
19:01:13 <jralls> I think in the aqbanking user edit somewhere. Give me a sec to look.
19:02:38 <CharlesIC> i saw it before, but dont see it now
19:03:05 <jralls> I dont' see it either. It might be something from an older version of AQBanking.
19:04:11 <CharlesIC> ok, i will bbl
19:04:12 <CharlesIC> thanks
19:11:30 *** warlord has quit IRC
20:31:16 *** mlncn_ has joined #gnucash
20:48:48 *** autoditac__ has quit IRC
20:50:10 *** storyjesse has joined #gnucash
20:58:38 *** warlord has joined #gnucash
20:58:40 *** gncbot sets mode: +o warlord
21:01:30 *** storyjesse has quit IRC