2018-12-02 GnuCash IRC logs
00:05:10 *** nimish has joined #gnucash
01:05:17 *** fell has quit IRC
01:06:26 *** fell has joined #gnucash
01:09:21 *** gour has joined #gnucash
01:14:30 *** gour has quit IRC
01:14:40 *** gour has joined #gnucash
02:10:07 *** jotrago has joined #gnucash
02:13:01 <blobdata> jrp when you import CSV you need to make shure that the "sign" of the number is proper for the account type, say you import revenues then positive is a revenu , negative goes into rebate"
02:15:10 <blobdata> when you import csv you need to import the transaction and the splits ( one line for transactions following lines for splits. ) you can import tranactions but you then need to have a colum for wich account the transaction is entered to and where is the money transfered to or from ( depending on the sign of the ammount)
02:20:47 <blobdata> say you have make a purchase from "cash" account its normal to find an entry both in your "expense" account and in the "cash" account they are the same transactions just different "views" of it ( if you expand it to show split you will see both "parts" of the transaction in either account
02:22:10 <blobdata> if you are creating a "credit card" make shure its liability type. so that way when you "pay into it" it will reduce the "debt" incured.
02:24:21 <blobdata> in liability case positive numbers "augment" the debt negative numbers reduces the debt...
02:36:21 *** jralls has joined #gnucash
02:38:36 *** chris has quit IRC
02:39:56 <blobdata> jrp , a few flows of how transactions go (money in/out) or (INCrease / DECrease)
02:40:06 <blobdata> Equity(in/out)->Assets(inc/dec)
02:40:06 <blobdata> Income(in)->Assets(inc)
02:40:06 <blobdata> Assets(dec)->Expenses(out)
02:40:06 <blobdata> Liability(inc)->Expenses(out)
02:40:06 <blobdata> Assets->Liability (dec)
02:49:18 *** nimish has quit IRC
02:54:33 *** nimish has joined #gnucash
02:58:01 *** Aussie_matt has quit IRC
03:17:00 *** Aussie_matt has joined #gnucash
03:22:20 *** kapil___ has joined #gnucash
03:35:06 *** chris has joined #gnucash
04:07:28 *** gjanssens has joined #gnucash
04:07:28 *** ChanServ sets mode: +o gjanssens
04:09:24 *** gjanssens has quit IRC
04:25:21 *** gour1 has joined #gnucash
04:25:50 *** gour has quit IRC
04:25:52 *** gour1 is now known as gour
04:26:46 *** gjanssens has joined #gnucash
04:26:46 *** ChanServ sets mode: +o gjanssens
04:27:13 *** gour has quit IRC
04:36:25 *** gour has joined #gnucash
04:39:31 *** gour_ has joined #gnucash
04:54:13 *** gour has quit IRC
04:54:28 *** gour has joined #gnucash
04:59:30 *** fell has quit IRC
05:04:17 *** nimish has quit IRC
05:04:58 *** nimish has joined #gnucash
05:05:12 * chris used to think taxtxf.scm was magical... oh my eyes :-(
05:13:44 *** fabior has joined #gnucash
05:22:39 <Mechtilde> autoconf
05:26:52 *** gour has quit IRC
05:27:01 *** gour has joined #gnucash
06:00:54 *** gour_ has quit IRC
06:01:04 *** gour has quit IRC
06:04:13 *** gour has joined #gnucash
06:05:05 *** gour_ has joined #gnucash
06:08:09 *** gour has quit IRC
06:08:35 *** gour has joined #gnucash
06:09:01 *** gour_ has joined #gnucash
06:13:08 *** gour_ has quit IRC
06:15:16 *** User has joined #gnucash
06:19:41 *** gour has quit IRC
06:19:48 *** gour has joined #gnucash
06:34:22 *** fabior has quit IRC
06:37:59 *** User has quit IRC
06:58:59 <jrp> @blobdata thank you for your input there -- that's useful info on how to set things up properly -- any idea how to sort out any of the 3 messes i've got myself in above though?
06:58:59 <gncbot> jrp: Error: "blobdata" is not a valid command.
07:00:00 <jrp> (apparently @ isn't a valid thing in IRC, it's been about 15 years since I last used IRC)
07:07:22 *** FoxT has quit IRC
07:10:16 <chris> jrp: import from CSV one account at a time.
07:11:20 <jrp> I have been doing it one at a time, and in general, I'm fairly happy with how it's been going, it's just those 3 curve balls that's got me stuck
07:13:13 <chris> well if there's a transfer acct-1 to acct-2, and you import .csv into acct-1 first, you *must* ensure you set the transfer account to acct-2.... so that when you import .csv into acct-2 gnucash can marry up the line into the existing transcation
07:13:40 *** FoxT has joined #gnucash
07:15:18 <jrp> I've got that far, but I found that for some (unclear why only some) transactions, there was no way to tell it which matched which -- literally nowhere i could click during the import that didn't result in the transaction either being silently ignored, or added as a duplicate
07:15:50 <jrp> (nowhere *I* could see anyway -- that's basically the question...)
07:17:02 *** Zerberus has joined #gnucash
07:17:38 <jrp> (note that I have no control of the format of the CSV files -- it's the only format other than dodgy PDFs that my bank will provide -- to be honest I'm grateful they have gone that far)
07:18:25 *** Jimraehl1 has joined #gnucash
07:18:56 *** Jimraehl1 has left #gnucash
07:18:56 <chris> well within the limitations of software this is the only way
07:19:04 <chris> maybe split .csv into separate accounts manually
07:20:21 <jrp> Each account is in a separate file already, with some accounts even being split up as one file per month.
07:21:31 <jrp> I import one account, (manually assigning where the splits go) survey its work (not really having much idea what I'm looking at, though it all looks fine to me)...
07:22:31 <jrp> then import the second account, and observe how some transactions fail to allow any way to let me link them.
07:24:43 <chris> don't know. i suggest import acct-1, then check acct-1 carefully, then move on to acct-2 when acct-1 is confirmed correct
07:24:45 <chris> good luck, gtg
07:26:45 <jrp> on inspecting the CSV files, -- one half of the transaction is actually missing... how in the name of ...what the... going to check online banking...
07:47:16 *** gour1 has joined #gnucash
07:48:47 *** gour has quit IRC
07:59:03 *** boldstripe has joined #gnucash
08:01:52 <jrp> for anyone interested -- that turned out to be an error on my part -- the transaction in fact came from another account, (which I haven't imported yet so the software handled it exactly as it should have.
08:16:08 *** ncv has joined #gnucash
08:22:35 *** Aussie_matt has quit IRC
08:50:59 <warlord> jrp: for opening balance, just change the O-B transaction. There's nothing magic about it.
08:51:38 <warlord> jrp: for the import, make sure you assign the correct destination account during the import process. The fact that it imported into Imbalance means you did not do that. If you assign the correct destination account then the importer will be able to match it properly.
08:53:27 *** oozer has joined #gnucash
09:53:08 *** tienne has joined #gnucash
09:53:08 *** jralls has quit IRC
09:53:37 *** jralls has joined #gnucash
09:59:38 <jrp> Huh, you can edit transactions after creating them -- fantastic, that makes things a whole lot simpler (does it show that I'm a newby...)
10:01:47 <jrp> this is all starting to make sense now... one further detail on that -- during import, if you find some oddball transaction that's going to take a bit of research to work out what it was, does that mean you have to abort the whole import and come back later, or can you do something with that transaction to allow you to return later? I presume that's what the "unbalanced" bit is for?
10:01:47 *** jralls has quit IRC
10:02:21 *** jralls has joined #gnucash
10:03:01 <chris> jrp: I'd leave it as Imbalance during import. after import I go to Imbalance account and try fix the transfer accounts
10:03:51 <chris> jralls still travelling?
10:04:56 <chris> jrp: note from Imbalance account you can't remove transaction from Imbalance account... you have to click JUMP to the other split, and change the transfer account from "Imbalance" to something else
10:04:58 <jrp> cool, that makes sense -- I'm definitely starting to get this. 24 hours ago I didn't actually know what double entry book keeping meant.
10:05:32 <jrp> ooh, good tip, that's a gotcha. Thanks
10:05:43 <chris> once you go double entry you never go back!
10:07:12 <jrp> I dunno -- what I had before worked pretty good most of the time: chuck it all in a bank account and check the balance at the end of the month, hoping it's black... except when it stopped working.
10:07:12 *** jralls has quit IRC
10:07:16 *** jralls has joined #gnucash
10:11:08 *** jralls_ has joined #gnucash
10:11:09 *** jralls has quit IRC
10:12:59 *** boldstripe has quit IRC
10:14:58 <jrp> I'm still left with this mess of already imported data in the credit account where the bank helpfully puts a minus sign in front of all the withdrawals -- my first attempt was to import again as an "update" but with 2 deposit columns, but it won't allow more than one deposit column. there doesn't seem to be any way to tell it there are negatives during import -- and to be honest if I can't get import working well for that acc
10:14:58 <jrp> ount, my whole use case for the gnucash kind goes out the window, which rules out faffing about with editing the csv files before import..
10:25:34 *** chris has quit IRC
10:40:47 *** karelk has joined #gnucash
10:46:26 *** karelk has quit IRC
10:49:41 *** tienne has quit IRC
11:01:44 *** fabior has joined #gnucash
11:18:15 <warlord> jrp: you can leave it as Imbalance --- but then the importer will *learn* that is where it is supposed to go. It does not learn about changes you make after-the-fact. IMHO it's better to import with all knowledge of where stuff goes. Or better yet, don't import.
11:20:25 <jrp> Huh, I understand -- unfortunately, the reason I'm going to the lengths of learning and setting up an accounting package is that I don't have perfect knowledge, if I did, I wouldn't need do all this... I assume it's capable of relearning?
11:20:53 <warlord> only if you go through another import and assign it properly during the import.
11:22:12 <jrp> where is the "learned" data stored anyway? if I delete a whole account of imported data, and start reimporting from scratch (I've got another stuffup and now the current account is out of kilter) will it have retained that learned data?
11:22:50 <jrp> relearning sounds fine then -- unbalanced as a placeholder for "work it out later" sounds good
11:22:53 <warlord> No. The mapping is stored in the account.
11:23:20 <jrp> ok, i understand. is there a shortcut for select all transactions and delete them?
11:24:01 <warlord> No
11:29:36 *** fell has joined #gnucash
11:57:04 *** ncv has quit IRC
12:13:04 *** boldstripe has joined #gnucash
13:03:41 *** oozer has quit IRC
13:08:22 *** fabior has quit IRC
13:23:29 <blobdata> jrp : i suspect your accounting file is new , one thing you can do if you have "importe" all of the transaction is to just export the account structure then import that into a new file
13:29:28 *** ncv has joined #gnucash
13:31:45 <blobdata> when you import transactions, "Account" drop box refer to the account you put the record "in" , a "account" column is also needed so that it knows where the "transfer account" field can be matched to. you will have to set wich column that is by selecting it at the bottom.You then have to match that into "macch import account with gnucash account": this is where gnucash learns where the "money goes to" its going to take your "transfer acc
13:31:45 <blobdata> ount" field and "match" it to an account in gnucash.
13:33:11 <blobdata> this will allow to create the second split in the correct account ( create the transaction into the other account instead of imbalance.)
14:07:27 *** frakturfreak has joined #gnucash
14:11:04 *** Mechtilde has quit IRC
14:11:48 *** AaronRaimist[m] has joined #gnucash
14:12:56 *** boldstripe has quit IRC
14:14:46 *** AaronRaimist[m] has left #gnucash
14:14:49 *** MatrixTraveler[m] has joined #gnucash
14:16:30 *** ncv has quit IRC
14:17:05 *** peter-butler[m] has joined #gnucash
14:17:48 *** ncv has joined #gnucash
14:24:26 *** Mechtilde has joined #gnucash
14:27:58 *** jrp_ has joined #gnucash
14:29:12 *** jrp has quit IRC
14:30:11 *** nimish has quit IRC
14:31:14 *** oozer has joined #gnucash
14:37:23 *** nimish has joined #gnucash
14:39:08 *** nimish has joined #gnucash
15:04:13 *** jrp_ has quit IRC
15:18:26 *** kapil___ has quit IRC
15:25:25 <blobdata> is there a way for me to modify html-text.scm or html-utilities.scm to add a newline(cr/lf) at the end of each html "tag-group" so that the html code is "prettier" ? i am guessing i need to modify each functions for that , just wondring how i should go about it ( in my own install not public source)
15:38:31 <blobdata> found it :P
15:40:01 <blobdata> hum going to have to tweek that a bit ...
15:41:46 *** ncv has quit IRC
16:08:33 *** gour1 has quit IRC
16:18:22 *** Mechtilde has quit IRC
16:20:08 *** jrp has joined #gnucash
16:23:08 *** jrp has quit IRC
16:30:56 *** marusich has joined #gnucash
16:35:34 *** ncv has joined #gnucash
16:40:09 *** gjanssens has quit IRC
16:40:43 *** ncv has quit IRC
17:03:50 *** frakturfreak has quit IRC
17:10:06 *** oozer has quit IRC
17:11:10 *** oozer has joined #gnucash
17:18:49 *** Aussie_matt has joined #gnucash
17:39:24 *** berFt has joined #gnucash
17:47:38 *** wookey has joined #gnucash
17:51:22 *** jrp has joined #gnucash
17:55:30 *** oozer has quit IRC
17:56:32 *** jrp has quit IRC
17:58:22 *** rdswift has joined #gnucash
18:01:14 <rdswift> I have a list of securities that I would like to import to the commodities table. Is there any way to do this? I tried exporting them as a securities list from Quicken and importing the QIF file with zero success.
18:02:05 <rdswift> I can easily script up something in python to format my list to whatever import spec is required.
18:14:17 *** oozer has joined #gnucash
18:28:03 <jralls_> @tell chris Yes, back to the US on Wednesday.
18:28:04 <gncbot> jralls_: The operation succeeded.
18:36:40 <jralls_> rdswift: Commodities are one thing that GnuCash doesn't have an importer for. If you're fluent in Python and are running on Linux you can use the Python bindings to write an importer.
18:37:31 <jralls_> It might be less work to just enter the securities in the securities editor by hand. Depends on how many there are.
18:38:36 <rdswift> Thanks. I'm just throwing together a python script to load them straight into the database. We're talking a couple of hundred, so I don't want to do them by hand. ;-)
18:39:35 *** thadtheman has joined #gnucash
18:50:44 <rdswift> All successfully imported now. Thanks.
19:05:21 *** bertbob has quit IRC
19:11:58 *** bertbob has joined #gnucash
19:21:35 *** jrp has joined #gnucash
19:24:04 *** CDB-Man_ has joined #gnucash
19:24:34 *** jrp has quit IRC
19:25:14 *** CDB-Away_ has joined #gnucash
19:26:11 *** CDB-Away has quit IRC
19:26:29 *** CDB-Man has quit IRC
19:34:49 *** nimish has quit IRC
20:03:36 *** chris has joined #gnucash
20:07:34 <chris> I wish to nuke taxtxf.scm from orbit :-O
20:07:34 <gncbot> chris: Sent 1 hour and 39 minutes ago: <jralls_> Yes, back to the US on Wednesday.
20:08:11 <chris> jralls_ long trip! I'm glad to be back
20:14:01 *** jralls_ is now known as jralls
20:14:55 <jralls> chris: You need to discuss taxtxf with Alex Aycinena.
20:16:59 <chris> that was a figure of speech... there's so much mess there and the hardcoded xaccAccountGetTaxUSCode(account) and friends is not nice to other countries
20:17:13 * chris not touching it
20:17:18 <jralls> chris: It's probably worth noting that taxtxf is mostly useful only for folks who file US income taxes using tax software. There's an modified version for Germany that cstim did some years ago, but I think it hasn't been maintained much.
20:18:30 <jralls> Is there Australian tax software that can read a TXF file with appropriately modified item keys?
20:18:39 <chris> I figure I can probably make an addition to income-gst-statement.scm to feed into UK's mtd bridging software
20:19:06 <chris> I don't think there's TXF for australia
20:19:24 <jralls> Ah, that's totally different from taxtxf.
20:20:06 <chris> yeah - uk's mtd is very easy to generate - copy totals from income-gst-report and make a small tab-separated-values file and it's done
20:20:10 <jralls> The VAT/GST reports are more appropriate starting points.
20:23:57 <chris> the only issue with UK's MTD requirements is that Reverse EC VAT amounts are not currently handled specifically... in my design for GST-report I'd expect EC-VAT accts to be simple ASSET/LIABILTIY accts but MTD requires that they are identified specifically
20:24:20 <chris> i.e. another option to identify reverse-ec vat accounts
20:24:35 <chris> but a basic non-ec mtd report is easy to do
20:48:41 *** marusich has quit IRC
21:00:26 *** CDB-Away_ has quit IRC
21:00:58 *** CDB-Away has joined #gnucash
21:05:34 *** abracada- has joined #gnucash
21:10:38 *** oozer has quit IRC
21:14:20 *** jralls has quit IRC
21:20:02 *** chris has quit IRC
22:22:30 *** jrp has joined #gnucash
22:25:30 *** jrp has quit IRC
23:53:39 *** jrp has joined #gnucash
23:56:40 *** jrp has quit IRC