2010-04-25 GnuCash IRC logs

00:30:40 *** fDavid has quit IRC
00:31:12 *** fDavid has joined #gnucash
01:19:03 *** warlord-afk is now known as warlord
01:19:19 <warlord> dwrudy_: In the BILL you should set the line-item to the asset account, not the expense account.
01:19:27 <warlord> (if you want to treat it as an asset)
01:19:40 <warlord> Or you can just forego the bill/process payment completely and just use Checking -> Asset directly.
01:20:02 <warlord> But if you're using the Biz features, it would be: A/P -> Asset for the bill, and then Checking -> A/P for the payment.
01:29:44 *** warlord is now known as warlord-afk
01:40:41 *** dreamon_ has quit IRC
02:08:46 *** gour has joined #gnucash
02:29:37 *** gncbot has joined #gnucash
03:46:32 *** ErKa has joined #gnucash
03:54:09 *** gary has quit IRC
04:01:15 *** ErKa has quit IRC
04:12:14 *** fDavid has quit IRC
04:50:36 *** wingo has joined #gnucash
05:19:09 *** gary has joined #gnucash
06:14:00 *** bastl has joined #gnucash
06:16:02 *** bastl has left #gnucash
06:27:42 *** cortana has joined #gnucash
07:08:02 *** blizgerg has quit IRC
07:08:12 *** blizgerg has joined #gnucash
07:08:35 *** daedeloth has joined #gnucash
08:50:13 *** Jimraehl has left #gnucash
08:51:39 *** jean has joined #gnucash
09:03:33 *** Jimraehl has joined #gnucash
09:13:42 *** cortana has quit IRC
09:22:13 *** cortana has joined #gnucash
10:16:02 *** jsled has quit IRC
10:35:55 *** jsled has joined #gnucash
10:43:10 *** gour1 has joined #gnucash
10:50:02 *** Tao_ has joined #gnucash
10:51:04 *** gour has quit IRC
10:51:22 <Tao_> Hi, who can tell me what is different between "booked balance" and "noted balance"?
10:52:23 <jsled> linas: please op gncbot
11:46:37 *** fDavid has joined #gnucash
12:24:43 *** Mer|in has joined #GnuCash
12:30:00 *** fDavid has quit IRC
12:31:56 *** bentob0x has joined #gnucash
12:59:14 *** fDavid has joined #gnucash
13:04:11 *** dwrudy has joined #gnucash
13:10:45 *** dwrudy_ has quit IRC
13:18:27 *** ErKa has joined #gnucash
13:39:31 *** fDavid has quit IRC
13:45:36 *** blizgerg has quit IRC
14:00:31 *** lypso has joined #gnucash
14:13:30 *** matt1973 has joined #gnucash
14:15:27 <matt1973> when i import qif files it asks me to create a account and this account shows up with some alance when i delete this account it creates it gives me a imbalance account what is the account it creates and what does that have to dow ith anything ?
14:17:27 *** warlord-afk is now known as warlord
14:18:20 <warlord> matt1973: It depends whether it's a single-account QIF file or a multi-account QIF file. But regardless, you have to tell GnuCash where you're importing the transactions. It could be a new account, or it could be an existing account.
14:18:48 <warlord> So you need to map the initial QIF account (e.g. file account) to a GNC Account.
14:19:11 <warlord> And then for each transaction you need to map the FAR account correctly via the QIF Category or Payee/Memo mapping.
14:19:19 <matt1973> I dont understand any of that
14:20:08 <jsled> matt1973: it's not really asking you to create a new account, but instead to select which account the transactions in the QIF file are "based" in.
14:20:59 <matt1973> when i import the qif it asks me to name the account and it creates a an account called what ever it is i call it, and shows a negative balance i have no idea why or where this figure comes from
14:21:21 <warlord> matt1973: it creates that account because you're not mapping it to an already-existing account.
14:22:04 <matt1973> OH so when i create a file new file and name it altana i should also use altana as teh account name ?
14:23:38 <matt1973> wait that did not work
14:23:45 <jsled> what account is the QIF for?
14:23:46 <matt1973> okay let me start all over
14:23:56 <jsled> Is it like your checking account or something?
14:24:22 <matt1973> yes
14:24:29 <warlord> You have a file altana.qif. That will assume the transactions belong in an asset or liability QIF account named 'altana'. You can then map the QIF Account 'altana' to the GnuCash account Assets:Bank:Altana
14:24:44 <jsled> So, nevermind your datafile name … what he said. :)
14:25:20 <matt1973> would you mind walking me through the whole thing i have created all kinds of accounts and want t o delete them all and start all over
14:26:41 <matt1973> how would i completely delet everything and start from scratch
14:27:03 <jsled> File > New File will work.
14:27:18 <jsled> save as a different filename, or save over the previous one. whatever.
14:27:51 <matt1973> it doesnt ask me for a file name
14:28:09 <jsled> When?
14:28:39 <matt1973> i click on new file
14:29:03 <matt1973> it then goes to what type of an account i select checking and also common accounts ?
14:29:10 <jsled> sure, whatever you like
14:29:23 <jsled> It's not going to ask you for a file name until you save.
14:29:47 <jsled> The datafile is just a file, like a word processor or spreadsheet or something.
14:30:43 <matt1973> okay i did it i saved it as altana checking
14:30:56 <matt1973> now when i go to import my qif
14:31:56 <matt1973> it asks me to name the default qif account do I also name it altana checking ?
14:32:18 <warlord> It's asking you the QIF account name..
14:32:33 <warlord> It doesn't matter.. If it's altana.qif it will suggest altana.
14:32:43 <warlord> Then LATER in the importer it asks you to map QIF accounts to GNC Accounts
14:32:58 <matt1973> what does that have to do with the file i just created in no it never does
14:33:01 <warlord> That's where you map the altana QIF Account to your GnuCash Assets:... account
14:33:45 <matt1973> you mean the match qif catagories ?
14:34:50 <warlord> the page before. match qif accounts
14:35:32 <warlord> (I think the page before)
14:36:42 <matt1973> nope it never says anyhting about mapping any thing
14:37:31 <matt1973> and i havnt seen anyhitng that says anything about gnc
14:37:33 * warlord doesn't use any of the importers. I know there USED to be a "map qif account" page in there somewhere.
14:38:52 <jsled> "GNC" is just shorthand for "gnucash"
14:39:00 <matt1973> oh okay
14:40:15 <matt1973> okay I just started a new file and saved and named it altana 5
14:40:31 <matt1973> if i want to i,port qif file to that i go to import
14:40:46 <matt1973> select the qif file i want t o import
14:41:31 <matt1973> then it says select default account name
14:41:52 <matt1973> it auto fill download(3) should change the name here ?
14:42:14 <warlord> It will autofill based on the filename.
14:42:23 <warlord> this is asking for the default qif account.
14:42:38 <matt1973> i dont understaND THAT
14:42:46 <matt1973> qif account ?
14:43:10 <warlord> sorry, I dont have time to explain it now -- I need to head out.
14:43:12 *** warlord is now known as warlord-afk
14:43:13 <jsled> the account that corresponds to the transactions in the QIF file.
14:43:23 <jsled> your checking account
14:44:13 <matt1973> okay so here i should put the name of the file i just created "altana 5 "
14:44:15 <matt1973> ?
14:44:20 <jsled> no.
14:44:23 <jsled> forget your datafile name.
14:44:33 <matt1973> okay
14:44:34 <jsled> choose the gnucash account that corresponds to your checking account
14:44:42 <jsled> You did the "Common Accounts" hierarchy?
14:44:47 <matt1973> yes
14:44:57 <jsled> It'll be … something like Assets:Current Accounts:Checking
14:46:00 <matt1973> seriously they expect us to know that whoel string there shold be a drop down box to select and account
14:46:10 <jsled> there should be
14:46:13 <jsled> just a second.
14:46:17 <jsled> dog drama here. :)
14:46:25 <matt1973> LOL
14:47:32 *** ErKa has quit IRC
14:47:49 *** jean has quit IRC
14:48:35 <jsled> Ah, I see.
14:49:00 <jsled> So, nevermind the naming there. Forward to the "files loaded" screen, then forward again.
14:49:12 <jsled> You'll be at the "Match QIF accounts with GnuCash accounts".
14:49:27 <jsled> The name from before will be there for the "QIF account name".
14:49:46 <jsled> Select it and "Change GnuCash Account…" to select an account from the tree.
14:49:57 <jsled> (or create a new one)
14:50:03 <jsled> That'll be your checking account.
14:51:21 <matt1973> okay geez that was dificult it isnt explained very well whats happening there
14:51:33 <jsled> no, it's a shitty importer ui.
14:51:45 <jsled> s/no/no, I agree,/ :)
14:51:52 <matt1973> now that i know how to do that how i completely dlete everything and start over
14:52:05 <jsled> Just create a new datafile.
14:52:15 <jsled> File > New File.
14:52:34 <matt1973> well ya i understand that but i want all previous (about 8 of them to go away )
14:52:43 <jsled> So delete the files
14:52:46 <jsled> they're just files
14:52:51 <matt1973> where
14:52:56 <jsled> whereever you saved them.
14:53:06 <jsled> open one up and the path will be in the titlebar
14:53:23 *** lypso has quit IRC
14:55:55 <matt1973> okay. I am in the gnu folder how do I knnow what to delete and what not to delete
14:57:03 *** lypso has joined #gnucash
14:57:22 <jsled> I don't know I understand. If you have a datafile named 'altana 5', then find that file and remove it. Any files that start with "altana 5" and have timestamps and .xac or .log suffixes are file to go, too.
14:58:11 <matt1973> okay
14:59:48 <matt1973> done gee wiz what a mess
15:00:08 <matt1973> just wait till i satrt trying to get all my loans and credit cards an all into this thing damn
15:00:24 <matt1973> so tell me do you use gnu cash ?
15:00:52 <jsled> I used to, and develop for it, too. I don't at present.
15:01:08 <matt1973> when i srt with a anew file do i have to select checking account or can i just slect common accounts
15:01:22 <jsled> I'd go with the Common Accounts.
15:01:27 <jsled> It's a good hierarchy, especially for Expenses.
15:01:33 <matt1973> okay
15:03:12 <jsled> double-entry takes getting used to. gnucash takes getting used to. the qif importer is a bit wonky.
15:03:54 <matt1973> if i import all a qif of all transactions from jan 1st to present how can i later go back and adjust the opening balance
15:04:15 <jsled> opening balances are simply an appropriately-dated transaction against Equity:Opening Balances.
15:04:32 <jsled> So, you can edit or create the transaction as needed.
15:04:42 <matt1973> so i can just add a transaction with amount
15:04:49 <jsled> yup
15:04:53 <matt1973> okay
15:10:31 <matt1973> a crap jsled ?? I imported all transactions this year, I am using the importer it now is at teh window match qif accounts to gnucash accounts is this where i select teh assetes bla bla bla
15:10:49 <jsled> yes
15:12:01 <matt1973> now it comes back and says match qif catergories with gnucash accounts and it has
15:12:12 <jsled> yes
15:13:18 <matt1973> qif catergory name lisiintg 2 names 1 and 22 int he gnucash account name column it lists assets current assets checking account, then it has one called 22 what is this
15:13:50 <jsled> the names are "1" and "22" ?
15:14:04 <matt1973> ya for the qif
15:14:36 <matt1973> this is what looks like
15:15:01 <matt1973> qif catagory gnucash account name
15:15:20 <matt1973> 1 assets:current ..........
15:15:27 <matt1973> 22 22
15:15:40 * jsled nods
15:15:45 <matt1973> where did 1 and 22 come from
15:15:58 <jsled> There's something in the QIF data itself that's suggesting those labels.
15:16:19 <matt1973> shouold i just map to assets
15:16:24 <matt1973> checking
15:16:56 <jsled> I'm pretty sure you want to map to an Income account, but … you might want to open the qif file(s) and find the "22" label, and see waht sort of transaction it's referring to.
15:18:03 <jsled> And, once you find the "22" label, you should see what sort of record type it is (the first character of the line) … then you can find the same label for the "1" and see what type of transaction that is.
15:18:05 <matt1973> ya something is wrong it is saying i am negative 1500 and some od dolars now
15:18:48 <matt1973> its says i cannot opent he qif to look in it
15:19:34 <jsled> Your file browser probably doesn't understand how to do so, but it's just a text file, so you can open it in any text editor
15:19:41 <matt1973> OH I dont have my opening balnce
15:19:47 <matt1973> thast why it negative
15:19:57 *** matt1973 has left #gnucash
15:20:27 <jsled> did you do the expense mapping in the subsequent screen?
15:20:36 <jsled> That's really the key step of the QIF importing.
15:24:32 *** matt1973 has joined #gnucash
15:24:50 <matt1973> okay how do i add a transaction to correct this
15:25:07 <jsled> did you do the expense mapping in the subsequent screen?
15:25:09 <jsled> That's really the key step of the QIF importing.
15:25:19 <jsled> I doubt you did, cause it should have taken a good bit of time.
15:25:53 <jsled> But, to answer your question, just open either the account register or the equity:Opening Balances register and … add it. :)
15:26:48 <matt1973> okay
15:27:01 <matt1973> i never saw anyhting about exspence mapping
15:27:38 <jsled> The import screen is titled "Match payees/memos to GnuCash accounts".
15:27:41 <matt1973> but it seems to be have put everything int eh right accounts at a glance my net incomne to exspence reports look about right
15:27:57 <matt1973> nope i never saw a page like that
15:28:24 <jsled> where are all the trasnactions mapped to, then? Just the top-level "Expenses" account?
15:29:47 <matt1973> no i have sortrde all the way to fricken movies and cigerettes
15:29:59 <matt1973> every penny almost
15:30:21 <matt1973> but i have a feeling alot of those smokes are goig to compiled with GAS
15:30:29 <jsled> And they're all in the correct Expense sub-accounts?
15:30:37 <matt1973> im not paying tax ont hat
15:31:02 *** gour1 has quit IRC
15:31:02 <matt1973> seems to be alright
15:31:27 <jsled> ah. well, you must have done all the heavy lifting in the past, then, and it rememeberd for your subsequent imports.
15:31:40 <matt1973> yes it did
15:31:42 <matt1973> rember
15:32:10 <matt1973> now how do i off set that checking to show i had money in there when i started this
15:32:35 <matt1973> i dont want it ashow as income though i have already paid taxes on that money and dont want it to show as a income
15:33:15 <jsled> Equity:Opening Balances/
15:33:31 *** Tao_ has quit IRC
15:35:15 <matt1973> i did that and it shows a balance in equity but it does not offset my negative checking ballance
15:35:27 <matt1973> that money was in my checking when i started
15:35:31 <jsled> what's the transfer account set to?
15:35:34 <matt1973> from last year
15:35:44 <matt1973> um nothing
15:36:01 <jsled> You will *always* want to set a transfer account on every transaction you create.
15:36:09 <jsled> Set this one two your Checking account.
15:36:19 <jsled> This is the basis of double-entry.
15:36:29 <matt1973> AAAA okay
15:36:31 <jsled> s/two/to/.
15:36:33 <matt1973> that did it
15:36:40 <matt1973> now i have another question
15:36:57 <jsled> Change to the "auto-split" view mode, and it might be a bit more clear.
15:37:04 <jsled> (you'll see both Splits, and how they balance)
15:41:53 *** lypso has quit IRC
15:43:19 <dwrudy> Is there a way to run a report on *all* customers or vendors or invoices or bills or whatever else?
15:43:45 <dwrudy> right now, I only see how I can run a report on a single customer, invoice, etc... by searching for it
15:44:02 <matt1973> how do get rid of the unspecified i opened it and allocated them to the correct accounts but they remain in unspeciffied
15:47:46 <jsled> matt1973: how did you "open and allocate" them?
15:48:01 <jsled> If they're still in "unspecified", it's because they still have a split that references the "unspecified" account.
15:48:05 <matt1973> i doubled them and used the drop down menu
15:48:22 <matt1973> i fixed them I deleted them
15:48:24 <jsled> did you "Enter" the transaction?
15:48:31 <matt1973> and made new entries
15:48:39 <matt1973> no
15:48:47 <matt1973> where do enter the transation
15:49:18 <jsled> firstly, there's no need to enter new transactions and delete the others; you can just change the Split that references "Unspecified" to whatever account you like.
15:49:43 <jsled> The enter key will enter a transaction. Selecting another transaction will enter the one you're "leaving". I believe there's a menu/toolbar Action to do so, too.
15:50:31 <jsled> If you go through the Unspecified account register in auto-split mode, you can change the "Unspecified" account to whatever's appropriate, enter the transaction, and it will disappear from the current view.
15:51:05 *** lypso has joined #gnucash
15:51:14 <jsled> Normally we recommend entering/editing transactions from the Asset (or Liability) account registers cause it's a bit more intuitive, but this is a good case to do it from the Unspecified account.
15:51:29 <matt1973> oh okay ,, thansk for teh help jsled I have to go tot eh store i guess im tired of hearing the nagging
15:51:47 *** matt1973 has left #gnucash
15:54:50 *** PaulNema has joined #gnucash
16:09:11 *** wingo has left #gnucash
17:09:43 *** lypso has left #gnucash
17:14:33 <PaulNema> When setting up your books: Under "Book Options" What is Company ID used for?
17:21:04 *** gary has quit IRC
17:21:47 *** gary has joined #gnucash
18:08:57 *** PaulNema has left #gnucash
18:14:33 *** stain has joined #gnucash
18:14:56 <stain> hello, dudes! Love GnuCash! One strange question about automatic currency rates coming up..
18:15:36 <stain> if I open a new file, and set the currency to GBP, then create an Asset accout with the currency NOK, and I set the opening balance to NOK 100, if I then do "Get Quotes" the currencies are upside-down
18:15:50 <stain> it tells me I have a total of GBP 1105 in savings
18:16:19 <stain> while it should be £11.045082
18:16:42 <stain> could be related to NOK currencies often being listed in prices pr. 100 NOK instead of pr 1 NOK
18:16:54 <stain> (do this with MXN and everything works)
18:17:31 <stain> this is with 2.2.9 from Ubuntu 10.04 b2
18:33:19 *** daedeloth has quit IRC
18:34:34 *** hatman has joined #gnucash
18:53:22 <stain> (posted this to the mailing list)
19:30:11 *** bentob0x has quit IRC
19:49:47 *** hatman has quit IRC
20:37:25 *** cortana has quit IRC
20:46:48 *** dwrudy has quit IRC
20:57:35 *** blizgerg has joined #gnucash
20:57:35 *** talexb has joined #gnucash
21:28:20 <stain> hello
21:31:39 *** dwrudy has joined #gnucash
21:42:04 <dwrudy> Is there anyway to set a default "Extra Notes" in the Fancy Invoice section?
21:42:25 <dwrudy> or to put these notes which need to show up on all my invoices into the style sheet or something?
21:47:28 *** warlord-afk is now known as warlord
21:47:56 <warlord> dwrudy: Set the notes in the invoice, then never close the invoice page. Instead of running from Reports menu, just go to the report tab and run the report options to select the invoice.
21:48:11 <warlord> When you quit gnucash it will remember the open reports and settings/options/
21:48:55 <dwrudy> Oh, that's an interesting way of doing it
21:48:59 <dwrudy> Ok, thanks.
21:49:02 *** gary has quit IRC
21:49:48 *** gary has joined #gnucash
21:52:31 *** warlord is now known as warlord-afk
21:56:18 *** Jimraehl has left #gnucash
21:56:43 *** Jimraehl has joined #gnucash
22:06:05 *** Jimraehl has left #gnucash
22:12:21 *** Jimraehl has joined #gnucash
23:30:18 *** talexb has quit IRC
23:38:12 *** blizgerg has quit IRC