2009-01-25 GnuCash IRC logs
00:01:53 *** Mike_ has joined #gnucash
00:05:09 <Mike_> I'm new to GNUCash and have been customizing some reports. I can't find a way to test if a commodity collector value is negative or positive. Is there a test function or a way to return a value that can be tested in an IF statement?
00:28:19 *** Mike_ has quit IRC
02:25:26 *** warlord has joined #gnucash
02:25:26 *** gncbot sets mode: +o warlord
03:09:58 *** Kevin_M has joined #gnucash
03:40:32 *** warlord is now known as warlord-afk
04:19:14 *** Kevin_M has left #gnucash
06:16:18 *** ErKa has joined #gnucash
06:23:12 *** ErKa has quit IRC
06:34:12 *** ErKa has joined #gnucash
06:45:38 *** palatin has joined #gnucash
07:38:54 *** joslwah has joined #gnucash
07:39:49 *** ErKa has quit IRC
07:53:26 *** ErKa has joined #gnucash
08:20:30 *** Mike_ has joined #gnucash
08:31:22 *** ErKa has quit IRC
09:27:45 *** twunder has joined #gnucash
09:45:07 *** hvx has joined #gnucash
09:46:09 *** hvx has joined #gnucash
09:54:15 *** kbingham has joined #gnucash
09:54:22 *** twunder has quit IRC
10:03:04 <kbingham> is it possible to add an account starting balance after I've imported 3 years worht of qfx data in to the top account?
10:07:54 *** palatin has quit IRC
10:15:23 *** ErKa has joined #gnucash
10:17:04 *** kbingham has quit IRC
10:47:17 *** patrick has joined #gnucash
10:47:42 <patrick> hello all !
10:48:41 <patrick> I've just discovered GnuCash... It seems I found what I were searching for some time already... Great and thanks to the developpers ;)
10:49:45 <patrick> But I wonder everything is in French (Normal, I'm french speaking) except the account names
10:50:08 <patrick> Is it a known problem or a misconfiguration at my side ?
10:50:59 <patrick> I'm using Kubuntu 8.10 and the package GnuCash from the ubuntu distro
10:52:25 <Mike_> <kbingham>To set the opening balance, add a recored using a date prior to the earliest period that sets the opening balance to the correct amount. Direct the transfer to an equity account called Opening Balance. I've also found it handy to add a matching entry in an income account so that the opening balance account is zeroed and the opening balance appears in retained earnings.
10:56:17 <Mike_> <patrick>C'est a toi de choisir les noms des comptes. Tu peux les changer comme tu veux.
10:58:51 <patrick> <Mike_> Lorsque je crée un nouveau fichier, après avoir choisi la devise, il me propose les comptes à créer
10:59:26 <patrick> <Mike_> Le nom de ces comptes sont en anglais... mais est-il possible de les avoir d'origine en français ?
11:15:01 *** kbingham has joined #gnucash
11:20:41 *** jrgenolsen has joined #gnucash
11:37:52 *** hvx_ has joined #gnucash
11:46:13 *** hvx has quit IRC
12:01:27 *** twunder has joined #gnucash
12:06:05 *** warlord-afk is now known as warlord
12:06:29 *** |gunni| has joined #gnucash
12:06:42 <warlord> kbingham: Yes, you can add an opening balance transaction,provided you have NOT already reconciled the account.
12:06:55 <warlord> Just create a transaction from Equity:Opening Balances
12:07:29 <warlord> patrick: What OS/Distro are you using?
12:07:59 <warlord> GnuCash has locale-based accounts for fr_CA, fr_CH, and fr_FR.. But if you're on windows it's POSSIBLE that it's setting your locale to "fr"
12:18:03 *** kbingham has quit IRC
12:24:53 *** twunder has quit IRC
12:48:44 *** Bob has joined #gnucash
12:49:03 <Bob> Hi!
12:49:20 <Bob> I just switched from Mandriva to Debian.....
12:49:40 <Bob> and now I cannot read my gnucash files I created under Mandriva
12:50:51 <jsled> what happens?
12:50:56 <Bob> I think it is a version problem....mandriva had 2.2.8 and Debian has 2.0.5-1
12:51:03 <Bob> what do you guys think?
12:51:19 <warlord> Do you have any SXes?
12:51:21 <jsled> if you use scheduled transactions, then yes that could be the problem.
12:53:17 <Bob> what happens when I try to open it just says that an error occured while trying to open the file...
12:53:21 <Guy-> fwiw, debian has 2.2.6 now
12:53:46 <Bob> I have etch, not lenny
12:53:50 <jsled> http://wiki.gnucash.org/wiki/Debian#Getting_more_recent_packages_from_GetDeb
12:53:57 *** jrgenolsen has quit IRC
12:54:01 <warlord> Bob: do you have any SXes?
12:55:00 <Bob> what are SXes?
12:55:04 <jsled> scheduled transactions
12:55:08 <Mike_> Re customizing reports - is there a simple way to test if a commodity collector value is negative or positive in a conditional statement?
12:56:13 <warlord> Mike_: use gnc_numeric_neg_p ?
12:56:22 <Bob> I don't think I left any....i.e. I had put some but I think I removed them before switching to debian...
12:56:28 <warlord> (pull out the gnc_numeric part, of course)
12:56:45 <warlord> Bob: if you left any then that would be the reason.
12:57:01 <warlord> There's also the problem of the ROOT account.
12:57:13 <Bob> do you think that would improve with 2.2.6?
12:57:16 <jsled> Bob: I'd try to get upgraded to 2.2.x for a variety of reasons, but if you can't, you can manually remove the SXes from the datafile.
12:57:43 <warlord> All of these are 2.2 -> 2.0 issues.
12:57:52 <jsled> the format incompatibility was introduced in 2.2.0, so yes 2.2.6 would be fine.
12:58:00 <warlord> Upgrading to any 2.2 version would be fine.
12:59:22 <Bob> all right, I'll try this...thanks!
13:03:25 <warlord> Have a good day, all.
13:05:24 *** Bob has quit IRC
13:06:16 *** warlord has quit IRC
13:11:27 *** sjc has joined #gnucash
13:16:29 *** ErKa has quit IRC
13:54:07 *** ams has quit IRC
14:13:41 *** warlord has joined #gnucash
14:13:41 *** gncbot sets mode: +o warlord
14:25:02 *** aindilis has joined #gnucash
14:30:12 *** hvx_ has quit IRC
14:38:37 *** warlord has quit IRC
15:12:40 *** Jimraehl has left #gnucash
15:13:09 *** JimRaehl2 has joined #gnucash
15:45:37 *** aindilis has quit IRC
15:56:14 *** JimRaehl2 has left #gnucash
15:56:49 *** palatin has joined #gnucash
16:02:10 *** Jimraehl has joined #gnucash
16:40:12 *** MechtiIde has quit IRC
16:41:46 *** BobMR2 has joined #gnucash
16:43:48 <BobMR2> Afternoon, here in NW Arkansas. I'm new to GNUcash; also IRC.
16:44:37 <andrewsw> Hi BobMR2. Just ask your question
16:44:50 <BobMR2> I'm wondering why, when setting up an opening balance it returns a negative entry
16:45:53 <BobMR2> initial setup up, the entry is assets, I know you know that, but I don't know what info to provide you.
16:46:29 <jsled> negative? You mean the asset account goes negative and red?
16:46:31 <andrewsw> okay, so you are entering an opening balance in an asset account?
16:47:20 <BobMR2> yes, I thought the initail deposit in the "Bank" would be a positive figure?
16:47:35 <BobMR2> yes, the checking account.
16:48:04 <fbond> joslwah: Patch attached to bug #568327.
16:48:12 <fbond> http://bugzilla.gnome.org/show_bug.cgi?id=568327
16:49:26 <jsled> BobMR2: and you entered this through the "Setup New Accounts" page on the "New Account Hierarchy Setup" druid?
16:50:06 <jsled> @echo test
16:50:06 <gncbot> jsled: Error: "echo" is not a valid command.
16:50:25 <BobMR2> jsled: I did that originally, but now just trying to enter a sum into the program.
16:50:55 <jsled> in what veiw are you trying to enter the deposit?
16:51:08 <BobMR2> one other question, is there a newbie channel on this server, I've lot to learn
16:51:34 <jsled> this is a general support channel for #gnucash.
16:52:13 <BobMR2> jsled: thank you will locate the newbie channel, also will open the GNUcash program again
16:52:40 <jsled> sorry. My point was there's no other "newbie" gnucash channel.
16:53:00 <andrewsw> maybe you mean a newbie IRC channel? for those new to IRC?
16:53:03 <jsled> This is the only channel out there, and we have both new user and development discussion in here.
16:53:16 <BobMR2> I'm in the accounts view, jsled
16:53:53 <jsled> okay. And how are you creating the transaction?
16:54:28 <BobMR2> andrewsw, yes a newbie channel, so I can learn how IRC works
16:54:59 <andrewsw> BobMR2: well, you've got the basics... just type what you want to say!
16:55:26 <BobMR2> jsled: double clicking and entering the transaction ledger Equity/
16:56:38 <BobMR2> Then posting as a balance, then enter, and negative entries appear in all places
16:57:12 <andrewsw> BobMR2: maybe this helps: http://www.rahul.net/dholmes/irc/irc-info.html
16:57:17 <jsled> And in which column are you entering the value in the Equity:Opening Balances account?
16:57:22 <jsled> decrease or increase?
16:59:18 <BobMR2> jsled: it's in the debit (left, my wife says debit is left column) and I think I see the problem.
16:59:34 <jsled> yeah.
16:59:45 <BobMR2> thank you
16:59:52 <jsled> "credit" and "debit" can be really counter-intuitive. Use the column headings.
17:00:30 <jsled> Especially for the account types you'll usually enter transactions against (asset (bank, savings, &c.) and Liability) the column headings are tuned to make sense.
17:00:46 <jsled> "deposit"/"withdrawl". "payment"/"charge", &c.
17:01:04 <jsled> "expense"/"Rebate" in the case of Expense accounts.
17:01:33 <jsled> Also, kinda implicitly in there, I suggest entering transactions in the registers of bank/credit-card accounts.
17:01:39 <jsled> (Rather than Equity accounts)
17:02:19 <jsled> At least to start off … I think it's easier to learn double-entry that way, and then extrapolate when you need to make transactions against other accounts later.
17:02:21 * jsled shrugs
17:02:41 <BobMR2> jsled: she''s been trying to beat that into my thick skull. oh, make entries in "bank tectc. I'll do that and thank you for the help
17:02:58 <andrewsw> sometimes SWMBO is right...
17:03:35 <BobMR2> I was following the help instructions on GNUcash site. thank once more to all of you
17:06:41 *** ryan has joined #gnucash
17:11:57 *** BobMR2 has quit IRC
17:15:13 *** Jimraehl has left #gnucash
17:15:26 *** ryan has quit IRC
17:19:39 *** Jimraehl has joined #gnucash
17:25:32 *** palatin has quit IRC
17:35:35 *** patrick has quit IRC
17:43:11 <joslwah> fbond, I noticed, but will check it tomorrow.
17:43:26 <joslwah> Unless someone beats me to it.
17:52:44 *** |gunni| has quit IRC
18:00:55 *** BobMR2 has joined #gnucash
18:34:51 *** twunder has joined #gnucash
19:23:00 *** BobMR2 has joined #gnucash
19:46:37 *** goodger has quit IRC
19:47:33 *** goodger has joined #gnucash
19:53:41 *** parodyoflanguage has joined #gnucash
19:54:08 <parodyoflanguage> Hello all.
19:54:22 <parodyoflanguage> I've just started using GNU Cash and I have a question.
19:54:49 <parodyoflanguage> I've downloaded two qif files from my bank, one for my checking account and another for my savings account.
19:55:14 <parodyoflanguage> I imported them separately now I'm afraid that transfers are being included twice.
19:55:49 <parodyoflanguage> But, if I delete the imports and start over with importing them at the same time, would gnu cash detect that there is a transfer from one account to another or not?
19:55:59 <parodyoflanguage> Or do I need to go through and fix all the transfers?
19:57:15 *** BobMR2 has joined #gnucash
20:00:56 *** cdenny has joined #gnucash
20:01:16 <cdenny> why should I use gnucash over grisbi? I cant decide
20:01:32 <goodger> cdenny: professional accountancy features
20:02:05 <cdenny> I just need to track paypal and my bank account
20:02:35 <cdenny> ill try gnucash
20:03:50 <cdenny> gnucash just uses the files right, it doesnt actually access the account through the internet?
20:06:01 *** cdenny has left #gnucash
20:13:59 *** sjc has quit IRC
20:14:55 <parodyoflanguage> No one knows?
20:25:57 *** cdenny has joined #gnucash
20:26:30 <cdenny> i want gnucash to see my checking, paypal, and savings accounts just as ins and outs, not specifics cause its messed up
20:26:42 <cdenny> how do i do that
20:28:42 <goodger> cdenny: switch to grisbi. among gnucash's professional accountancy features is double-entry bookkeeping that is the foundation of all accounting
20:28:55 <cdenny> ok
20:29:03 <cdenny> i just want something very simple
20:29:22 <goodger> parodyoflanguage: assuming the files are coming from your bank, gnucash will likely not properly interpret the transfers and you will have to check them
20:29:46 *** cdenny has left #gnucash
20:29:52 *** twunder has quit IRC
20:30:14 <parodyoflanguage> Thank you.
20:38:48 *** Jimraehl has left #gnucash
20:39:15 *** JimRaehl2 has joined #gnucash
21:06:06 *** Aganippe{B} has joined #gnucash
21:09:31 <Aganippe{B}> is someone available to field confused newbie questions?
22:22:22 <mishehu> you're better of just asking your questions than meta-asking. in other words, don't ask to ask, just ask.
22:22:43 <mishehu> it can be slow aorund here though, so it might take a bit for somebody to respond.
22:33:09 *** BobMR2 has left #gnucash
22:40:06 *** warlord has joined #gnucash
22:40:06 *** gncbot sets mode: +o warlord
22:43:00 *** Bob has joined #gnucash
22:43:16 <Bob> hi jsled & warlord
22:43:24 <warlord> hi
22:44:17 <Bob> my problem is solved....gnucash 2.2.6 from Debian Lenny can open my file without any problem
22:44:41 <Bob> (I'm the guy who switched from Mandriva...)
22:44:47 <Bob> thanks
22:46:29 *** Bob has quit IRC
23:22:04 *** JimRaehl2 has left #gnucash
23:22:24 *** Jimraehl has joined #gnucash
23:32:09 *** parodyoflanguage has quit IRC