2007-12-11 GnuCash IRC logs
00:31:25 *** ErKa has joined #gnucash
00:47:42 *** stlgirl has joined #gnucash
00:48:08 <stlgirl> Is there a way to export only the account structure, not any transactions?
00:51:47 <warlord> stlgirl: File -> Export Accounts
00:52:00 <warlord> (St. Louis is a great city!)
00:53:16 *** tjanssen has quit IRC
00:53:45 <stlgirl> oh ok, i was thinking export accounts would export everything
00:56:24 <warlord> Nope, just the accounts.
01:00:57 *** Zoolooc has joined #gnucash
01:01:10 <stlgirl> ok thanks
01:03:26 <warlord> anything else I can do for you?
01:21:39 *** stlgirl has quit IRC
01:25:35 *** warlord is now known as warlord-afk
01:29:26 *** Zoolooc has quit IRC
01:33:49 *** wizkid238 has quit IRC
01:54:18 *** ErKa has quit IRC
02:04:09 *** motin_0 has joined #gnucash
03:36:52 *** ErKa has joined #gnucash
04:40:28 *** edgy has joined #gnucash
05:17:28 *** kling0n has joined #gnucash
05:20:52 <edgy> hi, If I created an income account (with hosting, design as sub accounts) and issued an invoice of $200 ($100 for hosting and $100 for design) to a customer who paid $50 monthly for 4 months. What's the report that would tell me my income in a certain month on the hosting account? How can gnucash decide whether this $50 goes to the hosting or to the design?
05:52:34 *** pdc has quit IRC
05:58:10 *** pdc has joined #gnucash
06:00:41 *** kielein has joined #gnucash
06:10:22 *** nomeata has joined #gnucash
06:46:40 *** edgy has left #gnucash
06:53:49 *** nomeata has quit IRC
07:02:29 *** cortilap has joined #gnucash
07:08:01 *** twunder has joined #gnucash
07:15:29 *** twunder has quit IRC
07:44:38 *** IdeAlEss has quit IRC
07:56:42 *** IdeAlEss has joined #gnucash
07:59:04 *** tjanssen has joined #gnucash
08:02:14 *** nbinont has quit IRC
08:06:41 *** Rol1 has joined #gnucash
08:06:41 *** R0lf has quit IRC
08:18:36 *** IdeAlEss has quit IRC
08:22:05 *** twunder has joined #gnucash
08:26:50 *** stlgirl has joined #gnucash
08:31:43 *** nomeata has joined #gnucash
08:41:11 *** edgy has joined #gnucash
08:41:25 <edgy> hi
08:47:10 *** stlgirl has quit IRC
08:50:05 <edgy> it seems as if the "income statements" gives the profit in paper (even if the customer didn't pay the bill) but how can I track the real money I received in each month, please?
09:11:18 <andrewsw-afk> edgy: i've wondered about that too. You're talking about the difference between accrual and cash accounting.
09:11:23 *** IanL has joined #gnucash
09:11:28 *** andrewsw-afk is now known as andrewsw
09:30:55 *** Cosmic has joined #gnucash
09:32:45 <Cosmic> hi, I downloaded the stable release of GnuCash, and have entered about 100 transactions into it now (mostly receipts). Ive notice when I go view - sort and sort by other methods that the balance colum know longer matches up with the sorted items ? is this a bug or by design ?
09:32:56 <Cosmic> does that make sence?
09:33:19 <Cosmic> know = no
09:33:30 <jsled> AIUI, the balance is only a function of the natural ordering of the transactions.
09:33:34 <andrewsw> Cosmic: don't know whether it's a bug or design, but the balance column only makes sense in the defailt sort
09:33:43 <andrewsw> default
09:33:48 <andrewsw> hiya jsled
09:34:08 <jsled> But ... how does it make sense to compute balance by anything other than post date?
09:34:14 <jsled> andrewsw: 'morning.
09:35:00 <Cosmic> hmm ... well ive fiddled the num column so that I can get items entered on the same date into the order I want them when I sort by Num ... its slightly inconvenient that the balance dosnt match up when in this sort view
09:35:16 <Cosmic> ah well... least I know its not an out right bug
09:35:19 <Cosmic> thanks :)
09:35:22 <jsled> The natural ordering should include the num column.
09:35:38 <jsled> s/natural/standard/
09:35:54 <jsled> That is: the balance should be effected when you use Num to force an ordering for transactions.
09:36:00 <Cosmic> hmm ... oddly it dosnt seem to sort by date and then alphanumerically by num on my system
09:36:20 <jsled> http://wiki.gnucash.org/wiki/FAQ#Q:_How_do_I_order_transactions_in_a_register_so_deposits_are_before_withdrawls.3F
09:36:24 <Cosmic> seems to sort by the order in which I entered the transactions (when the date is the same)
09:36:51 *** kling0n has quit IRC
09:37:00 *** kling0n has joined #gnucash
09:37:33 * Cosmic goes to read that wiki entry
09:37:45 *** nomeata has quit IRC
09:39:39 <Cosmic> ah ok thats interesting jsled ... I'll go have a look at the data file ... (might be a nice option to be able to display and edit the entry time from within GnuCash, that would definatly fix the issue I have at the moment)
09:40:10 <Cosmic> (any plans to add that functionality in the future ?)
09:40:28 <jsled> Generically.
09:41:01 <jsled> No one's presently working on it; most register changes are gated by the register-rewrite branch finishing; general malaise, &c.
09:41:24 <Cosmic> hmm, Im sure this is in the help, but what language is gnucash written in ?
09:41:51 <jsled> It's in the FAQ ... mostly C, with some scheme/guile (reports, qif importer)
09:42:53 <Cosmic> hmm, I have programmed in C but not for a while ... perhaps if i get some time I'll brush up and have a look at the code ... anyway thanks for the help
09:43:12 <jsled> help is always welcome! :) and you're welcome. take care.
09:43:28 *** IanL has left #gnucash
09:44:54 <Cosmic> have never looked at scheme ? Its mostly a scripting type language isnt it ?
09:45:16 <jsled> it's a dialect of lisp.
09:45:22 <Cosmic> ahh
09:45:24 <Cosmic> yep yep
09:46:05 <andrewsw> Cosmic runs and hides ;)
09:47:03 <Cosmic> I can remember (Vaguly) playing with very early versions of lisp like its got to be 20 years ago now at least ... hehe
09:47:21 * Cosmic goes to wiki lisp to see how old it actually is
09:47:53 <jsled> almost 50 years old.
09:47:59 <andrewsw> yep
09:48:01 <jsled> ...next year.
09:48:09 <andrewsw> pretty amazing isn't it?
09:48:14 <jsled> indeed.
09:48:27 <edgy> andrewsw: yes it seems so. If you happen to find a tip please inform me
09:48:38 <Cosmic> wow "Originally specified in 1958, Lisp is the second-oldest high-level programming language in widespread use today"
09:48:45 <Cosmic> didnt realise it was THAT old
09:49:18 <andrewsw> edgy: I don't except that maybe you get away from referencing your income accounts directly in invoices.
09:49:48 <Cosmic> so does it must predate BASIC ... I think that came out about 1960 somthing
09:50:15 <jsled> 1963, says WP.
09:50:26 * Cosmic nods sounds right
09:50:31 <andrewsw> edgy: some kind of suspense account.
09:51:32 <andrewsw> edgy: ask on gnucash-user. I don't have call for cash accounting with invoicing.
10:04:32 <andrewsw> later
10:04:43 *** andrewsw is now known as andrewsw-afk
10:13:00 *** warlord-afk is now known as warlord
10:13:03 <Cosmic> hmm jsled ... where it says "Edit the datafile to adjust the hours:minutes:seconds of the <trn:date-entered> tag of the relevant <gnc:transaction> (of the deposit) to be before the withdrawl." Im looking at my data files and I have .log files that are plain text, the .xac files which are in some other format and my main company file which is also not readable in a text editor?
10:13:23 <jsled> the main file is the only one that matters; it's just gzip compressed.
10:13:29 <Cosmic> ah
10:13:31 <Cosmic> cool
10:13:37 <Cosmic> thanks
10:13:40 <jsled> you can either turn that off in Edit > Preferences and re-save, or just gunzip it.
10:13:54 * Cosmic nods ... will go ta :D
10:13:57 <jsled> (or, a *cough*better editor will automagically uncompress it. :)
10:15:46 <Cosmic> cool ... xml ... that means I can parse it with something that will make quick work of my issue
10:16:13 <Cosmic> go = do
10:17:29 <warlord> edgy: as andrewsw said, you're talking about Cash v. Accrual accounting. The business features only do Accrual accounting, and there are no reports to convert that to Cash. You could run a Receivable Aging report and then subtract by hand, but your stated question (above) is exactly the hard problem.
10:37:26 *** ttick has quit IRC
10:41:26 <edgy> andrewsw-afk, warlord: thanks a lot for the hints. I will reread all your tips and try to apply them
10:44:08 <edgy> warlord: may be you know I am a newbie to accounting and to gnucash and for this reason, I thought the things I would need is very essential to everyone else. My mind can't even think about complicated accounting things but it seems I am wrong ;)
10:44:38 <warlord> :)
10:46:03 <edgy> warlord: if I put all my cash in an account called cash, won't a "transaction report" of the cash account solve my problem?
10:47:05 <warlord> Not necessarily.
10:47:59 <edgy> warlord: because if I have a liability account of my credit card, it won't show, right?
10:48:15 <warlord> amongst other things.
10:48:35 <warlord> Have you read the Concepts Guide?
10:48:49 <warlord> I think you're missing some parts of "Double Entry Accounting"
10:50:36 <edgy> warlord: yes I have read most of it
10:50:59 <edgy> warlord: I know something deducted from one account would be added to another
10:51:26 <edgy> warlord: so transaction on my cash account comes from or go to the income or the expense account
10:52:55 <edgy> warlord: my credit card account would have transactions transfered to the expenses account
10:59:47 <warlord> right. But that doesn't help you with your accrual v. cash accounting problem.
11:01:46 *** ErKa has quit IRC
11:07:46 <warlord> anyways, gotta run. I'll be back online in an hour or so.
11:07:59 *** warlord has quit IRC
11:42:27 *** Cosmic has quit IRC
11:46:14 *** cortilap has quit IRC
11:49:18 *** cortilap has joined #gnucash
11:54:31 *** cortilap has quit IRC
11:55:13 *** edgy has quit IRC
12:00:21 *** warlord has joined #gnucash
12:00:22 *** gncbot sets mode: +o warlord
12:01:38 *** warlord has quit IRC
12:01:39 *** joerlend__ has joined #GnuCash
12:06:21 *** warlord has joined #gnucash
12:06:21 *** gncbot sets mode: +o warlord
12:10:21 *** joerlend_ has quit IRC
12:13:24 *** cortilap has joined #gnucash
12:20:08 *** motin_0 has quit IRC
12:31:08 *** cortilap has quit IRC
12:47:50 *** cortilap has joined #gnucash
13:01:52 *** cortilap has quit IRC
13:22:26 *** Demitar has quit IRC
13:51:19 *** Zoolooc has joined #gnucash
14:24:44 *** andi5 has joined #gnucash
14:24:45 *** gncbot sets mode: +o andi5
14:55:06 *** warlord is now known as warlord-afk
15:10:29 *** pdc has quit IRC
15:13:47 *** pdc has joined #gnucash
16:21:26 *** twunder has quit IRC
16:32:50 *** warlord-afk is now known as warlord
16:37:52 *** andi5 has quit IRC
16:47:05 *** ErKa has joined #gnucash
17:11:23 *** kielein has quit IRC
17:33:37 *** ttick has joined #gnucash
18:06:03 *** Demitar has joined #gnucash
18:17:00 *** tim_abell has joined #gnucash
18:20:17 *** tim_abell has quit IRC
18:22:03 *** stlgirl has joined #gnucash
18:27:59 *** rchern- has joined #gnucash
18:28:01 *** stlgirl has quit IRC
19:26:52 *** stlgirl has joined #gnucash
19:28:19 *** rchern- has quit IRC
19:41:32 *** rchern- has joined #gnucash
19:44:23 *** ErKa has quit IRC
19:48:02 *** stlgirl has quit IRC
19:51:33 *** rchern- has quit IRC
19:53:51 *** kling0n has quit IRC
20:01:19 *** puck has quit IRC
20:05:55 *** puck has joined #gnucash
20:21:04 *** timebomb has joined #gnucash
20:22:47 <timebomb> Is it possible to delete customers in gnucash?
20:23:21 <warlord> timebomb: http://wiki.gnucash.org/wiki/FAQ#Q:_How_can_I_delete_an_Invoice.2C_Customer.2C_Vendor.2C_or_Employee.3F
20:23:37 <timebomb> sweet thanks
20:24:16 <warlord> youre'weclome
20:31:41 <timebomb> lol, looks like I'll just make my duplicate customer inactive
20:34:57 <warlord> That or reuse the dup entry for your next customer.
20:50:17 <timebomb> oh good idea, I can write over the field, thanks for the tip
21:03:46 <warlord> you're welcome
21:57:05 *** localhost has quit IRC
21:57:24 *** localhost has joined #gnucash
22:03:26 *** andrewsw-afk is now known as andrewsw
22:03:42 <andrewsw> howdy
22:03:58 <andrewsw> blew my back out. stuck on the couch. ugh.
22:05:15 <andrewsw> but I learned how to check out my local svk repo to my laptop... sweet!
22:05:29 <andrewsw> commit to my local branch on my machine downstairs from the couch.
22:06:57 <warlord> Neat!
22:08:27 <warlord> Okay, time to head to dinner.
22:08:34 <andrewsw> see ya
22:10:13 *** warlord has quit IRC
22:24:20 <andrewsw> where does gnucash get the svn revision number that shows in the splash?
22:25:07 <jsled> andrewsw: see src/gnome-utils/Makefile.am
22:25:14 <andrewsw> thx
22:26:09 *** Zoolooc_ has joined #gnucash
22:33:06 *** twunder has joined #gnucash
22:35:28 *** Zoolooc has quit IRC
22:36:35 <ttick> Hmm, I have a transaction that gnucash won't let me edit. Any idea why?
22:38:00 <jsled> how so?
22:38:31 <ttick> can't click in the already set fields (amounts, splits, accounts, etc) But I could add something else to the split if needed)
22:39:37 <ttick> It's in the Imbalance-USD account (an a liability account (CC)) Can't edit it in either spot.
22:40:20 <jsled> Can you use the arrow keys or the tab key to focus any of the fields?
22:40:48 <ttick> nope.
22:40:56 <ttick> I get a bell for back-arrow.
22:41:03 <jsled> what distro/os and version?
22:42:32 <ttick> okay, odd, it let me delete the transaction (in the split) just not edit it.
22:42:50 <ttick> v2.2.1 Debian
22:43:09 <ttick> So I've worked around the problem -- but it was still odd.
22:43:24 <jsled> indeed. I've never seen that...
22:44:08 <ttick> even after correcting hte account via Add new account, delete old account for the transaction, I can't edit the transaction. Weird.
22:44:38 <andrewsw> adding a new account from within the split?
22:45:22 <ttick> yes, in the split I can't edit the two existing accounts (Expense and Liability) but I can add a new account to debit.
22:45:54 <ttick> And I can delete the credit or debit lines in the split as well. Just can't edit them.
22:49:02 *** wizkid238 has joined #gnucash
23:09:19 *** timebomb has left #gnucash
23:24:49 *** twunder has quit IRC
23:36:02 <andrewsw> can someone refresh me on how to create a numeric from scratch (scheme here). I need to be able to have a gnc-numeric '1', maybe that exists already?
23:38:46 <andrewsw> is it just the C constructor rewritten? (gnc-numeric numerator denom how-to-round)?
23:49:13 <andrewsw> aha (gnc:make-gnc-numeric num denom)