2015-02-05 GnuCash IRC logs
00:07:15 *** cartsoftware has joined #gnucash
00:21:22 *** mlncn has quit IRC
00:41:45 *** keret has quit IRC
00:51:49 *** kode has joined #gnucash
01:09:18 *** rubdos has joined #gnucash
01:36:39 *** gjanssens has quit IRC
01:39:32 *** gjanssens has joined #gnucash
01:39:32 *** gncbot sets mode: +o gjanssens
01:58:20 *** fabior has joined #gnucash
02:20:32 *** fabior has quit IRC
02:39:02 *** GabrieleV_ has joined #gnucash
02:39:33 *** GabrieleV has quit IRC
02:39:34 *** GabrieleV_ is now known as GabrieleV
02:43:50 *** aqua___ has joined #gnucash
02:44:56 *** MechtiIde has joined #gnucash
03:14:31 *** GabrieleV_ has joined #gnucash
03:14:32 *** GabrieleV has quit IRC
03:14:32 *** GabrieleV_ is now known as GabrieleV
03:25:07 *** keret has joined #gnucash
03:30:23 *** MechtiIde has quit IRC
03:57:36 *** kode has quit IRC
04:36:33 *** GabrieleV_ has joined #gnucash
04:36:33 *** GabrieleV has quit IRC
04:36:34 *** GabrieleV_ is now known as GabrieleV
04:41:24 *** fell has joined #gnucash
04:44:33 *** kode has joined #gnucash
04:48:01 *** Jimraehl1 has left #gnucash
04:52:40 *** Jimraehl1 has joined #gnucash
05:18:09 *** keret has quit IRC
05:19:31 *** keret1 has joined #gnucash
05:41:30 *** rickoehn has joined #gnucash
05:57:34 *** cartsoftware has quit IRC
06:01:58 *** cartsoftware has joined #gnucash
06:05:45 *** fell has quit IRC
06:20:53 *** andy_ has quit IRC
06:23:01 *** StuM has joined #gnucash
06:31:18 *** andy has joined #gnucash
06:44:08 *** wol has joined #gnucash
06:56:34 *** GabrieleV has quit IRC
06:59:58 *** GabrieleV has joined #gnucash
07:18:18 *** mlncn has joined #gnucash
07:24:45 *** ErKa has joined #gnucash
07:44:48 *** ErKa has quit IRC
07:49:59 *** wol has quit IRC
08:09:58 *** GabrieleV_ has joined #gnucash
08:10:04 *** GabrieleV has quit IRC
08:10:04 *** GabrieleV_ is now known as GabrieleV
08:17:07 *** lmat has joined #gnucash
08:22:00 *** mlncn has quit IRC
08:22:58 *** kode has quit IRC
08:24:25 *** ErKa has joined #gnucash
08:36:07 *** mlncn has joined #gnucash
08:46:19 *** AlonzoTG has quit IRC
08:51:04 *** fabior has joined #gnucash
08:54:35 *** kode has joined #gnucash
09:03:19 *** wol has joined #gnucash
09:03:24 *** mlncn has quit IRC
09:14:39 *** O01eg has joined #gnucash
09:33:07 *** KaiForce has joined #gnucash
09:37:04 *** mlncn has joined #gnucash
09:48:43 *** fabior has quit IRC
10:01:39 *** kode has quit IRC
10:05:17 *** kode has joined #gnucash
10:11:11 *** mlncn has quit IRC
10:11:23 *** fell has joined #gnucash
10:16:17 *** StuM has quit IRC
10:17:57 *** mlncn has joined #gnucash
10:19:30 *** alexjj has left #gnucash
10:23:03 *** kode has quit IRC
10:24:18 *** wol has quit IRC
10:24:41 *** wol has joined #gnucash
10:30:01 *** kode_ has joined #gnucash
10:34:58 *** AlonzoTG has joined #gnucash
10:40:23 *** kode_ has quit IRC
10:41:31 *** kode has joined #gnucash
10:41:44 *** Krzysiek_K has joined #gnucash
10:55:01 *** himaxx has joined #gnucash
11:00:11 *** aqua___ has quit IRC
11:02:31 *** kode has quit IRC
11:07:08 *** himaxx has quit IRC
11:07:55 *** fabior has joined #gnucash
11:09:11 *** O02eg has joined #gnucash
11:13:15 *** rubdos has quit IRC
11:14:27 *** mlncn-agaric has joined #gnucash
11:14:58 *** kode has joined #gnucash
11:15:59 *** mlncn has quit IRC
11:17:25 *** O01eg has quit IRC
11:19:25 *** mart_k has joined #gnucash
11:31:28 *** kode has quit IRC
11:31:45 *** fabior has quit IRC
11:32:56 *** kode has joined #gnucash
11:45:00 *** cartsoftware has quit IRC
12:08:12 *** kode has quit IRC
12:14:14 *** benjamin-agaric has joined #gnucash
12:20:39 *** mlncn-agaric has quit IRC
12:35:28 *** benjamin-agaric has quit IRC
12:53:40 *** benjamin-agaric has joined #gnucash
13:08:50 *** kode has joined #gnucash
13:18:57 *** kode has quit IRC
13:26:51 *** mart_k has quit IRC
13:43:48 *** guest1 has joined #gnucash
13:45:31 <guest1> How do I specify which Asset Account to import transactions into from a QIF or OFX file?
13:55:59 *** aqua___ has joined #gnucash
13:56:10 <jralls> guest1: When you run the import it will ask you to associate the account id in the import file with an account in your CoA. That association will be saved so it will ask only once.
14:06:39 *** aqua_ has joined #gnucash
14:13:03 *** aqua___ has quit IRC
14:13:19 *** KaiForce has quit IRC
14:18:50 *** wol has joined #gnucash
14:19:20 <warlord> guest1: where that association gets made is different based on whether you are using QIF or OFX. For QIF the filename gets mapped to a QIF Account, and later in the assistant it asks you to map QIF Accounts to GnuCash Accounts. That's where the binding happens.
14:19:50 <warlord> (Assuming a single-account QIF file. If you have a multi-account file then the account names are encoded in the file itself so the filename has no meaning)
14:21:26 <guest1> How do I change which account the import is mapped too?
14:27:12 <warlord> guest1: OFX or QIF?
14:28:18 <guest1> I don't know yet. I was experimenting with them and it seems like QIF works better???? My bank offers both.
14:29:00 <warlord> With QIF you just re-assign it during the "Map QIF Accounts" page in the assistant.
14:29:31 <warlord> With OFX.... It's more complicated. GnuCash stores the mapping internally; there's no way to remove that. All you can do is overwrite it.
14:30:26 <warlord> GnuCash stores the mapping in the account object. To overwrite it you need to import another OFX file and map it to the account you want to remap. Then when you import the original OFX again the mapping will be gone and you will be free to choose an account.
14:32:05 <guest1> Do you have an opinion as to which format is better for use with gnucash?
14:32:09 *** aqua_ has quit IRC
14:35:18 <warlord> depends what you are trying to achive.
14:35:23 <warlord> achieve, even
14:37:39 <warlord> If you're downloading from a bank, OFX is probably better because it does better duplicate detection.
14:37:58 <warlord> If you're trying to import more complicated data, or split transactions, then qif is probably better.
14:41:14 <guest1> Meaning I already entered a transaction in gnucash that had 2 or more expense lines? Or the info from the bank has split info?
14:46:11 <warlord> more the latter than the former. (although I know of no banks that do that)
14:47:44 *** lmat has quit IRC
14:49:20 <guest1> Oops, I just downloaded from the bank again. They offer QFX not QIF. QFX is basically the same or very similar to OFX, correct?
14:51:52 <warlord> Yes, QFX and OFX are apparently similar.
14:58:05 *** kode has joined #gnucash
15:06:20 <guest1> Thank you for your help. I followed your instructions for the OFX file and it worked perfectly. Now I'm going to review the matching/etc screen and see how confused I can get. May be back with a new question in a few.:)
15:07:48 <warlord> Good luck.
15:08:16 *** kode has quit IRC
15:12:35 *** gjanssens has quit IRC
15:14:22 *** wol has quit IRC
15:28:55 *** Krzysiek_K has quit IRC
15:42:56 <guest1> When I enter a transaction I put the store name on the main transaction line. When I imported the file from the bank it imported the store name on the line item line. Is there a setting/change/work around so it imports the way I am using it?
15:44:29 <guest1> This is for transactions that are being added through the import.
15:46:21 <keret1> Is it possible to import stock transactions in csv format? What I have tried so far suggests not, but thought I would ask for confirmation.
15:47:45 <keret1> More generally, is it possible to import stock transactions in any format?
16:01:20 *** lmat has joined #gnucash
16:17:32 <warlord> guest1: I dont recall how the ofx importer decides where to put the fields.
16:17:40 <warlord> keret1: I dont think so.
16:17:47 <warlord> Yes, you can import them in QIF
16:18:02 <warlord> keret1: (the I dont think so was answering your first question about CSV)
16:19:15 *** rickoehn has quit IRC
16:26:40 <keret1> any format? in the event I can convert csv data to another format. or is there no importer that enables gnc to manage the lots required for stock accounts?
16:46:50 *** kode has joined #gnucash
16:53:19 *** benjamin-agaric has quit IRC
16:56:54 *** kode has quit IRC
17:07:13 *** AlonzoTG has quit IRC
17:08:18 *** AlonzoTG has joined #gnucash
17:46:53 *** ErKa has quit IRC
17:58:14 <warlord> keret1: like I said at 18:18, QIF can import stocks/mutual funds..
17:58:29 <warlord> No importer, however, handles lots. You would need to do the lot management manually.
18:22:17 *** kim27` has joined #gnucash
18:22:22 *** kim27 has quit IRC
18:30:02 <keret1> warlord: thanks. missed the comment at 18:18. Thought that was aimed at guest1.
18:35:35 *** kode has joined #gnucash
18:44:04 *** ErKa has joined #gnucash
18:45:59 *** kode has quit IRC
19:17:01 *** lmat has quit IRC
19:22:46 *** keret has joined #gnucash
19:28:32 *** keret1 has quit IRC
19:29:45 *** fell_ has joined #gnucash
19:37:07 *** fell has quit IRC
19:37:39 *** bozonius has quit IRC
19:39:20 *** ErKa has quit IRC
20:04:36 *** GabrieleV_ has joined #gnucash
20:04:40 *** GabrieleV has quit IRC
20:04:40 *** GabrieleV_ is now known as GabrieleV
20:24:19 *** kode has joined #gnucash
20:34:38 *** kode has quit IRC
21:13:56 *** guest1 has left #gnucash
21:40:09 *** bozonius has joined #gnucash
21:44:21 <bozonius> new problem. I can't seem to get the customer report to show payments against invoices
21:44:33 <bozonius> I was able to do this with another customer, but not this one.
21:44:51 <bozonius> and this customer only has one job on it.
21:45:24 <bozonius> (I should have said "an invoice" not "invoices" in my first sentence, sorry)
21:45:56 <bozonius> and, yes, I used the official ways to post and pay the invoice
21:47:09 <bozonius> the other customer has about 6 jobs on it, and I had no problems posting or invoicing, applying payments, etc
21:47:17 <bozonius> so something is different, but I don't understand what
21:47:36 <bozonius> I even tracked down the ownership of the records by their owner id's and it all looks correct.
21:47:39 <bozonius> (to me)
21:53:53 *** GabrieleV has quit IRC
21:55:00 *** GabrieleV has joined #gnucash
22:13:06 *** kode has joined #gnucash
22:24:13 *** kode has quit IRC
22:39:21 *** O02eg has quit IRC
22:39:44 *** fell_ has quit IRC
23:04:01 *** GabrieleV_ has joined #gnucash
23:04:41 *** GabrieleV has quit IRC
23:04:41 *** GabrieleV_ is now known as GabrieleV
23:15:35 *** keret1 has joined #gnucash
23:19:02 *** GabrieleV_ has joined #gnucash
23:19:42 *** GabrieleV has quit IRC
23:19:42 *** GabrieleV_ is now known as GabrieleV
23:21:49 *** keret has quit IRC
23:39:33 *** GabrieleV_ has joined #gnucash
23:39:42 *** GabrieleV has quit IRC
23:39:42 *** GabrieleV_ is now known as GabrieleV
23:41:59 *** MechtiIde has joined #gnucash
23:58:36 *** gjanssens has joined #gnucash
23:58:37 *** gncbot sets mode: +o gjanssens
23:59:32 *** GabrieleV_ has joined #gnucash
23:59:33 *** GabrieleV has quit IRC
23:59:33 *** GabrieleV_ is now known as GabrieleV
23:59:56 *** Krzysiek_K has joined #gnucash