2008-04-14 GnuCash IRC logs
00:47:32 *** joerlend_ has quit IRC
00:57:28 *** XiXaQ has joined #GnuCash
01:27:37 *** jcreigh has quit IRC
02:55:57 *** glatapoui has quit IRC
04:38:39 *** warlord-afk has quit IRC
05:09:19 *** motin_0 has quit IRC
06:51:53 *** freakynl has joined #gnucash
06:52:18 <freakynl> hi, is something like this possible with the current report engine? http://moneydance.com/mac_expenses_graph
06:53:38 <freakynl> i'd also like to be able to click a category, so the line on the line graph on the bottom becomes fat/on top. i have a lot of accounts and it would otherwise be very hard to view the line
07:50:09 *** IanL has joined #gnucash
08:24:22 *** joerlend_ has joined #GnuCash
08:33:02 *** XiXaQ has quit IRC
09:08:56 *** donfede has joined #gnucash
09:37:47 *** freakynl has quit IRC
09:43:11 *** warlord has joined #gnucash
09:43:12 *** gncbot sets mode: +o warlord
10:16:51 *** kielein has joined #gnucash
10:31:50 *** IanL has left #gnucash
10:46:12 *** twunder has joined #gnucash
11:02:34 *** dsa has joined #gnucash
11:05:40 <dsa> I have two basic types of business expenses--reimbursable and nonreimbursable. I put the nonreimbursable into Expense:Business so that I know to deduct these later. What should I do with the reimbursable?
11:07:10 <warlord> I use Assets:Business Expenses
11:07:57 <dsa> Do you just take money out of that account when you pay and then put money back into it when you are reimbursed?
11:10:44 <vsync> warlord: heh i came up with that exact same idea myself
11:11:22 <warlord> dsa: I go from Cash (or CC) -> A:BE when I buy something, and then A:BE -> Checking when I get reimbursed.
11:12:04 <vsync> dsa: i use the invoicing feature to bill it from Assets:Business Expenses:$EMPLOYER to Accounts Receivable:Employers:$EMPLOYER ... i put the invoice date as when i expense it and the due date as when they are supposed to cut me a check by
11:12:42 <vsync> once they pay, i deposit the check, say "bill paid" in gnucash, and the money xfers from A/R to Bank Account
11:13:19 <vsync> this lets me visually see stuff i have or have not expensed
11:13:30 <vsync> and i know when i should be expecting a tasty cash infusion
11:15:06 <dsa> Essentially, the example warlord gave is really an expense ACCOUNT, isn't it? :)
11:15:54 <warlord> no, it's an ASSET account
11:25:43 *** dsa has quit IRC
11:56:31 *** warlord has quit IRC
12:12:43 *** warlord has joined #gnucash
12:12:44 *** gncbot sets mode: +o warlord
12:21:24 *** kimmo_ has joined #gnucash
12:24:05 *** kimmo has quit IRC
12:24:09 *** Demitar has joined #gnucash
13:52:34 *** sjc has joined #gnucash
13:58:54 *** nomeata has joined #gnucash
13:59:09 <foo_> Hm, is there a way to switch between tabs with the keyboard?
14:02:42 <warlord> Yes... But first you need the tabs to have focus. I THINK it's Alt-something-or-other?
14:03:38 <foo_> oh, in focus. ok, I saw that, didn't know if there was another. Thanks
14:04:49 <warlord> No idea.
14:04:55 * warlord uses the mouse
14:13:41 *** |gunni| has joined #gnucash
14:42:55 *** twunder has quit IRC
14:55:34 *** kling0n has joined #gnucash
15:04:53 *** twunder has joined #gnucash
15:17:14 *** twunder has quit IRC
15:22:37 *** tim_abell has joined #gnucash
15:45:45 *** kling0n has quit IRC
16:07:11 *** olsen has joined #gnucash
16:07:43 <olsen> can i lock transactions? my country demands that i be unable to change entries in my accounts when theyre reconciled
16:10:13 <warlord> gnucash attempts to prevent you from changing reconciled transactions, but there's no way to be 100% sure you can never ever modify them.
16:10:23 <warlord> (and any program that says they can is lying to you)
16:15:30 *** dsa has joined #gnucash
16:17:24 <olsen> yes but they want the lies :)
16:18:02 <dsa> I sometimes use PayPal to pay from my checking account. I have both checking and PayPal setup as separate asset accounts. I am creating one transaction for the ACH transfer from checking to PayPal, and then a second transaction for the payment from PayPal for whatever purpose. Is this the right way to do this?
16:19:06 <olsen> it just needs to be impossible to change it from within the program
16:20:19 <warlord> olsen: then no, gnucash doesn't enforce that completely.
16:20:44 *** foo_ has quit IRC
16:21:03 <warlord> dsa: You could do it that way or you could just short circuit and say checking -> expense and bypass the fact that the money flows through PP. Either way works.
16:21:08 <olsen> how much time do You think it would take for a programmer to modify gnucash to do so?
16:23:05 <warlord> Honestly, I dont know. I think it depends on the extent of the required changes. For example, is it really "reconciled"? or is it "close the books on a period"? Also, what part(s) become uneditable? For example, I can certainly see reason to allow you to not edit the reconciled split at all but you still might be able to change other splits in the same transaction..
16:23:38 <warlord> Are you offering to do this work?
16:39:30 *** twunder has joined #gnucash
16:41:06 *** dsa has quit IRC
16:44:53 *** twunder has quit IRC
16:49:35 *** mmatula has joined #gnucash
16:49:54 <mmatula> Hello. Hopefully have a quick question.
16:50:16 <mmatula> I seem to have lost the column in my account displays that shows if transactions are reconciled or not.
16:51:08 <mmatula> I've got a thick line between "Transfer" and "Deposit" so it looks like it's squished in between those, but I can't get that column to show.
16:51:11 <mmatula> Any hints?
16:51:26 <mmatula> V2.2.4 on WinXP.
16:53:50 <warlord> mmatula: try to grab that column header line and expand it?
16:59:28 <mmatula> Warlord, I seriously tried that about 25 times. And just this time, it worked.
16:59:42 <mmatula> I don't know what the magic was, but it's pretty frustrating.
17:00:14 <mmatula> In other accoutns, it's still hidden and I can't figure out a reliable way to get it to show. Just try try try.
17:09:40 <olsen> warlord, i don't know yet... do You have an offer for it?
17:10:18 <olsen> i'm considering it
17:12:02 <warlord> mmatula: once you get it done in one register then all subsequent register openings should take it.
17:12:17 <warlord> olsen: what do you mean, "an offer for it"
17:13:06 <olsen> if you have an idea on how much time you would spend adding this feature and would like the "job", then i would consider Your offer if I find it reasonable.
17:13:30 <warlord> Oh. I dont know.
17:13:40 <warlord> I think the requirements need to be better defined.
17:14:03 <warlord> GnuCash DOES have the ability to mark a transaction as read-only (and the UI will honor that and not let you modify the transaction at all).
17:14:16 <warlord> But it's all a question of when that flag gets set.
17:14:26 <warlord> Personally I think it should get set as part of the Book Close.
17:14:51 <warlord> ... and only if you specifically request it.
17:19:39 <olsen> how do i mark a set of transactions read-only as it is?
17:19:53 <warlord> You can't from the UI. It's an internal API.
17:19:56 *** Demitar has quit IRC
17:20:11 <olsen> yes, i know it works with invoices
17:20:21 <warlord> Right
17:20:28 <warlord> xaccTransSetReadOnly()
17:22:16 <olsen> you mean it should be set when you close an account?
17:23:34 <olsen> i think that would be very good, when you close an account, all transactions within, not yet read-only must be set to, that's pretty much what i need...
17:23:39 <warlord> I think it should be set only via a "Close Books" call.. But of course that has its own set of problems (specifically in Assets/Liabilities) because stuff might not have cleared by the close-date so you should really only take 'reconciled' txns into account in A/L accts.
17:23:48 <mmatula> THanks for the help, Warlord.
17:23:52 <warlord> mmatula: you're welcome
17:24:12 <warlord> olsen: by "close an account" do you really mean "close the books"?
17:24:31 <olsen> yes
17:28:03 *** dsa has joined #gnucash
17:29:46 <warlord> just making sure.
17:30:12 <warlord> Right now the Close Books process only looks at Income and Expense accounts; it doesn't look at Assets/Liabilities
17:30:40 <warlord> But adding that in wouldn't be TOO hard.. The hardest part is making sure you get the right set of transactions.
17:31:00 <dsa> I downloaded transactions from my account online and imported the file into gnucash. The problem is that some of the transactions in the file were payments for bills that were already in accounts payable. I was able to put these transactions in accounts payable as payments; however, I don't seem to be able to figure out how to associate the payment transactions with the bills. Is the only...
17:31:02 <dsa> ...way to mark a bill paid to use the process payment feature?
17:32:00 <warlord> dsa: Yes.
17:34:04 <dsa> So, should I delete the existing payment transactions and manually re-enter them using the process payment feature?
17:37:54 <olsen> i don't understand why it would affect the set of transactions, all it has to do is add read-only to the transactions within the book you close, how can it do so you get a wrong set of transactions?
17:43:31 <warlord> dsa: yes
17:43:57 <dsa> warlord: thank you. you are always helpful.
17:44:28 <warlord> olsen: what if you have a transaction dated 12/30, but it didn't clear until 1/3? If you do a "book close" as of 12/31 it really should ignore that 12/30 txn because it doesn't belong in the 12/31 period.
17:44:34 <warlord> dsa: You're welcome.
17:45:17 <warlord> It would be really bad to make that 12/30 transaction read-only prematurely.
17:45:49 <dsa> warlord: do you know anything about the status of the business module? is that an orphaned project, or is development still ongoing?
17:45:58 <warlord> Ideally it should probably require that ALL Asset/Liability splits be "reconciled" before it allows the txn to be RO.
17:46:17 <warlord> dsa: I dont understand the question?
17:46:23 <warlord> It's no more orphaned than anything else.
17:46:34 <warlord> (well, except the Postgres backend)
17:46:56 <dsa> warlord: the business module is maintained separately, correct?
17:47:08 <warlord> no.. it's part of the gnucash source tree.
17:48:28 <dsa> oh, sorry then. for some reason, i thought it had a different maintainer.
17:48:50 <warlord> Nope.
17:48:52 <warlord> I wrote it.
17:55:12 *** tim_abell has quit IRC
17:56:19 <dsa> warlord: cool. i certainly use it. actually, i would love to help; but i don't think learning scheme is my biggest hurdle--it's getting familiar with coding standards and structure of the existing business module.
17:56:32 <dsa> warlord: i don't yet know how any of the internals work. :)
17:56:40 <warlord> Scheme is only important for reports.
17:56:44 <warlord> 80% of gnucash is C
17:57:02 <warlord> As for the structure.. all the business code is in src/business/
17:57:22 <warlord> The directory structure is pretty straightforward and self-documenting.
18:03:45 *** kielein has quit IRC
18:04:38 <warlord> jsled: clearing the mail queue?
18:05:06 *** Demitar has joined #gnucash
18:08:05 *** Demitar has quit IRC
18:17:38 *** cortana has joined #gnucash
18:25:31 *** Demitar has joined #gnucash
18:26:39 *** dsa has quit IRC
18:36:36 *** benoitg has joined #gnucash
18:40:26 *** zarchne has quit IRC
18:56:37 *** nomeata has quit IRC
18:58:49 *** jcreigh has joined #gnucash
18:59:15 *** zarchne has joined #gnucash
19:27:29 *** _gunni_ has joined #gnucash
19:36:17 *** |gunni| has quit IRC
19:48:04 *** chris has quit IRC
19:56:44 *** _gunni_ has quit IRC
20:07:55 *** twunder has joined #gnucash
20:51:51 *** twunder has quit IRC
21:09:14 *** grandcanuck has joined #gnucash
21:29:58 *** sjc has quit IRC
21:44:45 *** warlord has quit IRC
21:55:55 *** mmatula has quit IRC
22:08:17 *** warlord has joined #gnucash
22:08:18 *** gncbot sets mode: +o warlord
22:13:50 *** warlord is now known as warlord-afk
22:35:39 *** benoitg has left #gnucash
22:39:44 *** hauptmat has joined #gnucash
22:40:59 *** cortana has quit IRC
22:44:00 <hauptmat> I'm importing a bunch of data. How do I tell GnuCash that two imported entries (in separate accts) are the same transaction? At the moment when I set the acct from Imbalance to the appropriate account it adds a new entry in the target account instead of connecting with the existing entry...
22:51:28 *** jcreigh has quit IRC
22:56:23 *** olsen has quit IRC
23:31:21 *** olsen has joined #gnucash