2010-11-30 GnuCash IRC logs
00:16:41 *** Slurpee has quit IRC
00:21:36 *** Slurpee has joined #gnucash
00:42:24 *** Slurpee has quit IRC
02:51:33 *** e-ndy has joined #gnucash
03:13:48 *** opalepatrick has joined #gnucash
03:30:12 *** fell has quit IRC
04:43:44 *** fDavid has joined #gnucash
05:45:23 *** opalepatrick has quit IRC
05:50:38 *** opalepatrick has joined #gnucash
06:10:21 *** opalepatrick has quit IRC
06:12:40 *** opalepatrick has joined #gnucash
06:51:21 *** e-ndy has quit IRC
06:57:58 *** e-ndy has joined #gnucash
07:04:20 *** fbond has joined #gnucash
07:15:26 *** Slurpee has joined #gnucash
07:17:03 *** mikee has joined #gnucash
07:18:39 *** kpreid has quit IRC
07:19:46 *** fbond has quit IRC
07:42:04 *** kpreid has joined #gnucash
08:03:03 *** opalepatrick has quit IRC
08:07:11 *** opalepatrick has joined #gnucash
08:16:46 *** Jimraehl has left #gnucash
08:19:28 *** Slurpee has quit IRC
08:25:54 *** fbond has joined #gnucash
08:30:00 *** mikee has quit IRC
08:37:49 *** Jimraehl has joined #gnucash
08:40:35 *** neutronium has joined #gnucash
08:51:18 *** opalepatrick has quit IRC
09:14:46 *** kpreid has quit IRC
09:23:56 *** opalepatrick has joined #gnucash
09:25:17 <opalepatrick> oldtux: I chickened out. I ran e2fsck -fy /dev/sda1 and got something like - warning. partition mounted you WILL cause SEVERE damage if you proceed do you want to?
09:31:47 <jsled> opalepatrick: mischan again, I believe
09:36:38 *** kpreid has joined #gnucash
09:49:54 *** Linuturk has quit IRC
09:53:39 *** Linuturk has joined #gnucash
09:55:16 *** fell has joined #gnucash
10:22:46 *** neutronium has quit IRC
10:24:11 *** kpreid has quit IRC
10:38:36 *** warlord-afk is now known as warlord
11:17:19 *** e-ndy has quit IRC
11:21:43 *** opalepatrick has quit IRC
11:28:22 *** kpreid has joined #gnucash
12:31:31 *** ace has joined #gnucash
12:31:39 <ace> good morning all!
12:31:58 <ace> ik begrijp dat er hier een flink aantal nederlanders zijn ?
12:32:16 <ace> hi jsled
12:32:49 <jsled> hello again. :) this is an english-language channel, for the most part.
12:33:13 <ace> thx, jsled
12:34:07 <ace> I am using GNUCash for the first time in my real small business. I got the first year entered now, and using ANG, EUR and USD as currencies. But somehow I can never get
12:34:30 <ace> everything balabced right. There is always a difference on the balance sheet
12:34:52 <ace> I also can't understand what are unrealized gains/losses it seems to have to do with the currencies
12:35:27 <ace> What I did was book al accounts with currencies towards one currency (ANG) and it still shows an unbalance.
12:36:10 <ace> I really would like to work with an open source/ free software book keeping program but i am at (unrealized) loss here! Can anybody help explaining this...?
12:37:49 <warlord> ace: whenever you exchange currencies you need to track the gain/loss of that exchange. Unfortunately in 2.2.x you have to do that manually. In 2.4 there will be an option to get gnucash to track it for you.
12:38:52 <warlord> So let's say you exchange 100EUR for 140USD, but then you later change those 140USD for 90EUR. You've now lost 10EUR, which would cause your balance sheet to go out of whack.
12:38:59 <ace> warlord (nice nickname!) could you spent some minutes to elaborate on that?
12:39:24 <warlord> It would be better if you go out and read Peter Selinger's website on the topic.
12:39:29 <ace> becasue I am not sure if I am 'trading' moneuy like that
12:39:39 <ace> Hmm i think i was just reading that let me check
12:39:42 <warlord> If you have multiple currencies then most likely you are.
12:40:14 <ace> http://www.mscs.dal.ca/~selinger/accounting/gnucash.html ?
12:40:40 *** opalepatrick has joined #gnucash
12:41:10 <opalepatrick> oldtux: thanks for the help previously. A file system repair on the first partition sorted it.
12:41:47 <jsled> opalepatrick: I believe you're still in the wrong channel. :)
12:42:14 <warlord> ace: yes
12:42:42 <opalepatrick> Very sorry. I boot up my irc client and it auto loads a number of channels, but I dont realise it has slipped away from the one I really want. :-)
12:43:13 <ace> hi opalepatrick
12:43:57 <ace> warlord: i read that, sort of... and what I gather from it, gnucash does NOT handle multiple currencies well... but I am still having a question
12:44:37 <ace> I have most entries in ANG but I also have a Credit Card in USD.
12:44:41 <warlord> ace: 2.2 does not. 2.4 will have trading accounts.
12:45:44 <ace> the stuff in the CC account is all in USD, (the payments) but the Expenses are in USD too (I created seperate USD and ANG account for each expense).
12:46:15 <ace> At the end of the year, I transfer the balance of the USD account to the ANG account against a certain exchange rate
12:46:25 <ace> So the balance of the CC account is zero
12:46:41 <ace> Also I transfer the USD Expense accounts to ANG
12:46:48 <warlord> right, but is the exchange rate the same going in and going out?
12:46:54 <warlord> .. same thing.
12:47:01 <ace> So I am left with a lot of zero balnced accounts in USD
12:47:03 <warlord> Those transfers are (possibly) what are causing your imbalance.
12:47:08 <ace> and only ANG accounts
12:47:13 <warlord> Yes, but ... now you're trading currencies
12:47:20 <warlord> You go from ANG->USD->ANG
12:47:30 <ace> warlord just from USD -> ANG
12:48:36 <warlord> How do you pay the credit card?
12:48:57 <ace> warlord good question
12:49:02 <ace> lol
12:49:13 <ace> I have income in USD that goes to the CC
12:50:10 <ace> So there is an invoice 1000 USD goes to AP/USD and an invoice 1000 ANG goes to AP/ANG (two different accounts)
12:50:39 <ace> when they get paid, they are booked in their own currency
12:50:50 <ace> so there is no 'trading' between the accounts
12:51:05 <ace> untill the end of the year where all the USD in each accounts go to ANG
12:52:47 <ace> should that leave an imbalance?
12:56:15 <ace> warlord if I go out and start testing 2.3.17, will it handle currencies right, even from an existing 2.2 file ?
12:57:55 <warlord> I dont know what it will do from a 2.2 file.
13:00:21 *** andyt has joined #gnucash
13:09:24 <ace> ok thx by
13:09:28 *** ace has left #gnucash
13:40:50 *** ironwolf1 has joined #gnucash
14:15:50 *** cortana has joined #gnucash
14:25:49 *** Slurpee has joined #gnucash
14:27:15 *** donfede has quit IRC
14:27:58 *** donfede has joined #gnucash
15:06:15 *** Sea has joined #gnucash
15:07:41 <Sea> Hello all, I've a question about a foreign transaction question
15:08:35 <Sea> Can someone help?
15:12:03 <warlord> not until you ask your question
15:17:44 <Sea> I set up this account Assets (USD)/Cash Assets (USD)/Cash $R (BRL) and Expenses (USD)/Vacation (USD)/Cash $R (BRL). over the years I added a few transactions in this account (vacation expenses). The last one I made was to expense 1411 BRL so that the balance would be 100 BRL.
15:18:20 <Sea> However GNUCASH keeps on "correcting" my transaction into 1411.01 with a balance 99.99. It must be a exchange rate problem but I can't figure it out. Any ideas? thanks
15:20:36 <Sea> I googled that problem and search through various forums to no avail
15:21:57 <warlord> It's most certainly an exchange rate problem.
15:22:08 <warlord> What exchange rate did you enter?
15:22:36 <warlord> (although you shouldn't need an exch rate if you're going from BRL->BRL)
15:25:14 <Sea> Exactly for that particular transaction there shouldn't be any exchange rate because both accounts are in BRL but I set an exchange rate through Price Editor of 1$ for 1.72 BRL which correspond to a previous transaction
15:26:37 <Sea> that previous transaction is between the Cash $R (BRL) and a expense account in USD
15:30:16 *** fDavid has quit IRC
15:53:03 <warlord> Well, how are you entering the transaction? From which interface?
15:53:18 <warlord> (sorry, Sea .. got dragged away)
15:53:30 <warlord> My guess: you're using the General Ledger for the entry?
15:55:02 <Sea> Yes from the Ledger
15:55:56 <warlord> And I bet your computer locale is 'C' or 'en_US' or some other USD area?
15:56:34 <warlord> The reason you're having issues here is that the GL always creates transactions with a TRANSACTION currency of your locale. If you entered the transactions from the actual account registers then you wouldn't have an issue.
15:56:56 <Sea> yes
15:59:55 <Sea> let me take that yes back. I entered the transaction in the Cash $R (BRL) tab (not sure what is the GL?)
16:00:58 <jsled> GL is "General Ledger"
16:01:50 <Sea> I understood that but what the difference between the GL and the actual account register then
16:04:52 <warlord> in this particular case, the difference is that a transaction created in an account register has a common-currency of the account-currency, whereas a txn created in the GL has a common-currency of your locale currency.
16:09:59 *** Slurpee has quit IRC
16:14:42 <Sea> that make sense but to make sure we are talking about the same thing how do I open the GL?
16:17:05 <Sea> I entered the txn in a tab that looked like figure 4.2 in http://www.gnucash.org/docs/v2.0/C/gnucash-help/ch04s03.html
16:20:27 <warlord> How did you open the tab?
16:20:36 <warlord> The GL is available under, IIRC, the Tools menu?
16:21:03 <warlord> 4.2 looks like the "Cash in Wallet" account, opened by double-clicking on the account in the Chart of Accounts page.
16:21:30 <Sea> I opened the account just like you just described
16:21:59 <Sea> the GL is available under the Tools menu but I've never used it
16:22:49 <Sea> sorry about this GL/account register but I needed to make sure we were talking about the same thing
16:24:18 *** ErKa has joined #gnucash
16:27:23 <warlord> If you're from/to accounts have the same currency then there shouldn't be an exchange rate. Can you verify you set the correct currency on the account(s)?
16:29:08 <Sea> That's the 1st thing I verified and I just re-verified it !
16:30:33 <warlord> Delete and re-create the transaction?
16:30:44 <warlord> .... make sure it's not an auto-fill?
16:33:12 <Sea> did delete and recreate, still same problem. I also manualy choose the Expenses:Vacation:Cash Expenses $R account from the drop-down list to bypass the auto-fill.... I even try to manual enter different exchange rates at different dates to see the effect
16:35:05 <Sea> Now I just realized that eventhough both accounts are in BRL the Expenses:Vacation:Cash Expenses $R is in USD !! How is that possible?
16:35:50 <warlord> Well, maybe you didn't check both accounts. ;)
16:36:37 <Sea> I did check both accounts and I'd printscreen the windows for you if you'd like
16:37:27 <warlord> Sure.
16:38:32 <Sea> can we do this via email? I have to leave soon
16:42:01 *** ErKa has quit IRC
16:44:15 <warlord> If you're going to do it via email, I recommend gnucash-user mailing list.
16:45:03 <Sea> Will you be on this channel tomorrow?
16:49:20 <warlord> I should be, US/EST
16:57:52 <Sea> ok see you tomorrow then I'm also on US/EST thanks for your help
16:58:25 *** Sea has left #gnucash
17:00:56 *** warlord is now known as warlord-afk
17:05:37 *** Slurpee has joined #gnucash
17:15:12 *** fbond has quit IRC
17:23:23 *** kpreid has quit IRC
17:28:34 *** markjenkinsparit has quit IRC
17:29:28 *** markjenkinsparit has joined #gnucash
17:32:54 *** kpreid has joined #gnucash
17:43:35 *** fDavid has joined #gnucash
17:56:38 *** fell has quit IRC
18:09:51 *** markjenkinsparit has quit IRC
18:26:05 *** andyt has quit IRC
18:28:26 *** opalepatrick has quit IRC
19:39:56 *** Slurpee has quit IRC
19:53:09 *** fbond has joined #gnucash
20:34:31 *** cortana has quit IRC
20:39:52 *** Jimraehl has quit IRC
21:08:12 *** fDavid has quit IRC
21:49:50 *** ironwolf1 has quit IRC
21:58:05 *** Jimraehl has joined #gnucash
22:16:40 <indigo> given a plain asset account (not the business A/R acct) is there some way I can produce a statement including present balance and recent transactions that I might give to a debtor?
22:18:15 <indigo> the transaction report is almost right, except it doesn't include the balance prior to the selected dates.
22:23:12 *** Slurpee has joined #gnucash
23:45:17 *** Slurpee has quit IRC
23:57:07 *** fbond has quit IRC