2009-03-16 GnuCash IRC logs

00:03:23 *** pcroque has quit IRC
00:24:26 *** u2nmy50u1 has joined #gnucash
00:24:43 <u2nmy50u1> greetings all
00:26:37 *** u2nmy50u1 has quit IRC
00:27:11 *** u2nmy50u1 has joined #gnucash
00:28:19 <u2nmy50u1> can gnucash be used like quickbooks with their POS software?
00:29:06 *** warlord-afk is now known as warlord
00:29:24 <warlord> u2nmy50u1: I know of no POS software that integrates directly into GnuCash.
00:29:38 <warlord> However if you have POS s/w that outputs QIF then GnuCash can import it.
00:31:03 <u2nmy50u1> I've heard that gnucash can be setup to use credit card swipes and thermal printers, is that correct
00:31:28 <warlord> GnuCash isn't a POS system
00:31:41 <warlord> If someone set it up that way.. I've not heard of it.
00:31:58 <u2nmy50u1> under the business tab it allows you to create invoices, customers, etc
00:33:09 <warlord> Yes
00:33:22 <warlord> But that's not a POS system.
00:35:36 <u2nmy50u1> hmm, it also allows you to take money doesn't it
00:38:47 <warlord> define "take money"
00:43:20 <u2nmy50u1> i'm not on my workstation, but doesn't it have a selection for receive payment somewhere under the business tab
00:45:49 <u2nmy50u1> I don't want to come across as argumentative, I just thought that there was a sourceforge project for POS that was backed by gnucash
00:46:10 <u2nmy50u1> I'm probably very wrong
00:46:28 <warlord> GnUCash has no POS code.
00:46:40 <warlord> As I said, if there is a POS that ties into GnuCash I have no knowledge of it.
00:46:55 <u2nmy50u1> okay, thank you much
00:47:00 <warlord> GnuCash DOES have business feautures for inputting and processing invoices and payments.
00:47:04 <warlord> But that's NOT a POS
00:47:36 <u2nmy50u1> do you know of any businesses using an open source POS and integrating it with gnucash
00:47:47 <warlord> Nope
00:48:00 <u2nmy50u1> okay, I have to find some other solution
00:48:04 <u2nmy50u1> thanks again
00:48:22 *** u2nmy50u1 has left #gnucash
01:34:15 *** warlord is now known as warlord-afk
01:53:39 *** ErKa has joined #gnucash
02:19:11 *** darco has left #gnucash
02:26:31 *** hvx has joined #gnucash
02:27:30 *** hvx has quit IRC
02:35:49 *** Jimraehl has left #gnucash
02:36:25 *** Jimraehl has joined #gnucash
03:18:53 *** MechtiIde has quit IRC
03:55:10 *** ErKa has quit IRC
04:14:48 *** darco2 has quit IRC
04:19:13 *** ErKa has joined #gnucash
05:15:47 *** MechtiIde has joined #gnucash
05:24:52 *** MechtiIde has quit IRC
05:25:25 *** MechtiIde has joined #gnucash
07:46:19 *** paulproteus_____ has quit IRC
07:49:53 *** vasanthv16 has joined #gnucash
07:51:04 *** paulproteus_____ has joined #gnucash
07:55:23 *** paulproteus_____ has quit IRC
07:56:26 *** paulproteus_____ has joined #gnucash
07:57:45 *** Jimraehl has left #gnucash
07:59:21 *** vasanthv161 has joined #gnucash
07:59:55 *** vasanthv16 has quit IRC
08:16:06 *** bacule has joined #gnucash
08:16:35 *** JimRaehl2 has joined #gnucash
08:18:25 *** vasanthv16 has joined #gnucash
08:20:27 *** JimRaehl2 has left #gnucash
08:21:41 *** JimRaehl2 has joined #gnucash
08:24:52 *** vasanthv161 has quit IRC
08:27:02 *** JimRaehl2 has quit IRC
08:28:13 *** vasanthv16 has quit IRC
08:29:08 *** JimRaehl2 has joined #gnucash
08:29:51 *** JimRaehl2 has joined #gnucash
08:42:56 *** eukreign has quit IRC
09:20:50 *** eukreign has joined #gnucash
09:43:47 *** SebastianHeld has joined #gnucash
10:09:19 *** warlord-afk is now known as warlord
11:39:49 *** warlord has quit IRC
12:07:30 *** warlord has joined #gnucash
12:07:30 *** gncbot sets mode: +o warlord
12:08:13 *** Rolf has quit IRC
12:08:41 *** mib_sgodse has joined #gnucash
12:08:49 <mib_sgodse> hi there
12:09:14 <mib_sgodse> what database gnucash use ?
12:12:08 <warlord> It doesn't.
12:12:17 <warlord> All released versions of GnuCash use a flat file.
12:12:52 <mib_sgodse> it has a very very nice UI
12:13:04 <warlord> thanks
12:13:07 <mib_sgodse> and i thought developing a small ERP on top of it...
12:13:19 <mib_sgodse> is that too unrealistic ideea ?
12:14:16 <warlord> Well, it depends on what kind of ERP you want to develop, and what you mean by "on top of it"
12:14:59 <mib_sgodse> well to be honesct i do not know what is inside...
12:15:10 <mib_sgodse> but i assume it has some controls cusom made..
12:15:37 <mib_sgodse> but i assumed it has like a db behind.
12:16:34 <warlord> Nope, no DB. Well, not in the sense of MySQL or Postgres.
12:16:45 <warlord> What exactly are you trying to do?
12:17:30 <mib_sgodse> i am prospecting now what choices do i have to make a small accountig program + some other things
12:17:40 <mib_sgodse> call it small ERP
12:17:52 <mib_sgodse> to do invoices ,printing etc.
12:17:58 <warlord> Which means what? What exactly are you trying to do?
12:17:58 <mib_sgodse> reports
12:18:30 <mib_sgodse> similar with what you do but for small firms not personal finance
12:19:07 <mib_sgodse> there is a different logic in a firms accounting system...there is chart of accounts ...
12:19:27 <mib_sgodse> stocks as well
12:20:04 <warlord> GnuCash has some quickbooks-like business features..
12:20:09 <warlord> Invoicing, Reports, ...
12:20:15 <mib_sgodse> really ?
12:20:22 <warlord> Have you installed the application and looked at it?
12:20:26 <warlord> No, i'm lying.
12:20:26 <mib_sgodse> then i have to read the tutorial first :)
12:20:39 <mib_sgodse> so ?
12:20:52 <mib_sgodse> you are jokeing ?
12:21:28 <warlord> Yes, really! Yes, GnuCash has business features. It has since 1.8 in 2001
12:22:21 <mib_sgodse> cool !
12:22:28 <warlord> (well, maybe 2002 -- I dont recall offhand)
12:22:35 <mib_sgodse> there are stocks as well ?
12:22:54 <mib_sgodse> FIFO ,LIFO average price alll this stuff ?
12:23:40 <warlord> Of course there are stocks.
12:23:51 <warlord> HOWEVER it doesn't calculate cap gains automatically.
12:25:22 *** darco2 has joined #gnucash
12:25:45 <mib_sgodse> this is gr8
12:25:59 <warlord> Have you even looked at www.gnucash.org? Or the wiki?
12:26:17 <mib_sgodse> just i am palying with program now
12:26:24 <mib_sgodse> but i do that soon
12:27:50 <mib_sgodse> one thing...is this possbile to use it in a lan ?
12:27:50 <mib_sgodse> and how much data can handle ?
12:27:50 <mib_sgodse> is possible to make like 10000 invoices / months with more then 1 mil invoice lines / total
12:27:50 <mib_sgodse> ?
12:30:13 <warlord> Um, 10000 invoices a month? Umm.. The UI would be a little prohibitive on doing that. It's really meant for a small company. 10k invoices/mo is not a small company.
12:31:08 <mib_sgodse> it is ...since it has like 3 people
12:31:22 <mib_sgodse> and they receive the invoces in a text format
12:31:31 <mib_sgodse> and those are converted automatically in the system
12:31:38 <mib_sgodse> they only print reports..:)
12:31:43 <mib_sgodse> and invoices..
12:31:52 <mib_sgodse> however...i read the manual now..
12:32:25 <mib_sgodse> you did not think to make this application db agnostic (or backend agnostic)
12:32:45 <mib_sgodse> so it does not matter what persitance looks like
12:34:16 <mib_sgodse> ?
12:35:28 *** ErKa has quit IRC
12:54:34 *** darco2 has quit IRC
12:55:05 <mib_sgodse> so warlord ?
12:55:51 *** darco2 has joined #gnucash
12:55:55 <warlord> I didn't write it from scratch.. The program already existed when I started working on it.
12:56:10 <warlord> There is a DBI project now which should give SQLIte/MySQL/PG support for 2.4
12:56:29 <warlord> But it's still single-user.
12:57:11 <mib_sgodse> i see thx for your help.
12:57:22 <mib_sgodse> anyway it became my personal fin program today :)
12:57:49 <warlord> Cool.
13:00:32 <warlord> mib_sgodse: Gnucash is a volunteer effort. Nobody is paid to work on it.
13:01:10 <mib_sgodse> i know...is open source...but it is huge
13:01:19 <mib_sgodse> it take time to maintain this project to add features
13:01:35 <mib_sgodse> ar least you sell your services ...or ...something
13:01:50 <mib_sgodse> you have to earn money in a way or another
13:02:50 <warlord> Everyone who works on GnuCash does it on their own time.
13:02:57 <warlord> Nobody has a job to work on GNC.
13:03:24 <mib_sgodse> nice effort then !
13:04:09 <mib_sgodse> i did the same for a couple of open sourcer java projects...
13:04:32 <mib_sgodse> cu ...and thx again for your time
13:10:40 *** darco2 has quit IRC
13:21:30 <warlord> You;'re welcoe.
13:21:34 <warlord> welcome
14:09:38 *** ErKa has joined #gnucash
14:27:38 *** jwshen has joined #gnucash
14:41:13 *** mib_sgodse has left #gnucash
14:46:10 *** andyt has joined #gnucash
15:01:51 *** MechtiIde has quit IRC
15:19:21 *** sjc has joined #gnucash
15:40:15 *** zathras_laptop has joined #gnucash
16:01:02 *** MechtiIde has joined #gnucash
16:07:33 *** hvx has joined #gnucash
16:12:52 *** twunder has joined #gnucash
16:21:30 *** grayness has joined #gnucash
16:22:58 *** grayness has quit IRC
17:08:05 *** jwshen has quit IRC
17:23:39 *** hvx has quit IRC
17:24:06 *** MechtiIde has quit IRC
17:28:15 *** charly has joined #gnucash
17:35:59 *** tbnorth has joined #gnucash
17:36:44 <tbnorth> hi all - is there a way to assign transactions with a given description to a particular accound after the .QXF import stage?
17:37:23 <warlord> Sure, you could manually change the transaction.
17:37:33 <tbnorth> but to do many at once?
17:38:15 <warlord> Nope. Only 1 at a time.
17:38:36 <tbnorth> so it would be quicker to start again and set them properly at the import stage, then?
17:40:09 *** twunder has quit IRC
17:41:38 *** ErKa has quit IRC
17:45:27 *** Zoolooc_ has joined #gnucash
17:47:26 <tbnorth> so what am I supposed to do with the "Generic import transaction matcher"? There are two many to do each manually.
17:48:02 <warlord> What I would recommend is that you turn on Bayesian Matching.
17:48:13 <warlord> Then download only a subset of your transactions.
17:48:18 <warlord> Go through them all.
17:48:30 <tbnorth> ok, no doubt I need to start again for that... but I'll try it
17:48:32 <warlord> THEN download the full set, and it should be able to better match them going forward.
17:59:12 *** Zoolooc_ has quit IRC
18:12:05 <tbnorth> thx for the pointers, warlord
18:12:36 <tbnorth> looks like qxf import is too painful, qif import looks like it would be ok, but my bank doesn't offer that
18:12:57 <tbnorth> it does offer iif, but I guess GnuCash doesn't speak iif.
18:13:05 <warlord> Nope, no IIF.
18:13:17 <warlord> QFX is fine, but you just shouldn't download years and years all at once.
18:13:36 <warlord> Download, say, 1 month.. Then the OFX importer will learn from that and apply it to future imports.
18:14:22 <tbnorth> even one month is excruciating, there's about 15 Overdraft Protection entries in it, and they all come from the same account, of course.
18:15:21 <warlord> Pick another month?
18:15:26 <warlord> Pick 1 week?
18:15:28 <warlord> 1 day?
18:15:33 <warlord> Seriously, just seed the info.
18:16:07 <tbnorth> I doubt less than 2 months will cover a decent percentage of cases, that's a lot of clicky clicky
18:17:12 <tbnorth> hmm, bank supports csv, I wonder if I can make QIF out of that...
18:17:13 <warlord> But it's a lot of clicky-clicky you only need to do once.
18:17:54 <tbnorth> true, I just have a low clicky-clicky tolerance, I like it when computers do the work.
18:19:18 <warlord> It will do the work -- you just have to train it.
18:19:27 <warlord> Dont let the computer be smarter than you.
18:20:53 <tbnorth> I know, I'm whining, I just associate repetition with M$ products, don't expect it on this side of the line. I bet the QXF importer will be as nice as the QIF importer sometime.
18:20:57 *** rgsteele||work has joined #gnucash
18:21:28 <rgsteele||work> Hey folks. How do you go about accounting for cash gifts? For example, a birthday check?
18:21:46 <rgsteele||work> There's really nowhere to take it 'from', and it seems silly to create an asset for one-off's like that.
18:22:28 <warlord> Huh? It would come out of Assets:Cash-in-Wallet or Assets:Checking, depending on how you gave them the cash.
18:22:38 <warlord> ... and go into Expenses:Gifts
18:22:50 <rgsteele||work> No, I meant cash gifts received.
18:22:53 <rgsteele||work> Not given.
18:23:46 <warlord> Then reverse it.. Income:Gifts -> ...
18:24:34 <jsled> Or just {Income} if you don't want to create a sub-account, but there's little reason not to.
18:24:59 <rgsteele||work> Well, it seems kinda silly to create an asset account for one-off events like cash received in a birthday card.
18:25:27 <jsled> No asset account created. Income:Gifts -> Assets:Checking
18:25:31 <warlord> rgsteele||work: you're NOT creating an asset account.
18:26:16 <rgsteele||work> Ok, what if I just found $10 on the ground? I guess that could be interpreted as a gift :)
18:26:35 <warlord> Income:Misc?
18:26:38 <warlord> Income:Found?
18:26:40 <warlord> Income:Other?
18:26:51 <warlord> Up to you on whether you want to consider it a gift..
18:26:59 <warlord> .. or if you want to differentiate that.
18:27:14 *** cortana has joined #gnucash
18:27:51 <rgsteele||work> Mkay, sounds good. Sorry if the question sounds a bit odd - I'm coming from a non-double-entry style budget, and still getting used to it.
18:28:59 *** SebastianHeld has left #gnucash
18:29:31 <rgsteele||work> But I definitely enjoy the robustness of gnucash. Head and shoulders above the rudimentary app I'd written years ago to handle my basic budget. Guess everyone's gotta grow up sometime :)
18:35:56 <tbnorth> woohoo - http://jelmer.vernstok.nl/blog/archives/188-Converting-CSV-files-to-QIF.html
18:46:11 <rgsteele||work> Jelmer is a smart cookie. He's done a lot of great work for Samba.
18:46:32 <tbnorth> for the log, http://allmybrain.com/2009/02/04/converting-financial-csv-data-to-ofx-or-qif-import-files/ looks better than the other url
18:47:08 *** andyt has quit IRC
18:57:02 *** tbnorth has quit IRC
19:12:05 *** zathras_laptop has quit IRC
19:39:37 <rgsteele||work> Hm, does gnucash have a 'task list', 'todo list', or something similar?
19:40:04 <jsled> closest thing is the RFEs in bugzilla.
19:40:11 <jsled> Or, do you mean, in the app?
19:40:33 <rgsteele||work> In the app. I want to put a note in there to indicate that there are certain pending transactions in my bank account that haven't been pulled down yet in the sync.
19:41:20 <jsled> oh. no.
19:41:26 <rgsteele||work> Mkay.
19:42:22 *** charly has left #gnucash
19:59:09 *** cortana has quit IRC
20:00:29 *** cortana has joined #gnucash
20:00:43 *** cortana has joined #gnucash
20:21:09 *** twunder has joined #gnucash
20:27:48 *** cortana has quit IRC
20:35:39 *** sjc has quit IRC
20:36:29 *** cortana has joined #gnucash
21:21:23 *** warlord has quit IRC
21:21:30 *** cortana has quit IRC
21:44:07 *** rgsteele||work has quit IRC
21:46:38 *** twunder has quit IRC
21:46:48 *** warlord has joined #gnucash
21:46:49 *** gncbot sets mode: +o warlord
21:50:29 *** warlord is now known as warlord-afk
22:29:33 *** JimRaehl2 has left #gnucash
22:30:43 *** Jimraehl has joined #gnucash
23:34:39 *** smacnay has quit IRC