2008-03-17 GnuCash IRC logs
00:04:26 *** aldente has left #gnucash
00:32:32 *** ferno has quit IRC
01:48:04 *** wizkid238 has joined #gnucash
01:56:10 *** wizkid239 has quit IRC
02:49:27 *** wizkid239 has joined #gnucash
02:55:06 *** wizkid238 has quit IRC
03:27:31 *** kielein has joined #gnucash
04:12:07 *** ErKa has joined #gnucash
04:12:08 *** wizkid239 has quit IRC
04:15:37 *** wizkid238 has joined #gnucash
04:28:10 *** cort has quit IRC
04:53:53 *** Demitar_ has joined #gnucash
04:54:42 *** Demitar has quit IRC
04:57:51 *** joslwah has quit IRC
05:04:23 *** vinci has joined #gnucash
05:31:37 *** _McLANE_ has joined #gnucash
05:43:00 *** freakynl_ has joined #gnucash
05:43:15 <freakynl_> hi, is the Imbalance-EUR account auto created and can I delete it (its 0)
05:44:11 <freakynl_> also having some issues. entered a booking with the same description as a split one, and it automagically copies the previous split copy. this is very much unwanted and also had some issues getting it un-split (although the description is the same it's not always a split transaction)
06:22:28 *** cortilap has joined #gnucash
06:34:20 *** _McLANE_ has quit IRC
07:06:12 *** wizkid239 has joined #gnucash
07:14:31 *** wizkid238 has quit IRC
07:32:52 *** XiXaQ has quit IRC
08:00:29 *** XiXaQ has joined #GnuCash
08:09:10 *** XiXaQ has quit IRC
08:10:02 *** XiXaQ has joined #GnuCash
08:37:43 *** _McLANE_ has joined #gnucash
08:38:04 <jsled> freakynl: Imbalance accounts are auto-created; you can delete them, but they'll eventually come back.
08:38:47 <jsled> There's no way to disable transaction autocompletion, though it should be straightforward to "unsplit" it ... just delete all the splits except the two that are relevant.
08:39:29 <jsled> (Note that even an "unsplit" transaction still has at least two splits; use the Split action (or the Auto-Split or Transaction Journal register View modes) on any existing "unsplit" transaction to see what I mean.)
08:39:40 <freakynl_> jsled: hmm
08:39:52 <freakynl_> jsled: yea i understand, it's always the open account plus the one you book against
08:40:00 <jsled> right.
08:40:31 <freakynl_> if i don't make any errors booking the imbalance's shouldn't return right? it was created because of issues with the split thing
08:41:22 <jsled> Yes and no... the "problem" is that – I think – the account is created while transitioning between splits w/in the context of editing a single Transaction.
08:41:34 <jsled> I.e., even before the Transaction is committed.
08:41:45 <jsled> Now that I say that, I might be wrong.
08:41:48 <jsled> heh.
08:42:24 <freakynl_> i presume you are, as it wasn't created with earlier splits i entered correctly (ie they were in balance)
08:50:04 *** XiXaQ has quit IRC
08:54:53 *** twunder has joined #gnucash
08:56:49 *** warlord-afk is now known as warlord
08:57:02 <warlord> It depends how you transition between splits.
08:57:12 <warlord> If you hit the ENTER key, then yes, it'll be created.
08:59:17 *** aasmodeus has joined #gnucash
09:01:26 *** XiXaQ has joined #GnuCash
09:04:30 <warlord> As for the auto-split, there's a "delete all splits" option in the right-click context menu you can use.
09:36:30 *** donfede has joined #gnucash
09:49:00 <freakynl_> yea clicked that several times, but didn't like it, (that is, would immediately make it a split again)
09:51:08 <warlord> HUH?
09:51:29 <warlord> Delete all splits shouldn't do that
10:44:07 *** warlord is now known as warlord-afk
11:23:00 *** wizkid239 is now known as wizkid238
11:38:17 *** warlord-afk is now known as warlord
11:44:17 *** freakynl_ has quit IRC
11:47:11 *** IanL has joined #gnucash
12:22:08 *** ErKa has quit IRC
12:48:39 *** IanL has quit IRC
13:30:55 *** cortilap has quit IRC
13:37:07 *** SamRose has joined #gnucash
13:51:26 *** cortana has joined #gnucash
14:13:13 *** cortana has quit IRC
14:24:58 *** cumbers has joined #gnucash
14:26:07 <cumbers> morning/afternoon/evening, I am trying to get an expense report for a single asset account, is this possible and if so how?
14:30:18 <warlord> What do you mean by "expense report for a single asset account"?
14:30:38 <warlord> You want to see to where money flowed out from that one account?
14:30:53 <cumbers> warlord: yes
14:30:56 <cumbers> please!
14:31:11 <warlord> Run the Cash Flow report and choose only the single Asset account.
14:32:19 <Simon> how long is likely to take before http://bugzilla.gnome.org/show_bug.cgi?id=106401 or some variation gets added to gnucash? if I start using it and an incompatible version is added in the future I'll end up with a mess of misconfigured scheduled transactions :/
14:32:46 <cumbers> warlord: perfect, only started using gnucash this morning, amazingly powerful, but also quite intimidating!
14:33:19 <warlord> cumbers: I highly recommend the docs.
14:33:28 <warlord> Simon: Um.. when jsled looks at it?
14:34:05 <jsled> As I might have said before, it generally looks good. I guess I should try to apply it and run SXes with it enabled for a bit.
14:34:21 <jsled> E_NOT_ENOUGH_HOURS_IN_THE_DAY
14:34:47 <Simon> it might still be possible to get it going in an infinite loop...
14:41:00 <Simon> if you'd agree changes to the xml format then it wouldn't really matter when it gets added
14:41:41 <jsled> Oh. I guess it would require such changes.
14:46:25 <Simon> as part of <gnc:recurrence version="1.0.0"> I added <recurrence:weekend_adj>{none,forward,back}</recurrence:weekend_adj>, but you might prefer something else or different names...
14:46:55 <jsled> no, that's fine. It's just that we then lose backward compat in the datafile, again. :/
14:47:19 *** tim_abell has joined #gnucash
14:48:40 <Simon> I don't see how you can avoid lose backwards compatibility... "weekend_adj" is ok?
14:49:56 <warlord> Use a KVP?
14:51:43 *** vinci has quit IRC
14:52:21 <jsled> Seems fine, I guess, yeah.
15:04:17 *** tim_abell_ has joined #gnucash
15:12:17 *** tim_abell has quit IRC
15:18:19 *** cumbers_ has joined #gnucash
15:25:11 *** cumbers has quit IRC
15:28:52 *** tim_abell_ has quit IRC
15:47:44 *** cumbers_ has quit IRC
15:51:03 *** fergal has joined #gnucash
15:54:01 *** fergal has quit IRC
16:03:02 *** _McLANE_ has quit IRC
16:09:50 *** ErKa has joined #gnucash
16:20:32 *** ErKa has quit IRC
16:21:00 *** googleboy has joined #gnucash
16:23:31 <googleboy> hey
16:23:46 *** andi5 has joined #gnucash
16:23:46 *** gncbot sets mode: +o andi5
16:24:00 <googleboy> can anyone inform me if gnucash prints micr or not?
16:25:09 <warlord> micr?
16:30:13 <googleboy> yes micr
16:30:17 <warlord> googleboy: what do you mean by micr?
16:30:35 <googleboy> the bottom line on the check with account number routing number and check number
16:30:45 <warlord> Ah! No, gnucash does not.
16:30:59 <andi5> is that an abbreviation?
16:33:52 <googleboy> micr - is what they call the line at the bottom of the check because its printed in magnetic ink
16:34:30 <andi5> ok
16:34:37 <googleboy> any other software you know of
16:37:20 <googleboy> ?
16:40:44 <warlord> sorry, no.
16:54:30 *** googleboy has quit IRC
16:55:50 *** andi6 has joined #gnucash
17:03:18 *** andi5 has quit IRC
17:17:14 *** twunder has quit IRC
18:00:36 *** _gunni_ has joined #gnucash
18:35:05 *** _gunni_ has quit IRC
18:48:46 *** andi6 has quit IRC
18:57:00 *** donfede has quit IRC
19:38:42 *** cortana has joined #gnucash
19:51:08 *** kielein has quit IRC
20:19:35 *** twunder has joined #gnucash
20:39:31 *** cortana has quit IRC
20:42:49 *** cortana has joined #gnucash
21:29:25 *** cortana has quit IRC
21:34:11 *** SamRose has quit IRC
22:02:54 *** Matthew_Murdock has joined #gnucash
22:05:10 <Matthew_Murdock> do you know in which countries is gnucash successfuly used as accounting software? I am from Serbia
22:06:50 <jsled> Any of them? The principals of double-entry accounting are hundreds of years old...
22:07:40 <jsled> I believe we have current serbian currency details reflected, though I don't think there's a translation.
22:08:35 <Matthew_Murdock> jsled: yes, but I am wondering if something special that would make a problem, I am no accounting expert :)
22:10:07 <Matthew_Murdock> jsled: so, if you think that I could use it, then I will spend some time learning about gnucash and accounting...
22:10:26 *** jcreigh has quit IRC
22:10:57 <Matthew_Murdock> ...because I need a legal software from now
22:20:57 *** Matthew_Murdock has left #gnucash
22:28:41 *** aindilis has joined #gnucash
22:48:35 *** twunder has quit IRC
22:54:02 *** Brandon has joined #gnucash
22:54:31 <Brandon> i have an automatic transaction set up with my bank... it pays off the balance of my credit card every month on the 28th
22:54:50 <Brandon> is there a way to schedule this within GnuCash?
22:55:15 <Brandon> like.. can I create a scheduled transaction with a transaction amount that equals a particular accounts balance
22:55:17 <jsled> Not automatically; you can have it prompt you for the value, though.
22:56:37 <Brandon> how would i go about that
22:57:14 <jsled> Are you familiar with the scheduled transaction dialogs?
22:57:22 <Brandon> pretty familiar, yeah
22:57:52 <jsled> In the template transaction, instead of entering a specific dollar amount for the transaction, just enter a variable name, like "amount" or something.
22:58:07 <jsled> It still needs to balance, so you'll need to enter "amount" on both splits.
22:58:30 *** twunder has joined #gnucash
22:58:30 <jsled> Then, in the since-last-run dialog, it'll see "amount" and treat it as a variable that needs a binding, and will prompt you for its value.
22:58:47 <Brandon> just once, as it's used on both sides?
22:59:36 <jsled> right.
23:00:18 <Brandon> hmm.. there's no formula entry that will retrieve an account balance?
23:00:37 <jsled> No. You could write one.
23:00:43 <jsled> The stumbling blocks have been...
23:00:44 <Brandon> i'm not very good at programming
23:01:06 <jsled> Ideally, the formula would *store* the account's identifier, but *display* the name for editing.
23:01:36 <Brandon> i'm a web developer... high level stuff.. low level programming is beyond me
23:01:37 <jsled> As well, one really wants the account-balance as-of a given date.
23:02:13 <jsled> (And *really*, one wants to take into account the fact that it could be creating multiple scheduled transactions at once, which would affect the on-the-books account as-of value for a given date)
23:02:51 <jsled> Of course, a simple (gnc:account-balance "string-account-name "string-date" …) would solve 80%, but it doesn't currently exist.
23:03:38 <Brandon> what i'd really like it to do is enter it two weeks ahead of time (like i have all of my schedules transactions), and continually update itself as the account balance in the credit card changes
23:04:03 <jsled> Why create it two weeks in advance? For forecasting?
23:04:11 <Brandon> so.. as add a transaction to an expense account on the credit card,.. my checking account balance goes down (if it's two weeks ahead of time)
23:04:45 <Brandon> because i get paid every two weeks.. and i like to be able to see any of the bills i'll have to pay before my next check
23:07:40 <Brandon> is there a better way to do it?
23:07:52 <jsled> not really, no.
23:07:58 <Brandon> i'm very new to gnucash
23:08:06 <Brandon> and honesly... very new to any kind of financial responsibility
23:08:25 <Brandon> .... never really learned to keep a register growing up.. i just spent whatever was in my account
23:08:30 <Brandon> ... lots of overdrafts
23:08:43 <Brandon> i'm making a big effort to be more responsible with it
23:09:11 <Brandon> i can't afford the $33.00 overdraft fees..
23:10:53 <jsled> I bet.
23:12:36 <Brandon> "Scheduled Transactions with variables cannot be automatically created
23:12:38 <Brandon> "
23:14:05 <jsled> right.
23:14:26 <Brandon> isn't that what you told me to do?
23:14:35 <jsled> It should really, say, "cannot be created without user interaction", I guess.
23:15:18 <jsled> That is, (with the right preference set) when gnucash starts it'll still automatically determine that it needs to create the SX, but it can't actaully *create* the transaction until you give it the value and hit "ok".
23:16:30 <Brandon> oh i see
23:16:32 <Brandon> so its still going to work
23:16:41 <Brandon> i thought it was not letting me schedule it
23:17:10 <jsled> nope; it's just that "create automatically" checkbox.
23:17:24 <jsled> It should probably reference that checkbox in the message.
23:17:26 <jsled> sigh.
23:17:55 <Brandon> ok.. i have to uncheck "Create automatically"
23:18:09 <Brandon> what's the point of a scheduled transaction if you have to go in and create it anyways
23:18:13 <Brandon> now i'm confused
23:18:48 <jsled> Well, the scheduling.
23:19:32 <Brandon> im new to gnucash... i apologize for being stupid about this
23:19:43 <Brandon> but.. if it's not created.. what's the point of setting it up
23:20:43 <jsled> it'll be created, it just can't be created automatically.
23:20:46 <jsled> So...
23:20:47 <Brandon> if it never takes any action.. like getting created.. what is "scheduled" about it
23:21:16 <jsled> There's a preference which controls if when gnucash starts it looks to see if it has any scheduled transactions that have come due "since last run".
23:21:26 <jsled> (you can also manually invoke that code in the menu)
23:21:28 <Brandon> oh ok.. so it will show up there?
23:21:40 <Brandon> how do you manually create a scheduled transaction
23:21:52 <jsled> Right. And you give it the value for that variable, click "ok", and it creates the transaction as specified.
23:22:13 <jsled> If the template has all the values (and you say "create automatically"), then it won't even give you that dialog.
23:22:19 <jsled> It'll just say "I created 5 transactions".
23:22:35 <jsled> (unless there's other stuff that *does* need interaction, of course.)
23:22:55 <jsled> The only way to create transactions is via the Since Last run dialog, as/when they come due.
23:23:20 <Brandon> oh ok
23:23:25 <Brandon> i guess i'll see how it works when it happens
23:23:31 <Brandon> thanks for the help
23:23:43 <jsled> you're welcome.
23:24:51 <Brandon> is there a way to see a projected balance, without creating the transactions ahead of time?
23:25:27 <jsled> no.
23:27:23 <Brandon> there a way to create a report that would look like the bar chart in http://z.about.com/d/financialsoft/1/0/E/3/6RptTabs.jpg
23:27:32 <Brandon> "account balance graph"
23:28:53 <jsled> {Reports > Assets & Liabilities > Asset Barchart} + some options changes.
23:30:02 <Brandon> cool.. will it take scheduled transactions into account?
23:30:06 <jsled> no.
23:30:29 <jsled> Scheduled Transactions exist outside of the books until the transactions are actaully created / posted.
23:30:37 <jsled> And the reports only look at posted transactions.
23:30:46 <Brandon> k
23:30:48 <Brandon> thanks
23:33:30 *** warlord is now known as warlord-afk
23:49:06 *** wizkid239 has joined #gnucash
23:53:34 *** Brandon has quit IRC
23:54:54 *** wizkid238 has quit IRC
23:59:12 *** twunder has quit IRC