2009-05-05 GnuCash IRC logs
00:04:07 *** jsled has quit IRC
00:40:40 *** owen1 has joined #gnucash
00:42:01 <owen1> could someone please give me a brief explanation of what the A and R means in the import screen for .ofx files?
00:58:43 *** owen1 has left #gnucash
01:08:20 *** jsled has joined #gnucash
01:08:21 *** gncbot sets mode: +o jsled
01:50:04 *** dan has joined #gnucash
01:50:12 <dan> hey everyone
01:50:25 <dan> I'm having trouble getting the correct cost-basis for a mutual fund that was taken over by another.
01:50:41 <dan> To me, if I buy shares in Fund A for $1000 then at some point later it is taken over by Fund B my cost-basis for my postion in Fund B is still $1000. Am I thinking about it wrong? I can't make gnucash do that (so far).
01:53:52 <dan> I am entering the takeover as a split transaction with a negative number of shares for Fund A and a positive number for Fund B. I thought that entering these without a price or buy/sell value would cause gnucash to use the Fund A buy price for the cost-basis, but that just makes the cost-basis for Fund B come up as $0.
01:54:15 <dan> (In the Advanced Portfolio report, that is)
02:57:36 *** bentob0x has joined #gnucash
02:59:24 *** Rolf2 has joined #gnucash
03:27:20 *** MechtiIde has joined #gnucash
04:40:56 *** owen1 has joined #gnucash
04:44:17 *** Feisar has joined #gnucash
05:14:10 *** dan has quit IRC
05:14:14 *** Rolf3 has joined #gnucash
05:22:17 *** Rolf2 has quit IRC
05:55:39 *** owen1 has left #gnucash
06:04:34 *** dan has joined #gnucash
06:05:56 *** dan has quit IRC
06:06:52 *** dan has joined #gnucash
06:46:27 *** twunder has joined #gnucash
07:10:40 *** twunder has quit IRC
07:35:24 *** twunder has joined #gnucash
07:51:20 *** twunder has quit IRC
08:04:25 *** mib_ad32vm1m has joined #gnucash
08:05:05 <mib_ad32vm1m> hello?
08:07:37 *** mib_ad32vm1m has left #gnucash
08:08:43 *** mib_ad32vm1m has joined #gnucash
08:21:19 *** mib_ad32vm1m has quit IRC
08:36:46 *** ErKa has joined #gnucash
08:36:48 *** twunder has joined #gnucash
08:37:41 *** twunder has quit IRC
09:04:02 *** Jimraehl has left #gnucash
09:29:05 *** JimRaehl2 has joined #gnucash
09:55:31 *** twunder has joined #gnucash
10:07:58 *** KaiForce has joined #gnucash
10:22:13 *** donfede has quit IRC
11:06:07 *** JimRaehl2 has quit IRC
11:28:35 *** MechtiIde has quit IRC
12:32:24 <todd> q/win 35
12:49:54 *** hvx has joined #gnucash
13:01:00 *** bob has joined #gnucash
13:01:17 <bob> Hi there
13:01:49 <bob> I was wondering...are you guys working on a version 3 of Gnucash?
13:02:37 <jsled> there's recent progress towards a 2.4
13:03:16 <bob> that's cool, what's new in it?
13:04:51 <jsled> report improvements. sql backend. other bug fixes. http://wiki.gnucash.org/wiki/Release_Schedule#Release_Schedule_for_2.3.x
13:07:29 <bob> I must say that I really like Gnucash (my 1st accounting program), but that reports are a weakness. I saw the Quicken reports and I was tempted to migrate....
13:07:48 <bob> the quicken version I saw was from 2002
13:08:48 <bob> what will SQL provide the home user with?
13:10:00 <jsled> some performance gains, but the uncaring end-user won't (and shouldn't) see huge differences by the backend switching.
13:11:57 *** palatin has joined #gnucash
13:32:55 *** cortana has joined #gnucash
13:33:13 *** jcreigh has joined #gnucash
13:34:41 *** jcreigh has joined #gnucash
13:36:37 <dan> If there was an answer, I missed it, so I'll repeat my q:
13:39:52 <dan> I am having trouble getting the correct cost-basis in the Advanced Portfolio report when one mutual fund takes over another
13:40:27 <dan> For example, if I bought $1000 worth of Fund A in the past and it was taken over by Fund B
13:41:15 <dan> I'd think my cost-basis for B should be $1000 regardless of the funds' prices at the time of the takeover
13:41:52 <dan> I'm entering the takeover as a split transaction with a negative amount of shares for Fund A and positive for Fund B and no values for price or sell/buy.
13:42:28 <dan> I would have thought that would indicate to gnucash to treat it as a transfer of funds, but the cost-basis for B comes up as $0 when I do it this way.
13:42:36 <dan> Is there another way to do this?
13:43:48 *** twunder has quit IRC
13:53:54 *** jcreigh has quit IRC
13:54:00 *** dang has joined #gnucash
13:54:44 *** jcreigh has joined #gnucash
14:13:48 *** MechtiIde has joined #gnucash
14:16:18 *** HerrK has joined #gnucash
14:22:11 *** ErKa has quit IRC
14:26:56 <bob> thanks jsled
14:26:58 <bob> bye now
14:27:01 *** chris has quit IRC
14:27:10 *** bob has left #gnucash
14:30:00 *** chris has joined #gnucash
14:40:49 *** JimRaehl2 has joined #gnucash
15:01:01 *** dan has quit IRC
15:04:51 *** Jimraehl has joined #gnucash
15:05:58 *** Jimraehl has left #gnucash
15:07:24 *** JimRaehl2 has left #gnucash
15:07:52 *** JimRaehl2 has joined #gnucash
15:10:01 *** andyt has joined #gnucash
15:11:27 *** hvx has quit IRC
15:38:50 *** cortana has quit IRC
15:40:10 *** palatin has quit IRC
15:40:36 *** cortana has joined #gnucash
15:46:14 *** vitoc has joined #gnucash
15:54:57 *** twunder has joined #gnucash
15:55:58 *** HerrK has quit IRC
16:11:35 *** sjc has joined #gnucash
16:13:25 *** bentob0x has quit IRC
16:37:38 *** puck has quit IRC
16:40:53 *** puck has joined #gnucash
16:52:09 *** KaiForce has quit IRC
16:55:03 *** Zoolooc has joined #gnucash
16:59:43 *** twunder has quit IRC
17:18:23 *** iamawake1 has quit IRC
17:18:36 *** MechtiIde has quit IRC
17:33:41 *** iamawake has joined #gnucash
17:44:51 *** sfalanga has joined #gnucash
17:49:34 <sfalanga> I'm giving a demo of GnuCash at the public library in 2 days. I want to start fresh and demonstrate aqbanking setup. Where are the configurations for this held? I'd like to rename the file(s) so I don't lose my info.
17:49:58 <sfalanga> Giving potential users the "authentic" setup experience.
17:50:46 <sfalanga> When I create a new "file" I'd like it to forget stuff I did in the past.
17:51:20 <sfalanga> I've looked in .gnucash as well as in the files itself. Using Ubuntu 9.04
17:51:23 <jsled> sfalanga: the simplest way is to perhaps create a new/throwaway user account for that purpose.
17:51:35 <jsled> There's stuff in ~/.gnucash and stuff stored in gconf
17:51:55 <sfalanga> jsled: a new Linux user?
17:51:58 * jsled nds
17:52:02 * jsled nods, too.
17:52:54 <sfalanga> jsled: gee... the solution was right there in front of me the whole time.... <G> Thanks.
17:53:00 <jsled> heh.
17:53:07 <jsled> It's probably the cleanest/easiest way.
17:53:23 <sfalanga> For sure... thanks again. TTYL
18:00:23 *** sfalanga has quit IRC
18:04:19 *** cedayiv has joined #gnucash
18:05:21 <cedayiv> Any idea why 'make' is failing with *** No rule to make target `16x16/gnucash-icon.png', needed by `all-am'. Stop.
18:05:40 *** Zoolooc has quit IRC
18:05:42 <cedayiv> I've done make clean and make distclean. Didn't help.
18:11:07 *** XiXaQ has joined #gnucash
18:13:41 *** teya has quit IRC
18:27:18 *** tuxfusion has joined #gnucash
18:31:43 *** andyt has quit IRC
18:34:23 <tuxfusion> hello , i'm testing gnucash for private financial overview , i've set the starting values of my accounts , i'm using it in german and i'm not fully aware of all correct translations . i've also set all reacurent transactions Assets + Liabilities and their monthly date , what i was looking for was some kind of a "forecast" where am i at the end of the year ( bankrupt , super rich ? ). All the reports i tried only show my current state, because no booking happen
18:38:33 <jsled> there's no such report
18:38:36 *** vitoc has quit IRC
18:38:38 *** iamawake has quit IRC
18:40:13 <tuxfusion> a simple and devastating answer =)
18:40:32 <todd> tuxfusion: you'd have to set the date for them to be entered a year in advance or so, then remove things if you need to change things
18:48:06 <tuxfusion> todd, yes i found a setting in the "reacurrent bookings" to book ahead or something ,it somehow shows a warning , ignoring it i still see nothing in a journal or elsewhere , gnarf , now it crashed at one report , but still thx guys
18:49:00 <todd> I know there is a setting to auto-create recurring transactions on startup, can't recall if there's a knob to create them on demand
18:49:10 <jsled> there is not
18:53:01 <tuxfusion> funny after starting again after the crash
18:53:18 <tuxfusion> all the "future bookings" i set where magicly there ..
18:53:44 <jsled> Oh, now you're screwed, cause you can't easily delete them. :(
18:53:52 <jsled> Maybe you have a timestampped auto-backup file.
18:54:44 <tuxfusion> i'm just testing around its okay i just want to see where this could help me
18:57:55 <cedayiv> I'm trying to make the latest trunk by the way, r18066. This stupid image file is hosing me.
19:03:33 *** iamawake has joined #gnucash
19:14:21 *** jcreigh has quit IRC
19:18:09 *** Feisar has quit IRC
19:42:19 *** XiXaQ has quit IRC
19:46:19 *** sjc has quit IRC
20:00:57 *** owen1 has joined #gnucash
20:02:52 <owen1> hello. I need help with figuring out how my books should be organized. Specifically I have internal expense accounts that the owner's of the company can draw upon for expenses. These expense accounts get funded as a % of the income based on how much work they did etc.
20:02:53 *** cortana has quit IRC
20:03:15 <owen1> i currently have the books balanced
20:03:32 <owen1> except I need to fit in these expense accounts somewhere in between and I'm having trouble figuring out how they would link up
20:05:13 <todd> one thing you could do would be to have $checking -> $holding_account transaction in the future for the amount reserved for them
20:05:32 <todd> as they draw from it, reduce the $checking -> $holding_account transaction accordingly
20:07:43 <todd> we have a budget higharchy that is more complicated, we `deposit' money into the budget:travel:flights and say it was expensed to expense:travel:flight, then a transaction from checking to budget:travel:flights is kept such that budget:travel:flights is always zero; when actually spending money the money comes from the budget:travel:flight and thus the account list wherever a budget item is not zero there is an adjustment to be made..
20:08:48 <todd> I've had accountants wring their hands at this system but there's not a lot else to do when one wishes to a) keep track of when money was added and removed to the budget, and b) have some semblance of indication things are right or wrong (the zero balance of the budget accounts is this indication for us)
20:08:55 <owen1> yes this is something along the lines of what i'm imagining
20:09:16 <todd> the drawbacks of the system I described (the 2nd one) is that reports require careful tweaking
20:09:28 <owen1> but i'm doing it fairly simple because i'm a simple person and not an accontant hehe
20:09:38 <todd> and if you ever get into a low water mark of money, its common to `give' money from one budget category to another
20:09:51 <todd> which then does not clearly show in the expense categories how that money was spent
20:10:40 <owen1> hmm i don't think i want to transfer money per se
20:10:41 <todd> I'm thinking we should go to the 1st system I mentioned .. but then there is no way to track what transaction effected your $holding_account by how much
20:10:49 <owen1> basically these expense accounts are in lieu of wages
20:11:13 <owen1> so whatever is in an account would stay there and later on get assigned to subaccounts under each person's expsense
20:11:44 <todd> sounds like you'd prefer the 1st item anyway
20:12:02 <owen1> yes your first method is close, but i'm still not grasping fully how it would all balance
20:12:38 <owen1> i thought of a messy way to get it done last night before i fell asleep
20:12:48 <todd> I suppose if you had $checking -> expenses:wages:betty transaction totaling the amount available, then $checking -> expenses:wages:betty:subaccount1 could be entered and at the same time you'd have to reduce the $checking -> expenses:wages:betty
20:13:28 <owen1> when you use the -> you are indicating a transaction from checking to expenses right?
20:13:39 <todd> as long as the total amount for a given month remained constant for all expenses:wages:betty.. and subaccounts .. then it ``balances''
20:13:43 <todd> right
20:13:51 <todd> one entry in two accounts, double entry accounting
20:14:28 <owen1> okay, I think I have what you are detailing mostly implemented
20:14:50 <owen1> i review all transaction in my checking and credit card, and assign to expenses:betty or expenses:john on a case by case basis
20:14:57 <todd> gnucash does have a budget function
20:15:01 <owen1> oh?
20:15:04 <todd> feel free to see if that helps
20:15:10 <todd> file->new->budget
20:15:10 <owen1> i'm using the win32 version lemme look
20:15:31 <todd> then you can generate a report to confirm things are ok or not with the budget
20:15:35 <owen1> yes this might help i'm going to read the docs
20:16:15 <owen1> i just have to figure out how to populate portions of the income into various books i guess
20:16:56 <owen1> thanks for your explanation it helps.. i'm a little slow wth accounting but thank you
20:17:09 <todd> one thing I've not done yet but seems like its going to be needed soon...
20:17:25 <todd> the more data in gnucash .. the slower it runs
20:17:47 <todd> I have 6+years of business accounting and 4+ years of personal accounting in separate sets of books.
20:18:10 <todd> I'm wondering more and more if I don't need to `close' things out and start from starting balances each January 1st so things do not continue to degrade in performance.
20:18:38 <owen1> yes because it's storing everythign in a flat file
20:18:39 <todd> if the db backend(s) were making progress, eventually this might not be an issue. but as it is, it is..
20:19:01 <todd> not only that it is storing everything in a flat file, but because everytime you generate a report its parsing things in memory (and somehow it is inefficent at that)
20:19:13 <owen1> how long before you started noticing performance issues?
20:19:23 <todd> couple years I guess
20:19:28 <owen1> i'm probably going to be keeping track of less than $50k in sales this year
20:19:30 <todd> I think it depends on the volume of transactions
20:19:36 <todd> my brother has been using gnucash for 10+ years I think
20:19:43 <owen1> hehe hopefully i'm good for a bit
20:19:44 <todd> but he does 5-10 transactions a month
20:19:51 <todd> we have some days with that many transactions
20:20:07 <owen1> yes for us we do a few large transactions a month
20:20:21 <owen1> most transactions are actually our expenses etc, which i was using excel to track
20:20:39 <owen1> and the spreadsheet was getting too overwhelming
20:21:11 <todd> we still use a spreadsheet for our official budget
20:21:42 <todd> someyear I'll either spend time myself or hire someone specifically to enhance gnucash or create something else that does all the things I've not yet found in free accounting software.
20:23:00 <owen1> i briefly considering writing a simple accounting package, but realize one year of accounting might not qualify me to write such a package
20:23:49 <owen1> i think a desktop app is more appropriate for accounting vs a web app anyway
20:27:19 <jsled> you seen webapps these days?
20:27:40 <owen1> i did try a few before deciding on gnucash
20:28:18 <owen1> of course i did limit my search to open source
20:28:34 *** cedayiv has quit IRC
20:29:46 <owen1> most of them were overkill for me
20:32:07 <owen1> the main thing that drew me to gnucash is how the books are in a tree heirarchy..
20:47:53 *** JimRaehl2 has left #gnucash
20:48:11 *** Jimraehl has joined #gnucash
21:04:48 *** sfalanga has joined #gnucash
22:34:38 *** cedayiv has joined #gnucash
22:55:47 *** sfalanga has quit IRC
23:36:08 *** twunder has joined #gnucash
23:44:17 *** twunder has quit IRC