2013-04-12 GnuCash IRC logs
00:05:15 *** vistas has quit IRC
00:14:51 *** benoitg has quit IRC
01:01:14 *** calbasi has joined #gnucash
01:18:42 *** benoitg has joined #gnucash
02:08:28 *** uXus has quit IRC
02:11:41 *** uXus has joined #gnucash
02:18:19 *** benoitg has quit IRC
02:40:16 *** Silly- has joined #gnucash
02:40:32 *** Silly has quit IRC
02:40:32 *** Silly- is now known as Silly
03:02:36 *** Jimraehl has joined #gnucash
03:03:10 *** aqua___ has joined #gnucash
03:03:26 *** diver has joined #gnucash
03:06:47 *** Topcat has joined #gnucash
03:10:14 *** Topcat has quit IRC
03:11:05 *** Topcat has joined #gnucash
03:22:50 *** Topcat has quit IRC
03:23:13 *** Topcat has joined #gnucash
03:28:20 *** Topcat has quit IRC
03:28:47 *** Topcat has joined #gnucash
03:33:46 *** Topcat has quit IRC
03:34:19 *** Topcat has joined #gnucash
03:37:14 *** todd has quit IRC
03:41:14 <diver> Hello guys, I have a question regarding booking GnuCash. I am doing the accounts for a dive club, and have to book incoming membership fees (income) against a cash account (asset). So far so good. However, the membership fees include a bond for equipment people can borrow, which is to be paid back if the member leaves (or forfeit if gear is damaged). How can I make a transaction that allows me to pay cash (all of it) into assets, but also introduces t
03:49:33 *** Topcat has quit IRC
03:49:56 *** Topcat has joined #gnucash
03:54:56 *** Topcat has quit IRC
03:55:49 *** Topcat has joined #gnucash
04:00:50 *** Topcat has quit IRC
04:01:36 *** Topcat has joined #gnucash
04:03:17 *** todd has joined #gnucash
04:11:40 *** Topcat has quit IRC
04:12:20 *** Topcat has joined #gnucash
04:17:20 *** Topcat has quit IRC
04:17:43 *** Topcat has joined #gnucash
04:22:44 *** Topcat has quit IRC
04:23:29 *** Topcat has joined #gnucash
04:24:01 *** todd has quit IRC
04:24:16 *** todd has joined #gnucash
04:24:22 *** fuzzybunny69y has joined #gnucash
04:32:31 *** fuzzybun_ has joined #gnucash
04:34:42 *** fuzzybunny69y has quit IRC
04:39:42 *** fuzzybunny69y has joined #gnucash
04:42:39 *** fuzzybun_ has quit IRC
04:46:23 *** ErKa has joined #gnucash
04:46:38 <aqua___> hi
04:47:20 *** fuzzybun_ has joined #gnucash
04:47:28 <aqua___> I'm using lubuntu 12.10 and i just did the regular apt-get update && upgrade and gnucash disappered
04:47:43 <aqua___> sudo apt-get install gnucash results in:
04:48:03 <aqua___> Paket libaqbanking33 is not avaible
04:48:35 <aqua___> i have (since the update?) libaqbanking34 installed
04:49:45 *** fuzzybunny69y has quit IRC
04:49:51 *** fuzzybun_ is now known as fuzzybunny69y
04:53:38 <aqua___> ok deinstalled liba...34, installed liba...33 from ubuntu.com and installed gnucash
04:54:08 <aqua___> only thing i lost (as far as i see) is my aqbanking-configuration
04:54:32 <aqua___> i'll have to look at the nightly backup
04:54:54 <aqua___> does anybody know, where the questionable files are?
04:57:14 *** fuzzybun_ has joined #gnucash
04:58:54 *** fuzzybunny69y has quit IRC
04:58:56 *** fuzzybun_ is now known as fuzzybunny69y
05:04:47 *** Topcat has quit IRC
05:05:09 *** Topcat has joined #gnucash
05:06:02 *** ErKa has quit IRC
05:07:40 *** fuzzybun_ has joined #gnucash
05:08:57 *** fuzzybunny69y has quit IRC
05:08:58 *** fuzzybun_ is now known as fuzzybunny69y
05:15:59 *** fuzzybun_ has joined #gnucash
05:19:02 *** fuzzybunny69y has quit IRC
05:23:30 *** fuzzybunny69y has joined #gnucash
05:26:04 *** fuzzybun_ has quit IRC
05:26:16 *** fell has joined #gnucash
05:26:16 *** gncbot sets mode: +o fell
05:26:43 *** ErKa has joined #gnucash
05:30:46 *** fuzzybun_ has joined #gnucash
05:31:21 *** fuzzybunny69y has quit IRC
05:31:22 *** fuzzybun_ is now known as fuzzybunny69y
05:37:27 *** ErKa has quit IRC
05:38:58 *** fuzzybun_ has joined #gnucash
05:41:32 *** fuzzybunny69y has quit IRC
05:45:19 *** ErKa has joined #gnucash
05:46:53 *** fuzzybunny69y has joined #gnucash
05:47:29 *** fuzzybun_ has quit IRC
05:55:09 *** ErKa has quit IRC
05:55:22 *** fuzzybun_ has joined #gnucash
05:57:01 *** fuzzybunny69y has quit IRC
05:57:02 *** fuzzybun_ is now known as fuzzybunny69y
06:02:32 *** Topcat has quit IRC
06:03:05 *** Topcat has joined #gnucash
06:04:24 *** fuzzybun_ has joined #gnucash
06:06:31 *** ErKa has joined #gnucash
06:07:19 *** fuzzybunny69y has quit IRC
06:12:00 *** fuzzybunny69y has joined #gnucash
06:13:08 *** fuzzybun_ has quit IRC
06:13:31 *** fuzzybunny69y has quit IRC
06:23:23 *** Topcat has quit IRC
06:23:46 *** Topcat has joined #gnucash
06:33:50 *** Topcat has quit IRC
06:34:24 *** Topcat has joined #gnucash
06:35:09 *** ErKa has quit IRC
06:36:25 <aqua___> hi again
06:37:12 <aqua___> on the command line (aqhbci-tool4 listaccounts) the accounts are avaible, but i can't the the accounts in gnucash via the aqbanking tool
06:37:24 <aqua___> any idea what could be wrong?
06:41:58 *** Jimraehl has left #gnucash
06:54:57 *** Topcat has quit IRC
06:55:32 *** Topcat has joined #gnucash
06:58:33 *** calbasi has left #gnucash
07:02:43 *** daniel_ has joined #gnucash
07:06:38 *** Jimraehl has joined #gnucash
07:20:42 *** Topcat has quit IRC
07:21:20 *** Topcat has joined #gnucash
07:26:21 *** Topcat has quit IRC
07:26:55 *** Topcat has joined #gnucash
07:31:55 *** Topcat has quit IRC
07:32:18 *** Topcat has joined #gnucash
07:40:49 *** ErKa has joined #gnucash
07:47:28 *** Topcat has quit IRC
07:47:50 *** Topcat has joined #gnucash
07:52:52 *** Topcat has quit IRC
07:53:24 *** Topcat has joined #gnucash
07:53:44 *** ErKa has quit IRC
08:03:31 *** Topcat has quit IRC
08:03:54 *** Topcat has joined #gnucash
08:06:43 *** fuzzybunny69y has joined #gnucash
08:07:04 <daniel_> Hi. I have an apartment and I'm paying mortgage for it. I rent it to a friend. I have the accounts Liabilities:Apartment, Expenses:Interests and Income:Rent. How can I graph or report how much I'm gaining or losing monthly considering (Liabilities:Apartment+Expenses:Interests)-Income:Rent. I know that Liabilities are not Expenses, but I can't figure out how to report it.
08:07:19 <daniel_> In other words, the gain or loss between the mortage I pay and the rent I receive.
08:12:23 *** Topcat has quit IRC
08:12:57 *** Topcat has joined #gnucash
08:14:29 *** fuzzybun_ has joined #gnucash
08:16:17 <warlord> diver: your message from 03:41am EDT ended early with: "but also introduces t".
08:17:08 *** fuzzybunny69y has quit IRC
08:17:09 *** fuzzybun_ is now known as fuzzybunny69y
08:17:35 <warlord> diver: The answer would be a split transaction.. The way I would book it (IANAA, so YMMV) would be to debit cash with the full amount, credit income with the dues, and credit Liabilities:Member Bonds with the rest
08:18:42 <warlord> aqua___: they are stored in ~/.banking or ~/.aqbanking. But if the version of AqB changed then you might need to manually reconfigure.. The upgrade of AqB probably "upgraded" your configs.
08:20:34 <warlord> daniel_: You could run a P&L and only include the apartment accounts.. Although that wont include the mortgage.
08:22:40 <daniel_> Is there a way or workaround to include the mortgage?
08:25:39 <warlord> Not in a P&L, because that only includes Income and Expenses. A Mortgage, technically, is paying down a liability..
08:26:04 <warlord> You could include the mortgage interest in the P&L, but not the Liability paydown. The report just wont include it.
08:26:25 <warlord> There's no existing report to do what you want..
08:27:23 <warlord> (AFAIK)
08:27:35 <daniel_> Then I'm going to export the data to a speadsheet and do the analysis there.
08:27:46 <warlord> ok.
08:28:27 <warlord> You can try going through the reports to see if there is anything that seems to give you what you want. Maybe a Cash Flow report?
08:29:07 <warlord> (it would be backwards, but you could try a cash flow and select the income/expense/liability accounts instead of the asset account)
08:31:11 *** fuzzybun_ has joined #gnucash
08:31:43 <daniel_> Yes, i was playing with cash flow but it returns some weird totals. I'm going to refine the accounts selections.
08:32:27 *** fuzzybunny69y has quit IRC
08:32:36 *** fuzzybun_ is now known as fuzzybunny69y
08:34:15 <diver> warlord: Thx for letting me know - the rest is: ... introduces the liability of the bond (Example: 60$ membership + $40 bond = 100$ cash). Currently I see only the option to split the income into 60 -> cash, 40-> bond, but this does not reflect the actual cash amount (100). Any ideas? Hope this question is somewhat clear. Btw, I am not an accountant and pardon for this obviously overly long post ;)
08:41:24 *** fuzzybun_ has joined #gnucash
08:42:36 *** fuzzybunny69y has quit IRC
08:42:37 *** fuzzybun_ is now known as fuzzybunny69y
08:48:46 *** aqua___ has quit IRC
08:50:30 *** fuzzybun_ has joined #gnucash
08:52:39 *** fuzzybunny69y has quit IRC
08:56:52 *** aqua___ has joined #gnucash
08:58:04 *** fuzzybunny69y has joined #gnucash
09:00:35 *** fuzzybun_ has quit IRC
09:02:37 *** aqua___ has quit IRC
09:05:21 *** fuzzybun_ has joined #gnucash
09:05:46 *** fuzzybunny69y has quit IRC
09:05:47 *** fuzzybun_ is now known as fuzzybunny69y
09:11:16 *** Topcat has quit IRC
09:11:39 *** Topcat has joined #gnucash
09:12:46 *** fuzzybun_ has joined #gnucash
09:15:56 *** fuzzybunny69y has quit IRC
09:20:20 *** fuzzybunny69y has joined #gnucash
09:21:07 *** fuzzybun_ has quit IRC
09:28:47 *** fuzzybun_ has joined #gnucash
09:30:44 *** fuzzybunny69y has quit IRC
09:30:45 *** fuzzybun_ is now known as fuzzybunny69y
09:33:27 <daniel_> warlord: I did it with a Transaction Report. Is not a graph, but it shows the montly gain/loss, with an annual total.
09:34:10 <daniel_> exactly what I wanted.
09:38:18 *** Topcat has quit IRC
09:38:51 *** fuzzybun_ has joined #gnucash
09:40:47 *** fuzzybunny69y has quit IRC
09:46:16 *** fuzzybunny69y has joined #gnucash
09:48:22 <warlord> daniel_: excellent. I wasn't sure whether to suggest that report. (I had thought about it but wasn't sure it would do what you wanted)
09:48:54 <warlord> diver: I dont know if the 'bond deposit' is technically "income"
09:48:58 <daniel_> For the record, I had to use filters to obtain the result I wanted.
09:48:58 *** fuzzybun_ has quit IRC
09:49:11 <warlord> daniel_: not surprising.. But that's what they exist for ;)
09:50:17 <warlord> diver: so for example, if they pay you 100, 60 for dues, 40 for bond, I would enter it as: debit cash 100, credit income 60, credit liability 40
09:53:33 *** fuzzybunny69y has quit IRC
09:54:12 *** fuzzybunny69y has joined #gnucash
10:02:41 *** fuzzybun_ has joined #gnucash
10:04:13 *** fuzzybunny69y has quit IRC
10:04:13 *** fuzzybun_ is now known as fuzzybunny69y
10:12:11 *** fuzzybun_ has joined #gnucash
10:14:14 *** fuzzybunny69y has quit IRC
10:19:34 *** fuzzybunny69y has joined #gnucash
10:22:17 *** fuzzybun_ has quit IRC
10:27:07 *** fuzzybun_ has joined #gnucash
10:28:16 *** fuzzybunny69y has quit IRC
10:28:18 *** fuzzybun_ is now known as fuzzybunny69y
10:35:23 *** fuzzybun_ has joined #gnucash
10:38:23 *** fuzzybunny69y has quit IRC
10:42:47 *** fuzzybunny69y has joined #gnucash
10:45:27 *** fuzzybun_ has quit IRC
10:50:49 *** fuzzybun_ has joined #gnucash
10:51:50 *** fuzzybunny69y has quit IRC
10:51:51 *** fuzzybun_ is now known as fuzzybunny69y
10:53:04 *** shanny has joined #gnucash
10:53:55 *** swinchen has joined #gnucash
10:55:05 <swinchen> Hi all. Book keeping question: I just paid to have my taxes my done out of my personal checking account. What is a good way to enter this a capital investment for my business in gnucash?
11:05:00 <warlord> The same way you would account for any other investment into your company
11:07:00 *** fuzzybunny69y has quit IRC
11:07:25 *** fuzzybunny69y has joined #gnucash
11:14:37 *** fuzzybun_ has joined #gnucash
11:17:37 *** fuzzybunny69y has quit IRC
11:20:06 *** Krzysiek_K has joined #gnucash
11:21:53 *** fuzzybunny69y has joined #gnucash
11:24:44 *** fuzzybun_ has quit IRC
11:32:04 *** fuzzybunny69y has quit IRC
11:32:26 *** fuzzybunny69y has joined #gnucash
11:36:40 *** arrainey has joined #gnucash
11:41:15 *** fuzzybun_ has joined #gnucash
11:41:35 *** fuzzybun_ has quit IRC
11:41:51 *** fuzzybunny69y has quit IRC
11:49:02 *** benoitg has joined #gnucash
11:49:03 *** gncbot sets mode: +o benoitg
11:51:47 *** arrainey has quit IRC
11:55:40 *** UnderBill has joined #gnucash
11:57:04 <UnderBill> Anyone understand how Gnucash figures basis for Advanced Portfolio report?
12:06:17 <UnderBill> I have three lots of VZ for a total basis of 15175 for 460 shares.
12:06:22 <UnderBill> The Advanced Portfolio report shows this basis as I expect.
12:06:28 <UnderBill> Then, to record a spinoff, I enter a split which sells the 460 at 15175, and buys them (460 shares) back at 14499.26, and also buys 23 IDAR for 675.74.
12:06:34 <UnderBill> I expect GC to close out the old position of three lots, and create a new position with basis 14499.26.
12:06:39 <UnderBill> But for whatever reason, the basis is now reported as 14837.13.
12:06:44 <UnderBill> This value is at half the difference I expect from the old basis, which seems like a useful clue, but I don't know what it means.
12:06:49 <UnderBill> Advice, please. Anyone?
12:11:49 *** shanny has quit IRC
12:15:22 <UnderBill> I'm suspecting I need to switch basis calc method to LIFO. But I can't find the config option.
12:20:37 <warlord> UnderBill: Sorry, I don't know how that report works. You could try asking on the gnucash-user mailing list.
12:27:15 <UnderBill> warlord, tnx
13:00:01 *** StuM has quit IRC
13:25:52 <warlord> UnderBill: See! Much better responses than I could've provided.
13:26:31 <warlord> UnderBill: Oooh, one other thing to try is the PriceDB Method -- make sure you use something other than Weighted Average
13:51:02 <UnderBill> warlord, sorry - I don't know what PriceDB Method refers to. Regarding Weighted Average, I was just informed that only FIFO is currently supported.
13:51:25 <UnderBill> So maybe I misunderstood? In any case, I cannot find a place in the UI to set such a thing.
13:51:32 *** shanny has joined #gnucash
13:51:36 <warlord> Price Source
13:51:39 <UnderBill> But there are references to it in a .scm file on Github
13:51:54 <warlord> What Price Source do you have set in the report?
13:52:29 <UnderBill> Price Source? As in current value? I'm not even looking at that. I'm interested in getting cost right (basis)
13:53:27 <UnderBill> I don't care about unrealized gain. I will know the real, realized gain whenever a key in the actual sale.
13:53:46 <UnderBill> s/ a / I /
13:54:51 <warlord> I understand, but please check which one you have set.
13:56:06 <UnderBill> Sure. Can you direct me to the option setting? Tnx!
14:02:09 *** shanny has quit IRC
14:03:30 *** shanny has joined #gnucash
14:25:24 <warlord> Open the report options..
14:25:35 <warlord> (I dont recall which page it is on)
15:03:26 *** daniel_ has left #gnucash
15:14:25 *** fell_ has joined #gnucash
15:14:25 *** gncbot sets mode: +o fell_
15:22:39 *** fell has quit IRC
15:46:59 *** fell_ is now known as fell
15:50:08 <fell> Underbill: Right-click in the report or on the toolbar the sheet with pencil or Edit->Report options
17:03:23 *** StuM has joined #gnucash
17:43:04 <UnderBill> fell, Bingo. Thank you.
17:46:57 <fell> :-)
17:48:20 <UnderBill> Weird to have to generate a report once before changing options. Not complaining, though.
17:50:33 *** benoitg has quit IRC
18:04:03 *** shanny has quit IRC
18:05:32 *** Krzysiek_K has left #gnucash
18:50:50 *** arrainey has joined #gnucash
18:58:10 <fell> Underbill: After adjusting, you can rename and save the report: http://wiki.gnucash.org/wiki/Using_GnuCash#Custom_Reports
18:58:36 <fell> http://wiki.gnucash.org/wiki/Custom_Reports might also be of your interest.
19:10:56 <UnderBill> Thanx. Scheme and Guile. Looks like Lisp or Forth. Joy. Let me put Scala and Ruby aside for a moment (-;
19:11:50 <UnderBill> Well, I got my basis right by splitting the splits. Enough for now. Thanks for your help.
19:12:52 *** UnderBill has quit IRC
19:18:03 *** arrainey has quit IRC
20:40:09 *** kpreid has quit IRC
20:40:34 *** kpreid has joined #gnucash
20:53:23 *** arrainey has joined #gnucash
20:58:23 *** arrainey has quit IRC
20:59:11 *** arrainey has joined #gnucash
21:04:12 *** arrainey has quit IRC
21:04:45 *** arrainey has joined #gnucash
21:09:45 *** arrainey has quit IRC
21:10:21 *** arrainey has joined #gnucash
21:15:28 *** arrainey has quit IRC
21:16:02 *** arrainey has joined #gnucash
21:24:22 *** arrainey has quit IRC
21:24:59 *** arrainey has joined #gnucash
21:38:20 *** arrainey has quit IRC