2009-04-15 GnuCash IRC logs
00:07:33 *** XiXaQ has joined #gnucash
00:18:14 <mib_ov2px7> got it. Thanks to everyone who was unable to help since it forced me to figure it out myself. I learned quite a bit, but it all came down to stupid '\' chars in the category names. The date didn't have anything to do with it.
00:18:27 *** mib_ov2px7 has quit IRC
01:21:07 *** newbbie has quit IRC
01:28:50 *** blahdeblah has quit IRC
01:35:41 *** blahdeblah has joined #gnucash
01:40:54 *** blahdeblah1 has joined #gnucash
01:42:54 *** blahdeblah has quit IRC
01:48:11 *** bentob0x has joined #gnucash
01:52:55 *** bentob0x has quit IRC
01:55:50 *** bentob0x has joined #gnucash
02:26:11 *** puck has quit IRC
02:29:22 *** soa2ii has joined #gnucash
03:08:44 *** moon has joined #gnucash
03:16:14 *** moon has left #gnucash
03:31:28 *** MechtiIde has joined #gnucash
04:17:06 *** tim_abell has joined #gnucash
04:20:30 *** Cho has joined #gnucash
04:20:52 <Cho> HI everyone
04:21:30 <Cho> Is this an accounting only chat room?
04:22:13 <Cho> Anyone know someone who is good at marketing who are currently looking for work?
04:46:50 *** Cho has quit IRC
06:29:18 *** bentob0x has quit IRC
06:48:34 *** soa2ii has quit IRC
06:53:05 *** soa2ii has joined #gnucash
07:50:02 *** bentob0x has joined #gnucash
08:51:48 *** KaiForce has joined #gnucash
08:58:59 *** warlord-afk is now known as warlord
09:23:06 *** Elvanor has joined #gnucash
09:23:47 <Elvanor> Hi, I need the help of someone at least a bit competent with french accounting
09:28:01 <XiXaQ> in that case, I'd suggest you use the mailinglist. You'd be very lucky if you'd happen to be here at the same time as a french accountant, I think.
09:30:10 <warlord> You can also try the gnucash-fr mailing list, but I don't know how active it is.
09:37:40 <XiXaQ> passive mailinglists may have readers though.
09:41:01 <warlord> True.
09:48:06 <XiXaQ> how many active developers are there in the GnuCash project?
09:48:58 <warlord> define "active"?
09:49:03 <warlord> (the answer is "not enough")
09:49:38 <XiXaQ> developers who are knowledable enough to do necessary stuff, and available?
09:50:24 <warlord> I'm not sure. Check the trac timeline and see who's made commits recently?
09:50:24 * tim_abell is active but not useful
09:50:35 <XiXaQ> tim_abell, how come?
09:50:49 <warlord> XiXaQ: did you have a patch you wanted committed or something?
09:50:53 <tim_abell> haven't been working on anything except what I want :)
09:51:03 <tim_abell> not yet, working on some reports
09:51:13 <tim_abell> oh, wrong person
09:51:19 * tim_abell goes back to sleep / work
09:53:01 <warlord> tim_abell: I think most people start with working on stuff that works for them.
09:53:12 <XiXaQ> warlord, no. But I live in Norway, and I think we have a rather desperate need of a FOSS accounting system. However, there are some laws and rules that accounting software needs to follow in order to be legal to use in businesses. If GnuCash doesn't comply to those rules, I'd like to make it so, but since I don't know C well enough, it'd be necessary to hire someone to do the work.
09:54:26 <warlord> You might be better just finding a local developer who knows C.
09:55:37 <XiXaQ> but then he'd have to study gnucash first, which would cost more money. I was thinking more like paying per feature. Bounty?
09:55:48 <jsled> We've never seen that work.
09:55:55 <jsled> I'd recommend going the other way, too.
09:58:46 <XiXaQ> how long will it take a good C programmer to understand gnucash well enough to start developing?
10:02:03 <Elvanor> XiXaQ: ok
10:02:09 <warlord> Depends on what features need to be developed.
10:02:56 <Elvanor> I am not sure I should use the ML though as the question is about OpenERP, not GnuCash. That's an accounting question though...
10:03:21 <Elvanor> http://www.openobject.com/forum/topic10656.html
10:03:21 *** chris has quit IRC
10:03:24 <Elvanor> if anyone is interestedc
10:04:52 *** chris has joined #gnucash
10:04:59 <warlord> Elvanor: I suspect OpenERP questions would not get answered on gnucash lists.
10:05:07 <Elvanor> warlord: yep
10:05:24 <warlord> Although gnucash-user is a good source of general accounting knowledge.
10:05:35 <Elvanor> I just need to know from which account I should draw the initial capital
10:06:07 <Elvanor> After learning a bit of OpenERP I can currently use it, but my very poor accounting knowledge prevents me from doing what I need
10:09:58 <warlord> It depends what you mean by "Draw initial capital" -- are you starting your accounting from before the business entity existed? Or are you trying to intiialize your data file to the current state of affairs?
10:11:12 *** XiXaQ has quit IRC
10:12:56 <Elvanor> warlord: from before the entity existed
10:13:03 <Elvanor> eg, I just created my company
10:13:19 <Elvanor> so I am starting accounting "from the start", I guess
10:13:20 <warlord> Okay, then... It would be Equity:Owners Equity
10:13:30 <Elvanor> ha
10:13:33 <warlord> (or Equity:Capital Deposit)
10:13:50 <Elvanor> warlord: this is for the US Chart of Accounts, right?
10:14:25 <warlord> yes.
10:14:35 <warlord> (although you may need to create said Equity subaccount)
10:14:50 <Elvanor> Let me see if I can find the french equivalent account
10:15:04 <Elvanor> And to which account would it be deposited?
10:15:05 <Elvanor> Capital?
10:21:50 <warlord> It would be a txn from Eq:Capital -> Assets:Bank
10:22:44 <Elvanor> warlord: txn?
10:22:57 <warlord> sound it out
10:23:17 <Elvanor> I am not a native speaker... transaction I guess?
10:23:43 <warlord> yes
10:25:09 *** KaiForce_ has joined #gnucash
10:26:49 *** KaiForce_ has quit IRC
10:27:08 *** KaiForce has quit IRC
10:37:33 *** soa2ii has quit IRC
10:40:21 *** bu11y has joined #gnucash
10:41:16 *** eukreign has quit IRC
10:41:43 <bu11y> I have a question on OFX downloads from TD Ameritrade
10:41:49 *** eukreign has joined #gnucash
10:42:14 <bu11y> There are these subaccount tags in the OFX document
10:42:25 <bu11y> are these not supported by gnucash 2.2.9?
10:43:57 <warlord> bu11y: you might want to ask on gnucash-user ml
10:44:09 <bu11y> k, thanks!
10:44:21 <warlord> but hang out here too just in case.
10:44:25 <bu11y> k
10:44:26 <warlord> (I dont know the answer to that one)
10:54:36 <tim_abell> "he just probably doesn't know any better."
10:54:44 <tim_abell> damn wrong channel
10:54:48 <tim_abell> i'd better watch that
10:56:22 <warlord> LOL
11:00:47 <warlord> gotta run for a bit
11:00:49 *** warlord is now known as warlord-afk
11:12:42 *** MechtiIde has quit IRC
11:14:59 <roe_> is there a way for me to get a "total deposit" and "total withdrawal" report for a certain date?
11:41:35 *** Rolf2 has quit IRC
11:43:21 *** Rolf1 has joined #gnucash
11:51:17 *** bu11y has quit IRC
11:52:45 *** ErKa has joined #gnucash
11:53:20 *** dbreiser has joined #gnucash
12:15:13 *** warlord-afk is now known as warlord
12:15:25 <warlord> roe_: what you mean by "total deposit" and "total withdrawal"?
12:15:44 <warlord> You could run a Cash Flow for just that date.
12:16:49 <roe_> I'm reconciling a checking account, and my bank statement provides me with totals for deposits and withdrawals, I was hoping to be able to compare those numbers to see where my problems lie
12:17:22 *** MechtiIde has joined #gnucash
12:17:43 *** dbreiser has quit IRC
12:17:56 <warlord> it doesn't give you an itemized list of txns?
12:18:34 <roe_> it does, but sometimes it is easier to compare totals
12:19:27 <warlord> note that your dates and their dates don't necessarily match. so that wouldn't help you.
12:20:00 <warlord> just go through your statement and mark off the txns 1 by 1. if you dont find the txn in your gnucash file then you know what's missing.
12:27:46 *** goodger_ has joined #gnucash
12:36:06 *** goodger has quit IRC
12:42:36 *** tim_abell has quit IRC
12:52:48 *** ErKa has quit IRC
13:20:03 *** iamawake has quit IRC
13:57:41 *** ErKa has joined #gnucash
14:16:16 *** hvx has joined #gnucash
14:26:05 *** donfede has joined #gnucash
14:30:50 *** hvx_ has joined #gnucash
14:38:27 *** KaiForce has joined #gnucash
14:39:11 *** hvx has quit IRC
15:31:56 *** hvx has joined #gnucash
15:34:34 *** hvx_ has quit IRC
16:10:46 *** hvx has quit IRC
16:14:22 *** bentob0x has quit IRC
16:16:13 *** KaiForce has quit IRC
16:23:23 *** moon has joined #gnucash
16:24:22 *** puck has joined #gnucash
16:26:34 <moon> Hi. I am doing some multi-currency transactions according to Peter Selinger's tutorial. It says "Sometimes a transaction will show up correctly when viewed from one account, and all the entries will be blank when the same transaction is viewed from another account. This is a bug in GnuCash (bug #410604). There is currently no way around it, except to delete the transaction and start from scratch. [Update 2007/03/23: M
16:28:17 <moon> If someone could guide me through the steps it would be nice.
16:34:18 <warlord> Have you tried the Edit Exchange Rates context-menu item?
16:34:25 <warlord> Have you tried it from multiple sides?
16:35:07 <warlord> (this code was working when it was first written but it's so spaghetti in there... There are multiple code paths all depending on how you move around the register)
16:37:11 <moon> I'm blindly following the manual to do currency trading accounts in GnuCash, "by hand". So not using the gnucash's currency exchange
16:37:32 <moon> http://www.mathstat.dal.ca/~selinger/accounting/gnucash.html#4 Shown here
16:37:50 <warlord> Yeah yeah yeah..
16:37:55 <warlord> Selinger is 90% correct.
16:38:06 <warlord> But that 10% is a HUGE issue.
16:38:16 <warlord> But you cannot do that in GnuCash right now.
16:38:43 <moon> hmm...not good...I have this balance sheet out of balance issue with multiple currency..so don't know what to do.
16:39:27 <warlord> Well, 4. How to do SSAP 20 accounting in GnuCash says quite clearly that in GnuCash you treat everything as a single currency.
16:39:40 <warlord> So you're not even following his instructions.
16:39:53 <moon> yes...but I need to track income and expense .
16:40:19 <warlord> Translate it.
16:41:22 <moon> I have expenses and income both in CAD and USD. With assets and liabilities in both currencies. I need to track all of them.
16:41:32 <warlord> E.g., when I go to Europe and spend €20 on dinner, I enter that as $32
16:42:20 <warlord> And how are you entering your transactions? In what interface?
16:44:04 <warlord> Are you using the Transfer Dialog, General Ledger, or an Account Register?
16:44:40 <moon> Account register, I think....sorry still very new to this.
16:50:28 <warlord> Okay, and what's the currency of the account whose register you have opened?
16:50:39 <moon> CAD
16:51:00 <warlord> Okay, and what's the currency(ies) of the transaction you're trying to enter?
16:51:15 <moon> CAD asset transferring to USD asset
16:52:07 <warlord> And this is just a simple 1:1 transfer?
16:52:13 <warlord> (not a split transaction)
16:52:31 <moon> Not split
16:52:36 <moon> simple 1:1.
16:52:50 <moon> I originally used to feature transfer
16:53:39 <warlord> the transfer dialog should work for a simple 1:1
16:53:40 <moon> Did a couple of transfers that way, then opened balance sheet...not balanced...that's why was trying to find a way to make it balanced
16:54:06 <warlord> It's not balanced because you're not accounting for the capital gain/loss when you transfer from currency A to currency B and then back again.
16:54:38 <moon> Hmm...so, how to account the capital gain/loss?
16:54:39 <warlord> E.g., you do $100 -> €75 and then €40 -> $60
16:54:43 *** iamawake has joined #gnucash
16:54:48 <warlord> That will throw you off balance.
16:54:52 <warlord> You need to account for it.
16:55:02 <warlord> The same way you'd account for selling stock.
16:55:33 <moon> yeap...I'm just lost on what accounts to set up, and what the transaction will look like.
16:57:32 <warlord> Read the docs.
16:57:39 <warlord> It should look just like a stock transaction.
16:58:01 <moon> okay...I'll do that...thank you for pointing me to the right direction
16:58:33 <warlord> You're welcome.
16:59:51 <moon> have a good day...I'm off to work this out.
16:59:53 *** moon has left #gnucash
17:13:57 *** warlord is now known as warlord-afk
17:19:31 *** sjc has joined #gnucash
17:28:30 *** MechtiIde has quit IRC
17:41:31 <blahdeblah1> Trying my question from yesterday again: is there a way to set a default filter so that reconciled transactions are filtered out?
17:41:45 <blahdeblah1> I checked the FAQ and there was no mention of it.
17:52:26 *** puck has quit IRC
17:52:37 *** puck has joined #gnucash
17:55:38 *** whoever has joined #gnucash
17:56:47 <whoever> hi all, I have gnucash setup and my bank info but don't know hw to start setting up OFx, is anyone available
17:56:51 <whoever> ?
17:56:55 <whoever> *how not hw
17:58:59 <jsled> I don't hardly know OFX, but have you seen the stuff on the wiki?
17:59:54 *** blahdeblah1 has quit IRC
17:59:59 <whoever> jsled: did this http://svn.gnucash.org/wiki/index.php?title=OFX_Direct_Connect_Bank_Settings&printable=yes but no other instuctions for OFX
18:00:41 <jsled> what about http://wiki.gnucash.org/wiki/Setting_up_OFXDirectConnect_in_GnuCash_2 ?
18:00:49 *** blahdeblah has joined #gnucash
18:05:23 <whoever> jsled: that page says for AQBanking tools>HBC account, but when I go to tools I have nothing that says anythiny like *oxfconect
18:06:14 <jsled> do you mean "Tools>HBCI Setup... " ?
18:07:21 <whoever> jsled: under tools I don't have anything that even says HBCI *
18:07:37 <jsled> what distro/os are you using?
18:07:46 <whoever> arch 64
18:08:07 *** puck has quit IRC
18:08:27 <jsled> can you see if it is built/configured with HBCI/OFX support?
18:08:32 <jsled> I bet it is not.
18:08:36 <jsled> and thus you don't have the options.
18:09:09 *** puck has joined #gnucash
18:09:41 <whoever> jsled: I may have just found it, gnucash-hbci/support (it was in a seperate repository
18:09:49 <whoever> hidden away
18:11:23 <whoever> jsled: so now i'll try the wiki, hope I don't get lost this time
18:20:14 *** puck has quit IRC
18:33:47 *** Elvanor has quit IRC
18:42:00 *** blahdeblah has quit IRC
18:47:07 *** Tim_Abell has joined #gnucash
18:47:11 *** Tim_Abell has left #gnucash
18:58:49 *** iamawake has quit IRC
19:06:36 *** iamawake has joined #gnucash
19:07:49 *** blahdeblah has joined #gnucash
19:16:54 *** jorelio has joined #gnucash
19:21:54 *** localhost has quit IRC
19:22:45 *** blahdeblah has quit IRC
19:32:52 *** yuriyg has joined #gnucash
19:33:25 <yuriyg> hi, I have a question regarding offsetting transactions in gnucash.
19:33:55 <yuriyg> I imported a number of transactions for two accounts from my bank
19:34:28 <yuriyg> several transactions "match" - for example I transfered money from acct A to acct B
19:35:14 <yuriyg> When I try to categorize the imported transactions, gnucash creates an additional offsetting transacction in the other account
19:35:31 <yuriyg> is there a way to "link" two offsetting transactions in two accounts?
19:37:35 *** blahdeblah has joined #gnucash
19:38:47 <yuriyg> i guess no one's home...
19:40:12 *** iamawake has quit IRC
19:43:34 *** localhost has joined #gnucash
19:57:04 *** sjc has quit IRC
19:57:07 *** yuriyg has left #gnucash
19:58:46 *** puck has joined #gnucash
20:10:03 *** puck has quit IRC
20:12:33 *** puck has joined #gnucash
20:32:35 *** yuriyg has joined #gnucash
20:33:31 <yuriyg> is there a way to link to exciting offsetting transaction in different accounts?
20:33:42 *** puck has quit IRC
20:33:53 <yuriyg> existing
20:35:50 *** puck has joined #gnucash
20:36:19 *** jorelio has quit IRC
21:05:07 *** warlord-afk is now known as warlord
21:05:10 <warlord> blahdeblah: no
21:06:14 <warlord> yuriyg: you need to manually mark the second one as a duplicate of the first during the import process.
21:12:46 *** aindilis` has quit IRC
21:14:14 <yuriyg> how do I mark it as duplicate?
21:14:34 <warlord> In the import UI you tell it "yes, this is a dup"
21:14:45 <warlord> But you do that after you assign the correct accounts.
21:16:27 <yuriyg> is that when I import OFX or QIF?
21:16:42 <yuriyg> or does it work for both formats?
21:17:29 <blahdeblah> warlord: OK - thanks. Any way a non-C/Scheme programmer can help to make it possible?
21:18:24 <warlord> yuriyg: both
21:18:48 <warlord> blahdeblah: learn C
21:19:32 <yuriyg> i'm looking at the import window right now
21:19:44 * blahdeblah sighs - not really an option right now
21:19:48 <blahdeblah> Thanks anyway warlord
21:19:53 *** blahdeblah has left #gnucash
21:19:55 <yuriyg> what do I do to mark a transaction as a dup?
21:20:55 <warlord> which import? OFX or QIF?
21:20:58 <yuriyg> OFX
21:21:17 <yuriyg> I assigned account number to two accounts that i'm importing
21:21:34 <yuriyg> right now I'm looking at a list of xactions, which are all marked in yellow
21:21:49 <warlord> Are you importing both at the same time?!?
21:21:54 <yuriyg> and have the 'A' checkbox checked and 'R' non-checked
21:22:04 <yuriyg> yeah, that's the way i downloaded them from citibank
21:22:17 <yuriyg> not correct, i assume?
21:23:30 <warlord> Yeah, I think that if you download both at the same time the OFX importer might not notice the dups.
21:23:40 <warlord> If you download 1 account, then the other, THEN it should notice.
21:23:45 <yuriyg> hmm
21:23:57 <yuriyg> i have 2 separate QIF files
21:23:59 <yuriyg> let me try
21:25:36 <warlord> In QIF it might work better loading them simultaneously, if they have proper QIF account mappings internally.
21:27:07 <yuriyg> yeah, the QIF import looks "smarter"
21:27:17 <yuriyg> i need to play around with it a bit :)
21:27:25 <warlord> Well, it's smarter in some ways.
21:27:37 <warlord> dumber in others.
21:27:48 <warlord> the account matching isn't as good as OFX
21:28:21 <yuriyg> it might have something to do with the fact that my ofx file had information for two accounts, but it didn't recognize any of transactions
21:28:30 <yuriyg> the sing-account qif recognized most of them
21:28:47 <yuriyg> s/sing/single
21:29:18 <warlord> * nods *
21:29:20 <warlord> could be.
21:29:36 *** moon has joined #gnucash
21:29:36 <warlord> Like I said, I dont know if the OFX importer is smart enough to notice cross-account txns.
21:29:44 <yuriyg> are you a gnucash developer?
21:31:42 <yuriyg> i have to say I was a little frusturated, as I downloaded a year worth of transactions from CC, saving and checking, and thought I would need to sort every xaction by hand
21:33:41 <warlord> Yes, I'm a dev, but have nothing to do with the OFX importer.
21:37:13 <yuriyg> :)
21:37:31 <warlord> I did some work on the QIF importer a long time ago, but we have a newer maintainer of that now.
21:38:24 <yuriyg> no, i was curious about aqbanking. seems like gnucash has a strong dependency on it for online imports
21:39:42 <yuriyg> but it seems it has limitations - a user has to dig for every banks info on the internet, no investment support
21:40:05 <yuriyg> i was curious if there are any plans to move away from it
21:40:32 <warlord> To what? There is no alternative.
21:42:12 <yuriyg> something like gnucashimporter? :)
21:43:49 *** twunder has joined #gnucash
21:49:09 <warlord> URL?
21:51:45 <jsled> no, there's no plan to move away from many man-years worth of development to something that doesn't exist by a project that barely has enough dev-cycles for itself.
22:06:48 *** twunder has quit IRC
22:10:05 *** iamawake has joined #gnucash
22:11:26 <moon> hello I'm back with the currency exchange capital gain issue.
22:12:03 <warlord> uhuh..
22:13:20 <moon> Now I understand the concept, although a little lost and confused. But would like an example how to input the data.
22:14:46 <warlord> There's an example in the docs.
22:15:00 <warlord> it's an example for stocks, but the theory is the same.
22:23:03 <moon> I must be stupid. If I give you two transactions, could you show me how it's done?
22:24:04 <warlord> sure.
22:24:20 <moon> Transfer CAD 5800 to USD 4550, Transfer USD 2000 to CAD 2400
22:24:38 <moon> thank u
22:25:31 <warlord> So CAD is your main currency.
22:25:35 <moon> yes
22:27:16 <warlord> so you bought 4550 USD at 1.27472 and then sold 2000 at 1.2. Those 2000 gives you a capital loss of CAD149.44
22:27:45 <moon> yes
22:27:53 <warlord> so you need to record that.
22:28:14 <warlord> just like you'd record it if you sold shares of stock.. or a painting. See the docs for how to enter it.
22:28:57 <moon> okay.
22:31:02 <warlord> It'll be two additional splits. One split into Expenses:Capital Loss and another split into the USD account.
22:33:22 *** aindilis` has joined #gnucash
22:33:46 <moon> Let's say in between these two transactions, I have a few none exchange transactions into USD account. Will it still be the same?
22:34:18 <warlord> "none exchange transactions"?
22:35:07 <moon> yes. like USD deposits and payments or transfer from USD liability into USD asset
22:35:17 *** yuriyg has left #gnucash
22:35:24 <warlord> That shouldn't affect it.
22:36:20 <moon> and if there's a capital gain, then the split will be Income:Capital Gain and split into CAD acc?
22:37:32 <warlord> No, still into USD.
22:38:08 <warlord> Just the sign is backwards in the account (credit v debit into the USD account for a $0 USD / Cap Gain/Loss)
22:38:55 <moon> .you mean the usd account where the transactions are occurring?
22:39:09 <warlord> yep
22:39:22 <warlord> Have you LOOKED at the docs?
22:39:27 <moon> yes.
22:39:37 <warlord> Treat the USD account as if it were a stock.
22:39:58 <moon> okay.
22:40:07 <warlord> and do what the docs say.
22:40:12 <warlord> The docs are quite clear on this.
22:40:56 <moon> It would be the same thing if the transfers occurred between USD liability and CAD liability?
22:42:11 <warlord> yes.
22:42:22 <warlord> just need to make sure the signs are all correct.
22:42:31 <moon> alright then. I am going to go and try them out.. Thank you very much.
22:42:53 <warlord> youre welcome
22:47:12 *** moon has left #gnucash
22:59:29 *** Rolf1 has quit IRC
23:00:49 *** warlord is now known as warlord-afk
23:00:58 *** Rolf has joined #gnucash
23:08:19 *** whoever has quit IRC
23:45:56 *** iamawake has quit IRC