2008-11-06 GnuCash IRC logs
01:29:25 *** TimothyA has quit IRC
01:41:59 *** TimothyA has joined #gnucash
01:42:03 <TimothyA> anyone around?
01:54:42 *** warlord-afk is now known as warlord
01:54:55 <warlord> TimothyA: It's 2am here in the US.. People are asleep. (*I* should be asleep)
01:55:26 <warlord> When creating an invoice, the Customer, Income accounts, A/R accounts, and BANK (asset) account (used for Process Payment) *ALL* have to be the same currency.
01:55:42 <warlord> If you CHANGE the customer currency existing invoices do NOT take that change automatically.
01:56:03 <warlord> ... to get an invoice to take a customer currency change you have to edit the invoice, then go through the 'select' process to re-select that customer.
01:56:30 <warlord> The "counting USD" on the bottom is (I believe) a bug.
01:58:17 <TimothyA> yeh, it's 3AM over here ;>.> This thing is just keeping me awake
01:58:45 <TimothyA> anyhow, all the accounts are of the same currency for as far as I can detect
01:59:09 <warlord> And the customer?
01:59:12 <TimothyA> customer is EUR, income account is EUR, A/R account is EUR, and then I transfer from the A/R to my bank account.
01:59:34 <TimothyA> for USD it just works even though all my accounts are in ANG
01:59:42 <warlord> Huh?
01:59:52 <warlord> If your accounts are in ANG then USD shouldn't work.
01:59:54 <TimothyA> yeh, I got the customer, etc set up as USD
02:00:08 <warlord> Oh, well that's the problem.
02:00:17 <TimothyA> same as I did the EUR
02:00:35 <warlord> Wait... is the customer USD or EUR?
02:00:57 <TimothyA> EUR (different customer)
02:01:09 <TimothyA> I have 2 customers, and each one has their own currency
02:02:07 <warlord> Did you create the invoice for EUR-customer after you set the customer currency?
02:02:28 <TimothyA> yes
02:02:50 <warlord> Are you sure you're choosing the correct (EUR) Income accounts on the invoice... And EUR A/R account when you post?
02:03:14 <TimothyA> ...hey, it suddendly worked now o.O
02:03:44 * TimothyA has no idea what he did this time that was different from the other 63 times...I guess albert einstein wasn't right about insanity!
02:03:59 <TimothyA> anyhow, that brings me up to the next issue; taxes.
02:05:19 <TimothyA> I have to charge an 5% on all my invoices/sales, but all my invoices/sales are multi-currency. how will I make these show up?
02:06:14 <warlord> You'll need a tax table per currency.
02:06:29 <TimothyA> that makes sense ;>_>
02:06:30 <warlord> (because you'll need individual currency tax holding accounts)
02:07:38 <warlord> any other questions?
02:09:38 <TimothyA> why will the profit remain the same in the EUR and USD totals when I transfer both currencies to my main currency (ANG)?
02:09:54 <TimothyA> from the A/R into my checkings account
02:11:50 <warlord> because the profit is only computed off the Income and Expense accounts, not by asset conversion.
02:12:09 <TimothyA> oh
02:12:24 <TimothyA> so what am I supposed to do with the A/R?
02:12:32 <warlord> What do you mean?
02:12:35 <TimothyA> is this the right way? or am I doing something wrong?
02:14:08 <warlord> The right way of what?
02:14:14 <warlord> I still dont understand your question.
02:14:43 <TimothyA> Invoice -> Income / A/Receivable -> Checkings Account
02:15:38 <warlord> Right
02:15:46 <warlord> Er... sorta..
02:15:53 <warlord> Invoice: Income -> A/R
02:15:58 <warlord> Process Payment: A/R -> Checking
02:16:04 <TimothyA> aah
02:16:33 <TimothyA> ( Invoice -> Income ) -> ( A/Receivable -> Checkings Account )
02:16:43 <warlord> Huh??
02:16:47 <warlord> No... There are TWO steps..
02:16:48 <TimothyA> grah >_<
02:16:56 <warlord> Post Invoice and Process Payment.
02:16:57 <TimothyA> making the invoice is also a step?
02:17:03 * TimothyA nods
02:17:26 <warlord> Making the invoice is part of the first step.
02:17:50 <TimothyA> okay, so the invoice is posted and the values are in the income account and in the A/R
02:17:57 <warlord> Right.
02:18:14 <warlord> Then you Process Payment to say that the check has been received, and it goes from A/R to Checking
02:18:16 <TimothyA> and then I click on process payment and transfer the funds to my checkings account with the right conversion rate
02:18:35 <TimothyA> isn't "process payment" then the same as "transfer"?
02:19:12 <TimothyA> er, nevermind
02:20:43 <warlord> No. Process Payment is a special function necessary to move funds out of A/R. A regular transfer wont get noticed by the business reports.
02:21:08 <warlord> No, there is no conversion rate.. Although you could go add one later for the Payment transaction.
02:21:09 * TimothyA nods
02:24:33 <warlord> okay, bedtime for me
02:24:41 <warlord> good night, and good luck
02:24:43 *** warlord is now known as warlord-afk
02:27:27 <TimothyA> goodnight warlord, and thanks :)
03:16:14 *** bentob0x has joined #gnucash
03:42:25 <puck> Hey, I'm trying to reconcile an account but the opening balance is wrong ($600 more than it should), using the Account Summary report for the account on the opening day of the bank statement has the correct balance.
03:42:30 <puck> Any ideas where I can look?
04:11:20 *** ErKa has joined #gnucash
04:33:43 *** ErKa has quit IRC
06:06:07 *** ErKa has joined #gnucash
07:04:25 *** ErKa has quit IRC
07:16:17 *** twunder has joined #gnucash
07:37:11 *** JimRaehl has left #gnucash
07:40:13 *** twunder has quit IRC
07:49:07 *** esperegu has joined #gnucash
07:49:35 *** JimRaehl has joined #gnucash
07:53:23 *** esperegu has quit IRC
08:52:40 *** warlord-afk is now known as warlord
08:53:19 <warlord> puck: just ignore the opening balance, make sure you have the right date and right closingbalance. Then you'll probably find the mising $600 -- most likely a txn got unreconciled.
09:00:14 *** esperegu has joined #gnucash
09:04:13 *** TimothyA has quit IRC
09:04:30 *** TimothyA has joined #gnucash
09:14:42 *** Nakjeido2 has joined #gnucash
09:14:51 *** TimothyA has quit IRC
09:43:19 *** wizkid238 has joined #gnucash
11:28:48 *** benjamin has joined #gnucash
11:41:55 *** sjc has joined #gnucash
12:50:01 *** Zoolooc has joined #gnucash
12:53:51 *** kielein has joined #gnucash
12:55:39 *** twunder has joined #gnucash
12:59:49 *** twunder has quit IRC
13:17:48 *** Zoolooc__ has joined #gnucash
13:24:53 *** Zoolooc has quit IRC
13:37:36 *** TimothyA has joined #gnucash
13:37:48 *** Nakjeido2 has quit IRC
13:42:50 *** bentob0x has quit IRC
13:56:43 *** nomeata has joined #gnucash
13:56:54 *** andy has joined #gnucash
13:58:01 <andy> I have a question concerning multiple currencies:
13:58:16 <andy> how can I set a default exchange rate for a certain curreny pair?
13:58:47 <andy> when I transfer amounts between different accounts, gnucash assumes most times an exchange rate of 1
13:59:42 <andy> I tried setting a exchange rate in the currency editor
14:03:34 <TimothyA> when you transfer an amount of cash, you should be presented with two input boxes at the bottom of the dialog of which you can select one
14:06:04 <andy> I imported my transfers from a qif file and assign just accounts to them, so I don't get these dialog
14:07:13 <warlord> QIF doesn't handle multiple currencies.
14:07:23 <warlord> You'll have to hand-edit all your imported multi-currency txns
14:07:57 <TimothyA> ouch
14:08:43 <andy> i observed, if a currency rate for a certain day is present, the correct rate is choosen
14:08:54 <andy> can i somehow preload all of them?
14:09:15 <andy> if I do a split transaction I can not even open the dialog to set the exchange rate
14:11:22 <warlord> you can -- but only from the splits where it's a valid option based on the current view.
14:11:44 <warlord> As for pre-loading.. Um, sure, I think you could do that by hand.
14:13:29 <andy> is there any chance to script this? I don't need exact exchange rates...
14:19:14 <warlord> ummm...
14:19:19 <warlord> i honestly dont know.
14:20:22 <andy> ok, but thank you anyway
14:21:36 <puck> warlord: Re my reconciliation, the closing balance is wrong after going through all the txns on the statement - I've triple checked them all.
14:22:29 <warlord> puck: right... it should be off by the same amount that the opening balance was off.... Go find that mising transaction earlier, the one that USED to be reconciled but isn't anymore, and reconcile that too.
14:50:02 *** Nakjeido2 has joined #gnucash
14:50:10 *** TimothyA has quit IRC
15:08:10 *** andy has quit IRC
15:18:10 <puck> warlord: Okay, I'll try that tonight.
15:18:59 <puck> thanks
15:43:49 *** twunder has joined #gnucash
16:10:10 *** Nakjeido2 has quit IRC
16:15:02 *** Zoolooc__ has quit IRC
16:15:38 *** Zoolooc has joined #gnucash
16:59:52 *** twunder has quit IRC
17:40:56 *** ninja has joined #gnucash
17:48:53 *** Zoolooc has quit IRC
17:49:32 *** Zoolooc has joined #gnucash
17:50:07 *** nomeata has quit IRC
18:37:19 *** benjamin has quit IRC
18:45:20 *** Zoolooc has quit IRC
19:43:09 *** warlord is now known as warlord-afk
20:03:07 *** kielein has quit IRC
20:44:36 *** puck` has joined #gnucash
20:45:19 *** puck has quit IRC
20:46:32 *** puck` is now known as puck
20:57:54 *** sjc has quit IRC
21:25:23 *** twunder has joined #gnucash
21:38:18 *** JimRaehl has left #gnucash
21:38:59 *** JimRaehl has joined #gnucash
22:39:49 *** xi1 has joined #gnucash
22:41:06 <xi1> I"m trying to get finance::quote to work with gnucash on a stock bought on the Swiss exchange (SIX), ticker symbol: PSPN. When I run: stockdump.pl europe pspn I get values (53.40 close) but it says its in euros when that number should be in CHF
22:41:35 <xi1> how can i get finance::quote to use the SIX as the source
22:41:45 <xi1> i think its using some exchange in paris as its source
22:45:27 *** twunder has quit IRC
23:05:20 *** warlord-afk is now known as warlord
23:06:07 <warlord> xi1: gnc-fq-dump should give you a list of available sources.