2014-08-25 GnuCash IRC logs
00:08:24 *** GabrieleV_ has joined #gnucash
00:08:41 *** GabrieleV has quit IRC
00:08:41 *** GabrieleV_ is now known as GabrieleV
00:23:24 *** GabrieleV_ has joined #gnucash
00:23:31 *** GabrieleV has quit IRC
00:23:31 *** GabrieleV_ is now known as GabrieleV
00:37:41 *** kpreid has quit IRC
00:38:00 *** kpreid has joined #gnucash
01:12:55 *** GabrieleV_ has joined #gnucash
01:13:29 *** GabrieleV has quit IRC
01:13:29 *** GabrieleV_ is now known as GabrieleV
01:16:48 *** fell has quit IRC
01:30:40 *** mlncn has quit IRC
01:34:15 *** jimvideo has quit IRC
02:02:24 *** MechtiIde has joined #gnucash
02:14:37 *** Krzysiek_K has joined #gnucash
02:34:31 *** O01eg has quit IRC
02:46:35 *** wol has joined #gnucash
03:00:18 *** ryanakca has joined #gnucash
03:00:59 <ryanakca> Is there a way I can programmatically (or automatedly) move transactions between accounts with different currencies?
03:01:09 <ryanakca> Copy/pasting doesn't take into account the exchange rate.
03:08:53 <ryanakca> ... also, importing a CSV file from my bank had all transactions listed as deposits instead of withdrawls. Is there an easy way to fix this?
03:32:52 *** Unhammer has joined #gnucash
03:34:49 <Unhammer> If I've added a bunch of transactions with only the sum, can I later auto-split them to pull out VAT?
03:35:43 <Unhammer> (instead of manually going through all of them and splitting)
03:36:58 <Unhammer> Also, is there a way to by default pull out VAT when I add an outgoing or incoming transaction?
03:37:40 <Unhammer> Like for a certain account, I would like all transactions I add to be split s.t. 25 % goes to the VAT account
03:46:13 *** DimStar_ has joined #gnucash
03:49:41 *** DimStar has quit IRC
04:08:53 *** gjanssens has joined #gnucash
04:08:54 *** gncbot sets mode: +o gjanssens
04:23:40 *** wol has quit IRC
04:25:13 *** DimStar_ is now known as DimStar
04:27:26 *** GabrieleV_ has joined #gnucash
04:27:59 *** GabrieleV has quit IRC
04:27:59 *** GabrieleV_ is now known as GabrieleV
04:48:50 *** wol has joined #gnucash
05:38:10 *** fell has joined #gnucash
05:38:10 *** gncbot sets mode: +o fell
06:48:35 *** Jimraehl1 has left #gnucash
06:49:04 *** Jimraehl1 has joined #gnucash
07:29:50 *** mlncn has joined #gnucash
07:52:57 *** GabrieleV_ has joined #gnucash
07:53:00 *** GabrieleV has quit IRC
07:53:00 *** GabrieleV_ is now known as GabrieleV
08:11:48 *** fell_ has joined #gnucash
08:11:48 *** gncbot sets mode: +o fell_
08:20:43 *** fell has quit IRC
08:33:12 <warlord> ryanakca: No, you need to manually do it, especially because you need to enter in/change the exchange rate.
08:33:32 <warlord> as for your CSV -- sounds like the numbers were all negative, or in the 'wrong column'.
08:33:45 <warlord> (i.e., you assigned them to debits instead of credits)?
08:34:20 <warlord> Unhammer: no, the only place toauto-compute VAT (or any tax) is via the business invoice/bill feature.
08:37:27 <ryanakca> warlord: Yup, they were all negative.
08:38:21 <ryanakca> I managed to get a rather decent rythm going by using the "Find" feature to gather up all of the ones that needed to be moved to a particular account; I could then just paste the destination account name in and be done with it.
08:41:21 <warlord> ryanakca: yeah, that would do it.
08:42:37 *** mlncn has quit IRC
08:47:20 <Unhammer> warlord, would it make sense to make a plugin or something so I could e.g. just select a transaction and hit my "auto-VAT" button?
08:48:53 <Unhammer> or, is it in general possible/easy to make plugins/scripts like that
08:55:53 <Unhammer> in say scheme/python
08:56:29 <warlord> Unhammer: it might make sense... and yes, you could possibly do something like that in Scheme. (and possibly python, but that wouldn't be as cross platform).
08:58:31 <warlord> I just dont know if all the right hooks are in place to do it, however.
09:02:09 <Unhammer> would I have to build my own gnucash or can I test on the apt-getted one?
09:02:30 <Unhammer> (also, where are the plugin docs? having a hard time duckduckgoing them)
09:03:54 *** wol has quit IRC
09:04:44 <warlord> Unhammer: if you do scheme then generally, no.. But there are no "docs" per se.. GnuCash doesn't have a stable "API". The best thing you've got is the C API docs
09:05:09 <warlord> the scheme API is just the wrapped C API
09:05:19 <warlord> But I dont think there is anything "published" per se
09:09:14 *** mlncn has joined #gnucash
09:12:56 <Unhammer> http://wiki.gnucash.org/wiki/Custom_Reports looks helpful though
09:14:02 *** mlncn-agaric has joined #gnucash
09:14:13 <warlord> there is that, too
09:14:35 *** mlncn has quit IRC
09:52:12 *** wol has joined #gnucash
10:07:48 *** warlord has quit IRC
10:08:51 *** warlord has joined #gnucash
10:08:51 *** gncbot sets mode: +o warlord
10:48:02 *** GabrieleV_ has joined #gnucash
10:48:02 *** GabrieleV has quit IRC
10:48:02 *** GabrieleV_ is now known as GabrieleV
10:48:33 *** O01eg has joined #gnucash
11:52:10 *** warlord2 has joined #gnucash
11:55:01 <warlord2> @op
11:55:01 <gncbot> warlord2: Error: You don't have the #gnucash,op capability. If you think that you should have this capability, be sure that you are identified before trying again. The 'whoami' command can tell you if you're identified.
11:55:07 <warlord2> grr..
11:56:21 *** mlncn-agaric has quit IRC
11:59:58 *** warlord has quit IRC
12:05:24 *** warlord2 is now known as warlord
12:05:26 <warlord> @op
12:05:26 *** gncbot sets mode: +o warlord
12:08:38 *** MechtiIde has quit IRC
12:09:32 *** mlncn-agaric has joined #gnucash
12:16:45 *** wol has quit IRC
12:22:37 *** jimvideo has joined #gnucash
12:24:56 <warlord> yay, new AP installed and temporarily deployed.
12:40:32 *** skomorokh_ has quit IRC
12:40:39 *** skomorokh has joined #gnucash
12:54:02 *** purplefishies has joined #gnucash
12:59:06 *** StuM has quit IRC
12:59:21 <purplefishies> Hi , I have a ? Is there a Best Practices page that could address the best way to handle a case where you've set an initial balance, but want to import QIF files of transactions that occured before that initial balance ? This is the case where you would like to add older financial transactions just for record keeping
13:02:47 <gjanssens> purplefishies: I don't of a Best Practises
13:03:35 <gjanssens> However I would remove the opening balance you set, import the transactions you want and set the real opening balance from before the first transaction you imported
13:03:55 <gjanssens> An opening balance only makes sense at the beginning or your account history in GnuCash
13:04:22 *** access has joined #gnucash
13:04:45 <gjanssens> Ok, English lesson requested.
13:05:14 <gjanssens> I have an invoice (say for $100) and a credit note (say for $50)
13:05:17 *** access has quit IRC
13:05:25 <purplefishies> just to clarify, I would import all the new QIFs, then go delete the initial balance, and then I should be able to add a brand new initial balance .
13:05:33 <gjanssens> So the net balance is the customer owes me $50
13:05:50 <gjanssens> But I wonder how do you call what the credit note does to the invoice ?
13:06:00 <gjanssens> Does it "balance out" the invoice ?
13:06:06 <gjanssens> Doest it "pay" the invoice ?
13:06:23 <gjanssens> I'm having a hard time finding the proper word for this.
13:06:47 <gjanssens> purplefishies that's what I propose indeed.
13:07:12 <gjanssens> An initial balance is just a transaction as any other
13:07:26 <warlord> purplefishies: an opening balance is just a regular transaction to a "special" (equity) account. You can reset it whenever you want. However by definition the O-B transaction is your opening balance, and you have *no* transactions before it.
13:07:39 *** jralls has quit IRC
13:07:47 <warlord> gjanssens: offsets? "credits"?
13:08:09 <warlord> Actually, the credit-note crediting the invoice actually makes sense in laymans terms.
13:08:10 *** jralls has joined #gnucash
13:08:11 *** gncbot sets mode: +o jralls
13:08:15 <gjanssens> warlord: offsets may be a good word as it can work in two directions
13:08:58 <gjanssens> I mean if I have a bigger credit note and a smaller invoice I'd like to be able to say the invoice "offsets" the credit note
13:09:40 <gjanssens> I'm looking for a word that I can use in an automatically generated memo when one document is used to balance out (part of) another document
13:11:09 <gjanssens> Something like "Offset between documents: doc A - doc B"
13:11:27 <gjanssens> Where doc A and doc B can be either an invoice or a credit note
13:11:46 <gjanssens> Would "Credit" work in that sentence as well ?
13:12:02 <warlord> Sure, offset works in that context
13:12:15 <gjanssens> Wonderful. I'll use that then. Tx
13:12:21 <warlord> np
13:13:11 <gjanssens> The memo like that will surely be more useful than the current "Internal link between invoice and payment lots" which confuses users all the time.
13:14:13 <purplefishies> ? is there a user contributed scripts section of gnucash ? I've written some scripts that automate downloading statements from several institutions and I would be happy to share them. I use these because my bank wants to charge me a monthly fee for using online banking
13:17:09 *** kythera has joined #gnucash
13:20:23 <kythera> I live in 2 diffrent country's, I have normal expenses like grocries and stuff in both of their currency's. I need a good way to keep track of what I spend. One solution I thought about was to record the exchange rate when I transfer money And everytime I make a transction from "BRL Cash" -> "EUR groceries" I would use that exchange rate. It works but it is difficult to keep track of the exchange rate. Another solution was to create top hierachy's denoti
13:21:51 <warlord> purplefishies: the wiki, or we could put it into the gnucash sources.
13:23:18 <warlord> kythera: your question ended at "top hierachy's denoti".. But basicaly you have two options: convert everything to a "home" currency, or have duplicate expense trees
13:24:06 *** kythera_ has joined #gnucash
13:24:26 *** fell_ is now known as fell
13:25:09 <kythera_> warlord: convert everything to a home currency would be simpler in my case (I travel alot). But does that mean that my assets like cash should also be in the home currency?
13:25:50 <kythera_> Actually the seperate currency's are easier... I guess I will try them both and stop using what does not work.. thanks!
13:26:07 <fell> Or have leaves for different currencies in the account tree - that's how I have it.
13:26:20 *** mlncn-agaric has quit IRC
13:26:20 *** benjamin-agaric has joined #gnucash
13:27:07 <kythera_> fell: do you do it like this: {expenses:groceries:usd,expenses:groceries:eur} or like this {expenses:usd:groceries,expenes:eur:groceries}
13:27:09 <warlord> kythera: I travel a lot, too. what I do is have assets for each of my "local currencies", but I denote it in USD (my home currency).
13:27:10 <kythera_> what would be best?
13:27:35 <warlord> I put the "local currency" amount in the transaction descriptions, sometimes along with the exchange rates.
13:28:12 <warlord> kythera: that choice depends on whether you care more about total amount of groceries spent or total amount of usd spent.
13:28:23 <warlord> (primarily -- you can run a report to compute the other value)
13:29:55 <kythera_> thank you for the quick answers! I guess I know enough to continue.
13:29:56 *** kythera_ has quit IRC
13:33:18 *** kythera has quit IRC
13:35:28 *** lowprof has joined #gnucash
13:49:22 *** agaric has joined #gnucash
13:50:08 *** benjamin-agaric has quit IRC
13:54:28 *** cigarshark has joined #gnucash
13:55:45 *** mlncn has joined #gnucash
13:55:45 *** agaric has quit IRC
13:56:33 <purplefishies> Yes , thank you all for your help
14:04:11 <warlord> you're welcome
14:04:35 *** Bodhi-Baum has joined #gnucash
14:16:05 *** Bodhi-Baum has quit IRC
14:33:50 *** wizkid238 has quit IRC
14:38:56 *** mlncn has quit IRC
14:42:15 *** rpg has joined #gnucash
14:53:57 *** warlord has quit IRC
14:54:08 *** warlord has joined #gnucash
14:54:08 *** gncbot sets mode: +o warlord
14:54:42 *** mlncn has joined #gnucash
14:55:25 *** kythera has joined #gnucash
14:56:55 <kythera> warlord, A quick question I noticed If I wanted to use separate accounts for the currency that when making a budget, The budget is only in one currency. Is this ignorance on my behalf or is there simply not support for budgeting with multiple currency's?
14:57:53 <kythera> I assume the solution is to convert it manually to one currency, Is this correct
15:03:31 <warlord> I honestly don't know -- I've never used the gnucash budget features.
15:10:31 *** purplefishies has quit IRC
15:15:00 *** wol has joined #gnucash
15:19:31 *** lmat has joined #gnucash
15:26:24 *** kythera_ has joined #gnucash
15:32:04 *** kythera has quit IRC
15:41:30 *** lowprof has quit IRC
15:58:03 *** GabrieleV_ has joined #gnucash
15:58:14 *** GabrieleV has quit IRC
15:58:14 *** GabrieleV_ is now known as GabrieleV
16:13:02 *** GabrieleV_ has joined #gnucash
16:13:03 *** GabrieleV has quit IRC
16:13:03 *** GabrieleV_ is now known as GabrieleV
16:44:17 *** wol has quit IRC
16:49:55 *** aqua___ has joined #gnucash
16:50:12 *** StuM has joined #gnucash
16:51:15 *** rpg has quit IRC
17:00:13 *** StuM has quit IRC
17:03:08 *** gjanssens has quit IRC
17:05:24 *** lmat has quit IRC
17:10:13 *** fell has quit IRC
17:19:04 *** aqua___ has quit IRC
19:04:19 *** mlncn has quit IRC
19:04:22 *** mlncn-agaric has joined #gnucash
19:16:18 <jethrogb> the organization I work for writes checks that are sometimes cashed after 60-90 days
19:16:33 <jethrogb> when I then import the bank transactions, the importer is unable to match these transactions
19:16:46 <jethrogb> is there any way to increase the time period that the matcher uses?
19:17:05 <jethrogb> this is GnuCash 2.4.13
19:39:26 *** jim has joined #gnucash
19:41:16 <jim> Need help with entering social security as income. what account do I need. or should I pretend it is a salary
19:43:27 *** mlncn-agaric has quit IRC
19:48:00 *** jralls has quit IRC
19:49:25 *** jralls has joined #gnucash
19:49:25 *** gncbot sets mode: +o jralls
19:50:22 *** jim has quit IRC
20:18:53 *** mlncn-agaric has joined #gnucash
20:23:18 *** warlord has quit IRC
20:23:49 *** warlord has joined #gnucash
20:23:49 *** gncbot sets mode: +o warlord
20:28:08 <warlord> jethrogb: easy answer: don't depend on the importer to clear the transactions, just reconcile them at the end of the month from the statement.
20:46:19 <jethrogb> warlord: sure, but my bank always exports all transactions
20:46:50 <jethrogb> so these late-cashed-check transactions come up in red every time I import new data
20:51:30 *** mlncn-agaric has quit IRC
20:57:53 *** cigarshark has quit IRC
20:59:19 *** StuM has joined #gnucash
21:05:58 <jimvideo> One of my friends used to dress as Chuck E. Cheese at that pizzeria.
21:40:46 *** mlncn-agaric has joined #gnucash
21:54:42 *** fell has joined #gnucash
21:54:42 *** gncbot sets mode: +o fell
22:00:48 *** kpreid has quit IRC
22:00:58 *** kpreid has joined #gnucash
22:17:36 *** GabrieleV_ has joined #gnucash
22:17:37 *** GabrieleV has quit IRC
22:17:37 *** GabrieleV_ is now known as GabrieleV
22:27:09 *** mlncn-agaric has quit IRC
23:02:49 *** fell has quit IRC
23:09:06 *** mlncn-agaric has joined #gnucash
23:22:09 *** mlncn-agaric has quit IRC
23:47:05 *** GabrieleV_ has joined #gnucash
23:47:08 *** GabrieleV has quit IRC
23:47:08 *** GabrieleV_ is now known as GabrieleV