2015-09-08 GnuCash IRC logs

00:26:54 *** OneM_Industries has quit IRC
00:48:32 *** uXus has quit IRC
00:51:36 *** uXus has joined #gnucash
01:25:12 *** fabior has quit IRC
01:27:39 *** fabior has joined #gnucash
01:33:16 *** nomeata has quit IRC
01:34:14 *** MechtiIde has joined #gnucash
01:38:03 *** O01eg has joined #gnucash
01:38:43 *** fabior has joined #gnucash
01:41:54 *** fabior has quit IRC
01:50:29 *** himaxx has joined #gnucash
01:53:38 *** MarcGuay has quit IRC
02:07:07 *** MarcGuay has joined #gnucash
02:36:10 *** himaxx has quit IRC
02:55:36 *** chazdiezal has joined #gnucash
03:33:59 *** MechtiIde has quit IRC
04:04:08 *** nomeata has joined #gnucash
04:04:35 *** chazdiezal1 has joined #gnucash
04:04:35 *** chazdiezal has quit IRC
04:18:43 *** jimvideo has joined #gnucash
04:21:45 *** OneM_Industries has joined #gnucash
04:21:48 <OneM_Industries> Hello again! For some reaso
04:21:54 <OneM_Industries> n, GNUcash is reading all of our income as expenses.
04:22:11 <OneM_Industries> Is there a way to convert an entire table's worth of records over from an expense to an income?
04:22:25 <OneM_Industries> Also, we had comments/notes in Quicken 2000 that we are not able to find in GNUcash. Has anyone else seen this when switching over?
04:53:28 *** mlncn has quit IRC
05:00:20 *** jimvideo has quit IRC
05:02:59 *** jimvideo has joined #gnucash
05:08:26 <warlord> OneM_Industries: "reading" in what way? Are you using an importer? What exactly is happening? Is it properly increasing/decreasing your Bank account?
05:08:41 *** nomeata has quit IRC
05:09:29 <OneM_Industries> Ok, so when I go into that account, all income is reading as an expense, so if we made $100, it is reading it as if we paid $100 out.
05:09:55 <warlord> OneM_Industries: what do you mean, "when you go into that account"?
05:10:27 <warlord> Please be specific about which account?
05:12:18 <OneM_Industries> I may not be using the right terminology, but if I go into the Customer Invoices account, then all payments to us are recorded as us paying out to them.
05:17:44 <warlord> You've clearly not used a standard gnucash account chart, so.. ab initio..
05:18:11 <warlord> Go to your Chart of Accounts, click once on your Customer Invoices account, then right-click 'Edit Account"... Then tell me the Account TYpe.
05:18:44 <OneM_Industries> Ok, hold on.
05:19:23 <OneM_Industries> Bank, from the look of it.
05:19:50 <warlord> Okay, now close that popup and double-click on the account in the CoA -- it should bring up the account register.
05:20:10 <warlord> Now... for these bad transactions, which column are the amounts in?
18:00:54 <OneM_Industries> They are all in the withdrawals column.
18:01:10 <OneM_Industries> And by that, I mean 15 years of this.
18:01:59 <warlord> where did this data originate?
18:02:37 <OneM_Industries> Quicken 2000, which was imported into Quicken 2004 to update the format, and then into GNUcash.
18:02:54 <warlord> using the qif importer?
18:02:59 *** rubdos has quit IRC
18:03:00 <OneM_Industries> Yes.
18:03:26 <warlord> was it a single qif file for all your accounts?
18:04:16 <OneM_Industries> Yes.
18:04:25 <OneM_Industries> Or, at least it appears to be.
18:04:36 <warlord> hmm...
18:04:44 <OneM_Industries> I have access to all the transactions for everything.
18:04:46 <warlord> the importer is pretty solid
18:06:02 <warlord> i wonder if you have "zero-sum" transactions in there
18:06:16 <OneM_Industries> What are those?
18:07:55 <OneM_Industries> Sorry, I am not an accountant, just tech support for the person using this.
18:09:32 <warlord> it's a multi-split transaction in qif with all splits summing to zero.
18:10:43 <warlord> normally in qif you elide the "current account" split.
18:11:25 <warlord> but there is one case where it can be ambiguous which direction the money flows
18:11:45 <warlord> (i dont recall which -- it's been 10 years since i looked at it)
18:11:48 <warlord> sorry.
18:11:55 <OneM_Industries> Uh..I am afraid I am having difficulty understanding what that means. Basically, the transaction is in multiple places, and all together it adds up to 0?
18:12:21 <warlord> do you understand basic double entry accounting?
18:12:34 <OneM_Industries> Er..no.
18:12:52 <OneM_Industries> I am mainly an OS and hardware guy.
18:13:12 <warlord> okay. i recommend you take the time to go read the gnucash concepts & tutorial guide
18:13:18 <OneM_Industries> Ok.
18:13:59 <warlord> you might want to play with some test files before you try to import 15 years of data.
18:14:10 <OneM_Industries> So, in the meantime, there is not that much that can be done about the reversed transactions?
18:14:18 <OneM_Industries> Yeah, I made sure to have backups.
18:14:54 <warlord> nope, if the data got entered backwards there really is not a good way to fix that.
18:15:17 <warlord> there is no magic "swap debits & credits" function..
18:16:02 <OneM_Industries> Bother. Knowing them, the backwards entering was intentional at the time, "Because that is how we do it." =/
18:16:47 <warlord> :(
18:16:49 <warlord> sorry
18:17:02 <warlord> your other option is just starting over
18:21:20 <OneM_Industries> Well, according to them, that is not an option, so apparently I get to set up some way for them to have a WinXp instance along with Ubuntu.
18:21:32 <OneM_Industries> &%^*ing XP...
18:21:52 *** himaxx has joined #gnucash
18:23:02 <warlord> how much history do they need?
18:23:34 <OneM_Industries> All of it, for now.
18:23:36 <warlord> your other other option is to work with the devs to track down the reversal..
18:23:45 <warlord> Why do they need 15 years of historical data?
18:24:12 <warlord> Hmm.. is *every* transaction reversed? Or only some?
18:24:34 <warlord> QIF is a text format -- you could use something like perl to add (or remove) the "-" from the amounts.
18:26:36 <OneM_Industries> Every single one.
18:29:21 <warlord> okay, then go through the qif and reverse every number
18:32:05 <OneM_Industries> Now it is a new story, apparently come the new financial year, they will switch over. I am not holding my breath.
18:32:52 <warlord> hahaha
18:39:15 *** himaxx has quit IRC
18:50:16 *** ksalman has joined #gnucash
18:52:06 <ksalman> Do folks generally backdate their taxes? for example I paid 2014 taxes in March 2015, and when I run expense report it includes the that entry. Should I back date that to 12/31/2014 or something?
18:58:46 *** himaxx has joined #gnucash
19:10:46 *** mlncn has joined #gnucash
19:17:48 *** himaxx has quit IRC
20:03:54 <jscinoz> Hi there, I'm having an issue in gnucash 2.6.7 where the total values in the "Invoice" row in the summary pane at the bottom of the budget editor are all zero, despite values being entered for income accounts. Teh same issue occurs with a brand new data file, and seems to also occur with version 2.6.6. I logged a bug for it (https://bugzilla.gnome.org/show_bug.cgi?id=754374) but i was wondering how I can go about debugging thsi myself.
20:37:53 <warlord> ksalman: IANAA but you can do whatever your locale laws allow..
20:38:14 <warlord> jscinoz: gdb?
20:55:05 *** gncbot has joined #gnucash
21:10:02 *** gncbot has joined #gnucash
21:47:05 *** mlncn_ has joined #gnucash
21:54:24 <warlord> uh oh...
21:54:31 <warlord> jralls_afk: can you /op gncbot please?
21:54:36 <warlord> er...
21:54:47 <jscinoz> warlord: Ah, there's nothign higher level, like application-level log files that might shed some light on this? If not, I'll see if I can figure out gdb after work this evening; i've not done much c/c++ related stuff before
21:54:48 *** ChanServ sets mode: +qo warlord warlord
21:54:55 *** warlord sets mode: +o gncbot
21:55:43 <warlord> jscinoz: well... you could turn on extra debugging into the tracefile, *IFF* you knew what module might be causing the error.
21:55:49 <warlord> But .... unlikely.
22:08:32 *** nodje has joined #gnucash
22:08:42 <jscinoz> warlord: Ah, I see, I can't say I'm familiar with the codebase at all. I'll see what I can figure out when I'm done with work for the day
22:14:02 <warlord> ok
22:31:02 <jscinoz> Also, completely unrelated, but what's recommended nowadays as to the backend data format, seeing as both the original XML format and a newer sqlite backed one seem to exist now?
22:37:34 <warlord> I use XML. Some others use SQL. Every once in a while we still find corner-cases where the SQL backend fails to store updated data.
22:37:39 <jscinoz> I did notice that the sqlite backend loses precision when storing transactions involving commodities with fractions smaller than 1/100
22:37:40 <warlord> So.... YMMV.
22:37:59 <warlord> Umm... it shouldn't do that..
22:38:03 <jscinoz> Yeah, i gave sqlite a try mainly from curiosity but had to switch back to the XML based one
22:38:18 <warlord> At least it shouldn't lose precision any differently than any other backend.
22:38:34 <jscinoz> Yeah, not sure why. When I looked in the commodity editor it had reset the "Fraction traded" value to 1/100 for all of the commodities I'd added
22:38:48 <warlord> That's.... odd.
22:38:49 <jscinoz> I do wonder if maybe there's something dodgy about my build specifically
22:39:01 <warlord> But that could be related to one of the "data loss" issues i mentioned.
22:39:03 <warlord> Did you report ti?
22:39:23 <jscinoz> I haven't reported that one yet, no. I'll see if it's still reproducible and log a bug if so
22:46:03 <warlord> thanks