2013-04-14 GnuCash IRC logs
00:07:35 *** arrainey has quit IRC
00:08:11 *** arrainey has joined #gnucash
00:14:18 *** arrainey has quit IRC
00:14:52 *** arrainey has joined #gnucash
00:19:54 *** arrainey has quit IRC
00:20:35 *** arrainey has joined #gnucash
00:22:38 *** fell has joined #gnucash
00:22:38 *** gncbot sets mode: +o fell
00:35:36 *** arrainey has quit IRC
00:36:30 *** arrainey has joined #gnucash
00:40:10 *** arrainey has quit IRC
02:09:25 *** DanC has quit IRC
02:09:56 *** DanC has joined #gnucash
02:35:35 *** arrainey has joined #gnucash
02:40:36 *** arrainey has quit IRC
02:41:09 *** arrainey has joined #gnucash
02:46:11 *** arrainey has quit IRC
02:46:44 *** arrainey has joined #gnucash
02:51:44 *** arrainey has quit IRC
02:52:20 *** arrainey has joined #gnucash
02:57:22 *** arrainey has quit IRC
02:57:59 *** arrainey has joined #gnucash
03:02:59 *** arrainey has quit IRC
03:03:36 *** arrainey has joined #gnucash
03:08:40 *** arrainey has quit IRC
03:09:03 *** kpreid has quit IRC
03:09:17 *** arrainey has joined #gnucash
03:14:17 *** arrainey has quit IRC
03:14:51 *** arrainey has joined #gnucash
03:19:55 *** arrainey has quit IRC
03:20:35 *** arrainey has joined #gnucash
03:25:37 *** arrainey has quit IRC
03:26:13 *** arrainey has joined #gnucash
03:31:15 *** arrainey has quit IRC
03:31:46 *** arrainey has joined #gnucash
03:36:48 *** arrainey has quit IRC
03:37:21 *** arrainey has joined #gnucash
03:42:22 *** arrainey has quit IRC
03:42:58 *** arrainey has joined #gnucash
03:48:01 *** arrainey has quit IRC
03:48:34 *** arrainey has joined #gnucash
03:53:34 *** arrainey has quit IRC
03:54:27 *** arrainey has joined #gnucash
03:59:30 *** arrainey has quit IRC
04:00:04 *** arrainey has joined #gnucash
04:05:05 *** arrainey has quit IRC
04:05:48 *** arrainey has joined #gnucash
04:16:17 *** arrainey has quit IRC
04:22:22 *** shanny has joined #gnucash
04:38:41 *** ErKa has joined #gnucash
04:58:39 *** ErKa has quit IRC
05:34:00 *** shanny has quit IRC
05:40:02 *** Topcat has joined #gnucash
05:45:01 *** Topcat has quit IRC
05:45:24 *** Topcat has joined #gnucash
05:56:17 *** Topcat has quit IRC
05:56:40 *** Topcat has joined #gnucash
05:57:32 *** fabior has joined #gnucash
06:06:44 *** Topcat has quit IRC
06:07:17 *** Topcat has joined #gnucash
06:12:19 *** Topcat has quit IRC
06:12:42 *** Topcat has joined #gnucash
06:14:16 *** ErKa has joined #gnucash
06:22:46 *** Topcat has quit IRC
06:23:09 *** Topcat has joined #gnucash
06:27:51 *** ErKa has quit IRC
06:33:19 *** Topcat has quit IRC
06:34:00 *** Topcat has joined #gnucash
06:46:30 *** fabior has quit IRC
06:50:00 *** Topcat has quit IRC
06:51:23 *** ErKa has joined #gnucash
06:52:44 *** fabior has joined #gnucash
07:03:23 *** ErKa has quit IRC
07:13:21 *** fabior has quit IRC
07:45:46 *** calbasi has joined #gnucash
07:56:12 *** Topcat has joined #gnucash
07:57:18 *** fabior has joined #gnucash
08:19:09 *** Topcat has quit IRC
08:19:31 *** Topcat has joined #gnucash
08:37:51 *** calbasi has left #gnucash
08:44:02 *** Topcat has quit IRC
08:52:52 *** Jimraehl has quit IRC
09:00:33 *** Jimraehl has joined #gnucash
09:01:49 *** Jimraehl has left #gnucash
09:02:37 *** Jimraehl has joined #gnucash
09:02:41 *** FabianS has joined #gnucash
09:03:53 <FabianS> Hi there. The AqBanking assistant fails without any usable error message when I try to set up my HBCI account.
09:05:11 <FabianS> It asks me several times for my PIN and seems to accept it. But then it just stops at 66% and tells me to close the window.
09:05:20 <FabianS> But closing it brings me back to the step before.
09:07:24 <FabianS> It just doesn't create the account entry.
09:09:59 *** DimStar_ has joined #gnucash
09:13:15 *** DimStar has quit IRC
10:02:05 *** aqua___ has joined #gnucash
10:39:09 *** aqua___ has quit IRC
10:51:55 *** aqua___ has joined #gnucash
11:16:40 *** kpreid has joined #gnucash
11:19:27 *** arrainey has joined #gnucash
11:29:29 *** arrainey has quit IRC
11:30:01 *** arrainey has joined #gnucash
11:33:19 *** aqua_ has joined #gnucash
11:34:39 *** aqua___ has quit IRC
11:40:06 *** arrainey has quit IRC
11:40:51 *** arrainey has joined #gnucash
11:41:59 *** aqua_ has quit IRC
11:50:55 *** arrainey has quit IRC
11:51:29 *** arrainey has joined #gnucash
12:01:34 *** arrainey has quit IRC
12:15:49 *** edi has joined #gnucash
12:30:07 *** edi has quit IRC
12:40:43 *** arrainey has joined #gnucash
12:45:46 *** arrainey has quit IRC
12:46:20 *** arrainey has joined #gnucash
12:51:21 *** arrainey has quit IRC
12:52:03 *** arrainey has joined #gnucash
12:55:50 *** Topcat has joined #gnucash
13:00:51 *** Topcat has quit IRC
13:01:25 *** Topcat has joined #gnucash
13:07:06 *** arrainey has quit IRC
13:07:42 *** arrainey has joined #gnucash
13:16:26 *** Topcat has quit IRC
13:17:01 *** Topcat has joined #gnucash
13:19:03 *** nomeata has joined #gnucash
13:21:25 *** aqua___ has joined #gnucash
13:21:36 *** Jimraehl has quit IRC
13:27:10 *** Topcat has quit IRC
13:27:44 *** Topcat has joined #gnucash
13:32:45 *** Topcat has quit IRC
13:33:32 *** Topcat has joined #gnucash
13:43:36 *** Topcat has quit IRC
13:43:58 *** Topcat has joined #gnucash
13:51:39 *** aqua_ has joined #gnucash
13:56:50 *** aqua___ has quit IRC
14:01:37 *** aqua_ has quit IRC
14:08:44 *** arrainey has quit IRC
14:08:57 *** fell_ has joined #gnucash
14:08:57 *** gncbot sets mode: +o fell_
14:09:20 *** arrainey has joined #gnucash
14:14:21 *** arrainey has quit IRC
14:14:56 *** arrainey has joined #gnucash
14:15:50 *** Topcat has quit IRC
14:17:16 *** fell has quit IRC
14:30:00 *** arrainey has quit IRC
14:30:32 *** arrainey has joined #gnucash
14:35:33 *** arrainey has quit IRC
14:36:08 *** arrainey has joined #gnucash
14:41:10 *** arrainey has quit IRC
14:41:47 *** arrainey has joined #gnucash
14:46:48 *** arrainey has quit IRC
14:47:21 *** arrainey has joined #gnucash
14:48:07 *** fabior has quit IRC
14:57:28 *** arrainey has quit IRC
14:57:57 *** calbasi has joined #gnucash
14:58:02 *** arrainey has joined #gnucash
15:18:05 *** arrainey has quit IRC
15:18:41 *** arrainey has joined #gnucash
15:23:43 *** arrainey has quit IRC
15:24:16 *** arrainey has joined #gnucash
15:29:17 *** arrainey has quit IRC
15:29:51 *** arrainey has joined #gnucash
15:49:14 *** arrainey has quit IRC
15:49:52 *** arrainey has joined #gnucash
15:54:54 *** arrainey has quit IRC
15:55:26 *** arrainey has joined #gnucash
16:04:15 *** arrainey1 has joined #gnucash
16:06:19 *** arrainey has quit IRC
16:07:14 *** fell_ has quit IRC
16:07:29 *** aqua___ has joined #gnucash
16:19:00 *** Jimraehl has joined #gnucash
16:22:14 *** Krzysiek_K has joined #gnucash
16:24:11 *** arrainey1 has quit IRC
16:36:00 *** aqua___ has quit IRC
16:53:52 *** ErKa has joined #gnucash
17:23:28 *** nomeata has quit IRC
17:40:28 *** calbasi has left #gnucash
17:53:54 *** ErKa has quit IRC
19:39:53 *** metalfreak has joined #gnucash
19:41:44 <metalfreak> Is it normal for a .QIF import to take hours?
19:45:07 <metalfreak> I'm importing several accounts from Quicken which I figured would take awhile but it's said "Finding duplicate transactions" for a few hours without giving me anymore information
19:54:43 *** metalfreak has left #gnucash
20:37:01 *** arrainey has joined #gnucash
20:47:05 *** arrainey has quit IRC
20:47:54 *** arrainey has joined #gnucash
20:58:20 *** arrainey has quit IRC
20:59:04 *** arrainey has joined #gnucash
21:04:05 *** arrainey has quit IRC
21:04:54 *** arrainey has joined #gnucash
21:09:57 *** arrainey has quit IRC
21:10:30 *** arrainey has joined #gnucash
21:15:24 *** kpreid has quit IRC
21:19:41 *** arrainey1 has joined #gnucash
21:24:41 *** arrainey1 has quit IRC
21:24:51 *** arrainey has quit IRC
21:25:30 *** arrainey has joined #gnucash
21:27:16 *** kpreid has joined #gnucash
21:31:02 *** slidesinger-lt has joined #gnucash
21:34:19 <slidesinger-lt> Trying to figure out how to handle deferred accounts-receivable... in this case a maintenance agreement that was negotiated for a figure of, say $1200 for the year billable at $100 on the first of each month. This is kind of important as some renew at 12 months, some at 24, and some at 36. Not sure how to show this, though it may be beyond the scope of this software.
21:34:47 <slidesinger-lt> Also not sure what I should be looking for in terms of what to read. Basically without a clue on this one.
21:35:58 <slidesinger-lt> Any idea either how to handle this or what I should be looking to read would be exceedingly helpful.
21:40:48 <slidesinger-lt> Come to think of it, I'm likely even using the wrong terms.
21:45:58 *** arrainey has quit IRC
21:46:31 *** arrainey has joined #gnucash
21:54:57 *** arrainey has quit IRC
21:55:33 *** arrainey has joined #gnucash
22:00:38 *** arrainey has quit IRC
22:01:12 *** arrainey has joined #gnucash
22:06:12 *** arrainey has quit IRC
22:06:46 *** arrainey has joined #gnucash
22:11:47 *** arrainey has quit IRC
22:12:28 *** arrainey has joined #gnucash
22:17:30 *** arrainey has quit IRC
22:18:06 *** arrainey has joined #gnucash
22:23:06 *** arrainey has quit IRC
22:23:40 *** arrainey has joined #gnucash
22:28:42 *** arrainey has quit IRC
22:29:26 *** arrainey has joined #gnucash
22:34:26 *** arrainey has quit IRC
22:35:00 *** arrainey has joined #gnucash
22:45:01 *** arrainey has quit IRC
22:45:33 *** arrainey has joined #gnucash
22:47:34 *** wizkid239 has quit IRC
22:55:39 *** arrainey has quit IRC
22:56:14 *** arrainey has joined #gnucash
22:56:20 *** wizkid238 has joined #gnucash
23:06:15 *** arrainey has quit IRC
23:06:49 *** arrainey has joined #gnucash
23:11:49 *** arrainey has quit IRC
23:12:22 *** arrainey has joined #gnucash
23:17:24 *** arrainey has quit IRC
23:18:02 *** arrainey has joined #gnucash
23:22:38 <Antisoche> slidesinger-lt: Recalling from a discussion here long ago, there isn't a way to auto-create A/R entries, even though you can with A/P (recurring bills). I've never used the feature, so I don't know if you can have negative "bills", or could fudge it to "bill" into income, say, instead of expense.
23:23:15 <Antisoche> slidesinger-lt: But I think you're out of luck unless you know C. ;-)
23:24:22 <slidesinger-lt> Heh! C is easy.... Accounting is hard. I'm trying to even figure out where it goes on the balance sheet and income statement.
23:27:16 <slidesinger-lt> I sell the service, they pay me a set amount broken up over the course of the year. I actually just came across something called residual income. It might be that.
23:27:32 <slidesinger-lt> I also provide the service.
23:32:45 <Antisoche> It's a retainer then?
23:34:48 <Antisoche> slidesinger-lt: I use the regular invoice system - flat fee (which I label "project" type) and then an hourly rate in excess of what's included in the flat rate. I don't do anything special with it accounting-wise, but the entry is a bit labor intensive.
23:35:20 <Antisoche> ... because I have to split line items at the break manually.
23:37:21 <Antisoche> slidesinger-lt: I don't think residuals are what you think they are: http://www.investopedia.com/terms/r/residualincome.asp
23:37:37 * Antisoche is not an accountant, as well.
23:39:41 <slidesinger-lt> That kind of makes sense. I'm really thinking it should just be an A/R transaction with a customized statement of account. e.g., show the balance, show the monthly payment, show the remaining term. I may just have to do that manually, although I might be able to cobble some code together to just pull it out of the database and run automatically.
23:42:41 <slidesinger-lt> html is easy enough to gen, so set up a text file that contains the customer numbers and read the information out of the xml file, gen the html formatted invoice then run that through wkhtmltopdf to create a pdf file for the customer. Not pretty, but it might just work.
23:42:45 <Antisoche> Ah, so you want to have something like a loan -- like $10,000/yr with monthly payments (amortized at 0% presumably). Sounds like a good challenge. Enterprise GNUCash :)
23:44:03 <slidesinger-lt> Well, all I need to do is track the value and expiration of the contracts.
23:46:15 <Antisoche> Well, I think you want to do a full-value invoice in GNUCash, and use something else to generate invoices. Then as payments come in you can just apply them against the single outstanding balance. Kinda hokey, but I don't know what else to suggest within GC. Also note I'm not a heavy user, just trying to help out when I can...
23:48:01 <Antisoche> One downside is that GNUCash can't apply payments to specific invoices, so that might mess things up if you generate a separate bill for something else. warlord I think would have more information about that. He once said he didn't need that so he didn't include it; I don't know if that's changed.
23:48:21 * slidesinger-lt grins... I've already created enough work for myself with my lack of understanding of accounting, putting things in the wrong place. I'm moving all the invoices generated in the last four months from income:service to income:sales:service... this puts the tree right.... according to my friend the accountant.
23:49:02 <Antisoche> (And I do realize that 'Apply payment' lets you put in an invoice number, but though I haven't tested it explicitly I don't think the infrastructure is there to deal with it.)
23:50:31 <Antisoche> That sounds like a lot of work. You can just create a 'sales' level under 'income' and then in 'service' right-click and 'edit' and change the parent. Moving things around in the tree (chart of accounts) is basically trivial.
23:50:52 <slidesinger-lt> Yeah, the problem is that it would be a split anyway. In addition to the service arrangement, I have multiple consulting invoices for other jobs for this same client.
23:51:20 <slidesinger-lt> Hmmmm. Let me look at that.
23:52:05 <slidesinger-lt> You just saved me HOURS of work!!!!
23:52:55 <Antisoche> shazam!
23:54:35 <slidesinger-lt> Now I only have four invoices to edit, those where I decided to break out the backup service as a separate revenue stream.
23:54:41 <Antisoche> I have the same - multiple invoices per client. Even multiple invoices per job per client. I also get paid out of order and it hasn't bit me yet, but it can get confusing if certain projects die, etc. So for, so good - here's to hoping the good times last! :-0
23:55:39 *** fell has joined #gnucash
23:55:39 *** gncbot sets mode: +o fell
23:56:23 <Antisoche> Anyway -- off to bed for me. Glad I could help with something.
23:57:09 <slidesinger-lt> Thank you thank you!
23:57:30 <Antisoche> slidesinger-lt: Oh, and if you're dealing with splits, I highly recommend making the default view 'Auto-split Ledger'.
23:58:17 <Antisoche> Edit -> Prefs -> Register Defaults
23:58:23 <slidesinger-lt> My accountant has got me using the transaction journal view, which actually breaks things down nicely1
23:58:50 <Antisoche> That works, too. I just find it too busy (usually).