2015-01-12 GnuCash IRC logs
00:27:30 *** fell has quit IRC
00:39:42 *** MechtiIde has joined #gnucash
01:28:19 *** MechtiIde has quit IRC
01:46:26 *** cartsoftware has quit IRC
01:48:20 *** GabrieleV_ has joined #gnucash
01:48:27 *** GabrieleV has quit IRC
01:48:27 *** GabrieleV_ is now known as GabrieleV
02:01:24 *** gour has joined #gnucash
02:01:31 *** cartsoftware has joined #gnucash
02:13:25 *** cartsoftware has quit IRC
02:15:59 *** ErKa has quit IRC
02:23:28 *** StuM has quit IRC
02:37:57 *** cartsoftware has joined #gnucash
02:41:20 *** Krzysiek_K has joined #gnucash
02:46:34 *** pacon has joined #gnucash
03:12:44 *** wol has joined #gnucash
03:13:22 *** MechtiIde has joined #gnucash
03:14:42 *** Krzysiek_K has quit IRC
04:12:03 *** wol has quit IRC
04:46:46 *** Ard0nik has joined #gnucash
04:55:44 *** Caesar has quit IRC
05:09:34 *** len has quit IRC
05:22:19 *** uXus has quit IRC
05:32:09 *** Caesar has joined #gnucash
05:32:33 *** uXus has joined #gnucash
05:40:32 *** Ard0nik has quit IRC
05:44:15 *** uXus has quit IRC
05:46:51 *** uXus has joined #gnucash
05:48:09 *** gour_ has joined #gnucash
05:48:45 *** uXus has quit IRC
05:56:48 *** gour has quit IRC
06:19:16 *** nomeata has joined #gnucash
06:19:29 *** Jimraehl1 has left #gnucash
06:19:44 *** pacon has quit IRC
06:19:54 *** Jimraehl1 has joined #gnucash
06:30:47 *** himaxx has joined #gnucash
06:35:29 *** himaxx has quit IRC
06:41:14 *** andy has quit IRC
06:55:03 *** andy has joined #gnucash
07:09:01 *** nomeata has quit IRC
07:12:41 *** fell has joined #gnucash
07:12:41 *** gncbot sets mode: +o fell
07:22:50 *** rickoehn has joined #gnucash
08:07:21 *** warlord has joined #gnucash
08:07:21 *** gncbot sets mode: +o warlord
08:11:04 *** wol has joined #gnucash
08:23:24 *** ErKa has joined #gnucash
08:35:41 *** MechtiIde has quit IRC
08:52:04 *** MechtiIde has joined #gnucash
08:57:16 *** aqua___ has joined #gnucash
08:59:57 *** wol1 has joined #gnucash
09:09:11 *** wol has quit IRC
09:53:11 *** aqua___ has quit IRC
10:01:28 *** wol1 has quit IRC
10:06:23 *** mlncn has joined #gnucash
10:14:32 *** MechtiIde has quit IRC
10:24:15 *** cartsoftware has quit IRC
10:39:30 *** cartsoftware has joined #gnucash
10:39:57 *** wol has joined #gnucash
10:44:48 *** nomeata has joined #gnucash
10:57:28 *** O01eg has joined #gnucash
10:58:15 *** wol has quit IRC
11:16:00 *** jchonig has joined #gnucash
11:35:28 *** chrne has joined #gnucash
11:37:48 <chrne> hi. i need to get an account report for the last quarter that shows the sum of each account (basically the sums of the main view but only considering transactions of the last quarter). the main problem her is that all reports that could do this don't have a "last quarter" option. any suggestions?
11:45:38 <jralls> chrne: You actually need two reports, a Balance Sheet for the last day of the report and a Profit & Loss statement for the quarter. Report options include a variety of date options including arbitrary dates. First run the reports with the defaults from the menu, then select "Options" from the toolbar and adjust the dates to what you want. You'll probably want to look over the other options as well.
11:49:37 *** frank has joined #gnucash
11:54:28 <chrne> jralls: thanks, the profit & loss report is able to show the sums by quarter!
11:56:07 <jralls> chrne: Yes, for the income and expense accounts. But it doesn't tell you the balances of the asset and liability accounts, so it's only half the picture.
11:58:36 <chrne> jralls: I see. But sadly the Balance Sheet does not have a "quarter option".
11:59:13 <jralls> chrne: A Balance Sheet is a snapshot for a particular day. Just specify the last day of the quarter.
12:00:20 <chrne> jralls: ah sorry, I guess my question was not clear: I don't need the balance at the last date, but the sum of transactions of the quarter (first day to last day)
12:01:05 <jralls> chrne: Besides, it does provide "End of the Previous Quarter" and "End of the Current Quarter".
12:04:05 <jralls> chrne: OK. You probably want the Cash Flow report then rather than the P & L.
12:08:33 <jralls> chrne: For that you'll want to include all of your asset accounts and perhaps liability accounts if you're buying stuff on credit.
12:10:17 <chrne> jralls: the report won't show the sums for the parent accounts. I guess nobody uses gnucash the way I do ;)
12:17:06 <warlord> chrne: Your other option is to run two balance sheet reports, one for the start of the quarter and one for the end; then load them into a spreadsheet or word processor to compute the changs.
12:17:08 <warlord> changes
12:17:34 *** frank1 has joined #gnucash
12:21:19 *** You4eea has joined #gnucash
12:21:27 <chrne> warlord: yes, but I hoped that there was a better way to do this. I mean, it's just a basic report :( But thanks anyway for your help!
12:22:01 *** frank has quit IRC
12:22:19 <warlord> chrne: it's actually *not* a "basic report"
12:29:39 *** frank1 has quit IRC
12:35:02 <jralls> chrme: Basic reports require that you follow standard accounting practices, and it appears that perhaps you are not. One more report to try is the Transaction Report. Select all of your Asset and Liability accounts and on the Sorting page of the options set the Secondary Key to "Other account name".
12:36:27 <jralls> The only problem with that report is that it doesn't handle well transactions with more than two splits.
12:46:18 <chrne> jralls: yeah I guess that's the main problem. I created sub accounts for my customers and it seems it's not the way it's usually done.
12:47:53 <chrne> but without sub accounts, I loose information about the sums of transactions per customer
12:48:02 <jralls> Not usually. What kind of sub accounts? If they're all income and expense, the P & L won't care.
12:48:57 <jralls> The catch with P & L is that it doesn't capture transactions between asset, liability, and equity accounts.
12:54:16 <chrne> jralls: you're right. I need this information for both the customer accounts (income) and some tax accounts (liabilities)
12:54:57 <chrne> and some asset accounts
12:55:34 <jralls> chrne: I think the transaction report is probably the closest to meeting your needs.
12:58:29 <chrne> jralls: yeah, still i have to sum the sub accounts "by hand". thanks anyway :) maybe I find another solution
13:00:39 <jralls> chrne: Well, by spreadsheet. You might ask on gnucash.users. There are some pretty clever and experienced users there, though most of them seem to think that a spreadsheet is a necessary adjunct to GnuCash.
13:07:50 <chrne> jralls: I guess I'll have a look at the custom scheme reports before touching a spreadsheet to do this ;) thanks and have a nice day/night!
13:07:54 *** chrne has left #gnucash
13:19:21 *** aqua___ has joined #gnucash
13:26:52 *** rubdos has joined #gnucash
13:28:02 *** Krzysiek_K has joined #gnucash
13:31:18 *** rubdos has quit IRC
13:50:16 *** nomeata has quit IRC
13:50:57 *** O01eg has quit IRC
13:58:11 *** O01eg has joined #gnucash
14:11:34 *** andy_ has joined #gnucash
14:14:39 *** andy has quit IRC
14:18:20 *** lmat has joined #gnucash
14:25:42 <You4eea> hey all.. is there a way to change the transfer account on multiple transactions.. for example.. I have some entries for starbuc- they are all Imbalance-USD right now, but they all need to be in expense meals.. is there a way to do this without have to do them each individually?
14:28:13 <warlord> You4eea: Do *all* your transactions in Imbalance go to the *same* other account?
14:29:21 *** mlncn has quit IRC
14:32:03 <You4eea> no they all goto different accounts..
14:32:16 <You4eea> but the starbucks all goto expense/meals..
14:32:57 <kimmo2_> it's official. I have ocd. I just realized I have 170 (!) accounts under groceries
14:33:53 <You4eea> LOL... yeah.. that is pretty extreem, but atleast you'll know who much jelly you eat.. :-)
14:34:46 <kimmo2_> indeed
14:34:47 <lmat> haha
14:34:59 <lmat> kimmo2_: I have successfully resisted *that* urge!
14:35:14 <You4eea> or more correctly how much you spend on jelly... I have alway thought if I can get just 1 to 3 years of accurrate data to see how the market fluxuates I would then be a good invester..
14:35:51 <kimmo2_> I just realized it, when I noticed I had 6 different accounts for meats...
14:36:13 <You4eea> corrolate it with some cacti graphing of weather condition sun rotation.. only then would investing be wise :-)
14:36:20 <kimmo2_> then again on the sunny side, I now have data to show my wife where all the money really goes
14:36:41 <You4eea> LOL... thats what my grandpa used to say..
14:36:54 <kimmo2_> not surprisingly, "snacks.candy", "snacks.soda", "snacks.chips" are leading the race
14:37:22 <kimmo2_> also "expenses.food.takeout.*" are in the race
14:37:48 <You4eea> ya... the good thing is that you can right takeout off but not grociers
14:38:02 <kimmo2_> but what really freaks me out is the 4.17 in espenses.food.groceries.plastic_bags
14:38:28 <You4eea> LOL...
14:38:56 <You4eea> hey are you tracking tax also? i.e. state sales, gas, etc...
14:39:22 <kimmo2_> nope
14:39:48 <kimmo2_> we have VAT 24%, on food 14% so it would be pretty easy to calculate
14:39:58 <kimmo2_> I don't buy gas, I drive company wheels
14:40:42 <You4eea> I have been trying to figure out a means.. dispite what is said about taxes in America.. I still think we pay as high as anyone else and we get less for it..
14:41:42 <kimmo2_> it's pretty hard to figure out
14:42:02 <kimmo2_> since the tax systems are not exactly comparable
14:42:29 <warlord> You4eea: Sorry, there is no way to move a partial set of transaction en-masse. You can move *all* transactions from one account into another, or you have to do it one-by-one.
14:43:26 <kimmo2_> ihtfp
14:45:02 <You4eea> speaking of food.. wifes calling my lunch is ready..
14:45:27 <kimmo2_> lucky bastard
14:45:42 <kimmo2_> how about them patriots
14:54:29 <warlord> kimmo2_: ???
15:01:41 *** lmat_ has joined #gnucash
15:04:15 <kimmo2_> warlord, ihtfp, tfp meaning finland
15:04:16 <kimmo2_> ;)
15:05:05 <warlord> This Fine Place can mean anywhere ;)
15:06:53 <kimmo2_> yeah
15:07:24 <kimmo2_> emphasis on This, usually meaning to a location close to oneself
15:08:35 <warlord> No, emphasis on "FINE", because the IH is usually "I Hate"...
15:12:02 *** fell_ has joined #gnucash
15:12:02 *** gncbot sets mode: +o fell_
15:12:31 *** gour_ is now known as gour
15:12:55 *** gour has left #gnucash
15:13:39 <kimmo2_> that's what I said... ;)
15:20:44 *** fell has quit IRC
15:25:19 <You4eea> ding... I was really hoping there was a way around that.. I have thousands of transactions that I need to move around in groups.. I imported from quicken and a houndreds of items went to Imbalance-USD
15:27:39 <kimmo2_> that's what you get for being a quicken user
15:28:04 <You4eea> hey hey...
15:28:26 <You4eea> is there a way to export then modify and then import back it?
15:29:44 <kimmo2_> umm, export what?
15:30:14 <You4eea> testing now.. --- the Imbalance account
15:35:10 *** Gbarr1 has joined #gnucash
15:35:14 *** rickoehn1 has joined #gnucash
15:37:54 *** andy__ has joined #gnucash
15:38:40 *** jchonig_ has joined #gnucash
15:39:35 *** Coderjoe_ has joined #gnucash
15:41:51 <You4eea> Ok.. here is a wierd one... when I goto menu>file>open and then goto my c:/ drive, I can see files in the open dialog box that I can't see in window explore file manager... I discovered this when I exported a file to my c:/ drive, I then went to open it and it was not there.. but I can see it in the open dialog window..
15:42:09 *** mikee_ has joined #gnucash
15:42:43 *** lmat has quit IRC
15:43:12 *** kim27` has joined #gnucash
15:43:19 *** andy_ has quit IRC
15:43:19 *** Krzysiek_K has quit IRC
15:43:19 *** jchonig has quit IRC
15:43:19 *** warlord has quit IRC
15:43:19 *** rickoehn has quit IRC
15:43:19 *** Jimraehl1 has quit IRC
15:43:19 *** Caesar has quit IRC
15:43:19 *** anything has quit IRC
15:43:19 *** wizkid238 has quit IRC
15:43:19 *** mikee has quit IRC
15:43:19 *** Gbarr has quit IRC
15:43:19 *** kim27 has quit IRC
15:43:19 *** Infiltrator has quit IRC
15:43:19 *** Coderjoe has quit IRC
15:43:19 *** mikee_ is now known as mikee
15:45:15 *** Infiltrator has joined #gnucash
15:52:13 *** Caesar has joined #gnucash
15:53:36 *** wizkid238 has joined #gnucash
15:53:37 *** warlord has joined #gnucash
15:53:38 *** gncbot sets mode: +o warlord
15:53:41 *** Krzysiek_K has joined #gnucash
15:53:56 *** len has joined #gnucash
16:11:01 <warlord> Yay, net splits
16:37:05 *** KaiForce has quit IRC
16:48:20 *** andy__ has quit IRC
16:49:10 *** andy__ has joined #gnucash
16:52:36 *** mlncn has joined #gnucash
16:55:17 *** aqua___ has quit IRC
16:59:55 *** irc has joined #gnucash
17:01:45 <irc> hey guys. any information on the c++ rewrite (http://wiki.gnucash.org/wiki/C%2B%2B) -- anyone know the status?
17:02:23 *** irc is now known as cantsin
17:16:03 <warlord> cantsin: it is in progress
17:18:44 *** StuM has joined #gnucash
17:19:07 <cantsin> warlord: good to know! is the c++ part a high priority at present? i want to contribute but the C code is a bit difficult to read.
17:19:28 <cantsin> (doesn't help that the documentation is way outdated either)
17:20:41 <cantsin> (for example, i get confused when the comments mention stuff like multi-user support which afaics isn't there at all)
17:22:00 <warlord> define "high priorty".. higher than what?
17:24:33 *** rickoehn1 has quit IRC
17:24:33 <warlord> what docs are you looking at?
17:26:00 <cantsin> warlord: well i see c++ transitions on the roadmap for 2.8.0 but i don't see anything for 2.7.0, so i was wondering if there were higher priority items for 2.7.0.
17:26:45 <warlord> 2.7 will be the alpha tests for 2.8
17:26:53 <cantsin> warlord: https://github.com/Gnucash/gnucash/blob/master/src/engine/Transaction.c#L1657
17:26:54 <cantsin> ah?
17:27:50 <cantsin> okay, so odd release numbers are experimental?
17:28:35 <warlord> yep
17:29:09 <cantsin> okay, so if i wanted to contribute, what would i look at first?
17:32:14 <You4eea> question.. I'm on windows and I can see files through the open dialog box on my c: that I can see in my file manager (windows explorer)... any ideas?
17:34:25 <You4eea> http://prntscr.com/5rrrr3
17:34:31 <warlord> cantsin: jralls and lmat are mostly running it.
17:34:59 <cantsin> warlord: nod, thanks.
17:35:43 <warlord> cantsin: ah, i wouldnt call that a doc. Its more a comment. Sure, some comments are out of date.
17:36:10 <You4eea> the files in red are missing from windows explorer in the list to the right of the image
17:37:01 <cantsin> warlord: yea, i gave up on the docs pretty quickly but i thought at least the comments were up to date :) oh well.
17:37:13 <cantsin> not a problem, just confusing
17:37:40 <warlord> cantsin: um, the docs are definitely up to date.. which is why i asked which docs...
17:38:39 <cantsin> warlord: i see now. i wasn't talking bout the user docs, rather the design documents still in the codebase
17:39:00 <warlord> ah. the doxygen docs are mixed
17:39:22 <warlord> You4eea: i dont understand the issue.
17:39:44 <cantsin> nod. `git blame` helps to get a sense of which parts were recently updated, but yea... most are very old.
17:41:03 <You4eea> I can see files listed on my c: drive using the gnucash file>open dialog box... files I can not see using windows explorer the picture shows this gnucash on the left... and windows eplorer on the right...
17:41:33 <warlord> You4eea: no clue. i dont use windows
17:42:15 <warlord> only 2 of those files are from gnucash.
17:42:45 <You4eea> I know.. which is fine, but I can see them or some of the other in WE
17:46:25 <warlord> WE sucks?
17:46:39 <warlord> maybe a permission or file flag thing?
18:13:54 *** GabrieleV_ has joined #gnucash
18:14:22 *** GabrieleV has quit IRC
18:14:23 *** GabrieleV_ is now known as GabrieleV
18:16:48 *** mlncn has quit IRC
18:30:55 *** warlord has quit IRC
18:49:24 *** GabrieleV_ has joined #gnucash
18:49:28 *** GabrieleV has quit IRC
18:49:28 *** GabrieleV_ is now known as GabrieleV
19:02:09 *** Simon has quit IRC
19:22:17 *** Simon has joined #gnucash
19:24:24 *** GabrieleV_ has joined #gnucash
19:24:25 *** GabrieleV has quit IRC
19:24:25 *** GabrieleV_ is now known as GabrieleV
19:42:22 *** himaxx has joined #gnucash
19:43:46 *** himaxx has quit IRC
20:04:25 *** GabrieleV_ has joined #gnucash
20:04:29 *** GabrieleV has quit IRC
20:04:29 *** GabrieleV_ is now known as GabrieleV
20:35:55 *** josecanuc has joined #gnucash
20:54:48 *** somethingrandom has joined #gnucash
21:02:06 <somethingrandom> Hello lovely folks! I had planned to start using gnucash one year ago, this year I want to start for real. Read through the complete user guide and have entered some past transactions. Didn't use double spending while tracking it on Android. How to best balance my transactions? I'm a bit clueless how to deal with this and the backfilling of data. Thought about just starting fresh this year, but also not sure if I need to calculate the correct amo
21:02:07 <somethingrandom> unt in my checking account on 1.1....
21:05:35 <somethingrandom> Another issue, some spendings are in another currency, my understanding is to best create two sub accounts for an account with multiple currency spending, in the needed currencies. My VISA card get's billed in my local currency based on the VISA exchange rate. How would I best track spendings in non-local currency?
21:06:12 <somethingrandom> Cheers, gnucash is lovely, but a bit intimidating at first.
21:14:01 *** mlncn has joined #gnucash
21:26:24 *** warlord has joined #gnucash
21:26:25 *** gncbot sets mode: +o warlord
21:52:06 *** ajs has joined #gnucash
22:13:52 *** StuM has quit IRC
22:32:21 *** josecanuc has quit IRC
22:45:37 *** somethingrandom has quit IRC
22:46:07 *** ErKa has quit IRC
22:52:17 *** somethingrandom has joined #gnucash
23:09:56 *** GabrieleV_ has joined #gnucash
23:10:01 *** GabrieleV has quit IRC
23:10:01 *** GabrieleV_ is now known as GabrieleV
23:10:25 *** mlncn has quit IRC
23:29:57 *** GabrieleV_ has joined #gnucash
23:29:58 *** GabrieleV has quit IRC
23:29:59 *** GabrieleV_ is now known as GabrieleV
23:35:29 <alexjj> I just started using gnucash this year and decided against back filling data. It would take a lot of time, and whilst maybe useful to see trends I thought it was better just to start using it
23:36:45 <alexjj> I don't use android app (yet) but it might be easiest just to record transactions, export them, email to yourself and then import on desktop then assign the "account"
23:37:45 <alexjj> I don't use much cash so I just use online banking to add transactions
23:39:49 <alexjj> I also use mutliple currencies and if you set your visa account to it's natural currency (your non-local one) then each time you add a transaction and assign it to an expense account (set in your local currency) it'll ask you for the exchange rate
23:40:29 <alexjj> you'd have to use your cc online account to see the exchange rate used per transaction
23:41:05 <alexjj> Also under Tools > Price Editor you can set a rate
23:42:11 <alexjj> Chapter 10 of the guide has some advice on multiple currencies: http://www.gnucash.org/docs/v2.6/C/gnucash-guide.pdf
23:42:41 <alexjj> somethingrandom: