2011-10-16 GnuCash IRC logs

00:00:31 *** fDavid has quit IRC
00:04:29 *** smw has joined #gnucash
00:13:58 *** smw has quit IRC
01:28:04 *** Jimraehl2 has quit IRC
02:01:52 *** smw has joined #gnucash
02:13:48 *** smw has quit IRC
02:21:21 *** ErKa has quit IRC
03:37:24 *** ironwolf1 has quit IRC
03:48:56 *** ironwolf has joined #gnucash
06:28:56 *** Octatron has joined #gnucash
06:29:36 <Octatron> Anyone here know anything about reconciliation with gnucash?
06:30:04 <ironwolf> What's your question?
06:30:38 <Octatron> is there a way to link a bank statement payment with an invoice or sale?
06:31:29 <ironwolf> I've never tried that personally, but someone here may have.
06:32:15 <Octatron> I just recently sussed it out.. its great for putting in expenses but ill be darned if I can attribute the incoming money to a sale
06:33:27 <Octatron> Another one you might know the answer too, is there a way to split an expense for personal and business use?
06:33:50 <Octatron> Thanks for you help btw, I
06:34:03 <Octatron> I've tried on this chat room several times
06:40:34 <Octatron> I thought maybe using spilts could work, but I've eneded up having to calculate a special tax rate to factor in the personal use
08:18:06 *** warlord-afk is now known as warlord
08:18:44 <warlord> Octatron: in 2.4 and earlier the only way is to Process Payment.. So you would need to process the payment for hte invoice first and then reconcile
08:19:12 <warlord> In trunk there is a way to take an existing Split in an A/R account and tell GnuCash that it's paying a specific Customer
08:21:51 <warlord> As for splitting a txn for business and personal use.. No, there's not a good way to do that. However you really should be keeping your personal and business books separately, especially if they are separate taxable entities
08:25:31 <Octatron> warlord: thanks for the input, however the items have a part business and personal use. ie a car or mobile phone
08:26:32 <Octatron> erecord had a section when inserting expenses that you could type in the percentage of personal use to deduct
08:26:55 <warlord> I have no idea what erecord it.
08:26:56 <warlord> is
08:27:35 <warlord> you can use regular math in gnucash, so if the bill is 123.45 and it's 60% business you can in your business books enter 123.45*.6 and in your personal books 123.45*.4
08:29:53 <Octatron> True, that is a good feature.. however I wonder how that will look on the statements for the acountant
08:30:25 <Octatron> perhaps I should learn the language gnucash is written in a add the feature
08:31:34 <Octatron> it really needs to be taken up by mozilla and have the add-on frame work built into it so countries can submit their tax system addon's and customisations
08:34:08 <warlord> The accountant will see 74.07
08:34:22 <warlord> (and 49.38)
08:34:37 <warlord> GnuCash is written in C
08:34:43 <warlord> (reports are written in Scheme)
08:34:58 <warlord> As for "taken up by mozilla", I'm not sure what that means..
08:49:20 <Octatron> I mean mozilla the company should take up the task of cleaning up and moderising gnucash
08:50:27 <warlord> good luck on that.
08:50:28 *** Octatron has quit IRC
08:59:06 *** pyther has joined #gnucash
09:24:14 *** warlord is now known as warlord-afk
09:38:41 *** pyther has quit IRC
09:55:56 *** arbortender has joined #gnucash
09:59:29 <arbortender> I'm trying to figure out how to use the vendor bill function. I've entered a few new vendors and entered 2 bills for one of them. In the bill entry window, the Invoiced? column does not seem to want to take an X as explained in the T&C Guide: "Invoiced? - X means the item is attached to this invoice, an empty box means the item is not attached to this invoice. If the box is empty you can attach the item to the invoice by first s
10:00:32 <arbortender> the box is empty & seems to want to stay that way. I entered several line items on the invoice & they all have that condition.
10:07:48 <arbortender> Also, when I select the Process Payment function, I'm not clear on what's intended by the Post To field. It's drop down offers 3 liability accounts (all personal liability accounts) none of which should be the one that an A/P for this vendor ought to be coming in & out of. This is a business expense & I have business liability accounts set up, but they do not come up as options in that dropdown.
10:11:57 <arbortender> How do I define the proper liability account for the bill when I enter it in the first place? I'm not seeing that option, to point it at a particular A/P account.
10:12:40 <arbortender> Which, I assume, would then be among the Post To options in the Payment Processing Window.
10:21:10 <arbortender> AND, is the Transfer Account field meant for selecting the account from which the bill was paid?
10:26:23 <arbortender> The bills themselves, though entered, do not appear as balances in ANY of the possible liability accounts. Where do those payables balances land?
10:39:47 <arbortender> anybody awake?
10:52:46 <arbortender> I'm gonna bug out & check back
10:54:54 *** kpreid has quit IRC
10:55:26 *** kpreid has joined #gnucash
12:06:53 <arbortender> anybody awake yet?
12:57:43 <arbortender> helloie?
13:17:15 <kpreid> EHLO
13:17:34 <arbortender> should I retype my question?
13:17:41 <kpreid> I didn't see it, so yes
13:17:48 <arbortender> eek. ok
13:17:52 <kpreid> better yet, copy & paste :)
13:18:03 <kpreid> wait, I've got it
13:18:15 <arbortender> (6:59:27 AM) arbortender: I'm trying to figure out how to use the vendor bill function. I've entered a few new vendors and entered 2 bills for one of them. In the bill entry window, the Invoiced? column does not seem to want to take an X as explained in the T&C Guide: "Invoiced? - X means the item is attached to this invoice, an empty box means the item is not attached to this invoice. If the box is empty you can attach the item
13:18:15 <arbortender> (7:00:31 AM) arbortender: the box is empty & seems to want to stay that way. I entered several line items on the invoice & they all have that condition.
13:18:15 <arbortender> (7:07:48 AM) arbortender: Also, when I select the Process Payment function, I'm not clear on what's intended by the Post To field. It's drop down offers 3 liability accounts (all personal liability accounts) none of which should be the one that an A/P for this vendor ought to be coming in & out of. This is a business expense & I have business liability accounts set up, but they do not come up as options in that dropdown.
13:18:19 <arbortender> (7:11:56 AM) arbortender: How do I define the proper liability account for the bill when I enter it in the first place? I'm not seeing that option, to point it at a particular A/P account.
13:18:22 <arbortender> (7:12:39 AM) arbortender: Which, I assume, would then be among the Post To options in the Payment Processing Window.
13:18:25 <arbortender> (7:21:09 AM) arbortender: AND, is the Transfer Account field meant for selecting the account from which the bill was paid?
13:18:28 <arbortender> (7:26:22 AM) arbortender: The bills themselves, though entered, do not appear as balances in ANY of the possible liability accounts. Where do those payables balances land?
13:18:31 <arbortender> ope...sorry
13:18:35 <kpreid> I don't know anything about that. I don't use gnucash business features.
13:18:49 <arbortender> all rightie...standing by
13:19:29 <arbortender> good morning upon you anyway!:)
13:42:29 *** arnotixe has quit IRC
14:07:50 *** ErKa has joined #gnucash
14:14:46 *** ironwolf has quit IRC
14:16:16 *** ironwolf has joined #gnucash
15:28:47 *** kpreid has quit IRC
15:29:41 *** kpreid has joined #gnucash
15:39:59 *** wdkrnls has joined #gnucash
15:41:04 <wdkrnls> what is the preferred way of recovering a lock on my database? I have single user system, but I had a crash unrelated to gnucash.
15:42:47 <wdkrnls> It is an SQL database. My Google foo turned up a bunch of references to older versions of gnu cash in where there were .LCK files, but I don't have any of those.
15:49:57 *** arnotixe has joined #gnucash
16:23:12 *** Jimraehl2 has joined #gnucash
18:14:06 *** wdkrnls has quit IRC
19:47:29 *** Jimraehl2 has quit IRC
20:35:01 *** fDavid has joined #gnucash
21:04:12 *** fDavid has quit IRC
21:04:43 *** warlord-afk is now known as warlord
21:06:46 <warlord> arbortender: The Post-To account would be an account of type A/P with the same currency as the vendor/bill. If it's not showing up in the list then either the account type or account currency doesn't match. But this begs the question why you have so many A/P accounts?
21:38:42 *** arbortender1 has joined #gnucash
21:47:34 *** arbortender has quit IRC
22:11:03 *** ErKa has quit IRC
22:27:40 <warlord> arbortender1: <warlord> arbortender: The Post-To account would be an account of type A/P with the same currency as the vendor/bill. If it's not showing up in the list then either the account type or account currency doesn't match. But this begs the question why you have so many A/P accounts?
22:35:23 *** ErKa has joined #gnucash
23:05:15 *** ErKa has quit IRC
23:46:21 *** warlord is now known as warlord-afk