2009-04-01 GnuCash IRC logs
00:26:53 *** Rolf has joined #gnucash
00:57:39 *** bluefox has quit IRC
01:09:21 *** smacnay has quit IRC
01:16:28 *** smacnay has joined #gnucash
01:51:25 *** linas has quit IRC
03:09:55 *** hvx has joined #gnucash
03:12:58 *** hvx has quit IRC
03:22:38 *** MechtiIde has joined #gnucash
03:44:33 *** Rolf has quit IRC
03:56:23 *** Rolf has joined #gnucash
05:26:12 *** soa2ii has joined #gnucash
05:31:04 *** rockfreak has quit IRC
05:31:47 *** rockfreak has joined #gnucash
05:40:25 *** linas has joined #gnucash
06:14:07 *** ErKa has joined #gnucash
06:16:23 *** kielein has joined #gnucash
06:26:27 *** kielein has quit IRC
06:35:04 *** kielein has joined #gnucash
06:45:20 *** kielein has quit IRC
06:47:05 *** grantbow has joined #gnucash
06:51:08 *** icpb has joined #gnucash
06:51:42 <icpb> <Grantbow@freenode> test relay
06:52:04 <grantbow> test relay
06:54:08 *** kielein has joined #gnucash
06:55:10 <grantbow> excellent, the freenode relay works! Any objections to keeping something like this running?
07:03:01 *** grantbow has left #gnucash
07:24:05 *** smileboot has joined #gnucash
07:25:08 <smileboot> Does anyone know how i can import the .txt files from my Bank of america account?
07:29:34 <smileboot> Or does anyone use gnucash with their BOA account? and can advise me how to best do it?
08:05:27 *** Jimraehl has left #gnucash
08:10:47 <icpb> Grantbow has quit freenode ("leaving")
08:29:12 *** JimRaehl2 has joined #gnucash
08:30:30 <jsled> yes.
08:31:45 <jsled> @tell grantbow I object. There's a handful of people that join freenode #gnucash, and they get redirected here 90% of the time. the relay will just create noise that I have to deal with.
08:31:45 <gncbot> jsled: The operation succeeded.
08:33:05 *** JimRaehl2 has left #gnucash
08:33:31 *** JimRaehl2 has joined #gnucash
09:49:22 *** ChrisDennis has left #gnucash
09:49:48 *** ChrisDennis has joined #gnucash
09:53:42 *** vitoc has joined #gnucash
10:05:02 *** Rolf has quit IRC
10:11:25 *** warlord-afk is now known as warlord
10:11:52 <warlord> How annoying, the new server is bouncing lots of monthly mail, and it's going into /my/ inbox.. :( I dont recall the old server doing this..
10:19:28 *** KaiForce has joined #gnucash
10:59:57 <icpb> Daviey has quit freenode (SendQ exceeded)
11:03:51 *** icpb was kicked by warlord (warlord)
11:03:53 *** icpb has joined #gnucash
11:04:02 <warlord> Damn, that didn't work.
12:23:41 *** MechtiIde has quit IRC
12:32:42 *** Zoolooc has joined #gnucash
12:32:43 *** chris has quit IRC
12:34:24 *** chris has joined #gnucash
12:45:05 <rockfreak> how do i save a custom report?
12:46:45 <rockfreak> more to the point I have customized the invoice report and would like to save that!
12:47:56 <warlord> Change the name, click "Add Report"..
12:48:09 <warlord> But keep in mind that it wont come up when you click the 'print' button...
12:55:59 *** palatin has joined #gnucash
12:56:20 *** foo has joined #gnucash
12:56:50 <foo> Hm, to close up records for 2008 and wrap up that year book-keeping-wise... I just need to reconcile everything, right? Pretty sure that's what I did last year, just want to double check.
12:57:18 <warlord> You can do whatever you'd like.
12:58:31 <foo> :) Gotcha. At the very least, that could be assumed to be the "right" way to do it - yeah? pretty sure
12:58:59 * foo wishes he could reference his logs from when he asked this last
13:01:55 *** soa2ii has quit IRC
13:03:42 <foo> warlord: so what would m y options be? eg. I could reconcile, or I could just leave them alone - right?
13:13:04 <warlord> Depends what you want to accomplish.
13:13:11 <warlord> You could also "close the books"
13:13:13 <warlord> (but I dont)
13:13:39 <foo> Just want to somehow wrap things up for last year
13:13:48 <foo> yeah, I think I'll just reconcile, thanks, unless you see I have other options
13:15:24 <warlord> Well, you should be reconciling every month..
13:15:40 <warlord> For end of year you can just do that, or you can close the books, or start a new file, or...
13:15:43 <warlord> You have lots of options.
13:31:25 <foo> thanks warlord :)
13:32:20 <warlord> You're welcome.
13:48:51 *** twunder has joined #gnucash
13:49:48 *** felipe__ has joined #gnucash
13:51:27 <felipe__> Hello guys, is there a way to use the account codes show along the account names in the transaccions and reports?
13:51:54 <warlord> felipe__: check the Display page on the report options?
13:52:22 <felipe__> warlord, and in the transacion is there a way to visualize the account code?
13:52:47 <warlord> "in the transaction"?
13:54:31 <felipe__> when I choose the account in the transactions, I have to choose by name, I want to choose the account by the account code....
13:55:08 <jsled> no, there's not
13:55:17 <felipe__> Oh ok.
13:56:07 <warlord> I think someone from germany was working on a patch to implement that, but AFAIK that was never committed to SVN
13:56:28 *** vitoc has quit IRC
13:57:19 *** hvx has joined #gnucash
13:58:31 <felipe__> warlord, do you think that feature is going to be in a future release of the program?
13:58:59 <warlord> I dunno.
13:59:11 *** Rolf has joined #gnucash
14:01:37 <felipe__> warlord, ok thanks
14:03:41 *** MechtiIde has joined #gnucash
14:13:18 *** soa2ii has joined #gnucash
14:16:46 *** andyt has joined #gnucash
14:19:42 *** rafael has joined #gnucash
14:19:48 <rafael> Hi everyone
14:20:01 <rafael> warlord: Thanks for your help yesterday. Everything working now..
14:20:43 <smileboot> Does anyone know how i can import the .txt files from my Bank of america account?
14:20:45 <smileboot> Or does anyone use gnucash with their BOA account? and can advise me how to best do it?
14:21:35 <warlord> rafael: great
14:21:43 <jsled> smileboot: probably by converting them to a format gnucash recognizes?
14:21:46 <warlord> smileboot: they wont give you a qif or ofx?
14:22:06 <jsled> Or, yeah, download QIF instead.
14:22:12 <smileboot> warlord, as far as i can see no. think you have to pay extra for ofx
14:22:25 <rafael> I remebered we have talked before about the translation in portuguese for the Profits and Loss reports. i submited the emails with the sugestions, but got no response
14:22:28 <jsled> If it's the same text format from their online banking webapp from a couple of years ago, the text format was really strange.
14:23:02 <smileboot> jsled, yeah its kinda like a normal mail statement written out
14:23:23 <jsled> are you using their Online Banking? It supports QIF downloads.
14:23:57 <smileboot> it supports qif but as far as i can tell you have to pay extra a month to "activate" it
14:25:02 <smileboot> ill have another look around the site later but i cant seem to find qif just txt and pdf
14:26:28 <jsled> smileboot: these are the options I get: http://pastebin.ca/1379145
14:26:45 <jsled> I've never had to pay to activate anything QIF-related. I believe OFX is a different matter.
14:27:33 <smileboot> hmmmm maybe im missing it
14:28:12 <smileboot> tho are you a business account? or is it a personal?
14:28:17 <jsled> personal.
14:28:55 <smileboot> then there should be no difference i must be overlooking somthing
14:29:43 <rafael> When I try to see a report with Bills to be Payed I get a message that no account is configured. I go to options and configure it entering my expenses accounts. When I apply my gnucash crash with the message:
14:29:44 <rafael> Found Finance::Quote version 1.13
14:29:44 <rafael> ERROR: In procedure gnc_option_set_ui_value_account_sel:
14:29:44 <rafael> ERROR: Option Value not a wcp.
14:30:30 <jsled> smileboot: This is just click on the account from the dashboard, then "Download" in the upper right corner of the transaction list.
14:30:40 *** hvx has quit IRC
14:31:29 *** rockfreak has quit IRC
14:32:32 <warlord> rafael: "bills to be payed"? Which report?
14:32:42 <rafael> hehe translation problem again
14:32:43 <smileboot> jsled, thanx for your help. cant check it right now since this aint my account im setting up but ill look thru later and hopefully ill find it this time.
14:33:43 <rafael> I am looking a way to have a report like profits and expenses that incldues what I still have not payed. I was using profits and expenses reports, but it is hiding my debts I could not honour...
14:34:07 <rafael> I think a solution would be put those expenses with next month date and then print a report including thgis next month
14:34:19 <rafael> But I am trying the usual way assing a vendor and a bill
14:35:42 <warlord> So you're trying to get the P&L to include A/R and A/P?
14:36:05 <rafael> yes. And my A/P is crashging with that message also..
14:36:20 <rafael> I was trying to print a A/P, but ius is crashing
14:36:33 <warlord> what do you mean by "print a A/P"?
14:36:58 <rafael> Is it a too wrong solutions to add those accounts as payed with a future date, and postpone this date unitl I actually pay them? This will they will be in P&E
14:37:06 <rafael> not print show...
14:37:23 <rafael> I must go to the options and select an account and when I select my account it crashes
14:39:02 <rafael> Hum this was an error in my tree again. Fixed that no more crash :)
14:39:18 <rafael> But to have those two reports as one, is it possible? and what I am doing is it to wrong?
14:39:34 <rafael> Those are account I should have payed,but I am late...
14:41:28 <warlord> I think your english is getting in the way of my understanding what you're trying to do.
14:41:49 <warlord> What do you mean "accounts as payed"?
14:44:13 <rafael> I add them in a expense account transaction, as usual, but with a future date.
14:45:03 <rafael> I think that I should only add a transaction when I have actually payed. So I though about adding transaction with a future date (though I am not sure when I will have the money to pay them)
14:46:50 <warlord> I add transactions with future dates when I set them up in my Bill Pay solution, because I know they will be paid at that future date. But I wouldn't use a transaction as a reminder.
14:49:34 <rafael> Hum,actualy bills to be paid appear in the Profit and Losses
14:49:49 <rafael> again was my mistake...
14:50:09 <warlord> Right, they will when you set the dates appropriately.
14:50:55 <rafael> Yes, I just dont know why in the reports they all appear as 91+ Days. if I set theirs date to today, and theirs pay day to the next week...
14:51:07 <rafael> In the A/P report
14:53:02 <rafael> but again must be something I am wrong again
14:53:18 <rafael> Until now the score is GNUCASH 5 X 0 Rafael ...
14:53:36 <rafael> The only bugged think here is my brain... This software is wonderful
14:54:01 <warlord> not sure what to tell you about the 91+ days.
14:55:17 <rafael> Yes, gonna recheck eveything again... If it is really a bug I will report... I will also resend my email with a translaction suggestion I made some months ago... IMHO Profits and Expenses Report is mistranslated in brazilian portuguese.
15:00:02 <warlord> You should work with the translator to supply a new .po file
15:01:02 <rafael> Ok, gonna do that
15:01:34 <rafael> What is the differnce betwen registering transactions in the future and using the vendor and bill way ?
15:01:54 <rafael> Both seems to have very near results...
15:02:35 <warlord> All depends on how you use it..
15:02:48 <warlord> (I dont use the Vendors, only Customers)
15:02:57 <warlord> ... and only in my business.
15:09:44 *** Rolf has quit IRC
15:15:54 <felipe__> Guys, is there a spanish channel for gnucash btw?
15:17:23 <warlord> No
15:17:27 <warlord> Well, there is gnucash-es
15:17:36 *** Rolf has joined #gnucash
15:19:10 *** Phil_Ewert has joined #gnucash
15:25:50 <felipe__> warlord, ok
15:44:24 *** soa2ii has quit IRC
15:54:05 <jsled> felipe__: I believe warlord was referring to the gnucash-es mailing list.
15:54:15 <jsled> There's no irc channel (except the one you created ;)
16:02:20 *** ErKa has quit IRC
16:04:15 <felipe__> jsled, lol
16:18:30 *** palatin has quit IRC
16:37:03 <felipe__> So my accounting knowledge is almost unexistent, I aprooved accountability or however you spell it by winking my eye at the assitan teacher, so excuse the noob questions. To depreciate for example a car, I need an accout for the car and another account for the depreciation?
16:39:24 <warlord> right. an Asset for the car, an expense for the depreciation.
16:41:00 *** KaiForce has quit IRC
16:41:37 *** twunder has quit IRC
16:42:22 <felipe__> warlord, The accountant gave me an account plan (is that how you call it in english?) where he has for example the car and the depreciation account under Fixed Assets (Im translating literaly, so it might not make sense), if the depreciation asset is a sub account of a fixed asset it cant be an expense right?
16:43:05 <felipe__> I'm thinking the guys is going to have to restructure the account plan to fit with gnucash....
16:43:44 <warlord> he could be using contra accounts.
16:43:51 <warlord> have you read the docs? and the FAQ?
16:44:25 <felipe__> I'm on the beginer guide right now, the FAQ I haven't read.
16:45:20 <felipe__> be back in a while, boss calling. Thanks for the help
16:47:18 <warlord> ok
17:27:32 <felipe__> I'm back
17:33:55 <warlord> really? i'm front.
17:41:57 *** kielein has quit IRC
17:45:33 <felipe__> have to go, thanks again.
17:45:35 <felipe__> bye
17:45:50 *** felipe__ has quit IRC
17:49:16 *** andyt has quit IRC
18:14:17 *** eukreign2 has quit IRC
18:15:54 *** eukreign has joined #gnucash
18:24:41 *** soa2ii has joined #gnucash
18:36:13 *** titanae has joined #gnucash
18:38:56 <titanae> imported .qif files of 2008, pre-defined categories before import, matched up unspecified with new categories, import successful, changed dates to 1/01/2008 and 12/31/2008, select transaction report and report appears with zeroes
18:38:56 <gncbot> titanae: Sent 21 hours and 17 minutes ago: <warlord> You should create your account tree first, then map your qif accounts to the gnucash accounts during the import process. You should also upgrade to 2.2.9 before doing it.
18:40:17 <titanae> The only step I did not do was upgrade to 2.2.9
18:40:19 <warlord> titanae: check your currencies?
18:40:35 <titanae> one moment
18:43:49 <titanae> Currency is set to USD
18:44:15 <warlord> What's the report currency? What are your account currencies?
18:45:13 <titanae> one moment
18:46:26 <foo> hmm
18:46:32 <foo> 18:53 <@warlord> foo: Process Payment to your checking account and then manually change it from Checking to Expenses:Write Off
18:46:35 <foo> warlord: fwiw, that won't work
18:46:55 <foo> oh, wait, I could go in and do that
18:47:00 <foo> after I process it
18:47:01 * foo does
18:51:50 *** goodger_ has quit IRC
18:52:29 *** goodger has joined #gnucash
18:54:48 <foo> warlord: around?
18:55:41 <warlord> Actually, I'd like to think I'm taller than I am wide.
18:56:02 <titanae> it works for transaction report but some values are missing from the import, it works for general ledger but incomplete and that is it
18:57:09 <warlord> Well, if you didn't update it's likely the import skipped some transactions. Are they in the registers?
18:57:12 <foo> warlord: :P Bleh, ok, I am trying to reconcile an account and I have a difference. What creates a difference? This isn't too hard... funds come in, they go out... I don't get why this isn't lining up and I've been banging my head against the wall trying to figure it out. If there was a difference of $1000, for instance, then why doesn't my remaining balance just say $1000 at the end of the billing period?
18:57:40 <titanae> currency usd is selected for balance, income and account summary. Yes all of the info is listed in registry
18:57:42 <warlord> foo: Did you enter in the correct ending balance off your statement?
18:57:58 <warlord> titanae: check the account currenies
18:58:30 <titanae> account categories you are referring to
18:59:06 <foo> warlord: yeah, I entered the amount that's shown on 12/31/08, which is the statement end period I set prior to the reconcile window
19:00:03 <warlord> The amount shown on your 12/31/08 statement?
19:00:31 <warlord> And you've gone off 1 by 1 and ticked off all the transactions from your statement? You didn't miss anything?
19:02:26 <titanae> warlord: all categories has usd currency selected
19:02:37 <titanae> all account categories this is
19:03:55 <warlord> Check the dates....
19:04:53 <foo> warlord: yeah, funds in = ~$8000 funds out = ~$7000... funds out was triple checked, funds in is straight from invoices
19:05:51 <warlord> foo: are you sure the previous reconciliation was correct?
19:06:31 <titanae> selected one of the categories to edit there is no option to input dates I look at the register and the dates are there per when the transaction happend
19:07:03 <foo> warlord: good question, I was thinking that might be the problem. No, I'm not 100%... it was a year ago. err, I don't get why it wouldn't be, but I can't think of any other reason for this.
19:07:04 <warlord> titanae: I dont understand what you mean by "selected on of the categories to edit"? Huh?
19:07:33 <warlord> foo: you accidentally deleted or moved a previously-reconciled transaction?
19:08:25 <foo> warlord: not that I can recall. I think I'll just leave this unreconciled for now and revisit it later today (after my meeting with the accountant). I'll review all of 2007 to see if there was a problem there
19:08:44 <warlord> ok..
19:08:51 <warlord> (this is why you should reconcile often)
19:09:24 <foo> warlord: I know :/ I need to be on top of things... completely agree with you. Thanks for being patient in dealing with me...
19:09:42 <titanae> you typed check the dates unless this was for foo
19:10:34 <warlord> titanae: no, it was, but you can check the dates in the register and in the report options. I have no idea what you mean by "categories to edit"
19:11:51 <titanae> the dates are 01/01/2008 to 12/31/2008
19:12:28 <warlord> in the report...
19:12:47 <warlord> and the accounts are selected properly? and the dates of the transactions in the register fall into that date?
19:14:04 <titanae> yes
19:15:42 <warlord> which report is failing?
19:18:53 <titanae> balance, income, and account summary
19:19:10 <warlord> Balance Sheet fails?
19:19:20 <titanae> I am searching for guncash 2.2.9 for ubuntu
19:21:30 <titanae> yes all zereos
19:23:03 <warlord> show me.
19:23:16 <icpb> ams has joined on freenode
19:23:25 <warlord> sorry, I just dont believe that it'll all be zero with the default settings.
19:23:43 *** Zoolooc has quit IRC
19:23:50 <icpb> <ams@freenode> is there some sort of hack for importing transactions from paypal for gnucash?
19:24:06 <warlord> ams: come over to gnome.irc.org
19:24:15 *** warlord sets mode: +b *!*supybot@*.dsl.pltn13.pacbell.net
19:24:22 *** icpb was kicked by warlord (warlord)
19:25:24 <warlord> jsled: that will do it. :)
19:25:40 *** ams has joined #gnucash
19:25:46 <jsled> warlord: thanks
19:26:17 <ams> is there some sort of hack for importing transactions from paypal for gnucash?
19:26:19 <warlord> jsled: you're welcome.
19:26:30 <warlord> ams: download them as QIF or OFX?
19:26:43 <warlord> Or use a CSV->QIF converter?
19:26:46 <ams> warlord: was thinking more of a "press me, and i'll do your dishes" thing
19:26:54 <warlord> nope
19:27:04 <warlord> not unless PP has a qif download.
19:27:09 <titanae> can I upload a sample of the file somewhere to your attention
19:27:20 <ams> any means of doing batch imports?
19:27:24 <titanae> I never had this problem before
19:27:57 <titanae> I did this in January it worked fine and you talked me through reconciling and bingo all worked fine
19:28:00 <warlord> titanae: upload screen shots to imagebin.ca ?
19:28:12 <titanae> will do
19:30:23 <warlord> ams: no
19:30:30 <warlord> it requires the GUI
19:38:10 <titanae> warlord there are three (3) images for your viewing
19:39:16 <warlord> titanae: I need the URLs..
19:39:29 *** ams has quit IRC
19:39:51 <titanae> one moment
19:40:35 <titanae> http://imagebin.ca/view/MOMmKf.html
19:40:54 <titanae> http://imagebin.ca/view/3suDK_f.html
19:41:27 <titanae> http://imagebin.ca/view/ZwVgxqp.html
19:42:09 <warlord> titanae: I also need to see an account register.
19:42:44 <titanae> one moment uploading this one
19:44:01 <titanae> http://imagebin.ca/view/ZyMgNVrs.html
19:44:09 <warlord> Also, are you sure you have the correct double-entry account settings?>
19:45:11 <titanae> one moment
19:46:01 <warlord> I can tell you right now that no, you didn't.
19:46:21 <warlord> Your import has transactions debiting and crediting the same account, which is why it's all 0.
19:46:41 *** soa2ii has quit IRC
19:46:42 <warlord> you should start over and import it all properly -- you assigned the accounts incorrectly during the import.
19:48:15 <titanae> created new account lets say test
19:48:25 <titanae> I chose business accounts
19:48:57 <titanae> I removed the categories I did not need and kept the ones I did
19:50:25 <titanae> Is it here that I have to access each category edit it, enter in the amount, save and then import the .qif files?
19:51:46 <warlord> titanae: have you read the gnucash docs?
19:52:42 <warlord> You clearly don't understand double-entry accounting.. I recommend you read the docs to get a basic understanding of at least the different types of accounts before you import your data.
19:53:11 <warlord> QIF Categories map to GnuCash Income/Expense accounts, but you also need to map in the QIF Accounts to GnuCash Asset and LIability accounts.
19:55:54 <titanae> I read double account entries docs
19:56:38 <titanae> I customized the categories before I imported the data
19:56:44 <warlord> dont do that
19:56:59 <warlord> you should map stuff properly...
19:57:06 <warlord> (which you clearly didn't do)
19:57:25 <warlord> Basically, you imported your data wrong, which is why the reports appear to be 0.
19:57:25 <titanae> Okay so if I select business accounts just accept as is and make not changes to the categories
19:57:33 <warlord> correct.
19:57:42 <warlord> feel free to add new ones if you need to.
19:57:55 <titanae> After the import?
19:57:57 <warlord> But stop thinking about "categories"
19:58:12 <warlord> The QIF importer can create new accounts if you need them.
19:59:18 <titanae> I will select currency, select business account, click on to setup new accounts and apply
19:59:33 <titanae> next will import the .qif files
20:00:10 <warlord> titanae: http://cvs.gnucash.org/docs/help/import-qif.html
20:00:22 <titanae> yes I seen and read this
20:00:58 <warlord> Then you clearly don't understand the differnce between an Account and a "Category".
20:01:12 <warlord> Anyways, I have other things to do.
20:01:22 <warlord> Sorry. Good Luck.
20:01:38 <warlord> Just remember: You're importing transactions into your ASSETS..
20:01:51 <warlord> You dont import Income/Expense Accounts (categories)
20:02:10 <warlord> Keep that in mind as you enter your data.
20:02:15 <warlord> (and run the importer)
20:02:38 <titanae> thanks
20:18:11 *** titanae has quit IRC
20:59:26 *** warlord is now known as warlord-afk
21:29:59 *** rafael has left #gnucash
22:18:24 *** twunder has joined #gnucash
22:46:27 *** JimRaehl2 has left #gnucash
22:47:18 *** Jimraehl has joined #gnucash
22:49:30 *** twunder has quit IRC